APPS.QP_PRICE_BOOK_UTIL dependencies on QP_PB_INPUT_HEADERS_B

Line 633: UPDATE qp_pb_input_headers_b

629: RETURN;
630: END IF;
631:
632: --Update the input_header table with the request_type_code
633: UPDATE qp_pb_input_headers_b
634: SET request_type_code = l_request_type_code
635: WHERE pb_input_header_id = p_pb_input_header_rec.pb_input_header_id;
636:
637: BEGIN

Line 2919: DELETE FROM QP_PB_INPUT_HEADERS_B 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:
2919: DELETE FROM QP_PB_INPUT_HEADERS_B WHERE PB_INPUT_HEADER_ID in (l_pb_input_header_id, d_pb_input_header_id);
2920: IF SQL%FOUND THEN
2921: COMMIT;
2922: END IF;
2923:

Line 2956: DELETE FROM QP_PB_INPUT_HEADERS_B WHERE PB_INPUT_HEADER_ID in (p_pb_input_header_id);

2952: IF SQL%FOUND THEN
2953: COMMIT;
2954: END IF;
2955:
2956: DELETE FROM QP_PB_INPUT_HEADERS_B WHERE PB_INPUT_HEADER_ID in (p_pb_input_header_id);
2957: IF SQL%FOUND THEN
2958: COMMIT;
2959: END IF;
2960: */

Line 3046: FROM FND_LANGUAGES L, QP_PB_INPUT_HEADERS_B PBIH

3042: p_price_book_name,
3043: p_pl_agr_bsa_name,
3044: L.LANGUAGE_CODE,
3045: userenv('LANG')
3046: FROM FND_LANGUAGES L, QP_PB_INPUT_HEADERS_B PBIH
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

Line 3612: FROM qp_price_book_headers_b p, qp_pb_input_headers_b i

3608: msgs_sent_flag := FALSE;
3609:
3610: SELECT i.customer_attr_value, i.DLV_XML_SITE_ID
3611: INTO party_id, party_site_id
3612: FROM qp_price_book_headers_b p, qp_pb_input_headers_b i
3613: WHERE p.price_book_header_id = p_price_book_header_id
3614: AND p.pb_input_header_id = i.pb_input_header_id;
3615:
3616: IF (l_debug = FND_API.G_TRUE) THEN

Line 4143: UPDATE QP_PB_INPUT_HEADERS_B

4139: AND customer_attr_value = p_customer_attr_value
4140: --AND effective_date = p_effective_date
4141: AND price_book_type_code = p_price_book_type_code;
4142:
4143: UPDATE QP_PB_INPUT_HEADERS_B
4144: SET PUB_TEMPLATE_CODE = NULL,
4145: PUB_LANGUAGE = NULL,
4146: PUB_TERRITORY = NULL,
4147: PUB_OUTPUT_DOCUMENT_TYPE = NULL,

Line 4210: UPDATE QP_PB_INPUT_HEADERS_B

4206: IF l_pb_input_header_rec.cust_account_id is null THEN
4207: DEFAULT_CUST_ACCOUNT_ID(l_pb_input_header_rec.customer_attr_value,
4208: l_cust_account_id);
4209: IF l_cust_account_id is not null THEN
4210: UPDATE QP_PB_INPUT_HEADERS_B
4211: SET CUST_ACCOUNT_ID = l_cust_account_id
4212: WHERE pb_input_header_id = p_pb_input_header_id;
4213: END IF;
4214: END IF;

Line 4235: UPDATE qp_pb_input_headers_b

4231: x_return_text := FND_MESSAGE.GET;
4232: RETURN;
4233: END;
4234:
4235: UPDATE qp_pb_input_headers_b
4236: SET customer_context = l_full_pb_input_header_rec.customer_context,
4237: customer_attribute = l_full_pb_input_header_rec.customer_attribute,
4238: customer_attr_value = l_full_pb_input_header_rec.customer_attr_value,
4239: cust_account_id = l_full_pb_input_header_rec.cust_account_id,

Line 4320: UPDATE QP_PB_INPUT_HEADERS_B

4316: x_return_text IN OUT NOCOPY VARCHAR2
4317: )
4318: IS
4319: BEGIN
4320: UPDATE QP_PB_INPUT_HEADERS_B
4321: SET CUST_ACCOUNT_ID = p_cust_account_id
4322: WHERE pb_input_header_id = p_pb_input_header_id;
4323: x_return_status := FND_API.G_RET_STS_SUCCESS;
4324: x_return_text := '';