1 PACKAGE RCV_DISTRIBUTIONS_S AUTHID CURRENT_USER AS
2 /* $Header: RCVTXDIS.pls 115.2 2002/11/23 00:55:40 sbull ship $*/
3
4 /*===========================================================================
5 PROCEDURE NAME: get_distribution_info ()
6
7 DESCRIPTION: Go get the default destination information for either
8 a po or an internal shipment along with any wip info
9 if necessary
10
11 PARAMETERS:
12
13 X_line_location_id IN NUMBER,
14 X_shipment_line_id IN NUMBER,
15 X_item_id IN NUMBER,
16 X_num_of_distributions IN OUT NUMBER,
17 X_po_distributions_id OUT NUMBER,
18 X_destination_type_code IN OUT VARCHAR2,
19 X_destination_type_dsp OUT VARCHAR2,
20 X_deliver_to_location_id OUT NUMBER,
21 X_deliver_to_location OUT VARCHAR2,
22 X_deliver_to_person_id OUT NUMBER,
23 X_deliver_to_person OUT VARCHAR2,
24 X_deliver_to_sub OUT VARCHAR2,
25 X_deliver_to_locator_id OUT NUMBER,
26 X_deliver_to_locator OUT VARCHAR2,
27 X_wip_entity_id IN OUT NUMBER,
28 X_wip_repetitive_schedule_id IN OUT NUMBER,
29 X_wip_line_id IN OUT NUMBER,
30 X_wip_operation_seq_num IN OUT NUMBER,
31 X_wip_resource_seq_num IN OUT NUMBER,
32 X_bom_resource_id IN OUT NUMBER,
33 X_to_organization_id IN OUT NUMBER,
34 X_job IN OUT VARCHAR2,
35 X_line_num IN OUT VARCHAR2,
36 X_sequence IN OUT NUMBER,
37 X_department IN OUT VARCHAR2
38 X_rate IN OUT NUMBER
39 X_rate_date IN OUT DATE
40 -- <RCV ENH FPI START>
41 x_kanban_card_number OUT NOCOPY VARCHAR2,
42 x_project_number OUT NOCOPY VARCHAR2,
43 x_task_number OUT NOCOPY VARCHAR2,
44 x_charge_account OUT NOCOPY VARCHAR2
45 -- <RCV ENH FPI END>
46
47 DESIGN REFERENCES: RCVRCERC.dd
48 RCVTXERT.dd
49
50 ALGORITHM:
51
52 NOTES:
53
54 OPEN ISSUES:
55
56 CLOSED ISSUES:
57
58 CHANGE HISTORY:
59
60 ===========================================================================*/
61
62 PROCEDURE get_distributions_info
63 (X_line_location_id IN NUMBER,
64 X_shipment_line_id IN NUMBER,
65 X_item_id IN NUMBER,
66 X_num_of_distributions IN OUT NOCOPY NUMBER,
67 X_po_distributions_id OUT NOCOPY NUMBER,
68 X_destination_type_code IN OUT NOCOPY VARCHAR2,
69 X_destination_type_dsp OUT NOCOPY VARCHAR2,
70 X_deliver_to_location_id IN OUT NOCOPY NUMBER,
71 X_deliver_to_location OUT NOCOPY VARCHAR2,
72 X_deliver_to_person_id IN OUT NOCOPY NUMBER,
73 X_deliver_to_person OUT NOCOPY VARCHAR2,
74 X_deliver_to_sub IN OUT NOCOPY VARCHAR2,
75 X_deliver_to_locator_id OUT NOCOPY NUMBER,
76 X_deliver_to_locator OUT NOCOPY VARCHAR2,
77 X_wip_entity_id IN OUT NOCOPY NUMBER,
78 X_wip_repetitive_schedule_id IN OUT NOCOPY NUMBER,
79 X_wip_line_id IN OUT NOCOPY NUMBER,
80 X_wip_operation_seq_num IN OUT NOCOPY NUMBER,
81 X_wip_resource_seq_num IN OUT NOCOPY NUMBER,
82 X_bom_resource_id IN OUT NOCOPY NUMBER,
83 X_to_organization_id IN OUT NOCOPY NUMBER,
84 X_job IN OUT NOCOPY VARCHAR2,
85 X_line_num IN OUT NOCOPY VARCHAR2,
86 X_sequence IN OUT NOCOPY NUMBER,
87 X_department IN OUT NOCOPY VARCHAR2,
88 X_rate IN OUT NOCOPY NUMBER,
89 X_rate_date IN OUT NOCOPY DATE,
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: test_rcv_distributions_s ()
100
101 DESCRIPTION: Test all functions and procedures in the
102 rcv_distributions_s
103
104 PARAMETERS: X_line_location_id IN NUMBER
105 -- The line location you wish to look for
106 X_shipment_line_id IN NUMBER
107 -- The RCV shipment line id you wish to look for
108 X_item_id IN NUMBER
109 -- The item thats on the line
110
111 DESIGN REFERENCES:
112
113 ALGORITHM:
114
115 NOTES:
116
117 OPEN ISSUES:
118
119 CLOSED ISSUES:
120
121 CHANGE HISTORY:
122
123 ===========================================================================*/
124
125 PROCEDURE test_rcv_distributions_s
126 (X_line_location_id IN NUMBER,
127 X_shipment_line_id IN NUMBER,
128 X_item_id IN NUMBER);
129
130 -- <RCV ENH FPI START>
131 PROCEDURE get_misc_distr_info
132 (x_return_status OUT NOCOPY VARCHAR2,
133 p_line_location_id IN NUMBER,
134 p_po_distribution_id IN NUMBER,
135 x_kanban_card_number OUT NOCOPY VARCHAR2,
136 x_project_number OUT NOCOPY VARCHAR2,
137 x_task_number OUT NOCOPY VARCHAR2,
138 x_charge_account OUT NOCOPY VARCHAR2,
139 x_deliver_to_person OUT NOCOPY VARCHAR2,
140 x_job OUT NOCOPY VARCHAR2,
141 x_outside_line_num OUT NOCOPY VARCHAR2,
142 x_sequence OUT NOCOPY NUMBER,
143 x_department OUT NOCOPY VARCHAR2,
144 x_dest_subinv OUT NOCOPY VARCHAR2,
145 x_rate OUT NOCOPY NUMBER,
146 x_rate_date OUT NOCOPY DATE);
147
148 PROCEDURE get_misc_req_distr_info
149 (x_return_status OUT NOCOPY VARCHAR2,
150 p_requisition_line_id IN NUMBER,
151 p_req_distribution_id IN NUMBER,
152 x_kanban_card_number OUT NOCOPY VARCHAR2,
153 x_project_number OUT NOCOPY VARCHAR2,
154 x_task_number OUT NOCOPY VARCHAR2,
155 x_charge_account OUT NOCOPY VARCHAR2,
156 x_deliver_to_person OUT NOCOPY VARCHAR2,
157 x_dest_subinv OUT NOCOPY VARCHAR2);
158
159 -- <RCV ENH FPI END>
160
161 END RCV_DISTRIBUTIONS_S;