APPS.AME_ACTION_PKG dependencies on AME_APPROVER_TYPE_USAGES

Line 2746: ame_approver_type_usages.approver_type_id,

2742: allowedApproverTypeIdsOut out nocopy ame_util.stringList,
2743: allowedApproverTypeNamesOut out nocopy ame_util.stringList) as
2744: cursor getApproverTypesCursor(actionTypeIdIn in integer) is
2745: select
2746: ame_approver_type_usages.approver_type_id,
2747: ame_approver_type_pkg.getOrigSystemDisplayName(orig_system) approver_name
2748: from ame_approver_types,
2749: ame_approver_type_usages
2750: where

Line 2749: ame_approver_type_usages

2745: select
2746: ame_approver_type_usages.approver_type_id,
2747: ame_approver_type_pkg.getOrigSystemDisplayName(orig_system) approver_name
2748: from ame_approver_types,
2749: ame_approver_type_usages
2750: where
2751: ame_approver_types.approver_type_id = ame_approver_type_usages.approver_type_id and
2752: ame_approver_type_usages.action_type_id = actionTypeIdIn and
2753: sysdate between

Line 2751: ame_approver_types.approver_type_id = ame_approver_type_usages.approver_type_id and

2747: ame_approver_type_pkg.getOrigSystemDisplayName(orig_system) approver_name
2748: from ame_approver_types,
2749: ame_approver_type_usages
2750: where
2751: ame_approver_types.approver_type_id = ame_approver_type_usages.approver_type_id and
2752: ame_approver_type_usages.action_type_id = actionTypeIdIn and
2753: sysdate between
2754: ame_approver_types.start_date and
2755: nvl(ame_approver_types.end_date - ame_util.oneSecond, sysdate) and

Line 2752: ame_approver_type_usages.action_type_id = actionTypeIdIn and

2748: from ame_approver_types,
2749: ame_approver_type_usages
2750: where
2751: ame_approver_types.approver_type_id = ame_approver_type_usages.approver_type_id and
2752: ame_approver_type_usages.action_type_id = actionTypeIdIn and
2753: sysdate between
2754: ame_approver_types.start_date and
2755: nvl(ame_approver_types.end_date - ame_util.oneSecond, sysdate) and
2756: sysdate between

Line 2757: ame_approver_type_usages.start_date and

2753: sysdate between
2754: ame_approver_types.start_date and
2755: nvl(ame_approver_types.end_date - ame_util.oneSecond, sysdate) and
2756: sysdate between
2757: ame_approver_type_usages.start_date and
2758: nvl(ame_approver_type_usages.end_date - ame_util.oneSecond, sysdate)
2759: order by approver_name;
2760: begin
2761: open getApproverTypesCursor(actionTypeIdIn => actionTypeIdIn);

Line 2758: nvl(ame_approver_type_usages.end_date - ame_util.oneSecond, sysdate)

2754: ame_approver_types.start_date and
2755: nvl(ame_approver_types.end_date - ame_util.oneSecond, sysdate) and
2756: sysdate between
2757: ame_approver_type_usages.start_date and
2758: nvl(ame_approver_type_usages.end_date - ame_util.oneSecond, sysdate)
2759: order by approver_name;
2760: begin
2761: open getApproverTypesCursor(actionTypeIdIn => actionTypeIdIn);
2762: fetch getApproverTypesCursor bulk collect

Line 2826: from ame_approver_type_usages

2822: ame_action_type_usages.rule_type = ruleTypeIn) and
2823: (allowAllApproverTypesIn = ame_util.yes or
2824: ame_action_types.action_type_id in (
2825: select distinct action_type_id
2826: from ame_approver_type_usages
2827: where
2828: (approver_type_id = ame_util.anyApproverType or
2829: approver_type_id in
2830: (select approver_type_id

Line 2954: from ame_approver_type_usages

2950: ame_util.substitutionRuleType))) and
2951: (allowAllApproverTypesIn = ame_util.yes or
2952: ame_action_types.action_type_id in (
2953: select distinct action_type_id
2954: from ame_approver_type_usages
2955: where
2956: (approver_type_id = ame_util.anyApproverType or
2957: approver_type_id in
2958: (select approver_type_id

Line 3431: update ame_approver_type_usages

3427: where
3428: action_type_id = actionTypeIdIn and
3429: processingDate between start_date and
3430: nvl(end_date - ame_util.oneSecond, processingDate);
3431: update ame_approver_type_usages
3432: set
3433: last_updated_by = currentUserId,
3434: last_update_date = processingDate,
3435: last_update_login = currentUserId,