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.EDR_RULE_TEMP dependencies on AME_UTIL

Line 8: conditionIdsOut out nocopy ame_util.idList,

4:
5: procedure getRuleDetails( ruleIdIn in number,
6: ruleTypeOut out nocopy varchar2,
7: ruleDescriptionOut out nocopy varchar2,
8: conditionIdsOut out nocopy ame_util.idList,
9: conditionDescriptionsOut out nocopy ame_util.longestStringList,
10: conditionHasLOVsOut out nocopy ame_util.charList,
11: approvalTypeNameOut out nocopy varchar2,
12: approvalTypeDescriptionOut out nocopy varchar2,

Line 9: conditionDescriptionsOut out nocopy ame_util.longestStringList,

5: procedure getRuleDetails( ruleIdIn in number,
6: ruleTypeOut out nocopy varchar2,
7: ruleDescriptionOut out nocopy varchar2,
8: conditionIdsOut out nocopy ame_util.idList,
9: conditionDescriptionsOut out nocopy ame_util.longestStringList,
10: conditionHasLOVsOut out nocopy ame_util.charList,
11: approvalTypeNameOut out nocopy varchar2,
12: approvalTypeDescriptionOut out nocopy varchar2,
13: approvalDescriptionOut out nocopy varchar2) IS

Line 10: conditionHasLOVsOut out nocopy ame_util.charList,

6: ruleTypeOut out nocopy varchar2,
7: ruleDescriptionOut out nocopy varchar2,
8: conditionIdsOut out nocopy ame_util.idList,
9: conditionDescriptionsOut out nocopy ame_util.longestStringList,
10: conditionHasLOVsOut out nocopy ame_util.charList,
11: approvalTypeNameOut out nocopy varchar2,
12: approvalTypeDescriptionOut out nocopy varchar2,
13: approvalDescriptionOut out nocopy varchar2) IS
14:

Line 15: l_approvalTypeNames ame_util.stringList;

11: approvalTypeNameOut out nocopy varchar2,
12: approvalTypeDescriptionOut out nocopy varchar2,
13: approvalDescriptionOut out nocopy varchar2) IS
14:
15: l_approvalTypeNames ame_util.stringList;
16: l_approvalTypeDescriptions ame_util.stringList;
17: l_approvalDescriptions ame_util.stringList;
18: Begin
19: ame_api3.getRuleDetails3( ruleIdIn => ruleIdIn,

Line 16: l_approvalTypeDescriptions ame_util.stringList;

12: approvalTypeDescriptionOut out nocopy varchar2,
13: approvalDescriptionOut out nocopy varchar2) IS
14:
15: l_approvalTypeNames ame_util.stringList;
16: l_approvalTypeDescriptions ame_util.stringList;
17: l_approvalDescriptions ame_util.stringList;
18: Begin
19: ame_api3.getRuleDetails3( ruleIdIn => ruleIdIn,
20: ruleTypeOut => ruleTypeOut,

Line 17: l_approvalDescriptions ame_util.stringList;

13: approvalDescriptionOut out nocopy varchar2) IS
14:
15: l_approvalTypeNames ame_util.stringList;
16: l_approvalTypeDescriptions ame_util.stringList;
17: l_approvalDescriptions ame_util.stringList;
18: Begin
19: ame_api3.getRuleDetails3( ruleIdIn => ruleIdIn,
20: ruleTypeOut => ruleTypeOut,
21: ruleDescriptionOut =>ruleDescriptionOut,

Line 52: l_rule_ids ame_util.idList;

48: ith NUMBER;
49: l_apps_id NUMBER;
50: l_apps_name VARCHAR2(240);
51:
52: l_rule_ids ame_util.idList;
53: l_rule_id_t ame_util.idList;
54: l_date_0s edr_rule_temp.edr_array_date;
55: l_date_1s edr_rule_temp.edr_array_date;
56:

Line 53: l_rule_id_t ame_util.idList;

49: l_apps_id NUMBER;
50: l_apps_name VARCHAR2(240);
51:
52: l_rule_ids ame_util.idList;
53: l_rule_id_t ame_util.idList;
54: l_date_0s edr_rule_temp.edr_array_date;
55: l_date_1s edr_rule_temp.edr_array_date;
56:
57: l_rule_name VARCHAR2(100);

Line 64: l_cond_ids ame_util.idList;

60: l_deft_use VARCHAR2(1);
61:
62: l_rule_type VARCHAR2(100);
63: l_rule_desc VARCHAR2(100);
64: l_cond_ids ame_util.idList;
65: l_cond_desc ame_util.longestStringList;
66: l_cond_lov ame_util.charList;
67: l_appr_name VARCHAR2(100);
68: l_appr_type VARCHAR2(100);

Line 65: l_cond_desc ame_util.longestStringList;

61:
62: l_rule_type VARCHAR2(100);
63: l_rule_desc VARCHAR2(100);
64: l_cond_ids ame_util.idList;
65: l_cond_desc ame_util.longestStringList;
66: l_cond_lov ame_util.charList;
67: l_appr_name VARCHAR2(100);
68: l_appr_type VARCHAR2(100);
69: l_appr_desc VARCHAR2(100);

Line 66: l_cond_lov ame_util.charList;

62: l_rule_type VARCHAR2(100);
63: l_rule_desc VARCHAR2(100);
64: l_cond_ids ame_util.idList;
65: l_cond_desc ame_util.longestStringList;
66: l_cond_lov ame_util.charList;
67: l_appr_name VARCHAR2(100);
68: l_appr_type VARCHAR2(100);
69: l_appr_desc VARCHAR2(100);
70:

Line 172: l_cond_ids ame_util.idList;

168: l_date_end DATE;
169:
170: l_rule_type VARCHAR2(100);
171: l_rule_desc VARCHAR2(100);
172: l_cond_ids ame_util.idList;
173: l_cond_desc ame_util.longestStringList;
174: l_cond_lov ame_util.charList;
175: l_appr_name VARCHAR2(100);
176: l_appr_type VARCHAR2(100);

Line 173: l_cond_desc ame_util.longestStringList;

169:
170: l_rule_type VARCHAR2(100);
171: l_rule_desc VARCHAR2(100);
172: l_cond_ids ame_util.idList;
173: l_cond_desc ame_util.longestStringList;
174: l_cond_lov ame_util.charList;
175: l_appr_name VARCHAR2(100);
176: l_appr_type VARCHAR2(100);
177: l_appr_desc VARCHAR2(100);

Line 174: l_cond_lov ame_util.charList;

170: l_rule_type VARCHAR2(100);
171: l_rule_desc VARCHAR2(100);
172: l_cond_ids ame_util.idList;
173: l_cond_desc ame_util.longestStringList;
174: l_cond_lov ame_util.charList;
175: l_appr_name VARCHAR2(100);
176: l_appr_type VARCHAR2(100);
177: l_appr_desc VARCHAR2(100);
178:

Line 287: l_rule_ids ame_util.idList;

283: ith NUMBER;
284: l_apps_id NUMBER;
285: l_apps_name VARCHAR2(240);
286:
287: l_rule_ids ame_util.idList;
288: l_rule_id_t ame_util.idList;
289: l_date_0s edr_rule_temp.edr_array_date;
290: l_date_1s edr_rule_temp.edr_array_date;
291:

Line 288: l_rule_id_t ame_util.idList;

284: l_apps_id NUMBER;
285: l_apps_name VARCHAR2(240);
286:
287: l_rule_ids ame_util.idList;
288: l_rule_id_t ame_util.idList;
289: l_date_0s edr_rule_temp.edr_array_date;
290: l_date_1s edr_rule_temp.edr_array_date;
291:
292: l_rule_name VARCHAR2(100);

Line 299: l_cond_ids ame_util.idList;

295: l_deft_use VARCHAR2(1);
296:
297: l_rule_type VARCHAR2(100);
298: l_rule_desc VARCHAR2(100);
299: l_cond_ids ame_util.idList;
300: l_cond_desc ame_util.longestStringList;
301: l_cond_lov ame_util.charList;
302: l_appr_name VARCHAR2(100);
303: l_appr_type VARCHAR2(100);

Line 300: l_cond_desc ame_util.longestStringList;

296:
297: l_rule_type VARCHAR2(100);
298: l_rule_desc VARCHAR2(100);
299: l_cond_ids ame_util.idList;
300: l_cond_desc ame_util.longestStringList;
301: l_cond_lov ame_util.charList;
302: l_appr_name VARCHAR2(100);
303: l_appr_type VARCHAR2(100);
304: l_appr_desc VARCHAR2(100);

Line 301: l_cond_lov ame_util.charList;

297: l_rule_type VARCHAR2(100);
298: l_rule_desc VARCHAR2(100);
299: l_cond_ids ame_util.idList;
300: l_cond_desc ame_util.longestStringList;
301: l_cond_lov ame_util.charList;
302: l_appr_name VARCHAR2(100);
303: l_appr_type VARCHAR2(100);
304: l_appr_desc VARCHAR2(100);
305:

Line 399: l_cond_ids ame_util.idList;

395: l_date_end DATE;
396:
397: l_rule_type VARCHAR2(100);
398: l_rule_desc VARCHAR2(100);
399: l_cond_ids ame_util.idList;
400: l_cond_desc ame_util.longestStringList;
401: l_cond_lov ame_util.charList;
402: l_appr_name VARCHAR2(100);
403: l_appr_type VARCHAR2(100);

Line 400: l_cond_desc ame_util.longestStringList;

396:
397: l_rule_type VARCHAR2(100);
398: l_rule_desc VARCHAR2(100);
399: l_cond_ids ame_util.idList;
400: l_cond_desc ame_util.longestStringList;
401: l_cond_lov ame_util.charList;
402: l_appr_name VARCHAR2(100);
403: l_appr_type VARCHAR2(100);
404: l_appr_desc VARCHAR2(100);

Line 401: l_cond_lov ame_util.charList;

397: l_rule_type VARCHAR2(100);
398: l_rule_desc VARCHAR2(100);
399: l_cond_ids ame_util.idList;
400: l_cond_desc ame_util.longestStringList;
401: l_cond_lov ame_util.charList;
402: l_appr_name VARCHAR2(100);
403: l_appr_type VARCHAR2(100);
404: l_appr_desc VARCHAR2(100);
405:

Line 490: l_rule_ids ame_util.idList;

486: ith NUMBER;
487: l_apps_id NUMBER;
488: l_apps_name VARCHAR2(240);
489:
490: l_rule_ids ame_util.idList;
491: l_rule_id_t ame_util.idList;
492: l_date_0s edr_rule_temp.edr_array_date;
493: l_date_1s edr_rule_temp.edr_array_date;
494:

Line 491: l_rule_id_t ame_util.idList;

487: l_apps_id NUMBER;
488: l_apps_name VARCHAR2(240);
489:
490: l_rule_ids ame_util.idList;
491: l_rule_id_t ame_util.idList;
492: l_date_0s edr_rule_temp.edr_array_date;
493: l_date_1s edr_rule_temp.edr_array_date;
494:
495: l_rule_name VARCHAR2(100);

Line 502: l_cond_ids ame_util.idList;

498: l_deft_use VARCHAR2(1);
499:
500: l_rule_type VARCHAR2(100);
501: l_rule_desc VARCHAR2(100);
502: l_cond_ids ame_util.idList;
503: l_cond_desc ame_util.longestStringList;
504: l_cond_lov ame_util.charList;
505: l_appr_name VARCHAR2(100);
506: l_appr_type VARCHAR2(100);

Line 503: l_cond_desc ame_util.longestStringList;

499:
500: l_rule_type VARCHAR2(100);
501: l_rule_desc VARCHAR2(100);
502: l_cond_ids ame_util.idList;
503: l_cond_desc ame_util.longestStringList;
504: l_cond_lov ame_util.charList;
505: l_appr_name VARCHAR2(100);
506: l_appr_type VARCHAR2(100);
507: l_appr_desc VARCHAR2(100);

Line 504: l_cond_lov ame_util.charList;

500: l_rule_type VARCHAR2(100);
501: l_rule_desc VARCHAR2(100);
502: l_cond_ids ame_util.idList;
503: l_cond_desc ame_util.longestStringList;
504: l_cond_lov ame_util.charList;
505: l_appr_name VARCHAR2(100);
506: l_appr_type VARCHAR2(100);
507: l_appr_desc VARCHAR2(100);
508:

Line 611: l_cond_ids ame_util.idList;

607: l_date_end DATE;
608:
609: l_rule_type VARCHAR2(100);
610: l_rule_desc VARCHAR2(100);
611: l_cond_ids ame_util.idList;
612: l_cond_desc ame_util.longestStringList;
613: l_cond_lov ame_util.charList;
614: l_appr_name VARCHAR2(100);
615: l_appr_type VARCHAR2(100);

Line 612: l_cond_desc ame_util.longestStringList;

608:
609: l_rule_type VARCHAR2(100);
610: l_rule_desc VARCHAR2(100);
611: l_cond_ids ame_util.idList;
612: l_cond_desc ame_util.longestStringList;
613: l_cond_lov ame_util.charList;
614: l_appr_name VARCHAR2(100);
615: l_appr_type VARCHAR2(100);
616: l_appr_desc VARCHAR2(100);

Line 613: l_cond_lov ame_util.charList;

609: l_rule_type VARCHAR2(100);
610: l_rule_desc VARCHAR2(100);
611: l_cond_ids ame_util.idList;
612: l_cond_desc ame_util.longestStringList;
613: l_cond_lov ame_util.charList;
614: l_appr_name VARCHAR2(100);
615: l_appr_type VARCHAR2(100);
616: l_appr_desc VARCHAR2(100);
617:

Line 701: L_RULE_IDS AME_UTIL.IDLIST;

697: ITH NUMBER;
698: L_APPS_ID NUMBER;
699: L_APPS_NAME VARCHAR2(240);
700:
701: L_RULE_IDS AME_UTIL.IDLIST;
702: L_RULE_ID_T AME_UTIL.IDLIST;
703: L_DATE_0S EDR_RULE_TEMP.EDR_ARRAY_DATE;
704: L_DATE_1S EDR_RULE_TEMP.EDR_ARRAY_DATE;
705:

Line 702: L_RULE_ID_T AME_UTIL.IDLIST;

698: L_APPS_ID NUMBER;
699: L_APPS_NAME VARCHAR2(240);
700:
701: L_RULE_IDS AME_UTIL.IDLIST;
702: L_RULE_ID_T AME_UTIL.IDLIST;
703: L_DATE_0S EDR_RULE_TEMP.EDR_ARRAY_DATE;
704: L_DATE_1S EDR_RULE_TEMP.EDR_ARRAY_DATE;
705:
706: L_RULE_NAME VARCHAR2(100);

Line 713: L_COND_IDS AME_UTIL.IDLIST;

709: L_DEFT_USE VARCHAR2(1);
710:
711: L_RULE_TYPE VARCHAR2(100);
712: L_RULE_DESC VARCHAR2(100);
713: L_COND_IDS AME_UTIL.IDLIST;
714: L_COND_DESC AME_UTIL.LONGESTSTRINGLIST;
715: L_COND_LOV AME_UTIL.CHARLIST;
716: L_APPR_NAME VARCHAR2(100);
717: L_APPR_TYPE VARCHAR2(100);

Line 714: L_COND_DESC AME_UTIL.LONGESTSTRINGLIST;

710:
711: L_RULE_TYPE VARCHAR2(100);
712: L_RULE_DESC VARCHAR2(100);
713: L_COND_IDS AME_UTIL.IDLIST;
714: L_COND_DESC AME_UTIL.LONGESTSTRINGLIST;
715: L_COND_LOV AME_UTIL.CHARLIST;
716: L_APPR_NAME VARCHAR2(100);
717: L_APPR_TYPE VARCHAR2(100);
718: L_APPR_DESC VARCHAR2(100);

Line 715: L_COND_LOV AME_UTIL.CHARLIST;

711: L_RULE_TYPE VARCHAR2(100);
712: L_RULE_DESC VARCHAR2(100);
713: L_COND_IDS AME_UTIL.IDLIST;
714: L_COND_DESC AME_UTIL.LONGESTSTRINGLIST;
715: L_COND_LOV AME_UTIL.CHARLIST;
716: L_APPR_NAME VARCHAR2(100);
717: L_APPR_TYPE VARCHAR2(100);
718: L_APPR_DESC VARCHAR2(100);
719:

Line 820: L_COND_IDS AME_UTIL.IDLIST;

816: L_DATE_END DATE;
817:
818: L_RULE_TYPE VARCHAR2(100);
819: L_RULE_DESC VARCHAR2(100);
820: L_COND_IDS AME_UTIL.IDLIST;
821: L_COND_DESC AME_UTIL.LONGESTSTRINGLIST;
822: L_COND_LOV AME_UTIL.CHARLIST;
823: L_APPR_NAME VARCHAR2(100);
824: L_APPR_TYPE VARCHAR2(100);

Line 821: L_COND_DESC AME_UTIL.LONGESTSTRINGLIST;

817:
818: L_RULE_TYPE VARCHAR2(100);
819: L_RULE_DESC VARCHAR2(100);
820: L_COND_IDS AME_UTIL.IDLIST;
821: L_COND_DESC AME_UTIL.LONGESTSTRINGLIST;
822: L_COND_LOV AME_UTIL.CHARLIST;
823: L_APPR_NAME VARCHAR2(100);
824: L_APPR_TYPE VARCHAR2(100);
825: L_APPR_DESC VARCHAR2(100);

Line 822: L_COND_LOV AME_UTIL.CHARLIST;

818: L_RULE_TYPE VARCHAR2(100);
819: L_RULE_DESC VARCHAR2(100);
820: L_COND_IDS AME_UTIL.IDLIST;
821: L_COND_DESC AME_UTIL.LONGESTSTRINGLIST;
822: L_COND_LOV AME_UTIL.CHARLIST;
823: L_APPR_NAME VARCHAR2(100);
824: L_APPR_TYPE VARCHAR2(100);
825: L_APPR_DESC VARCHAR2(100);
826: