APPS.PON_ATTR_MAPPING dependencies on POS_PRODUCT_SERVICE_UTL_PKG

Line 82: SELECT 'PS:' || pos_product_service_utl_pkg.get_concat_code(classification_id) as code

78: AND pcard_site_flag = 'Y';
79:
80: CURSOR ps_cursor(x_vendor_id NUMBER)
81: IS
82: SELECT 'PS:' || pos_product_service_utl_pkg.get_concat_code(classification_id) as code
83: FROM pos_sup_products_services
84: WHERE vendor_id = x_vendor_id;
85:
86: CURSOR hz_cursor(x_party_id NUMBER)

Line 156: pos_product_service_utl_pkg.get_product_meta_data(segment_definition, segment_count, po_category_set_id, x_delimiter);

152: EXIT;
153: END IF;
154: END LOOP;
155: WHEN 'PS' THEN
156: pos_product_service_utl_pkg.get_product_meta_data(segment_definition, segment_count, po_category_set_id, x_delimiter);
157: FOR ps_rec IN ps_cursor(p_vendor_id) LOOP
158: IF (class_code = ps_rec.code) THEN
159: return_code := class_code;
160: EXIT;