APPS.POS_SUPP_CLASSIFICATION_PKG dependencies on POS_SUPPLIER_MAPPINGS

Line 53: from pos_supplier_mappings

49: );
50: ELSE
51: select count(mapping_id)
52: into l_count
53: from pos_supplier_mappings
54: where party_id = p_party_id;
55:
56: if ( l_count = 0 ) then
57: insert into pos_supplier_mappings

Line 57: insert into pos_supplier_mappings

53: from pos_supplier_mappings
54: where party_id = p_party_id;
55:
56: if ( l_count = 0 ) then
57: insert into pos_supplier_mappings
58: (
59: mapping_id, party_id , vendor_id ,
60: created_by, creation_date,
61: last_updated_by, last_update_date, last_update_login

Line 73: from pos_supplier_mappings

69: end if;
70:
71: select mapping_id
72: into l_mapping_id
73: from pos_supplier_mappings
74: where party_id = p_party_id;
75:
76: insert into pos_bus_class_reqs
77: (

Line 231: from pos_supplier_mappings

227: where classification_id = p_classification_id;*/
228:
229: select count(mapping_id)
230: into l_count
231: from pos_supplier_mappings
232: where party_id = p_party_id;
233:
234: if ( l_count = 0 ) then
235: insert into pos_supplier_mappings

Line 235: insert into pos_supplier_mappings

231: from pos_supplier_mappings
232: where party_id = p_party_id;
233:
234: if ( l_count = 0 ) then
235: insert into pos_supplier_mappings
236: (
237: mapping_id, party_id , vendor_id ,
238: created_by, creation_date,
239: last_updated_by, last_update_date, last_update_login

Line 251: from pos_supplier_mappings

247: end if;
248:
249: select mapping_id
250: into l_mapping_id
251: from pos_supplier_mappings
252: where party_id = p_party_id;
253:
254: -- bug 11803346 - rejecting all other existing pending requests for the same lookup code
255: UPDATE pos_bus_class_reqs

Line 328: FROM pos_supplier_mappings psm

324:
325: IF (p_req_id_tbl(i) IS NOT NULL) THEN
326:
327: SELECT mapping_id INTO l_map_id
328: FROM pos_supplier_mappings psm
329: WHERE psm.party_id = p_party_id;
330:
331: SELECT request_status INTO req_status
332: FROM pos_bus_class_reqs

Line 364: pos_supplier_mappings psm

360: AND party_site_id IS NULL
361: AND vendor_site_id IS NULL
362: AND classification_id not in ( select classification_id
363: from pos_bus_class_reqs pbcr,
364: pos_supplier_mappings psm
365: where psm.party_id = p_party_id
366: and psm.mapping_id = pbcr.mapping_id
367: and pbcr.request_status = 'PENDING'
368: and pbcr.request_type in ( 'ADD', 'UPDATE' )

Line 397: FROM pos_bus_class_reqs pbcr, pos_supplier_mappings psm

393:
394: UNION
395:
396: SELECT lookup_code
397: FROM pos_bus_class_reqs pbcr, pos_supplier_mappings psm
398: WHERE psm.party_id = p_party_id
399: AND psm.mapping_id = pbcr.mapping_id
400: AND pbcr.lookup_type = p_lkp_type_tbl(i)
401: AND pbcr.lookup_code = p_lkp_code_tbl(i)