API - HZ_LOCATIONS

[cralcantara]

Hey guys.

I need guidelines as to maintain the HZ_Locations table via API.

Thanks for the attention.

Carlos A.

[fsitja]

I think the question belongs to the EBS forum ...

I have no experience to answer your question, but in the OTN forum I found something: http://forums.oracle.com/forums/thread. ... dID=678965

[cralcantara]

Thank you, I'll post the post in the right place.

[paulochagas]

Hi friend

What version of your EBS?

[marlonpasquali]

Hello, I have these examples to include and change via API:

to include

Select all

 
            HZ_LOCATION_V2PUB.CREATE_LOCATION 
      										  ( 'T' 
      										  , P_LOCATION_REC 
      										  , X_LOCATION_ID 
      										  , X_RETURN_STATUS 
      										  , X_MSG_COUNT 
      										  , X_MSG_DATA 
      										  ); 
       
      		  dbms_output.put_line('*********** ENDERECO ****************'); 
      		  dbms_output.put_line('x_location_id: '||x_location_id); 
      		  dbms_output.put_line('x_return_status: '||x_return_status); 
      		  dbms_output.put_line('x_msg_count: '||x_msg_count); 
      		  dbms_output.put_line('x_msg_data: '||x_msg_data); 
      		  dbms_output.put_line('***************************'); 
       
       
            IF X_RETURN_STATUS  <> 'S' THEN 
              DBMS_OUTPUT.PUT_LINE ('ERRO CREATE LOCATION'); 
              DBMS_OUTPUT.PUT_LINE('x_msg_data '     || x_msg_data); 
    			    DBMS_OUTPUT.PUT_LINE('x_msg_count ' || x_msg_count ); 
               
      			  VRETURN_STATUS_END    := X_RETURN_STATUS; 
      			  VMSG_COUNT_END        := X_MSG_COUNT; 
      			  VMSG_DATA_END         := X_MSG_DATA; 
       
      		    ROLLBACK; 
              RETURN; 
      		  END IF;

to change

]

[cralcantara]

Marlon Thanks for the aid, it was very useful.

[cralcantara]

Folks.

I found the same way, a little more complete.

Select all

 
DECLARE 
	p_location_rec  HZ_LOCATION_V2PUB.LOCATION_REC_TYPE; 
	x_location_id   NUMBER; 
	x_return_status VARCHAR2(2000); 
	x_msg_count     NUMBER; 
	x_msg_data      VARCHAR2(2000); 
BEGIN 
	p_location_rec.country           := 'US'; 
	p_location_rec.address1          := '300 Oracle Parkway'; 
	p_location_rec.address2          := '13th Floor'; 
	p_location_rec.city              := 'Redwood Shores'; 
	p_location_rec.postal_code       := '94065'; 
	p_location_rec.state             := 'CA'; 
	p_location_rec.created_by_module := 'TCA_EXAMPLE'; 
	hz_location_v2pub.create_location('T', 
	p_location_rec, 
	x_location_id, 
	x_return_status, 
	x_msg_count, 
	x_msg_data);