DBA Data[Home] [Help]

APPS.AME_CALLING_APPS_API dependencies on AME_APPROVAL_GROUP_CONFIG

Line 462: -- and ame_approval_group_config tables and

458: -- this logic is also represented in amem0031.sql and amem0032.sql.
459: -- it runs within this api when a transaction type is being applied
460: -- after the AME mother patch has been run.
461: -- it inserts rows into the ame_action_type_config
462: -- and ame_approval_group_config tables and
463: -- attribute usages for USE_WORKFLOW, REJECTION_RESPONSE and
464: -- REPEAT_SUBSTITUTION attributes where they do not exist.
465: --
466: procedure RUN_CONFIG_USAGES_ROWS(X_APPLICATION_ID in NUMBER,

Line 531: insert into ame_approval_group_config

527: end if;
528: if X_AME_INSTALLATION_LEVEL is not null and to_number(X_AME_INSTALLATION_LEVEL) < 2 then
529: for groupsRec in getApprovalGroup loop
530: groupOrderNumber := groupOrderNumber + 1;
531: insert into ame_approval_group_config
532: (application_id,
533: approval_group_id,
534: voting_regime,
535: order_number,

Line 559: from ame_approval_group_config

555: 1
556: from sys.dual
557: where not exists
558: (select null
559: from ame_approval_group_config
560: where application_id = X_APPLICATION_ID
561: and approval_group_id = groupsRec.approval_group_id
562: and ((sysdate between start_date
563: and nvl(end_date - (1/86400),sysdate))