DBA Data[Home] [Help]

APPS.AME_CONFIG_VARS_API dependencies on FND_APPLICATION

Line 20: FND_APPLICATION_VL FAV

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)

Line 22: and FAV.APPLICATION_ID = ACA.FND_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)
25: and sysdate between ACA.START_DATE and nvl(ACA.END_DATE - (1/86400),sysdate);
26: exception

Line 323: L_APPLICATION_SHORT_NAME FND_APPLICATION.APPLICATION_SHORT_NAME%TYPE;

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;

Line 507: FND_APPLICATION_VL FAV

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)

Line 509: and FAV.APPLICATION_ID = ACA.FND_APPLICATION_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

Line 568: FND_APPLICATION_VL FAV

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)

Line 570: and FAV.APPLICATION_ID = ACA.FND_APPLICATION_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