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

Line 104: l_key PO_SESSION_GT.key%TYPE;

100:
101: l_vendor_contact_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
102: l_is_fixed_rate VARCHAR2(10);
103:
104: l_key PO_SESSION_GT.key%TYPE;
105: i NUMBER;
106: rate NUMBER;
107: BEGIN
108: l_progress := '010';

Line 115: SELECT PO_SESSION_GT_S.nextval

111: IF g_debug THEN PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'p_headers_rec.interface_header_id.COUNT='||p_headers_rec.interface_header_id.COUNT); END IF;
112:
113: -- pick a new key from temp table which will be used in all default logic
114: --l_key := PO_CORE_S.get_session_gt_nextval;
115: SELECT PO_SESSION_GT_S.nextval
116: INTO l_key
117: FROM DUAL;
118:
119: l_progress := '020';

Line 620: -- Key used to access records in PO_SESSION_GT table.

616: -- This API should be called during the upgrade phase only.
617: --Parameters:
618: --IN:
619: --p_key
620: -- Key used to access records in PO_SESSION_GT table.
621: --p_headers_rec
622: -- A record of plsql tables containing a batch of headers. The value of
623: -- vendor_id will be picked up from this record.
624: --OUT:

Line 666: INSERT INTO PO_SESSION_GT(key,

662: -- SQL What: Get vendor related info into session GT table
663: -- SQL Why : It will be used to populate the OUT parameters.
664: -- SQL Join: vendor_id
665: FORALL i IN 1 .. p_headers_rec.vendor_id.COUNT
666: INSERT INTO PO_SESSION_GT(key,
667: num1,
668: char1,
669: num2)
670: SELECT p_key,

Line 686: DELETE FROM PO_SESSION_GT

682: l_progress := '030';
683: -- SQL What: Transfer from session GT table to local arrays
684: -- SQL Why : It will be used to populate the OUT parameters.
685: -- SQL Join: key
686: DELETE FROM PO_SESSION_GT
687: WHERE key = p_key
688: RETURNING num1, char1, num2
689: BULK COLLECT INTO l_indexes, l_currency_codes, l_terms_ids;
690:

Line 735: -- Key used to access records in PO_SESSION_GT table.

731: -- This API should be called during the upgrade phase only.
732: --Parameters:
733: --IN:
734: --p_key
735: -- Key used to access records in PO_SESSION_GT table.
736: --IN/OUT:
737: --p_headers_rec
738: -- A record of plsql tables containing a batch of headers. The value of
739: -- vendor_id will be picked up from this record. The default values of

Line 777: INSERT INTO PO_SESSION_GT(key, num1, num2, num3)

773: -- 1 site for the given vendor.
774: -- SQL Why : It will be used to populate the OUT parameters.
775: -- SQL Join: vendor_id
776: FORALL i IN 1 .. p_headers_rec.vendor_id.COUNT
777: INSERT INTO PO_SESSION_GT(key, num1, num2, num3)
778: SELECT p_key,
779: l_subscript_array(i),
780: min(vendor_site.vendor_site_id),
781: vendor_site.vendor_id

Line 800: DELETE FROM PO_SESSION_GT

796: l_progress := '030';
797: -- SQL What: Transfer from session GT table to local arrays
798: -- SQL Why : It will be used to populate the OUT parameters.
799: -- SQL Join: key
800: DELETE FROM PO_SESSION_GT
801: WHERE key = p_key
802: RETURNING num1,
803: num2
804: BULK COLLECT INTO l_indexes, l_vendor_site_ids;

Line 851: -- Key used to access records in PO_SESSION_GT table.

847: -- This API should be called during the upgrade phase only.
848: --Parameters:
849: --IN:
850: --p_key
851: -- Key used to access records in PO_SESSION_GT table.
852: --IN/OUT:
853: --p_headers_rec
854: -- A record of plsql tables containing a batch of headers. The value of
855: -- vendor_id will be picked up from this record. The default values from

Line 907: INSERT INTO PO_SESSION_GT(key,

903: -- SQL What: Get vendor site related info into session GT table
904: -- SQL Why : It will be used to populate the OUT parameters.
905: -- SQL Join: vendor_site_id
906: FORALL i IN 1 .. p_headers_rec.vendor_id.COUNT
907: INSERT INTO PO_SESSION_GT(key,
908: num1,
909: char1,
910: char2,
911: char3,

Line 945: DELETE FROM PO_SESSION_GT

941: l_progress := '030';
942: -- SQL What: Transfer from session GT table to local arrays
943: -- SQL Why : It will be used to populate the OUT parameters.
944: -- SQL Join: key
945: DELETE FROM PO_SESSION_GT
946: WHERE key = p_key
947: RETURNING num1,
948: char1,
949: char2,

Line 1018: -- Key used to access records in PO_SESSION_GT table.

1014: -- This API should be called during the upgrade phase only.
1015: --Parameters:
1016: --IN:
1017: --p_key
1018: -- Key used to access records in PO_SESSION_GT table.
1019: --IN/OUT:
1020: --p_headers_rec
1021: -- A record of plsql tables containing a batch of headers. The value of
1022: -- vendor_site_id will be picked up from this record. The default values

Line 1056: INSERT INTO PO_SESSION_GT(key,

1052: -- SQL What: Get vendor contact id into session GT table
1053: -- SQL Why : It will be used to populate the OUT parameters.
1054: -- SQL Join: vendor_site_id
1055: FORALL i IN 1 .. p_headers_rec.vendor_site_id.COUNT
1056: INSERT INTO PO_SESSION_GT(key,
1057: num1,
1058: num2,
1059: num3)
1060: SELECT p_key,

Line 1081: DELETE FROM po_session_gt

1077: l_progress := '030';
1078: -- SQL What: Transfer from session GT table to local arrays
1079: -- SQL Why : It will be used to populate the OUT parameters.
1080: -- SQL Join: key
1081: DELETE FROM po_session_gt
1082: WHERE key = p_key
1083: RETURNING num1, num2
1084: BULK COLLECT INTO l_indexes, l_contact_ids;
1085:

Line 1134: -- Key used to access records in PO_SESSION_GT table.

1130: -- This API should be called during the upgrade phase only.
1131: --Parameters:
1132: --IN:
1133: --p_key
1134: -- Key used to access records in PO_SESSION_GT table.
1135: --IN/OUT:
1136: --p_headers_rec
1137: -- A record of plsql tables containing a batch of headers. The value of
1138: -- vendor_id, site_id, currency_code, org_id, cpa_reference will be picked up

Line 1172: INSERT INTO PO_SESSION_GT(key,

1168: -- SQL Why : It will be used to populate the OUT parameters (to default the
1169: -- agent_id into the new GBPA)
1170: -- SQL Join: segment1, org_id
1171: FORALL i IN 1 .. x_headers_rec.po_header_id.COUNT
1172: INSERT INTO PO_SESSION_GT(key,
1173: num1,
1174: num2)
1175: SELECT p_key,
1176: l_subscript_array(i),

Line 1195: DELETE FROM PO_SESSION_GT

1191: l_progress := '030';
1192: -- SQL What: Transfer from session GT table to local arrays
1193: -- SQL Why : It will be used to populate the OUT parameters.
1194: -- SQL Join: key
1195: DELETE FROM PO_SESSION_GT
1196: WHERE key = p_key
1197: RETURNING num1, num2
1198: BULK COLLECT INTO l_indexes, l_agent_ids;
1199:

Line 1223: INSERT INTO PO_SESSION_GT(key,

1219: -- SQL Why : It will be used to populate the OUT parameters (to default the
1220: -- agent_id into the new GBPA)
1221: -- SQL Join: vendor_id, vendor_site_id, currency_code, org_id, type_lookup_code
1222: FORALL i IN 1 .. x_headers_rec.po_header_id.COUNT
1223: INSERT INTO PO_SESSION_GT(key,
1224: num1,
1225: num2)
1226: SELECT p_key,
1227: l_subscript_array(i),

Line 1261: DELETE FROM PO_SESSION_GT

1257: l_progress := '060';
1258: -- SQL What: Transfer from session GT table to local arrays
1259: -- SQL Why : It will be used to populate the OUT parameters.
1260: -- SQL Join: key
1261: DELETE FROM PO_SESSION_GT
1262: WHERE key = p_key
1263: RETURNING num1, num2
1264: BULK COLLECT INTO l_indexes, l_agent_ids;
1265:

Line 1289: INSERT INTO PO_SESSION_GT(key,

1285: -- Bug#5389286 use PER_EMPLOYEES_CURRENT_X instead of POBUYERS_VAL_V
1286: -- and collapsed 2 subqueries into 1 subquery to get newest valid
1287: -- buyer in the current business group
1288: FORALL i IN 1 .. x_headers_rec.po_header_id.COUNT
1289: INSERT INTO PO_SESSION_GT(key,
1290: num1,
1291: num2)
1292: SELECT p_key,
1293: l_subscript_array(i),

Line 1321: DELETE FROM PO_SESSION_GT

1317: l_progress := '090';
1318: -- SQL What: Transfer from session GT table to local arrays
1319: -- SQL Why : It will be used to populate the OUT parameters.
1320: -- SQL Join: key
1321: DELETE FROM PO_SESSION_GT
1322: WHERE key = p_key
1323: RETURNING num1, num2
1324: BULK COLLECT INTO l_indexes, l_agent_ids;
1325:

Line 1353: p_key IN PO_SESSION_GT.key%TYPE,

1349: -- Forward function declarations
1350:
1351: PROCEDURE default_hdr_info
1352: (
1353: p_key IN PO_SESSION_GT.key%TYPE,
1354: p_lines_rec IN PO_R12_CAT_UPG_PVT.record_of_lines_type,
1355: x_org_ids OUT NOCOPY PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER,
1356: x_vendor_ids OUT NOCOPY PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER,
1357: x_vendor_site_ids OUT NOCOPY PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER,

Line 1372: p_key IN PO_SESSION_GT.key%TYPE,

1368: );
1369:
1370: PROCEDURE default_line_type
1371: (
1372: p_key IN PO_SESSION_GT.key%TYPE,
1373: p_hdr_org_ids IN PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER,
1374: x_lines_rec IN OUT NOCOPY PO_R12_CAT_UPG_PVT.record_of_lines_type
1375: );
1376:

Line 1379: p_key IN PO_SESSION_GT.key%TYPE,

1375: );
1376:
1377: PROCEDURE default_info_from_line_type
1378: (
1379: p_key IN PO_SESSION_GT.key%TYPE,
1380: x_lines_rec IN OUT NOCOPY PO_R12_CAT_UPG_PVT.record_of_lines_type
1381: );
1382:
1383: PROCEDURE default_info_from_item

Line 1385: p_key IN PO_SESSION_GT.key%TYPE,

1381: );
1382:
1383: PROCEDURE default_info_from_item
1384: (
1385: p_key IN PO_SESSION_GT.key%TYPE,
1386: x_lines_rec IN OUT NOCOPY PO_R12_CAT_UPG_PVT.record_of_lines_type
1387: );
1388:
1389: PROCEDURE default_hzd_cls_from_un_num

Line 1391: p_key IN PO_SESSION_GT.key%TYPE,

1387: );
1388:
1389: PROCEDURE default_hzd_cls_from_un_num
1390: (
1391: p_key IN PO_SESSION_GT.key%TYPE,
1392: x_lines_rec IN OUT NOCOPY PO_R12_CAT_UPG_PVT.record_of_lines_type
1393: );
1394:
1395: PROCEDURE get_ship_to_org_from_location

Line 1397: p_key IN PO_SESSION_GT.key%TYPE,

1393: );
1394:
1395: PROCEDURE get_ship_to_org_from_location
1396: (
1397: p_key IN PO_SESSION_GT.key%TYPE,
1398: p_location_ids IN PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER,
1399: x_org_ids OUT NOCOPY PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER
1400: );
1401:

Line 1436: l_key PO_SESSION_GT.key%TYPE;

1432: l_progress VARCHAR2(3) := '000';
1433:
1434: l_size NUMBER := p_lines_rec.interface_line_id.COUNT;
1435:
1436: l_key PO_SESSION_GT.key%TYPE;
1437: i NUMBER;
1438:
1439: l_hdr_org_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
1440: l_hdr_vendor_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;

Line 1456: SELECT PO_SESSION_GT_S.nextval

1452:
1453: l_progress := '020';
1454: -- pick a new key from temp table which will be used in all default logic
1455: --l_key := PO_CORE_S.get_session_gt_nextval;
1456: SELECT PO_SESSION_GT_S.nextval
1457: INTO l_key
1458: FROM DUAL;
1459:
1460: l_progress := '030';

Line 1822: -- Key used to access records in PO_SESSION_GT table.

1818: -- Defaults the line type.
1819: --Parameters:
1820: --IN:
1821: --p_key
1822: -- Key used to access records in PO_SESSION_GT table.
1823: --p_hdr_org_ids
1824: -- A table of numbers containing the header level org_id's
1825: --IN/OUT:
1826: --x_lines_rec

Line 1834: p_key IN PO_SESSION_GT.key%TYPE,

1830: --End of Comments
1831: --------------------------------------------------------------------------------
1832: PROCEDURE default_line_type
1833: (
1834: p_key IN PO_SESSION_GT.key%TYPE,
1835: p_hdr_org_ids IN PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER,
1836: x_lines_rec IN OUT NOCOPY PO_R12_CAT_UPG_PVT.record_of_lines_type
1837: )
1838: IS

Line 1864: INSERT INTO PO_SESSION_GT(key,

1860: -- value of line_type_id = 1)
1861: -- SQL Why : It will be used to populate the OUT parameters.
1862: -- SQL Join: line_type_id, org_id
1863: FORALL i IN 1 .. x_lines_rec.interface_line_id.COUNT
1864: INSERT INTO PO_SESSION_GT(key,
1865: num1,
1866: num2)
1867: SELECT p_key,
1868: l_subscript_array(i),

Line 1885: DELETE FROM po_session_gt

1881: l_progress := '030';
1882: -- SQL What: Transfer from session GT table to local arrays
1883: -- SQL Why : It will be used to populate the OUT parameters.
1884: -- SQL Join: key
1885: DELETE FROM po_session_gt
1886: WHERE key = p_key
1887: RETURNING num1, num2
1888: BULK COLLECT INTO l_indexes, l_line_type_ids;
1889:

Line 1932: -- Key used to access records in PO_SESSION_GT table.

1928: -- unit_price
1929: --Parameters:
1930: --IN:
1931: --p_key
1932: -- Key used to access records in PO_SESSION_GT table.
1933: --IN/OUT:
1934: --x_lines_rec
1935: -- A record of plsql tables containing a batch of lines. The value of
1936: -- order_type_lookup_code, purchase_basis and matching_basis will be populated.

Line 1942: p_key IN PO_SESSION_GT.key%TYPE,

1938: --End of Comments
1939: --------------------------------------------------------------------------------
1940: PROCEDURE default_info_from_line_type
1941: (
1942: p_key IN PO_SESSION_GT.key%TYPE,
1943: x_lines_rec IN OUT NOCOPY PO_R12_CAT_UPG_PVT.record_of_lines_type
1944: )
1945: IS
1946: l_api_name CONSTANT VARCHAR2(30) := 'default_info_from_line_type';

Line 1971: INSERT INTO po_session_gt(key,

1967: -- SQL What: Get the line type related info into the session GT table.
1968: -- SQL Why : It will be used to populate the OUT parameters.
1969: -- SQL Join: line_type_id
1970: FORALL i IN 1 .. x_lines_rec.line_type_id.COUNT
1971: INSERT INTO po_session_gt(key,
1972: num1,
1973: char1,
1974: char2,
1975: char3)

Line 1993: DELETE FROM po_session_gt

1989: l_progress := '030';
1990: -- SQL What: Transfer from session GT table to local arrays
1991: -- SQL Why : It will be used to populate the OUT parameters.
1992: -- SQL Join: key
1993: DELETE FROM po_session_gt
1994: WHERE key = p_key
1995: RETURNING num1, char1, char2, char3
1996: BULK COLLECT INTO l_indexes, l_order_type_lookup_codes,
1997: l_purchase_basis, l_matching_basis;

Line 2039: -- Key used to access records in PO_SESSION_GT table.

2035: --
2036: --Parameters:
2037: --IN:
2038: --p_key
2039: -- Key used to access records in PO_SESSION_GT table.
2040: --IN/OUT:
2041: --x_lines_rec
2042: -- A record of plsql tables containing a batch of lines. The value of
2043: -- above gived fields will be populated.

Line 2049: p_key IN PO_SESSION_GT.key%TYPE,

2045: --End of Comments
2046: --------------------------------------------------------------------------------
2047: PROCEDURE default_info_from_item
2048: (
2049: p_key IN PO_SESSION_GT.key%TYPE,
2050: x_lines_rec IN OUT NOCOPY PO_R12_CAT_UPG_PVT.record_of_lines_type
2051: )
2052: IS
2053: l_api_name CONSTANT VARCHAR2(30) := 'default_info_from_item';

Line 2079: INSERT INTO po_session_gt(key,

2075: -- SQL What: Default information from item_id into the session GT table.
2076: -- SQL Why : It will be used to populate the OUT parameters.
2077: -- SQL Join: item_id
2078: FORALL i IN 1 .. x_lines_rec.line_type_id.COUNT
2079: INSERT INTO po_session_gt(key,
2080: num1,
2081: num2,
2082: num3,
2083: num4,

Line 2104: DELETE FROM po_session_gt

2100: l_progress := '030';
2101: -- SQL What: Transfer from session GT table to local arrays
2102: -- SQL Why : It will be used to populate the OUT parameters.
2103: -- SQL Join: key
2104: DELETE FROM po_session_gt
2105: WHERE key = p_key
2106: RETURNING num1, num2, num3, num4, char1
2107: BULK COLLECT INTO l_indexes, l_un_number_ids, l_hazard_class_ids,
2108: l_market_prices, l_inspection_required_flags;

Line 2146: -- Key used to access records in PO_SESSION_GT table.

2142: --
2143: --Parameters:
2144: --IN:
2145: --p_key
2146: -- Key used to access records in PO_SESSION_GT table.
2147: --p_location_ids
2148: -- A plsql tables containing a set of location_ids
2149: --OUT:
2150: --x_org_ids

Line 2158: p_key IN PO_SESSION_GT.key%TYPE,

2154: --End of Comments
2155: --------------------------------------------------------------------------------
2156: PROCEDURE get_ship_to_org_from_location
2157: (
2158: p_key IN PO_SESSION_GT.key%TYPE,
2159: p_location_ids IN PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER,
2160: x_org_ids OUT NOCOPY PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER
2161: )
2162: IS

Line 2190: INSERT INTO po_session_gt(key,

2186: -- SQL What: Default information from ship_to_location into session GT table.
2187: -- SQL Why : It will be used to populate the OUT parameters.
2188: -- SQL Join: location_id
2189: FORALL i IN 1 .. p_location_ids.COUNT
2190: INSERT INTO po_session_gt(key,
2191: num1,
2192: num2)
2193: SELECT p_key,
2194: l_subscript_array(i),

Line 2207: DELETE FROM po_session_gt

2203: l_progress := '030';
2204: -- SQL What: Transfer from session GT table to local arrays
2205: -- SQL Why : It will be used to populate the OUT parameters.
2206: -- SQL Join: key
2207: DELETE FROM po_session_gt
2208: WHERE key = p_key
2209: RETURNING num1, num2
2210: BULK COLLECT INTO l_indexes, l_org_ids;
2211:

Line 2251: -- Key used to access records in PO_SESSION_GT table.

2247: --
2248: --Parameters:
2249: --IN:
2250: --p_key
2251: -- Key used to access records in PO_SESSION_GT table.
2252: --IN/OUT:
2253: --x_lines_rec
2254: -- A record of plsql tables containing a batch of lines. The value of
2255: -- hazard_class_id will be populated.

Line 2261: p_key IN PO_SESSION_GT.key%TYPE,

2257: --End of Comments
2258: --------------------------------------------------------------------------------
2259: PROCEDURE default_hzd_cls_from_un_num
2260: (
2261: p_key IN PO_SESSION_GT.key%TYPE,
2262: x_lines_rec IN OUT NOCOPY PO_R12_CAT_UPG_PVT.record_of_lines_type
2263: )
2264: IS
2265: l_api_name CONSTANT VARCHAR2(30) := 'default_hzd_cls_from_un_num';

Line 2288: INSERT INTO po_session_gt(key,

2284: -- SQL What: Default hazard_class_id into the session GT table.
2285: -- SQL Why : It will be used to populate the OUT parameters.
2286: -- SQL Join: un_number
2287: FORALL i IN 1 .. x_lines_rec.ship_to_location_id.COUNT
2288: INSERT INTO po_session_gt(key,
2289: num1,
2290: num2)
2291: SELECT p_key,
2292: l_subscript_array(i),

Line 2307: DELETE FROM po_session_gt

2303: l_progress := '030';
2304: -- SQL What: Transfer from session GT table to local arrays
2305: -- SQL Why : It will be used to populate the OUT parameters.
2306: -- SQL Join: key
2307: DELETE FROM po_session_gt
2308: WHERE key = p_key
2309: RETURNING num1, num2
2310: BULK COLLECT INTO l_indexes, l_hazard_class_ids;
2311:

Line 2352: -- Key used to access records in PO_SESSION_GT table.

2348: --
2349: --Parameters:
2350: --IN:
2351: --p_key
2352: -- Key used to access records in PO_SESSION_GT table.
2353: --p_lines_rec
2354: -- A record of plsql tables containing a batch of lines.
2355: --OUT:
2356: --x_org_ids

Line 2370: p_key IN PO_SESSION_GT.key%TYPE,

2366: --End of Comments
2367: --------------------------------------------------------------------------------
2368: PROCEDURE default_hdr_info
2369: (
2370: p_key IN PO_SESSION_GT.key%TYPE,
2371: p_lines_rec IN PO_R12_CAT_UPG_PVT.record_of_lines_type,
2372: x_org_ids OUT NOCOPY PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER,
2373: x_vendor_ids OUT NOCOPY PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER,
2374: x_vendor_site_ids OUT NOCOPY PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER,

Line 2409: INSERT INTO po_session_gt(key,

2405: -- SQL What: Default header related info into the session GT table.
2406: -- SQL Why : It will be used to populate the OUT parameters.
2407: -- SQL Join: interface_header_id, po_header_id
2408: FORALL i IN 1 .. p_lines_rec.interface_line_id.COUNT
2409: INSERT INTO po_session_gt(key,
2410: num1,
2411: num2,
2412: num3,
2413: num4,

Line 2438: DELETE FROM po_session_gt

2434: l_progress := '030';
2435: -- SQL What: Transfer from session GT table to local arrays
2436: -- SQL Why : It will be used to populate the OUT parameters.
2437: -- SQL Join: key
2438: DELETE FROM po_session_gt
2439: WHERE key = p_key
2440: RETURNING num1, num2, num3, num4, num5, num6, num7
2441: BULK COLLECT INTO l_indexes, l_org_ids, l_vendor_ids,
2442: l_vendor_site_ids, l_ship_to_location_ids,