APPS.PO_AUTOCREATE_GROUPING_PVT dependencies on PO_TBL_VARCHAR1

Line 70: , p_req_clm_info_flag_tbl IN PO_TBL_VARCHAR1

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

Line 71: , p_req_option_flag_tbl IN PO_TBL_VARCHAR1

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

Line 72: , p_req_line_num_tbl IN PO_TBL_VARCHAR100

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

Line 74: , p_po_line_num_disp_tbl IN OUT NOCOPY PO_TBL_VARCHAR100

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

Line 93: , p_req_clm_info_flag_tbl IN PO_TBL_VARCHAR1

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

Line 94: , p_req_option_flag_tbl IN PO_TBL_VARCHAR1

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

Line 95: , p_req_line_num_tbl IN PO_TBL_VARCHAR100

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

Line 97: , p_neg_line_num_disp_tbl IN OUT NOCOPY PO_TBL_VARCHAR100

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

Line 113: , p_req_clm_info_flag_tbl IN PO_TBL_VARCHAR1

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

Line 114: , p_req_option_flag_tbl IN PO_TBL_VARCHAR1

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

Line 115: , p_req_line_num_tbl IN PO_TBL_VARCHAR100

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

Line 117: , p_neg_line_num_disp_tbl IN OUT NOCOPY PO_TBL_VARCHAR100

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

Line 133: p_po_line_num_tbl IN PO_TBL_VARCHAR100,

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:

Line 136: RETURN PO_TBL_VARCHAR100;

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,

Line 159: , p_po_line_num_disp_tbl IN OUT NOCOPY PO_TBL_VARCHAR100

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

Line 160: , p_req_clm_info_flag_tbl IN PO_TBL_VARCHAR1

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

Line 161: , p_renumber_flag IN PO_TBL_VARCHAR1

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

Line 173: , p_req_option_flag_tbl IN PO_TBL_VARCHAR1

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

Line 176: , p_req_clm_info_flag_tbl IN PO_TBL_VARCHAR1

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

Line 180: , p_po_line_num_disp_tbl IN OUT NOCOPY PO_TBL_VARCHAR100

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
184: ( p_neg_line_num_tbl IN OUT NOCOPY PO_TBL_NUMBER

Line 186: , p_req_option_flag_tbl IN PO_TBL_VARCHAR1

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
190: , p_add_to_neg_header_id IN NUMBER

Line 189: , p_req_clm_info_flag_tbl IN PO_TBL_VARCHAR1

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
193: , p_neg_line_num_disp_tbl IN OUT NOCOPY PO_TBL_VARCHAR100

Line 193: , p_neg_line_num_disp_tbl IN OUT NOCOPY PO_TBL_VARCHAR100

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