APPS.POS_VENDOR_REG_PKG dependencies on POS_PRODUCT_SERVICE_REQUESTS

Line 712: FROM pos_product_service_requests ppsr

708: )
709: IS
710: CURSOR l_cur IS
711: SELECT ppsr.ps_request_id
712: FROM pos_product_service_requests ppsr
713: , pos_supplier_mappings psm
714: WHERE ppsr.request_type = 'ADD'
715: AND ppsr.request_status = 'PENDING'
716: AND ppsr.mapping_id = psm.mapping_id

Line 1922: l_ps_rec pos_product_service_requests%ROWTYPE;

1918:
1919: l_mapping_id pos_supplier_mappings.mapping_id%TYPE;
1920: l_party_id pos_supplier_registrations.vendor_party_id%TYPE;
1921: l_supplier_type pos_supplier_registrations.supplier_type%TYPE;
1922: l_ps_rec pos_product_service_requests%ROWTYPE;
1923: l_segment pos_product_service_requests.segment1%TYPE;
1924:
1925: l_ps_segment_def fnd_profile_option_values.profile_option_value%TYPE;
1926: l_ps_segment_count NUMBER;

Line 1923: l_segment pos_product_service_requests.segment1%TYPE;

1919: l_mapping_id pos_supplier_mappings.mapping_id%TYPE;
1920: l_party_id pos_supplier_registrations.vendor_party_id%TYPE;
1921: l_supplier_type pos_supplier_registrations.supplier_type%TYPE;
1922: l_ps_rec pos_product_service_requests%ROWTYPE;
1923: l_segment pos_product_service_requests.segment1%TYPE;
1924:
1925: l_ps_segment_def fnd_profile_option_values.profile_option_value%TYPE;
1926: l_ps_segment_count NUMBER;
1927: l_category_set_id NUMBER;

Line 1962: FROM pos_product_service_requests

1958: WHERE mapping_id = p_mapping_id;
1959:
1960: CURSOR c_product_service(p_mapping_id IN NUMBER) IS
1961: SELECT *
1962: FROM pos_product_service_requests
1963: WHERE mapping_id = p_mapping_id;
1964:
1965: CURSOR c_tca_class(p_party_id IN NUMBER) IS
1966: SELECT 'HZ:' || REPLACE(hccr.class_category, ' ', '$')