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_VARCHAR30

Line 15: p_rate_type_tbl IN PO_TBL_VARCHAR30,

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: );
18:
19: PROCEDURE derive_agent_id

Line 16: x_rate_type_code_tbl IN OUT NOCOPY PO_TBL_VARCHAR30

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: );
18:
19: PROCEDURE derive_agent_id
20: (

Line 32: p_vendor_site_code_tbl IN PO_TBL_VARCHAR30,

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:
36: PROCEDURE derive_vendor_contact_id

Line 49: p_from_rfq_num_tbl IN PO_TBL_VARCHAR30,

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

Line 66: x_invoice_currency_code_tbl OUT NOCOPY PO_TBL_VARCHAR30,

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:
70: PROCEDURE default_info_from_vendor_site

Line 76: x_fob_tbl OUT NOCOPY PO_TBL_VARCHAR30,

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,
80: x_bill_to_loc_id_tbl OUT NOCOPY PO_TBL_NUMBER,

Line 77: x_freight_carrier_tbl OUT NOCOPY PO_TBL_VARCHAR30,

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,
80: x_bill_to_loc_id_tbl OUT NOCOPY PO_TBL_NUMBER,
81: x_invoice_currency_code_tbl OUT NOCOPY PO_TBL_VARCHAR30,

Line 78: x_freight_term_tbl OUT NOCOPY PO_TBL_VARCHAR30,

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,
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,

Line 81: x_invoice_currency_code_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
85: );

Line 83: x_shipping_control_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:
87: PROCEDURE default_vendor_contact

Line 84: x_pay_on_code_tbl OUT NOCOPY PO_TBL_VARCHAR30

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:
87: PROCEDURE default_vendor_contact
88: (

Line 980: --l_vendor_fob_tbl PO_TBL_VARCHAR30;

976: -- information defaulted from vendor
977:
978: --
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;

Line 981: --l_vendor_freight_carrier_tbl PO_TBL_VARCHAR30;

977:
978: --
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:

Line 982: --l_vendor_freight_term_tbl PO_TBL_VARCHAR30;

978: --
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;

Line 986: l_vendor_invoice_curr_code_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:
989: -- information defaulted from vendor site
990: l_site_fob_tbl PO_TBL_VARCHAR30;

Line 990: l_site_fob_tbl PO_TBL_VARCHAR30;

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;
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;

Line 991: l_site_freight_carrier_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;
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;

Line 992: l_site_freight_term_tbl PO_TBL_VARCHAR30;

988:
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;

Line 995: l_site_invoice_curr_code_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;
999:

Line 997: l_site_shipping_control_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);
1001:

Line 998: l_site_pay_on_code_tbl PO_TBL_VARCHAR30;

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);
1001:
1002: l_display_rate NUMBER;

Line 1911: p_vendor_num_tbl IN PO_TBL_VARCHAR30,

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

Line 2022: p_rate_type_tbl IN PO_TBL_VARCHAR30,

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
2025:
2026: d_api_name CONSTANT VARCHAR2(30) := 'derive_rate_type_code';

Line 2023: x_rate_type_code_tbl IN OUT NOCOPY PO_TBL_VARCHAR30

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
2025:
2026: d_api_name CONSTANT VARCHAR2(30) := 'derive_rate_type_code';
2027: d_module CONSTANT VARCHAR2(255) := d_pkg_name || d_api_name || '.';

Line 2032: l_result_tbl PO_TBL_VARCHAR30;

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:
2036: IF (PO_LOG.d_proc) THEN

Line 2207: p_vendor_site_code_tbl IN PO_TBL_VARCHAR30,

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:
2211: d_api_name CONSTANT VARCHAR2(30) := 'derive_vendor_site_id';

Line 2495: p_from_rfq_num_tbl IN PO_TBL_VARCHAR30,

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

Line 2591: x_invoice_currency_code_tbl OUT NOCOPY PO_TBL_VARCHAR30,

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:
2595: d_api_name CONSTANT VARCHAR2(30) := 'default_info_from_vendor';

Line 2601: l_currency_code_tbl PO_TBL_VARCHAR30;

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
2605: l_index NUMBER;

Line 2618: --x_fob_tbl := PO_TBL_VARCHAR30();

2614: -- Initialize OUT parameters
2615:
2616: --
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();

Line 2619: --x_freight_carrier_tbl := PO_TBL_VARCHAR30();

2615:
2616: --
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:

Line 2620: --x_freight_term_tbl := PO_TBL_VARCHAR30();

2616: --
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();

Line 2624: x_invoice_currency_code_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:
2627: x_invoice_currency_code_tbl.EXTEND(p_index_tbl.COUNT);
2628: x_terms_id_tbl.EXTEND(p_index_tbl.COUNT);

Line 2739: x_fob_tbl OUT NOCOPY PO_TBL_VARCHAR30,

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,
2743: x_bill_to_loc_id_tbl OUT NOCOPY PO_TBL_NUMBER,

Line 2740: x_freight_carrier_tbl OUT NOCOPY PO_TBL_VARCHAR30,

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,
2743: x_bill_to_loc_id_tbl OUT NOCOPY PO_TBL_NUMBER,
2744: x_invoice_currency_code_tbl OUT NOCOPY PO_TBL_VARCHAR30,

Line 2741: x_freight_term_tbl OUT NOCOPY PO_TBL_VARCHAR30,

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,
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,

Line 2744: x_invoice_currency_code_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
2748: ) IS

Line 2746: x_shipping_control_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:
2750: d_api_name CONSTANT VARCHAR2(30) := 'default_info_from_vendor_site';

Line 2747: x_pay_on_code_tbl OUT NOCOPY PO_TBL_VARCHAR30

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:
2750: d_api_name CONSTANT VARCHAR2(30) := 'default_info_from_vendor_site';
2751: d_module CONSTANT VARCHAR2(255) := d_pkg_name || d_api_name || '.';

Line 2757: l_fob_tbl PO_TBL_VARCHAR30;

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;
2761: l_bill_to_loc_id_tbl PO_TBL_NUMBER;

Line 2758: l_freight_carrier_tbl PO_TBL_VARCHAR30;

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;
2761: l_bill_to_loc_id_tbl PO_TBL_NUMBER;
2762: l_currency_code_tbl PO_TBL_VARCHAR30;

Line 2759: l_freight_term_tbl PO_TBL_VARCHAR30;

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;
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;

Line 2762: l_currency_code_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;
2766:

Line 2764: l_shipping_control_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
2768: l_index NUMBER;

Line 2765: l_pay_on_code_tbl PO_TBL_VARCHAR30;

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
2768: l_index NUMBER;
2769:

Line 2778: x_fob_tbl := PO_TBL_VARCHAR30();

2774: PO_LOG.proc_begin(d_module, 'vendor ids', p_vendor_id_tbl);
2775: PO_LOG.proc_begin(d_module, 'vendor site ids', x_vendor_site_id_tbl);
2776: END IF;
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();

Line 2779: x_freight_carrier_tbl := PO_TBL_VARCHAR30();

2775: PO_LOG.proc_begin(d_module, 'vendor site ids', x_vendor_site_id_tbl);
2776: END IF;
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();

Line 2780: x_freight_term_tbl := PO_TBL_VARCHAR30();

2776: END IF;
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();

Line 2783: x_invoice_currency_code_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();
2787:

Line 2785: x_shipping_control_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);
2789: x_freight_carrier_tbl.EXTEND(p_index_tbl.COUNT);

Line 2786: x_pay_on_code_tbl := PO_TBL_VARCHAR30();

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);
2789: x_freight_carrier_tbl.EXTEND(p_index_tbl.COUNT);
2790: x_freight_term_tbl.EXTEND(p_index_tbl.COUNT);