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_MOVE_TO_DRAFT_TABS_PVT dependencies on PO_SESSION_GT

Line 47: p_key IN po_session_gt.key%TYPE,

43: );
44:
45: PROCEDURE merge_po_attr_values_draft
46: (
47: p_key IN po_session_gt.key%TYPE,
48: p_attr_values IN PO_PDOI_TYPES.attr_values_rec_type
49: );
50:
51: PROCEDURE merge_po_attr_values_tlp_draft

Line 53: p_key IN po_session_gt.key%TYPE,

49: );
50:
51: PROCEDURE merge_po_attr_values_tlp_draft
52: (
53: p_key IN po_session_gt.key%TYPE,
54: p_attr_values_tlp IN PO_PDOI_TYPES.attr_values_tlp_rec_type
55: );
56:
57: PROCEDURE reset_cat_attributes

Line 291: l_key po_session_gt.key%TYPE;

287: d_position NUMBER;
288:
289: l_po_line_id NUMBER;
290: l_count NUMBER := 0;
291: l_key po_session_gt.key%TYPE;
292: l_index NUMBER;
293:
294: l_uom_different VARCHAR2(1);
295: l_exceed_tolerance VARCHAR2(1);

Line 436: INSERT INTO po_session_gt

432:
433: -- get existing values for all updatable attributes
434: l_key := PO_CORE_S.get_session_gt_nextval;
435: FORALL i IN 1..l_po_line_id_tbl.COUNT
436: INSERT INTO po_session_gt
437: (
438: key,
439: num1, -- po_line_id
440: char1, -- unit_of_measure

Line 483: DELETE FROM po_session_gt

479: AND items.organization_id(+) = PO_PDOI_PARAMS.g_sys.def_inv_org_id;
480:
481: d_position := 30;
482:
483: DELETE FROM po_session_gt
484: WHERE key = l_key
485: RETURNING num1, char1, num2, char2, date1, date2, char3,
486: num3, char4, num4, num5, char5, num6, num7, num8, char6
487: BULK COLLECT INTO

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

1112:
1113: -- 3. update or delete price break depending on document type
1114: -- when price is changed
1115: FORALL i IN INDICES OF l_update_loc_queue
1116: INSERT INTO po_session_gt(key, num1, num2, char1)
1117: SELECT l_key,
1118: line_location_id,
1119: x_lines.draft_id_tbl(i),
1120: 'Y'

Line 1126: DELETE FROM po_session_gt

1122: WHERE po_line_id = x_lines.po_line_id_tbl(i);
1123:
1124: d_position := 300;
1125:
1126: DELETE FROM po_session_gt
1127: WHERE key = l_key
1128: RETURNING num1, num2, char1 BULK COLLECT INTO
1129: l_change_loc_id_tbl, l_draft_id_tbl, l_delete_flag_tbl;
1130:

Line 1161: INSERT INTO po_session_gt(key, num1)

1157: d_position := 310;
1158:
1159: -- 4. give warning message for lines in l_uom_warning_queue
1160: FORALL i IN INDICES OF l_uom_warning_queue
1161: INSERT INTO po_session_gt(key, num1)
1162: SELECT l_key,
1163: l_uom_warning_queue(i)
1164: FROM DUAL
1165: WHERE EXISTS (SELECT 1

Line 1179: DELETE FROM po_session_gt

1175: OR l_price_limit_queue(i) IS NOT NULL;
1176:
1177: d_position := 320;
1178:
1179: DELETE FROM po_session_gt
1180: WHERE key = l_key
1181: RETURNING num1 BULK COLLECT INTO l_index_tbl;
1182:
1183: FOR i IN 1..l_index_tbl.COUNT

Line 1213: INSERT INTO po_session_gt

1209:
1210: -- 5. update description field in po_attribute_values_tlp table for current lang
1211: -- a. get rows that need to be synced from txn table to draft table;
1212: FORALL i IN INDICES OF l_update_desc_queue
1213: INSERT INTO po_session_gt
1214: (
1215: key,
1216: num1,
1217: num2,

Line 1233: DELETE FROM po_session_gt

1229: AND language = USERENV('LANG');
1230:
1231: d_position := 340;
1232:
1233: DELETE FROM po_session_gt
1234: WHERE key = l_key
1235: RETURNING num1, num2, char1, char2 BULK COLLECT INTO
1236: l_sync_attr_tlp_id_tbl, l_draft_id_tbl,
1237: l_item_desc_tbl, l_delete_flag_tbl;

Line 1310: l_key po_session_gt.key%TYPE;

1306: d_api_name CONSTANT VARCHAR2(30) := 'insert_line_locs';
1307: d_module CONSTANT VARCHAR2(255) := d_pkg_name || d_api_name || '.';
1308: d_position NUMBER;
1309:
1310: l_key po_session_gt.key%TYPE;
1311:
1312: l_change_loc_id_tbl PO_TBL_NUMBER;
1313: l_draft_id_tbl PO_TBL_NUMBER;
1314: l_delete_flag_tbl PO_TBL_VARCHAR1;

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

1330:
1331: -- get existing line_location_ids
1332: l_key := PO_CORE_S.get_session_gt_nextval;
1333: FORALL i IN 1..p_line_locs.rec_count
1334: INSERT INTO po_session_gt(key, num1, num2, char1)
1335: SELECT DISTINCT l_key,
1336: line_location_id,
1337: p_line_locs.draft_id_tbl(i),
1338: 'Y'

Line 1345: DELETE FROM po_session_gt

1341: AND p_line_locs.error_flag_tbl(i) = FND_API.g_FALSE;
1342:
1343: d_position := 20;
1344:
1345: DELETE FROM po_session_gt
1346: WHERE key = l_key
1347: RETURNING num1, num2, char1 BULK COLLECT INTO
1348: l_change_loc_id_tbl, l_draft_id_tbl, l_delete_flag_tbl;
1349:

Line 1534: l_key po_session_gt.key%TYPE;

1530: d_api_name CONSTANT VARCHAR2(30) := 'merge_attr_values';
1531: d_module CONSTANT VARCHAR2(255) := d_pkg_name || d_api_name || '.';
1532: d_position NUMBER;
1533:
1534: l_key po_session_gt.key%TYPE;
1535:
1536: -- variables used to sync attr values rows from txn table
1537: -- to draft table
1538: l_delete_flag_tbl PO_TBL_VARCHAR1 := PO_TBL_VARCHAR1();

Line 1567: -- save id attr values into po_session_gt for MERGE query

1563: );
1564:
1565: d_position := 10;
1566:
1567: -- save id attr values into po_session_gt for MERGE query
1568: l_key := PO_CORE_S.get_session_gt_nextval;
1569: FORALL i IN INDICES OF p_processing_row_tbl
1570: INSERT INTO po_session_gt
1571: (

Line 1570: INSERT INTO po_session_gt

1566:
1567: -- save id attr values into po_session_gt for MERGE query
1568: l_key := PO_CORE_S.get_session_gt_nextval;
1569: FORALL i IN INDICES OF p_processing_row_tbl
1570: INSERT INTO po_session_gt
1571: (
1572: key,
1573: num1, -- interface_attr_values_id
1574: num2, -- attribute_values_id

Line 1652: l_key po_session_gt.key%TYPE;

1648: d_api_name CONSTANT VARCHAR2(30) := 'merge_attr_values_tlp';
1649: d_module CONSTANT VARCHAR2(255) := d_pkg_name || d_api_name || '.';
1650: d_position NUMBER;
1651:
1652: l_key po_session_gt.key%TYPE;
1653:
1654: -- variables used to sync attr values rows from txn table
1655: -- to draft table
1656: l_delete_flag_tbl PO_TBL_VARCHAR1 := PO_TBL_VARCHAR1();

Line 1685: -- save id attr values tlp into po_session_gt for MERGE query

1681: );
1682:
1683: d_position := 10;
1684:
1685: -- save id attr values tlp into po_session_gt for MERGE query
1686: l_key := PO_CORE_S.get_session_gt_nextval;
1687: FORALL i IN INDICES OF p_processing_row_tbl
1688: INSERT INTO po_session_gt
1689: (

Line 1688: INSERT INTO po_session_gt

1684:
1685: -- save id attr values tlp into po_session_gt for MERGE query
1686: l_key := PO_CORE_S.get_session_gt_nextval;
1687: FORALL i IN INDICES OF p_processing_row_tbl
1688: INSERT INTO po_session_gt
1689: (
1690: key,
1691: num1, -- interface_attr_values_tlp_id
1692: num2, -- attribute_values_tlp_id

Line 3186: p_key IN po_session_gt.key%TYPE,

3182: --End of Comments
3183: ------------------------------------------------------------------------
3184: PROCEDURE merge_po_attr_values_draft
3185: (
3186: p_key IN po_session_gt.key%TYPE,
3187: p_attr_values IN PO_PDOI_TYPES.attr_values_rec_type
3188: ) IS
3189:
3190: d_api_name CONSTANT VARCHAR2(30) := 'merge_po_attr_values_draft';

Line 3534: po_session_gt gt

3530: PROGRAM_ID,
3531: PROGRAM_UPDATE_DATE,
3532: PICTURE
3533: FROM po_attr_values_interface intf_attrs,
3534: po_session_gt gt
3535: WHERE intf_attrs.interface_attr_values_id = gt.num1
3536: AND gt.key = p_key) PAVI
3537: ON (PAVD.attribute_values_id = PAVI.attribute_values_id
3538: AND PAVD.draft_id = PAVI.draft_id)

Line 4559: p_key IN po_session_gt.key%TYPE,

4555: --End of Comments
4556: ------------------------------------------------------------------------
4557: PROCEDURE merge_po_attr_values_tlp_draft
4558: (
4559: p_key IN po_session_gt.key%TYPE,
4560: p_attr_values_tlp IN PO_PDOI_TYPES.attr_values_tlp_rec_type
4561: ) IS
4562:
4563: d_api_name CONSTANT VARCHAR2(30) := 'merge_po_attr_values_tlp_draft';

Line 4755: po_session_gt gt

4751: PROGRAM_APPLICATION_ID,
4752: PROGRAM_ID,
4753: PROGRAM_UPDATE_DATE
4754: FROM po_attr_values_tlp_interface intf_attrs_tlp,
4755: po_session_gt gt
4756: WHERE intf_attrs_tlp.interface_attr_values_tlp_id = gt.num1
4757: AND gt.key = p_key) PAVTI
4758: ON (PAVTD.attribute_values_tlp_id = PAVTI.attribute_values_tlp_id
4759: AND PAVTD.draft_id = PAVTI.draft_id)

Line 5329: l_key po_session_gt.key%TYPE;

5325: d_api_name CONSTANT VARCHAR2(30) := 'reset_cat_attributes';
5326: d_module CONSTANT VARCHAR2(255) := d_pkg_name || d_api_name || '.';
5327: d_position NUMBER;
5328:
5329: l_key po_session_gt.key%TYPE;
5330:
5331: l_sync_attr_values_id_tbl PO_TBL_NUMBER;
5332: l_sync_attr_values_tlp_id_tbl PO_TBL_NUMBER;
5333: l_draft_id_tbl PO_TBL_NUMBER;

Line 5348: INSERT INTO po_session_gt

5344: l_key := PO_CORE_S.get_session_gt_nextval;
5345:
5346: -- get attribute_values_id we need to sync from txn tables
5347: FORALL i IN INDICES OF p_index_tbl
5348: INSERT INTO po_session_gt
5349: (
5350: key,
5351: num1,
5352: num2,

Line 5365: DELETE FROM po_session_gt

5361: WHERE po_line_id = p_po_line_id_tbl(i);
5362:
5363: d_position := 10;
5364:
5365: DELETE FROM po_session_gt
5366: WHERE key = l_key
5367: RETURNING num1, num2, char1 BULK COLLECT INTO
5368: l_sync_attr_values_id_tbl, l_draft_id_tbl,
5369: l_delete_flag_tbl;

Line 5501: INSERT INTO po_session_gt

5497: d_position := 40;
5498:
5499: -- get attribute_values_tlp_id we need to sync from txn tables
5500: FORALL i IN INDICES OF p_index_tbl
5501: INSERT INTO po_session_gt
5502: (
5503: key,
5504: num1,
5505: num2,

Line 5518: DELETE FROM po_session_gt

5514: WHERE po_line_id = p_po_line_id_tbl(i);
5515:
5516: d_position := 50;
5517:
5518: DELETE FROM po_session_gt
5519: WHERE key = l_key
5520: RETURNING num1, num2, char1 BULK COLLECT INTO
5521: l_sync_attr_values_tlp_id_tbl, l_draft_id_tbl,
5522: l_delete_flag_tbl;