APPS.PO_AUTOCREATE_GROUPING_PVT dependencies on PO_TBL_NUMBER

Line 5: p_po_line_number_tbl IN PO_TBL_NUMBER,

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:

Line 15: p_req_line_id_tbl IN PO_TBL_NUMBER,

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,

Line 16: p_po_line_number_tbl IN PO_TBL_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,

Line 25: p_req_line_id_tbl IN PO_TBL_NUMBER,

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,

Line 27: p_sol_line_number_tbl IN PO_TBL_NUMBER,

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

Line 50: ( p_req_line_id_tbl IN PO_TBL_NUMBER

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

Line 51: , p_req_line_num_tbl IN PO_TBL_NUMBER

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

Line 52: , p_po_line_num_tbl IN PO_TBL_NUMBER

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

Line 61: ) RETURN PO_TBL_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: */

Line 68: p_req_line_id_tbl IN PO_TBL_NUMBER

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

Line 69: , p_req_group_line_id_tbl IN PO_TBL_NUMBER

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

Line 73: , p_po_line_num_tbl IN OUT NOCOPY 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

Line 91: p_req_line_id_tbl IN PO_TBL_NUMBER

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

Line 92: , p_req_group_line_id_tbl IN PO_TBL_NUMBER

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

Line 96: , p_neg_line_num_tbl IN OUT NOCOPY 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

Line 111: p_req_line_id_tbl IN PO_TBL_NUMBER

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

Line 112: , p_req_group_line_id_tbl IN PO_TBL_NUMBER

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

Line 116: , p_neg_line_num_tbl IN OUT NOCOPY 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

Line 132: p_req_group_line_id_tbl IN PO_TBL_NUMBER,

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;

Line 140: p_po_line_number_tbl IN PO_TBL_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,

Line 156: p_source_line_id_tbl IN PO_TBL_NUMBER

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

Line 157: , p_source_group_line_id_tbl IN PO_TBL_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

Line 158: , p_po_line_num_tbl IN PO_TBL_NUMBER

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

Line 171: ( p_po_line_num_tbl IN OUT NOCOPY PO_TBL_NUMBER

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

Line 172: , p_req_line_id_tbl IN PO_TBL_NUMBER

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

Line 175: , p_req_group_line_id_tbl IN PO_TBL_NUMBER

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

Line 184: ( p_neg_line_num_tbl IN OUT NOCOPY PO_TBL_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
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
187: , p_draft_id IN NUMBER
188: , p_req_group_line_id_tbl IN PO_TBL_NUMBER

Line 185: , p_req_line_id_tbl IN PO_TBL_NUMBER

181: );
182:
183: PROCEDURE get_sol_line_num_disp_for_clin
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
187: , p_draft_id IN NUMBER
188: , p_req_group_line_id_tbl IN PO_TBL_NUMBER
189: , p_req_clm_info_flag_tbl IN PO_TBL_VARCHAR1

Line 188: , p_req_group_line_id_tbl IN PO_TBL_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
187: , p_draft_id IN NUMBER
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

Line 198: ( p_po_line_num_tbl IN PO_TBL_NUMBER

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: