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 112: p_clm_award_type IN PO_TBL_VARCHAR30,

108: (
109: p_key IN po_session_gt.key%TYPE,
110: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,
111: p_style_id_tbl IN PO_TBL_NUMBER,
112: p_clm_award_type IN PO_TBL_VARCHAR30,
113: x_clm_standard_form_tbl IN OUT NOCOPY PO_TBL_VARCHAR2000,
114: x_clm_document_format_tbl IN OUT NOCOPY PO_TBL_VARCHAR2000
115: );
116:

Line 122: x_clm_award_type_tbl IN OUT NOCOPY PO_TBL_VARCHAR30

118: (
119: p_key IN po_session_gt.key%TYPE,
120: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,
121: p_clm_award_type_disp_tbl IN PO_TBL_VARCHAR240,
122: x_clm_award_type_tbl IN OUT NOCOPY PO_TBL_VARCHAR30
123: );
124:
125: PROCEDURE derive_clm_award_admin
126: (

Line 146: p_doc_type_tbl IN PO_TBL_VARCHAR30,

142: (
143: p_key IN po_session_gt.key%TYPE,
144: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,
145: p_clm_source_document_id_tbl IN PO_TBL_NUMBER,
146: p_doc_type_tbl IN PO_TBL_VARCHAR30,
147: x_vendor_site_id_tbl IN OUT NOCOPY PO_TBL_NUMBER
148: );
149:
150: --PDOI CLM Integration Ends

Line 1449: --l_vendor_fob_tbl PO_TBL_VARCHAR30;

1445: -- information defaulted from vendor
1446:
1447: --
1448: -- The following columns are being obsoleted from PO_VENDORS level.
1449: --l_vendor_fob_tbl PO_TBL_VARCHAR30;
1450: --l_vendor_freight_carrier_tbl PO_TBL_VARCHAR30;
1451: --l_vendor_freight_term_tbl PO_TBL_VARCHAR30;
1452: --l_vendor_ship_to_loc_id_tbl PO_TBL_NUMBER;
1453: --l_vendor_bill_to_loc_id_tbl PO_TBL_NUMBER;

Line 1450: --l_vendor_freight_carrier_tbl PO_TBL_VARCHAR30;

1446:
1447: --
1448: -- The following columns are being obsoleted from PO_VENDORS level.
1449: --l_vendor_fob_tbl PO_TBL_VARCHAR30;
1450: --l_vendor_freight_carrier_tbl PO_TBL_VARCHAR30;
1451: --l_vendor_freight_term_tbl PO_TBL_VARCHAR30;
1452: --l_vendor_ship_to_loc_id_tbl PO_TBL_NUMBER;
1453: --l_vendor_bill_to_loc_id_tbl PO_TBL_NUMBER;
1454:

Line 1451: --l_vendor_freight_term_tbl PO_TBL_VARCHAR30;

1447: --
1448: -- The following columns are being obsoleted from PO_VENDORS level.
1449: --l_vendor_fob_tbl PO_TBL_VARCHAR30;
1450: --l_vendor_freight_carrier_tbl PO_TBL_VARCHAR30;
1451: --l_vendor_freight_term_tbl PO_TBL_VARCHAR30;
1452: --l_vendor_ship_to_loc_id_tbl PO_TBL_NUMBER;
1453: --l_vendor_bill_to_loc_id_tbl PO_TBL_NUMBER;
1454:
1455: l_vendor_invoice_curr_code_tbl PO_TBL_VARCHAR30;

Line 1455: l_vendor_invoice_curr_code_tbl PO_TBL_VARCHAR30;

1451: --l_vendor_freight_term_tbl PO_TBL_VARCHAR30;
1452: --l_vendor_ship_to_loc_id_tbl PO_TBL_NUMBER;
1453: --l_vendor_bill_to_loc_id_tbl PO_TBL_NUMBER;
1454:
1455: l_vendor_invoice_curr_code_tbl PO_TBL_VARCHAR30;
1456: l_vendor_terms_id_tbl PO_TBL_NUMBER;
1457:
1458: -- information defaulted from vendor site
1459: l_site_fob_tbl PO_TBL_VARCHAR30;

Line 1459: l_site_fob_tbl PO_TBL_VARCHAR30;

1455: l_vendor_invoice_curr_code_tbl PO_TBL_VARCHAR30;
1456: l_vendor_terms_id_tbl PO_TBL_NUMBER;
1457:
1458: -- information defaulted from vendor site
1459: l_site_fob_tbl PO_TBL_VARCHAR30;
1460: l_site_freight_carrier_tbl PO_TBL_VARCHAR30;
1461: l_site_freight_term_tbl PO_TBL_VARCHAR30;
1462: l_site_ship_to_loc_id_tbl PO_TBL_NUMBER;
1463: l_site_bill_to_loc_id_tbl PO_TBL_NUMBER;

Line 1460: l_site_freight_carrier_tbl PO_TBL_VARCHAR30;

1456: l_vendor_terms_id_tbl PO_TBL_NUMBER;
1457:
1458: -- information defaulted from vendor site
1459: l_site_fob_tbl PO_TBL_VARCHAR30;
1460: l_site_freight_carrier_tbl PO_TBL_VARCHAR30;
1461: l_site_freight_term_tbl PO_TBL_VARCHAR30;
1462: l_site_ship_to_loc_id_tbl PO_TBL_NUMBER;
1463: l_site_bill_to_loc_id_tbl PO_TBL_NUMBER;
1464: l_site_invoice_curr_code_tbl PO_TBL_VARCHAR30;

Line 1461: l_site_freight_term_tbl PO_TBL_VARCHAR30;

1457:
1458: -- information defaulted from vendor site
1459: l_site_fob_tbl PO_TBL_VARCHAR30;
1460: l_site_freight_carrier_tbl PO_TBL_VARCHAR30;
1461: l_site_freight_term_tbl PO_TBL_VARCHAR30;
1462: l_site_ship_to_loc_id_tbl PO_TBL_NUMBER;
1463: l_site_bill_to_loc_id_tbl PO_TBL_NUMBER;
1464: l_site_invoice_curr_code_tbl PO_TBL_VARCHAR30;
1465: l_site_terms_id_tbl PO_TBL_NUMBER;

Line 1464: l_site_invoice_curr_code_tbl PO_TBL_VARCHAR30;

1460: l_site_freight_carrier_tbl PO_TBL_VARCHAR30;
1461: l_site_freight_term_tbl PO_TBL_VARCHAR30;
1462: l_site_ship_to_loc_id_tbl PO_TBL_NUMBER;
1463: l_site_bill_to_loc_id_tbl PO_TBL_NUMBER;
1464: l_site_invoice_curr_code_tbl PO_TBL_VARCHAR30;
1465: l_site_terms_id_tbl PO_TBL_NUMBER;
1466: l_site_shipping_control_tbl PO_TBL_VARCHAR30;
1467: l_site_pay_on_code_tbl PO_TBL_VARCHAR30;
1468:

Line 1466: l_site_shipping_control_tbl PO_TBL_VARCHAR30;

1462: l_site_ship_to_loc_id_tbl PO_TBL_NUMBER;
1463: l_site_bill_to_loc_id_tbl PO_TBL_NUMBER;
1464: l_site_invoice_curr_code_tbl PO_TBL_VARCHAR30;
1465: l_site_terms_id_tbl PO_TBL_NUMBER;
1466: l_site_shipping_control_tbl PO_TBL_VARCHAR30;
1467: l_site_pay_on_code_tbl PO_TBL_VARCHAR30;
1468:
1469: l_lang VARCHAR2(4);
1470:

Line 1467: l_site_pay_on_code_tbl PO_TBL_VARCHAR30;

1463: l_site_bill_to_loc_id_tbl PO_TBL_NUMBER;
1464: l_site_invoice_curr_code_tbl PO_TBL_VARCHAR30;
1465: l_site_terms_id_tbl PO_TBL_NUMBER;
1466: l_site_shipping_control_tbl PO_TBL_VARCHAR30;
1467: l_site_pay_on_code_tbl PO_TBL_VARCHAR30;
1468:
1469: l_lang VARCHAR2(4);
1470:
1471: l_display_rate NUMBER;

Line 2420: p_vendor_num_tbl IN PO_TBL_VARCHAR30,

2416: (
2417: p_key IN po_session_gt.key%TYPE,
2418: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,
2419: p_vendor_name_tbl IN PO_TBL_VARCHAR2000,
2420: p_vendor_num_tbl IN PO_TBL_VARCHAR30,
2421: x_vendor_id_tbl IN OUT NOCOPY PO_TBL_NUMBER
2422: ) IS
2423:
2424: d_api_name CONSTANT VARCHAR2(30) := 'derive_vendor_id';

Line 2531: p_rate_type_tbl IN PO_TBL_VARCHAR30,

2527: PROCEDURE derive_rate_type_code
2528: (
2529: p_key IN po_session_gt.key%TYPE,
2530: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,
2531: p_rate_type_tbl IN PO_TBL_VARCHAR30,
2532: x_rate_type_code_tbl IN OUT NOCOPY PO_TBL_VARCHAR30
2533: ) IS
2534:
2535: d_api_name CONSTANT VARCHAR2(30) := 'derive_rate_type_code';

Line 2532: x_rate_type_code_tbl IN OUT NOCOPY PO_TBL_VARCHAR30

2528: (
2529: p_key IN po_session_gt.key%TYPE,
2530: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,
2531: p_rate_type_tbl IN PO_TBL_VARCHAR30,
2532: x_rate_type_code_tbl IN OUT NOCOPY PO_TBL_VARCHAR30
2533: ) IS
2534:
2535: d_api_name CONSTANT VARCHAR2(30) := 'derive_rate_type_code';
2536: d_module CONSTANT VARCHAR2(255) := d_pkg_name || d_api_name || '.';

Line 2541: l_result_tbl PO_TBL_VARCHAR30;

2537: d_position NUMBER;
2538:
2539: -- tables to store the derived result
2540: l_index_tbl PO_TBL_NUMBER;
2541: l_result_tbl PO_TBL_VARCHAR30;
2542: BEGIN
2543: d_position := 0;
2544:
2545: IF (PO_LOG.d_proc) THEN

Line 2716: p_vendor_site_code_tbl IN PO_TBL_VARCHAR30,

2712: (
2713: p_key IN po_session_gt.key%TYPE,
2714: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,
2715: p_vendor_id_tbl IN PO_TBL_NUMBER,
2716: p_vendor_site_code_tbl IN PO_TBL_VARCHAR30,
2717: x_vendor_site_id_tbl IN OUT NOCOPY PO_TBL_NUMBER
2718: ) IS
2719:
2720: d_api_name CONSTANT VARCHAR2(30) := 'derive_vendor_site_id';

Line 3004: p_from_rfq_num_tbl IN PO_TBL_VARCHAR30,

3000: PROCEDURE derive_from_header_id
3001: (
3002: p_key IN po_session_gt.key%TYPE,
3003: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,
3004: p_from_rfq_num_tbl IN PO_TBL_VARCHAR30,
3005: x_from_header_id_tbl IN OUT NOCOPY PO_TBL_NUMBER
3006: ) IS
3007:
3008: d_api_name CONSTANT VARCHAR2(30) := 'derive_from_header_id';

Line 3100: x_invoice_currency_code_tbl OUT NOCOPY PO_TBL_VARCHAR30,

3096: (
3097: p_key IN po_session_gt.key%TYPE,
3098: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,
3099: p_vendor_id_tbl IN PO_TBL_NUMBER,
3100: x_invoice_currency_code_tbl OUT NOCOPY PO_TBL_VARCHAR30,
3101: x_terms_id_tbl OUT NOCOPY PO_TBL_NUMBER
3102: ) IS
3103:
3104: d_api_name CONSTANT VARCHAR2(30) := 'default_info_from_vendor';

Line 3110: l_currency_code_tbl PO_TBL_VARCHAR30;

3106: d_position NUMBER;
3107:
3108: -- variables to hold values read from vendor definition
3109: l_index_tbl PO_TBL_NUMBER;
3110: l_currency_code_tbl PO_TBL_VARCHAR30;
3111: l_terms_id_tbl PO_TBL_NUMBER;
3112:
3113: -- variable to hold index of the current processing row
3114: l_index NUMBER;

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

3123: -- Initialize OUT parameters
3124:
3125: --
3126: -- The following columns are being obsoleted from PO_VENDORS level
3127: --x_fob_tbl := PO_TBL_VARCHAR30();
3128: --x_freight_carrier_tbl := PO_TBL_VARCHAR30();
3129: --x_freight_term_tbl := PO_TBL_VARCHAR30();
3130: --x_ship_to_loc_id_tbl := PO_TBL_NUMBER();
3131: --x_bill_to_loc_id_tbl := PO_TBL_NUMBER();

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

3124:
3125: --
3126: -- The following columns are being obsoleted from PO_VENDORS level
3127: --x_fob_tbl := PO_TBL_VARCHAR30();
3128: --x_freight_carrier_tbl := PO_TBL_VARCHAR30();
3129: --x_freight_term_tbl := PO_TBL_VARCHAR30();
3130: --x_ship_to_loc_id_tbl := PO_TBL_NUMBER();
3131: --x_bill_to_loc_id_tbl := PO_TBL_NUMBER();
3132:

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

3125: --
3126: -- The following columns are being obsoleted from PO_VENDORS level
3127: --x_fob_tbl := PO_TBL_VARCHAR30();
3128: --x_freight_carrier_tbl := PO_TBL_VARCHAR30();
3129: --x_freight_term_tbl := PO_TBL_VARCHAR30();
3130: --x_ship_to_loc_id_tbl := PO_TBL_NUMBER();
3131: --x_bill_to_loc_id_tbl := PO_TBL_NUMBER();
3132:
3133: x_invoice_currency_code_tbl := PO_TBL_VARCHAR30();

Line 3133: x_invoice_currency_code_tbl := PO_TBL_VARCHAR30();

3129: --x_freight_term_tbl := PO_TBL_VARCHAR30();
3130: --x_ship_to_loc_id_tbl := PO_TBL_NUMBER();
3131: --x_bill_to_loc_id_tbl := PO_TBL_NUMBER();
3132:
3133: x_invoice_currency_code_tbl := PO_TBL_VARCHAR30();
3134: x_terms_id_tbl := PO_TBL_NUMBER();
3135:
3136: x_invoice_currency_code_tbl.EXTEND(p_index_tbl.COUNT);
3137: x_terms_id_tbl.EXTEND(p_index_tbl.COUNT);

Line 3248: x_fob_tbl OUT NOCOPY PO_TBL_VARCHAR30,

3244: p_key IN po_session_gt.key%TYPE,
3245: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,
3246: p_vendor_id_tbl IN PO_TBL_NUMBER,
3247: x_vendor_site_id_tbl IN OUT NOCOPY PO_TBL_NUMBER,
3248: x_fob_tbl OUT NOCOPY PO_TBL_VARCHAR30,
3249: x_freight_carrier_tbl OUT NOCOPY PO_TBL_VARCHAR30,
3250: x_freight_term_tbl OUT NOCOPY PO_TBL_VARCHAR30,
3251: x_ship_to_loc_id_tbl OUT NOCOPY PO_TBL_NUMBER,
3252: x_bill_to_loc_id_tbl OUT NOCOPY PO_TBL_NUMBER,

Line 3249: x_freight_carrier_tbl OUT NOCOPY PO_TBL_VARCHAR30,

3245: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,
3246: p_vendor_id_tbl IN PO_TBL_NUMBER,
3247: x_vendor_site_id_tbl IN OUT NOCOPY PO_TBL_NUMBER,
3248: x_fob_tbl OUT NOCOPY PO_TBL_VARCHAR30,
3249: x_freight_carrier_tbl OUT NOCOPY PO_TBL_VARCHAR30,
3250: x_freight_term_tbl OUT NOCOPY PO_TBL_VARCHAR30,
3251: x_ship_to_loc_id_tbl OUT NOCOPY PO_TBL_NUMBER,
3252: x_bill_to_loc_id_tbl OUT NOCOPY PO_TBL_NUMBER,
3253: x_invoice_currency_code_tbl OUT NOCOPY PO_TBL_VARCHAR30,

Line 3250: x_freight_term_tbl OUT NOCOPY PO_TBL_VARCHAR30,

3246: p_vendor_id_tbl IN PO_TBL_NUMBER,
3247: x_vendor_site_id_tbl IN OUT NOCOPY PO_TBL_NUMBER,
3248: x_fob_tbl OUT NOCOPY PO_TBL_VARCHAR30,
3249: x_freight_carrier_tbl OUT NOCOPY PO_TBL_VARCHAR30,
3250: x_freight_term_tbl OUT NOCOPY PO_TBL_VARCHAR30,
3251: x_ship_to_loc_id_tbl OUT NOCOPY PO_TBL_NUMBER,
3252: x_bill_to_loc_id_tbl OUT NOCOPY PO_TBL_NUMBER,
3253: x_invoice_currency_code_tbl OUT NOCOPY PO_TBL_VARCHAR30,
3254: x_terms_id_tbl OUT NOCOPY PO_TBL_NUMBER,

Line 3253: x_invoice_currency_code_tbl OUT NOCOPY PO_TBL_VARCHAR30,

3249: x_freight_carrier_tbl OUT NOCOPY PO_TBL_VARCHAR30,
3250: x_freight_term_tbl OUT NOCOPY PO_TBL_VARCHAR30,
3251: x_ship_to_loc_id_tbl OUT NOCOPY PO_TBL_NUMBER,
3252: x_bill_to_loc_id_tbl OUT NOCOPY PO_TBL_NUMBER,
3253: x_invoice_currency_code_tbl OUT NOCOPY PO_TBL_VARCHAR30,
3254: x_terms_id_tbl OUT NOCOPY PO_TBL_NUMBER,
3255: x_shipping_control_tbl OUT NOCOPY PO_TBL_VARCHAR30,
3256: x_pay_on_code_tbl OUT NOCOPY PO_TBL_VARCHAR30
3257: ) IS

Line 3255: x_shipping_control_tbl OUT NOCOPY PO_TBL_VARCHAR30,

3251: x_ship_to_loc_id_tbl OUT NOCOPY PO_TBL_NUMBER,
3252: x_bill_to_loc_id_tbl OUT NOCOPY PO_TBL_NUMBER,
3253: x_invoice_currency_code_tbl OUT NOCOPY PO_TBL_VARCHAR30,
3254: x_terms_id_tbl OUT NOCOPY PO_TBL_NUMBER,
3255: x_shipping_control_tbl OUT NOCOPY PO_TBL_VARCHAR30,
3256: x_pay_on_code_tbl OUT NOCOPY PO_TBL_VARCHAR30
3257: ) IS
3258:
3259: d_api_name CONSTANT VARCHAR2(30) := 'default_info_from_vendor_site';

Line 3256: x_pay_on_code_tbl OUT NOCOPY PO_TBL_VARCHAR30

3252: x_bill_to_loc_id_tbl OUT NOCOPY PO_TBL_NUMBER,
3253: x_invoice_currency_code_tbl OUT NOCOPY PO_TBL_VARCHAR30,
3254: x_terms_id_tbl OUT NOCOPY PO_TBL_NUMBER,
3255: x_shipping_control_tbl OUT NOCOPY PO_TBL_VARCHAR30,
3256: x_pay_on_code_tbl OUT NOCOPY PO_TBL_VARCHAR30
3257: ) IS
3258:
3259: d_api_name CONSTANT VARCHAR2(30) := 'default_info_from_vendor_site';
3260: d_module CONSTANT VARCHAR2(255) := d_pkg_name || d_api_name || '.';

Line 3266: l_fob_tbl PO_TBL_VARCHAR30;

3262:
3263: -- variables to hold values read from vendor definition
3264: l_index_tbl PO_TBL_NUMBER;
3265: l_vendor_site_id_tbl PO_TBL_NUMBER;
3266: l_fob_tbl PO_TBL_VARCHAR30;
3267: l_freight_carrier_tbl PO_TBL_VARCHAR30;
3268: l_freight_term_tbl PO_TBL_VARCHAR30;
3269: l_ship_to_loc_id_tbl PO_TBL_NUMBER;
3270: l_bill_to_loc_id_tbl PO_TBL_NUMBER;

Line 3267: l_freight_carrier_tbl PO_TBL_VARCHAR30;

3263: -- variables to hold values read from vendor definition
3264: l_index_tbl PO_TBL_NUMBER;
3265: l_vendor_site_id_tbl PO_TBL_NUMBER;
3266: l_fob_tbl PO_TBL_VARCHAR30;
3267: l_freight_carrier_tbl PO_TBL_VARCHAR30;
3268: l_freight_term_tbl PO_TBL_VARCHAR30;
3269: l_ship_to_loc_id_tbl PO_TBL_NUMBER;
3270: l_bill_to_loc_id_tbl PO_TBL_NUMBER;
3271: l_currency_code_tbl PO_TBL_VARCHAR30;

Line 3268: l_freight_term_tbl PO_TBL_VARCHAR30;

3264: l_index_tbl PO_TBL_NUMBER;
3265: l_vendor_site_id_tbl PO_TBL_NUMBER;
3266: l_fob_tbl PO_TBL_VARCHAR30;
3267: l_freight_carrier_tbl PO_TBL_VARCHAR30;
3268: l_freight_term_tbl PO_TBL_VARCHAR30;
3269: l_ship_to_loc_id_tbl PO_TBL_NUMBER;
3270: l_bill_to_loc_id_tbl PO_TBL_NUMBER;
3271: l_currency_code_tbl PO_TBL_VARCHAR30;
3272: l_terms_id_tbl PO_TBL_NUMBER;

Line 3271: l_currency_code_tbl PO_TBL_VARCHAR30;

3267: l_freight_carrier_tbl PO_TBL_VARCHAR30;
3268: l_freight_term_tbl PO_TBL_VARCHAR30;
3269: l_ship_to_loc_id_tbl PO_TBL_NUMBER;
3270: l_bill_to_loc_id_tbl PO_TBL_NUMBER;
3271: l_currency_code_tbl PO_TBL_VARCHAR30;
3272: l_terms_id_tbl PO_TBL_NUMBER;
3273: l_shipping_control_tbl PO_TBL_VARCHAR30;
3274: l_pay_on_code_tbl PO_TBL_VARCHAR30;
3275:

Line 3273: l_shipping_control_tbl PO_TBL_VARCHAR30;

3269: l_ship_to_loc_id_tbl PO_TBL_NUMBER;
3270: l_bill_to_loc_id_tbl PO_TBL_NUMBER;
3271: l_currency_code_tbl PO_TBL_VARCHAR30;
3272: l_terms_id_tbl PO_TBL_NUMBER;
3273: l_shipping_control_tbl PO_TBL_VARCHAR30;
3274: l_pay_on_code_tbl PO_TBL_VARCHAR30;
3275:
3276: -- variable to hold index of the current processing row
3277: l_index NUMBER;

Line 3274: l_pay_on_code_tbl PO_TBL_VARCHAR30;

3270: l_bill_to_loc_id_tbl PO_TBL_NUMBER;
3271: l_currency_code_tbl PO_TBL_VARCHAR30;
3272: l_terms_id_tbl PO_TBL_NUMBER;
3273: l_shipping_control_tbl PO_TBL_VARCHAR30;
3274: l_pay_on_code_tbl PO_TBL_VARCHAR30;
3275:
3276: -- variable to hold index of the current processing row
3277: l_index NUMBER;
3278:

Line 3287: x_fob_tbl := PO_TBL_VARCHAR30();

3283: PO_LOG.proc_begin(d_module, 'vendor ids', p_vendor_id_tbl);
3284: PO_LOG.proc_begin(d_module, 'vendor site ids', x_vendor_site_id_tbl);
3285: END IF;
3286:
3287: x_fob_tbl := PO_TBL_VARCHAR30();
3288: x_freight_carrier_tbl := PO_TBL_VARCHAR30();
3289: x_freight_term_tbl := PO_TBL_VARCHAR30();
3290: x_ship_to_loc_id_tbl := PO_TBL_NUMBER();
3291: x_bill_to_loc_id_tbl := PO_TBL_NUMBER();

Line 3288: x_freight_carrier_tbl := PO_TBL_VARCHAR30();

3284: PO_LOG.proc_begin(d_module, 'vendor site ids', x_vendor_site_id_tbl);
3285: END IF;
3286:
3287: x_fob_tbl := PO_TBL_VARCHAR30();
3288: x_freight_carrier_tbl := PO_TBL_VARCHAR30();
3289: x_freight_term_tbl := PO_TBL_VARCHAR30();
3290: x_ship_to_loc_id_tbl := PO_TBL_NUMBER();
3291: x_bill_to_loc_id_tbl := PO_TBL_NUMBER();
3292: x_invoice_currency_code_tbl := PO_TBL_VARCHAR30();

Line 3289: x_freight_term_tbl := PO_TBL_VARCHAR30();

3285: END IF;
3286:
3287: x_fob_tbl := PO_TBL_VARCHAR30();
3288: x_freight_carrier_tbl := PO_TBL_VARCHAR30();
3289: x_freight_term_tbl := PO_TBL_VARCHAR30();
3290: x_ship_to_loc_id_tbl := PO_TBL_NUMBER();
3291: x_bill_to_loc_id_tbl := PO_TBL_NUMBER();
3292: x_invoice_currency_code_tbl := PO_TBL_VARCHAR30();
3293: x_terms_id_tbl := PO_TBL_NUMBER();

Line 3292: x_invoice_currency_code_tbl := PO_TBL_VARCHAR30();

3288: x_freight_carrier_tbl := PO_TBL_VARCHAR30();
3289: x_freight_term_tbl := PO_TBL_VARCHAR30();
3290: x_ship_to_loc_id_tbl := PO_TBL_NUMBER();
3291: x_bill_to_loc_id_tbl := PO_TBL_NUMBER();
3292: x_invoice_currency_code_tbl := PO_TBL_VARCHAR30();
3293: x_terms_id_tbl := PO_TBL_NUMBER();
3294: x_shipping_control_tbl := PO_TBL_VARCHAR30();
3295: x_pay_on_code_tbl := PO_TBL_VARCHAR30();
3296:

Line 3294: x_shipping_control_tbl := PO_TBL_VARCHAR30();

3290: x_ship_to_loc_id_tbl := PO_TBL_NUMBER();
3291: x_bill_to_loc_id_tbl := PO_TBL_NUMBER();
3292: x_invoice_currency_code_tbl := PO_TBL_VARCHAR30();
3293: x_terms_id_tbl := PO_TBL_NUMBER();
3294: x_shipping_control_tbl := PO_TBL_VARCHAR30();
3295: x_pay_on_code_tbl := PO_TBL_VARCHAR30();
3296:
3297: x_fob_tbl.EXTEND(p_index_tbl.COUNT);
3298: x_freight_carrier_tbl.EXTEND(p_index_tbl.COUNT);

Line 3295: x_pay_on_code_tbl := PO_TBL_VARCHAR30();

3291: x_bill_to_loc_id_tbl := PO_TBL_NUMBER();
3292: x_invoice_currency_code_tbl := PO_TBL_VARCHAR30();
3293: x_terms_id_tbl := PO_TBL_NUMBER();
3294: x_shipping_control_tbl := PO_TBL_VARCHAR30();
3295: x_pay_on_code_tbl := PO_TBL_VARCHAR30();
3296:
3297: x_fob_tbl.EXTEND(p_index_tbl.COUNT);
3298: x_freight_carrier_tbl.EXTEND(p_index_tbl.COUNT);
3299: x_freight_term_tbl.EXTEND(p_index_tbl.COUNT);

Line 3734: p_clm_award_type IN PO_TBL_VARCHAR30,

3730: (
3731: p_key IN po_session_gt.key%TYPE,
3732: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,
3733: p_style_id_tbl IN PO_TBL_NUMBER,
3734: p_clm_award_type IN PO_TBL_VARCHAR30,
3735: x_clm_standard_form_tbl IN OUT NOCOPY PO_TBL_VARCHAR2000,
3736: x_clm_document_format_tbl IN OUT NOCOPY PO_TBL_VARCHAR2000
3737: ) IS
3738:

Line 3745: l_standard_form_tbl PO_TBL_VARCHAR30;

3741: d_position NUMBER;
3742:
3743: -- tables to store the derived result
3744: l_index_tbl PO_TBL_NUMBER;
3745: l_standard_form_tbl PO_TBL_VARCHAR30;
3746: l_document_format_tbl PO_TBL_VARCHAR30;
3747:
3748: BEGIN
3749: d_position := 0;

Line 3746: l_document_format_tbl PO_TBL_VARCHAR30;

3742:
3743: -- tables to store the derived result
3744: l_index_tbl PO_TBL_NUMBER;
3745: l_standard_form_tbl PO_TBL_VARCHAR30;
3746: l_document_format_tbl PO_TBL_VARCHAR30;
3747:
3748: BEGIN
3749: d_position := 0;
3750:

Line 3878: x_clm_award_type_tbl IN OUT NOCOPY PO_TBL_VARCHAR30

3874: (
3875: p_key IN po_session_gt.key%TYPE,
3876: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,
3877: p_clm_award_type_disp_tbl IN PO_TBL_VARCHAR240,
3878: x_clm_award_type_tbl IN OUT NOCOPY PO_TBL_VARCHAR30
3879: ) IS
3880:
3881: d_api_name CONSTANT VARCHAR2(30) := 'derive_clm_award_type';
3882: d_module CONSTANT VARCHAR2(255) := d_pkg_name || d_api_name || '.';

Line 3887: l_result_tbl PO_TBL_VARCHAR30;

3883: d_position NUMBER;
3884:
3885: -- tables to store the derived result
3886: l_index_tbl PO_TBL_NUMBER;
3887: l_result_tbl PO_TBL_VARCHAR30;
3888: BEGIN
3889: d_position := 0;
3890:
3891: IF (PO_LOG.d_proc) THEN

Line 3958: l_result_tbl PO_TBL_VARCHAR30;

3954: d_position NUMBER;
3955:
3956: -- tables to store the derived result
3957: l_index_tbl PO_TBL_NUMBER;
3958: l_result_tbl PO_TBL_VARCHAR30;
3959: BEGIN
3960: d_position := 0;
3961:
3962: IF (PO_LOG.d_proc) THEN

Line 4155: p_doc_type_tbl IN PO_TBL_VARCHAR30,

4151: (
4152: p_key IN po_session_gt.key%TYPE,
4153: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,
4154: p_clm_source_document_id_tbl IN PO_TBL_NUMBER,
4155: p_doc_type_tbl IN PO_TBL_VARCHAR30,
4156: x_vendor_id_tbl IN OUT NOCOPY PO_TBL_NUMBER
4157: ) IS
4158:
4159: d_api_name CONSTANT VARCHAR2(30) := 'derive_vendor_id_from_idv';

Line 4223: p_doc_type_tbl IN PO_TBL_VARCHAR30,

4219: (
4220: p_key IN po_session_gt.key%TYPE,
4221: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,
4222: p_clm_source_document_id_tbl IN PO_TBL_NUMBER,
4223: p_doc_type_tbl IN PO_TBL_VARCHAR30,
4224: x_vendor_site_id_tbl IN OUT NOCOPY PO_TBL_NUMBER
4225: ) IS
4226:
4227: d_api_name CONSTANT VARCHAR2(30) := 'derive_vendor_site_id_from_idv';