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 111: p_style_id_tbl IN PO_TBL_NUMBER,

107: PROCEDURE default_clm_standard_format
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: );

Line 138: x_clm_contract_officer_tbl IN OUT NOCOPY PO_TBL_NUMBER

134: (
135: p_key IN po_session_gt.key%TYPE,
136: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,
137: p_clm_contract_oficer_disp_tbl IN PO_TBL_VARCHAR240,
138: x_clm_contract_officer_tbl IN OUT NOCOPY PO_TBL_NUMBER
139: );
140:
141: PROCEDURE derive_vendor_site_id_from_idv
142: (

Line 145: p_clm_source_document_id_tbl IN PO_TBL_NUMBER,

141: PROCEDURE derive_vendor_site_id_from_idv
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:

Line 147: x_vendor_site_id_tbl IN OUT NOCOPY PO_TBL_NUMBER

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
151: --------------------------------------------------------------------------

Line 1452: --l_vendor_ship_to_loc_id_tbl PO_TBL_NUMBER;

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;
1456: l_vendor_terms_id_tbl PO_TBL_NUMBER;

Line 1453: --l_vendor_bill_to_loc_id_tbl PO_TBL_NUMBER;

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;
1456: l_vendor_terms_id_tbl PO_TBL_NUMBER;
1457:

Line 1456: l_vendor_terms_id_tbl PO_TBL_NUMBER;

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;
1460: l_site_freight_carrier_tbl PO_TBL_VARCHAR30;

Line 1462: l_site_ship_to_loc_id_tbl PO_TBL_NUMBER;

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;
1466: l_site_shipping_control_tbl PO_TBL_VARCHAR30;

Line 1463: l_site_bill_to_loc_id_tbl PO_TBL_NUMBER;

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;
1466: l_site_shipping_control_tbl PO_TBL_VARCHAR30;
1467: l_site_pay_on_code_tbl PO_TBL_VARCHAR30;

Line 1465: l_site_terms_id_tbl PO_TBL_NUMBER;

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:
1469: l_lang VARCHAR2(4);

Line 2217: x_location_id_tbl IN OUT NOCOPY PO_TBL_NUMBER

2213: p_key IN po_session_gt.key%TYPE,
2214: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,
2215: p_location_type IN VARCHAR2,
2216: p_location_tbl IN PO_TBL_VARCHAR100,
2217: x_location_id_tbl IN OUT NOCOPY PO_TBL_NUMBER
2218: ) IS
2219:
2220: d_api_name CONSTANT VARCHAR2(30) := 'derive_location_id';
2221: d_module CONSTANT VARCHAR2(255) := d_pkg_name || d_api_name || '.';

Line 2225: l_index_tbl PO_TBL_NUMBER;

2221: d_module CONSTANT VARCHAR2(255) := d_pkg_name || d_api_name || '.';
2222: d_position NUMBER;
2223:
2224: -- tables to store the derived result
2225: l_index_tbl PO_TBL_NUMBER;
2226: l_result_tbl PO_TBL_NUMBER;
2227: BEGIN
2228: d_position := 0;
2229:

Line 2226: l_result_tbl PO_TBL_NUMBER;

2222: d_position NUMBER;
2223:
2224: -- tables to store the derived result
2225: l_index_tbl PO_TBL_NUMBER;
2226: l_result_tbl PO_TBL_NUMBER;
2227: BEGIN
2228: d_position := 0;
2229:
2230: IF (PO_LOG.d_proc) THEN

Line 2323: x_terms_id_tbl IN OUT NOCOPY PO_TBL_NUMBER

2319: (
2320: p_key IN po_session_gt.key%TYPE,
2321: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,
2322: p_payment_terms_tbl IN PO_TBL_VARCHAR100,
2323: x_terms_id_tbl IN OUT NOCOPY PO_TBL_NUMBER
2324: ) IS
2325:
2326: d_api_name CONSTANT VARCHAR2(30) := 'derive_terms_id';
2327: d_module CONSTANT VARCHAR2(255) := d_pkg_name || d_api_name || '.';

Line 2331: l_index_tbl PO_TBL_NUMBER;

2327: d_module CONSTANT VARCHAR2(255) := d_pkg_name || d_api_name || '.';
2328: d_position NUMBER;
2329:
2330: -- tables to store the derived result
2331: l_index_tbl PO_TBL_NUMBER;
2332: l_result_tbl PO_TBL_NUMBER;
2333: BEGIN
2334: d_position := 0;
2335:

Line 2332: l_result_tbl PO_TBL_NUMBER;

2328: d_position NUMBER;
2329:
2330: -- tables to store the derived result
2331: l_index_tbl PO_TBL_NUMBER;
2332: l_result_tbl PO_TBL_NUMBER;
2333: BEGIN
2334: d_position := 0;
2335:
2336: IF (PO_LOG.d_proc) THEN

Line 2421: x_vendor_id_tbl IN OUT NOCOPY PO_TBL_NUMBER

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

Line 2429: l_index_tbl PO_TBL_NUMBER;

2425: d_module CONSTANT VARCHAR2(255) := d_pkg_name || d_api_name || '.';
2426: d_position NUMBER;
2427:
2428: -- tables to store the derived result
2429: l_index_tbl PO_TBL_NUMBER;
2430: l_result_tbl PO_TBL_NUMBER;
2431:
2432: -- variable to hold the current index of the row processed
2433: l_index NUMBER;

Line 2430: l_result_tbl PO_TBL_NUMBER;

2426: d_position NUMBER;
2427:
2428: -- tables to store the derived result
2429: l_index_tbl PO_TBL_NUMBER;
2430: l_result_tbl PO_TBL_NUMBER;
2431:
2432: -- variable to hold the current index of the row processed
2433: l_index NUMBER;
2434: BEGIN

Line 2540: l_index_tbl PO_TBL_NUMBER;

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

Line 2623: x_agent_id_tbl IN OUT NOCOPY PO_TBL_NUMBER

2619: (
2620: p_key IN po_session_gt.key%TYPE,
2621: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,
2622: p_agent_name_tbl IN PO_TBL_VARCHAR2000,
2623: x_agent_id_tbl IN OUT NOCOPY PO_TBL_NUMBER
2624: ) IS
2625:
2626: d_api_name CONSTANT VARCHAR2(30) := 'derive_agent_id';
2627: d_module CONSTANT VARCHAR2(255) := d_pkg_name || d_api_name || '.';

Line 2631: l_index_tbl PO_TBL_NUMBER;

2627: d_module CONSTANT VARCHAR2(255) := d_pkg_name || d_api_name || '.';
2628: d_position NUMBER;
2629:
2630: -- tables to store the derived result
2631: l_index_tbl PO_TBL_NUMBER;
2632: l_result_tbl PO_TBL_NUMBER;
2633: BEGIN
2634: d_position := 0;
2635:

Line 2632: l_result_tbl PO_TBL_NUMBER;

2628: d_position NUMBER;
2629:
2630: -- tables to store the derived result
2631: l_index_tbl PO_TBL_NUMBER;
2632: l_result_tbl PO_TBL_NUMBER;
2633: BEGIN
2634: d_position := 0;
2635:
2636: IF (PO_LOG.d_proc) THEN

Line 2715: p_vendor_id_tbl IN PO_TBL_NUMBER,

2711: PROCEDURE derive_vendor_site_id
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:

Line 2717: x_vendor_site_id_tbl IN OUT NOCOPY PO_TBL_NUMBER

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

Line 2725: l_index_tbl PO_TBL_NUMBER;

2721: d_module CONSTANT VARCHAR2(255) := d_pkg_name || d_api_name || '.';
2722: d_position NUMBER;
2723:
2724: -- tables to store the derived result
2725: l_index_tbl PO_TBL_NUMBER;
2726: l_result_tbl PO_TBL_NUMBER;
2727: BEGIN
2728: d_position := 0;
2729:

Line 2726: l_result_tbl PO_TBL_NUMBER;

2722: d_position NUMBER;
2723:
2724: -- tables to store the derived result
2725: l_index_tbl PO_TBL_NUMBER;
2726: l_result_tbl PO_TBL_NUMBER;
2727: BEGIN
2728: d_position := 0;
2729:
2730: IF (PO_LOG.d_proc) THEN

Line 2813: p_vendor_site_id_tbl IN PO_TBL_NUMBER,

2809: PROCEDURE derive_vendor_contact_id
2810: (
2811: p_key IN po_session_gt.key%TYPE,
2812: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,
2813: p_vendor_site_id_tbl IN PO_TBL_NUMBER,
2814: p_vendor_contact_tbl IN PO_TBL_VARCHAR2000,
2815: x_vendor_contact_id_tbl IN OUT NOCOPY PO_TBL_NUMBER
2816: ) IS
2817:

Line 2815: x_vendor_contact_id_tbl IN OUT NOCOPY PO_TBL_NUMBER

2811: p_key IN po_session_gt.key%TYPE,
2812: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,
2813: p_vendor_site_id_tbl IN PO_TBL_NUMBER,
2814: p_vendor_contact_tbl IN PO_TBL_VARCHAR2000,
2815: x_vendor_contact_id_tbl IN OUT NOCOPY PO_TBL_NUMBER
2816: ) IS
2817:
2818: d_api_name CONSTANT VARCHAR2(30) := 'derive_vendor_contact_id';
2819: d_module CONSTANT VARCHAR2(255) := d_pkg_name || d_api_name || '.';

Line 2823: l_index_tbl PO_TBL_NUMBER;

2819: d_module CONSTANT VARCHAR2(255) := d_pkg_name || d_api_name || '.';
2820: d_position NUMBER;
2821:
2822: -- tables to store the derived result
2823: l_index_tbl PO_TBL_NUMBER;
2824: l_result_tbl PO_TBL_NUMBER;
2825: BEGIN
2826: d_position := 0;
2827:

Line 2824: l_result_tbl PO_TBL_NUMBER;

2820: d_position NUMBER;
2821:
2822: -- tables to store the derived result
2823: l_index_tbl PO_TBL_NUMBER;
2824: l_result_tbl PO_TBL_NUMBER;
2825: BEGIN
2826: d_position := 0;
2827:
2828: IF (PO_LOG.d_proc) THEN

Line 2913: x_style_id_tbl IN OUT NOCOPY PO_TBL_NUMBER

2909: (
2910: p_key IN po_session_gt.key%TYPE,
2911: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,
2912: p_style_display_name_tbl IN PO_TBL_VARCHAR2000,
2913: x_style_id_tbl IN OUT NOCOPY PO_TBL_NUMBER
2914: ) IS
2915:
2916: d_api_name CONSTANT VARCHAR2(30) := 'derive_style_id';
2917: d_module CONSTANT VARCHAR2(255) := d_pkg_name || d_api_name || '.';

Line 2921: l_index_tbl PO_TBL_NUMBER;

2917: d_module CONSTANT VARCHAR2(255) := d_pkg_name || d_api_name || '.';
2918: d_position NUMBER;
2919:
2920: -- tables to store the derived result
2921: l_index_tbl PO_TBL_NUMBER;
2922: l_result_tbl PO_TBL_NUMBER;
2923: BEGIN
2924: d_position := 0;
2925:

Line 2922: l_result_tbl PO_TBL_NUMBER;

2918: d_position NUMBER;
2919:
2920: -- tables to store the derived result
2921: l_index_tbl PO_TBL_NUMBER;
2922: l_result_tbl PO_TBL_NUMBER;
2923: BEGIN
2924: d_position := 0;
2925:
2926: IF (PO_LOG.d_proc) THEN

Line 3005: x_from_header_id_tbl IN OUT NOCOPY PO_TBL_NUMBER

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

Line 3013: l_index_tbl PO_TBL_NUMBER;

3009: d_module CONSTANT VARCHAR2(255) := d_pkg_name || d_api_name || '.';
3010: d_position NUMBER;
3011:
3012: -- tables to store the derived result
3013: l_index_tbl PO_TBL_NUMBER;
3014: l_result_tbl PO_TBL_NUMBER;
3015: BEGIN
3016: d_position := 0;
3017:

Line 3014: l_result_tbl PO_TBL_NUMBER;

3010: d_position NUMBER;
3011:
3012: -- tables to store the derived result
3013: l_index_tbl PO_TBL_NUMBER;
3014: l_result_tbl PO_TBL_NUMBER;
3015: BEGIN
3016: d_position := 0;
3017:
3018: IF (PO_LOG.d_proc) THEN

Line 3099: p_vendor_id_tbl IN PO_TBL_NUMBER,

3095: PROCEDURE default_info_from_vendor
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:

Line 3101: x_terms_id_tbl OUT NOCOPY PO_TBL_NUMBER

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

Line 3109: l_index_tbl PO_TBL_NUMBER;

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

Line 3111: l_terms_id_tbl PO_TBL_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;
3115:

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

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();
3134: x_terms_id_tbl := PO_TBL_NUMBER();

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

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();
3134: x_terms_id_tbl := PO_TBL_NUMBER();
3135:

Line 3134: x_terms_id_tbl := PO_TBL_NUMBER();

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);
3138:

Line 3246: p_vendor_id_tbl IN PO_TBL_NUMBER,

3242: PROCEDURE default_info_from_vendor_site
3243: (
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,

Line 3247: x_vendor_site_id_tbl IN OUT NOCOPY PO_TBL_NUMBER,

3243: (
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,

Line 3251: x_ship_to_loc_id_tbl OUT NOCOPY 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,
3255: x_shipping_control_tbl OUT NOCOPY PO_TBL_VARCHAR30,

Line 3252: x_bill_to_loc_id_tbl 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,
3255: x_shipping_control_tbl OUT NOCOPY PO_TBL_VARCHAR30,
3256: x_pay_on_code_tbl OUT NOCOPY PO_TBL_VARCHAR30

Line 3254: x_terms_id_tbl OUT NOCOPY PO_TBL_NUMBER,

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
3258:

Line 3264: l_index_tbl PO_TBL_NUMBER;

3260: d_module CONSTANT VARCHAR2(255) := d_pkg_name || d_api_name || '.';
3261: d_position NUMBER;
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;

Line 3265: l_vendor_site_id_tbl PO_TBL_NUMBER;

3261: d_position NUMBER;
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;

Line 3269: l_ship_to_loc_id_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;
3273: l_shipping_control_tbl PO_TBL_VARCHAR30;

Line 3270: l_bill_to_loc_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;
3273: l_shipping_control_tbl PO_TBL_VARCHAR30;
3274: l_pay_on_code_tbl PO_TBL_VARCHAR30;

Line 3272: l_terms_id_tbl PO_TBL_NUMBER;

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:
3276: -- variable to hold index of the current processing row

Line 3290: x_ship_to_loc_id_tbl := PO_TBL_NUMBER();

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();
3294: x_shipping_control_tbl := PO_TBL_VARCHAR30();

Line 3291: x_bill_to_loc_id_tbl := PO_TBL_NUMBER();

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();
3294: x_shipping_control_tbl := PO_TBL_VARCHAR30();
3295: x_pay_on_code_tbl := PO_TBL_VARCHAR30();

Line 3293: x_terms_id_tbl := PO_TBL_NUMBER();

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:
3297: x_fob_tbl.EXTEND(p_index_tbl.COUNT);

Line 3462: p_vendor_site_id_tbl IN PO_TBL_NUMBER,

3458: PROCEDURE default_vendor_contact
3459: (
3460: p_key IN po_session_gt.key%TYPE,
3461: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,
3462: p_vendor_site_id_tbl IN PO_TBL_NUMBER,
3463: x_vendor_contact_id_tbl IN OUT NOCOPY PO_TBL_NUMBER
3464: ) IS
3465:
3466: d_api_name CONSTANT VARCHAR2(30) := 'default_vendor_contact';

Line 3463: x_vendor_contact_id_tbl IN OUT NOCOPY PO_TBL_NUMBER

3459: (
3460: p_key IN po_session_gt.key%TYPE,
3461: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,
3462: p_vendor_site_id_tbl IN PO_TBL_NUMBER,
3463: x_vendor_contact_id_tbl IN OUT NOCOPY PO_TBL_NUMBER
3464: ) IS
3465:
3466: d_api_name CONSTANT VARCHAR2(30) := 'default_vendor_contact';
3467: d_module CONSTANT VARCHAR2(255) := d_pkg_name || d_api_name || '.';

Line 3471: l_index_tbl PO_TBL_NUMBER;

3467: d_module CONSTANT VARCHAR2(255) := d_pkg_name || d_api_name || '.';
3468: d_position NUMBER;
3469:
3470: -- variables to hold defaulted results
3471: l_index_tbl PO_TBL_NUMBER;
3472: l_result_tbl PO_TBL_NUMBER;
3473:
3474: BEGIN
3475: d_position := 0;

Line 3472: l_result_tbl PO_TBL_NUMBER;

3468: d_position NUMBER;
3469:
3470: -- variables to hold defaulted results
3471: l_index_tbl PO_TBL_NUMBER;
3472: l_result_tbl PO_TBL_NUMBER;
3473:
3474: BEGIN
3475: d_position := 0;
3476:

Line 3733: p_style_id_tbl IN PO_TBL_NUMBER,

3729: PROCEDURE default_clm_standard_format
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

Line 3744: l_index_tbl PO_TBL_NUMBER;

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

Line 3886: l_index_tbl PO_TBL_NUMBER;

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

Line 3957: l_index_tbl PO_TBL_NUMBER;

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

Line 4018: x_clm_contract_officer_tbl IN OUT NOCOPY PO_TBL_NUMBER

4014: (
4015: p_key IN po_session_gt.key%TYPE,
4016: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,
4017: p_clm_contract_oficer_disp_tbl IN PO_TBL_VARCHAR240,
4018: x_clm_contract_officer_tbl IN OUT NOCOPY PO_TBL_NUMBER
4019: ) IS
4020:
4021: d_api_name CONSTANT VARCHAR2(30) := 'derive_clm_contract_officer';
4022: d_module CONSTANT VARCHAR2(255) := d_pkg_name || d_api_name || '.';

Line 4026: l_index_tbl PO_TBL_NUMBER;

4022: d_module CONSTANT VARCHAR2(255) := d_pkg_name || d_api_name || '.';
4023: d_position NUMBER;
4024:
4025: -- tables to store the derived result
4026: l_index_tbl PO_TBL_NUMBER;
4027: l_result_tbl PO_TBL_NUMBER;
4028: BEGIN
4029: d_position := 0;
4030:

Line 4027: l_result_tbl PO_TBL_NUMBER;

4023: d_position NUMBER;
4024:
4025: -- tables to store the derived result
4026: l_index_tbl PO_TBL_NUMBER;
4027: l_result_tbl PO_TBL_NUMBER;
4028: BEGIN
4029: d_position := 0;
4030:
4031: IF (PO_LOG.d_proc) THEN

Line 4088: x_clm_source_document_id_tbl IN OUT NOCOPY PO_TBL_NUMBER

4084: (
4085: p_key IN po_session_gt.key%TYPE,
4086: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,
4087: p_clm_source_document_disp_tbl IN PO_TBL_VARCHAR240,
4088: x_clm_source_document_id_tbl IN OUT NOCOPY PO_TBL_NUMBER
4089: ) IS
4090:
4091: d_api_name CONSTANT VARCHAR2(30) := 'derive_clm_source_document_id';
4092: d_module CONSTANT VARCHAR2(255) := d_pkg_name || d_api_name || '.';

Line 4096: l_index_tbl PO_TBL_NUMBER;

4092: d_module CONSTANT VARCHAR2(255) := d_pkg_name || d_api_name || '.';
4093: d_position NUMBER;
4094:
4095: -- tables to store the derived result
4096: l_index_tbl PO_TBL_NUMBER;
4097: l_result_tbl PO_TBL_NUMBER;
4098: BEGIN
4099: d_position := 0;
4100:

Line 4097: l_result_tbl PO_TBL_NUMBER;

4093: d_position NUMBER;
4094:
4095: -- tables to store the derived result
4096: l_index_tbl PO_TBL_NUMBER;
4097: l_result_tbl PO_TBL_NUMBER;
4098: BEGIN
4099: d_position := 0;
4100:
4101: IF (PO_LOG.d_proc) THEN

Line 4154: p_clm_source_document_id_tbl IN PO_TBL_NUMBER,

4150: PROCEDURE derive_vendor_id_from_idv
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:

Line 4156: x_vendor_id_tbl IN OUT NOCOPY PO_TBL_NUMBER

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

Line 4164: l_index_tbl PO_TBL_NUMBER;

4160: d_module CONSTANT VARCHAR2(255) := d_pkg_name || d_api_name || '.';
4161: d_position NUMBER;
4162:
4163: -- tables to store the derived result
4164: l_index_tbl PO_TBL_NUMBER;
4165: l_result_tbl PO_TBL_NUMBER;
4166: BEGIN
4167: d_position := 0;
4168:

Line 4165: l_result_tbl PO_TBL_NUMBER;

4161: d_position NUMBER;
4162:
4163: -- tables to store the derived result
4164: l_index_tbl PO_TBL_NUMBER;
4165: l_result_tbl PO_TBL_NUMBER;
4166: BEGIN
4167: d_position := 0;
4168:
4169: IF (PO_LOG.d_proc) THEN

Line 4222: p_clm_source_document_id_tbl IN PO_TBL_NUMBER,

4218: PROCEDURE derive_vendor_site_id_from_idv
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:

Line 4224: x_vendor_site_id_tbl IN OUT NOCOPY PO_TBL_NUMBER

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

Line 4232: l_index_tbl PO_TBL_NUMBER;

4228: d_module CONSTANT VARCHAR2(255) := d_pkg_name || d_api_name || '.';
4229: d_position NUMBER;
4230:
4231: -- tables to store the derived result
4232: l_index_tbl PO_TBL_NUMBER;
4233: l_result_tbl PO_TBL_NUMBER;
4234: BEGIN
4235: d_position := 0;
4236:

Line 4233: l_result_tbl PO_TBL_NUMBER;

4229: d_position NUMBER;
4230:
4231: -- tables to store the derived result
4232: l_index_tbl PO_TBL_NUMBER;
4233: l_result_tbl PO_TBL_NUMBER;
4234: BEGIN
4235: d_position := 0;
4236:
4237: IF (PO_LOG.d_proc) THEN