APPS.AME_RULE_API dependencies on AME_CALLING_APPS

Line 118: applicationName ame_calling_apps.application_name%type;

114: l_swi_package_name varchar2(30) := 'AME_RULE_SWI';
115: l_count number;
116: actionTypeIds ame_util.idList;
117: l_rule_type ame_rules.rule_type%type;
118: applicationName ame_calling_apps.application_name%type;
119: --+
120: cursor getApplicationName(applicationIdIn in integer)is
121: select application_name
122: from ame_calling_apps

Line 122: from ame_calling_apps

118: applicationName ame_calling_apps.application_name%type;
119: --+
120: cursor getApplicationName(applicationIdIn in integer)is
121: select application_name
122: from ame_calling_apps
123: where application_id = applicationIdIn
124: and sysdate between start_date and nvl(end_date - (1/86400), sysdate);
125: --+
126: cursor getActionTypeCursor is

Line 1473: from ame_calling_apps

1469: and nvl(end_date - ame_util.oneSecond,l_effective_date )
1470: and application_id = p_application_id;
1471: cursor getApplicationName(applicationIdIn in integer)is
1472: select application_name
1473: from ame_calling_apps
1474: where application_id = applicationIdIn
1475: and sysdate between start_date and nvl(end_date - (1/86400), sysdate);
1476: cursor getApplicationIds(p_rule_id in integer) is
1477: select distinct item_id

Line 1504: applicationName ame_calling_apps.application_name%type;

1500: l_cnu_end_date date;
1501: l_use_count number := 0;
1502: actionIdList ame_util.idList;
1503: conditionIdList ame_util.idList;
1504: applicationName ame_calling_apps.application_name%type;
1505: attributeName ame_attributes.name%type;
1506: appIdList ame_util.idList;
1507: lm_count number;
1508: begin

Line 3012: from ame_calling_apps

3008: l_attribute_id number;
3009: --+
3010: cursor getApplicationName(applicationIdIn in integer)is
3011: select application_name
3012: from ame_calling_apps
3013: where application_id = applicationIdIn
3014: and sysdate between start_date and nvl(end_date - (1/86400), sysdate);
3015: --+
3016: cursor getConditionCount(p_condition_type in varchar2

Line 3098: applicationName ame_calling_apps.application_name%type;

3094: l_acu_end_date date;
3095: l_use_count number := 0;
3096: actionIdList ame_util.idList;
3097: conditionIdList ame_util.idList;
3098: applicationName ame_calling_apps.application_name%type;
3099: attributeName ame_attributes.name%type;
3100: l_swi_call boolean;
3101: begin
3102: hr_utility.set_location('Entering:'|| l_proc, 10);