APPS.ARP_CLAS_PKG dependencies on PO_LOCATION_ASSOCIATIONS

Line 34: from po_location_associations_all

30: --
31: begin
32: select count(1)
33: into dummy
34: from po_location_associations_all
35: where location_id = p_inventory_location_id
36: and org_id = l_org_id;
37: --
38: if ( dummy >= 1 ) then

Line 57: from po_location_associations_all

53: --
54: begin
55: select count(1)
56: into dummy
57: from po_location_associations_all
58: where location_id = p_inventory_location_id;
59: --
60: if ( dummy >= 1 ) then
61: fnd_message.set_name('AR','AR_CUST_DUP_INTERNAL_LOCATION');

Line 73: -- This procedure inserts rows into the table po_location_associations

69: -- PROCEDURE
70: -- insert_po_loc_associations
71: --
72: -- DESCRIPTION
73: -- This procedure inserts rows into the table po_location_associations
74: -- This table is simple implements a foreign key from ra_site_use.site_use_id
75: -- to hr_locations.
76: --
77: -- SCOPE - PUBLIC

Line 136: insert into po_location_associations (

132: WHEN OTHERS
133: THEN
134: RAISE FND_API.G_EXC_ERROR;
135: END;
136: insert into po_location_associations (
137: location_id,
138: last_update_date,
139: last_updated_by,
140: last_update_login,

Line 177: insert into po_location_associations (

173: begin
174: --
175: check_unique_inv_location( p_inventory_location_id => p_inventory_location_id );
176: --
177: insert into po_location_associations (
178: location_id,
179: last_update_date,
180: last_updated_by,
181: last_update_login,

Line 231: from po_location_associations

227: organization_id is same*/
228: begin
229: select location_id,organization_id
230: into l_inventory_location_id,l_inventory_organization_id
231: from po_location_associations
232: where site_use_id = p_site_use_id;
233: exception
234: when NO_DATA_FOUND then
235: null;

Line 264: delete from po_location_associations

260: x_msg_data := 'AR_CUST_INT_REQ_LINES_EXIST';
261: return;
262: end if;
263: --
264: delete from po_location_associations
265: where site_use_id = p_site_use_id;
266: --
267: end if;
268: --

Line 308: from po_location_associations

304: organization_id is same*/
305: begin
306: select location_id,organization_id
307: into l_inventory_location_id,l_inventory_organization_id
308: from po_location_associations
309: where site_use_id = p_site_use_id;
310: exception
311: when NO_DATA_FOUND then
312: null;

Line 331: delete from po_location_associations

327: fnd_message.set_name('AR','AR_CUST_INT_REQ_LINES_EXIST');
328: app_exception.raise_exception;
329: end if;
330: --
331: delete from po_location_associations
332: where site_use_id = p_site_use_id;
333: --
334: end if;
335: --