DBA Data[Home] [Help]

APPS.AME_ACTIONS_API dependencies on AME_UTIL

Line 469: ame_util.runtimeException('ame_actions_usages_api',

465: end if;
466: end;
467: exception
468: when others then
469: ame_util.runtimeException('ame_actions_usages_api',
470: 'load_row',
471: sqlcode,
472: sqlerrm);
473: raise;

Line 509: if X_ACTION_TYPE_NAME in (ame_util.groupChainApprovalTypeName

505: return;
506: end if;
507: begin
508: X_TEMP_PARAMETER := X_PARAMETER;
509: if X_ACTION_TYPE_NAME in (ame_util.groupChainApprovalTypeName
510: ,ame_util.preApprovalTypeName
511: ,ame_util.postApprovalTypeName) then
512: begin
513: select approval_group_id

Line 510: ,ame_util.preApprovalTypeName

506: end if;
507: begin
508: X_TEMP_PARAMETER := X_PARAMETER;
509: if X_ACTION_TYPE_NAME in (ame_util.groupChainApprovalTypeName
510: ,ame_util.preApprovalTypeName
511: ,ame_util.postApprovalTypeName) then
512: begin
513: select approval_group_id
514: into X_APPROVAL_GROUP_ID

Line 511: ,ame_util.postApprovalTypeName) then

507: begin
508: X_TEMP_PARAMETER := X_PARAMETER;
509: if X_ACTION_TYPE_NAME in (ame_util.groupChainApprovalTypeName
510: ,ame_util.preApprovalTypeName
511: ,ame_util.postApprovalTypeName) then
512: begin
513: select approval_group_id
514: into X_APPROVAL_GROUP_ID
515: from ame_approval_groups

Line 543: and (X_ACTION_TYPE_NAME <> ame_util.finalAuthorityTypeName

539: and sysdate between AAT.START_DATE and nvl(AAT.END_DATE - (1/86400),sysdate)
540: and sysdate between ACT.START_DATE and nvl(ACT.END_DATE - (1/86400),sysdate)
541: and ACTTL.ACTION_ID = ACT.ACTION_ID
542: and ACTTL.LANGUAGE = userenv('LANG')
543: and (X_ACTION_TYPE_NAME <> ame_util.finalAuthorityTypeName
544: or (X_ACTION_TYPE_NAME = ame_util.finalAuthorityTypeName and
545: ACT.ACTION_ID = (
546: select MIN(ACTION_ID)
547: from ame_actions aac,ame_action_types aaty

Line 544: or (X_ACTION_TYPE_NAME = ame_util.finalAuthorityTypeName and

540: and sysdate between ACT.START_DATE and nvl(ACT.END_DATE - (1/86400),sysdate)
541: and ACTTL.ACTION_ID = ACT.ACTION_ID
542: and ACTTL.LANGUAGE = userenv('LANG')
543: and (X_ACTION_TYPE_NAME <> ame_util.finalAuthorityTypeName
544: or (X_ACTION_TYPE_NAME = ame_util.finalAuthorityTypeName and
545: ACT.ACTION_ID = (
546: select MIN(ACTION_ID)
547: from ame_actions aac,ame_action_types aaty
548: where aac.action_type_id = aaty.action_type_id