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 EDR_RULE_TEMP

Line 1: PACKAGE BODY EDR_RULE_TEMP AS

1: PACKAGE BODY EDR_RULE_TEMP AS
2: /* $Header: EDRTEMPB.pls 120.4.12000000.1 2007/01/18 05:55:41 appldev ship $ */
3: -- Bug 5167817 : start
4:
5: procedure getRuleDetails( ruleIdIn in number,

Line 54: l_date_0s edr_rule_temp.edr_array_date;

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);
58: l_count_num NUMBER;

Line 55: l_date_1s edr_rule_temp.edr_array_date;

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);
58: l_count_num NUMBER;
59: jth NUMBER;

Line 289: l_date_0s edr_rule_temp.edr_array_date;

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);
293: l_count_num NUMBER;

Line 290: l_date_1s edr_rule_temp.edr_array_date;

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);
293: l_count_num NUMBER;
294: jth NUMBER;

Line 492: l_date_0s edr_rule_temp.edr_array_date;

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);
496: l_count_num NUMBER;

Line 493: l_date_1s edr_rule_temp.edr_array_date;

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);
496: l_count_num NUMBER;
497: jth NUMBER;

Line 703: L_DATE_0S EDR_RULE_TEMP.EDR_ARRAY_DATE;

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);
707: L_COUNT_NUM NUMBER;

Line 704: L_DATE_1S EDR_RULE_TEMP.EDR_ARRAY_DATE;

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);
707: L_COUNT_NUM NUMBER;
708: jth NUMBER;

Line 934: FND_MESSAGE.SET_TOKEN('PKG_NAME','EDR_RULE_TEMP');

930:
931: ROLLBACK;
932: FND_MESSAGE.SET_NAME('FND','FND_AS_UNEXPECTED_ERROR');
933: FND_MESSAGE.SET_TOKEN('ERROR_TEXT',SQLERRM);
934: FND_MESSAGE.SET_TOKEN('PKG_NAME','EDR_RULE_TEMP');
935: FND_MESSAGE.SET_TOKEN('PROCEDURE_NAME','SYNC_RULE_TABLE');
936: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
937: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED,
938: 'edr.plsql.EDR_RULE_TEMP.SYNC_RULE_TABLE',

Line 938: 'edr.plsql.EDR_RULE_TEMP.SYNC_RULE_TABLE',

934: FND_MESSAGE.SET_TOKEN('PKG_NAME','EDR_RULE_TEMP');
935: FND_MESSAGE.SET_TOKEN('PROCEDURE_NAME','SYNC_RULE_TABLE');
936: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
937: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED,
938: 'edr.plsql.EDR_RULE_TEMP.SYNC_RULE_TABLE',
939: FALSE
940: );
941: END IF;
942: END SYNC_RULE_TABLE;

Line 968: END EDR_RULE_TEMP;

964: END IF;
965:
966: END CHECK_AND_SYNC_RULE_TABLE;
967:
968: END EDR_RULE_TEMP;