1 PACKAGE po_autocreate_grouping_pvt AUTHID CURRENT_USER AS
2 /* $Header: PO_AUTOCREATE_GROUPING_PVT.pls 120.6.12020000.4 2013/04/08 10:50:13 jemishra ship $ */
3
4 FUNCTION get_line_action_tbl(
5 p_po_line_number_tbl IN PO_TBL_NUMBER,
6 p_add_to_po_header_id IN NUMBER,
7 p_draft_id IN NUMBER --CLM Autogrouping
8 ) RETURN PO_TBL_VARCHAR5;
9
10 PROCEDURE check_po_line_numbers(
11 p_style_id IN NUMBER,
12 p_agreement_id IN NUMBER,
13 p_supplier_id IN NUMBER,
14 p_site_id IN NUMBER,
15 p_req_line_id_tbl IN PO_TBL_NUMBER,
16 p_po_line_number_tbl IN PO_TBL_NUMBER,
17 p_add_to_po_header_id IN NUMBER,
18 p_draft_id IN NUMBER, --Autocreate grouping
19 x_message_code_tbl OUT NOCOPY PO_TBL_VARCHAR30,
20 x_token_name_tbl OUT NOCOPY PO_TBL_VARCHAR30,
21 x_token_value_tbl OUT NOCOPY PO_TBL_VARCHAR2000
22 );
23
24 PROCEDURE check_neg_line_numbers(
25 p_req_line_id_tbl IN PO_TBL_NUMBER,
26 p_sol_line_number_display_tbl IN PO_TBL_VARCHAR30,
27 p_sol_line_number_tbl IN PO_TBL_NUMBER,
28 p_draft_id IN NUMBER, --Autocreate grouping
29 x_message_code_tbl OUT NOCOPY PO_TBL_VARCHAR30,
30 x_token_name_tbl OUT NOCOPY PO_TBL_VARCHAR30,
31 x_token_value_tbl OUT NOCOPY PO_TBL_VARCHAR2000
32 );
33
34
35 PROCEDURE lines_match(
36 p_agreement_id IN NUMBER,
37 p_supplier_id IN NUMBER,
38 p_site_id IN NUMBER,
39 p_req_line_id IN NUMBER,
40 p_req_line_id_to_compare IN NUMBER,
41 p_po_line_id_to_compare IN NUMBER,
42 p_draft_id IN NUMBER := -1, --Autocreate grouping
43 p_relax_item_desc_check IN VARCHAR2, --Autocreate grouping
44 x_message_code OUT NOCOPY VARCHAR2,
45 x_token_name OUT NOCOPY VARCHAR2,
46 x_token_value OUT NOCOPY VARCHAR2
47 );
48
49 FUNCTION group_req_lines
50 ( p_req_line_id_tbl IN PO_TBL_NUMBER
51 , p_req_line_num_tbl IN PO_TBL_NUMBER
52 , p_po_line_num_tbl IN PO_TBL_NUMBER
53 , p_add_to_po_header_id IN NUMBER
54 , p_builder_agreement_id IN NUMBER
55 , p_builder_supplier_id IN NUMBER
56 , p_builder_site_id IN NUMBER
57 , p_builder_org_id IN NUMBER
58 , p_start_index IN NUMBER
59 , p_end_index IN NUMBER
60 , p_grouping_method IN VARCHAR2
61 ) RETURN PO_TBL_NUMBER;
62
63 /*
64 Added as part of CLM - serukull
65 */
66 Procedure group_clm_req_lines
67 (
68 p_req_line_id_tbl IN PO_TBL_NUMBER
69 , p_req_group_line_id_tbl IN PO_TBL_NUMBER
70 , p_req_clm_info_flag_tbl IN PO_TBL_VARCHAR1
71 , p_req_option_flag_tbl IN PO_TBL_VARCHAR1
72 , p_req_line_num_tbl IN PO_TBL_VARCHAR100
73 , p_po_line_num_tbl IN OUT NOCOPY PO_TBL_NUMBER
74 , p_po_line_num_disp_tbl IN OUT NOCOPY PO_TBL_VARCHAR100
75 , p_add_to_po_header_id IN NUMBER
76 , p_draft_id IN NUMBER --Autocreate grouping
77 , p_builder_agreement_id IN NUMBER
78 , p_builder_supplier_id IN NUMBER
79 , p_builder_site_id IN NUMBER
80 , p_builder_org_id IN NUMBER
81 , p_start_index IN NUMBER
82 , p_end_index IN NUMBER
83 , p_grouping_method IN VARCHAR2
84 );
85
86 /*
87 Added as part of CLM - serukull
88 */
89 Procedure group_clm_sol_req_lines
90 (
91 p_req_line_id_tbl IN PO_TBL_NUMBER
92 , p_req_group_line_id_tbl IN PO_TBL_NUMBER
93 , p_req_clm_info_flag_tbl IN PO_TBL_VARCHAR1
94 , p_req_option_flag_tbl IN PO_TBL_VARCHAR1
95 , p_req_line_num_tbl IN PO_TBL_VARCHAR100
96 , p_neg_line_num_tbl IN OUT NOCOPY PO_TBL_NUMBER
97 , p_neg_line_num_disp_tbl IN OUT NOCOPY PO_TBL_VARCHAR100
98 , p_add_to_neg_header_id IN NUMBER
99 , p_draft_id IN NUMBER --Autocreate grouping
100 , p_builder_agreement_id IN NUMBER
101 , p_builder_supplier_id IN NUMBER
102 , p_builder_site_id IN NUMBER
103 , p_builder_org_id IN NUMBER
104 , p_start_index IN NUMBER
105 , p_end_index IN NUMBER
106 , p_grouping_method IN VARCHAR2
107 );
108
109 Procedure group_neg_req_lines
110 (
111 p_req_line_id_tbl IN PO_TBL_NUMBER
112 , p_req_group_line_id_tbl IN PO_TBL_NUMBER
113 , p_req_clm_info_flag_tbl IN PO_TBL_VARCHAR1
114 , p_req_option_flag_tbl IN PO_TBL_VARCHAR1
115 , p_req_line_num_tbl IN PO_TBL_VARCHAR100
116 , p_neg_line_num_tbl IN OUT NOCOPY PO_TBL_NUMBER
117 , p_neg_line_num_disp_tbl IN OUT NOCOPY PO_TBL_VARCHAR100
118 , p_add_to_neg_header_id IN NUMBER
119 , p_draft_id IN NUMBER --Autocreate grouping
120 , p_builder_agreement_id IN NUMBER
121 , p_builder_supplier_id IN NUMBER
122 , p_builder_site_id IN NUMBER
123 , p_builder_org_id IN NUMBER
124 , p_start_index IN NUMBER
125 , p_end_index IN NUMBER
126 , p_grouping_method IN VARCHAR2
127 );
128
129
130 FUNCTION default_info_slin_numbers (
131 p_req_line_id IN NUMBER,
132 p_req_group_line_id_tbl IN PO_TBL_NUMBER,
133 p_po_line_num_tbl IN PO_TBL_VARCHAR100,
134 p_po_line_num IN NUMBER,
135 p_po_header_id IN NUMBER)
136 RETURN PO_TBL_VARCHAR100;
137
138 /*autocreate grouping*/
139 PROCEDURE check_mod_lock_availability(
140 p_po_line_number_tbl IN PO_TBL_NUMBER,
141 p_add_to_po_header_id IN NUMBER,
142 p_draft_id IN NUMBER,
143 x_message_code_tbl OUT NOCOPY PO_TBL_VARCHAR30,
144 x_token_name_tbl OUT NOCOPY PO_TBL_VARCHAR30,
145 x_token_value_tbl OUT NOCOPY PO_TBL_VARCHAR2000
146 );
147
148 FUNCTION get_edited_po_line_num (
149 p_draft_id IN NUMBER,
150 p_add_to_po_header_id IN NUMBER,
151 p_po_line_num_disp IN VARCHAR2)
152 RETURN Number;
153
154 Procedure RenumberSlins
155 (
156 p_source_line_id_tbl IN PO_TBL_NUMBER
157 , p_source_group_line_id_tbl IN PO_TBL_NUMBER
158 , p_po_line_num_tbl IN PO_TBL_NUMBER
159 , p_po_line_num_disp_tbl IN OUT NOCOPY PO_TBL_VARCHAR100
160 , p_req_clm_info_flag_tbl IN PO_TBL_VARCHAR1
161 , p_renumber_flag IN PO_TBL_VARCHAR1
162 , p_start_index IN NUMBER default null
163 , p_end_index IN NUMBER default null
164 , p_add_to_po_header_id IN NUMBER default null
165 , p_draft_id IN NUMBER default NULL
166 , p_orig_line_num IN NUMBER DEFAULT -1
167 , p_edit_line_num IN NUMBER DEFAULT -1
168 );
169
170 PROCEDURE get_line_num_disp_for_clin
171 ( p_po_line_num_tbl IN OUT NOCOPY PO_TBL_NUMBER
172 , p_req_line_id_tbl IN PO_TBL_NUMBER
173 , p_req_option_flag_tbl IN PO_TBL_VARCHAR1
174 , p_draft_id IN NUMBER
175 , p_req_group_line_id_tbl IN PO_TBL_NUMBER
176 , p_req_clm_info_flag_tbl IN PO_TBL_VARCHAR1
177 , p_add_to_po_header_id IN NUMBER
178 , p_start_index IN NUMBER
179 , p_end_index IN NUMBER
180 , p_po_line_num_disp_tbl IN OUT NOCOPY PO_TBL_VARCHAR100
181 );
182
183 PROCEDURE get_sol_line_num_disp_for_clin
187 , p_draft_id IN NUMBER
184 ( p_neg_line_num_tbl IN OUT NOCOPY PO_TBL_NUMBER
185 , p_req_line_id_tbl IN PO_TBL_NUMBER
186 , p_req_option_flag_tbl IN PO_TBL_VARCHAR1
188 , p_req_group_line_id_tbl IN PO_TBL_NUMBER
189 , p_req_clm_info_flag_tbl IN PO_TBL_VARCHAR1
190 , p_add_to_neg_header_id IN NUMBER
191 , p_start_index IN NUMBER
192 , p_end_index IN NUMBER
193 , p_neg_line_num_disp_tbl IN OUT NOCOPY PO_TBL_VARCHAR100
194 );
195
196
197 FUNCTION get_max_po_line_num
198 ( p_po_line_num_tbl IN PO_TBL_NUMBER
199 , p_po_header_id IN NUMBER := NULL
200 , p_draft_id IN NUMBER := -1
201 ) RETURN NUMBER;
202
203 --Bug 13622501. New procedure to update the po line num and po line num display based on the shipment selected during the 'ADD_FUNDS' case.
204 PROCEDURE get_po_linenum_for_shipment
205 (
206 p_po_shipment_id IN NUMBER
207 , p_draft_id IN NUMBER
208 , x_po_line_num OUT NOCOPY NUMBER
209 , x_po_line_num_disp OUT NOCOPY VARCHAR2
210 );
211
212 -- Added as part of bug fix 16097884
213 PROCEDURE check_item_description(
214 p_po_header_id IN NUMBER,
215 p_po_line_num IN NUMBER,
216 p_req_line_id IN NUMBER,
217 x_same_item_desc OUT NOCOPY VARCHAR2
218 );
219
220 END PO_AUTOCREATE_GROUPING_PVT;
221
[Home] [Help]