APPS.PO_PDOI_PRICE_TOLERANCE_PVT dependencies on PO_SESSION_GT

Line 400: l_key po_session_gt.key%TYPE;

396: d_api_name CONSTANT VARCHAR2(30) := 'get_price_tolerance';
397: d_module CONSTANT VARCHAR2(255) := d_pkg_name || d_api_name || '.';
398: d_position NUMBER;
399:
400: l_key po_session_gt.key%TYPE;
401:
402: l_index_tbl PO_TBL_NUMBER;
403: l_tolerance_tbl PO_TBL_NUMBER;
404:

Line 424: INSERT INTO po_session_gt(key, num1, num2)

420: l_key := PO_CORE_S.get_session_gt_nextval;
421:
422: -- first, the value is fetched from po_asl_attributes table
423: FORALL i IN INDICES OF p_index_tbl
424: INSERT INTO po_session_gt(key, num1, num2)
425: SELECT l_key,
426: p_index_tbl(i),
427: price_update_tolerance
428: FROM po_asl_attributes

Line 443: DELETE FROM po_session_gt

439: AND using_organization_id IN (-1, PO_PDOI_PARAMS.g_sys.master_inv_org_id);
440:
441: d_position := 20;
442:
443: DELETE FROM po_session_gt
444: WHERE key = l_key
445: RETURNING num1, num2 BULK COLLECT INTO l_index_tbl, l_tolerance_tbl;
446:
447: FOR i IN 1..l_index_tbl.COUNT

Line 462: INSERT INTO po_session_gt(key, num1, num2)

458: d_position := 30;
459:
460: -- if tolerance is still null, get value from document header
461: FORALL i IN INDICES OF p_index_tbl
462: INSERT INTO po_session_gt(key, num1, num2)
463: SELECT l_key,
464: p_index_tbl(i),
465: price_update_tolerance
466: FROM po_headers_all

Line 473: DELETE FROM po_session_gt

469: AND x_price_update_tolerance_tbl(i) IS NULL;
470:
471: d_position := 40;
472:
473: DELETE FROM po_session_gt
474: WHERE key = l_key
475: RETURNING num1, num2 BULK COLLECT INTO l_index_tbl, l_tolerance_tbl;
476:
477: FOR I IN 1..l_index_tbl.COUNT