eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.QP_PRICE_BOOK_PUB dependencies on QP_PB_INPUT_LINES

Line 305: FROM qp_pb_input_lines

301: BEGIN
302: SELECT context, attribute, attribute_value, attribute_type
303: BULK COLLECT INTO l_context_tbl, l_attribute_tbl,
304: l_attribute_value_tbl, l_attribute_type_tbl
305: FROM qp_pb_input_lines
306: WHERE pb_input_header_id = l_full_pb_input_header_id;
307: EXCEPTION
308: WHEN OTHERS THEN
309: NULL;

Line 314: INSERT INTO qp_pb_input_lines

310: END;
311:
312: --Insert the Input criteria into input lines tables
313: FORALL k IN l_context_tbl.FIRST..l_context_tbl.LAST
314: INSERT INTO qp_pb_input_lines
315: (pb_input_line_id, pb_input_header_id,
316: context, attribute, attribute_value,
317: attribute_type, creation_date, created_by, last_update_date,
318: last_updated_by, last_update_login

Line 321: (qp_pb_input_lines_s.nextval,

317: attribute_type, creation_date, created_by, last_update_date,
318: last_updated_by, last_update_login
319: )
320: VALUES
321: (qp_pb_input_lines_s.nextval,
322: l_pb_input_header_id,
323: l_context_tbl(k), l_attribute_tbl(k),
324: l_attribute_value_tbl(k), l_attribute_type_tbl(k),
325: l_sysdate, l_user_id, l_sysdate, l_user_id, l_login_id

Line 426: INSERT INTO qp_pb_input_lines

422: END LOOP;
423: END IF; --If p_pb_input_lines_tbl.count > 0
424:
425: FORALL i IN l_context_tbl.FIRST..l_context_tbl.LAST
426: INSERT INTO qp_pb_input_lines
427: (pb_input_line_id, pb_input_header_id,
428: context, attribute, attribute_value,
429: attribute_type, creation_date, created_by, last_update_date,
430: last_updated_by, last_update_login

Line 433: (qp_pb_input_lines_s.nextval, l_pb_input_header_id,

429: attribute_type, creation_date, created_by, last_update_date,
430: last_updated_by, last_update_login
431: )
432: VALUES
433: (qp_pb_input_lines_s.nextval, l_pb_input_header_id,
434: l_context_tbl(i), l_attribute_tbl(i),
435: l_attribute_value_tbl(i),
436: l_attribute_type_tbl(i),
437: l_sysdate, l_user_id, l_sysdate, l_user_id, l_login_id

Line 465: DELETE FROM qp_pb_input_lines

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;
467:
468: END IF;
469: