494: -- REJECTION_RESPONSE
495: cursor getRejectionAttributeId is
496: select attribute_id
497: from ame_attributes
498: where name = ame_util.rejectionResponseAttribute
499: and (sysdate between start_date
500: and nvl(end_date - (1/86400),sysdate));
501: -- USE_WORKFLOW
502: cursor getUseWorkflowId is
501: -- USE_WORKFLOW
502: cursor getUseWorkflowId is
503: select attribute_id
504: from ame_attributes
505: where name = ame_util.useWorkflowAttribute
506: and (sysdate between start_date
507: and nvl(end_date - (1/86400),sysdate));
508: --REPEAT_SUBSTITUTIONS
509: cursor getRepeatSubAttributeId is
542: end_date,
543: object_version_number)
544: select X_APPLICATION_ID,
545: groupsRec.approval_group_id,
546: ame_util.orderNumberVoting,
547: groupOrderNumber,
548: x_created_by,
549: sysdate,
550: x_created_by,
569: select count(*)
570: into authorityRuleTypeCount
571: from ame_action_type_usages
572: where action_type_id = actionRec.action_type_id
573: and rule_type = ame_util.authorityRuleType;
574: if authorityRuleTypeCount > 0 then
575: votingRegimeValue := ame_util.serializedVoting;
576: else
577: votingRegimeValue := null;
571: from ame_action_type_usages
572: where action_type_id = actionRec.action_type_id
573: and rule_type = ame_util.authorityRuleType;
574: if authorityRuleTypeCount > 0 then
575: votingRegimeValue := ame_util.serializedVoting;
576: else
577: votingRegimeValue := null;
578: end if;
579: if actionRec.created_by <> ame_util.seededDataCreatedById then
575: votingRegimeValue := ame_util.serializedVoting;
576: else
577: votingRegimeValue := null;
578: end if;
579: if actionRec.created_by <> ame_util.seededDataCreatedById then
580: customOrderNumber := customOrderNumber + 1;
581: end if;
582: insert into ame_action_type_config
583: (application_id,
597: X_APPLICATION_ID,
598: actionRec.action_type_id,
599: votingRegimeValue,
600: decode(actionRec.name,
601: ame_util.preApprovalTypeName, 1,
602: ame_util.dynamicPreApprover, 2,
603: ame_util.absoluteJobLevelTypeName, 1,
604: ame_util.relativeJobLevelTypeName, 2,
605: ame_util.supervisoryLevelTypeName, 3,
598: actionRec.action_type_id,
599: votingRegimeValue,
600: decode(actionRec.name,
601: ame_util.preApprovalTypeName, 1,
602: ame_util.dynamicPreApprover, 2,
603: ame_util.absoluteJobLevelTypeName, 1,
604: ame_util.relativeJobLevelTypeName, 2,
605: ame_util.supervisoryLevelTypeName, 3,
606: ame_util.positionTypeName, 4,
599: votingRegimeValue,
600: decode(actionRec.name,
601: ame_util.preApprovalTypeName, 1,
602: ame_util.dynamicPreApprover, 2,
603: ame_util.absoluteJobLevelTypeName, 1,
604: ame_util.relativeJobLevelTypeName, 2,
605: ame_util.supervisoryLevelTypeName, 3,
606: ame_util.positionTypeName, 4,
607: ame_util.positionLevelTypeName, 5,
600: decode(actionRec.name,
601: ame_util.preApprovalTypeName, 1,
602: ame_util.dynamicPreApprover, 2,
603: ame_util.absoluteJobLevelTypeName, 1,
604: ame_util.relativeJobLevelTypeName, 2,
605: ame_util.supervisoryLevelTypeName, 3,
606: ame_util.positionTypeName, 4,
607: ame_util.positionLevelTypeName, 5,
608: ame_util.managerFinalApproverTypeName, 6,
601: ame_util.preApprovalTypeName, 1,
602: ame_util.dynamicPreApprover, 2,
603: ame_util.absoluteJobLevelTypeName, 1,
604: ame_util.relativeJobLevelTypeName, 2,
605: ame_util.supervisoryLevelTypeName, 3,
606: ame_util.positionTypeName, 4,
607: ame_util.positionLevelTypeName, 5,
608: ame_util.managerFinalApproverTypeName, 6,
609: ame_util.finalApproverOnlyTypeName, 7,
602: ame_util.dynamicPreApprover, 2,
603: ame_util.absoluteJobLevelTypeName, 1,
604: ame_util.relativeJobLevelTypeName, 2,
605: ame_util.supervisoryLevelTypeName, 3,
606: ame_util.positionTypeName, 4,
607: ame_util.positionLevelTypeName, 5,
608: ame_util.managerFinalApproverTypeName, 6,
609: ame_util.finalApproverOnlyTypeName, 7,
610: ame_util.lineItemJobLevelTypeName, 8,
603: ame_util.absoluteJobLevelTypeName, 1,
604: ame_util.relativeJobLevelTypeName, 2,
605: ame_util.supervisoryLevelTypeName, 3,
606: ame_util.positionTypeName, 4,
607: ame_util.positionLevelTypeName, 5,
608: ame_util.managerFinalApproverTypeName, 6,
609: ame_util.finalApproverOnlyTypeName, 7,
610: ame_util.lineItemJobLevelTypeName, 8,
611: ame_util.dualChainsAuthorityTypeName, 9,
604: ame_util.relativeJobLevelTypeName, 2,
605: ame_util.supervisoryLevelTypeName, 3,
606: ame_util.positionTypeName, 4,
607: ame_util.positionLevelTypeName, 5,
608: ame_util.managerFinalApproverTypeName, 6,
609: ame_util.finalApproverOnlyTypeName, 7,
610: ame_util.lineItemJobLevelTypeName, 8,
611: ame_util.dualChainsAuthorityTypeName, 9,
612: ame_util.groupChainApprovalTypeName, 10,
605: ame_util.supervisoryLevelTypeName, 3,
606: ame_util.positionTypeName, 4,
607: ame_util.positionLevelTypeName, 5,
608: ame_util.managerFinalApproverTypeName, 6,
609: ame_util.finalApproverOnlyTypeName, 7,
610: ame_util.lineItemJobLevelTypeName, 8,
611: ame_util.dualChainsAuthorityTypeName, 9,
612: ame_util.groupChainApprovalTypeName, 10,
613: ame_util.nonFinalAuthority, 1,
606: ame_util.positionTypeName, 4,
607: ame_util.positionLevelTypeName, 5,
608: ame_util.managerFinalApproverTypeName, 6,
609: ame_util.finalApproverOnlyTypeName, 7,
610: ame_util.lineItemJobLevelTypeName, 8,
611: ame_util.dualChainsAuthorityTypeName, 9,
612: ame_util.groupChainApprovalTypeName, 10,
613: ame_util.nonFinalAuthority, 1,
614: ame_util.finalAuthorityTypeName, 2,
607: ame_util.positionLevelTypeName, 5,
608: ame_util.managerFinalApproverTypeName, 6,
609: ame_util.finalApproverOnlyTypeName, 7,
610: ame_util.lineItemJobLevelTypeName, 8,
611: ame_util.dualChainsAuthorityTypeName, 9,
612: ame_util.groupChainApprovalTypeName, 10,
613: ame_util.nonFinalAuthority, 1,
614: ame_util.finalAuthorityTypeName, 2,
615: ame_util.substitutionTypeName, 1,
608: ame_util.managerFinalApproverTypeName, 6,
609: ame_util.finalApproverOnlyTypeName, 7,
610: ame_util.lineItemJobLevelTypeName, 8,
611: ame_util.dualChainsAuthorityTypeName, 9,
612: ame_util.groupChainApprovalTypeName, 10,
613: ame_util.nonFinalAuthority, 1,
614: ame_util.finalAuthorityTypeName, 2,
615: ame_util.substitutionTypeName, 1,
616: ame_util.postApprovalTypeName, 1,
609: ame_util.finalApproverOnlyTypeName, 7,
610: ame_util.lineItemJobLevelTypeName, 8,
611: ame_util.dualChainsAuthorityTypeName, 9,
612: ame_util.groupChainApprovalTypeName, 10,
613: ame_util.nonFinalAuthority, 1,
614: ame_util.finalAuthorityTypeName, 2,
615: ame_util.substitutionTypeName, 1,
616: ame_util.postApprovalTypeName, 1,
617: ame_util.dynamicPostApprover, 2,
610: ame_util.lineItemJobLevelTypeName, 8,
611: ame_util.dualChainsAuthorityTypeName, 9,
612: ame_util.groupChainApprovalTypeName, 10,
613: ame_util.nonFinalAuthority, 1,
614: ame_util.finalAuthorityTypeName, 2,
615: ame_util.substitutionTypeName, 1,
616: ame_util.postApprovalTypeName, 1,
617: ame_util.dynamicPostApprover, 2,
618: customOrderNumber),
611: ame_util.dualChainsAuthorityTypeName, 9,
612: ame_util.groupChainApprovalTypeName, 10,
613: ame_util.nonFinalAuthority, 1,
614: ame_util.finalAuthorityTypeName, 2,
615: ame_util.substitutionTypeName, 1,
616: ame_util.postApprovalTypeName, 1,
617: ame_util.dynamicPostApprover, 2,
618: customOrderNumber),
619: ame_util.serialChainsMode,
612: ame_util.groupChainApprovalTypeName, 10,
613: ame_util.nonFinalAuthority, 1,
614: ame_util.finalAuthorityTypeName, 2,
615: ame_util.substitutionTypeName, 1,
616: ame_util.postApprovalTypeName, 1,
617: ame_util.dynamicPostApprover, 2,
618: customOrderNumber),
619: ame_util.serialChainsMode,
620: actionRec.created_by,
613: ame_util.nonFinalAuthority, 1,
614: ame_util.finalAuthorityTypeName, 2,
615: ame_util.substitutionTypeName, 1,
616: ame_util.postApprovalTypeName, 1,
617: ame_util.dynamicPostApprover, 2,
618: customOrderNumber),
619: ame_util.serialChainsMode,
620: actionRec.created_by,
621: sysdate,
615: ame_util.substitutionTypeName, 1,
616: ame_util.postApprovalTypeName, 1,
617: ame_util.dynamicPostApprover, 2,
618: customOrderNumber),
619: ame_util.serialChainsMode,
620: actionRec.created_by,
621: sysdate,
622: actionRec.last_updated_by,
623: sysdate,
660: )
661: select
662: X_REJECTION_RESPONSE_ID,
663: X_APPLICATION_ID,
664: ame_util.stopAllItems,
665: 0,
666: ame_util.booleanTrue,
667: x_created_by,
668: to_date(X_LAST_UPDATE_DATE,'YYYY/MM/DD HH24:MI:SS'),
662: X_REJECTION_RESPONSE_ID,
663: X_APPLICATION_ID,
664: ame_util.stopAllItems,
665: 0,
666: ame_util.booleanTrue,
667: x_created_by,
668: to_date(X_LAST_UPDATE_DATE,'YYYY/MM/DD HH24:MI:SS'),
669: x_created_by,
670: to_date(X_LAST_UPDATE_DATE,'YYYY/MM/DD HH24:MI:SS'),
670: to_date(X_LAST_UPDATE_DATE,'YYYY/MM/DD HH24:MI:SS'),
671: 0,
672: to_date(X_LAST_UPDATE_DATE,'YYYY/MM/DD HH24:MI:SS'),
673: AME_SEED_UTILITY.GET_DEFAULT_END_DATE,
674: ame_util.booleanTrue,
675: null,
676: 1
677: from sys.dual
678: where not exists
707: )
708: select
709: X_USE_WORKFLOW_ID,
710: X_APPLICATION_ID,
711: ame_util.booleanAttributeTrue,
712: 0,
713: ame_util.booleanTrue,
714: x_created_by,
715: to_date(X_LAST_UPDATE_DATE,'YYYY/MM/DD HH24:MI:SS'),
709: X_USE_WORKFLOW_ID,
710: X_APPLICATION_ID,
711: ame_util.booleanAttributeTrue,
712: 0,
713: ame_util.booleanTrue,
714: x_created_by,
715: to_date(X_LAST_UPDATE_DATE,'YYYY/MM/DD HH24:MI:SS'),
716: x_created_by,
717: to_date(X_LAST_UPDATE_DATE,'YYYY/MM/DD HH24:MI:SS'),
717: to_date(X_LAST_UPDATE_DATE,'YYYY/MM/DD HH24:MI:SS'),
718: 0,
719: to_date(X_LAST_UPDATE_DATE,'YYYY/MM/DD HH24:MI:SS'),
720: AME_SEED_UTILITY.GET_DEFAULT_END_DATE,
721: ame_util.booleanTrue,
722: null,
723: 1
724: from sys.dual
725: where not exists
756: )
757: select
758: X_REPEAT_SUBSTITUTIONS_ID,
759: X_APPLICATION_ID,
760: ame_util.booleanAttributeFalse,
761: 0,
762: ame_util.booleanTrue,
763: x_created_by,
764: to_date(X_LAST_UPDATE_DATE,'YYYY/MM/DD HH24:MI:SS'),
758: X_REPEAT_SUBSTITUTIONS_ID,
759: X_APPLICATION_ID,
760: ame_util.booleanAttributeFalse,
761: 0,
762: ame_util.booleanTrue,
763: x_created_by,
764: to_date(X_LAST_UPDATE_DATE,'YYYY/MM/DD HH24:MI:SS'),
765: x_created_by,
766: to_date(X_LAST_UPDATE_DATE,'YYYY/MM/DD HH24:MI:SS'),
766: to_date(X_LAST_UPDATE_DATE,'YYYY/MM/DD HH24:MI:SS'),
767: 0,
768: to_date(X_LAST_UPDATE_DATE,'YYYY/MM/DD HH24:MI:SS'),
769: AME_SEED_UTILITY.GET_DEFAULT_END_DATE,
770: ame_util.booleanTrue,
771: null,
772: 1
773: from sys.dual
774: where not exists
1034: end if;
1035: end;
1036: exception
1037: when others then
1038: ame_util.runtimeException('ame_calling_apps_api',
1039: 'load_row',
1040: sqlcode,
1041: sqlerrm);
1042: raise;