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 1276: INSERT INTO PO_SESSION_GT SES

1272:
1273: l_data_key := PO_CORE_S.get_session_gt_nextval();
1274:
1275: FORALL i IN 1 .. p_line_id_tbl.COUNT
1276: INSERT INTO PO_SESSION_GT SES
1277: ( key
1278: , num1
1279: , date1
1280: , date2

Line 1302: PO_SESSION_GT SES

1298: BULK COLLECT INTO
1299: l_line_id_tbl
1300: , l_end_date_tbl
1301: FROM
1302: PO_SESSION_GT SES
1303: , PO_LINES_ALL LINE
1304: , PO_HEADERS_ALL HEADER
1305: WHERE
1306: SES.key = l_data_key

Line 1601: INSERT INTO PO_SESSION_GT

1597: l_column_name := c_DISTRIBUTION_NUM;
1598: l_message_name := PO_MESSAGE_S.PO_PO_ENTER_UNIQUE_DIST_NUM;
1599:
1600: FORALL i IN 1 .. l_parent_id_tbl.COUNT
1601: INSERT INTO PO_SESSION_GT
1602: ( key
1603: , index_num1
1604: , index_num2
1605: , num1

Line 1626: INSERT INTO PO_SESSION_GT

1622: l_column_name := c_SHIPMENT_NUM;
1623: l_message_name := PO_MESSAGE_S.PO_PO_ENTER_UNIQUE_SHIP_NUM;
1624:
1625: FORALL i IN 1 .. l_parent_id_tbl.COUNT
1626: INSERT INTO PO_SESSION_GT
1627: ( key
1628: , index_num1
1629: , index_num2
1630: , num1

Line 1657: INSERT INTO PO_SESSION_GT

1653: l_column_name := c_LINE_NUM;
1654: l_message_name := PO_MESSAGE_S.PO_PO_ENTER_UNIQUE_LINE_NUM;
1655:
1656: FORALL i IN 1 .. l_parent_id_tbl.COUNT
1657: INSERT INTO PO_SESSION_GT
1658: ( key
1659: , index_num1
1660: , index_num2
1661: , num1

Line 1681: MERGE INTO PO_SESSION_GT SES

1677:
1678: -- Merge in the new data.
1679:
1680: FORALL i IN 1 .. p_entity_id_tbl.COUNT
1681: MERGE INTO PO_SESSION_GT SES
1682: USING DUAL
1683: ON
1684: ( SES.key = l_data_key
1685: AND SES.index_num2 = p_entity_id_tbl(i)

Line 1710: UPDATE PO_SESSION_GT SES

1706: -- : update session gt with p_entity_type_tbl values
1707: IF (p_entity_type_tbl IS NOT NULL) THEN
1708:
1709: FORALL I IN 1..p_entity_id_tbl.COUNT
1710: UPDATE PO_SESSION_GT SES
1711: SET SES.char1 = p_entity_type_tbl(i)
1712: WHERE SES.key = l_data_key
1713: AND SES.index_num2 = p_entity_id_tbl(i);
1714:

Line 1741: PO_SESSION_GT CHILD

1737: , decode(char1,
1738: PO_CONSTANTS_SV.SHIP_TYPE_PRICE_BREAK, PO_MESSAGE_S.PO_PO_ENTER_UNIQUE_PRC_BRK_NUM,
1739: l_message_name)
1740: FROM
1741: PO_SESSION_GT CHILD
1742: WHERE
1743: CHILD.key = l_data_key
1744: AND CHILD.index_char2 = c_NEW
1745: AND EXISTS

Line 1747: FROM PO_SESSION_GT SIBLING

1743: CHILD.key = l_data_key
1744: AND CHILD.index_char2 = c_NEW
1745: AND EXISTS
1746: ( SELECT null
1747: FROM PO_SESSION_GT SIBLING
1748: WHERE
1749: SIBLING.key = l_data_key
1750: AND SIBLING.index_num1 = CHILD.index_num1 -- parent id
1751: AND SIBLING.num1 = CHILD.num1 -- child num

Line 1849: INSERT INTO PO_SESSION_GT

1845:
1846: l_data_key := PO_CORE_S.get_session_gt_nextval();
1847:
1848: FORALL i IN 1 .. l_parent_id_tbl.COUNT
1849: INSERT INTO PO_SESSION_GT
1850: ( key
1851: , index_num1
1852: , index_char1
1853: , index_num2

Line 1874: MERGE INTO PO_SESSION_GT SES

1870:
1871: -- Merge in the new data.
1872:
1873: FORALL i IN 1 .. p_price_diff_id_tbl.COUNT
1874: MERGE INTO PO_SESSION_GT SES
1875: USING DUAL
1876: ON
1877: ( SES.key = l_data_key
1878: AND SES.index_num2 = p_price_diff_id_tbl(i)

Line 1924: PO_SESSION_GT CHILD

1920: , p_message_name
1921: , p_column_name --bug #4956116
1922: , (select displayed_field from po_lookup_codes where lookup_code = CHILD.char1 and lookup_type = 'PRICE DIFFERENTIALS') --bug #4956116
1923: FROM
1924: PO_SESSION_GT CHILD
1925: WHERE
1926: CHILD.key = l_data_key
1927: AND CHILD.index_char2 = c_NEW
1928: AND EXISTS

Line 1930: FROM PO_SESSION_GT SIBLING

1926: CHILD.key = l_data_key
1927: AND CHILD.index_char2 = c_NEW
1928: AND EXISTS
1929: ( SELECT null
1930: FROM PO_SESSION_GT SIBLING
1931: WHERE
1932: SIBLING.key = l_data_key
1933: AND SIBLING.index_num1 = CHILD.index_num1 -- entity_id
1934: AND SIBLING.index_char1 = CHILD.index_char1 -- entity_type

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

3297:
3298: d_mod CONSTANT VARCHAR2(100) := d_get_item_secondary_uom;
3299: l_secondary_unit_of_meas_tbl PO_TBL_VARCHAR30 := PO_TBL_VARCHAR30();
3300:
3301: -- key value used to identify rows in po_session_gt table
3302: l_key po_session_gt.key%TYPE;
3303: l_index_tbl DBMS_SQL.NUMBER_TABLE;
3304: l_index1_tbl PO_TBL_NUMBER;
3305: l_result1_tbl PO_TBL_VARCHAR30;

Line 3302: l_key po_session_gt.key%TYPE;

3298: d_mod CONSTANT VARCHAR2(100) := d_get_item_secondary_uom;
3299: l_secondary_unit_of_meas_tbl PO_TBL_VARCHAR30 := PO_TBL_VARCHAR30();
3300:
3301: -- key value used to identify rows in po_session_gt table
3302: l_key po_session_gt.key%TYPE;
3303: l_index_tbl DBMS_SQL.NUMBER_TABLE;
3304: l_index1_tbl PO_TBL_NUMBER;
3305: l_result1_tbl PO_TBL_VARCHAR30;
3306:

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

3319: l_index_tbl(i) := i;
3320: END LOOP;
3321:
3322: FORALL i IN 1..p_item_id_tbl.COUNT
3323: INSERT INTO po_session_gt(key, num1, char1)
3324: SELECT l_key, l_index_tbl(i), uom.unit_of_measure
3325: FROM mtl_system_items msi,
3326: mtl_units_of_measure uom
3327: WHERE msi.inventory_item_id = p_item_id_tbl(i)

Line 3332: DELETE FROM po_session_gt

3328: AND msi.organization_id = p_organization_id_tbl(i)
3329: AND msi.tracking_quantity_ind = 'PS'
3330: AND msi.secondary_uom_code = uom.uom_code;
3331:
3332: DELETE FROM po_session_gt
3333: WHERE key = l_key
3334: RETURNING num1, char1 BULK COLLECT INTO l_index1_tbl, l_result1_tbl;
3335:
3336: FOR i IN 1..l_index1_tbl.COUNT LOOP