APPS.QP_PRICE_BOOK_UTIL dependencies on QP_PB_INPUT_HEADERS_TL

Line 2914: DELETE FROM QP_PB_INPUT_HEADERS_TL WHERE PB_INPUT_HEADER_ID in (l_pb_input_header_id, d_pb_input_header_id);

2910: IF SQL%FOUND THEN
2911: COMMIT;
2912: END IF;
2913:
2914: DELETE FROM QP_PB_INPUT_HEADERS_TL WHERE PB_INPUT_HEADER_ID in (l_pb_input_header_id, d_pb_input_header_id);
2915: IF SQL%FOUND THEN
2916: COMMIT;
2917: END IF;
2918:

Line 2951: DELETE FROM QP_PB_INPUT_HEADERS_TL WHERE PB_INPUT_HEADER_ID in (p_pb_input_header_id);

2947: IF SQL%FOUND THEN
2948: COMMIT;
2949: END IF;
2950:
2951: DELETE FROM QP_PB_INPUT_HEADERS_TL WHERE PB_INPUT_HEADER_ID in (p_pb_input_header_id);
2952: IF SQL%FOUND THEN
2953: COMMIT;
2954: END IF;
2955:

Line 3024: INSERT INTO QP_PB_INPUT_HEADERS_TL (

3020: p_pl_agr_bsa_name IN VARCHAR2
3021: )
3022: IS
3023: BEGIN
3024: INSERT INTO QP_PB_INPUT_HEADERS_TL (
3025: PB_INPUT_HEADER_ID,
3026: CREATION_DATE,
3027: CREATED_BY,
3028: LAST_UPDATE_DATE,

Line 3051: FROM QP_PB_INPUT_HEADERS_TL T

3047: WHERE L.INSTALLED_FLAG in ('I', 'B')
3048: AND PBIH.PB_INPUT_HEADER_ID = p_pb_input_header_id
3049: AND NOT EXISTS
3050: (SELECT NULL
3051: FROM QP_PB_INPUT_HEADERS_TL T
3052: WHERE T.PB_INPUT_HEADER_ID = p_pb_input_header_id
3053: AND T.LANGUAGE = L.LANGUAGE_CODE);
3054: END INSERT_PB_TL_RECORDS;
3055:

Line 4253: UPDATE qp_pb_input_headers_tl

4249: pricing_perspective_code = l_full_pb_input_header_rec.pricing_perspective_code,
4250: request_type_code = l_full_pb_input_header_rec.request_type_code
4251: WHERE pb_input_header_id = p_pb_input_header_id;
4252:
4253: UPDATE qp_pb_input_headers_tl
4254: SET pl_agr_bsa_name = l_full_pb_input_header_rec.pl_agr_bsa_name
4255: WHERE pb_input_header_id = p_pb_input_header_id;
4256:
4257: --Select the certain columns of input lines from the full price book