APPS.POS_PRODUCT_SERVICE_UTL_PKG dependencies on POS_PRODUCT_SERVICE_REQUESTS

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 1320: from POS_PRODUCT_SERVICE_REQUESTS

1316:
1317:
1318:
1319: l_sql := 'select PS_REQUEST_ID
1320: from POS_PRODUCT_SERVICE_REQUESTS
1321: WHERE '||l_concat_value||'='||''''||l_segcode_val||''''||
1322: 'and MAPPING_ID='||x_mapp_id||
1323: 'AND REQUEST_STATUS =''PENDING'' ';
1324:

Line 1348: from POS_PRODUCT_SERVICE_REQUESTS

1344:
1345:
1346: l_parent_sql := '
1347: select PS_REQUEST_ID
1348: from POS_PRODUCT_SERVICE_REQUESTS
1349: WHERE '||l_concat_value||'='||''''||l_segcode_val||''''||
1350: 'AND '||l_next_seg||' is null '||
1351: 'and MAPPING_ID='||x_mapp_id||
1352: 'AND REQUEST_STATUS =''PENDING''';

Line 1384: from POS_PRODUCT_SERVICE_REQUESTS

1380: where classification_id = x_classification_id)
1381: UNION ALL
1382: (select segment1 , segment2, segment3 , segment4,segment5 , segment6,segment7 , segment8,segment9 , segment10,
1383: segment11 , segment12,segment13 , segment14,segment15 , segment16,segment17 , segment18,segment19 , segment20
1384: from POS_PRODUCT_SERVICE_REQUESTS
1385: where PS_REQUEST_ID = x_classification_id);
1386:
1387: l_rec category_segment_record;
1388:

Line 1446: ' mtl_category_set_valid_cats mcsvc, pos_product_service_requests ppsr where ' ||

1442: RETURN;
1443: END IF;
1444:
1445: l_query := 'select mcb.category_id from mtl_categories_b mcb, ' ||
1446: ' mtl_category_set_valid_cats mcsvc, pos_product_service_requests ppsr where ' ||
1447: ' (mcb.supplier_enabled_flag is null or mcb.supplier_enabled_flag = ''Y'' or mcb.supplier_enabled_flag = ''y'') ' ||
1448: ' and mcsvc.category_set_id = ' || g_default_po_category_set_id ||
1449: ' and mcb.category_id = mcsvc.category_id ' ||
1450: ' and ppsr.ps_request_id = :1 and (';

Line 1480: SELECT * FROM pos_product_service_requests

1476: x_has_subcategory OUT nocopy VARCHAR2
1477: )
1478: IS
1479: CURSOR l_cur IS
1480: SELECT * FROM pos_product_service_requests
1481: WHERE ps_request_id = p_ps_request_id;
1482: l_rec l_cur%ROWTYPE;
1483: l_segment_values category_segment_record;
1484: l_segment_value pos_product_service_requests.segment1%TYPE;

Line 1484: l_segment_value pos_product_service_requests.segment1%TYPE;

1480: SELECT * FROM pos_product_service_requests
1481: WHERE ps_request_id = p_ps_request_id;
1482: l_rec l_cur%ROWTYPE;
1483: l_segment_values category_segment_record;
1484: l_segment_value pos_product_service_requests.segment1%TYPE;
1485: BEGIN
1486: assert_init();
1487: OPEN l_cur;
1488: FETCH l_cur INTO l_rec;

Line 1593: INSERT INTO POS_PRODUCT_SERVICE_REQUESTS

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: (
1595: PS_REQUEST_ID
1596: , MAPPING_ID
1597: , segment1

Line 1698: UPDATE POS_PRODUCT_SERVICE_REQUESTS

1694: IS
1695: BEGIN
1696:
1697: for i in 1..p_req_id_tbl.COUNT LOOP
1698: UPDATE POS_PRODUCT_SERVICE_REQUESTS
1699: SET request_status = 'DELETED',
1700: last_updated_by = fnd_global.user_id,
1701: last_update_date = Sysdate,
1702: last_update_login = fnd_global.login_id

Line 1719: UPDATE POS_PRODUCT_SERVICE_REQUESTS

1715: IS
1716: BEGIN
1717:
1718: for i in 1..p_req_id_tbl.COUNT LOOP
1719: UPDATE POS_PRODUCT_SERVICE_REQUESTS
1720: SET request_status = 'PENDING',
1721: request_type = 'ADD',
1722: last_updated_by = fnd_global.user_id,
1723: last_update_date = Sysdate,