eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AK_ON_OBJECTS_PVT dependencies on AK_UPLOAD_GRP

Line 2168: AK_UPLOAD_GRP.G_GEN_DATE:= to_date(substr(l_buffer,16),'RR/MM/DD HH24:MI:SS');

2164: --
2165: l_buffer := LTRIM(l_buffer);
2166: if (SUBSTR(l_buffer, 1, 1) = '#') then
2167: if (SUBSTR(l_buffer, 3,12) = 'Generated on') then
2168: AK_UPLOAD_GRP.G_GEN_DATE:= to_date(substr(l_buffer,16),'RR/MM/DD HH24:MI:SS');
2169: end if;
2170: l_buffer := null;
2171: end if;
2172: end loop;

Line 2174: if (AK_UPLOAD_GRP.G_GEN_DATE is null) then

2170: l_buffer := null;
2171: end if;
2172: end loop;
2173:
2174: if (AK_UPLOAD_GRP.G_GEN_DATE is null) then
2175: AK_UPLOAD_GRP.G_GEN_DATE := l_timestamp;
2176: end if;
2177:
2178: --

Line 2175: AK_UPLOAD_GRP.G_GEN_DATE := l_timestamp;

2171: end if;
2172: end loop;
2173:
2174: if (AK_UPLOAD_GRP.G_GEN_DATE is null) then
2175: AK_UPLOAD_GRP.G_GEN_DATE := l_timestamp;
2176: end if;
2177:
2178: --
2179: -- if we cannot even get one non-blank, non-comment line from

Line 2287: AK_UPLOAD_GRP.G_EXTRACT_OBJ := l_extract_by_obj;

2283: end if;
2284: raise FND_API.G_EXC_ERROR;
2285: else
2286: l_extract_by_obj := UPPER(l_token);
2287: AK_UPLOAD_GRP.G_EXTRACT_OBJ := l_extract_by_obj;
2288: end if;
2289: elsif (l_column = 'FILE_FORMAT_VERSION') then
2290: l_file_version := to_number(l_token);
2291: AK_ON_OBJECTS_PUB.G_UPLOAD_FILE_VERSION := l_file_version;

Line 3176: if AK_UPLOAD_GRP.G_UPLOAD_DATE is null then

3172: l_api_name CONSTANT varchar2(30) := 'Set_Who';
3173: l_file_version number;
3174: begin
3175:
3176: if AK_UPLOAD_GRP.G_UPLOAD_DATE is null then
3177: AK_UPLOAD_GRP.G_UPLOAD_DATE := AK_UPLOAD_GRP.G_GEN_DATE;
3178: end if;
3179: if (p_loader_timestamp <> FND_API.G_MISS_DATE) then
3180: l_file_version := AK_ON_OBJECTS_PUB.G_UPLOAD_FILE_VERSION;

Line 3177: AK_UPLOAD_GRP.G_UPLOAD_DATE := AK_UPLOAD_GRP.G_GEN_DATE;

3173: l_file_version number;
3174: begin
3175:
3176: if AK_UPLOAD_GRP.G_UPLOAD_DATE is null then
3177: AK_UPLOAD_GRP.G_UPLOAD_DATE := AK_UPLOAD_GRP.G_GEN_DATE;
3178: end if;
3179: if (p_loader_timestamp <> FND_API.G_MISS_DATE) then
3180: l_file_version := AK_ON_OBJECTS_PUB.G_UPLOAD_FILE_VERSION;
3181: if ( l_file_version = AK_ON_OBJECTS_PUB.G_OLD_FILE_FORMAT_VER1 or

Line 3193: if (AK_UPLOAD_GRP.G_UPLOAD_DATE is null and AK_UPLOAD_GRP.G_COMPARE_UPDATE = FALSE) then

3189: l_file_version = AK_ON_OBJECTS_PUB.G_OLD_FILE_FORMAT_VER9 or
3190: l_file_version = AK_ON_OBJECTS_PUB.G_OLD_FILE_FORMAT_VER10 or
3191: l_file_version = AK_ON_OBJECTS_PUB.G_OLD_FILE_FORMAT_VER11 or
3192: l_file_version = AK_ON_OBJECTS_PUB.G_OLD_FILE_FORMAT_VER12) then
3193: if (AK_UPLOAD_GRP.G_UPLOAD_DATE is null and AK_UPLOAD_GRP.G_COMPARE_UPDATE = FALSE) then
3194: AK_UPLOAD_GRP.G_UPLOAD_DATE := p_loader_timestamp;
3195: elsif (AK_UPLOAD_GRP.G_UPLOAD_DATE is null and AK_UPLOAD_GRP.G_COMPARE_UPDATE = TRUE) then
3196: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then
3197: FND_MESSAGE.SET_NAME('AK','AK_MISSING_GEN_DATE');

Line 3194: AK_UPLOAD_GRP.G_UPLOAD_DATE := p_loader_timestamp;

3190: l_file_version = AK_ON_OBJECTS_PUB.G_OLD_FILE_FORMAT_VER10 or
3191: l_file_version = AK_ON_OBJECTS_PUB.G_OLD_FILE_FORMAT_VER11 or
3192: l_file_version = AK_ON_OBJECTS_PUB.G_OLD_FILE_FORMAT_VER12) then
3193: if (AK_UPLOAD_GRP.G_UPLOAD_DATE is null and AK_UPLOAD_GRP.G_COMPARE_UPDATE = FALSE) then
3194: AK_UPLOAD_GRP.G_UPLOAD_DATE := p_loader_timestamp;
3195: elsif (AK_UPLOAD_GRP.G_UPLOAD_DATE is null and AK_UPLOAD_GRP.G_COMPARE_UPDATE = TRUE) then
3196: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then
3197: FND_MESSAGE.SET_NAME('AK','AK_MISSING_GEN_DATE');
3198: FND_MSG_PUB.Add;

Line 3195: elsif (AK_UPLOAD_GRP.G_UPLOAD_DATE is null and AK_UPLOAD_GRP.G_COMPARE_UPDATE = TRUE) then

3191: l_file_version = AK_ON_OBJECTS_PUB.G_OLD_FILE_FORMAT_VER11 or
3192: l_file_version = AK_ON_OBJECTS_PUB.G_OLD_FILE_FORMAT_VER12) then
3193: if (AK_UPLOAD_GRP.G_UPLOAD_DATE is null and AK_UPLOAD_GRP.G_COMPARE_UPDATE = FALSE) then
3194: AK_UPLOAD_GRP.G_UPLOAD_DATE := p_loader_timestamp;
3195: elsif (AK_UPLOAD_GRP.G_UPLOAD_DATE is null and AK_UPLOAD_GRP.G_COMPARE_UPDATE = TRUE) then
3196: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then
3197: FND_MESSAGE.SET_NAME('AK','AK_MISSING_GEN_DATE');
3198: FND_MSG_PUB.Add;
3199: end if;

Line 3203: p_creation_date := AK_UPLOAD_GRP.G_UPLOAD_DATE;

3199: end if;
3200: raise FND_API.G_EXC_ERROR;
3201: end if;
3202: p_created_by := 1;
3203: p_creation_date := AK_UPLOAD_GRP.G_UPLOAD_DATE;
3204: p_last_updated_by := 1;
3205: p_last_update_date := AK_UPLOAD_GRP.G_UPLOAD_DATE;
3206: p_last_update_login := 1;
3207: elsif ( l_file_version = AK_ON_OBJECTS_PUB.G_OLD_FILE_FORMAT_VER15 or

Line 3205: p_last_update_date := AK_UPLOAD_GRP.G_UPLOAD_DATE;

3201: end if;
3202: p_created_by := 1;
3203: p_creation_date := AK_UPLOAD_GRP.G_UPLOAD_DATE;
3204: p_last_updated_by := 1;
3205: p_last_update_date := AK_UPLOAD_GRP.G_UPLOAD_DATE;
3206: p_last_update_login := 1;
3207: elsif ( l_file_version = AK_ON_OBJECTS_PUB.G_OLD_FILE_FORMAT_VER15 or
3208: l_file_version = AK_ON_OBJECTS_PUB.G_OLD_FILE_FORMAT_VER14) then
3209: -- called from loader

Line 3211: p_creation_date := AK_UPLOAD_GRP.G_UPLOAD_DATE;

3207: elsif ( l_file_version = AK_ON_OBJECTS_PUB.G_OLD_FILE_FORMAT_VER15 or
3208: l_file_version = AK_ON_OBJECTS_PUB.G_OLD_FILE_FORMAT_VER14) then
3209: -- called from loader
3210: p_created_by := 2;
3211: p_creation_date := AK_UPLOAD_GRP.G_UPLOAD_DATE;
3212: p_last_updated_by := 2;
3213: p_last_update_date := AK_UPLOAD_GRP.G_UPLOAD_DATE;
3214: p_last_update_login := 1;
3215: end if;

Line 3213: p_last_update_date := AK_UPLOAD_GRP.G_UPLOAD_DATE;

3209: -- called from loader
3210: p_created_by := 2;
3211: p_creation_date := AK_UPLOAD_GRP.G_UPLOAD_DATE;
3212: p_last_updated_by := 2;
3213: p_last_update_date := AK_UPLOAD_GRP.G_UPLOAD_DATE;
3214: p_last_update_login := 1;
3215: end if;
3216: else
3217: -- called from user procedure

Line 3307: if (AK_UPLOAD_GRP.G_UPDATE_MODE or p_create_or_update = 'FORCE') then

3303: l_custom_mode varchar2(8);
3304: begin
3305:
3306: l_file_version := AK_ON_OBJECTS_PUB.G_UPLOAD_FILE_VERSION;
3307: if (AK_UPLOAD_GRP.G_UPDATE_MODE or p_create_or_update = 'FORCE') then
3308: l_custom_mode := 'FORCE';
3309: elsif (AK_UPLOAD_GRP.G_NO_CUSTOM_UPDATE) then
3310: l_custom_mode := 'NCUPDATE';
3311: else

Line 3309: elsif (AK_UPLOAD_GRP.G_NO_CUSTOM_UPDATE) then

3305:
3306: l_file_version := AK_ON_OBJECTS_PUB.G_UPLOAD_FILE_VERSION;
3307: if (AK_UPLOAD_GRP.G_UPDATE_MODE or p_create_or_update = 'FORCE') then
3308: l_custom_mode := 'FORCE';
3309: elsif (AK_UPLOAD_GRP.G_NO_CUSTOM_UPDATE) then
3310: l_custom_mode := 'NCUPDATE';
3311: else
3312: l_custom_mode := 'INVALID';
3313: end if;

Line 3331: if (AK_UPLOAD_GRP.G_NO_CUSTOM_UPDATE) then

3327: end if;
3328:
3329: /* ELSIF JLT PRIOR TO R12 DO OLD COMPARISON CHECKING */
3330: elsif (l_file_version <> AK_ON_OBJECTS_PUB.G_FILE_FORMAT_VER) then
3331: if (AK_UPLOAD_GRP.G_NO_CUSTOM_UPDATE) then
3332: if (p_db_last_updated_by <> 1 and p_db_last_updated_by <> 2) then
3333: return FALSE;
3334: end if;
3335: end if;

Line 3336: AK_UPLOAD_GRP.G_UPLOAD_DATE := p_last_update_date;

3332: if (p_db_last_updated_by <> 1 and p_db_last_updated_by <> 2) then
3333: return FALSE;
3334: end if;
3335: end if;
3336: AK_UPLOAD_GRP.G_UPLOAD_DATE := p_last_update_date;
3337: AK_ON_OBJECTS_PVT.SET_WHO (
3338: p_return_status => l_return_status,
3339: p_loader_timestamp => p_loader_timestamp,
3340: p_created_by => l_created_by,

Line 3346: if (AK_UPLOAD_GRP.G_NON_SEED_DATA) then

3342: p_last_updated_by => l_last_updated_by,
3343: p_last_update_date => l_last_update_date,
3344: p_last_update_login => l_last_update_login);
3345:
3346: if (AK_UPLOAD_GRP.G_NON_SEED_DATA) then
3347: l_created_by := p_created_by;
3348: l_last_updated_by := p_last_updated_by;
3349: l_last_update_login := p_last_update_login;
3350: end if;

Line 3361: ((AK_UPLOAD_GRP.G_COMPARE_UPDATE = TRUE and

3357:
3358: if p_create_or_update = 'CREATE' then
3359: return TRUE;
3360: elsif
3361: ((AK_UPLOAD_GRP.G_COMPARE_UPDATE = TRUE and
3362: (l_file_version = AK_ON_OBJECTS_PUB.G_OLD_FILE_FORMAT_VER15 or
3363: l_file_version = AK_ON_OBJECTS_PUB.G_OLD_FILE_FORMAT_VER14) and
3364: (p_db_last_updated_by = 1 or p_last_update_date > p_db_last_update_date)) or
3365: (AK_UPLOAD_GRP.G_COMPARE_UPDATE = TRUE and

Line 3365: (AK_UPLOAD_GRP.G_COMPARE_UPDATE = TRUE and

3361: ((AK_UPLOAD_GRP.G_COMPARE_UPDATE = TRUE and
3362: (l_file_version = AK_ON_OBJECTS_PUB.G_OLD_FILE_FORMAT_VER15 or
3363: l_file_version = AK_ON_OBJECTS_PUB.G_OLD_FILE_FORMAT_VER14) and
3364: (p_db_last_updated_by = 1 or p_last_update_date > p_db_last_update_date)) or
3365: (AK_UPLOAD_GRP.G_COMPARE_UPDATE = TRUE and
3366: ( l_file_version = AK_ON_OBJECTS_PUB.G_OLD_FILE_FORMAT_VER1 or
3367: l_file_version = AK_ON_OBJECTS_PUB.G_OLD_FILE_FORMAT_VER2 or
3368: l_file_version = AK_ON_OBJECTS_PUB.G_OLD_FILE_FORMAT_VER3 or
3369: l_file_version = AK_ON_OBJECTS_PUB.G_OLD_FILE_FORMAT_VER4 or

Line 3379: AK_UPLOAD_GRP.G_COMPARE_UPDATE = FALSE)

3375: l_file_version = AK_ON_OBJECTS_PUB.G_OLD_FILE_FORMAT_VER10 or
3376: l_file_version = AK_ON_OBJECTS_PUB.G_OLD_FILE_FORMAT_VER11 or
3377: l_file_version = AK_ON_OBJECTS_PUB.G_OLD_FILE_FORMAT_VER12) and
3378: p_db_last_updated_by = 1) or
3379: AK_UPLOAD_GRP.G_COMPARE_UPDATE = FALSE)
3380: THEN
3381: return TRUE;
3382: else return FALSE;
3383: end if;