APPS.AP_PO_LOCN_ASSOCIATION_PKG SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 11

PROCEDURE insert_row ( 	p_location_id 		IN NUMBER,
			p_vendor_id   		IN NUMBER,
			p_vendor_site_id 	IN NUMBER,
			p_last_update_date 	IN DATE,
			p_last_updated_by  	IN NUMBER,
			p_last_update_login 	IN NUMBER,
			p_creation_date 	IN DATE,
			p_created_by 		IN NUMBER,
			p_org_id		IN NUMBER) IS		/* MO Access Control */

l_po_location_exist  VARCHAR2(2);

Line: 30

	select  'Y'
	  into 	l_po_location_exist
	  from 	po_location_associations pla
	 where	pla.location_id = nvl(p_location_id,0);

Line: 48

   UPDATE po_location_associations
      SET vendor_id = p_vendor_id,
	  vendor_site_id = p_vendor_site_id,
	  last_update_date = p_last_update_date,
          last_updated_by = p_last_updated_by,
	  last_update_login = p_last_update_login,
	  org_id	    = p_org_id		--MO Access Control
    WHERE location_id = p_location_id;

Line: 59

   INSERT into po_location_associations(location_id,
					vendor_id,
					vendor_site_id,
					last_update_date,
					last_updated_by,
					last_update_login,
					creation_date,
					created_by,
					org_id)		--MO Access Control
   VALUES (p_location_id, p_vendor_id, p_vendor_site_id, p_last_update_date,
           p_last_updated_by, p_last_update_login, p_creation_date, p_created_by,
	   p_org_id);		--MO Access Control

Line: 78

PROCEDURE update_row ( 	p_location_id 		IN NUMBER,
			p_vendor_id   		IN NUMBER,
			p_vendor_site_id 	IN NUMBER,
			p_last_update_date 	IN DATE,
			p_last_updated_by  	IN NUMBER,
			p_last_update_login 	IN NUMBER,
			p_creation_date 	IN DATE,
			p_created_by 		IN NUMBER,
			p_org_id		IN NUMBER)  IS		--MO Access Control

l_po_location_exist  	VARCHAR2(2);

Line: 97

	select  'Y', nvl(location_id,0)
	  into 	l_site_associated, l_location_id
	  from 	po_location_associations pla
	 where	pla.vendor_site_id = p_vendor_site_id;

Line: 118

	UPDATE 	po_location_associations
           SET 	vendor_id = NULL,
		vendor_site_id = NULL,
      		last_update_date = p_last_update_date,
      		last_updated_by = p_last_updated_by,
	        last_update_login = p_last_update_login,
		org_id		  = p_org_id		--MO Access Control
         WHERE  vendor_site_id = p_vendor_site_id;

Line: 130

	select  'Y'
	  into 	l_po_location_exist
	  from 	po_location_associations pla
	 where	pla.location_id = p_location_id;

Line: 145

   	UPDATE 	po_location_associations
           SET 	vendor_id = p_vendor_id,
		vendor_site_id = p_vendor_site_id,
		last_update_date = p_last_update_date,
		last_updated_by = p_last_updated_by,
	       	last_update_login = p_last_update_login,
		org_id		  = p_org_id	--MO Access Control
         WHERE  location_id = p_location_id;

Line: 154

   	INSERT into po_location_associations (	location_id,
						vendor_id,
						vendor_site_id,
						last_update_date,
						last_updated_by,
						last_update_login,
						creation_date,
						created_by ,
						org_id)		--MO Access Control
      	VALUES (p_location_id, p_vendor_id, p_vendor_site_id, p_last_update_date,
		p_last_updated_by, p_last_update_login, p_creation_date, p_created_by,
		p_org_id);       --MO Access Control