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

Line 1430: INSERT INTO PO_SESSION_GT SES

1426:
1427: l_data_key := PO_CORE_S.get_session_gt_nextval();
1428:
1429: FORALL i IN 1 .. p_line_id_tbl.COUNT
1430: INSERT INTO PO_SESSION_GT SES
1431: ( key
1432: , num1
1433: , date1
1434: , date2

Line 1456: PO_SESSION_GT SES

1452: BULK COLLECT INTO
1453: l_line_id_tbl
1454: , l_end_date_tbl
1455: FROM
1456: PO_SESSION_GT SES
1457: , PO_LINES_ALL LINE
1458: , PO_HEADERS_ALL HEADER
1459: WHERE
1460: SES.key = l_data_key

Line 1760: INSERT INTO PO_SESSION_GT

1756:
1757: FOR i IN 1 .. l_parent_id_tbl.Count LOOP
1758: -- Extract Par Line ids of this distribution
1759: extract_par_draft_id_tbl(p_par_draft_id_tbl(i), l_par_draft_id_tbl);
1760: INSERT INTO PO_SESSION_GT
1761: ( key
1762: , index_num1
1763: , index_num2
1764: , num1

Line 1796: INSERT INTO PO_SESSION_GT

1792:
1793: FOR i IN 1 .. l_parent_id_tbl.COUNT LOOP
1794: -- Extract Par Line ids of this shipment
1795: extract_par_draft_id_tbl(p_par_draft_id_tbl(i), l_par_draft_id_tbl);
1796: INSERT INTO PO_SESSION_GT
1797: ( key
1798: , index_num1
1799: , index_num2
1800: , num1

Line 1835: INSERT INTO PO_SESSION_GT

1831:
1832: FOR i IN 1 .. l_parent_id_tbl.COUNT LOOP
1833: -- Extract Par Line ids of this line
1834: extract_par_draft_id_tbl(p_par_draft_id_tbl(i), l_par_draft_id_tbl);
1835: INSERT INTO PO_SESSION_GT
1836: ( key
1837: , index_num1
1838: , index_num2
1839: , num1

Line 1866: MERGE INTO PO_SESSION_GT SES

1862:
1863: -- Merge in the new data.
1864:
1865: FORALL i IN 1 .. p_entity_id_tbl.COUNT
1866: MERGE INTO PO_SESSION_GT SES
1867: USING DUAL
1868: ON
1869: ( SES.key = l_data_key
1870: AND SES.index_num2 = p_entity_id_tbl(i)

Line 1895: UPDATE PO_SESSION_GT SES

1891: -- : update session gt with p_entity_type_tbl values
1892: IF (p_entity_type_tbl IS NOT NULL) THEN
1893:
1894: FORALL I IN 1..p_entity_id_tbl.COUNT
1895: UPDATE PO_SESSION_GT SES
1896: SET SES.char1 = p_entity_type_tbl(i)
1897: WHERE SES.key = l_data_key
1898: AND SES.index_num2 = p_entity_id_tbl(i);
1899:

Line 1926: PO_SESSION_GT CHILD

1922: , decode(char1,
1923: PO_CONSTANTS_SV.SHIP_TYPE_PRICE_BREAK, PO_MESSAGE_S.PO_PO_ENTER_UNIQUE_PRC_BRK_NUM,
1924: l_message_name)
1925: FROM
1926: PO_SESSION_GT CHILD
1927: WHERE
1928: CHILD.key = l_data_key
1929: AND CHILD.index_char2 = c_NEW
1930: AND EXISTS

Line 1932: FROM PO_SESSION_GT SIBLING

1928: CHILD.key = l_data_key
1929: AND CHILD.index_char2 = c_NEW
1930: AND EXISTS
1931: ( SELECT null
1932: FROM PO_SESSION_GT SIBLING
1933: WHERE
1934: SIBLING.key = l_data_key
1935: AND SIBLING.index_num1 = CHILD.index_num1 -- parent id
1936: AND SIBLING.num1 = CHILD.num1 -- child num

Line 2034: INSERT INTO PO_SESSION_GT

2030:
2031: l_data_key := PO_CORE_S.get_session_gt_nextval();
2032:
2033: FORALL i IN 1 .. l_parent_id_tbl.COUNT
2034: INSERT INTO PO_SESSION_GT
2035: ( key
2036: , index_num1
2037: , index_char1
2038: , index_num2

Line 2059: MERGE INTO PO_SESSION_GT SES

2055:
2056: -- Merge in the new data.
2057:
2058: FORALL i IN 1 .. p_price_diff_id_tbl.COUNT
2059: MERGE INTO PO_SESSION_GT SES
2060: USING DUAL
2061: ON
2062: ( SES.key = l_data_key
2063: AND SES.index_num2 = p_price_diff_id_tbl(i)

Line 2109: PO_SESSION_GT CHILD

2105: , p_message_name
2106: , p_column_name --bug #4956116
2107: , (select displayed_field from po_lookup_codes where lookup_code = CHILD.char1 and lookup_type = 'PRICE DIFFERENTIALS') --bug #4956116
2108: FROM
2109: PO_SESSION_GT CHILD
2110: WHERE
2111: CHILD.key = l_data_key
2112: AND CHILD.index_char2 = c_NEW
2113: AND EXISTS

Line 2115: FROM PO_SESSION_GT SIBLING

2111: CHILD.key = l_data_key
2112: AND CHILD.index_char2 = c_NEW
2113: AND EXISTS
2114: ( SELECT null
2115: FROM PO_SESSION_GT SIBLING
2116: WHERE
2117: SIBLING.key = l_data_key
2118: AND SIBLING.index_num1 = CHILD.index_num1 -- entity_id
2119: AND SIBLING.index_char1 = CHILD.index_char1 -- entity_type

Line 3488: -- key value used to identify rows in po_session_gt table

3484:
3485: d_mod CONSTANT VARCHAR2(100) := d_get_item_secondary_uom;
3486: l_secondary_unit_of_meas_tbl PO_TBL_VARCHAR30 := PO_TBL_VARCHAR30();
3487:
3488: -- key value used to identify rows in po_session_gt table
3489: l_key po_session_gt.key%TYPE;
3490: l_index_tbl DBMS_SQL.NUMBER_TABLE;
3491: l_index1_tbl PO_TBL_NUMBER;
3492: l_result1_tbl PO_TBL_VARCHAR30;

Line 3489: l_key po_session_gt.key%TYPE;

3485: d_mod CONSTANT VARCHAR2(100) := d_get_item_secondary_uom;
3486: l_secondary_unit_of_meas_tbl PO_TBL_VARCHAR30 := PO_TBL_VARCHAR30();
3487:
3488: -- key value used to identify rows in po_session_gt table
3489: l_key po_session_gt.key%TYPE;
3490: l_index_tbl DBMS_SQL.NUMBER_TABLE;
3491: l_index1_tbl PO_TBL_NUMBER;
3492: l_result1_tbl PO_TBL_VARCHAR30;
3493:

Line 3510: INSERT INTO po_session_gt(key, num1, char1)

3506: l_index_tbl(i) := i;
3507: END LOOP;
3508:
3509: FORALL i IN 1..p_item_id_tbl.COUNT
3510: INSERT INTO po_session_gt(key, num1, char1)
3511: SELECT l_key, l_index_tbl(i), uom.unit_of_measure
3512: FROM mtl_system_items msi,
3513: mtl_units_of_measure uom
3514: WHERE msi.inventory_item_id = p_item_id_tbl(i)

Line 3519: DELETE FROM po_session_gt

3515: AND msi.organization_id = p_organization_id_tbl(i)
3516: AND msi.tracking_quantity_ind = 'PS'
3517: AND msi.secondary_uom_code = uom.uom_code;
3518:
3519: DELETE FROM po_session_gt
3520: WHERE key = l_key
3521: RETURNING num1, char1 BULK COLLECT INTO l_index1_tbl, l_result1_tbl;
3522:
3523: FOR i IN 1..l_index1_tbl.COUNT LOOP