APPS.POS_PRODUCT_SERVICE_UTL_PKG dependencies on POS_SUPPLIER_MAPPINGS

Line 1231: from POS_PRODUCT_SERVICE_REQUESTS psr , POS_SUPPLIER_MAPPINGS pmapp

1227: 'AND status <> '||''''||'X'||''''||
1228: 'AND vendor_id = '||x_vendor_id||
1229: 'union all
1230: select PS_REQUEST_ID classification_id
1231: from POS_PRODUCT_SERVICE_REQUESTS psr , POS_SUPPLIER_MAPPINGS pmapp
1232: WHERE '||l_concat_value||'='||''''||l_segcode_val||''''||
1233: 'and pmapp.mapping_id = psr.MAPPING_ID
1234: AND (psr.REQUEST_STATUS =''PENDING'' or psr.REQUEST_STATUS =''REJECTED'')
1235: AND pmapp.vendor_id = '||x_vendor_id ;

Line 1265: from POS_PRODUCT_SERVICE_REQUESTS psr , POS_SUPPLIER_MAPPINGS pmapp

1261: 'AND status <> '||''''||'X'||''''||
1262: 'AND vendor_id = '||x_vendor_id||
1263: 'union all
1264: select PS_REQUEST_ID classification_id
1265: from POS_PRODUCT_SERVICE_REQUESTS psr , POS_SUPPLIER_MAPPINGS pmapp
1266: WHERE '||l_concat_value||'='||''''||l_segcode_val||''''||
1267: 'AND '||l_next_seg||' is null '||
1268: 'and pmapp.mapping_id = psr.MAPPING_ID
1269: AND (psr.REQUEST_STATUS ='||''''||'PENDING'||''''|| 'or psr.REQUEST_STATUS ='||''''|| 'REJECTED'||''''||')

Line 1557: * insert a record into the pos_supplier_mappings table for corresponding vendor id and party id

1553: BEGIN
1554:
1555: /*
1556: * If the count of pos_suppliers mapping record of the party id is zero, then
1557: * insert a record into the pos_supplier_mappings table for corresponding vendor id and party id
1558: * else, use the existing mapping_id value of the party id to create a Pending Product and
1559: * Service Request.
1560: * Please refer the bug 7374266 for more information.
1561: */

Line 1570: FROM pos_supplier_mappings

1566: WHERE vendor_id = p_vendor_id;
1567:
1568: SELECT COUNT(mapping_id)
1569: INTO l_count
1570: FROM pos_supplier_mappings
1571: WHERE party_id = l_party_id;
1572:
1573: IF ( l_count = 0 ) then
1574: INSERT INTO pos_supplier_mappings

Line 1574: INSERT INTO pos_supplier_mappings

1570: FROM pos_supplier_mappings
1571: WHERE party_id = l_party_id;
1572:
1573: IF ( l_count = 0 ) then
1574: INSERT INTO pos_supplier_mappings
1575: (
1576: mapping_id, party_id , vendor_id ,
1577: created_by, creation_date,
1578: last_updated_by, last_update_date, last_update_login

Line 1590: from Pos_supplier_mappings

1586: END IF;
1587:
1588: select mapping_id
1589: into l_mapping_id
1590: from Pos_supplier_mappings
1591: where vendor_id = p_vendor_id ;
1592:
1593: INSERT INTO POS_PRODUCT_SERVICE_REQUESTS
1594: (