APPS.POS_PRODUCT_SERVICE_UTL_PKG dependencies on POS_SUPPLIER_MAPPINGS

Line 1402: from POS_PRODUCT_SERVICE_REQUESTS psr , POS_SUPPLIER_MAPPINGS pmapp

1398: 'AND status <> '||''''||'X'||''''||
1399: 'AND vendor_id = '||x_vendor_id||
1400: 'union all
1401: select PS_REQUEST_ID classification_id
1402: from POS_PRODUCT_SERVICE_REQUESTS psr , POS_SUPPLIER_MAPPINGS pmapp
1403: WHERE '||l_concat_value||'='||''''||l_segcode_val||''''||
1404: 'and pmapp.mapping_id = psr.MAPPING_ID
1405: AND (psr.REQUEST_STATUS =''PENDING'' or psr.REQUEST_STATUS =''REJECTED'')
1406: AND pmapp.vendor_id = '||x_vendor_id ;

Line 1436: from POS_PRODUCT_SERVICE_REQUESTS psr , POS_SUPPLIER_MAPPINGS pmapp

1432: 'AND status <> '||''''||'X'||''''||
1433: 'AND vendor_id = '||x_vendor_id||
1434: 'union all
1435: select PS_REQUEST_ID classification_id
1436: from POS_PRODUCT_SERVICE_REQUESTS psr , POS_SUPPLIER_MAPPINGS pmapp
1437: WHERE '||l_concat_value||'='||''''||l_segcode_val||''''||
1438: 'AND '||l_next_seg||' is null '||
1439: 'and pmapp.mapping_id = psr.MAPPING_ID
1440: AND (psr.REQUEST_STATUS ='||''''||'PENDING'||''''|| 'or psr.REQUEST_STATUS ='||''''|| 'REJECTED'||''''||')

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

1739: BEGIN
1740:
1741: /*
1742: * If the count of pos_suppliers mapping record of the party id is zero, then
1743: * insert a record into the pos_supplier_mappings table for corresponding vendor id and party id
1744: * else, use the existing mapping_id value of the party id to create a Pending Product and
1745: * Service Request.
1746: * Please refer the bug 7374266 for more information.
1747: */

Line 1756: FROM pos_supplier_mappings

1752: WHERE vendor_id = p_vendor_id;
1753:
1754: SELECT COUNT(mapping_id)
1755: INTO l_count
1756: FROM pos_supplier_mappings
1757: WHERE party_id = l_party_id;
1758:
1759: IF ( l_count = 0 ) then
1760: INSERT INTO pos_supplier_mappings

Line 1760: INSERT INTO pos_supplier_mappings

1756: FROM pos_supplier_mappings
1757: WHERE party_id = l_party_id;
1758:
1759: IF ( l_count = 0 ) then
1760: INSERT INTO pos_supplier_mappings
1761: (
1762: mapping_id, party_id , vendor_id ,
1763: created_by, creation_date,
1764: last_updated_by, last_update_date, last_update_login

Line 1776: from Pos_supplier_mappings

1772: END IF;
1773:
1774: select mapping_id
1775: into l_mapping_id
1776: from Pos_supplier_mappings
1777: where vendor_id = p_vendor_id ;
1778:
1779: INSERT INTO POS_PRODUCT_SERVICE_REQUESTS
1780: (