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.PO_PDOI_ATTR_PROCESS_PVT dependencies on PO_SESSION_GT

Line 220: -- ket value used to identify records in po_session_gt table

216: d_api_name CONSTANT VARCHAR2(30) := 'check_attr_actions';
217: d_module CONSTANT VARCHAR2(255) := d_pkg_name || d_api_name || '.';
218: d_position NUMBER;
219:
220: -- ket value used to identify records in po_session_gt table
221: l_key PO_SESSION_GT.key%TYPE;
222:
223: -- variables to save result read from po_session_gt
224: l_index_tbl PO_TBL_NUMBER;

Line 221: l_key PO_SESSION_GT.key%TYPE;

217: d_module CONSTANT VARCHAR2(255) := d_pkg_name || d_api_name || '.';
218: d_position NUMBER;
219:
220: -- ket value used to identify records in po_session_gt table
221: l_key PO_SESSION_GT.key%TYPE;
222:
223: -- variables to save result read from po_session_gt
224: l_index_tbl PO_TBL_NUMBER;
225: l_result_tbl PO_TBL_NUMBER;

Line 223: -- variables to save result read from po_session_gt

219:
220: -- ket value used to identify records in po_session_gt table
221: l_key PO_SESSION_GT.key%TYPE;
222:
223: -- variables to save result read from po_session_gt
224: l_index_tbl PO_TBL_NUMBER;
225: l_result_tbl PO_TBL_NUMBER;
226: l_source_tbl PO_TBL_VARCHAR5; -- values can be 'draft' or 'txn'
227:

Line 254: INSERT INTO po_session_gt(key, num1, num2, char1)

250: l_key := PO_CORE_S.get_session_gt_nextval;
251:
252: -- first check whether record exists in draft table
253: FORALL i IN INDICES OF x_processing_row_tbl
254: INSERT INTO po_session_gt(key, num1, num2, char1)
255: SELECT l_key,
256: x_processing_row_tbl(i),
257: attribute_values_id,
258: 'DRAFT'

Line 273: INSERT INTO po_session_gt(key, num1, num2, char1)

269:
270: d_position := 20;
271:
272: FORALL i IN INDICES OF x_processing_row_tbl
273: INSERT INTO po_session_gt(key, num1, num2, char1)
274: SELECT l_key,
275: x_processing_row_tbl(i),
276: attribute_values_id,
277: 'TXN'

Line 283: -- retrieve result from po_session_gt table

279: WHERE po_line_id = x_attr_values.ln_po_line_id_tbl(i)
280: AND org_id = x_attr_values.org_id_tbl(i);
281: END IF;
282:
283: -- retrieve result from po_session_gt table
284: DELETE FROM po_session_gt
285: WHERE key = l_key
286: RETURNING num1, num2, char1 BULK COLLECT INTO
287: l_index_tbl, l_result_tbl, l_source_tbl;

Line 284: DELETE FROM po_session_gt

280: AND org_id = x_attr_values.org_id_tbl(i);
281: END IF;
282:
283: -- retrieve result from po_session_gt table
284: DELETE FROM po_session_gt
285: WHERE key = l_key
286: RETURNING num1, num2, char1 BULK COLLECT INTO
287: l_index_tbl, l_result_tbl, l_source_tbl;
288:

Line 596: -- ket value used to identify records in po_session_gt table

592: d_api_name CONSTANT VARCHAR2(30) := 'check_attr_tlp_actions';
593: d_module CONSTANT VARCHAR2(255) := d_pkg_name || d_api_name || '.';
594: d_position NUMBER;
595:
596: -- ket value used to identify records in po_session_gt table
597: l_key PO_SESSION_GT.key%TYPE;
598:
599: -- variables to save result read from po_session_gt
600: l_index_tbl PO_TBL_NUMBER;

Line 597: l_key PO_SESSION_GT.key%TYPE;

593: d_module CONSTANT VARCHAR2(255) := d_pkg_name || d_api_name || '.';
594: d_position NUMBER;
595:
596: -- ket value used to identify records in po_session_gt table
597: l_key PO_SESSION_GT.key%TYPE;
598:
599: -- variables to save result read from po_session_gt
600: l_index_tbl PO_TBL_NUMBER;
601: l_result_tbl PO_TBL_NUMBER;

Line 599: -- variables to save result read from po_session_gt

595:
596: -- ket value used to identify records in po_session_gt table
597: l_key PO_SESSION_GT.key%TYPE;
598:
599: -- variables to save result read from po_session_gt
600: l_index_tbl PO_TBL_NUMBER;
601: l_result_tbl PO_TBL_NUMBER;
602: l_source_tbl PO_TBL_VARCHAR5; -- values can be 'draft' or 'txn'
603:

Line 634: INSERT INTO po_session_gt(key, num1, num2, char1)

630: l_key := PO_CORE_S.get_session_gt_nextval;
631:
632: -- first check whether record exists in draft table
633: FORALL i IN INDICES OF x_processing_row_tbl
634: INSERT INTO po_session_gt(key, num1, num2, char1)
635: SELECT l_key,
636: x_processing_row_tbl(i),
637: attribute_values_tlp_id,
638: 'DRAFT'

Line 654: INSERT INTO po_session_gt(key, num1, num2, char1)

650:
651: d_position := 20;
652:
653: FORALL i IN INDICES OF x_processing_row_tbl
654: INSERT INTO po_session_gt(key, num1, num2, char1)
655: SELECT l_key,
656: x_processing_row_tbl(i),
657: attribute_values_tlp_id,
658: 'TXN'

Line 665: -- retrieve result from po_session_gt table

661: AND language = x_attr_values_tlp.language_tbl(i)
662: AND org_id = x_attr_values_tlp.org_id_tbl(i);
663: END IF;
664:
665: -- retrieve result from po_session_gt table
666: DELETE FROM po_session_gt
667: WHERE key = l_key
668: RETURNING num1, num2, char1 BULK COLLECT INTO
669: l_index_tbl, l_result_tbl, l_source_tbl;

Line 666: DELETE FROM po_session_gt

662: AND org_id = x_attr_values_tlp.org_id_tbl(i);
663: END IF;
664:
665: -- retrieve result from po_session_gt table
666: DELETE FROM po_session_gt
667: WHERE key = l_key
668: RETURNING num1, num2, char1 BULK COLLECT INTO
669: l_index_tbl, l_result_tbl, l_source_tbl;
670: