APPS.QP_PRICE_BOOK_PUB dependencies on QP_PB_INPUT_HEADERS_B

Line 95: UPDATE qp_pb_input_headers_b

91: x_price_book_messages_tbl(1).last_update_login := l_login_id;
92: RETURN;
93: END;
94:
95: UPDATE qp_pb_input_headers_b
96: SET publish_existing_pb_flag =
97: l_pb_input_header_rec.publish_existing_pb_flag,
98: dlv_xml_flag = l_pb_input_header_rec.dlv_xml_flag,
99: pub_template_code = l_pb_input_header_rec.pub_template_code,

Line 217: INSERT INTO qp_pb_input_headers_b

213: x_price_book_messages_tbl(1).last_update_login := l_login_id;
214: RETURN;
215: END;
216:
217: INSERT INTO qp_pb_input_headers_b
218: ( pb_input_header_id, customer_context, customer_attribute,
219: customer_attr_value, cust_account_id,
220: dlv_xml_site_id, currency_code, limit_products_by,
221: product_context, product_attribute, product_attr_value,

Line 238: qp_pb_input_headers_b_s.nextval,

234: creation_date, created_by, last_update_date, last_updated_by,
235: last_update_login
236: )
237: VALUES(
238: qp_pb_input_headers_b_s.nextval,
239: l_pb_input_header_rec.customer_context,
240: l_pb_input_header_rec.customer_attribute,
241: l_pb_input_header_rec.customer_attr_value,
242: l_pb_input_header_rec.cust_account_id,

Line 331: INSERT INTO qp_pb_input_headers_b

327:
328: ELSE --Not Delta price book request
329:
330: --Insert the Input criteria into the price book input header tables
331: INSERT INTO qp_pb_input_headers_b
332: (pb_input_header_id, customer_context, customer_attribute,
333: customer_attr_value, cust_account_id,
334: dlv_xml_site_id, currency_code, limit_products_by,
335: product_context, product_attribute, product_attr_value,

Line 352: (qp_pb_input_headers_b_s.nextval,

348: creation_date, created_by, last_update_date, last_updated_by,
349: last_update_login
350: )
351: VALUES
352: (qp_pb_input_headers_b_s.nextval,
353: l_pb_input_header_rec.customer_context,
354: l_pb_input_header_rec.customer_attribute,
355: l_pb_input_header_rec.customer_attr_value,
356: l_pb_input_header_rec.cust_account_id,

Line 459: DELETE FROM qp_pb_input_headers_b

455:
456: DELETE FROM qp_price_book_messages
457: WHERE pb_input_header_id = l_pb_input_header_id;
458:
459: DELETE FROM qp_pb_input_headers_b
460: WHERE pb_input_header_id = l_pb_input_header_id;
461:
462: DELETE FROM qp_pb_input_headers_tl
463: WHERE pb_input_header_id = l_pb_input_header_id;