eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PO_VALIDATION_HELPER dependencies on PO_TBL_NUMBER

Line 11: , p_value_tbl IN PO_TBL_NUMBER

7:
8: PROCEDURE greater_than_zero(
9: p_calling_module IN VARCHAR2
10: , p_null_allowed_flag IN VARCHAR2 DEFAULT NULL
11: , p_value_tbl IN PO_TBL_NUMBER
12: , p_entity_id_tbl IN PO_TBL_NUMBER
13: , p_entity_type IN VARCHAR2
14: , p_column_name IN VARCHAR2
15: , p_message_name IN VARCHAR2 DEFAULT NULL

Line 12: , p_entity_id_tbl IN PO_TBL_NUMBER

8: PROCEDURE greater_than_zero(
9: p_calling_module IN VARCHAR2
10: , p_null_allowed_flag IN VARCHAR2 DEFAULT NULL
11: , p_value_tbl IN PO_TBL_NUMBER
12: , p_entity_id_tbl IN PO_TBL_NUMBER
13: , p_entity_type IN VARCHAR2
14: , p_column_name IN VARCHAR2
15: , p_message_name IN VARCHAR2 DEFAULT NULL
16: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE

Line 23: p_value_tbl IN PO_TBL_NUMBER,

19:
20: PROCEDURE greater_or_equal_zero(
21: p_calling_module IN VARCHAR2,
22: p_null_allowed_flag IN VARCHAR2 DEFAULT NULL,
23: p_value_tbl IN PO_TBL_NUMBER,
24: p_entity_id_tbl IN PO_TBL_NUMBER,
25: p_entity_type IN VARCHAR2,
26: p_column_name IN VARCHAR2,
27: p_message_name IN VARCHAR2 DEFAULT NULL,

Line 24: p_entity_id_tbl IN PO_TBL_NUMBER,

20: PROCEDURE greater_or_equal_zero(
21: p_calling_module IN VARCHAR2,
22: p_null_allowed_flag IN VARCHAR2 DEFAULT NULL,
23: p_value_tbl IN PO_TBL_NUMBER,
24: p_entity_id_tbl IN PO_TBL_NUMBER,
25: p_entity_type IN VARCHAR2,
26: p_column_name IN VARCHAR2,
27: p_message_name IN VARCHAR2 DEFAULT NULL,
28: p_token1_name IN VARCHAR2 DEFAULT NULL,

Line 39: , p_value_tbl IN PO_TBL_NUMBER

35:
36: PROCEDURE within_percentage_range(
37: p_calling_module IN VARCHAR2
38: , p_null_allowed_flag IN VARCHAR2 DEFAULT NULL
39: , p_value_tbl IN PO_TBL_NUMBER
40: , p_entity_id_tbl IN PO_TBL_NUMBER
41: , p_entity_type IN VARCHAR2
42: , p_column_name IN VARCHAR2
43: , p_message_name IN VARCHAR2 DEFAULT NULL

Line 40: , p_entity_id_tbl IN PO_TBL_NUMBER

36: PROCEDURE within_percentage_range(
37: p_calling_module IN VARCHAR2
38: , p_null_allowed_flag IN VARCHAR2 DEFAULT NULL
39: , p_value_tbl IN PO_TBL_NUMBER
40: , p_entity_id_tbl IN PO_TBL_NUMBER
41: , p_entity_type IN VARCHAR2
42: , p_column_name IN VARCHAR2
43: , p_message_name IN VARCHAR2 DEFAULT NULL
44: , p_token1_name IN VARCHAR2 DEFAULT NULL

Line 53: , p_org_id_tbl IN PO_TBL_NUMBER

49:
50: PROCEDURE open_period(
51: p_calling_module IN VARCHAR2
52: , p_date_tbl IN PO_TBL_DATE
53: , p_org_id_tbl IN PO_TBL_NUMBER
54: , p_entity_id_tbl IN PO_TBL_NUMBER
55: , p_entity_type IN VARCHAR2
56: , p_column_name IN VARCHAR2
57: , p_message_name IN VARCHAR2

Line 54: , p_entity_id_tbl IN PO_TBL_NUMBER

50: PROCEDURE open_period(
51: p_calling_module IN VARCHAR2
52: , p_date_tbl IN PO_TBL_DATE
53: , p_org_id_tbl IN PO_TBL_NUMBER
54: , p_entity_id_tbl IN PO_TBL_NUMBER
55: , p_entity_type IN VARCHAR2
56: , p_column_name IN VARCHAR2
57: , p_message_name IN VARCHAR2
58: -- PBWC Message Change Impact: Adding a token

Line 60: , p_token1_value IN PO_TBL_NUMBER DEFAULT NULL

56: , p_column_name IN VARCHAR2
57: , p_message_name IN VARCHAR2
58: -- PBWC Message Change Impact: Adding a token
59: , p_token1_name IN VARCHAR2 DEFAULT NULL
60: , p_token1_value IN PO_TBL_NUMBER DEFAULT NULL
61: , x_result_set_id IN OUT NOCOPY NUMBER
62: , x_result_type OUT NOCOPY VARCHAR2
63: );
64:

Line 67: p_entity_id_tbl IN PO_TBL_NUMBER,

63: );
64:
65: PROCEDURE not_null(p_calling_module IN VARCHAR2,
66: p_value_tbl IN PO_TBL_VARCHAR4000,
67: p_entity_id_tbl IN PO_TBL_NUMBER,
68: p_entity_type IN VARCHAR2,
69: p_column_name IN VARCHAR2,
70: p_message_name IN VARCHAR2,
71: p_token1_name IN VARCHAR2 DEFAULT NULL,

Line 81: p_entity_id_tbl IN PO_TBL_NUMBER,

77: x_result_type OUT NOCOPY VARCHAR2);
78:
79: PROCEDURE ensure_null(p_calling_module IN VARCHAR2,
80: p_value_tbl IN PO_TBL_VARCHAR4000,
81: p_entity_id_tbl IN PO_TBL_NUMBER,
82: p_entity_type IN VARCHAR2,
83: p_column_name IN VARCHAR2,
84: p_message_name IN VARCHAR2,
85: p_token1_name IN VARCHAR2 DEFAULT NULL,

Line 95: p_entity_id_tbl IN PO_TBL_NUMBER,

91: x_result_type OUT NOCOPY VARCHAR2);
92:
93: PROCEDURE flag_value_Y_N(p_calling_module IN VARCHAR2,
94: p_flag_value_tbl IN PO_TBL_VARCHAR1,
95: p_entity_id_tbl IN PO_TBL_NUMBER,
96: p_entity_type IN VARCHAR2,
97: p_column_name IN VARCHAR2,
98: p_message_name IN VARCHAR2,
99: p_token1_name IN VARCHAR2 DEFAULT NULL,

Line 109: , p_value_tbl IN PO_TBL_NUMBER

105: x_result_type OUT NOCOPY VARCHAR2);
106:
107: PROCEDURE gt_zero_order_type_filter(
108: p_calling_module IN VARCHAR2
109: , p_value_tbl IN PO_TBL_NUMBER
110: , p_entity_id_tbl IN PO_TBL_NUMBER
111: , p_order_type_lookup_code_tbl IN PO_TBL_VARCHAR30
112: , p_check_quantity_types_flag IN VARCHAR2
113: , p_entity_type IN VARCHAR2

Line 110: , p_entity_id_tbl IN PO_TBL_NUMBER

106:
107: PROCEDURE gt_zero_order_type_filter(
108: p_calling_module IN VARCHAR2
109: , p_value_tbl IN PO_TBL_NUMBER
110: , p_entity_id_tbl IN PO_TBL_NUMBER
111: , p_order_type_lookup_code_tbl IN PO_TBL_VARCHAR30
112: , p_check_quantity_types_flag IN VARCHAR2
113: , p_entity_type IN VARCHAR2
114: , p_column_name IN VARCHAR2

Line 121: , p_line_id_tbl IN PO_TBL_NUMBER

117: );
118:
119: PROCEDURE no_timecards_exist(
120: p_calling_module IN VARCHAR2
121: , p_line_id_tbl IN PO_TBL_NUMBER
122: , p_start_date_tbl IN PO_TBL_DATE DEFAULT NULL
123: , p_expiration_date_tbl IN PO_TBL_DATE DEFAULT NULL
124: , p_column_name IN VARCHAR2
125: , p_message_name IN VARCHAR2

Line 132: , p_line_id_tbl IN PO_TBL_NUMBER

128: );
129:
130: PROCEDURE amount_notif_ctrl_warning(
131: p_calling_module IN VARCHAR2
132: , p_line_id_tbl IN PO_TBL_NUMBER
133: , p_quantity_tbl IN PO_TBL_NUMBER
134: , p_column_name IN VARCHAR2
135: , p_message_name IN VARCHAR2
136: , x_result_set_id IN OUT NOCOPY NUMBER

Line 133: , p_quantity_tbl IN PO_TBL_NUMBER

129:
130: PROCEDURE amount_notif_ctrl_warning(
131: p_calling_module IN VARCHAR2
132: , p_line_id_tbl IN PO_TBL_NUMBER
133: , p_quantity_tbl IN PO_TBL_NUMBER
134: , p_column_name IN VARCHAR2
135: , p_message_name IN VARCHAR2
136: , x_result_set_id IN OUT NOCOPY NUMBER
137: , x_result_type OUT NOCOPY VARCHAR2

Line 143: , p_entity_id_tbl IN PO_TBL_NUMBER

139:
140: PROCEDURE child_num_unique(
141: p_calling_module IN VARCHAR2
142: , p_entity_type IN VARCHAR2
143: , p_entity_id_tbl IN PO_TBL_NUMBER
144: , p_parent_id_tbl IN PO_TBL_NUMBER
145: , p_entity_num_tbl IN PO_TBL_NUMBER
146: , x_result_set_id IN OUT NOCOPY NUMBER
147: , x_result_type OUT NOCOPY VARCHAR2

Line 144: , p_parent_id_tbl IN PO_TBL_NUMBER

140: PROCEDURE child_num_unique(
141: p_calling_module IN VARCHAR2
142: , p_entity_type IN VARCHAR2
143: , p_entity_id_tbl IN PO_TBL_NUMBER
144: , p_parent_id_tbl IN PO_TBL_NUMBER
145: , p_entity_num_tbl IN PO_TBL_NUMBER
146: , x_result_set_id IN OUT NOCOPY NUMBER
147: , x_result_type OUT NOCOPY VARCHAR2
148: , p_entity_type_tbl IN PO_TBL_VARCHAR30 DEFAULT NULL --

Line 145: , p_entity_num_tbl IN PO_TBL_NUMBER

141: p_calling_module IN VARCHAR2
142: , p_entity_type IN VARCHAR2
143: , p_entity_id_tbl IN PO_TBL_NUMBER
144: , p_parent_id_tbl IN PO_TBL_NUMBER
145: , p_entity_num_tbl IN PO_TBL_NUMBER
146: , x_result_set_id IN OUT NOCOPY NUMBER
147: , x_result_type OUT NOCOPY VARCHAR2
148: , p_entity_type_tbl IN PO_TBL_VARCHAR30 DEFAULT NULL --
149: );

Line 153: , p_price_diff_id_tbl IN PO_TBL_NUMBER

149: );
150:
151: PROCEDURE price_diff_value_unique(
152: p_calling_module IN VARCHAR2
153: , p_price_diff_id_tbl IN PO_TBL_NUMBER
154: , p_entity_id_tbl IN PO_TBL_NUMBER
155: , p_entity_type_tbl IN PO_TBL_VARCHAR30
156: , p_unique_value_tbl IN PO_TBL_VARCHAR4000
157: , p_column_name IN VARCHAR2

Line 154: , p_entity_id_tbl IN PO_TBL_NUMBER

150:
151: PROCEDURE price_diff_value_unique(
152: p_calling_module IN VARCHAR2
153: , p_price_diff_id_tbl IN PO_TBL_NUMBER
154: , p_entity_id_tbl IN PO_TBL_NUMBER
155: , p_entity_type_tbl IN PO_TBL_VARCHAR30
156: , p_unique_value_tbl IN PO_TBL_VARCHAR4000
157: , p_column_name IN VARCHAR2
158: , p_message_name IN VARCHAR2

Line 167: , p_entity_id_tbl IN PO_TBL_NUMBER

163: PROCEDURE start_date_le_end_date(
164: p_calling_module IN VARCHAR2
165: , p_start_date_tbl IN PO_TBL_DATE
166: , p_end_date_tbl IN PO_TBL_DATE
167: , p_entity_id_tbl IN PO_TBL_NUMBER
168: , p_entity_type IN VARCHAR2
169: , p_column_name IN VARCHAR2
170: , p_column_val_selector IN VARCHAR2
171: , p_message_name IN VARCHAR2

Line 179: , p_num1_tbl IN PO_TBL_NUMBER

175: );
176:
177: PROCEDURE num1_less_or_equal_num2(
178: p_calling_module IN VARCHAR2
179: , p_num1_tbl IN PO_TBL_NUMBER
180: , p_num2_tbl IN PO_TBL_NUMBER
181: , p_entity_id_tbl IN PO_TBL_NUMBER
182: , p_entity_type IN VARCHAR2
183: , p_column_name IN VARCHAR2

Line 180: , p_num2_tbl IN PO_TBL_NUMBER

176:
177: PROCEDURE num1_less_or_equal_num2(
178: p_calling_module IN VARCHAR2
179: , p_num1_tbl IN PO_TBL_NUMBER
180: , p_num2_tbl IN PO_TBL_NUMBER
181: , p_entity_id_tbl IN PO_TBL_NUMBER
182: , p_entity_type IN VARCHAR2
183: , p_column_name IN VARCHAR2
184: , p_message_name IN VARCHAR2

Line 181: , p_entity_id_tbl IN PO_TBL_NUMBER

177: PROCEDURE num1_less_or_equal_num2(
178: p_calling_module IN VARCHAR2
179: , p_num1_tbl IN PO_TBL_NUMBER
180: , p_num2_tbl IN PO_TBL_NUMBER
181: , p_entity_id_tbl IN PO_TBL_NUMBER
182: , p_entity_type IN VARCHAR2
183: , p_column_name IN VARCHAR2
184: , p_message_name IN VARCHAR2
185: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE

Line 190: p_value_tbl IN PO_TBL_NUMBER,

186: , x_result_type OUT NOCOPY VARCHAR2
187: );
188:
189: PROCEDURE zero(p_calling_module IN VARCHAR2,
190: p_value_tbl IN PO_TBL_NUMBER,
191: p_entity_id_tbl IN PO_TBL_NUMBER,
192: p_entity_type IN VARCHAR2,
193: p_column_name IN VARCHAR2,
194: p_message_name IN VARCHAR2,

Line 191: p_entity_id_tbl IN PO_TBL_NUMBER,

187: );
188:
189: PROCEDURE zero(p_calling_module IN VARCHAR2,
190: p_value_tbl IN PO_TBL_NUMBER,
191: p_entity_id_tbl IN PO_TBL_NUMBER,
192: p_entity_type IN VARCHAR2,
193: p_column_name IN VARCHAR2,
194: p_message_name IN VARCHAR2,
195: p_token1_name IN VARCHAR2 DEFAULT NULL,

Line 204: p_terms_id_tbl IN PO_TBL_NUMBER,

200: x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE,
201: x_result_type OUT NOCOPY VARCHAR2);
202:
203: PROCEDURE terms_id(p_calling_module IN VARCHAR2,
204: p_terms_id_tbl IN PO_TBL_NUMBER,
205: p_entity_id_tbl IN PO_TBL_NUMBER,
206: p_entity_type IN VARCHAR2,
207: p_validation_id IN NUMBER DEFAULT NULL,
208: x_result_set_id IN OUT NOCOPY NUMBER,

Line 205: p_entity_id_tbl IN PO_TBL_NUMBER,

201: x_result_type OUT NOCOPY VARCHAR2);
202:
203: PROCEDURE terms_id(p_calling_module IN VARCHAR2,
204: p_terms_id_tbl IN PO_TBL_NUMBER,
205: p_entity_id_tbl IN PO_TBL_NUMBER,
206: p_entity_type IN VARCHAR2,
207: p_validation_id IN NUMBER DEFAULT NULL,
208: x_result_set_id IN OUT NOCOPY NUMBER,
209: x_result_type OUT NOCOPY VARCHAR2);

Line 213: , p_value_tbl IN PO_TBL_NUMBER

209: x_result_type OUT NOCOPY VARCHAR2);
210:
211: PROCEDURE gt_zero_opm_filter(
212: p_calling_module IN VARCHAR2
213: , p_value_tbl IN PO_TBL_NUMBER
214: , p_entity_id_tbl IN PO_TBL_NUMBER
215: , p_item_id_tbl IN PO_TBL_NUMBER
216: , p_inv_org_id_tbl IN PO_TBL_NUMBER
217: , p_entity_type IN VARCHAR2

Line 214: , p_entity_id_tbl IN PO_TBL_NUMBER

210:
211: PROCEDURE gt_zero_opm_filter(
212: p_calling_module IN VARCHAR2
213: , p_value_tbl IN PO_TBL_NUMBER
214: , p_entity_id_tbl IN PO_TBL_NUMBER
215: , p_item_id_tbl IN PO_TBL_NUMBER
216: , p_inv_org_id_tbl IN PO_TBL_NUMBER
217: , p_entity_type IN VARCHAR2
218: , p_column_name IN VARCHAR2

Line 215: , p_item_id_tbl IN PO_TBL_NUMBER

211: PROCEDURE gt_zero_opm_filter(
212: p_calling_module IN VARCHAR2
213: , p_value_tbl IN PO_TBL_NUMBER
214: , p_entity_id_tbl IN PO_TBL_NUMBER
215: , p_item_id_tbl IN PO_TBL_NUMBER
216: , p_inv_org_id_tbl IN PO_TBL_NUMBER
217: , p_entity_type IN VARCHAR2
218: , p_column_name IN VARCHAR2
219: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE

Line 216: , p_inv_org_id_tbl IN PO_TBL_NUMBER

212: p_calling_module IN VARCHAR2
213: , p_value_tbl IN PO_TBL_NUMBER
214: , p_entity_id_tbl IN PO_TBL_NUMBER
215: , p_item_id_tbl IN PO_TBL_NUMBER
216: , p_inv_org_id_tbl IN PO_TBL_NUMBER
217: , p_entity_type IN VARCHAR2
218: , p_column_name IN VARCHAR2
219: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
220: , x_result_type OUT NOCOPY VARCHAR2

Line 225: , p_entity_id_tbl IN PO_TBL_NUMBER

221: );
222:
223: PROCEDURE qtys_within_deviation(
224: p_calling_module IN VARCHAR2
225: , p_entity_id_tbl IN PO_TBL_NUMBER
226: , p_item_id_tbl IN PO_TBL_NUMBER
227: , p_inv_org_id_tbl IN PO_TBL_NUMBER
228: , p_quantity_tbl IN PO_TBL_NUMBER
229: , p_primary_uom_tbl IN PO_TBL_VARCHAR30

Line 226: , p_item_id_tbl IN PO_TBL_NUMBER

222:
223: PROCEDURE qtys_within_deviation(
224: p_calling_module IN VARCHAR2
225: , p_entity_id_tbl IN PO_TBL_NUMBER
226: , p_item_id_tbl IN PO_TBL_NUMBER
227: , p_inv_org_id_tbl IN PO_TBL_NUMBER
228: , p_quantity_tbl IN PO_TBL_NUMBER
229: , p_primary_uom_tbl IN PO_TBL_VARCHAR30
230: , p_sec_quantity_tbl IN PO_TBL_NUMBER

Line 227: , p_inv_org_id_tbl IN PO_TBL_NUMBER

223: PROCEDURE qtys_within_deviation(
224: p_calling_module IN VARCHAR2
225: , p_entity_id_tbl IN PO_TBL_NUMBER
226: , p_item_id_tbl IN PO_TBL_NUMBER
227: , p_inv_org_id_tbl IN PO_TBL_NUMBER
228: , p_quantity_tbl IN PO_TBL_NUMBER
229: , p_primary_uom_tbl IN PO_TBL_VARCHAR30
230: , p_sec_quantity_tbl IN PO_TBL_NUMBER
231: , p_secondary_uom_tbl IN PO_TBL_VARCHAR30

Line 228: , p_quantity_tbl IN PO_TBL_NUMBER

224: p_calling_module IN VARCHAR2
225: , p_entity_id_tbl IN PO_TBL_NUMBER
226: , p_item_id_tbl IN PO_TBL_NUMBER
227: , p_inv_org_id_tbl IN PO_TBL_NUMBER
228: , p_quantity_tbl IN PO_TBL_NUMBER
229: , p_primary_uom_tbl IN PO_TBL_VARCHAR30
230: , p_sec_quantity_tbl IN PO_TBL_NUMBER
231: , p_secondary_uom_tbl IN PO_TBL_VARCHAR30
232: , p_column_name IN VARCHAR2

Line 230: , p_sec_quantity_tbl IN PO_TBL_NUMBER

226: , p_item_id_tbl IN PO_TBL_NUMBER
227: , p_inv_org_id_tbl IN PO_TBL_NUMBER
228: , p_quantity_tbl IN PO_TBL_NUMBER
229: , p_primary_uom_tbl IN PO_TBL_VARCHAR30
230: , p_sec_quantity_tbl IN PO_TBL_NUMBER
231: , p_secondary_uom_tbl IN PO_TBL_VARCHAR30
232: , p_column_name IN VARCHAR2
233: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
234: , x_result_type OUT NOCOPY VARCHAR2

Line 238: p_id_tbl IN po_tbl_number,

234: , x_result_type OUT NOCOPY VARCHAR2
235: );
236:
237: PROCEDURE secondary_unit_of_measure(
238: p_id_tbl IN po_tbl_number,
239: p_entity_type IN VARCHAR2,
240: p_secondary_unit_of_meas_tbl IN po_tbl_varchar30,
241: p_item_id_tbl IN po_tbl_number,
242: p_item_tbl IN po_tbl_varchar2000,

Line 241: p_item_id_tbl IN po_tbl_number,

237: PROCEDURE secondary_unit_of_measure(
238: p_id_tbl IN po_tbl_number,
239: p_entity_type IN VARCHAR2,
240: p_secondary_unit_of_meas_tbl IN po_tbl_varchar30,
241: p_item_id_tbl IN po_tbl_number,
242: p_item_tbl IN po_tbl_varchar2000,
243: p_organization_id_tbl IN po_tbl_number,
244: p_doc_type IN VARCHAR2,
245: p_create_or_update_item_flag IN VARCHAR2,

Line 243: p_organization_id_tbl IN po_tbl_number,

239: p_entity_type IN VARCHAR2,
240: p_secondary_unit_of_meas_tbl IN po_tbl_varchar30,
241: p_item_id_tbl IN po_tbl_number,
242: p_item_tbl IN po_tbl_varchar2000,
243: p_organization_id_tbl IN po_tbl_number,
244: p_doc_type IN VARCHAR2,
245: p_create_or_update_item_flag IN VARCHAR2,
246: x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE,
247: x_result_type OUT NOCOPY VARCHAR2);

Line 250: p_id_tbl IN po_tbl_number,

246: x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE,
247: x_result_type OUT NOCOPY VARCHAR2);
248:
249: PROCEDURE secondary_quantity(
250: p_id_tbl IN po_tbl_number,
251: p_entity_type IN VARCHAR2,
252: p_secondary_quantity_tbl IN po_tbl_number,
253: p_order_type_lookup_code_tbl IN po_tbl_varchar30,
254: p_item_id_tbl IN po_tbl_number,

Line 252: p_secondary_quantity_tbl IN po_tbl_number,

248:
249: PROCEDURE secondary_quantity(
250: p_id_tbl IN po_tbl_number,
251: p_entity_type IN VARCHAR2,
252: p_secondary_quantity_tbl IN po_tbl_number,
253: p_order_type_lookup_code_tbl IN po_tbl_varchar30,
254: p_item_id_tbl IN po_tbl_number,
255: p_item_tbl IN po_tbl_varchar2000,
256: p_organization_id_tbl IN po_tbl_number,

Line 254: p_item_id_tbl IN po_tbl_number,

250: p_id_tbl IN po_tbl_number,
251: p_entity_type IN VARCHAR2,
252: p_secondary_quantity_tbl IN po_tbl_number,
253: p_order_type_lookup_code_tbl IN po_tbl_varchar30,
254: p_item_id_tbl IN po_tbl_number,
255: p_item_tbl IN po_tbl_varchar2000,
256: p_organization_id_tbl IN po_tbl_number,
257: p_doc_type IN VARCHAR2,
258: p_create_or_update_item_flag IN VARCHAR2,

Line 256: p_organization_id_tbl IN po_tbl_number,

252: p_secondary_quantity_tbl IN po_tbl_number,
253: p_order_type_lookup_code_tbl IN po_tbl_varchar30,
254: p_item_id_tbl IN po_tbl_number,
255: p_item_tbl IN po_tbl_varchar2000,
256: p_organization_id_tbl IN po_tbl_number,
257: p_doc_type IN VARCHAR2,
258: p_create_or_update_item_flag IN VARCHAR2,
259: x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE,
260: x_result_type OUT NOCOPY VARCHAR2);

Line 263: p_id_tbl IN po_tbl_number,

259: x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE,
260: x_result_type OUT NOCOPY VARCHAR2);
261:
262: PROCEDURE secondary_uom_update(
263: p_id_tbl IN po_tbl_number,
264: p_entity_type IN VARCHAR2,
265: p_secondary_unit_of_meas_tbl IN po_tbl_varchar30,
266: p_item_id_tbl IN po_tbl_number,
267: p_organization_id_tbl IN po_tbl_number,

Line 266: p_item_id_tbl IN po_tbl_number,

262: PROCEDURE secondary_uom_update(
263: p_id_tbl IN po_tbl_number,
264: p_entity_type IN VARCHAR2,
265: p_secondary_unit_of_meas_tbl IN po_tbl_varchar30,
266: p_item_id_tbl IN po_tbl_number,
267: p_organization_id_tbl IN po_tbl_number,
268: p_create_or_update_item_flag IN VARCHAR2,
269: x_result_set_id IN OUT NOCOPY NUMBER,
270: x_result_type OUT NOCOPY VARCHAR2);

Line 267: p_organization_id_tbl IN po_tbl_number,

263: p_id_tbl IN po_tbl_number,
264: p_entity_type IN VARCHAR2,
265: p_secondary_unit_of_meas_tbl IN po_tbl_varchar30,
266: p_item_id_tbl IN po_tbl_number,
267: p_organization_id_tbl IN po_tbl_number,
268: p_create_or_update_item_flag IN VARCHAR2,
269: x_result_set_id IN OUT NOCOPY NUMBER,
270: x_result_type OUT NOCOPY VARCHAR2);
271:

Line 273: p_id_tbl IN po_tbl_number,

269: x_result_set_id IN OUT NOCOPY NUMBER,
270: x_result_type OUT NOCOPY VARCHAR2);
271:
272: PROCEDURE preferred_grade(
273: p_id_tbl IN po_tbl_number,
274: p_entity_type IN VARCHAR2,
275: p_preferred_grade_tbl IN po_tbl_varchar2000,
276: p_item_id_tbl IN po_tbl_number,
277: p_item_tbl IN po_tbl_varchar2000,

Line 276: p_item_id_tbl IN po_tbl_number,

272: PROCEDURE preferred_grade(
273: p_id_tbl IN po_tbl_number,
274: p_entity_type IN VARCHAR2,
275: p_preferred_grade_tbl IN po_tbl_varchar2000,
276: p_item_id_tbl IN po_tbl_number,
277: p_item_tbl IN po_tbl_varchar2000,
278: p_organization_id_tbl IN po_tbl_number,
279: p_create_or_update_item_flag IN VARCHAR2,
280: p_validation_id IN NUMBER DEFAULT NULL,

Line 278: p_organization_id_tbl IN po_tbl_number,

274: p_entity_type IN VARCHAR2,
275: p_preferred_grade_tbl IN po_tbl_varchar2000,
276: p_item_id_tbl IN po_tbl_number,
277: p_item_tbl IN po_tbl_varchar2000,
278: p_organization_id_tbl IN po_tbl_number,
279: p_create_or_update_item_flag IN VARCHAR2,
280: p_validation_id IN NUMBER DEFAULT NULL,
281: x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE,
282: x_result_set_id IN OUT NOCOPY NUMBER,

Line 286: p_id_tbl IN po_tbl_number,

282: x_result_set_id IN OUT NOCOPY NUMBER,
283: x_result_type OUT NOCOPY VARCHAR2);
284:
285: PROCEDURE process_enabled(
286: p_id_tbl IN po_tbl_number,
287: p_entity_type IN VARCHAR2,
288: p_ship_to_organization_id_tbl IN po_tbl_number,
289: p_item_id_tbl IN po_tbl_number,
290: x_result_set_id IN OUT NOCOPY NUMBER,

Line 288: p_ship_to_organization_id_tbl IN po_tbl_number,

284:
285: PROCEDURE process_enabled(
286: p_id_tbl IN po_tbl_number,
287: p_entity_type IN VARCHAR2,
288: p_ship_to_organization_id_tbl IN po_tbl_number,
289: p_item_id_tbl IN po_tbl_number,
290: x_result_set_id IN OUT NOCOPY NUMBER,
291: x_result_type OUT NOCOPY VARCHAR2);
292:

Line 289: p_item_id_tbl IN po_tbl_number,

285: PROCEDURE process_enabled(
286: p_id_tbl IN po_tbl_number,
287: p_entity_type IN VARCHAR2,
288: p_ship_to_organization_id_tbl IN po_tbl_number,
289: p_item_id_tbl IN po_tbl_number,
290: x_result_set_id IN OUT NOCOPY NUMBER,
291: x_result_type OUT NOCOPY VARCHAR2);
292:
293: -- Bug 7516824: New procedure added

Line 296: p_id_tbl IN po_tbl_number,

292:
293: -- Bug 7516824: New procedure added
294: PROCEDURE validate_desc_flex (
295: p_calling_module IN VARCHAR2,
296: p_id_tbl IN po_tbl_number,
297: p_desc_flex_name IN fnd_descr_flex_column_usages.descriptive_flexfield_name%TYPE,
298: p_attribute_category_tbl IN PO_TBL_VARCHAR30,
299: p_attribute1_tbl IN PO_TBL_VARCHAR2000,
300: p_attribute2_tbl IN PO_TBL_VARCHAR2000,