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_TBL_NUMBER

Line 24: x_agent_id_tbl IN OUT NOCOPY PO_TBL_NUMBER

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: );
26:
27: PROCEDURE derive_vendor_site_id
28: (

Line 31: p_vendor_id_tbl IN PO_TBL_NUMBER,

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
34: );
35:

Line 33: x_vendor_site_id_tbl IN OUT NOCOPY PO_TBL_NUMBER

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
34: );
35:
36: PROCEDURE derive_vendor_contact_id
37: (

Line 40: p_vendor_site_id_tbl IN PO_TBL_NUMBER,

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
43: );
44:

Line 42: x_vendor_contact_id_tbl IN OUT NOCOPY PO_TBL_NUMBER

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
43: );
44:
45: PROCEDURE derive_from_header_id
46: (

Line 50: x_from_header_id_tbl IN OUT NOCOPY PO_TBL_NUMBER

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: );
52:
53: PROCEDURE derive_style_id
54: (

Line 58: x_style_id_tbl IN OUT NOCOPY PO_TBL_NUMBER

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: );
60:
61: PROCEDURE default_info_from_vendor
62: (

Line 65: p_vendor_id_tbl IN PO_TBL_NUMBER,

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
68: );
69:

Line 67: x_terms_id_tbl OUT NOCOPY PO_TBL_NUMBER

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
68: );
69:
70: PROCEDURE default_info_from_vendor_site
71: (

Line 74: p_vendor_id_tbl IN PO_TBL_NUMBER,

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,
77: x_freight_carrier_tbl OUT NOCOPY PO_TBL_VARCHAR30,
78: x_freight_term_tbl OUT NOCOPY PO_TBL_VARCHAR30,

Line 75: x_vendor_site_id_tbl IN OUT NOCOPY PO_TBL_NUMBER,

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,
77: x_freight_carrier_tbl OUT NOCOPY PO_TBL_VARCHAR30,
78: x_freight_term_tbl OUT NOCOPY PO_TBL_VARCHAR30,
79: x_ship_to_loc_id_tbl OUT NOCOPY PO_TBL_NUMBER,

Line 79: x_ship_to_loc_id_tbl OUT NOCOPY PO_TBL_NUMBER,

75: x_vendor_site_id_tbl IN OUT NOCOPY PO_TBL_NUMBER,
76: x_fob_tbl OUT NOCOPY PO_TBL_VARCHAR30,
77: x_freight_carrier_tbl OUT NOCOPY PO_TBL_VARCHAR30,
78: x_freight_term_tbl OUT NOCOPY PO_TBL_VARCHAR30,
79: x_ship_to_loc_id_tbl OUT NOCOPY PO_TBL_NUMBER,
80: x_bill_to_loc_id_tbl OUT NOCOPY PO_TBL_NUMBER,
81: x_invoice_currency_code_tbl OUT NOCOPY PO_TBL_VARCHAR30,
82: x_terms_id_tbl OUT NOCOPY PO_TBL_NUMBER,
83: x_shipping_control_tbl OUT NOCOPY PO_TBL_VARCHAR30,

Line 80: x_bill_to_loc_id_tbl OUT NOCOPY PO_TBL_NUMBER,

76: x_fob_tbl OUT NOCOPY PO_TBL_VARCHAR30,
77: x_freight_carrier_tbl OUT NOCOPY PO_TBL_VARCHAR30,
78: x_freight_term_tbl OUT NOCOPY PO_TBL_VARCHAR30,
79: x_ship_to_loc_id_tbl OUT NOCOPY PO_TBL_NUMBER,
80: x_bill_to_loc_id_tbl OUT NOCOPY PO_TBL_NUMBER,
81: x_invoice_currency_code_tbl OUT NOCOPY PO_TBL_VARCHAR30,
82: x_terms_id_tbl OUT NOCOPY PO_TBL_NUMBER,
83: x_shipping_control_tbl OUT NOCOPY PO_TBL_VARCHAR30,
84: x_pay_on_code_tbl OUT NOCOPY PO_TBL_VARCHAR30

Line 82: x_terms_id_tbl OUT NOCOPY PO_TBL_NUMBER,

78: x_freight_term_tbl OUT NOCOPY PO_TBL_VARCHAR30,
79: x_ship_to_loc_id_tbl OUT NOCOPY PO_TBL_NUMBER,
80: x_bill_to_loc_id_tbl OUT NOCOPY PO_TBL_NUMBER,
81: x_invoice_currency_code_tbl OUT NOCOPY PO_TBL_VARCHAR30,
82: x_terms_id_tbl OUT NOCOPY PO_TBL_NUMBER,
83: x_shipping_control_tbl OUT NOCOPY PO_TBL_VARCHAR30,
84: x_pay_on_code_tbl OUT NOCOPY PO_TBL_VARCHAR30
85: );
86:

Line 91: p_vendor_site_id_tbl IN PO_TBL_NUMBER,

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: );
94:
95: PROCEDURE default_dist_attributes

Line 92: x_vendor_contact_id_tbl IN OUT NOCOPY PO_TBL_NUMBER

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: );
94:
95: PROCEDURE default_dist_attributes
96: (

Line 983: --l_vendor_ship_to_loc_id_tbl PO_TBL_NUMBER;

979: -- The following columns are being obsoleted from PO_VENDORS level.
980: --l_vendor_fob_tbl PO_TBL_VARCHAR30;
981: --l_vendor_freight_carrier_tbl PO_TBL_VARCHAR30;
982: --l_vendor_freight_term_tbl PO_TBL_VARCHAR30;
983: --l_vendor_ship_to_loc_id_tbl PO_TBL_NUMBER;
984: --l_vendor_bill_to_loc_id_tbl PO_TBL_NUMBER;
985:
986: l_vendor_invoice_curr_code_tbl PO_TBL_VARCHAR30;
987: l_vendor_terms_id_tbl PO_TBL_NUMBER;

Line 984: --l_vendor_bill_to_loc_id_tbl PO_TBL_NUMBER;

980: --l_vendor_fob_tbl PO_TBL_VARCHAR30;
981: --l_vendor_freight_carrier_tbl PO_TBL_VARCHAR30;
982: --l_vendor_freight_term_tbl PO_TBL_VARCHAR30;
983: --l_vendor_ship_to_loc_id_tbl PO_TBL_NUMBER;
984: --l_vendor_bill_to_loc_id_tbl PO_TBL_NUMBER;
985:
986: l_vendor_invoice_curr_code_tbl PO_TBL_VARCHAR30;
987: l_vendor_terms_id_tbl PO_TBL_NUMBER;
988:

Line 987: l_vendor_terms_id_tbl PO_TBL_NUMBER;

983: --l_vendor_ship_to_loc_id_tbl PO_TBL_NUMBER;
984: --l_vendor_bill_to_loc_id_tbl PO_TBL_NUMBER;
985:
986: l_vendor_invoice_curr_code_tbl PO_TBL_VARCHAR30;
987: l_vendor_terms_id_tbl PO_TBL_NUMBER;
988:
989: -- information defaulted from vendor site
990: l_site_fob_tbl PO_TBL_VARCHAR30;
991: l_site_freight_carrier_tbl PO_TBL_VARCHAR30;

Line 993: l_site_ship_to_loc_id_tbl PO_TBL_NUMBER;

989: -- information defaulted from vendor site
990: l_site_fob_tbl PO_TBL_VARCHAR30;
991: l_site_freight_carrier_tbl PO_TBL_VARCHAR30;
992: l_site_freight_term_tbl PO_TBL_VARCHAR30;
993: l_site_ship_to_loc_id_tbl PO_TBL_NUMBER;
994: l_site_bill_to_loc_id_tbl PO_TBL_NUMBER;
995: l_site_invoice_curr_code_tbl PO_TBL_VARCHAR30;
996: l_site_terms_id_tbl PO_TBL_NUMBER;
997: l_site_shipping_control_tbl PO_TBL_VARCHAR30;

Line 994: l_site_bill_to_loc_id_tbl PO_TBL_NUMBER;

990: l_site_fob_tbl PO_TBL_VARCHAR30;
991: l_site_freight_carrier_tbl PO_TBL_VARCHAR30;
992: l_site_freight_term_tbl PO_TBL_VARCHAR30;
993: l_site_ship_to_loc_id_tbl PO_TBL_NUMBER;
994: l_site_bill_to_loc_id_tbl PO_TBL_NUMBER;
995: l_site_invoice_curr_code_tbl PO_TBL_VARCHAR30;
996: l_site_terms_id_tbl PO_TBL_NUMBER;
997: l_site_shipping_control_tbl PO_TBL_VARCHAR30;
998: l_site_pay_on_code_tbl PO_TBL_VARCHAR30;

Line 996: l_site_terms_id_tbl PO_TBL_NUMBER;

992: l_site_freight_term_tbl PO_TBL_VARCHAR30;
993: l_site_ship_to_loc_id_tbl PO_TBL_NUMBER;
994: l_site_bill_to_loc_id_tbl PO_TBL_NUMBER;
995: l_site_invoice_curr_code_tbl PO_TBL_VARCHAR30;
996: l_site_terms_id_tbl PO_TBL_NUMBER;
997: l_site_shipping_control_tbl PO_TBL_VARCHAR30;
998: l_site_pay_on_code_tbl PO_TBL_VARCHAR30;
999:
1000: l_lang VARCHAR2(4);

Line 1708: x_location_id_tbl IN OUT NOCOPY PO_TBL_NUMBER

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
1709: ) IS
1710:
1711: d_api_name CONSTANT VARCHAR2(30) := 'derive_location_id';
1712: d_module CONSTANT VARCHAR2(255) := d_pkg_name || d_api_name || '.';

Line 1716: l_index_tbl PO_TBL_NUMBER;

1712: d_module CONSTANT VARCHAR2(255) := d_pkg_name || d_api_name || '.';
1713: d_position NUMBER;
1714:
1715: -- tables to store the derived result
1716: l_index_tbl PO_TBL_NUMBER;
1717: l_result_tbl PO_TBL_NUMBER;
1718: BEGIN
1719: d_position := 0;
1720:

Line 1717: l_result_tbl PO_TBL_NUMBER;

1713: d_position NUMBER;
1714:
1715: -- tables to store the derived result
1716: l_index_tbl PO_TBL_NUMBER;
1717: l_result_tbl PO_TBL_NUMBER;
1718: BEGIN
1719: d_position := 0;
1720:
1721: IF (PO_LOG.d_proc) THEN

Line 1814: x_terms_id_tbl IN OUT NOCOPY PO_TBL_NUMBER

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
1816:
1817: d_api_name CONSTANT VARCHAR2(30) := 'derive_terms_id';
1818: d_module CONSTANT VARCHAR2(255) := d_pkg_name || d_api_name || '.';

Line 1822: l_index_tbl PO_TBL_NUMBER;

1818: d_module CONSTANT VARCHAR2(255) := d_pkg_name || d_api_name || '.';
1819: d_position NUMBER;
1820:
1821: -- tables to store the derived result
1822: l_index_tbl PO_TBL_NUMBER;
1823: l_result_tbl PO_TBL_NUMBER;
1824: BEGIN
1825: d_position := 0;
1826:

Line 1823: l_result_tbl PO_TBL_NUMBER;

1819: d_position NUMBER;
1820:
1821: -- tables to store the derived result
1822: l_index_tbl PO_TBL_NUMBER;
1823: l_result_tbl PO_TBL_NUMBER;
1824: BEGIN
1825: d_position := 0;
1826:
1827: IF (PO_LOG.d_proc) THEN

Line 1912: x_vendor_id_tbl IN OUT NOCOPY PO_TBL_NUMBER

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
1913: ) IS
1914:
1915: d_api_name CONSTANT VARCHAR2(30) := 'derive_vendor_id';
1916: d_module CONSTANT VARCHAR2(255) := d_pkg_name || d_api_name || '.';

Line 1920: l_index_tbl PO_TBL_NUMBER;

1916: d_module CONSTANT VARCHAR2(255) := d_pkg_name || d_api_name || '.';
1917: d_position NUMBER;
1918:
1919: -- tables to store the derived result
1920: l_index_tbl PO_TBL_NUMBER;
1921: l_result_tbl PO_TBL_NUMBER;
1922:
1923: -- variable to hold the current index of the row processed
1924: l_index NUMBER;

Line 1921: l_result_tbl PO_TBL_NUMBER;

1917: d_position NUMBER;
1918:
1919: -- tables to store the derived result
1920: l_index_tbl PO_TBL_NUMBER;
1921: l_result_tbl PO_TBL_NUMBER;
1922:
1923: -- variable to hold the current index of the row processed
1924: l_index NUMBER;
1925: BEGIN

Line 2031: l_index_tbl PO_TBL_NUMBER;

2027: d_module CONSTANT VARCHAR2(255) := d_pkg_name || d_api_name || '.';
2028: d_position NUMBER;
2029:
2030: -- tables to store the derived result
2031: l_index_tbl PO_TBL_NUMBER;
2032: l_result_tbl PO_TBL_VARCHAR30;
2033: BEGIN
2034: d_position := 0;
2035:

Line 2114: x_agent_id_tbl IN OUT NOCOPY PO_TBL_NUMBER

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
2116:
2117: d_api_name CONSTANT VARCHAR2(30) := 'derive_agent_id';
2118: d_module CONSTANT VARCHAR2(255) := d_pkg_name || d_api_name || '.';

Line 2122: l_index_tbl PO_TBL_NUMBER;

2118: d_module CONSTANT VARCHAR2(255) := d_pkg_name || d_api_name || '.';
2119: d_position NUMBER;
2120:
2121: -- tables to store the derived result
2122: l_index_tbl PO_TBL_NUMBER;
2123: l_result_tbl PO_TBL_NUMBER;
2124: BEGIN
2125: d_position := 0;
2126:

Line 2123: l_result_tbl PO_TBL_NUMBER;

2119: d_position NUMBER;
2120:
2121: -- tables to store the derived result
2122: l_index_tbl PO_TBL_NUMBER;
2123: l_result_tbl PO_TBL_NUMBER;
2124: BEGIN
2125: d_position := 0;
2126:
2127: IF (PO_LOG.d_proc) THEN

Line 2206: p_vendor_id_tbl IN PO_TBL_NUMBER,

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
2209: ) IS
2210:

Line 2208: x_vendor_site_id_tbl IN OUT NOCOPY PO_TBL_NUMBER

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
2209: ) IS
2210:
2211: d_api_name CONSTANT VARCHAR2(30) := 'derive_vendor_site_id';
2212: d_module CONSTANT VARCHAR2(255) := d_pkg_name || d_api_name || '.';

Line 2216: l_index_tbl PO_TBL_NUMBER;

2212: d_module CONSTANT VARCHAR2(255) := d_pkg_name || d_api_name || '.';
2213: d_position NUMBER;
2214:
2215: -- tables to store the derived result
2216: l_index_tbl PO_TBL_NUMBER;
2217: l_result_tbl PO_TBL_NUMBER;
2218: BEGIN
2219: d_position := 0;
2220:

Line 2217: l_result_tbl PO_TBL_NUMBER;

2213: d_position NUMBER;
2214:
2215: -- tables to store the derived result
2216: l_index_tbl PO_TBL_NUMBER;
2217: l_result_tbl PO_TBL_NUMBER;
2218: BEGIN
2219: d_position := 0;
2220:
2221: IF (PO_LOG.d_proc) THEN

Line 2304: p_vendor_site_id_tbl IN PO_TBL_NUMBER,

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
2307: ) IS
2308:

Line 2306: x_vendor_contact_id_tbl IN OUT NOCOPY PO_TBL_NUMBER

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
2307: ) IS
2308:
2309: d_api_name CONSTANT VARCHAR2(30) := 'derive_vendor_contact_id';
2310: d_module CONSTANT VARCHAR2(255) := d_pkg_name || d_api_name || '.';

Line 2314: l_index_tbl PO_TBL_NUMBER;

2310: d_module CONSTANT VARCHAR2(255) := d_pkg_name || d_api_name || '.';
2311: d_position NUMBER;
2312:
2313: -- tables to store the derived result
2314: l_index_tbl PO_TBL_NUMBER;
2315: l_result_tbl PO_TBL_NUMBER;
2316: BEGIN
2317: d_position := 0;
2318:

Line 2315: l_result_tbl PO_TBL_NUMBER;

2311: d_position NUMBER;
2312:
2313: -- tables to store the derived result
2314: l_index_tbl PO_TBL_NUMBER;
2315: l_result_tbl PO_TBL_NUMBER;
2316: BEGIN
2317: d_position := 0;
2318:
2319: IF (PO_LOG.d_proc) THEN

Line 2404: x_style_id_tbl IN OUT NOCOPY PO_TBL_NUMBER

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
2406:
2407: d_api_name CONSTANT VARCHAR2(30) := 'derive_style_id';
2408: d_module CONSTANT VARCHAR2(255) := d_pkg_name || d_api_name || '.';

Line 2412: l_index_tbl PO_TBL_NUMBER;

2408: d_module CONSTANT VARCHAR2(255) := d_pkg_name || d_api_name || '.';
2409: d_position NUMBER;
2410:
2411: -- tables to store the derived result
2412: l_index_tbl PO_TBL_NUMBER;
2413: l_result_tbl PO_TBL_NUMBER;
2414: BEGIN
2415: d_position := 0;
2416:

Line 2413: l_result_tbl PO_TBL_NUMBER;

2409: d_position NUMBER;
2410:
2411: -- tables to store the derived result
2412: l_index_tbl PO_TBL_NUMBER;
2413: l_result_tbl PO_TBL_NUMBER;
2414: BEGIN
2415: d_position := 0;
2416:
2417: IF (PO_LOG.d_proc) THEN

Line 2496: x_from_header_id_tbl IN OUT NOCOPY PO_TBL_NUMBER

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
2498:
2499: d_api_name CONSTANT VARCHAR2(30) := 'derive_from_header_id';
2500: d_module CONSTANT VARCHAR2(255) := d_pkg_name || d_api_name || '.';

Line 2504: l_index_tbl PO_TBL_NUMBER;

2500: d_module CONSTANT VARCHAR2(255) := d_pkg_name || d_api_name || '.';
2501: d_position NUMBER;
2502:
2503: -- tables to store the derived result
2504: l_index_tbl PO_TBL_NUMBER;
2505: l_result_tbl PO_TBL_NUMBER;
2506: BEGIN
2507: d_position := 0;
2508:

Line 2505: l_result_tbl PO_TBL_NUMBER;

2501: d_position NUMBER;
2502:
2503: -- tables to store the derived result
2504: l_index_tbl PO_TBL_NUMBER;
2505: l_result_tbl PO_TBL_NUMBER;
2506: BEGIN
2507: d_position := 0;
2508:
2509: IF (PO_LOG.d_proc) THEN

Line 2590: p_vendor_id_tbl IN PO_TBL_NUMBER,

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
2593: ) IS
2594:

Line 2592: x_terms_id_tbl OUT NOCOPY PO_TBL_NUMBER

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
2593: ) IS
2594:
2595: d_api_name CONSTANT VARCHAR2(30) := 'default_info_from_vendor';
2596: d_module CONSTANT VARCHAR2(255) := d_pkg_name || d_api_name || '.';

Line 2600: l_index_tbl PO_TBL_NUMBER;

2596: d_module CONSTANT VARCHAR2(255) := d_pkg_name || d_api_name || '.';
2597: d_position NUMBER;
2598:
2599: -- variables to hold values read from vendor definition
2600: l_index_tbl PO_TBL_NUMBER;
2601: l_currency_code_tbl PO_TBL_VARCHAR30;
2602: l_terms_id_tbl PO_TBL_NUMBER;
2603:
2604: -- variable to hold index of the current processing row

Line 2602: l_terms_id_tbl PO_TBL_NUMBER;

2598:
2599: -- variables to hold values read from vendor definition
2600: l_index_tbl PO_TBL_NUMBER;
2601: l_currency_code_tbl PO_TBL_VARCHAR30;
2602: l_terms_id_tbl PO_TBL_NUMBER;
2603:
2604: -- variable to hold index of the current processing row
2605: l_index NUMBER;
2606:

Line 2621: --x_ship_to_loc_id_tbl := PO_TBL_NUMBER();

2617: -- The following columns are being obsoleted from PO_VENDORS level
2618: --x_fob_tbl := PO_TBL_VARCHAR30();
2619: --x_freight_carrier_tbl := PO_TBL_VARCHAR30();
2620: --x_freight_term_tbl := PO_TBL_VARCHAR30();
2621: --x_ship_to_loc_id_tbl := PO_TBL_NUMBER();
2622: --x_bill_to_loc_id_tbl := PO_TBL_NUMBER();
2623:
2624: x_invoice_currency_code_tbl := PO_TBL_VARCHAR30();
2625: x_terms_id_tbl := PO_TBL_NUMBER();

Line 2622: --x_bill_to_loc_id_tbl := PO_TBL_NUMBER();

2618: --x_fob_tbl := PO_TBL_VARCHAR30();
2619: --x_freight_carrier_tbl := PO_TBL_VARCHAR30();
2620: --x_freight_term_tbl := PO_TBL_VARCHAR30();
2621: --x_ship_to_loc_id_tbl := PO_TBL_NUMBER();
2622: --x_bill_to_loc_id_tbl := PO_TBL_NUMBER();
2623:
2624: x_invoice_currency_code_tbl := PO_TBL_VARCHAR30();
2625: x_terms_id_tbl := PO_TBL_NUMBER();
2626:

Line 2625: x_terms_id_tbl := PO_TBL_NUMBER();

2621: --x_ship_to_loc_id_tbl := PO_TBL_NUMBER();
2622: --x_bill_to_loc_id_tbl := PO_TBL_NUMBER();
2623:
2624: x_invoice_currency_code_tbl := PO_TBL_VARCHAR30();
2625: x_terms_id_tbl := PO_TBL_NUMBER();
2626:
2627: x_invoice_currency_code_tbl.EXTEND(p_index_tbl.COUNT);
2628: x_terms_id_tbl.EXTEND(p_index_tbl.COUNT);
2629:

Line 2737: p_vendor_id_tbl IN PO_TBL_NUMBER,

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,
2740: x_freight_carrier_tbl OUT NOCOPY PO_TBL_VARCHAR30,
2741: x_freight_term_tbl OUT NOCOPY PO_TBL_VARCHAR30,

Line 2738: x_vendor_site_id_tbl IN OUT NOCOPY PO_TBL_NUMBER,

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,
2740: x_freight_carrier_tbl OUT NOCOPY PO_TBL_VARCHAR30,
2741: x_freight_term_tbl OUT NOCOPY PO_TBL_VARCHAR30,
2742: x_ship_to_loc_id_tbl OUT NOCOPY PO_TBL_NUMBER,

Line 2742: x_ship_to_loc_id_tbl OUT NOCOPY PO_TBL_NUMBER,

2738: x_vendor_site_id_tbl IN OUT NOCOPY PO_TBL_NUMBER,
2739: x_fob_tbl OUT NOCOPY PO_TBL_VARCHAR30,
2740: x_freight_carrier_tbl OUT NOCOPY PO_TBL_VARCHAR30,
2741: x_freight_term_tbl OUT NOCOPY PO_TBL_VARCHAR30,
2742: x_ship_to_loc_id_tbl OUT NOCOPY PO_TBL_NUMBER,
2743: x_bill_to_loc_id_tbl OUT NOCOPY PO_TBL_NUMBER,
2744: x_invoice_currency_code_tbl OUT NOCOPY PO_TBL_VARCHAR30,
2745: x_terms_id_tbl OUT NOCOPY PO_TBL_NUMBER,
2746: x_shipping_control_tbl OUT NOCOPY PO_TBL_VARCHAR30,

Line 2743: x_bill_to_loc_id_tbl OUT NOCOPY PO_TBL_NUMBER,

2739: x_fob_tbl OUT NOCOPY PO_TBL_VARCHAR30,
2740: x_freight_carrier_tbl OUT NOCOPY PO_TBL_VARCHAR30,
2741: x_freight_term_tbl OUT NOCOPY PO_TBL_VARCHAR30,
2742: x_ship_to_loc_id_tbl OUT NOCOPY PO_TBL_NUMBER,
2743: x_bill_to_loc_id_tbl OUT NOCOPY PO_TBL_NUMBER,
2744: x_invoice_currency_code_tbl OUT NOCOPY PO_TBL_VARCHAR30,
2745: x_terms_id_tbl OUT NOCOPY PO_TBL_NUMBER,
2746: x_shipping_control_tbl OUT NOCOPY PO_TBL_VARCHAR30,
2747: x_pay_on_code_tbl OUT NOCOPY PO_TBL_VARCHAR30

Line 2745: x_terms_id_tbl OUT NOCOPY PO_TBL_NUMBER,

2741: x_freight_term_tbl OUT NOCOPY PO_TBL_VARCHAR30,
2742: x_ship_to_loc_id_tbl OUT NOCOPY PO_TBL_NUMBER,
2743: x_bill_to_loc_id_tbl OUT NOCOPY PO_TBL_NUMBER,
2744: x_invoice_currency_code_tbl OUT NOCOPY PO_TBL_VARCHAR30,
2745: x_terms_id_tbl OUT NOCOPY PO_TBL_NUMBER,
2746: x_shipping_control_tbl OUT NOCOPY PO_TBL_VARCHAR30,
2747: x_pay_on_code_tbl OUT NOCOPY PO_TBL_VARCHAR30
2748: ) IS
2749:

Line 2755: l_index_tbl PO_TBL_NUMBER;

2751: d_module CONSTANT VARCHAR2(255) := d_pkg_name || d_api_name || '.';
2752: d_position NUMBER;
2753:
2754: -- variables to hold values read from vendor definition
2755: l_index_tbl PO_TBL_NUMBER;
2756: l_vendor_site_id_tbl PO_TBL_NUMBER;
2757: l_fob_tbl PO_TBL_VARCHAR30;
2758: l_freight_carrier_tbl PO_TBL_VARCHAR30;
2759: l_freight_term_tbl PO_TBL_VARCHAR30;

Line 2756: l_vendor_site_id_tbl PO_TBL_NUMBER;

2752: d_position NUMBER;
2753:
2754: -- variables to hold values read from vendor definition
2755: l_index_tbl PO_TBL_NUMBER;
2756: l_vendor_site_id_tbl PO_TBL_NUMBER;
2757: l_fob_tbl PO_TBL_VARCHAR30;
2758: l_freight_carrier_tbl PO_TBL_VARCHAR30;
2759: l_freight_term_tbl PO_TBL_VARCHAR30;
2760: l_ship_to_loc_id_tbl PO_TBL_NUMBER;

Line 2760: l_ship_to_loc_id_tbl PO_TBL_NUMBER;

2756: l_vendor_site_id_tbl PO_TBL_NUMBER;
2757: l_fob_tbl PO_TBL_VARCHAR30;
2758: l_freight_carrier_tbl PO_TBL_VARCHAR30;
2759: l_freight_term_tbl PO_TBL_VARCHAR30;
2760: l_ship_to_loc_id_tbl PO_TBL_NUMBER;
2761: l_bill_to_loc_id_tbl PO_TBL_NUMBER;
2762: l_currency_code_tbl PO_TBL_VARCHAR30;
2763: l_terms_id_tbl PO_TBL_NUMBER;
2764: l_shipping_control_tbl PO_TBL_VARCHAR30;

Line 2761: l_bill_to_loc_id_tbl PO_TBL_NUMBER;

2757: l_fob_tbl PO_TBL_VARCHAR30;
2758: l_freight_carrier_tbl PO_TBL_VARCHAR30;
2759: l_freight_term_tbl PO_TBL_VARCHAR30;
2760: l_ship_to_loc_id_tbl PO_TBL_NUMBER;
2761: l_bill_to_loc_id_tbl PO_TBL_NUMBER;
2762: l_currency_code_tbl PO_TBL_VARCHAR30;
2763: l_terms_id_tbl PO_TBL_NUMBER;
2764: l_shipping_control_tbl PO_TBL_VARCHAR30;
2765: l_pay_on_code_tbl PO_TBL_VARCHAR30;

Line 2763: l_terms_id_tbl PO_TBL_NUMBER;

2759: l_freight_term_tbl PO_TBL_VARCHAR30;
2760: l_ship_to_loc_id_tbl PO_TBL_NUMBER;
2761: l_bill_to_loc_id_tbl PO_TBL_NUMBER;
2762: l_currency_code_tbl PO_TBL_VARCHAR30;
2763: l_terms_id_tbl PO_TBL_NUMBER;
2764: l_shipping_control_tbl PO_TBL_VARCHAR30;
2765: l_pay_on_code_tbl PO_TBL_VARCHAR30;
2766:
2767: -- variable to hold index of the current processing row

Line 2781: x_ship_to_loc_id_tbl := PO_TBL_NUMBER();

2777:
2778: x_fob_tbl := PO_TBL_VARCHAR30();
2779: x_freight_carrier_tbl := PO_TBL_VARCHAR30();
2780: x_freight_term_tbl := PO_TBL_VARCHAR30();
2781: x_ship_to_loc_id_tbl := PO_TBL_NUMBER();
2782: x_bill_to_loc_id_tbl := PO_TBL_NUMBER();
2783: x_invoice_currency_code_tbl := PO_TBL_VARCHAR30();
2784: x_terms_id_tbl := PO_TBL_NUMBER();
2785: x_shipping_control_tbl := PO_TBL_VARCHAR30();

Line 2782: x_bill_to_loc_id_tbl := PO_TBL_NUMBER();

2778: x_fob_tbl := PO_TBL_VARCHAR30();
2779: x_freight_carrier_tbl := PO_TBL_VARCHAR30();
2780: x_freight_term_tbl := PO_TBL_VARCHAR30();
2781: x_ship_to_loc_id_tbl := PO_TBL_NUMBER();
2782: x_bill_to_loc_id_tbl := PO_TBL_NUMBER();
2783: x_invoice_currency_code_tbl := PO_TBL_VARCHAR30();
2784: x_terms_id_tbl := PO_TBL_NUMBER();
2785: x_shipping_control_tbl := PO_TBL_VARCHAR30();
2786: x_pay_on_code_tbl := PO_TBL_VARCHAR30();

Line 2784: x_terms_id_tbl := PO_TBL_NUMBER();

2780: x_freight_term_tbl := PO_TBL_VARCHAR30();
2781: x_ship_to_loc_id_tbl := PO_TBL_NUMBER();
2782: x_bill_to_loc_id_tbl := PO_TBL_NUMBER();
2783: x_invoice_currency_code_tbl := PO_TBL_VARCHAR30();
2784: x_terms_id_tbl := PO_TBL_NUMBER();
2785: x_shipping_control_tbl := PO_TBL_VARCHAR30();
2786: x_pay_on_code_tbl := PO_TBL_VARCHAR30();
2787:
2788: x_fob_tbl.EXTEND(p_index_tbl.COUNT);

Line 2950: p_vendor_site_id_tbl IN PO_TBL_NUMBER,

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
2953:
2954: d_api_name CONSTANT VARCHAR2(30) := 'default_vendor_contact';

Line 2951: x_vendor_contact_id_tbl IN OUT NOCOPY PO_TBL_NUMBER

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
2953:
2954: d_api_name CONSTANT VARCHAR2(30) := 'default_vendor_contact';
2955: d_module CONSTANT VARCHAR2(255) := d_pkg_name || d_api_name || '.';

Line 2959: l_index_tbl PO_TBL_NUMBER;

2955: d_module CONSTANT VARCHAR2(255) := d_pkg_name || d_api_name || '.';
2956: d_position NUMBER;
2957:
2958: -- variables to hold defaulted results
2959: l_index_tbl PO_TBL_NUMBER;
2960: l_result_tbl PO_TBL_NUMBER;
2961:
2962: BEGIN
2963: d_position := 0;

Line 2960: l_result_tbl PO_TBL_NUMBER;

2956: d_position NUMBER;
2957:
2958: -- variables to hold defaulted results
2959: l_index_tbl PO_TBL_NUMBER;
2960: l_result_tbl PO_TBL_NUMBER;
2961:
2962: BEGIN
2963: d_position := 0;
2964: