1 PACKAGE RCV_TRANSACTION_SV AUTHID CURRENT_USER AS
2 /* $Header: RCVTXPQS.pls 115.6 2002/11/23 00:54:16 sbull ship $*/
3
4 /*===========================================================================
5 PROCEDURE NAME: POST_QUERY
6
7 DESCRIPTION:
8
9 PARAMETERS:
10
11 DESIGN REFERENCES:
12
13 ALGORITHM:
14
15 NOTES:
16
17 OPEN ISSUES:
18
19 CLOSED ISSUES:
20
21 CHANGE HISTORY:
22
23 ===========================================================================*/
24 --Bug#2109106. This function has been overloaded.
25 PROCEDURE POST_QUERY ( x_transaction_id IN NUMBER,
26 x_receipt_source_code IN VARCHAR2,
27 x_organization_id IN NUMBER,
28 x_hazard_class_id IN NUMBER,
29 x_un_number_id IN NUMBER,
30 x_shipment_header_id IN NUMBER,
31 x_shipment_line_id IN NUMBER,
32 x_po_line_location_id IN NUMBER,
33 x_po_line_id IN NUMBER,
34 x_po_header_id IN NUMBER,
35 x_po_release_id IN NUMBER,
36 x_vendor_id IN NUMBER,
37 x_item_id IN NUMBER,
38 x_item_revision IN VARCHAR2,
39 x_transaction_date IN DATE,
40 x_creation_date IN DATE,
41 x_location_id IN NUMBER,
42 x_subinventory IN VARCHAR2,
43 x_destination_type_code IN VARCHAR2,
44 x_destination_type_dsp IN VARCHAR2,
45 x_primary_uom IN VARCHAR2,
46 x_routing_id IN NUMBER,
47 x_po_distribution_id IN OUT NOCOPY NUMBER,
48 x_final_dest_type_code IN OUT NOCOPY VARCHAR2,
49 x_final_dest_type_dsp IN OUT NOCOPY VARCHAR2,
50 x_final_location_id IN OUT NOCOPY NUMBER,
51 x_final_subinventory IN OUT NOCOPY VARCHAR2,
52 x_destination_context IN OUT NOCOPY VARCHAR2,
53 x_wip_entity_id IN OUT NOCOPY NUMBER,
54 x_wip_line_id IN OUT NOCOPY NUMBER,
55 x_wip_repetitive_schedule_id IN OUT NOCOPY NUMBER,
56 x_outside_processing IN OUT NOCOPY VARCHAR2,
57 x_job_schedule_dsp IN OUT NOCOPY VARCHAR2,
58 x_op_seq_num_dsp IN OUT NOCOPY VARCHAR2,
59 x_department_code IN OUT NOCOPY VARCHAR2 ,
60 x_production_line_dsp IN OUT NOCOPY VARCHAR2,
61 x_bom_resource_id IN OUT NOCOPY NUMBER,
62 x_final_deliver_to_person_id IN OUT NOCOPY NUMBER,
63 x_final_deliver_to_location_id IN OUT NOCOPY NUMBER,
64 x_person IN OUT NOCOPY VARCHAR2,
65 x_location IN OUT NOCOPY VARCHAR2,
66 x_hazard_class IN OUT NOCOPY VARCHAR2,
67 x_un_number IN OUT NOCOPY VARCHAR2,
68 x_sub_locator_control IN OUT NOCOPY VARCHAR2 ,
69 x_count IN OUT NOCOPY NUMBER ,
70 x_locator_id IN OUT NOCOPY NUMBER ,
71 x_available_qty IN OUT NOCOPY NUMBER,
72 x_primary_available_qty IN OUT NOCOPY NUMBER,
73 x_tolerable_qty IN OUT NOCOPY NUMBER ,
74 x_uom IN OUT NOCOPY VARCHAR2,
75 x_count_po_distribution IN OUT NOCOPY NUMBER,
76 x_receiving_dsp_value IN OUT NOCOPY VARCHAR2,
77 x_po_operation_seq_num IN OUT NOCOPY NUMBER,
78 x_po_resource_seq_num IN OUT NOCOPY NUMBER,
79 x_currency_conv_rate IN OUT NOCOPY NUMBER,
80 x_currency_conv_date IN OUT NOCOPY DATE,
81 x_oe_order_line_id IN NUMBER,
82 /* Bug# 1548597 */
83 x_secondary_available_qty IN OUT NOCOPY NUMBER,
84 -- <RCV ENH FPI START>
85 p_req_line_id IN NUMBER,
86 p_req_distribution_id IN NUMBER,
87 x_kanban_card_number OUT NOCOPY VARCHAR2,
88 x_project_number OUT NOCOPY VARCHAR2,
89 x_task_number OUT NOCOPY VARCHAR2,
90 x_charge_account OUT NOCOPY VARCHAR2
91 -- <RCV ENH FPI END>
92 )
93 ;
94 -- End 1548597
95 -- Bug#2109106. This function has been overloaded.This has been done because
96 -- the change done for OPM to include the parameter x_secondary_available_qty
97 -- breaks the inventory api call to this procedure.x_secondary_available_qty
98 -- has been removed from the parameters.
99 -- This has been done for WMS only.
100
101 PROCEDURE POST_QUERY ( x_transaction_id IN NUMBER,
102 x_receipt_source_code IN VARCHAR2,
103 x_organization_id IN NUMBER,
104 x_hazard_class_id IN NUMBER,
105 x_un_number_id IN NUMBER,
106 x_shipment_header_id IN NUMBER,
107 x_shipment_line_id IN NUMBER,
108 x_po_line_location_id IN NUMBER,
109 x_po_line_id IN NUMBER,
110 x_po_header_id IN NUMBER,
111 x_po_release_id IN NUMBER,
112 x_vendor_id IN NUMBER,
113 x_item_id IN NUMBER,
114 x_item_revision IN VARCHAR2,
115 x_transaction_date IN DATE,
116 x_creation_date IN DATE,
117 x_location_id IN NUMBER,
118 x_subinventory IN VARCHAR2,
119 x_destination_type_code IN VARCHAR2,
120 x_destination_type_dsp IN VARCHAR2,
121 x_primary_uom IN VARCHAR2,
122 x_routing_id IN NUMBER,
123 x_po_distribution_id IN OUT NOCOPY NUMBER,
124 x_final_dest_type_code IN OUT NOCOPY VARCHAR2,
125 x_final_dest_type_dsp IN OUT NOCOPY VARCHAR2,
126 x_final_location_id IN OUT NOCOPY NUMBER,
127 x_final_subinventory IN OUT NOCOPY VARCHAR2,
128 x_destination_context IN OUT NOCOPY VARCHAR2,
129 x_wip_entity_id IN OUT NOCOPY NUMBER,
130 x_wip_line_id IN OUT NOCOPY NUMBER,
131 x_wip_repetitive_schedule_id IN OUT NOCOPY NUMBER,
132 x_outside_processing IN OUT NOCOPY VARCHAR2,
133 x_job_schedule_dsp IN OUT NOCOPY VARCHAR2,
134 x_op_seq_num_dsp IN OUT NOCOPY VARCHAR2,
135 x_department_code IN OUT NOCOPY VARCHAR2 ,
136 x_production_line_dsp IN OUT NOCOPY VARCHAR2,
137 x_bom_resource_id IN OUT NOCOPY NUMBER,
138 x_final_deliver_to_person_id IN OUT NOCOPY NUMBER,
139 x_final_deliver_to_location_id IN OUT NOCOPY NUMBER,
140 x_person IN OUT NOCOPY VARCHAR2,
141 x_location IN OUT NOCOPY VARCHAR2,
142 x_hazard_class IN OUT NOCOPY VARCHAR2,
143 x_un_number IN OUT NOCOPY VARCHAR2,
144 x_sub_locator_control IN OUT NOCOPY VARCHAR2 ,
145 x_count IN OUT NOCOPY NUMBER ,
146 x_locator_id IN OUT NOCOPY NUMBER ,
147 x_available_qty IN OUT NOCOPY NUMBER,
148 x_primary_available_qty IN OUT NOCOPY NUMBER,
149 x_tolerable_qty IN OUT NOCOPY NUMBER ,
150 x_uom IN OUT NOCOPY VARCHAR2,
151 x_count_po_distribution IN OUT NOCOPY NUMBER,
152 x_receiving_dsp_value IN OUT NOCOPY VARCHAR2,
153 x_po_operation_seq_num IN OUT NOCOPY NUMBER,
154 x_po_resource_seq_num IN OUT NOCOPY NUMBER,
155 x_currency_conv_rate IN OUT NOCOPY NUMBER,
156 x_currency_conv_date IN OUT NOCOPY DATE,
157 x_oe_order_line_id IN NUMBER);
158
159 END RCV_TRANSACTION_SV;