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_300

Line 32: p_name IN jtf_varchar2_table_300 := 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,
36: p_approver_category_desc IN jtf_varchar2_table_100 := NULL,

Line 34: p_approval_comments IN jtf_varchar2_table_300 := 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,
38: p_sub_list_desc IN jtf_varchar2_table_100 := NULL,

Line 41: p_action_type IN jtf_varchar2_table_300 := 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,
45: p_authority IN jtf_varchar2_table_100 := NULL,

Line 192: x_name OUT NOCOPY jtf_varchar2_table_300,

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,
196: x_approver_category_desc OUT NOCOPY jtf_varchar2_table_100,

Line 194: x_approval_comments OUT NOCOPY jtf_varchar2_table_300,

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,
198: x_sub_list_desc OUT NOCOPY jtf_varchar2_table_100,

Line 201: x_action_type OUT NOCOPY jtf_varchar2_table_300,

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,
205: x_authority OUT NOCOPY jtf_varchar2_table_100,

Line 218: x_name := jtf_varchar2_table_300();

214: x_approver_person_id := jtf_number_table();
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();

Line 221: x_approval_comments := jtf_varchar2_table_300();

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();
225: x_sub_list_desc := jtf_varchar2_table_100();

Line 228: x_action_type := jtf_varchar2_table_300();

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();
232: x_authority := jtf_varchar2_table_100();

Line 301: x_rule_description OUT NOCOPY jtf_varchar2_table_300,

297: p_qte_rules_list_tbl IN ASO_PA_Apr_Pub.Rules_List_Tbl_Type,
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

Line 303: x_approval_level OUT NOCOPY jtf_varchar2_table_300,

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: )
307: AS

Line 313: x_rule_description := jtf_varchar2_table_300();

309: BEGIN
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();

Line 315: x_approval_level := jtf_varchar2_table_300();

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
319: x_rule_id.extend(p_qte_rules_list_tbl.count);

Line 356: x_qa_name OUT NOCOPY jtf_varchar2_table_300 ,

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 ,
360: x_qa_approver_category_desc OUT NOCOPY jtf_varchar2_table_100 ,

Line 358: x_qa_approval_comments OUT NOCOPY jtf_varchar2_table_300 ,

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 ,
362: x_qa_sub_list_desc OUT NOCOPY jtf_varchar2_table_100 ,

Line 365: x_qa_action_type OUT NOCOPY jtf_varchar2_table_300 ,

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 ,
369: x_qa_authority OUT NOCOPY jtf_varchar2_table_100 ,

Line 375: x_qr_rule_description OUT NOCOPY jtf_varchar2_table_300 ,

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 ,
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 ,

Line 377: x_qr_approval_level OUT NOCOPY jtf_varchar2_table_300 ,

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 ,
381: p_object_type IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 502: p_qa_name IN jtf_varchar2_table_300 := 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,
506: p_qa_approver_category_desc IN jtf_varchar2_table_100 := NULL,

Line 504: p_qa_approval_comments IN jtf_varchar2_table_300 := 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,
508: p_qa_sub_list_desc IN jtf_varchar2_table_100 := NULL,

Line 511: p_qa_action_type IN jtf_varchar2_table_300 := 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,
515: p_qa_authority IN jtf_varchar2_table_100 := NULL,