APPS.AME_CALLING_APPS_API dependencies on DUAL

Line 209: from sys.dual;

205: X_START_DATE,
206: AME_SEED_UTILITY.GET_DEFAULT_END_DATE,
207: X_LINE_ITEM_ID_QUERY,
208: X_OBJECT_VERSION_NUMBER
209: from sys.dual;
210: end INSERT_ROW;
211: --
212: procedure FORCE_UPDATE_ROW (
213: X_ROWID in VARCHAR2,

Line 556: from sys.dual

552: null,
553: groupsRec.start_date,
554: groupsRec.end_date,
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

Line 611: ame_util.dualChainsAuthorityTypeName, 9,

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,

Line 628: from sys.dual

624: null,
625: actionRec.start_date,
626: actionRec.end_date,
627: 1
628: from sys.dual
629: where not exists
630: (select null
631: from ame_action_type_config
632: where application_id = X_APPLICATION_ID

Line 677: from sys.dual

673: AME_SEED_UTILITY.GET_DEFAULT_END_DATE,
674: ame_util.booleanTrue,
675: null,
676: 1
677: from sys.dual
678: where not exists
679: (select null
680: from ame_attribute_usages
681: where application_id = X_APPLICATION_ID

Line 724: from sys.dual

720: AME_SEED_UTILITY.GET_DEFAULT_END_DATE,
721: ame_util.booleanTrue,
722: null,
723: 1
724: from sys.dual
725: where not exists
726: (select null
727: from ame_attribute_usages
728: where application_id = X_APPLICATION_ID

Line 773: from sys.dual

769: AME_SEED_UTILITY.GET_DEFAULT_END_DATE,
770: ame_util.booleanTrue,
771: null,
772: 1
773: from sys.dual
774: where not exists
775: (select null
776: from ame_attribute_usages
777: where application_id = X_APPLICATION_ID

Line 864: from dual;

860: (X_APPLICATION_ID is null) then
861: -- derive a new application id
862: select ame_applications_s.nextval
863: into X_APPLICATION_ID
864: from dual;
865: INSERT_ROW (
866: X_FND_APPLICATION_ID,
867: X_BASE_APP_NAME,
868: X_TRANSACTION_TYPE_ID,

Line 892: 'select :transactionId from dual',

888: -- insert new row for ame_item_class_usages header
889: INSERT_USAGE_ROW (
890: X_APPLICATION_ID,
891: 1,
892: 'select :transactionId from dual',
893: 1,
894: 'S',
895: 'S',
896: X_CREATED_BY,