APPS.AME_CALLING_APPS_API dependencies on AME_ATTRIBUTE_USAGES

Line 644: insert into AME_ATTRIBUTE_USAGES

640: -- insert an attribute usage for rejectionResponse
641: open getRejectionAttributeId;
642: fetch getRejectionAttributeId into X_REJECTION_RESPONSE_ID;
643: if (getRejectionAttributeId%found) then
644: insert into AME_ATTRIBUTE_USAGES
645: (ATTRIBUTE_ID,
646: APPLICATION_ID,
647: QUERY_STRING,
648: USE_COUNT,

Line 680: from ame_attribute_usages

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
682: and attribute_id = X_REJECTION_RESPONSE_ID
683: and (sysdate between start_date
684: and nvl(end_date - (1/86400),sysdate)));

Line 691: insert into AME_ATTRIBUTE_USAGES

687: -- insert an attribute usage for useWorkflow
688: open getUseWorkflowId;
689: fetch getUseWorkflowId into X_USE_WORKFLOW_ID;
690: if (getUseWorkflowId%found) then
691: insert into AME_ATTRIBUTE_USAGES
692: (ATTRIBUTE_ID,
693: APPLICATION_ID,
694: QUERY_STRING,
695: USE_COUNT,

Line 727: from ame_attribute_usages

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
729: and attribute_id = X_USE_WORKFLOW_ID
730: and (sysdate between start_date
731: and nvl(end_date - (1/86400),sysdate)));

Line 740: insert into AME_ATTRIBUTE_USAGES

736: --
737: open getRepeatSubAttributeId;
738: fetch getRepeatSubAttributeId into X_REPEAT_SUBSTITUTIONS_ID;
739: if (getRepeatSubAttributeId%found) then
740: insert into AME_ATTRIBUTE_USAGES
741: (ATTRIBUTE_ID,
742: APPLICATION_ID,
743: QUERY_STRING,
744: USE_COUNT,

Line 776: from ame_attribute_usages

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
778: and attribute_id = X_REPEAT_SUBSTITUTIONS_ID
779: and (sysdate between start_date
780: and nvl(end_date - (1/86400),sysdate)));