16: begin
17: select ACA.APPLICATION_ID
18: into X_APPLICATION_ID
19: from AME_CALLING_APPS ACA,
20: FND_APPLICATION_VL FAV
21: where FAV.APPLICATION_SHORT_NAME = X_APPLICATION_SHORT_NAME
22: and FAV.APPLICATION_ID = ACA.FND_APPLICATION_ID
23: and ((ACA.TRANSACTION_TYPE_ID is null and X_TRANSACTION_TYPE_ID is null) or
24: ACA.TRANSACTION_TYPE_ID = X_TRANSACTION_TYPE_ID)
503: into X_CURRENT_OWNER,
504: X_CURRENT_LAST_UPDATE_DATE
505: from AME_CONFIG_VARS ACV,
506: AME_CALLING_APPS ACA,
507: FND_APPLICATION_VL FAV
508: where FAV.APPLICATION_SHORT_NAME = X_APPLICATION_SHORT_NAME
509: and FAV.APPLICATION_ID = ACA.FND_APPLICATION_ID
510: and ((ACA.TRANSACTION_TYPE_ID is null and X_TRANSACTION_TYPE_ID is null) or
511: ACA.TRANSACTION_TYPE_ID = X_TRANSACTION_TYPE_ID)
564: begin
565: select ACA.APPLICATION_NAME
566: into X_APPLICATION_NAME
567: from AME_CALLING_APPS ACA,
568: FND_APPLICATION_VL FAV
569: where FAV.APPLICATION_SHORT_NAME = X_APPLICATION_SHORT_NAME
570: and FAV.APPLICATION_ID = ACA.FND_APPLICATION_ID
571: and ((X_TRANSACTION_TYPE_ID is null and ACA.TRANSACTION_TYPE_ID is null) or
572: X_TRANSACTION_TYPE_ID = ACA.TRANSACTION_TYPE_ID)