1 PACKAGE RCV_RECEIPTS_QUERY_SV AUTHID CURRENT_USER AS
2 /* $Header: RCVRCPQS.pls 120.0.12010000.1 2008/07/24 14:36:34 appldev ship $*/
3
4 /*===========================================================================
5 PROCEDURE NAME: post_query()
6
7 DESCRIPTION:
8 This is the wrapper procedure for the Enter Receipts post query
9 logic.
10
11 USAGE:
12
13 PARAMETERS:
14
15 DESIGN REFERENCES: Generic
16
17 ALGORITHM:
18
19 NOTES:
20
21 OPEN ISSUES:
22
23 CLOSED ISSUES:
24
25 CHANGE HISTORY:
26 24-MAY-95 Sanjay Kothary Created
27 24-JUL-01 Sanjay Kumar Bug# 1432909
28 20-AUG-01 Sanjay Kumar Bug# 1942953
29 ===========================================================================*/
30 /* Bug# 1942953 - Added x_from_org_id as a new parameter in the POST_QUERY */
31
32 -- <ENT RCPT PERF FPI>
33 TYPE NUM_TBL_TYPE IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;
34
35
36 PROCEDURE POST_QUERY ( x_line_location_id IN NUMBER,
37 x_shipment_line_id IN NUMBER,
38 x_receipt_source_code IN VARCHAR2,
39 x_org_id IN NUMBER,
40 x_item_id IN NUMBER,
41 x_unit_of_measure_class IN VARCHAR2,
42 x_ship_to_location_id IN NUMBER,
43 x_vendor_id IN NUMBER,
44 x_customer_id IN NUMBER,
45 x_item_rev_control_flag_to IN VARCHAR2,
46 x_available_qty IN OUT NOCOPY NUMBER,
47 x_primary_qty IN OUT NOCOPY NUMBER,
48 x_tolerable_qty IN OUT NOCOPY NUMBER,
49 x_uom IN OUT NOCOPY VARCHAR2,
50 x_primary_uom IN OUT NOCOPY VARCHAR2,
51 x_valid_ship_to_location IN OUT NOCOPY BOOLEAN,
52 x_num_of_distributions IN OUT NOCOPY NUMBER,
53 x_po_distributions_id IN OUT NOCOPY NUMBER,
54 x_destination_type_code IN OUT NOCOPY VARCHAR2,
55 x_destination_type_dsp IN OUT NOCOPY VARCHAR2,
56 x_deliver_to_location_id IN OUT NOCOPY NUMBER,
57 x_deliver_to_location IN OUT NOCOPY VARCHAR2,
58 x_deliver_to_person_id IN OUT NOCOPY NUMBER,
59 x_deliver_to_person IN OUT NOCOPY VARCHAR2,
60 x_deliver_to_sub IN OUT NOCOPY VARCHAR2,
61 x_deliver_to_locator_id IN OUT NOCOPY NUMBER,
62 x_wip_entity_id IN OUT NOCOPY NUMBER,
63 x_wip_repetitive_schedule_id IN OUT NOCOPY NUMBER,
64 x_wip_line_id IN OUT NOCOPY NUMBER,
65 x_wip_operation_seq_num IN OUT NOCOPY NUMBER,
66 x_wip_resource_seq_num IN OUT NOCOPY NUMBER,
67 x_bom_resource_id IN OUT NOCOPY NUMBER,
68 x_to_organization_id IN OUT NOCOPY NUMBER,
69 x_job IN OUT NOCOPY VARCHAR2,
70 x_line_num IN OUT NOCOPY VARCHAR2,
71 x_sequence IN OUT NOCOPY NUMBER,
72 x_department IN OUT NOCOPY VARCHAR2,
73 x_enforce_ship_to_loc IN OUT NOCOPY VARCHAR2,
74 x_allow_substitutes IN OUT NOCOPY VARCHAR2,
75 x_routing_id IN OUT NOCOPY NUMBER,
76 x_qty_rcv_tolerance IN OUT NOCOPY NUMBER,
77 x_qty_rcv_exception IN OUT NOCOPY VARCHAR2,
78 x_days_early_receipt IN OUT NOCOPY NUMBER,
79 x_days_late_receipt IN OUT NOCOPY NUMBER,
80 x_rcv_days_exception IN OUT NOCOPY VARCHAR2,
81 x_item_revision IN OUT NOCOPY VARCHAR2,
82 x_locator_control IN OUT NOCOPY NUMBER,
83 x_inv_destinations IN OUT NOCOPY BOOLEAN,
84 x_rate IN OUT NOCOPY NUMBER,
85 x_rate_date IN OUT NOCOPY DATE,
86 x_asn_type IN VARCHAR2,
87 x_oe_order_header_id IN NUMBER,
88 x_oe_order_line_id IN NUMBER,
89 x_from_org_id IN NUMBER DEFAULT NULL,
90 -- <RCV ENH FPI START>
91 x_kanban_card_number OUT NOCOPY VARCHAR2,
92 x_project_number OUT NOCOPY VARCHAR2,
93 x_task_number OUT NOCOPY VARCHAR2,
94 x_charge_account OUT NOCOPY VARCHAR2
95 -- <RCV ENH FPI END>
96 );
97
98 /*===========================================================================
99 PROCEDURE NAME: post_query()
100
101 DESCRIPTION:
102 This is the overloading procedure intended to be used by INV team.
103
104
105 CHANGE HISTORY:
106 12/31/02 BAO created (for bug2730828)
107
108 ===========================================================================*/
109 PROCEDURE POST_QUERY ( x_line_location_id IN NUMBER,
110 x_shipment_line_id IN NUMBER,
111 x_receipt_source_code IN VARCHAR2,
112 x_org_id IN NUMBER,
113 x_item_id IN NUMBER,
114 x_unit_of_measure_class IN VARCHAR2,
115 x_ship_to_location_id IN NUMBER,
116 x_vendor_id IN NUMBER,
117 x_customer_id IN NUMBER,
118 x_item_rev_control_flag_to IN VARCHAR2,
119 x_available_qty IN OUT NOCOPY NUMBER,
120 x_primary_qty IN OUT NOCOPY NUMBER,
121 x_tolerable_qty IN OUT NOCOPY NUMBER,
122 x_uom IN OUT NOCOPY VARCHAR2,
123 x_primary_uom IN OUT NOCOPY VARCHAR2,
124 x_valid_ship_to_location IN OUT NOCOPY BOOLEAN,
125 x_num_of_distributions IN OUT NOCOPY NUMBER,
126 x_po_distributions_id IN OUT NOCOPY NUMBER,
127 x_destination_type_code IN OUT NOCOPY VARCHAR2,
128 x_destination_type_dsp IN OUT NOCOPY VARCHAR2,
129 x_deliver_to_location_id IN OUT NOCOPY NUMBER,
130 x_deliver_to_location IN OUT NOCOPY VARCHAR2,
131 x_deliver_to_person_id IN OUT NOCOPY NUMBER,
132 x_deliver_to_person IN OUT NOCOPY VARCHAR2,
133 x_deliver_to_sub IN OUT NOCOPY VARCHAR2,
134 x_deliver_to_locator_id IN OUT NOCOPY NUMBER,
135 x_wip_entity_id IN OUT NOCOPY NUMBER,
136 x_wip_repetitive_schedule_id IN OUT NOCOPY NUMBER,
137 x_wip_line_id IN OUT NOCOPY NUMBER,
138 x_wip_operation_seq_num IN OUT NOCOPY NUMBER,
139 x_wip_resource_seq_num IN OUT NOCOPY NUMBER,
140 x_bom_resource_id IN OUT NOCOPY NUMBER,
141 x_to_organization_id IN OUT NOCOPY NUMBER,
142 x_job IN OUT NOCOPY VARCHAR2,
143 x_line_num IN OUT NOCOPY VARCHAR2,
144 x_sequence IN OUT NOCOPY NUMBER,
145 x_department IN OUT NOCOPY VARCHAR2,
146 x_enforce_ship_to_loc IN OUT NOCOPY VARCHAR2,
147 x_allow_substitutes IN OUT NOCOPY VARCHAR2,
148 x_routing_id IN OUT NOCOPY NUMBER,
149 x_qty_rcv_tolerance IN OUT NOCOPY NUMBER,
150 x_qty_rcv_exception IN OUT NOCOPY VARCHAR2,
151 x_days_early_receipt IN OUT NOCOPY NUMBER,
152 x_days_late_receipt IN OUT NOCOPY NUMBER,
153 x_rcv_days_exception IN OUT NOCOPY VARCHAR2,
154 x_item_revision IN OUT NOCOPY VARCHAR2,
155 x_locator_control IN OUT NOCOPY NUMBER,
156 x_inv_destinations IN OUT NOCOPY BOOLEAN,
157 x_rate IN OUT NOCOPY NUMBER,
158 x_rate_date IN OUT NOCOPY DATE,
159 x_asn_type IN VARCHAR2,
160 x_oe_order_header_id IN NUMBER,
161 x_oe_order_line_id IN NUMBER,
162 x_from_org_id IN NUMBER DEFAULT NULL);
163
164
165 -- <ENT RCPT PERF FPI START>
166
167 PROCEDURE exec_dynamic_sql(p_query IN VARCHAR2,
168 p_val IN RCV_RECEIPTS_QUERY_SV.NUM_TBL_TYPE,
169 x_exist OUT NOCOPY VARCHAR2) ;
170
171 -- <ENT RCPT PERF FPI END>
172
173 END RCV_RECEIPTS_QUERY_SV;
174