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:
255: insert into pos_bus_class_reqs

Line 322: FROM pos_supplier_mappings psm

318:
319: IF (p_req_id_tbl(i) IS NOT NULL) THEN
320:
321: SELECT mapping_id INTO l_map_id
322: FROM pos_supplier_mappings psm
323: WHERE psm.party_id = p_party_id;
324:
325: SELECT request_status INTO req_status
326: FROM pos_bus_class_reqs

Line 355: pos_supplier_mappings psm

351: AND status='A'
352: AND class_status = 'APPROVED'
353: AND classification_id not in ( select classification_id
354: from pos_bus_class_reqs pbcr,
355: pos_supplier_mappings psm
356: where psm.party_id = p_party_id
357: and psm.mapping_id = pbcr.mapping_id
358: and pbcr.request_status = 'PENDING'
359: and pbcr.request_type in ( 'ADD', 'UPDATE' )

Line 386: FROM pos_bus_class_reqs pbcr, pos_supplier_mappings psm

382:
383: UNION
384:
385: SELECT lookup_code
386: FROM pos_bus_class_reqs pbcr, pos_supplier_mappings psm
387: WHERE psm.party_id = p_party_id
388: AND psm.mapping_id = pbcr.mapping_id
389: AND pbcr.lookup_type = p_lkp_type_tbl(i)
390: AND pbcr.lookup_code = p_lkp_code_tbl(i)