APPS.QP_PRICE_BOOK_PUB dependencies on QP_PB_INPUT_HEADERS_TL

Line 117: UPDATE qp_pb_input_headers_tl

113: last_updated_by = l_user_id,
114: last_update_login = l_login_id
115: WHERE pb_input_header_id = l_pb_input_header_id;
116:
117: UPDATE qp_pb_input_headers_tl
118: SET pub_template_name = l_pb_input_header_rec.pub_template_name,
119: last_update_date = l_sysdate,
120: last_updated_by = l_user_id,
121: last_update_login = l_login_id

Line 277: INSERT INTO qp_pb_input_headers_tl

273: l_sysdate, l_user_id, l_sysdate, l_user_id, l_login_id)
274: RETURNING pb_input_header_id
275: INTO l_pb_input_header_id;
276:
277: INSERT INTO qp_pb_input_headers_tl
278: (pb_input_header_id, price_book_name, pl_agr_bsa_name,
279: pub_template_name, creation_date, created_by,
280: last_update_date, last_updated_by,
281: last_update_login, language, source_lang

Line 294: FROM qp_pb_input_headers_tl t

290: userenv('LANG')
291: FROM fnd_languages l
292: WHERE l.installed_flag IN ('I', 'B')
293: AND NOT EXISTS (SELECT NULL
294: FROM qp_pb_input_headers_tl t
295: WHERE t.pb_input_header_id =
296: l_pb_input_header_id
297: AND t.language = l.language_code);
298:

Line 391: INSERT INTO qp_pb_input_headers_tl

387: l_sysdate, l_user_id, l_sysdate, l_user_id, l_login_id
388: ) RETURNING pb_input_header_id INTO
389: l_pb_input_header_id;
390:
391: INSERT INTO qp_pb_input_headers_tl
392: (pb_input_header_id, price_book_name, pl_agr_bsa_name,
393: pub_template_name, creation_date, created_by,
394: last_update_date, last_updated_by,
395: last_update_login, language, source_lang

Line 408: FROM qp_pb_input_headers_tl t

404: userenv('LANG')
405: FROM fnd_languages l
406: WHERE l.installed_flag IN ('I', 'B')
407: AND NOT EXISTS (SELECT NULL
408: FROM qp_pb_input_headers_tl t
409: WHERE t.pb_input_header_id =
410: l_pb_input_header_id
411: AND t.language = l.language_code);
412:

Line 462: DELETE FROM qp_pb_input_headers_tl

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;
464:
465: DELETE FROM qp_pb_input_lines
466: WHERE pb_input_header_id = l_pb_input_header_id;