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 591: -- ket value used to identify records in po_session_gt table

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

Line 592: l_key PO_SESSION_GT.key%TYPE;

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

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

590:
591: -- ket value used to identify records in po_session_gt table
592: l_key PO_SESSION_GT.key%TYPE;
593:
594: -- variables to save result read from po_session_gt
595: l_index_tbl PO_TBL_NUMBER;
596: l_result_tbl PO_TBL_NUMBER;
597: l_source_tbl PO_TBL_VARCHAR5; -- values can be 'draft' or 'txn'
598:

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

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

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

645:
646: d_position := 20;
647:
648: FORALL i IN INDICES OF x_processing_row_tbl
649: INSERT INTO po_session_gt(key, num1, num2, char1)
650: SELECT l_key,
651: x_processing_row_tbl(i),
652: attribute_values_tlp_id,
653: 'TXN'

Line 660: -- retrieve result from po_session_gt table

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

Line 661: DELETE FROM po_session_gt

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