[Home] [Help]
PACKAGE: APPS.RCV_TABLE_FUNCTIONS
Source
1 PACKAGE rcv_table_functions AUTHID CURRENT_USER AS
2 /* $Header: RCVTBFNS.pls 120.3.12010000.4 2010/03/02 09:34: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 --Bug 9005670 Added input parameter receipt_source_code.
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 p_receipt_source_code IN rcv_shipment_headers.receipt_source_code%TYPE,
51 no_data_found_is_error IN BOOLEAN
52 )
53 RETURN rcv_shipment_headers%ROWTYPE;
54
55 FUNCTION get_rsh_row_from_id(
56 p_shipment_header_id IN rcv_shipment_headers.shipment_header_id%TYPE
57 )
58 RETURN rcv_shipment_headers%ROWTYPE;
59
60 FUNCTION get_rsl_row_from_num(
61 p_line_num rcv_shipment_lines.line_num%TYPE,
62 p_shipment_header_id rcv_shipment_lines.shipment_header_id%TYPE
63 )
64 RETURN rcv_shipment_lines%ROWTYPE;
65
66 FUNCTION get_rsl_row_from_id(
67 p_shipment_line_id IN rcv_shipment_lines.shipment_line_id%TYPE
68 )
69 RETURN rcv_shipment_lines%ROWTYPE;
70
71 PROCEDURE update_rsl_row(
72 p_rsl_row IN rcv_shipment_lines%ROWTYPE
73 );
74
75 FUNCTION get_poh_row_from_num(
76 p_po_num po_headers_all.segment1%TYPE,
77 p_org_id po_headers_all.org_id%TYPE
78 )
79 RETURN po_headers_all%ROWTYPE;
80
81 FUNCTION get_poh_row_from_id(
82 p_header_id IN po_headers_all.po_header_id%TYPE
83 )
84 RETURN po_headers_all%ROWTYPE;
85
86 FUNCTION get_pol_row_from_num(
87 p_line_num po_lines_all.line_num%TYPE,
88 p_header_id po_lines_all.po_header_id%TYPE,
89 p_item_description po_lines_all.item_description%TYPE,
90 p_vendor_product_num po_lines_all.vendor_product_num%TYPE,
91 p_item_id po_lines_all.item_id%TYPE
92 )
93 RETURN po_lines_all%ROWTYPE;
94 -- Bug 7645326 Added item_id in the above Function
95
96 FUNCTION get_pol_row_from_id(
97 p_line_id IN po_lines_all.po_line_id%TYPE
98 )
99 RETURN po_lines_all%ROWTYPE;
100
101 FUNCTION get_pll_row_from_num(
102 p_shipment_num po_line_locations_all.shipment_num%TYPE,
103 p_line_id po_line_locations_all.po_line_id%TYPE
104 )
105 RETURN po_line_locations_all%ROWTYPE;
106
107 FUNCTION get_pll_row_from_id(
108 p_line_location_id IN po_line_locations_all.line_location_id%TYPE
109 )
110 RETURN po_line_locations_all%ROWTYPE;
111
112 FUNCTION get_pod_row_from_num(
113 p_distribution_num po_distributions_all.distribution_num%TYPE,
114 p_line_location_id po_distributions_all.line_location_id%TYPE
115 )
116 RETURN po_distributions_all%ROWTYPE;
117
118 FUNCTION get_pod_row_from_id(
119 p_distribution_id IN po_distributions_all.po_distribution_id%TYPE
120 )
121 RETURN po_distributions_all%ROWTYPE;
122
123 FUNCTION get_pvs_row_from_id( p_vendor_site_id IN po_vendor_sites_all.vendor_site_id%TYPE )
124 RETURN po_vendor_sites_all%ROWTYPE;
125
126 FUNCTION get_oeh_row_from_num(
127 p_order_number oe_order_headers_all.order_number%TYPE,
128 p_order_type_id oe_order_headers_all.order_type_id%TYPE,
129 p_version_number oe_order_headers_all.version_number%TYPE,
130 p_org_id oe_order_headers_all.org_id%TYPE
131 )
132 RETURN oe_order_headers_all%ROWTYPE;
133
134 FUNCTION get_oeh_row_from_id(
135 p_header_id IN oe_order_headers_all.header_id%TYPE
136 )
137 RETURN oe_order_headers_all%ROWTYPE;
138
139 FUNCTION get_oel_row_from_num(
140 p_line_number oe_order_lines_all.line_number%TYPE,
141 p_header_id oe_order_lines_all.header_id%TYPE
142 )
143 RETURN oe_order_lines_all%ROWTYPE;
144
145 FUNCTION get_oel_row_from_id(
146 p_line_id IN oe_order_lines_all.line_id%TYPE
147 )
148 RETURN oe_order_lines_all%ROWTYPE;
149
150 FUNCTION get_prl_row_from_id(
151 p_requisition_line_id IN po_requisition_lines_all.requisition_line_id%TYPE
152 )
153 RETURN po_requisition_lines_all%ROWTYPE;
154
155 FUNCTION get_prd_row_from_id(
156 p_req_distribution_id IN po_req_distributions_all.distribution_id%TYPE
157 )
158 RETURN po_req_distributions_all%ROWTYPE;
159
160 FUNCTION get_msi_row_from_num
161 ( p_item_id IN mtl_system_items.inventory_item_id%TYPE
162 , p_org_id IN mtl_system_items.organization_id%TYPE
163 )
164 RETURN mtl_system_items%ROWTYPE;
165
166 FUNCTION get_mic_row_from_num
167 ( p_item_id IN mtl_item_categories.inventory_item_id%TYPE
168 , p_org_id IN mtl_item_categories.organization_id%TYPE
169 )
170 RETURN mtl_item_categories%ROWTYPE;
171
172 FUNCTION get_mp_row_from_org( p_org_id IN mtl_parameters.organization_id%TYPE )
173 RETURN mtl_parameters%ROWTYPE;
174
175 FUNCTION get_rp_row_from_org( p_org_id IN rcv_parameters.organization_id%TYPE )
176 RETURN rcv_parameters%ROWTYPE;
177
178 FUNCTION get_fc_row_from_code( p_currency_code IN fnd_currencies.currency_code%TYPE )
179 RETURN fnd_currencies%ROWTYPE;
180
181 FUNCTION get_fsp_row
182 RETURN financials_system_parameters%ROWTYPE;
183
184
185 FUNCTION get_muom_row_from_name( p_unit_of_measure IN mtl_units_of_measure.unit_of_measure%TYPE )
186 RETURN mtl_units_of_measure%ROWTYPE;
187
188 FUNCTION get_po_lookup
189 ( p_lookup_type IN po_lookup_codes.lookup_type%TYPE
190 , p_lookup_code IN po_lookup_codes.lookup_code%TYPE
191 ) RETURN po_lookup_codes.displayed_field%TYPE;
192
193 -- lcm changes
194 FUNCTION is_lcm_shipment
195 ( p_po_line_location_id IN NUMBER )
196 RETURN VARCHAR2;
197
198 FUNCTION is_lcm_org
199 ( p_organization_id IN NUMBER )
200 RETURN VARCHAR2;
201
202 FUNCTION is_pre_rcv_org
203 ( p_organization_id IN NUMBER )
204 RETURN VARCHAR2;
205
206 END rcv_table_functions;