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 294: l_key po_session_gt.key%TYPE;

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

Line 449: INSERT INTO po_session_gt

445:
446: -- get existing values for all updatable attributes
447: l_key := PO_CORE_S.get_session_gt_nextval;
448: FORALL i IN 1..l_po_line_id_tbl.COUNT
449: INSERT INTO po_session_gt
450: (
451: key,
452: num1, -- po_line_id
453: char1, -- unit_of_measure

Line 506: DELETE FROM po_session_gt

502: AND items.organization_id(+) = PO_PDOI_PARAMS.g_sys.def_inv_org_id;
503:
504: d_position := 30;
505:
506: DELETE FROM po_session_gt
507: WHERE key = l_key
508: RETURNING num1, char1, num2, char2, date1, date2, char3,
509: num3, char4, num4, num5, char5, num6, num7, num8, char6,num9, -- Bug 11927927
510: num10, index_num1 -- Bug 13506679

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

1207:
1208: -- 3. update or delete price break depending on document type
1209: -- when price is changed
1210: FORALL i IN INDICES OF l_update_loc_queue
1211: INSERT INTO po_session_gt(key, num1, num2, char1)
1212: SELECT l_key,
1213: line_location_id,
1214: x_lines.draft_id_tbl(i),
1215: 'Y'

Line 1221: DELETE FROM po_session_gt

1217: WHERE po_line_id = x_lines.po_line_id_tbl(i);
1218:
1219: d_position := 300;
1220:
1221: DELETE FROM po_session_gt
1222: WHERE key = l_key
1223: RETURNING num1, num2, char1 BULK COLLECT INTO
1224: l_change_loc_id_tbl, l_draft_id_tbl, l_delete_flag_tbl;
1225:

Line 1256: INSERT INTO po_session_gt(key, num1)

1252: d_position := 310;
1253:
1254: -- 4. give warning message for lines in l_uom_warning_queue
1255: FORALL i IN INDICES OF l_uom_warning_queue
1256: INSERT INTO po_session_gt(key, num1)
1257: SELECT l_key,
1258: l_uom_warning_queue(i)
1259: FROM DUAL
1260: WHERE EXISTS (SELECT 1

Line 1274: DELETE FROM po_session_gt

1270: OR l_price_limit_queue(i) IS NOT NULL;
1271:
1272: d_position := 320;
1273:
1274: DELETE FROM po_session_gt
1275: WHERE key = l_key
1276: RETURNING num1 BULK COLLECT INTO l_index_tbl;
1277:
1278: FOR i IN 1..l_index_tbl.COUNT

Line 1308: INSERT INTO po_session_gt

1304:
1305: --
1306: -- 5.a. udpate ip category in po_attribute_values table
1307: FORALL i IN INDICES OF l_ip_cat_id_updated_queue
1308: INSERT INTO po_session_gt
1309: (
1310: key,
1311: num1,
1312: num2,

Line 1327: DELETE FROM po_session_gt

1323: WHERE po_line_id = x_lines.po_line_id_tbl(i);
1324:
1325: d_position := 333;
1326:
1327: DELETE FROM po_session_gt
1328: WHERE key = l_key
1329: RETURNING num1, num2, char1, char2
1330: BULK COLLECT INTO
1331: l_sync_attr_id_tbl, l_draft_id_tbl,

Line 1360: INSERT INTO po_session_gt

1356:
1357: -- 5. update description field in po_attribute_values_tlp table for current lang
1358: -- b. get rows that need to be synced from txn table to draft table;
1359: FORALL i IN INDICES OF l_update_desc_queue
1360: INSERT INTO po_session_gt
1361: (
1362: key,
1363: num1,
1364: num2,

Line 1388: MERGE INTO po_session_gt merged

1384: --
1385: -- merge rows for which ip category is to be updated with
1386: -- rows identified above (for which description is to be updated)
1387: FORALL i IN INDICES OF l_ip_cat_id_updated_queue
1388: MERGE INTO po_session_gt merged
1389: USING dual
1390: ON (merged.num3 = l_ip_cat_id_updated_queue(i)
1391: AND merged.key = l_key)
1392: WHEN MATCHED THEN

Line 1424: DELETE FROM po_session_gt

1420: --
1421:
1422: d_position := 345;
1423:
1424: DELETE FROM po_session_gt
1425: WHERE key = l_key
1426: RETURNING num1, num2, char1, char2, num4
1427: BULK COLLECT INTO
1428: l_sync_attr_tlp_id_tbl, l_draft_id_tbl,

Line 1504: l_key po_session_gt.key%TYPE;

1500: d_api_name CONSTANT VARCHAR2(30) := 'insert_line_locs';
1501: d_module CONSTANT VARCHAR2(255) := d_pkg_name || d_api_name || '.';
1502: d_position NUMBER;
1503:
1504: l_key po_session_gt.key%TYPE;
1505:
1506: l_change_loc_id_tbl PO_TBL_NUMBER;
1507: l_draft_id_tbl PO_TBL_NUMBER;
1508: l_delete_flag_tbl PO_TBL_VARCHAR1;

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

1524:
1525: -- get existing line_location_ids
1526: l_key := PO_CORE_S.get_session_gt_nextval;
1527: FORALL i IN 1..p_line_locs.rec_count
1528: INSERT INTO po_session_gt(key, num1, num2, char1)
1529: SELECT DISTINCT l_key,
1530: line_location_id,
1531: p_line_locs.draft_id_tbl(i),
1532: 'Y'

Line 1539: DELETE FROM po_session_gt

1535: AND p_line_locs.error_flag_tbl(i) = FND_API.g_FALSE;
1536:
1537: d_position := 20;
1538:
1539: DELETE FROM po_session_gt
1540: WHERE key = l_key
1541: RETURNING num1, num2, char1 BULK COLLECT INTO
1542: l_change_loc_id_tbl, l_draft_id_tbl, l_delete_flag_tbl;
1543:

Line 1728: l_key po_session_gt.key%TYPE;

1724: d_api_name CONSTANT VARCHAR2(30) := 'merge_attr_values';
1725: d_module CONSTANT VARCHAR2(255) := d_pkg_name || d_api_name || '.';
1726: d_position NUMBER;
1727:
1728: l_key po_session_gt.key%TYPE;
1729:
1730: -- variables used to sync attr values rows from txn table
1731: -- to draft table
1732: l_delete_flag_tbl PO_TBL_VARCHAR1 := PO_TBL_VARCHAR1();

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

1757: );
1758:
1759: d_position := 10;
1760:
1761: -- save id attr values into po_session_gt for MERGE query
1762: l_key := PO_CORE_S.get_session_gt_nextval;
1763: FORALL i IN INDICES OF p_processing_row_tbl
1764: INSERT INTO po_session_gt
1765: (

Line 1764: INSERT INTO po_session_gt

1760:
1761: -- save id attr values into po_session_gt for MERGE query
1762: l_key := PO_CORE_S.get_session_gt_nextval;
1763: FORALL i IN INDICES OF p_processing_row_tbl
1764: INSERT INTO po_session_gt
1765: (
1766: key,
1767: num1, -- interface_attr_values_id
1768: num2, -- attribute_values_id

Line 1846: l_key po_session_gt.key%TYPE;

1842: d_api_name CONSTANT VARCHAR2(30) := 'merge_attr_values_tlp';
1843: d_module CONSTANT VARCHAR2(255) := d_pkg_name || d_api_name || '.';
1844: d_position NUMBER;
1845:
1846: l_key po_session_gt.key%TYPE;
1847:
1848: -- variables used to sync attr values rows from txn table
1849: -- to draft table
1850: l_delete_flag_tbl PO_TBL_VARCHAR1 := PO_TBL_VARCHAR1();

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

1875: );
1876:
1877: d_position := 10;
1878:
1879: -- save id attr values tlp into po_session_gt for MERGE query
1880: l_key := PO_CORE_S.get_session_gt_nextval;
1881: FORALL i IN INDICES OF p_processing_row_tbl
1882: INSERT INTO po_session_gt
1883: (

Line 1882: INSERT INTO po_session_gt

1878:
1879: -- save id attr values tlp into po_session_gt for MERGE query
1880: l_key := PO_CORE_S.get_session_gt_nextval;
1881: FORALL i IN INDICES OF p_processing_row_tbl
1882: INSERT INTO po_session_gt
1883: (
1884: key,
1885: num1, -- interface_attr_values_tlp_id
1886: num2, -- attribute_values_tlp_id

Line 3526: p_key IN po_session_gt.key%TYPE,

3522: --End of Comments
3523: ------------------------------------------------------------------------
3524: PROCEDURE merge_po_attr_values_draft
3525: (
3526: p_key IN po_session_gt.key%TYPE,
3527: p_attr_values IN PO_PDOI_TYPES.attr_values_rec_type
3528: ) IS
3529:
3530: d_api_name CONSTANT VARCHAR2(30) := 'merge_po_attr_values_draft';

Line 3874: po_session_gt gt

3870: PROGRAM_ID,
3871: PROGRAM_UPDATE_DATE,
3872: PICTURE
3873: FROM po_attr_values_interface intf_attrs,
3874: po_session_gt gt
3875: WHERE intf_attrs.interface_attr_values_id = gt.num1
3876: AND gt.key = p_key) PAVI
3877: ON (PAVD.attribute_values_id = PAVI.attribute_values_id
3878: AND PAVD.draft_id = PAVI.draft_id)

Line 4899: p_key IN po_session_gt.key%TYPE,

4895: --End of Comments
4896: ------------------------------------------------------------------------
4897: PROCEDURE merge_po_attr_values_tlp_draft
4898: (
4899: p_key IN po_session_gt.key%TYPE,
4900: p_attr_values_tlp IN PO_PDOI_TYPES.attr_values_tlp_rec_type
4901: ) IS
4902:
4903: d_api_name CONSTANT VARCHAR2(30) := 'merge_po_attr_values_tlp_draft';

Line 5095: po_session_gt gt

5091: PROGRAM_APPLICATION_ID,
5092: PROGRAM_ID,
5093: PROGRAM_UPDATE_DATE
5094: FROM po_attr_values_tlp_interface intf_attrs_tlp,
5095: po_session_gt gt
5096: WHERE intf_attrs_tlp.interface_attr_values_tlp_id = gt.num1
5097: AND gt.key = p_key) PAVTI
5098: ON (PAVTD.attribute_values_tlp_id = PAVTI.attribute_values_tlp_id
5099: AND PAVTD.draft_id = PAVTI.draft_id)

Line 5669: l_key po_session_gt.key%TYPE;

5665: d_api_name CONSTANT VARCHAR2(30) := 'reset_cat_attributes';
5666: d_module CONSTANT VARCHAR2(255) := d_pkg_name || d_api_name || '.';
5667: d_position NUMBER;
5668:
5669: l_key po_session_gt.key%TYPE;
5670:
5671: l_sync_attr_values_id_tbl PO_TBL_NUMBER;
5672: l_sync_attr_values_tlp_id_tbl PO_TBL_NUMBER;
5673: l_draft_id_tbl PO_TBL_NUMBER;

Line 5688: INSERT INTO po_session_gt

5684: l_key := PO_CORE_S.get_session_gt_nextval;
5685:
5686: -- get attribute_values_id we need to sync from txn tables
5687: FORALL i IN INDICES OF p_index_tbl
5688: INSERT INTO po_session_gt
5689: (
5690: key,
5691: num1,
5692: num2,

Line 5705: DELETE FROM po_session_gt

5701: WHERE po_line_id = p_po_line_id_tbl(i);
5702:
5703: d_position := 10;
5704:
5705: DELETE FROM po_session_gt
5706: WHERE key = l_key
5707: RETURNING num1, num2, char1 BULK COLLECT INTO
5708: l_sync_attr_values_id_tbl, l_draft_id_tbl,
5709: l_delete_flag_tbl;

Line 5841: INSERT INTO po_session_gt

5837: d_position := 40;
5838:
5839: -- get attribute_values_tlp_id we need to sync from txn tables
5840: FORALL i IN INDICES OF p_index_tbl
5841: INSERT INTO po_session_gt
5842: (
5843: key,
5844: num1,
5845: num2,

Line 5858: DELETE FROM po_session_gt

5854: WHERE po_line_id = p_po_line_id_tbl(i);
5855:
5856: d_position := 50;
5857:
5858: DELETE FROM po_session_gt
5859: WHERE key = l_key
5860: RETURNING num1, num2, char1 BULK COLLECT INTO
5861: l_sync_attr_values_tlp_id_tbl, l_draft_id_tbl,
5862: l_delete_flag_tbl;