APPS.AME_UTIL dependencies on AME_CALLING_APPS

Line 2882: from ame_calling_apps

2878: cursor callingAppCursor is
2879: select
2880: application_id,
2881: application_name
2882: from ame_calling_apps
2883: where
2884: sysdate between start_date and
2885: nvl(end_date - ame_util.oneSecond, sysdate)
2886: order by application_name;

Line 2890: ame_calling_apps.application_name

2886: order by application_name;
2887: cursor securedAttributesCursor(userId in integer) is
2888: select
2889: ak_web_user_sec_attr_values.number_value,
2890: ame_calling_apps.application_name
2891: from ak_web_user_sec_attr_values,
2892: ame_calling_apps
2893: where ak_web_user_sec_attr_values.number_value = ame_calling_apps.application_id and
2894: web_user_id = userId and

Line 2892: ame_calling_apps

2888: select
2889: ak_web_user_sec_attr_values.number_value,
2890: ame_calling_apps.application_name
2891: from ak_web_user_sec_attr_values,
2892: ame_calling_apps
2893: where ak_web_user_sec_attr_values.number_value = ame_calling_apps.application_id and
2894: web_user_id = userId and
2895: sysdate between ame_calling_apps.start_date and
2896: nvl(ame_calling_apps.end_date - ame_util.oneSecond, sysdate)

Line 2893: where ak_web_user_sec_attr_values.number_value = ame_calling_apps.application_id and

2889: ak_web_user_sec_attr_values.number_value,
2890: ame_calling_apps.application_name
2891: from ak_web_user_sec_attr_values,
2892: ame_calling_apps
2893: where ak_web_user_sec_attr_values.number_value = ame_calling_apps.application_id and
2894: web_user_id = userId and
2895: sysdate between ame_calling_apps.start_date and
2896: nvl(ame_calling_apps.end_date - ame_util.oneSecond, sysdate)
2897: order by application_name;

Line 2895: sysdate between ame_calling_apps.start_date and

2891: from ak_web_user_sec_attr_values,
2892: ame_calling_apps
2893: where ak_web_user_sec_attr_values.number_value = ame_calling_apps.application_id and
2894: web_user_id = userId and
2895: sysdate between ame_calling_apps.start_date and
2896: nvl(ame_calling_apps.end_date - ame_util.oneSecond, sysdate)
2897: order by application_name;
2898: tempIndex integer;
2899: badRespException exception;

Line 2896: nvl(ame_calling_apps.end_date - ame_util.oneSecond, sysdate)

2892: ame_calling_apps
2893: where ak_web_user_sec_attr_values.number_value = ame_calling_apps.application_id and
2894: web_user_id = userId and
2895: sysdate between ame_calling_apps.start_date and
2896: nvl(ame_calling_apps.end_date - ame_util.oneSecond, sysdate)
2897: order by application_name;
2898: tempIndex integer;
2899: badRespException exception;
2900: noRespoTransException exception;

Line 2990: from ame_calling_apps

2986: cursor callingAppCursor is
2987: select
2988: application_id,
2989: application_name
2990: from ame_calling_apps
2991: where
2992: sysdate between start_date and
2993: nvl(end_date - ame_util.oneSecond, sysdate)
2994: order by application_name;

Line 3018: from ame_calling_apps

3014: cursor callingAppCursor is
3015: select
3016: application_id,
3017: application_name
3018: from ame_calling_apps
3019: where
3020: sysdate between start_date and
3021: nvl(end_date - ame_util.oneSecond, sysdate)
3022: order by application_name;

Line 3049: from ame_calling_apps

3045: cursor callingAppCursor(applicationIdIn in integer) is
3046: select
3047: application_id,
3048: application_name
3049: from ame_calling_apps
3050: where
3051: application_id <> applicationIdIn and
3052: sysdate between start_date and
3053: nvl(end_date - ame_util.oneSecond, sysdate)

Line 3154: from ame_calling_apps

3150: transaction_type_id
3151: into
3152: fndApplicationIdOut,
3153: transactionTypeIdOut
3154: from ame_calling_apps
3155: where
3156: application_id = applicationIdIn and
3157: /* Don't use tempEffectiveRuleDate here. */
3158: sysdate between

Line 3913: transactionType ame_calling_apps.application_name%type;

3909: comma1Location integer;
3910: comma2Location integer;
3911: errorCode integer;
3912: errorMessage ame_util.longestStringType;
3913: transactionType ame_calling_apps.application_name%type;
3914: begin
3915: /*
3916: Static currency usages must be null or look like this: '5000.00,USD,Corporate'
3917: or '666,66,USD,Daily'. The amount can be formatted per the currency's requirements;

Line 3966: from ame_calling_apps

3962: end parseStaticCurAttValue;
3963: procedure purgeOldTempData as
3964: cursor transactionTypeCursor is
3965: select application_id
3966: from ame_calling_apps
3967: where
3968: sysdate between start_date and
3969: nvl(end_date - ame_util.oneSecond, sysdate);
3970: cursor attributeUsageCursor (applicationIdIn integer) is