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)
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)
25: and sysdate between ACA.START_DATE and nvl(ACA.END_DATE - (1/86400),sysdate);
26: exception
319: ,X_LAST_UPDATE_DATE in varchar2
320: ,X_CUSTOM_MODE in varchar2
321: ) as
322: L_VARIABLE_NAME AME_CONFIG_VARS.VARIABLE_NAME%TYPE;
323: L_APPLICATION_SHORT_NAME FND_APPLICATION.APPLICATION_SHORT_NAME%TYPE;
324: L_TRANSACTION_TYPE_ID AME_CALLING_APPS.TRANSACTION_TYPE_ID%TYPE;
325: L_APPLICATION_ID number;
326: L_VARIABLE_VALUE AME_CONFIG_VARS.VARIABLE_VALUE%TYPE;
327: L_USER_CONFIG_VAR_NAME AME_CONFIG_VARS_TL.USER_CONFIG_VAR_NAME%TYPE;
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)
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)
512: and ACV.APPLICATION_ID = ACA.APPLICATION_ID
513: and ACV.VARIABLE_NAME = X_VARIABLE_NAME
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)
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)
573: and sysdate between ACA.START_DATE and nvl(ACA.END_DATE - (1/86400),sysdate);
574: exception