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

Line 13: p_key IN po_session_gt.key%TYPE,

9: ---------------------- PRIVATE PROCEDURES PROTOTYPE ----------------------
10: --------------------------------------------------------------------------
11: PROCEDURE derive_rate_type_code
12: (
13: p_key IN po_session_gt.key%TYPE,
14: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,
15: p_rate_type_tbl IN PO_TBL_VARCHAR30,
16: x_rate_type_code_tbl IN OUT NOCOPY PO_TBL_VARCHAR30
17: );

Line 21: p_key IN po_session_gt.key%TYPE,

17: );
18:
19: PROCEDURE derive_agent_id
20: (
21: p_key IN po_session_gt.key%TYPE,
22: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,
23: p_agent_name_tbl IN PO_TBL_VARCHAR2000,
24: x_agent_id_tbl IN OUT NOCOPY PO_TBL_NUMBER
25: );

Line 29: p_key IN po_session_gt.key%TYPE,

25: );
26:
27: PROCEDURE derive_vendor_site_id
28: (
29: p_key IN po_session_gt.key%TYPE,
30: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,
31: p_vendor_id_tbl IN PO_TBL_NUMBER,
32: p_vendor_site_code_tbl IN PO_TBL_VARCHAR30,
33: x_vendor_site_id_tbl IN OUT NOCOPY PO_TBL_NUMBER

Line 38: p_key IN po_session_gt.key%TYPE,

34: );
35:
36: PROCEDURE derive_vendor_contact_id
37: (
38: p_key IN po_session_gt.key%TYPE,
39: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,
40: p_vendor_site_id_tbl IN PO_TBL_NUMBER,
41: p_vendor_contact_tbl IN PO_TBL_VARCHAR2000,
42: x_vendor_contact_id_tbl IN OUT NOCOPY PO_TBL_NUMBER

Line 47: p_key IN po_session_gt.key%TYPE,

43: );
44:
45: PROCEDURE derive_from_header_id
46: (
47: p_key IN po_session_gt.key%TYPE,
48: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,
49: p_from_rfq_num_tbl IN PO_TBL_VARCHAR30,
50: x_from_header_id_tbl IN OUT NOCOPY PO_TBL_NUMBER
51: );

Line 55: p_key IN po_session_gt.key%TYPE,

51: );
52:
53: PROCEDURE derive_style_id
54: (
55: p_key IN po_session_gt.key%TYPE,
56: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,
57: p_style_display_name_tbl IN PO_TBL_VARCHAR2000,
58: x_style_id_tbl IN OUT NOCOPY PO_TBL_NUMBER
59: );

Line 63: p_key IN po_session_gt.key%TYPE,

59: );
60:
61: PROCEDURE default_info_from_vendor
62: (
63: p_key IN po_session_gt.key%TYPE,
64: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,
65: p_vendor_id_tbl IN PO_TBL_NUMBER,
66: x_invoice_currency_code_tbl OUT NOCOPY PO_TBL_VARCHAR30,
67: x_terms_id_tbl OUT NOCOPY PO_TBL_NUMBER

Line 72: p_key IN po_session_gt.key%TYPE,

68: );
69:
70: PROCEDURE default_info_from_vendor_site
71: (
72: p_key IN po_session_gt.key%TYPE,
73: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,
74: p_vendor_id_tbl IN PO_TBL_NUMBER,
75: x_vendor_site_id_tbl IN OUT NOCOPY PO_TBL_NUMBER,
76: x_fob_tbl OUT NOCOPY PO_TBL_VARCHAR30,

Line 89: p_key IN po_session_gt.key%TYPE,

85: );
86:
87: PROCEDURE default_vendor_contact
88: (
89: p_key IN po_session_gt.key%TYPE,
90: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,
91: p_vendor_site_id_tbl IN PO_TBL_NUMBER,
92: x_vendor_contact_id_tbl IN OUT NOCOPY PO_TBL_NUMBER
93: );

Line 510: l_key po_session_gt.key%TYPE;

506: d_module CONSTANT VARCHAR2(255) := d_pkg_name || d_api_name || '.';
507: d_position NUMBER;
508:
509: -- key used when operating on temp table
510: l_key po_session_gt.key%TYPE;
511:
512: -- table used to save the index of the each row
513: l_index_tbl DBMS_SQL.NUMBER_TABLE;
514:

Line 971: l_key po_session_gt.key%TYPE;

967: d_module CONSTANT VARCHAR2(255) := d_pkg_name || d_api_name || '.';
968: d_position NUMBER;
969:
970: -- key used when operating on temp table
971: l_key po_session_gt.key%TYPE;
972:
973: -- table used to save the index of the each row
974: l_index_tbl DBMS_SQL.NUMBER_TABLE;
975:

Line 1704: p_key IN po_session_gt.key%TYPE,

1700: --End of Comments
1701: ------------------------------------------------------------------------
1702: PROCEDURE derive_location_id
1703: (
1704: p_key IN po_session_gt.key%TYPE,
1705: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,
1706: p_location_type IN VARCHAR2,
1707: p_location_tbl IN PO_TBL_VARCHAR100,
1708: x_location_id_tbl IN OUT NOCOPY PO_TBL_NUMBER

Line 1729: INSERT INTO po_session_gt(key, num1, num2)

1725: END IF;
1726:
1727: IF (p_location_type = 'SHIP_TO') THEN
1728: FORALL i IN 1..p_index_tbl.COUNT
1729: INSERT INTO po_session_gt(key, num1, num2)
1730: SELECT p_key,
1731: p_index_tbl(i),
1732: location_id
1733: FROM po_locations_val_v

Line 1740: INSERT INTO po_session_gt(key, num1, num2)

1736: AND location_code = p_location_tbl(i)
1737: AND nvl(ship_to_site_flag, 'N') = 'Y';
1738: ELSE -- p_location_type = 'BILL_TO'
1739: FORALL i IN 1..p_index_tbl.COUNT
1740: INSERT INTO po_session_gt(key, num1, num2)
1741: SELECT p_key,
1742: p_index_tbl(i),
1743: location_id
1744: FROM po_locations_val_v

Line 1753: DELETE FROM po_session_gt

1749: END IF;
1750:
1751: d_position := 10;
1752:
1753: DELETE FROM po_session_gt
1754: WHERE key = p_key
1755: RETURNING num1, num2 BULK COLLECT INTO l_index_tbl, l_result_tbl;
1756:
1757: d_position := 20;

Line 1811: p_key IN po_session_gt.key%TYPE,

1807: --End of Comments
1808: ------------------------------------------------------------------------
1809: PROCEDURE derive_terms_id
1810: (
1811: p_key IN po_session_gt.key%TYPE,
1812: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,
1813: p_payment_terms_tbl IN PO_TBL_VARCHAR100,
1814: x_terms_id_tbl IN OUT NOCOPY PO_TBL_NUMBER
1815: ) IS

Line 1833: INSERT INTO po_session_gt(key, num1, num2)

1829: PO_LOG.proc_begin(d_module, 'terms ids', x_terms_id_tbl);
1830: END IF;
1831:
1832: FORALL i IN 1..p_index_tbl.COUNT
1833: INSERT INTO po_session_gt(key, num1, num2)
1834: SELECT p_key,
1835: p_index_tbl(i),
1836: term_id
1837: FROM ap_terms

Line 1847: DELETE FROM po_session_gt

1843: AND TRUNC(nvl(end_date_active, sysdate));
1844:
1845: d_position := 10;
1846:
1847: DELETE FROM po_session_gt
1848: WHERE key = p_key
1849: RETURNING num1, num2 BULK COLLECT INTO l_index_tbl, l_result_tbl;
1850:
1851: d_position := 20;

Line 1908: p_key IN po_session_gt.key%TYPE,

1904: --End of Comments
1905: ------------------------------------------------------------------------
1906: PROCEDURE derive_vendor_id
1907: (
1908: p_key IN po_session_gt.key%TYPE,
1909: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,
1910: p_vendor_name_tbl IN PO_TBL_VARCHAR2000,
1911: p_vendor_num_tbl IN PO_TBL_VARCHAR30,
1912: x_vendor_id_tbl IN OUT NOCOPY PO_TBL_NUMBER

Line 1935: INSERT INTO po_session_gt(key, num1, num2)

1931: PO_LOG.proc_begin(d_module, 'vendor ids', x_vendor_id_tbl);
1932: END IF;
1933:
1934: FORALL i IN 1..p_index_tbl.COUNT
1935: INSERT INTO po_session_gt(key, num1, num2)
1936: SELECT p_key,
1937: p_index_tbl(i),
1938: vendor_id
1939: FROM po_vendors

Line 1947: DELETE FROM po_session_gt

1943: segment1 = p_vendor_num_tbl(i));
1944:
1945: d_position := 10;
1946:
1947: DELETE FROM po_session_gt
1948: WHERE key = p_key
1949: RETURNING num1, num2 BULK COLLECT INTO l_index_tbl, l_result_tbl;
1950:
1951: d_position := 20;

Line 2020: p_key IN po_session_gt.key%TYPE,

2016: --End of Comments
2017: ------------------------------------------------------------------------
2018: PROCEDURE derive_rate_type_code
2019: (
2020: p_key IN po_session_gt.key%TYPE,
2021: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,
2022: p_rate_type_tbl IN PO_TBL_VARCHAR30,
2023: x_rate_type_code_tbl IN OUT NOCOPY PO_TBL_VARCHAR30
2024: ) IS

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

2038: PO_LOG.proc_begin(d_module, 'rate type code', x_rate_type_code_tbl);
2039: END IF;
2040:
2041: FORALL i IN 1..p_index_tbl.COUNT
2042: INSERT INTO po_session_gt(key, num1, char1)
2043: SELECT p_key,
2044: p_index_tbl(i),
2045: conversion_type
2046: FROM gl_daily_conversion_types

Line 2053: DELETE FROM po_session_gt

2049: AND user_conversion_type = p_rate_type_tbl(i);
2050:
2051: d_position := 10;
2052:
2053: DELETE FROM po_session_gt
2054: WHERE key = p_key
2055: RETURNING num1, char1 BULK COLLECT INTO l_index_tbl, l_result_tbl;
2056:
2057: d_position := 20;

Line 2111: p_key IN po_session_gt.key%TYPE,

2107: --End of Comments
2108: ------------------------------------------------------------------------
2109: PROCEDURE derive_agent_id
2110: (
2111: p_key IN po_session_gt.key%TYPE,
2112: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,
2113: p_agent_name_tbl IN PO_TBL_VARCHAR2000,
2114: x_agent_id_tbl IN OUT NOCOPY PO_TBL_NUMBER
2115: ) IS

Line 2133: INSERT INTO po_session_gt(key, num1, num2)

2129: PO_LOG.proc_begin(d_module, 'agent id', x_agent_id_tbl);
2130: END IF;
2131:
2132: FORALL i IN 1..p_index_tbl.COUNT
2133: INSERT INTO po_session_gt(key, num1, num2)
2134: SELECT p_key,
2135: p_index_tbl(i),
2136: employee_id
2137: FROM po_buyers_val_v

Line 2144: DELETE FROM po_session_gt

2140: AND full_name = p_agent_name_tbl(i);
2141:
2142: d_position := 10;
2143:
2144: DELETE FROM po_session_gt
2145: WHERE key = p_key
2146: RETURNING num1, num2 BULK COLLECT INTO l_index_tbl, l_result_tbl;
2147:
2148: d_position := 20;

Line 2204: p_key IN po_session_gt.key%TYPE,

2200: --End of Comments
2201: ------------------------------------------------------------------------
2202: PROCEDURE derive_vendor_site_id
2203: (
2204: p_key IN po_session_gt.key%TYPE,
2205: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,
2206: p_vendor_id_tbl IN PO_TBL_NUMBER,
2207: p_vendor_site_code_tbl IN PO_TBL_VARCHAR30,
2208: x_vendor_site_id_tbl IN OUT NOCOPY PO_TBL_NUMBER

Line 2228: INSERT INTO po_session_gt(key, num1, num2)

2224: PO_LOG.proc_begin(d_module, 'site id', x_vendor_site_id_tbl);
2225: END IF;
2226:
2227: FORALL i IN 1..p_index_tbl.COUNT
2228: INSERT INTO po_session_gt(key, num1, num2)
2229: SELECT p_key,
2230: p_index_tbl(i),
2231: vendor_site_id
2232: FROM po_supplier_sites_val_v

Line 2241: DELETE FROM po_session_gt

2237: AND vendor_site_code = p_vendor_site_code_tbl(i);
2238:
2239: d_position := 10;
2240:
2241: DELETE FROM po_session_gt
2242: WHERE key = p_key
2243: RETURNING num1, num2 BULK COLLECT INTO l_index_tbl, l_result_tbl;
2244:
2245: d_position := 20;

Line 2302: p_key IN po_session_gt.key%TYPE,

2298: --End of Comments
2299: ------------------------------------------------------------------------
2300: PROCEDURE derive_vendor_contact_id
2301: (
2302: p_key IN po_session_gt.key%TYPE,
2303: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,
2304: p_vendor_site_id_tbl IN PO_TBL_NUMBER,
2305: p_vendor_contact_tbl IN PO_TBL_VARCHAR2000,
2306: x_vendor_contact_id_tbl IN OUT NOCOPY PO_TBL_NUMBER

Line 2326: INSERT INTO po_session_gt(key, num1, num2)

2322: PO_LOG.proc_begin(d_module, 'contact id', x_vendor_contact_id_tbl);
2323: END IF;
2324:
2325: FORALL i IN 1..p_index_tbl.COUNT
2326: INSERT INTO po_session_gt(key, num1, num2)
2327: SELECT p_key,
2328: p_index_tbl(i),
2329: vendor_contact_id
2330: FROM po_vendor_contacts

Line 2339: DELETE FROM po_session_gt

2335: AND vendor_site_id = p_vendor_site_id_tbl(i);
2336:
2337: d_position := 10;
2338:
2339: DELETE FROM po_session_gt
2340: WHERE key = p_key
2341: RETURNING num1, num2 BULK COLLECT INTO l_index_tbl, l_result_tbl;
2342:
2343: d_position := 20;

Line 2401: p_key IN po_session_gt.key%TYPE,

2397: --End of Comments
2398: ------------------------------------------------------------------------
2399: PROCEDURE derive_style_id
2400: (
2401: p_key IN po_session_gt.key%TYPE,
2402: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,
2403: p_style_display_name_tbl IN PO_TBL_VARCHAR2000,
2404: x_style_id_tbl IN OUT NOCOPY PO_TBL_NUMBER
2405: ) IS

Line 2423: INSERT INTO po_session_gt(key, num1, num2)

2419: PO_LOG.proc_begin(d_module, 'p_style_display_name_tbl', p_style_display_name_tbl);
2420: END IF;
2421:
2422: FORALL i IN 1..p_index_tbl.COUNT
2423: INSERT INTO po_session_gt(key, num1, num2)
2424: SELECT p_key,
2425: p_index_tbl(i),
2426: style_id
2427: FROM po_doc_style_lines_tl pds

Line 2434: DELETE FROM po_session_gt

2430: pds.LANGUAGE = USERENV('LANG');
2431:
2432: d_position := 10;
2433:
2434: DELETE FROM po_session_gt
2435: WHERE key = p_key
2436: RETURNING num1, num2 BULK COLLECT INTO l_index_tbl, l_result_tbl;
2437:
2438: d_position := 20;

Line 2493: p_key IN po_session_gt.key%TYPE,

2489: --End of Comments
2490: ------------------------------------------------------------------------
2491: PROCEDURE derive_from_header_id
2492: (
2493: p_key IN po_session_gt.key%TYPE,
2494: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,
2495: p_from_rfq_num_tbl IN PO_TBL_VARCHAR30,
2496: x_from_header_id_tbl IN OUT NOCOPY PO_TBL_NUMBER
2497: ) IS

Line 2515: INSERT INTO po_session_gt(key, num1, num2)

2511: PO_LOG.proc_begin(d_module, 'from header id', x_from_header_id_tbl);
2512: END IF;
2513:
2514: FORALL i IN 1..p_index_tbl.COUNT
2515: INSERT INTO po_session_gt(key, num1, num2)
2516: SELECT p_key,
2517: p_index_tbl(i),
2518: po_header_id
2519: FROM po_headers

Line 2527: DELETE FROM po_session_gt

2523: AND type_lookup_code = 'RFQ'; -- PO_PDOI_CONSTANTS.g_DOC_TYPE_RFQ;
2524:
2525: d_position := 10;
2526:
2527: DELETE FROM po_session_gt
2528: WHERE key = p_key
2529: RETURNING num1, num2 BULK COLLECT INTO l_index_tbl, l_result_tbl;
2530:
2531: d_position := 20;

Line 2588: p_key IN po_session_gt.key%TYPE,

2584: --End of Comments
2585: ------------------------------------------------------------------------
2586: PROCEDURE default_info_from_vendor
2587: (
2588: p_key IN po_session_gt.key%TYPE,
2589: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,
2590: p_vendor_id_tbl IN PO_TBL_NUMBER,
2591: x_invoice_currency_code_tbl OUT NOCOPY PO_TBL_VARCHAR30,
2592: x_terms_id_tbl OUT NOCOPY PO_TBL_NUMBER

Line 2631: INSERT INTO po_session_gt(

2627: x_invoice_currency_code_tbl.EXTEND(p_index_tbl.COUNT);
2628: x_terms_id_tbl.EXTEND(p_index_tbl.COUNT);
2629:
2630: FORALL i IN 1..p_index_tbl.COUNT
2631: INSERT INTO po_session_gt(
2632: key, num1, char1, num2)
2633: SELECT p_key,
2634: p_index_tbl(i),
2635: invoice_currency_code,

Line 2642: DELETE FROM po_session_gt

2638: WHERE vendor_id = p_vendor_id_tbl(i);
2639:
2640: d_position := 10;
2641:
2642: DELETE FROM po_session_gt
2643: WHERE key = p_key
2644: RETURNING num1, char1, num2
2645: BULK COLLECT INTO
2646: l_index_tbl,

Line 2735: p_key IN po_session_gt.key%TYPE,

2731: --End of Comments
2732: ------------------------------------------------------------------------
2733: PROCEDURE default_info_from_vendor_site
2734: (
2735: p_key IN po_session_gt.key%TYPE,
2736: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,
2737: p_vendor_id_tbl IN PO_TBL_NUMBER,
2738: x_vendor_site_id_tbl IN OUT NOCOPY PO_TBL_NUMBER,
2739: x_fob_tbl OUT NOCOPY PO_TBL_VARCHAR30,

Line 2802: INSERT INTO po_session_gt(key, num1, num2, num3)

2798: d_position := 10;
2799:
2800: -- default vendor_site_id if it is empty
2801: FORALL i IN 1..p_index_tbl.COUNT
2802: INSERT INTO po_session_gt(key, num1, num2, num3)
2803: SELECT p_key,
2804: p_index_tbl(i),
2805: min(vendor_site_id),
2806: vendor_id

Line 2821: DELETE FROM po_session_gt

2817: HAVING count(vendor_site_id) = 1;
2818:
2819: d_position := 20;
2820:
2821: DELETE FROM po_session_gt
2822: WHERE key = p_key
2823: RETURNING num1, num2 BULK COLLECT INTO l_index_tbl, l_vendor_site_id_tbl;
2824:
2825: FOR i IN 1..l_index_tbl.COUNT

Line 2840: INSERT INTO po_session_gt(

2836:
2837: -- default other attributes from site definition
2838: -- to do (add char6 to gt table?)
2839: FORALL i IN 1..p_index_tbl.COUNT
2840: INSERT INTO po_session_gt(
2841: key, num1, char1, char2, char3, num2, num3, char4, num4, char5, char6)
2842: SELECT p_key,
2843: p_index_tbl(i),
2844: fob_lookup_code,

Line 2858: DELETE FROM po_session_gt

2854: WHERE vendor_site_id = x_vendor_site_id_tbl(i);
2855:
2856: d_position := 40;
2857:
2858: DELETE FROM po_session_gt
2859: WHERE key = p_key
2860: RETURNING num1, char1, char2, char3, num2, num3, char4, num4, char5, char6
2861: BULK COLLECT INTO
2862: l_index_tbl,

Line 2948: p_key IN po_session_gt.key%TYPE,

2944: --End of Comments
2945: ------------------------------------------------------------------------
2946: PROCEDURE default_vendor_contact
2947: (
2948: p_key IN po_session_gt.key%TYPE,
2949: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,
2950: p_vendor_site_id_tbl IN PO_TBL_NUMBER,
2951: x_vendor_contact_id_tbl IN OUT NOCOPY PO_TBL_NUMBER
2952: ) IS

Line 2973: INSERT INTO po_session_gt(key, num1, num2, num3)

2969:
2970: -- select contact id from vendor_site table if there is only
2971: -- one contact defined on that site
2972: FORALL i IN 1..p_index_tbl.COUNT
2973: INSERT INTO po_session_gt(key, num1, num2, num3)
2974: SELECT p_key,
2975: p_index_tbl(i),
2976: max(vendor_contact_id),
2977: vendor_site_id

Line 2988: DELETE FROM po_session_gt

2984: HAVING count(vendor_contact_id) = 1;
2985:
2986: d_position := 10;
2987:
2988: DELETE FROM po_session_gt
2989: WHERE key = p_key
2990: RETURNING num1, num2 BULK COLLECT INTO l_index_tbl, l_result_tbl;
2991:
2992: d_position := 20;