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 2160: AK_UPLOAD_GRP.G_GEN_DATE:= to_date(substr(l_buffer,16),'RR/MM/DD HH24:MI:SS');

2156: --
2157: l_buffer := LTRIM(l_buffer);
2158: if (SUBSTR(l_buffer, 1, 1) = '#') then
2159: if (SUBSTR(l_buffer, 3,12) = 'Generated on') then
2160: AK_UPLOAD_GRP.G_GEN_DATE:= to_date(substr(l_buffer,16),'RR/MM/DD HH24:MI:SS');
2161: end if;
2162: l_buffer := null;
2163: end if;
2164: end loop;

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

2162: l_buffer := null;
2163: end if;
2164: end loop;
2165:
2166: if (AK_UPLOAD_GRP.G_GEN_DATE is null) then
2167: AK_UPLOAD_GRP.G_GEN_DATE := l_timestamp;
2168: end if;
2169:
2170: --

Line 2167: AK_UPLOAD_GRP.G_GEN_DATE := l_timestamp;

2163: end if;
2164: end loop;
2165:
2166: if (AK_UPLOAD_GRP.G_GEN_DATE is null) then
2167: AK_UPLOAD_GRP.G_GEN_DATE := l_timestamp;
2168: end if;
2169:
2170: --
2171: -- if we cannot even get one non-blank, non-comment line from

Line 2279: AK_UPLOAD_GRP.G_EXTRACT_OBJ := l_extract_by_obj;

2275: end if;
2276: raise FND_API.G_EXC_ERROR;
2277: else
2278: l_extract_by_obj := UPPER(l_token);
2279: AK_UPLOAD_GRP.G_EXTRACT_OBJ := l_extract_by_obj;
2280: end if;
2281: elsif (l_column = 'FILE_FORMAT_VERSION') then
2282: l_file_version := to_number(l_token);
2283: AK_ON_OBJECTS_PUB.G_UPLOAD_FILE_VERSION := l_file_version;

Line 3081: if AK_UPLOAD_GRP.G_UPLOAD_DATE is null then

3077: l_api_name CONSTANT varchar2(30) := 'Set_Who';
3078: l_file_version number;
3079: begin
3080:
3081: if AK_UPLOAD_GRP.G_UPLOAD_DATE is null then
3082: AK_UPLOAD_GRP.G_UPLOAD_DATE := AK_UPLOAD_GRP.G_GEN_DATE;
3083: end if;
3084: if (p_loader_timestamp <> FND_API.G_MISS_DATE) then
3085: l_file_version := AK_ON_OBJECTS_PUB.G_UPLOAD_FILE_VERSION;

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

3078: l_file_version number;
3079: begin
3080:
3081: if AK_UPLOAD_GRP.G_UPLOAD_DATE is null then
3082: AK_UPLOAD_GRP.G_UPLOAD_DATE := AK_UPLOAD_GRP.G_GEN_DATE;
3083: end if;
3084: if (p_loader_timestamp <> FND_API.G_MISS_DATE) then
3085: l_file_version := AK_ON_OBJECTS_PUB.G_UPLOAD_FILE_VERSION;
3086: if ( l_file_version = AK_ON_OBJECTS_PUB.G_OLD_FILE_FORMAT_VER1 or

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

3094: l_file_version = AK_ON_OBJECTS_PUB.G_OLD_FILE_FORMAT_VER9 or
3095: l_file_version = AK_ON_OBJECTS_PUB.G_OLD_FILE_FORMAT_VER10 or
3096: l_file_version = AK_ON_OBJECTS_PUB.G_OLD_FILE_FORMAT_VER11 or
3097: l_file_version = AK_ON_OBJECTS_PUB.G_OLD_FILE_FORMAT_VER12) then
3098: if (AK_UPLOAD_GRP.G_UPLOAD_DATE is null and AK_UPLOAD_GRP.G_COMPARE_UPDATE = FALSE) then
3099: AK_UPLOAD_GRP.G_UPLOAD_DATE := p_loader_timestamp;
3100: elsif (AK_UPLOAD_GRP.G_UPLOAD_DATE is null and AK_UPLOAD_GRP.G_COMPARE_UPDATE = TRUE) then
3101: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then
3102: FND_MESSAGE.SET_NAME('AK','AK_MISSING_GEN_DATE');

Line 3099: AK_UPLOAD_GRP.G_UPLOAD_DATE := p_loader_timestamp;

3095: l_file_version = AK_ON_OBJECTS_PUB.G_OLD_FILE_FORMAT_VER10 or
3096: l_file_version = AK_ON_OBJECTS_PUB.G_OLD_FILE_FORMAT_VER11 or
3097: l_file_version = AK_ON_OBJECTS_PUB.G_OLD_FILE_FORMAT_VER12) then
3098: if (AK_UPLOAD_GRP.G_UPLOAD_DATE is null and AK_UPLOAD_GRP.G_COMPARE_UPDATE = FALSE) then
3099: AK_UPLOAD_GRP.G_UPLOAD_DATE := p_loader_timestamp;
3100: elsif (AK_UPLOAD_GRP.G_UPLOAD_DATE is null and AK_UPLOAD_GRP.G_COMPARE_UPDATE = TRUE) then
3101: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then
3102: FND_MESSAGE.SET_NAME('AK','AK_MISSING_GEN_DATE');
3103: FND_MSG_PUB.Add;

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

3096: l_file_version = AK_ON_OBJECTS_PUB.G_OLD_FILE_FORMAT_VER11 or
3097: l_file_version = AK_ON_OBJECTS_PUB.G_OLD_FILE_FORMAT_VER12) then
3098: if (AK_UPLOAD_GRP.G_UPLOAD_DATE is null and AK_UPLOAD_GRP.G_COMPARE_UPDATE = FALSE) then
3099: AK_UPLOAD_GRP.G_UPLOAD_DATE := p_loader_timestamp;
3100: elsif (AK_UPLOAD_GRP.G_UPLOAD_DATE is null and AK_UPLOAD_GRP.G_COMPARE_UPDATE = TRUE) then
3101: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then
3102: FND_MESSAGE.SET_NAME('AK','AK_MISSING_GEN_DATE');
3103: FND_MSG_PUB.Add;
3104: end if;

Line 3108: p_creation_date := AK_UPLOAD_GRP.G_UPLOAD_DATE;

3104: end if;
3105: raise FND_API.G_EXC_ERROR;
3106: end if;
3107: p_created_by := 1;
3108: p_creation_date := AK_UPLOAD_GRP.G_UPLOAD_DATE;
3109: p_last_updated_by := 1;
3110: p_last_update_date := AK_UPLOAD_GRP.G_UPLOAD_DATE;
3111: p_last_update_login := 1;
3112: elsif ( l_file_version = AK_ON_OBJECTS_PUB.G_OLD_FILE_FORMAT_VER15 or

Line 3110: p_last_update_date := AK_UPLOAD_GRP.G_UPLOAD_DATE;

3106: end if;
3107: p_created_by := 1;
3108: p_creation_date := AK_UPLOAD_GRP.G_UPLOAD_DATE;
3109: p_last_updated_by := 1;
3110: p_last_update_date := AK_UPLOAD_GRP.G_UPLOAD_DATE;
3111: p_last_update_login := 1;
3112: elsif ( l_file_version = AK_ON_OBJECTS_PUB.G_OLD_FILE_FORMAT_VER15 or
3113: l_file_version = AK_ON_OBJECTS_PUB.G_OLD_FILE_FORMAT_VER14) then
3114: -- called from loader

Line 3116: p_creation_date := AK_UPLOAD_GRP.G_UPLOAD_DATE;

3112: elsif ( l_file_version = AK_ON_OBJECTS_PUB.G_OLD_FILE_FORMAT_VER15 or
3113: l_file_version = AK_ON_OBJECTS_PUB.G_OLD_FILE_FORMAT_VER14) then
3114: -- called from loader
3115: p_created_by := 2;
3116: p_creation_date := AK_UPLOAD_GRP.G_UPLOAD_DATE;
3117: p_last_updated_by := 2;
3118: p_last_update_date := AK_UPLOAD_GRP.G_UPLOAD_DATE;
3119: p_last_update_login := 1;
3120: end if;

Line 3118: p_last_update_date := AK_UPLOAD_GRP.G_UPLOAD_DATE;

3114: -- called from loader
3115: p_created_by := 2;
3116: p_creation_date := AK_UPLOAD_GRP.G_UPLOAD_DATE;
3117: p_last_updated_by := 2;
3118: p_last_update_date := AK_UPLOAD_GRP.G_UPLOAD_DATE;
3119: p_last_update_login := 1;
3120: end if;
3121: else
3122: -- called from user procedure

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

3208: l_custom_mode varchar2(8);
3209: begin
3210:
3211: l_file_version := AK_ON_OBJECTS_PUB.G_UPLOAD_FILE_VERSION;
3212: if (AK_UPLOAD_GRP.G_UPDATE_MODE or p_create_or_update = 'FORCE') then
3213: l_custom_mode := 'FORCE';
3214: elsif (AK_UPLOAD_GRP.G_NO_CUSTOM_UPDATE) then
3215: l_custom_mode := 'NCUPDATE';
3216: else

Line 3214: elsif (AK_UPLOAD_GRP.G_NO_CUSTOM_UPDATE) then

3210:
3211: l_file_version := AK_ON_OBJECTS_PUB.G_UPLOAD_FILE_VERSION;
3212: if (AK_UPLOAD_GRP.G_UPDATE_MODE or p_create_or_update = 'FORCE') then
3213: l_custom_mode := 'FORCE';
3214: elsif (AK_UPLOAD_GRP.G_NO_CUSTOM_UPDATE) then
3215: l_custom_mode := 'NCUPDATE';
3216: else
3217: l_custom_mode := 'INVALID';
3218: end if;

Line 3236: if (AK_UPLOAD_GRP.G_NO_CUSTOM_UPDATE) then

3232: end if;
3233:
3234: /* ELSIF JLT PRIOR TO R12 DO OLD COMPARISON CHECKING */
3235: elsif (l_file_version <> AK_ON_OBJECTS_PUB.G_FILE_FORMAT_VER) then
3236: if (AK_UPLOAD_GRP.G_NO_CUSTOM_UPDATE) then
3237: if (p_db_last_updated_by <> 1 and p_db_last_updated_by <> 2) then
3238: return FALSE;
3239: end if;
3240: end if;

Line 3241: AK_UPLOAD_GRP.G_UPLOAD_DATE := p_last_update_date;

3237: if (p_db_last_updated_by <> 1 and p_db_last_updated_by <> 2) then
3238: return FALSE;
3239: end if;
3240: end if;
3241: AK_UPLOAD_GRP.G_UPLOAD_DATE := p_last_update_date;
3242: AK_ON_OBJECTS_PVT.SET_WHO (
3243: p_return_status => l_return_status,
3244: p_loader_timestamp => p_loader_timestamp,
3245: p_created_by => l_created_by,

Line 3251: if (AK_UPLOAD_GRP.G_NON_SEED_DATA) then

3247: p_last_updated_by => l_last_updated_by,
3248: p_last_update_date => l_last_update_date,
3249: p_last_update_login => l_last_update_login);
3250:
3251: if (AK_UPLOAD_GRP.G_NON_SEED_DATA) then
3252: l_created_by := p_created_by;
3253: l_last_updated_by := p_last_updated_by;
3254: l_last_update_login := p_last_update_login;
3255: end if;

Line 3266: ((AK_UPLOAD_GRP.G_COMPARE_UPDATE = TRUE and

3262:
3263: if p_create_or_update = 'CREATE' then
3264: return TRUE;
3265: elsif
3266: ((AK_UPLOAD_GRP.G_COMPARE_UPDATE = TRUE and
3267: (l_file_version = AK_ON_OBJECTS_PUB.G_OLD_FILE_FORMAT_VER15 or
3268: l_file_version = AK_ON_OBJECTS_PUB.G_OLD_FILE_FORMAT_VER14) and
3269: (p_db_last_updated_by = 1 or p_last_update_date > p_db_last_update_date)) or
3270: (AK_UPLOAD_GRP.G_COMPARE_UPDATE = TRUE and

Line 3270: (AK_UPLOAD_GRP.G_COMPARE_UPDATE = TRUE and

3266: ((AK_UPLOAD_GRP.G_COMPARE_UPDATE = TRUE and
3267: (l_file_version = AK_ON_OBJECTS_PUB.G_OLD_FILE_FORMAT_VER15 or
3268: l_file_version = AK_ON_OBJECTS_PUB.G_OLD_FILE_FORMAT_VER14) and
3269: (p_db_last_updated_by = 1 or p_last_update_date > p_db_last_update_date)) or
3270: (AK_UPLOAD_GRP.G_COMPARE_UPDATE = TRUE and
3271: ( l_file_version = AK_ON_OBJECTS_PUB.G_OLD_FILE_FORMAT_VER1 or
3272: l_file_version = AK_ON_OBJECTS_PUB.G_OLD_FILE_FORMAT_VER2 or
3273: l_file_version = AK_ON_OBJECTS_PUB.G_OLD_FILE_FORMAT_VER3 or
3274: l_file_version = AK_ON_OBJECTS_PUB.G_OLD_FILE_FORMAT_VER4 or

Line 3284: AK_UPLOAD_GRP.G_COMPARE_UPDATE = FALSE)

3280: l_file_version = AK_ON_OBJECTS_PUB.G_OLD_FILE_FORMAT_VER10 or
3281: l_file_version = AK_ON_OBJECTS_PUB.G_OLD_FILE_FORMAT_VER11 or
3282: l_file_version = AK_ON_OBJECTS_PUB.G_OLD_FILE_FORMAT_VER12) and
3283: p_db_last_updated_by = 1) or
3284: AK_UPLOAD_GRP.G_COMPARE_UPDATE = FALSE)
3285: THEN
3286: return TRUE;
3287: else return FALSE;
3288: end if;