[Home] [Help]
15: else
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
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;
328: L_DESCRIPTION AME_CONFIG_VARS_TL.DESCRIPTION%TYPE;
502: AME_SEED_UTILITY.DATE_AS_STRING(ACV.LAST_UPDATE_DATE)
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
549: ,X_UPLOAD_MODE in varchar2
550: ,X_CUSTOM_MODE in varchar2
551: ) as
552: X_ATTRIBUTE_VALUE varchar2(10);
553: X_APPLICATION_NAME AME_CALLING_APPS.APPLICATION_NAME%TYPE;
554: begin
555: AME_SEED_UTILITY.INIT_AME_INSTALLATION_LEVEL;
556:
557: if AME_SEED_UTILITY.AME_INSTALLATION_LEVEL is not null and
563: end if;
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