APPS.PO_PDOI_PRICE_TOLERANCE_PVT dependencies on PO_SESSION_GT

Line 406: l_key po_session_gt.key%TYPE;

402: d_api_name CONSTANT VARCHAR2(30) := 'get_price_tolerance';
403: d_module CONSTANT VARCHAR2(255) := d_pkg_name || d_api_name || '.';
404: d_position NUMBER;
405:
406: l_key po_session_gt.key%TYPE;
407:
408: l_index_tbl PO_TBL_NUMBER;
409: l_tolerance_tbl PO_TBL_NUMBER;
410:

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

426: l_key := PO_CORE_S.get_session_gt_nextval;
427:
428: -- first, the value is fetched from po_asl_attributes table
429: FORALL i IN INDICES OF p_index_tbl
430: INSERT INTO po_session_gt(key, num1, num2)
431: SELECT l_key,
432: p_index_tbl(i),
433: price_update_tolerance
434: FROM po_asl_attributes

Line 449: DELETE FROM po_session_gt

445: AND using_organization_id IN (-1, PO_PDOI_PARAMS.g_sys.master_inv_org_id);
446:
447: d_position := 20;
448:
449: DELETE FROM po_session_gt
450: WHERE key = l_key
451: RETURNING num1, num2 BULK COLLECT INTO l_index_tbl, l_tolerance_tbl;
452:
453: FOR i IN 1..l_index_tbl.COUNT

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

464: d_position := 30;
465:
466: -- if tolerance is still null, get value from document header
467: FORALL i IN INDICES OF p_index_tbl
468: INSERT INTO po_session_gt(key, num1, num2)
469: SELECT l_key,
470: p_index_tbl(i),
471: price_update_tolerance
472: FROM po_headers_all

Line 479: DELETE FROM po_session_gt

475: AND x_price_update_tolerance_tbl(i) IS NULL;
476:
477: d_position := 40;
478:
479: DELETE FROM po_session_gt
480: WHERE key = l_key
481: RETURNING num1, num2 BULK COLLECT INTO l_index_tbl, l_tolerance_tbl;
482:
483: FOR I IN 1..l_index_tbl.COUNT