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.ASO_PA_APR_PUB_W dependencies on JTF_VARCHAR2_TABLE_100

Line 31: p_approver_status IN jtf_varchar2_table_100 := NULL,

27: p_approver_person_id IN jtf_number_table := NULL,
28: p_approver_user_id IN jtf_number_table := NULL,
29: p_notification_id IN jtf_number_table := NULL,
30: p_approver_sequence IN jtf_number_table := NULL,
31: p_approver_status IN jtf_varchar2_table_100 := NULL,
32: p_name IN jtf_varchar2_table_300 := NULL,
33: p_approver_name IN jtf_varchar2_table_100 := NULL,
34: p_approval_comments IN jtf_varchar2_table_300 := NULL,
35: p_approver_category IN jtf_varchar2_table_100 := NULL,

Line 33: p_approver_name IN jtf_varchar2_table_100 := NULL,

29: p_notification_id IN jtf_number_table := NULL,
30: p_approver_sequence IN jtf_number_table := NULL,
31: p_approver_status IN jtf_varchar2_table_100 := NULL,
32: p_name IN jtf_varchar2_table_300 := NULL,
33: p_approver_name IN jtf_varchar2_table_100 := NULL,
34: p_approval_comments IN jtf_varchar2_table_300 := NULL,
35: p_approver_category IN jtf_varchar2_table_100 := NULL,
36: p_approver_category_desc IN jtf_varchar2_table_100 := NULL,
37: p_approver_type_desc IN jtf_varchar2_table_100 := NULL,

Line 35: p_approver_category IN jtf_varchar2_table_100 := NULL,

31: p_approver_status IN jtf_varchar2_table_100 := NULL,
32: p_name IN jtf_varchar2_table_300 := NULL,
33: p_approver_name IN jtf_varchar2_table_100 := NULL,
34: p_approval_comments IN jtf_varchar2_table_300 := NULL,
35: p_approver_category IN jtf_varchar2_table_100 := NULL,
36: p_approver_category_desc IN jtf_varchar2_table_100 := NULL,
37: p_approver_type_desc IN jtf_varchar2_table_100 := NULL,
38: p_sub_list_desc IN jtf_varchar2_table_100 := NULL,
39: p_item_id IN jtf_varchar2_table_100 := NULL,

Line 36: p_approver_category_desc IN jtf_varchar2_table_100 := NULL,

32: p_name IN jtf_varchar2_table_300 := NULL,
33: p_approver_name IN jtf_varchar2_table_100 := NULL,
34: p_approval_comments IN jtf_varchar2_table_300 := NULL,
35: p_approver_category IN jtf_varchar2_table_100 := NULL,
36: p_approver_category_desc IN jtf_varchar2_table_100 := NULL,
37: p_approver_type_desc IN jtf_varchar2_table_100 := NULL,
38: p_sub_list_desc IN jtf_varchar2_table_100 := NULL,
39: p_item_id IN jtf_varchar2_table_100 := NULL,
40: p_item_class IN jtf_varchar2_table_100 := NULL,

Line 37: p_approver_type_desc IN jtf_varchar2_table_100 := NULL,

33: p_approver_name IN jtf_varchar2_table_100 := NULL,
34: p_approval_comments IN jtf_varchar2_table_300 := NULL,
35: p_approver_category IN jtf_varchar2_table_100 := NULL,
36: p_approver_category_desc IN jtf_varchar2_table_100 := NULL,
37: p_approver_type_desc IN jtf_varchar2_table_100 := NULL,
38: p_sub_list_desc IN jtf_varchar2_table_100 := NULL,
39: p_item_id IN jtf_varchar2_table_100 := NULL,
40: p_item_class IN jtf_varchar2_table_100 := NULL,
41: p_action_type IN jtf_varchar2_table_300 := NULL,

Line 38: p_sub_list_desc IN jtf_varchar2_table_100 := NULL,

34: p_approval_comments IN jtf_varchar2_table_300 := NULL,
35: p_approver_category IN jtf_varchar2_table_100 := NULL,
36: p_approver_category_desc IN jtf_varchar2_table_100 := NULL,
37: p_approver_type_desc IN jtf_varchar2_table_100 := NULL,
38: p_sub_list_desc IN jtf_varchar2_table_100 := NULL,
39: p_item_id IN jtf_varchar2_table_100 := NULL,
40: p_item_class IN jtf_varchar2_table_100 := NULL,
41: p_action_type IN jtf_varchar2_table_300 := NULL,
42: p_action_type_id IN jtf_number_table := NULL,

Line 39: p_item_id IN jtf_varchar2_table_100 := NULL,

35: p_approver_category IN jtf_varchar2_table_100 := NULL,
36: p_approver_category_desc IN jtf_varchar2_table_100 := NULL,
37: p_approver_type_desc IN jtf_varchar2_table_100 := NULL,
38: p_sub_list_desc IN jtf_varchar2_table_100 := NULL,
39: p_item_id IN jtf_varchar2_table_100 := NULL,
40: p_item_class IN jtf_varchar2_table_100 := NULL,
41: p_action_type IN jtf_varchar2_table_300 := NULL,
42: p_action_type_id IN jtf_number_table := NULL,
43: p_chain_number IN jtf_number_table := NULL,

Line 40: p_item_class IN jtf_varchar2_table_100 := NULL,

36: p_approver_category_desc IN jtf_varchar2_table_100 := NULL,
37: p_approver_type_desc IN jtf_varchar2_table_100 := NULL,
38: p_sub_list_desc IN jtf_varchar2_table_100 := NULL,
39: p_item_id IN jtf_varchar2_table_100 := NULL,
40: p_item_class IN jtf_varchar2_table_100 := NULL,
41: p_action_type IN jtf_varchar2_table_300 := NULL,
42: p_action_type_id IN jtf_number_table := NULL,
43: p_chain_number IN jtf_number_table := NULL,
44: p_occurrence IN jtf_number_table := NULL,

Line 45: p_authority IN jtf_varchar2_table_100 := NULL,

41: p_action_type IN jtf_varchar2_table_300 := NULL,
42: p_action_type_id IN jtf_number_table := NULL,
43: p_chain_number IN jtf_number_table := NULL,
44: p_occurrence IN jtf_number_table := NULL,
45: p_authority IN jtf_varchar2_table_100 := NULL,
46: p_date_sent IN jtf_date_table := NULL,
47: p_date_received IN jtf_date_table := NULL
48: )RETURN ASO_PA_APR_PUB.approvers_list_tbl_type
49: IS

Line 191: x_approver_status OUT NOCOPY jtf_varchar2_table_100,

187: x_approver_person_id OUT NOCOPY jtf_number_table,
188: x_approver_user_id OUT NOCOPY jtf_number_table,
189: x_notification_id OUT NOCOPY jtf_number_table,
190: x_approver_sequence OUT NOCOPY jtf_number_table,
191: x_approver_status OUT NOCOPY jtf_varchar2_table_100,
192: x_name OUT NOCOPY jtf_varchar2_table_300,
193: x_approver_name OUT NOCOPY jtf_varchar2_table_100,
194: x_approval_comments OUT NOCOPY jtf_varchar2_table_300,
195: x_approver_category OUT NOCOPY jtf_varchar2_table_100,

Line 193: x_approver_name OUT NOCOPY jtf_varchar2_table_100,

189: x_notification_id OUT NOCOPY jtf_number_table,
190: x_approver_sequence OUT NOCOPY jtf_number_table,
191: x_approver_status OUT NOCOPY jtf_varchar2_table_100,
192: x_name OUT NOCOPY jtf_varchar2_table_300,
193: x_approver_name OUT NOCOPY jtf_varchar2_table_100,
194: x_approval_comments OUT NOCOPY jtf_varchar2_table_300,
195: x_approver_category OUT NOCOPY jtf_varchar2_table_100,
196: x_approver_category_desc OUT NOCOPY jtf_varchar2_table_100,
197: x_approver_type_desc OUT NOCOPY jtf_varchar2_table_100,

Line 195: x_approver_category OUT NOCOPY jtf_varchar2_table_100,

191: x_approver_status OUT NOCOPY jtf_varchar2_table_100,
192: x_name OUT NOCOPY jtf_varchar2_table_300,
193: x_approver_name OUT NOCOPY jtf_varchar2_table_100,
194: x_approval_comments OUT NOCOPY jtf_varchar2_table_300,
195: x_approver_category OUT NOCOPY jtf_varchar2_table_100,
196: x_approver_category_desc OUT NOCOPY jtf_varchar2_table_100,
197: x_approver_type_desc OUT NOCOPY jtf_varchar2_table_100,
198: x_sub_list_desc OUT NOCOPY jtf_varchar2_table_100,
199: x_item_id OUT NOCOPY jtf_varchar2_table_100,

Line 196: x_approver_category_desc OUT NOCOPY jtf_varchar2_table_100,

192: x_name OUT NOCOPY jtf_varchar2_table_300,
193: x_approver_name OUT NOCOPY jtf_varchar2_table_100,
194: x_approval_comments OUT NOCOPY jtf_varchar2_table_300,
195: x_approver_category OUT NOCOPY jtf_varchar2_table_100,
196: x_approver_category_desc OUT NOCOPY jtf_varchar2_table_100,
197: x_approver_type_desc OUT NOCOPY jtf_varchar2_table_100,
198: x_sub_list_desc OUT NOCOPY jtf_varchar2_table_100,
199: x_item_id OUT NOCOPY jtf_varchar2_table_100,
200: x_item_class OUT NOCOPY jtf_varchar2_table_100,

Line 197: x_approver_type_desc OUT NOCOPY jtf_varchar2_table_100,

193: x_approver_name OUT NOCOPY jtf_varchar2_table_100,
194: x_approval_comments OUT NOCOPY jtf_varchar2_table_300,
195: x_approver_category OUT NOCOPY jtf_varchar2_table_100,
196: x_approver_category_desc OUT NOCOPY jtf_varchar2_table_100,
197: x_approver_type_desc OUT NOCOPY jtf_varchar2_table_100,
198: x_sub_list_desc OUT NOCOPY jtf_varchar2_table_100,
199: x_item_id OUT NOCOPY jtf_varchar2_table_100,
200: x_item_class OUT NOCOPY jtf_varchar2_table_100,
201: x_action_type OUT NOCOPY jtf_varchar2_table_300,

Line 198: x_sub_list_desc OUT NOCOPY jtf_varchar2_table_100,

194: x_approval_comments OUT NOCOPY jtf_varchar2_table_300,
195: x_approver_category OUT NOCOPY jtf_varchar2_table_100,
196: x_approver_category_desc OUT NOCOPY jtf_varchar2_table_100,
197: x_approver_type_desc OUT NOCOPY jtf_varchar2_table_100,
198: x_sub_list_desc OUT NOCOPY jtf_varchar2_table_100,
199: x_item_id OUT NOCOPY jtf_varchar2_table_100,
200: x_item_class OUT NOCOPY jtf_varchar2_table_100,
201: x_action_type OUT NOCOPY jtf_varchar2_table_300,
202: x_action_type_id OUT NOCOPY jtf_number_table,

Line 199: x_item_id OUT NOCOPY jtf_varchar2_table_100,

195: x_approver_category OUT NOCOPY jtf_varchar2_table_100,
196: x_approver_category_desc OUT NOCOPY jtf_varchar2_table_100,
197: x_approver_type_desc OUT NOCOPY jtf_varchar2_table_100,
198: x_sub_list_desc OUT NOCOPY jtf_varchar2_table_100,
199: x_item_id OUT NOCOPY jtf_varchar2_table_100,
200: x_item_class OUT NOCOPY jtf_varchar2_table_100,
201: x_action_type OUT NOCOPY jtf_varchar2_table_300,
202: x_action_type_id OUT NOCOPY jtf_number_table,
203: x_chain_number OUT NOCOPY jtf_number_table,

Line 200: x_item_class OUT NOCOPY jtf_varchar2_table_100,

196: x_approver_category_desc OUT NOCOPY jtf_varchar2_table_100,
197: x_approver_type_desc OUT NOCOPY jtf_varchar2_table_100,
198: x_sub_list_desc OUT NOCOPY jtf_varchar2_table_100,
199: x_item_id OUT NOCOPY jtf_varchar2_table_100,
200: x_item_class OUT NOCOPY jtf_varchar2_table_100,
201: x_action_type OUT NOCOPY jtf_varchar2_table_300,
202: x_action_type_id OUT NOCOPY jtf_number_table,
203: x_chain_number OUT NOCOPY jtf_number_table,
204: x_occurrence OUT NOCOPY jtf_number_table,

Line 205: x_authority OUT NOCOPY jtf_varchar2_table_100,

201: x_action_type OUT NOCOPY jtf_varchar2_table_300,
202: x_action_type_id OUT NOCOPY jtf_number_table,
203: x_chain_number OUT NOCOPY jtf_number_table,
204: x_occurrence OUT NOCOPY jtf_number_table,
205: x_authority OUT NOCOPY jtf_varchar2_table_100,
206: x_date_sent OUT NOCOPY jtf_date_table,
207: x_date_received OUT NOCOPY jtf_date_table
208: )
209: AS

Line 219: x_approver_status := jtf_varchar2_table_100();

215: x_approver_user_id := jtf_number_table();
216: x_notification_id := jtf_number_table();
217: x_approver_sequence := jtf_number_table();
218: x_name := jtf_varchar2_table_300();
219: x_approver_status := jtf_varchar2_table_100();
220: x_approver_name := jtf_varchar2_table_100();
221: x_approval_comments := jtf_varchar2_table_300();
222: x_approver_category :=jtf_varchar2_table_100();
223: x_approver_category_desc := jtf_varchar2_table_100();

Line 220: x_approver_name := jtf_varchar2_table_100();

216: x_notification_id := jtf_number_table();
217: x_approver_sequence := jtf_number_table();
218: x_name := jtf_varchar2_table_300();
219: x_approver_status := jtf_varchar2_table_100();
220: x_approver_name := jtf_varchar2_table_100();
221: x_approval_comments := jtf_varchar2_table_300();
222: x_approver_category :=jtf_varchar2_table_100();
223: x_approver_category_desc := jtf_varchar2_table_100();
224: x_approver_type_desc := jtf_varchar2_table_100();

Line 222: x_approver_category :=jtf_varchar2_table_100();

218: x_name := jtf_varchar2_table_300();
219: x_approver_status := jtf_varchar2_table_100();
220: x_approver_name := jtf_varchar2_table_100();
221: x_approval_comments := jtf_varchar2_table_300();
222: x_approver_category :=jtf_varchar2_table_100();
223: x_approver_category_desc := jtf_varchar2_table_100();
224: x_approver_type_desc := jtf_varchar2_table_100();
225: x_sub_list_desc := jtf_varchar2_table_100();
226: x_item_id := jtf_varchar2_table_100();

Line 223: x_approver_category_desc := jtf_varchar2_table_100();

219: x_approver_status := jtf_varchar2_table_100();
220: x_approver_name := jtf_varchar2_table_100();
221: x_approval_comments := jtf_varchar2_table_300();
222: x_approver_category :=jtf_varchar2_table_100();
223: x_approver_category_desc := jtf_varchar2_table_100();
224: x_approver_type_desc := jtf_varchar2_table_100();
225: x_sub_list_desc := jtf_varchar2_table_100();
226: x_item_id := jtf_varchar2_table_100();
227: x_item_class := jtf_varchar2_table_100();

Line 224: x_approver_type_desc := jtf_varchar2_table_100();

220: x_approver_name := jtf_varchar2_table_100();
221: x_approval_comments := jtf_varchar2_table_300();
222: x_approver_category :=jtf_varchar2_table_100();
223: x_approver_category_desc := jtf_varchar2_table_100();
224: x_approver_type_desc := jtf_varchar2_table_100();
225: x_sub_list_desc := jtf_varchar2_table_100();
226: x_item_id := jtf_varchar2_table_100();
227: x_item_class := jtf_varchar2_table_100();
228: x_action_type := jtf_varchar2_table_300();

Line 225: x_sub_list_desc := jtf_varchar2_table_100();

221: x_approval_comments := jtf_varchar2_table_300();
222: x_approver_category :=jtf_varchar2_table_100();
223: x_approver_category_desc := jtf_varchar2_table_100();
224: x_approver_type_desc := jtf_varchar2_table_100();
225: x_sub_list_desc := jtf_varchar2_table_100();
226: x_item_id := jtf_varchar2_table_100();
227: x_item_class := jtf_varchar2_table_100();
228: x_action_type := jtf_varchar2_table_300();
229: x_action_type_id := jtf_number_table();

Line 226: x_item_id := jtf_varchar2_table_100();

222: x_approver_category :=jtf_varchar2_table_100();
223: x_approver_category_desc := jtf_varchar2_table_100();
224: x_approver_type_desc := jtf_varchar2_table_100();
225: x_sub_list_desc := jtf_varchar2_table_100();
226: x_item_id := jtf_varchar2_table_100();
227: x_item_class := jtf_varchar2_table_100();
228: x_action_type := jtf_varchar2_table_300();
229: x_action_type_id := jtf_number_table();
230: x_chain_number := jtf_number_table();

Line 227: x_item_class := jtf_varchar2_table_100();

223: x_approver_category_desc := jtf_varchar2_table_100();
224: x_approver_type_desc := jtf_varchar2_table_100();
225: x_sub_list_desc := jtf_varchar2_table_100();
226: x_item_id := jtf_varchar2_table_100();
227: x_item_class := jtf_varchar2_table_100();
228: x_action_type := jtf_varchar2_table_300();
229: x_action_type_id := jtf_number_table();
230: x_chain_number := jtf_number_table();
231: x_occurrence := jtf_number_table();

Line 232: x_authority := jtf_varchar2_table_100();

228: x_action_type := jtf_varchar2_table_300();
229: x_action_type_id := jtf_number_table();
230: x_chain_number := jtf_number_table();
231: x_occurrence := jtf_number_table();
232: x_authority := jtf_varchar2_table_100();
233: x_date_sent := jtf_date_table();
234: x_date_received := jtf_date_table();
235: IF p_qte_approvers_list_tbl.count > 0 THEN
236: x_approval_det_id.extend(p_qte_approvers_list_tbl.count);

Line 302: x_rule_type OUT NOCOPY jtf_varchar2_table_100,

298: x_rule_id OUT NOCOPY jtf_number_table,
299: x_object_approval_id OUT NOCOPY jtf_number_table,
300: x_rule_action_id OUT NOCOPY jtf_number_table,
301: x_rule_description OUT NOCOPY jtf_varchar2_table_300,
302: x_rule_type OUT NOCOPY jtf_varchar2_table_100,
303: x_approval_level OUT NOCOPY jtf_varchar2_table_300,
304: x_rule_item_class OUT NOCOPY jtf_varchar2_table_100,
305: x_rule_category_desc OUT NOCOPY jtf_varchar2_table_100
306: )

Line 304: x_rule_item_class OUT NOCOPY jtf_varchar2_table_100,

300: x_rule_action_id OUT NOCOPY jtf_number_table,
301: x_rule_description OUT NOCOPY jtf_varchar2_table_300,
302: x_rule_type OUT NOCOPY jtf_varchar2_table_100,
303: x_approval_level OUT NOCOPY jtf_varchar2_table_300,
304: x_rule_item_class OUT NOCOPY jtf_varchar2_table_100,
305: x_rule_category_desc OUT NOCOPY jtf_varchar2_table_100
306: )
307: AS
308: ddindx binary_integer; indx binary_integer;

Line 305: x_rule_category_desc OUT NOCOPY jtf_varchar2_table_100

301: x_rule_description OUT NOCOPY jtf_varchar2_table_300,
302: x_rule_type OUT NOCOPY jtf_varchar2_table_100,
303: x_approval_level OUT NOCOPY jtf_varchar2_table_300,
304: x_rule_item_class OUT NOCOPY jtf_varchar2_table_100,
305: x_rule_category_desc OUT NOCOPY jtf_varchar2_table_100
306: )
307: AS
308: ddindx binary_integer; indx binary_integer;
309: BEGIN

Line 314: x_rule_type := jtf_varchar2_table_100();

310: x_rule_id := jtf_number_table();
311: x_object_approval_id := jtf_number_table();
312: x_rule_action_id := jtf_number_table();
313: x_rule_description := jtf_varchar2_table_300();
314: x_rule_type := jtf_varchar2_table_100();
315: x_approval_level := jtf_varchar2_table_300();
316: x_rule_item_class := jtf_varchar2_table_100();
317: x_rule_category_desc := jtf_varchar2_table_100();
318: IF p_qte_rules_list_tbl.count > 0 THEN

Line 316: x_rule_item_class := jtf_varchar2_table_100();

312: x_rule_action_id := jtf_number_table();
313: x_rule_description := jtf_varchar2_table_300();
314: x_rule_type := jtf_varchar2_table_100();
315: x_approval_level := jtf_varchar2_table_300();
316: x_rule_item_class := jtf_varchar2_table_100();
317: x_rule_category_desc := jtf_varchar2_table_100();
318: IF p_qte_rules_list_tbl.count > 0 THEN
319: x_rule_id.extend(p_qte_rules_list_tbl.count);
320: x_object_approval_id.extend(p_qte_rules_list_tbl.count);

Line 317: x_rule_category_desc := jtf_varchar2_table_100();

313: x_rule_description := jtf_varchar2_table_300();
314: x_rule_type := jtf_varchar2_table_100();
315: x_approval_level := jtf_varchar2_table_300();
316: x_rule_item_class := jtf_varchar2_table_100();
317: x_rule_category_desc := jtf_varchar2_table_100();
318: IF p_qte_rules_list_tbl.count > 0 THEN
319: x_rule_id.extend(p_qte_rules_list_tbl.count);
320: x_object_approval_id.extend(p_qte_rules_list_tbl.count);
321: x_rule_action_id.extend(p_qte_rules_list_tbl.count);

Line 355: x_qa_approver_status OUT NOCOPY jtf_varchar2_table_100 ,

351: x_qa_approver_person_id OUT NOCOPY jtf_number_table ,
352: x_qa_approver_user_id OUT NOCOPY jtf_number_table ,
353: x_qa_notification_id OUT NOCOPY jtf_number_table ,
354: x_qa_approver_sequence OUT NOCOPY jtf_number_table ,
355: x_qa_approver_status OUT NOCOPY jtf_varchar2_table_100 ,
356: x_qa_name OUT NOCOPY jtf_varchar2_table_300 ,
357: x_qa_approver_name OUT NOCOPY jtf_varchar2_table_100 ,
358: x_qa_approval_comments OUT NOCOPY jtf_varchar2_table_300 ,
359: x_qa_approver_category OUT NOCOPY jtf_varchar2_table_100 ,

Line 357: x_qa_approver_name OUT NOCOPY jtf_varchar2_table_100 ,

353: x_qa_notification_id OUT NOCOPY jtf_number_table ,
354: x_qa_approver_sequence OUT NOCOPY jtf_number_table ,
355: x_qa_approver_status OUT NOCOPY jtf_varchar2_table_100 ,
356: x_qa_name OUT NOCOPY jtf_varchar2_table_300 ,
357: x_qa_approver_name OUT NOCOPY jtf_varchar2_table_100 ,
358: x_qa_approval_comments OUT NOCOPY jtf_varchar2_table_300 ,
359: x_qa_approver_category OUT NOCOPY jtf_varchar2_table_100 ,
360: x_qa_approver_category_desc OUT NOCOPY jtf_varchar2_table_100 ,
361: x_qa_approver_type_desc OUT NOCOPY jtf_varchar2_table_100 ,

Line 359: x_qa_approver_category OUT NOCOPY jtf_varchar2_table_100 ,

355: x_qa_approver_status OUT NOCOPY jtf_varchar2_table_100 ,
356: x_qa_name OUT NOCOPY jtf_varchar2_table_300 ,
357: x_qa_approver_name OUT NOCOPY jtf_varchar2_table_100 ,
358: x_qa_approval_comments OUT NOCOPY jtf_varchar2_table_300 ,
359: x_qa_approver_category OUT NOCOPY jtf_varchar2_table_100 ,
360: x_qa_approver_category_desc OUT NOCOPY jtf_varchar2_table_100 ,
361: x_qa_approver_type_desc OUT NOCOPY jtf_varchar2_table_100 ,
362: x_qa_sub_list_desc OUT NOCOPY jtf_varchar2_table_100 ,
363: x_qa_item_id OUT NOCOPY jtf_varchar2_table_100 ,

Line 360: x_qa_approver_category_desc OUT NOCOPY jtf_varchar2_table_100 ,

356: x_qa_name OUT NOCOPY jtf_varchar2_table_300 ,
357: x_qa_approver_name OUT NOCOPY jtf_varchar2_table_100 ,
358: x_qa_approval_comments OUT NOCOPY jtf_varchar2_table_300 ,
359: x_qa_approver_category OUT NOCOPY jtf_varchar2_table_100 ,
360: x_qa_approver_category_desc OUT NOCOPY jtf_varchar2_table_100 ,
361: x_qa_approver_type_desc OUT NOCOPY jtf_varchar2_table_100 ,
362: x_qa_sub_list_desc OUT NOCOPY jtf_varchar2_table_100 ,
363: x_qa_item_id OUT NOCOPY jtf_varchar2_table_100 ,
364: x_qa_item_class OUT NOCOPY jtf_varchar2_table_100 ,

Line 361: x_qa_approver_type_desc OUT NOCOPY jtf_varchar2_table_100 ,

357: x_qa_approver_name OUT NOCOPY jtf_varchar2_table_100 ,
358: x_qa_approval_comments OUT NOCOPY jtf_varchar2_table_300 ,
359: x_qa_approver_category OUT NOCOPY jtf_varchar2_table_100 ,
360: x_qa_approver_category_desc OUT NOCOPY jtf_varchar2_table_100 ,
361: x_qa_approver_type_desc OUT NOCOPY jtf_varchar2_table_100 ,
362: x_qa_sub_list_desc OUT NOCOPY jtf_varchar2_table_100 ,
363: x_qa_item_id OUT NOCOPY jtf_varchar2_table_100 ,
364: x_qa_item_class OUT NOCOPY jtf_varchar2_table_100 ,
365: x_qa_action_type OUT NOCOPY jtf_varchar2_table_300 ,

Line 362: x_qa_sub_list_desc OUT NOCOPY jtf_varchar2_table_100 ,

358: x_qa_approval_comments OUT NOCOPY jtf_varchar2_table_300 ,
359: x_qa_approver_category OUT NOCOPY jtf_varchar2_table_100 ,
360: x_qa_approver_category_desc OUT NOCOPY jtf_varchar2_table_100 ,
361: x_qa_approver_type_desc OUT NOCOPY jtf_varchar2_table_100 ,
362: x_qa_sub_list_desc OUT NOCOPY jtf_varchar2_table_100 ,
363: x_qa_item_id OUT NOCOPY jtf_varchar2_table_100 ,
364: x_qa_item_class OUT NOCOPY jtf_varchar2_table_100 ,
365: x_qa_action_type OUT NOCOPY jtf_varchar2_table_300 ,
366: x_qa_action_type_id OUT NOCOPY jtf_number_table ,

Line 363: x_qa_item_id OUT NOCOPY jtf_varchar2_table_100 ,

359: x_qa_approver_category OUT NOCOPY jtf_varchar2_table_100 ,
360: x_qa_approver_category_desc OUT NOCOPY jtf_varchar2_table_100 ,
361: x_qa_approver_type_desc OUT NOCOPY jtf_varchar2_table_100 ,
362: x_qa_sub_list_desc OUT NOCOPY jtf_varchar2_table_100 ,
363: x_qa_item_id OUT NOCOPY jtf_varchar2_table_100 ,
364: x_qa_item_class OUT NOCOPY jtf_varchar2_table_100 ,
365: x_qa_action_type OUT NOCOPY jtf_varchar2_table_300 ,
366: x_qa_action_type_id OUT NOCOPY jtf_number_table ,
367: x_qa_chain_number OUT NOCOPY jtf_number_table ,

Line 364: x_qa_item_class OUT NOCOPY jtf_varchar2_table_100 ,

360: x_qa_approver_category_desc OUT NOCOPY jtf_varchar2_table_100 ,
361: x_qa_approver_type_desc OUT NOCOPY jtf_varchar2_table_100 ,
362: x_qa_sub_list_desc OUT NOCOPY jtf_varchar2_table_100 ,
363: x_qa_item_id OUT NOCOPY jtf_varchar2_table_100 ,
364: x_qa_item_class OUT NOCOPY jtf_varchar2_table_100 ,
365: x_qa_action_type OUT NOCOPY jtf_varchar2_table_300 ,
366: x_qa_action_type_id OUT NOCOPY jtf_number_table ,
367: x_qa_chain_number OUT NOCOPY jtf_number_table ,
368: x_qa_occurrence OUT NOCOPY jtf_number_table ,

Line 369: x_qa_authority OUT NOCOPY jtf_varchar2_table_100 ,

365: x_qa_action_type OUT NOCOPY jtf_varchar2_table_300 ,
366: x_qa_action_type_id OUT NOCOPY jtf_number_table ,
367: x_qa_chain_number OUT NOCOPY jtf_number_table ,
368: x_qa_occurrence OUT NOCOPY jtf_number_table ,
369: x_qa_authority OUT NOCOPY jtf_varchar2_table_100 ,
370: x_qa_date_sent OUT NOCOPY jtf_date_table ,
371: x_qa_date_received OUT NOCOPY jtf_date_table ,
372: x_qr_rule_id OUT NOCOPY jtf_number_table ,
373: x_qr_object_approval_id OUT NOCOPY jtf_number_table ,

Line 376: x_qr_rule_type OUT NOCOPY jtf_varchar2_table_100 ,

372: x_qr_rule_id OUT NOCOPY jtf_number_table ,
373: x_qr_object_approval_id OUT NOCOPY jtf_number_table ,
374: x_qr_rule_action_id OUT NOCOPY jtf_number_table ,
375: x_qr_rule_description OUT NOCOPY jtf_varchar2_table_300 ,
376: x_qr_rule_type OUT NOCOPY jtf_varchar2_table_100 ,
377: x_qr_approval_level OUT NOCOPY jtf_varchar2_table_300 ,
378: x_qr_rule_item_class OUT NOCOPY jtf_varchar2_table_100 ,
379: x_qr_rule_category_desc OUT NOCOPY jtf_varchar2_table_100 ,
380: p_object_id IN NUMBER := FND_API.G_MISS_NUM ,

Line 378: x_qr_rule_item_class OUT NOCOPY jtf_varchar2_table_100 ,

374: x_qr_rule_action_id OUT NOCOPY jtf_number_table ,
375: x_qr_rule_description OUT NOCOPY jtf_varchar2_table_300 ,
376: x_qr_rule_type OUT NOCOPY jtf_varchar2_table_100 ,
377: x_qr_approval_level OUT NOCOPY jtf_varchar2_table_300 ,
378: x_qr_rule_item_class OUT NOCOPY jtf_varchar2_table_100 ,
379: x_qr_rule_category_desc OUT NOCOPY jtf_varchar2_table_100 ,
380: p_object_id IN NUMBER := FND_API.G_MISS_NUM ,
381: p_object_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
382: p_application_id IN NUMBER := FND_API.G_MISS_NUM ,

Line 379: x_qr_rule_category_desc OUT NOCOPY jtf_varchar2_table_100 ,

375: x_qr_rule_description OUT NOCOPY jtf_varchar2_table_300 ,
376: x_qr_rule_type OUT NOCOPY jtf_varchar2_table_100 ,
377: x_qr_approval_level OUT NOCOPY jtf_varchar2_table_300 ,
378: x_qr_rule_item_class OUT NOCOPY jtf_varchar2_table_100 ,
379: x_qr_rule_category_desc OUT NOCOPY jtf_varchar2_table_100 ,
380: p_object_id IN NUMBER := FND_API.G_MISS_NUM ,
381: p_object_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
382: p_application_id IN NUMBER := FND_API.G_MISS_NUM ,
383: p_object_approval_id IN NUMBER := FND_API.G_MISS_NUM ,

Line 501: p_qa_approver_status IN jtf_varchar2_table_100 := NULL,

497: p_qa_approver_person_id IN jtf_number_table := NULL,
498: p_qa_approver_user_id IN jtf_number_table := NULL,
499: p_qa_notification_id IN jtf_number_table := NULL,
500: p_qa_approver_sequence IN jtf_number_table := NULL,
501: p_qa_approver_status IN jtf_varchar2_table_100 := NULL,
502: p_qa_name IN jtf_varchar2_table_300 := NULL,
503: p_qa_approver_name IN jtf_varchar2_table_100 := NULL,
504: p_qa_approval_comments IN jtf_varchar2_table_300 := NULL,
505: p_qa_approver_category IN jtf_varchar2_table_100 := NULL,

Line 503: p_qa_approver_name IN jtf_varchar2_table_100 := NULL,

499: p_qa_notification_id IN jtf_number_table := NULL,
500: p_qa_approver_sequence IN jtf_number_table := NULL,
501: p_qa_approver_status IN jtf_varchar2_table_100 := NULL,
502: p_qa_name IN jtf_varchar2_table_300 := NULL,
503: p_qa_approver_name IN jtf_varchar2_table_100 := NULL,
504: p_qa_approval_comments IN jtf_varchar2_table_300 := NULL,
505: p_qa_approver_category IN jtf_varchar2_table_100 := NULL,
506: p_qa_approver_category_desc IN jtf_varchar2_table_100 := NULL,
507: p_qa_approver_type_desc IN jtf_varchar2_table_100 := NULL,

Line 505: p_qa_approver_category IN jtf_varchar2_table_100 := NULL,

501: p_qa_approver_status IN jtf_varchar2_table_100 := NULL,
502: p_qa_name IN jtf_varchar2_table_300 := NULL,
503: p_qa_approver_name IN jtf_varchar2_table_100 := NULL,
504: p_qa_approval_comments IN jtf_varchar2_table_300 := NULL,
505: p_qa_approver_category IN jtf_varchar2_table_100 := NULL,
506: p_qa_approver_category_desc IN jtf_varchar2_table_100 := NULL,
507: p_qa_approver_type_desc IN jtf_varchar2_table_100 := NULL,
508: p_qa_sub_list_desc IN jtf_varchar2_table_100 := NULL,
509: p_qa_item_id IN jtf_varchar2_table_100 := NULL,

Line 506: p_qa_approver_category_desc IN jtf_varchar2_table_100 := NULL,

502: p_qa_name IN jtf_varchar2_table_300 := NULL,
503: p_qa_approver_name IN jtf_varchar2_table_100 := NULL,
504: p_qa_approval_comments IN jtf_varchar2_table_300 := NULL,
505: p_qa_approver_category IN jtf_varchar2_table_100 := NULL,
506: p_qa_approver_category_desc IN jtf_varchar2_table_100 := NULL,
507: p_qa_approver_type_desc IN jtf_varchar2_table_100 := NULL,
508: p_qa_sub_list_desc IN jtf_varchar2_table_100 := NULL,
509: p_qa_item_id IN jtf_varchar2_table_100 := NULL,
510: p_qa_item_class IN jtf_varchar2_table_100 := NULL,

Line 507: p_qa_approver_type_desc IN jtf_varchar2_table_100 := NULL,

503: p_qa_approver_name IN jtf_varchar2_table_100 := NULL,
504: p_qa_approval_comments IN jtf_varchar2_table_300 := NULL,
505: p_qa_approver_category IN jtf_varchar2_table_100 := NULL,
506: p_qa_approver_category_desc IN jtf_varchar2_table_100 := NULL,
507: p_qa_approver_type_desc IN jtf_varchar2_table_100 := NULL,
508: p_qa_sub_list_desc IN jtf_varchar2_table_100 := NULL,
509: p_qa_item_id IN jtf_varchar2_table_100 := NULL,
510: p_qa_item_class IN jtf_varchar2_table_100 := NULL,
511: p_qa_action_type IN jtf_varchar2_table_300 := NULL,

Line 508: p_qa_sub_list_desc IN jtf_varchar2_table_100 := NULL,

504: p_qa_approval_comments IN jtf_varchar2_table_300 := NULL,
505: p_qa_approver_category IN jtf_varchar2_table_100 := NULL,
506: p_qa_approver_category_desc IN jtf_varchar2_table_100 := NULL,
507: p_qa_approver_type_desc IN jtf_varchar2_table_100 := NULL,
508: p_qa_sub_list_desc IN jtf_varchar2_table_100 := NULL,
509: p_qa_item_id IN jtf_varchar2_table_100 := NULL,
510: p_qa_item_class IN jtf_varchar2_table_100 := NULL,
511: p_qa_action_type IN jtf_varchar2_table_300 := NULL,
512: p_qa_action_type_id IN jtf_number_table := NULL,

Line 509: p_qa_item_id IN jtf_varchar2_table_100 := NULL,

505: p_qa_approver_category IN jtf_varchar2_table_100 := NULL,
506: p_qa_approver_category_desc IN jtf_varchar2_table_100 := NULL,
507: p_qa_approver_type_desc IN jtf_varchar2_table_100 := NULL,
508: p_qa_sub_list_desc IN jtf_varchar2_table_100 := NULL,
509: p_qa_item_id IN jtf_varchar2_table_100 := NULL,
510: p_qa_item_class IN jtf_varchar2_table_100 := NULL,
511: p_qa_action_type IN jtf_varchar2_table_300 := NULL,
512: p_qa_action_type_id IN jtf_number_table := NULL,
513: p_qa_chain_number IN jtf_number_table := NULL,

Line 510: p_qa_item_class IN jtf_varchar2_table_100 := NULL,

506: p_qa_approver_category_desc IN jtf_varchar2_table_100 := NULL,
507: p_qa_approver_type_desc IN jtf_varchar2_table_100 := NULL,
508: p_qa_sub_list_desc IN jtf_varchar2_table_100 := NULL,
509: p_qa_item_id IN jtf_varchar2_table_100 := NULL,
510: p_qa_item_class IN jtf_varchar2_table_100 := NULL,
511: p_qa_action_type IN jtf_varchar2_table_300 := NULL,
512: p_qa_action_type_id IN jtf_number_table := NULL,
513: p_qa_chain_number IN jtf_number_table := NULL,
514: p_qa_occurrence IN jtf_number_table := NULL,

Line 515: p_qa_authority IN jtf_varchar2_table_100 := NULL,

511: p_qa_action_type IN jtf_varchar2_table_300 := NULL,
512: p_qa_action_type_id IN jtf_number_table := NULL,
513: p_qa_chain_number IN jtf_number_table := NULL,
514: p_qa_occurrence IN jtf_number_table := NULL,
515: p_qa_authority IN jtf_varchar2_table_100 := NULL,
516: p_qa_date_sent IN jtf_date_table := NULL,
517: p_qa_date_received IN jtf_date_table := NULL,
518: x_object_approval_id OUT NOCOPY NUMBER,
519: x_approval_instance_id OUT NOCOPY NUMBER,