APPS.POS_PRODUCT_SERVICE_UTL_PKG dependencies on POS_PRODUCT_SERVICE_REQUESTS

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

1492:
1493:
1494:
1495: l_sql := 'select PS_REQUEST_ID
1496: from POS_PRODUCT_SERVICE_REQUESTS
1497: WHERE '||l_concat_value||'='||''''||l_segcode_val||''''||
1498: 'and MAPPING_ID='||x_mapp_id||
1499: 'AND REQUEST_STATUS =''PENDING'' ';
1500:

Line 1524: from POS_PRODUCT_SERVICE_REQUESTS

1520:
1521:
1522: l_parent_sql := '
1523: select PS_REQUEST_ID
1524: from POS_PRODUCT_SERVICE_REQUESTS
1525: WHERE '||l_concat_value||'='||''''||l_segcode_val||''''||
1526: 'AND '||l_next_seg||' is null '||
1527: 'and MAPPING_ID='||x_mapp_id||
1528: 'AND REQUEST_STATUS =''PENDING''';

Line 1560: from POS_PRODUCT_SERVICE_REQUESTS

1556: where classification_id = x_classification_id)
1557: UNION ALL
1558: (select segment1 , segment2, segment3 , segment4,segment5 , segment6,segment7 , segment8,segment9 , segment10,
1559: segment11 , segment12,segment13 , segment14,segment15 , segment16,segment17 , segment18,segment19 , segment20
1560: from POS_PRODUCT_SERVICE_REQUESTS
1561: where PS_REQUEST_ID = x_classification_id);
1562:
1563: l_rec category_segment_record;
1564:

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

1618: RETURN;
1619: END IF;
1620:
1621: l_query := 'select mcb.category_id from mtl_categories_b mcb, ' ||
1622: ' mtl_category_set_valid_cats mcsvc, pos_product_service_requests ppsr where ' ||
1623: ' (mcb.supplier_enabled_flag is null or mcb.supplier_enabled_flag = ''Y'' or mcb.supplier_enabled_flag = ''y'') ' ||
1624: ' and mcsvc.category_set_id = ' || g_default_po_category_set_id ||
1625: ' and mcb.category_id = mcsvc.category_id ' ||
1626: ' and ppsr.ps_request_id = :1 and (';

Line 1666: SELECT * FROM pos_product_service_requests

1662: x_has_subcategory OUT nocopy VARCHAR2
1663: )
1664: IS
1665: CURSOR l_cur IS
1666: SELECT * FROM pos_product_service_requests
1667: WHERE ps_request_id = p_ps_request_id;
1668: l_rec l_cur%ROWTYPE;
1669: l_segment_values category_segment_record;
1670: l_segment_value pos_product_service_requests.segment1%TYPE;

Line 1670: l_segment_value pos_product_service_requests.segment1%TYPE;

1666: SELECT * FROM pos_product_service_requests
1667: WHERE ps_request_id = p_ps_request_id;
1668: l_rec l_cur%ROWTYPE;
1669: l_segment_values category_segment_record;
1670: l_segment_value pos_product_service_requests.segment1%TYPE;
1671: BEGIN
1672: assert_init();
1673: OPEN l_cur;
1674: FETCH l_cur INTO l_rec;

Line 1779: INSERT INTO POS_PRODUCT_SERVICE_REQUESTS

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: (
1781: PS_REQUEST_ID
1782: , MAPPING_ID
1783: , segment1

Line 1884: UPDATE POS_PRODUCT_SERVICE_REQUESTS

1880: IS
1881: BEGIN
1882:
1883: for i in 1..p_req_id_tbl.COUNT LOOP
1884: UPDATE POS_PRODUCT_SERVICE_REQUESTS
1885: SET request_status = 'DELETED',
1886: last_updated_by = fnd_global.user_id,
1887: last_update_date = Sysdate,
1888: last_update_login = fnd_global.login_id

Line 1905: UPDATE POS_PRODUCT_SERVICE_REQUESTS

1901: IS
1902: BEGIN
1903:
1904: for i in 1..p_req_id_tbl.COUNT LOOP
1905: UPDATE POS_PRODUCT_SERVICE_REQUESTS
1906: SET request_status = 'PENDING',
1907: request_type = 'ADD',
1908: last_updated_by = fnd_global.user_id,
1909: last_update_date = Sysdate,