[Home] [Help]
PACKAGE: APPS.RCV_TABLE_FUNCTIONS
Source
1 PACKAGE rcv_table_functions AS
2 /* $Header: RCVTBFNS.pls 120.3.12010000.3 2008/12/26 07:26:54 ksivasa ship $*/
3
4 TYPE lookup_table_type IS TABLE OF VARCHAR2(80) INDEX BY VARCHAR2(80);
5
6 e_fatal_error EXCEPTION;
7 g_error_column VARCHAR2(80);
8 g_default_org_id NUMBER;
9
10 g_mp_org_id NUMBER; -- lcm changes
11 g_rp_org_id NUMBER; -- lcm changes
12 g_lcm_enabled_flag VARCHAR2(1); -- lcm changes
13 g_pre_rcv_flag VARCHAR2(1); -- lcm changes
14 g_pll_id NUMBER; -- lcm changes
15 g_lcm_flag VARCHAR2(1); -- lcm changes
16
17 /* Bug 5246147: Removed the following function declarations,
18 get_fspa_row_from_org() and
19 get_sob_row_from_id() */
20
21 FUNCTION get_rhi_row_from_id(
22 p_header_interface_id IN rcv_headers_interface.header_interface_id%TYPE
23 )
24 RETURN rcv_headers_interface%ROWTYPE;
25
26 PROCEDURE update_rhi_row(
27 p_rhi_row IN rcv_headers_interface%ROWTYPE
28 );
29
30 FUNCTION get_rti_row_from_id(
31 p_interface_transaction_id IN rcv_transactions_interface.interface_transaction_id%TYPE
32 )
33 RETURN rcv_transactions_interface%ROWTYPE;
34
35 PROCEDURE update_rti_row(
36 p_rti_row IN rcv_transactions_interface%ROWTYPE
37 );
38
39 FUNCTION get_rt_row_from_id(
40 p_transaction_id IN rcv_transactions.transaction_id%TYPE
41 )
42 RETURN rcv_transactions%ROWTYPE;
43
44 FUNCTION get_rsh_row_from_num(
45 p_shipment_num IN rcv_shipment_headers.shipment_num%TYPE,
46 p_vendor_id IN rcv_shipment_headers.vendor_id%TYPE,
47 p_vendor_site_id IN rcv_shipment_headers.vendor_site_id%TYPE,
48 p_ship_to_org_id IN rcv_shipment_headers.ship_to_org_id%TYPE,
49 p_shipped_date IN rcv_shipment_headers.shipped_date%TYPE,
50 no_data_found_is_error IN BOOLEAN
51 )
52 RETURN rcv_shipment_headers%ROWTYPE;
53
54 FUNCTION get_rsh_row_from_id(
55 p_shipment_header_id IN rcv_shipment_headers.shipment_header_id%TYPE
56 )
57 RETURN rcv_shipment_headers%ROWTYPE;
58
59 FUNCTION get_rsl_row_from_num(
60 p_line_num rcv_shipment_lines.line_num%TYPE,
61 p_shipment_header_id rcv_shipment_lines.shipment_header_id%TYPE
62 )
63 RETURN rcv_shipment_lines%ROWTYPE;
64
65 FUNCTION get_rsl_row_from_id(
66 p_shipment_line_id IN rcv_shipment_lines.shipment_line_id%TYPE
67 )
68 RETURN rcv_shipment_lines%ROWTYPE;
69
70 PROCEDURE update_rsl_row(
71 p_rsl_row IN rcv_shipment_lines%ROWTYPE
72 );
73
74 FUNCTION get_poh_row_from_num(
75 p_po_num po_headers_all.segment1%TYPE,
76 p_org_id po_headers_all.org_id%TYPE
77 )
78 RETURN po_headers_all%ROWTYPE;
79
80 FUNCTION get_poh_row_from_id(
81 p_header_id IN po_headers_all.po_header_id%TYPE
82 )
83 RETURN po_headers_all%ROWTYPE;
84
85 FUNCTION get_pol_row_from_num(
86 p_line_num po_lines_all.line_num%TYPE,
87 p_header_id po_lines_all.po_header_id%TYPE,
88 p_item_description po_lines_all.item_description%TYPE,
89 p_vendor_product_num po_lines_all.vendor_product_num%TYPE,
90 p_item_id po_lines_all.item_id%TYPE
91 )
92 RETURN po_lines_all%ROWTYPE;
93 -- Bug 7645326 Added item_id in the above Function
94
95 FUNCTION get_pol_row_from_id(
96 p_line_id IN po_lines_all.po_line_id%TYPE
97 )
98 RETURN po_lines_all%ROWTYPE;
99
100 FUNCTION get_pll_row_from_num(
101 p_shipment_num po_line_locations_all.shipment_num%TYPE,
102 p_line_id po_line_locations_all.po_line_id%TYPE
103 )
104 RETURN po_line_locations_all%ROWTYPE;
105
106 FUNCTION get_pll_row_from_id(
107 p_line_location_id IN po_line_locations_all.line_location_id%TYPE
108 )
109 RETURN po_line_locations_all%ROWTYPE;
110
111 FUNCTION get_pod_row_from_num(
112 p_distribution_num po_distributions_all.distribution_num%TYPE,
113 p_line_location_id po_distributions_all.line_location_id%TYPE
114 )
115 RETURN po_distributions_all%ROWTYPE;
116
117 FUNCTION get_pod_row_from_id(
118 p_distribution_id IN po_distributions_all.po_distribution_id%TYPE
119 )
120 RETURN po_distributions_all%ROWTYPE;
121
122 FUNCTION get_pvs_row_from_id( p_vendor_site_id IN po_vendor_sites_all.vendor_site_id%TYPE )
123 RETURN po_vendor_sites_all%ROWTYPE;
124
125 FUNCTION get_oeh_row_from_num(
126 p_order_number oe_order_headers_all.order_number%TYPE,
127 p_order_type_id oe_order_headers_all.order_type_id%TYPE,
128 p_version_number oe_order_headers_all.version_number%TYPE,
129 p_org_id oe_order_headers_all.org_id%TYPE
130 )
131 RETURN oe_order_headers_all%ROWTYPE;
132
133 FUNCTION get_oeh_row_from_id(
134 p_header_id IN oe_order_headers_all.header_id%TYPE
135 )
136 RETURN oe_order_headers_all%ROWTYPE;
137
138 FUNCTION get_oel_row_from_num(
139 p_line_number oe_order_lines_all.line_number%TYPE,
140 p_header_id oe_order_lines_all.header_id%TYPE
141 )
142 RETURN oe_order_lines_all%ROWTYPE;
143
144 FUNCTION get_oel_row_from_id(
145 p_line_id IN oe_order_lines_all.line_id%TYPE
146 )
147 RETURN oe_order_lines_all%ROWTYPE;
148
149 FUNCTION get_prl_row_from_id(
150 p_requisition_line_id IN po_requisition_lines_all.requisition_line_id%TYPE
151 )
152 RETURN po_requisition_lines_all%ROWTYPE;
153
154 FUNCTION get_prd_row_from_id(
155 p_req_distribution_id IN po_req_distributions_all.distribution_id%TYPE
156 )
157 RETURN po_req_distributions_all%ROWTYPE;
158
159 FUNCTION get_msi_row_from_num
160 ( p_item_id IN mtl_system_items.inventory_item_id%TYPE
161 , p_org_id IN mtl_system_items.organization_id%TYPE
162 )
163 RETURN mtl_system_items%ROWTYPE;
164
165 FUNCTION get_mic_row_from_num
166 ( p_item_id IN mtl_item_categories.inventory_item_id%TYPE
167 , p_org_id IN mtl_item_categories.organization_id%TYPE
168 )
169 RETURN mtl_item_categories%ROWTYPE;
170
171 FUNCTION get_mp_row_from_org( p_org_id IN mtl_parameters.organization_id%TYPE )
172 RETURN mtl_parameters%ROWTYPE;
173
174 FUNCTION get_rp_row_from_org( p_org_id IN rcv_parameters.organization_id%TYPE )
175 RETURN rcv_parameters%ROWTYPE;
176
177 FUNCTION get_fc_row_from_code( p_currency_code IN fnd_currencies.currency_code%TYPE )
178 RETURN fnd_currencies%ROWTYPE;
179
180 FUNCTION get_fsp_row
181 RETURN financials_system_parameters%ROWTYPE;
182
183
184 FUNCTION get_muom_row_from_name( p_unit_of_measure IN mtl_units_of_measure.unit_of_measure%TYPE )
185 RETURN mtl_units_of_measure%ROWTYPE;
186
187 FUNCTION get_po_lookup
188 ( p_lookup_type IN po_lookup_codes.lookup_type%TYPE
189 , p_lookup_code IN po_lookup_codes.lookup_code%TYPE
190 ) RETURN po_lookup_codes.displayed_field%TYPE;
191
192 -- lcm changes
193 FUNCTION is_lcm_shipment
194 ( p_po_line_location_id IN NUMBER )
195 RETURN VARCHAR2;
196
197 FUNCTION is_lcm_org
198 ( p_organization_id IN NUMBER )
199 RETURN VARCHAR2;
200
201 FUNCTION is_pre_rcv_org
202 ( p_organization_id IN NUMBER )
203 RETURN VARCHAR2;
204
205 END rcv_table_functions;