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_ON_OBJECTS_PUB

Line 16: G_buffer_tbl AK_ON_OBJECTS_PUB.Buffer_Tbl_Type;

12:
13: --
14: -- global variables within this package body
15: --
16: G_buffer_tbl AK_ON_OBJECTS_PUB.Buffer_Tbl_Type;
17: G_PREPARE_ATTRIBUTE boolean:=false;
18: G_PREPARE_OBJECT boolean:=false;
19: G_PREPARE_REGION boolean:=false;
20: G_PREPARE_CUSTOM boolean:=false;

Line 44: l_buffer AK_ON_OBJECTS_PUB.Buffer_Type;

40: --==============================================
41: function REPLACE_ESCAPED_CHARS (
42: p_buffer IN varchar2
43: ) return varchar2 is
44: l_buffer AK_ON_OBJECTS_PUB.Buffer_Type;
45: begin
46: l_buffer := REPLACE(p_buffer, '\"', '"');
47: l_buffer := REPLACE(l_buffer, '\t', ' '); /* tab */
48: l_buffer := REPLACE(l_buffer, '\n', '

Line 78: l_buffer AK_ON_OBJECTS_PUB.Buffer_Type;

74: p_buffer IN VARCHAR2
75: ) return VARCHAR2 is
76: l_api_version_number CONSTANT number := 1.0;
77: l_api_name CONSTANT varchar2(30) := 'Replace_Special_Char';
78: l_buffer AK_ON_OBJECTS_PUB.Buffer_Type;
79: begin
80:
81: if (p_buffer is null) then
82: return null;

Line 122: p_from_table IN AK_ON_OBJECTS_PUB.Buffer_Tbl_Type,

118: -- in the from table appended to it.
119: --==============================================
120: procedure APPEND_BUFFER_TABLES (
121: p_return_status OUT NOCOPY VARCHAR2,
122: p_from_table IN AK_ON_OBJECTS_PUB.Buffer_Tbl_Type,
123: p_to_table IN OUT NOCOPY AK_ON_OBJECTS_PUB.Buffer_Tbl_Type
124: ) is
125: l_api_name CONSTANT varchar2(30) := 'Append_Buffer_Tables';
126: l_from_index NUMBER;

Line 123: p_to_table IN OUT NOCOPY AK_ON_OBJECTS_PUB.Buffer_Tbl_Type

119: --==============================================
120: procedure APPEND_BUFFER_TABLES (
121: p_return_status OUT NOCOPY VARCHAR2,
122: p_from_table IN AK_ON_OBJECTS_PUB.Buffer_Tbl_Type,
123: p_to_table IN OUT NOCOPY AK_ON_OBJECTS_PUB.Buffer_Tbl_Type
124: ) is
125: l_api_name CONSTANT varchar2(30) := 'Append_Buffer_Tables';
126: l_from_index NUMBER;
127: l_to_index NUMBER;

Line 235: l_header_tbl AK_ON_OBJECTS_PUB.Buffer_Tbl_Type;

231: where application_short_name = short_name_param;
232: l_api_version_number CONSTANT number := 1.0;
233: l_api_name CONSTANT varchar2(30) := 'Download_Header';
234: l_application_id number;
235: l_header_tbl AK_ON_OBJECTS_PUB.Buffer_Tbl_Type;
236: l_index NUMBER;
237: l_nls_language VARCHAR2(30);
238: l_return_status varchar2(1);
239: l_sub_phase varchar2(2);

Line 382: l_header_tbl(l_index) := 'FILE_FORMAT_VERSION = '||to_char(AK_ON_OBJECTS_PUB.G_FILE_FORMAT_VER);

378: l_header_tbl(l_index) := 'EXTRACT_BY_OBJECT = "' ||
379: p_download_by_object || '"';
380:
381: l_index := l_index + 1;
382: l_header_tbl(l_index) := 'FILE_FORMAT_VERSION = '||to_char(AK_ON_OBJECTS_PUB.G_FILE_FORMAT_VER);
383:
384: --
385: -- DEFINE section
386: --

Line 2010: p_write_mode => AK_ON_OBJECTS_PUB.G_OVERWRITE

2006: --
2007: AK_ON_OBJECTS_PVT.WRITE_FILE (
2008: p_return_status => l_return_status,
2009: p_buffer_tbl => l_header_tbl,
2010: p_write_mode => AK_ON_OBJECTS_PUB.G_OVERWRITE
2011: );
2012: if (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) or
2013: (l_return_status = FND_API.G_RET_STS_ERROR) then
2014: --dbms_output.put_line(G_PKG_NAME || ': first write_File failed');

Line 2068: l_upl_loader_cur AK_ON_OBJECTS_PUB.LoaderCurTyp; -- Cursor for upload

2064: p_msg_count OUT NOCOPY NUMBER,
2065: p_msg_data OUT NOCOPY VARCHAR2,
2066: p_return_status OUT NOCOPY VARCHAR2
2067: ) is
2068: l_upl_loader_cur AK_ON_OBJECTS_PUB.LoaderCurTyp; -- Cursor for upload
2069: l_api_version_number CONSTANT number := 1.0;
2070: l_api_name CONSTANT varchar2(30) := 'Upload';
2071: l_attribute_index NUMBER := 0;
2072: l_attribute_index_tbl Index_Tbl_Type;

Line 2073: l_buffer_tbl AK_ON_OBJECTS_PUB.Buffer_Tbl_Type;

2069: l_api_version_number CONSTANT number := 1.0;
2070: l_api_name CONSTANT varchar2(30) := 'Upload';
2071: l_attribute_index NUMBER := 0;
2072: l_attribute_index_tbl Index_Tbl_Type;
2073: l_buffer_tbl AK_ON_OBJECTS_PUB.Buffer_Tbl_Type;
2074: l_buffer AK_ON_OBJECTS_PUB.Buffer_Type;
2075: l_buffer2 AK_ON_OBJECTS_PUB.Buffer_Type;
2076: l_column varchar2(30);
2077: l_dummy NUMBER;

Line 2074: l_buffer AK_ON_OBJECTS_PUB.Buffer_Type;

2070: l_api_name CONSTANT varchar2(30) := 'Upload';
2071: l_attribute_index NUMBER := 0;
2072: l_attribute_index_tbl Index_Tbl_Type;
2073: l_buffer_tbl AK_ON_OBJECTS_PUB.Buffer_Tbl_Type;
2074: l_buffer AK_ON_OBJECTS_PUB.Buffer_Type;
2075: l_buffer2 AK_ON_OBJECTS_PUB.Buffer_Type;
2076: l_column varchar2(30);
2077: l_dummy NUMBER;
2078: l_eof_flag varchar2(1);

Line 2075: l_buffer2 AK_ON_OBJECTS_PUB.Buffer_Type;

2071: l_attribute_index NUMBER := 0;
2072: l_attribute_index_tbl Index_Tbl_Type;
2073: l_buffer_tbl AK_ON_OBJECTS_PUB.Buffer_Tbl_Type;
2074: l_buffer AK_ON_OBJECTS_PUB.Buffer_Type;
2075: l_buffer2 AK_ON_OBJECTS_PUB.Buffer_Type;
2076: l_column varchar2(30);
2077: l_dummy NUMBER;
2078: l_eof_flag varchar2(1);
2079: l_extract_by_obj varchar2(20);

Line 2091: l_token AK_ON_OBJECTS_PUB.Buffer_Type;

2087: l_object_name varchar2(30);
2088: l_return_status varchar2(1);
2089: l_state NUMBER;
2090: l_timestamp DATE := sysdate;
2091: l_token AK_ON_OBJECTS_PUB.Buffer_Type;
2092: l_tbl_index NUMBER;
2093: l_file_version NUMBER;
2094: l_validation_level NUMBER := FND_API.G_VALID_LEVEL_FULL;
2095: l_not_compatible_version BOOLEAN := TRUE;

Line 2291: AK_ON_OBJECTS_PUB.G_UPLOAD_FILE_VERSION := l_file_version;

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;
2292: if ( l_file_version <> AK_ON_OBJECTS_PUB.G_FILE_FORMAT_VER and
2293: l_file_version <> AK_ON_OBJECTS_PUB.G_OLD_FILE_FORMAT_VER1 and
2294: l_file_version <> AK_ON_OBJECTS_PUB.G_OLD_FILE_FORMAT_VER2 and
2295: l_file_version <> AK_ON_OBJECTS_PUB.G_OLD_FILE_FORMAT_VER3 and

Line 2292: if ( l_file_version <> AK_ON_OBJECTS_PUB.G_FILE_FORMAT_VER and

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;
2292: if ( l_file_version <> AK_ON_OBJECTS_PUB.G_FILE_FORMAT_VER and
2293: l_file_version <> AK_ON_OBJECTS_PUB.G_OLD_FILE_FORMAT_VER1 and
2294: l_file_version <> AK_ON_OBJECTS_PUB.G_OLD_FILE_FORMAT_VER2 and
2295: l_file_version <> AK_ON_OBJECTS_PUB.G_OLD_FILE_FORMAT_VER3 and
2296: l_file_version <> AK_ON_OBJECTS_PUB.G_OLD_FILE_FORMAT_VER4 and

Line 2293: l_file_version <> AK_ON_OBJECTS_PUB.G_OLD_FILE_FORMAT_VER1 and

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;
2292: if ( l_file_version <> AK_ON_OBJECTS_PUB.G_FILE_FORMAT_VER and
2293: l_file_version <> AK_ON_OBJECTS_PUB.G_OLD_FILE_FORMAT_VER1 and
2294: l_file_version <> AK_ON_OBJECTS_PUB.G_OLD_FILE_FORMAT_VER2 and
2295: l_file_version <> AK_ON_OBJECTS_PUB.G_OLD_FILE_FORMAT_VER3 and
2296: l_file_version <> AK_ON_OBJECTS_PUB.G_OLD_FILE_FORMAT_VER4 and
2297: l_file_version <> AK_ON_OBJECTS_PUB.G_OLD_FILE_FORMAT_VER5 and

Line 2294: l_file_version <> AK_ON_OBJECTS_PUB.G_OLD_FILE_FORMAT_VER2 and

2290: l_file_version := to_number(l_token);
2291: AK_ON_OBJECTS_PUB.G_UPLOAD_FILE_VERSION := l_file_version;
2292: if ( l_file_version <> AK_ON_OBJECTS_PUB.G_FILE_FORMAT_VER and
2293: l_file_version <> AK_ON_OBJECTS_PUB.G_OLD_FILE_FORMAT_VER1 and
2294: l_file_version <> AK_ON_OBJECTS_PUB.G_OLD_FILE_FORMAT_VER2 and
2295: l_file_version <> AK_ON_OBJECTS_PUB.G_OLD_FILE_FORMAT_VER3 and
2296: l_file_version <> AK_ON_OBJECTS_PUB.G_OLD_FILE_FORMAT_VER4 and
2297: l_file_version <> AK_ON_OBJECTS_PUB.G_OLD_FILE_FORMAT_VER5 and
2298: l_file_version <> AK_ON_OBJECTS_PUB.G_OLD_FILE_FORMAT_VER6 and

Line 2295: l_file_version <> AK_ON_OBJECTS_PUB.G_OLD_FILE_FORMAT_VER3 and

2291: AK_ON_OBJECTS_PUB.G_UPLOAD_FILE_VERSION := l_file_version;
2292: if ( l_file_version <> AK_ON_OBJECTS_PUB.G_FILE_FORMAT_VER and
2293: l_file_version <> AK_ON_OBJECTS_PUB.G_OLD_FILE_FORMAT_VER1 and
2294: l_file_version <> AK_ON_OBJECTS_PUB.G_OLD_FILE_FORMAT_VER2 and
2295: l_file_version <> AK_ON_OBJECTS_PUB.G_OLD_FILE_FORMAT_VER3 and
2296: l_file_version <> AK_ON_OBJECTS_PUB.G_OLD_FILE_FORMAT_VER4 and
2297: l_file_version <> AK_ON_OBJECTS_PUB.G_OLD_FILE_FORMAT_VER5 and
2298: l_file_version <> AK_ON_OBJECTS_PUB.G_OLD_FILE_FORMAT_VER6 and
2299: l_file_version <> AK_ON_OBJECTS_PUB.G_OLD_FILE_FORMAT_VER7 and

Line 2296: l_file_version <> AK_ON_OBJECTS_PUB.G_OLD_FILE_FORMAT_VER4 and

2292: if ( l_file_version <> AK_ON_OBJECTS_PUB.G_FILE_FORMAT_VER and
2293: l_file_version <> AK_ON_OBJECTS_PUB.G_OLD_FILE_FORMAT_VER1 and
2294: l_file_version <> AK_ON_OBJECTS_PUB.G_OLD_FILE_FORMAT_VER2 and
2295: l_file_version <> AK_ON_OBJECTS_PUB.G_OLD_FILE_FORMAT_VER3 and
2296: l_file_version <> AK_ON_OBJECTS_PUB.G_OLD_FILE_FORMAT_VER4 and
2297: l_file_version <> AK_ON_OBJECTS_PUB.G_OLD_FILE_FORMAT_VER5 and
2298: l_file_version <> AK_ON_OBJECTS_PUB.G_OLD_FILE_FORMAT_VER6 and
2299: l_file_version <> AK_ON_OBJECTS_PUB.G_OLD_FILE_FORMAT_VER7 and
2300: l_file_version <> AK_ON_OBJECTS_PUB.G_OLD_FILE_FORMAT_VER8 and

Line 2297: l_file_version <> AK_ON_OBJECTS_PUB.G_OLD_FILE_FORMAT_VER5 and

2293: l_file_version <> AK_ON_OBJECTS_PUB.G_OLD_FILE_FORMAT_VER1 and
2294: l_file_version <> AK_ON_OBJECTS_PUB.G_OLD_FILE_FORMAT_VER2 and
2295: l_file_version <> AK_ON_OBJECTS_PUB.G_OLD_FILE_FORMAT_VER3 and
2296: l_file_version <> AK_ON_OBJECTS_PUB.G_OLD_FILE_FORMAT_VER4 and
2297: l_file_version <> AK_ON_OBJECTS_PUB.G_OLD_FILE_FORMAT_VER5 and
2298: l_file_version <> AK_ON_OBJECTS_PUB.G_OLD_FILE_FORMAT_VER6 and
2299: l_file_version <> AK_ON_OBJECTS_PUB.G_OLD_FILE_FORMAT_VER7 and
2300: l_file_version <> AK_ON_OBJECTS_PUB.G_OLD_FILE_FORMAT_VER8 and
2301: l_file_version <> AK_ON_OBJECTS_PUB.G_OLD_FILE_FORMAT_VER9 and

Line 2298: l_file_version <> AK_ON_OBJECTS_PUB.G_OLD_FILE_FORMAT_VER6 and

2294: l_file_version <> AK_ON_OBJECTS_PUB.G_OLD_FILE_FORMAT_VER2 and
2295: l_file_version <> AK_ON_OBJECTS_PUB.G_OLD_FILE_FORMAT_VER3 and
2296: l_file_version <> AK_ON_OBJECTS_PUB.G_OLD_FILE_FORMAT_VER4 and
2297: l_file_version <> AK_ON_OBJECTS_PUB.G_OLD_FILE_FORMAT_VER5 and
2298: l_file_version <> AK_ON_OBJECTS_PUB.G_OLD_FILE_FORMAT_VER6 and
2299: l_file_version <> AK_ON_OBJECTS_PUB.G_OLD_FILE_FORMAT_VER7 and
2300: l_file_version <> AK_ON_OBJECTS_PUB.G_OLD_FILE_FORMAT_VER8 and
2301: l_file_version <> AK_ON_OBJECTS_PUB.G_OLD_FILE_FORMAT_VER9 and
2302: l_file_version <> AK_ON_OBJECTS_PUB.G_OLD_FILE_FORMAT_VER10 and

Line 2299: l_file_version <> AK_ON_OBJECTS_PUB.G_OLD_FILE_FORMAT_VER7 and

2295: l_file_version <> AK_ON_OBJECTS_PUB.G_OLD_FILE_FORMAT_VER3 and
2296: l_file_version <> AK_ON_OBJECTS_PUB.G_OLD_FILE_FORMAT_VER4 and
2297: l_file_version <> AK_ON_OBJECTS_PUB.G_OLD_FILE_FORMAT_VER5 and
2298: l_file_version <> AK_ON_OBJECTS_PUB.G_OLD_FILE_FORMAT_VER6 and
2299: l_file_version <> AK_ON_OBJECTS_PUB.G_OLD_FILE_FORMAT_VER7 and
2300: l_file_version <> AK_ON_OBJECTS_PUB.G_OLD_FILE_FORMAT_VER8 and
2301: l_file_version <> AK_ON_OBJECTS_PUB.G_OLD_FILE_FORMAT_VER9 and
2302: l_file_version <> AK_ON_OBJECTS_PUB.G_OLD_FILE_FORMAT_VER10 and
2303: l_file_version <> AK_ON_OBJECTS_PUB.G_OLD_FILE_FORMAT_VER11 and

Line 2300: l_file_version <> AK_ON_OBJECTS_PUB.G_OLD_FILE_FORMAT_VER8 and

2296: l_file_version <> AK_ON_OBJECTS_PUB.G_OLD_FILE_FORMAT_VER4 and
2297: l_file_version <> AK_ON_OBJECTS_PUB.G_OLD_FILE_FORMAT_VER5 and
2298: l_file_version <> AK_ON_OBJECTS_PUB.G_OLD_FILE_FORMAT_VER6 and
2299: l_file_version <> AK_ON_OBJECTS_PUB.G_OLD_FILE_FORMAT_VER7 and
2300: l_file_version <> AK_ON_OBJECTS_PUB.G_OLD_FILE_FORMAT_VER8 and
2301: l_file_version <> AK_ON_OBJECTS_PUB.G_OLD_FILE_FORMAT_VER9 and
2302: l_file_version <> AK_ON_OBJECTS_PUB.G_OLD_FILE_FORMAT_VER10 and
2303: l_file_version <> AK_ON_OBJECTS_PUB.G_OLD_FILE_FORMAT_VER11 and
2304: l_file_version <> AK_ON_OBJECTS_PUB.G_OLD_FILE_FORMAT_VER12 and

Line 2301: l_file_version <> AK_ON_OBJECTS_PUB.G_OLD_FILE_FORMAT_VER9 and

2297: l_file_version <> AK_ON_OBJECTS_PUB.G_OLD_FILE_FORMAT_VER5 and
2298: l_file_version <> AK_ON_OBJECTS_PUB.G_OLD_FILE_FORMAT_VER6 and
2299: l_file_version <> AK_ON_OBJECTS_PUB.G_OLD_FILE_FORMAT_VER7 and
2300: l_file_version <> AK_ON_OBJECTS_PUB.G_OLD_FILE_FORMAT_VER8 and
2301: l_file_version <> AK_ON_OBJECTS_PUB.G_OLD_FILE_FORMAT_VER9 and
2302: l_file_version <> AK_ON_OBJECTS_PUB.G_OLD_FILE_FORMAT_VER10 and
2303: l_file_version <> AK_ON_OBJECTS_PUB.G_OLD_FILE_FORMAT_VER11 and
2304: l_file_version <> AK_ON_OBJECTS_PUB.G_OLD_FILE_FORMAT_VER12 and
2305: l_file_version <> AK_ON_OBJECTS_PUB.G_OLD_FILE_FORMAT_VER14 and

Line 2302: l_file_version <> AK_ON_OBJECTS_PUB.G_OLD_FILE_FORMAT_VER10 and

2298: l_file_version <> AK_ON_OBJECTS_PUB.G_OLD_FILE_FORMAT_VER6 and
2299: l_file_version <> AK_ON_OBJECTS_PUB.G_OLD_FILE_FORMAT_VER7 and
2300: l_file_version <> AK_ON_OBJECTS_PUB.G_OLD_FILE_FORMAT_VER8 and
2301: l_file_version <> AK_ON_OBJECTS_PUB.G_OLD_FILE_FORMAT_VER9 and
2302: l_file_version <> AK_ON_OBJECTS_PUB.G_OLD_FILE_FORMAT_VER10 and
2303: l_file_version <> AK_ON_OBJECTS_PUB.G_OLD_FILE_FORMAT_VER11 and
2304: l_file_version <> AK_ON_OBJECTS_PUB.G_OLD_FILE_FORMAT_VER12 and
2305: l_file_version <> AK_ON_OBJECTS_PUB.G_OLD_FILE_FORMAT_VER14 and
2306: l_file_version <> AK_ON_OBJECTS_PUB.G_OLD_FILE_FORMAT_VER15) then

Line 2303: l_file_version <> AK_ON_OBJECTS_PUB.G_OLD_FILE_FORMAT_VER11 and

2299: l_file_version <> AK_ON_OBJECTS_PUB.G_OLD_FILE_FORMAT_VER7 and
2300: l_file_version <> AK_ON_OBJECTS_PUB.G_OLD_FILE_FORMAT_VER8 and
2301: l_file_version <> AK_ON_OBJECTS_PUB.G_OLD_FILE_FORMAT_VER9 and
2302: l_file_version <> AK_ON_OBJECTS_PUB.G_OLD_FILE_FORMAT_VER10 and
2303: l_file_version <> AK_ON_OBJECTS_PUB.G_OLD_FILE_FORMAT_VER11 and
2304: l_file_version <> AK_ON_OBJECTS_PUB.G_OLD_FILE_FORMAT_VER12 and
2305: l_file_version <> AK_ON_OBJECTS_PUB.G_OLD_FILE_FORMAT_VER14 and
2306: l_file_version <> AK_ON_OBJECTS_PUB.G_OLD_FILE_FORMAT_VER15) then
2307: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

Line 2304: l_file_version <> AK_ON_OBJECTS_PUB.G_OLD_FILE_FORMAT_VER12 and

2300: l_file_version <> AK_ON_OBJECTS_PUB.G_OLD_FILE_FORMAT_VER8 and
2301: l_file_version <> AK_ON_OBJECTS_PUB.G_OLD_FILE_FORMAT_VER9 and
2302: l_file_version <> AK_ON_OBJECTS_PUB.G_OLD_FILE_FORMAT_VER10 and
2303: l_file_version <> AK_ON_OBJECTS_PUB.G_OLD_FILE_FORMAT_VER11 and
2304: l_file_version <> AK_ON_OBJECTS_PUB.G_OLD_FILE_FORMAT_VER12 and
2305: l_file_version <> AK_ON_OBJECTS_PUB.G_OLD_FILE_FORMAT_VER14 and
2306: l_file_version <> AK_ON_OBJECTS_PUB.G_OLD_FILE_FORMAT_VER15) then
2307: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2308: FND_MESSAGE.SET_NAME('AK','AK_WRONG_FILE_VERSION');

Line 2305: l_file_version <> AK_ON_OBJECTS_PUB.G_OLD_FILE_FORMAT_VER14 and

2301: l_file_version <> AK_ON_OBJECTS_PUB.G_OLD_FILE_FORMAT_VER9 and
2302: l_file_version <> AK_ON_OBJECTS_PUB.G_OLD_FILE_FORMAT_VER10 and
2303: l_file_version <> AK_ON_OBJECTS_PUB.G_OLD_FILE_FORMAT_VER11 and
2304: l_file_version <> AK_ON_OBJECTS_PUB.G_OLD_FILE_FORMAT_VER12 and
2305: l_file_version <> AK_ON_OBJECTS_PUB.G_OLD_FILE_FORMAT_VER14 and
2306: l_file_version <> AK_ON_OBJECTS_PUB.G_OLD_FILE_FORMAT_VER15) then
2307: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2308: FND_MESSAGE.SET_NAME('AK','AK_WRONG_FILE_VERSION');
2309: FND_MSG_PUB.Add;

Line 2306: l_file_version <> AK_ON_OBJECTS_PUB.G_OLD_FILE_FORMAT_VER15) then

2302: l_file_version <> AK_ON_OBJECTS_PUB.G_OLD_FILE_FORMAT_VER10 and
2303: l_file_version <> AK_ON_OBJECTS_PUB.G_OLD_FILE_FORMAT_VER11 and
2304: l_file_version <> AK_ON_OBJECTS_PUB.G_OLD_FILE_FORMAT_VER12 and
2305: l_file_version <> AK_ON_OBJECTS_PUB.G_OLD_FILE_FORMAT_VER14 and
2306: l_file_version <> AK_ON_OBJECTS_PUB.G_OLD_FILE_FORMAT_VER15) then
2307: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2308: FND_MESSAGE.SET_NAME('AK','AK_WRONG_FILE_VERSION');
2309: FND_MSG_PUB.Add;
2310: end if;

Line 3022: p_buffer OUT NOCOPY AK_ON_OBJECTS_PUB.Buffer_Type,

3018: --=======================================================
3019: procedure READ_LINE (
3020: p_return_status OUT NOCOPY VARCHAR2,
3021: p_index IN OUT NOCOPY Number,
3022: p_buffer OUT NOCOPY AK_ON_OBJECTS_PUB.Buffer_Type,
3023: p_lines_read OUT NOCOPY number,
3024: p_eof_flag OUT NOCOPY VARCHAR2,
3025: p_upl_loader_cur IN OUT NOCOPY AK_ON_OBJECTS_PUB.LoaderCurTyp
3026: )

Line 3025: p_upl_loader_cur IN OUT NOCOPY AK_ON_OBJECTS_PUB.LoaderCurTyp

3021: p_index IN OUT NOCOPY Number,
3022: p_buffer OUT NOCOPY AK_ON_OBJECTS_PUB.Buffer_Type,
3023: p_lines_read OUT NOCOPY number,
3024: p_eof_flag OUT NOCOPY VARCHAR2,
3025: p_upl_loader_cur IN OUT NOCOPY AK_ON_OBJECTS_PUB.LoaderCurTyp
3026: )
3027: is
3028: l_api_name CONSTANT varchar2(30) := 'Read_Line';
3029: l_buffer AK_ON_OBJECTS_PUB.Buffer_Type;

Line 3029: l_buffer AK_ON_OBJECTS_PUB.Buffer_Type;

3025: p_upl_loader_cur IN OUT NOCOPY AK_ON_OBJECTS_PUB.LoaderCurTyp
3026: )
3027: is
3028: l_api_name CONSTANT varchar2(30) := 'Read_Line';
3029: l_buffer AK_ON_OBJECTS_PUB.Buffer_Type;
3030: l_cont_buffer AK_ON_OBJECTS_PUB.Buffer_Type;
3031: l_done BOOLEAN := TRUE;
3032: l_lines_read NUMBER := 0;
3033: l_index NUMBER;

Line 3030: l_cont_buffer AK_ON_OBJECTS_PUB.Buffer_Type;

3026: )
3027: is
3028: l_api_name CONSTANT varchar2(30) := 'Read_Line';
3029: l_buffer AK_ON_OBJECTS_PUB.Buffer_Type;
3030: l_cont_buffer AK_ON_OBJECTS_PUB.Buffer_Type;
3031: l_done BOOLEAN := TRUE;
3032: l_lines_read NUMBER := 0;
3033: l_index NUMBER;
3034: l_return_status VARCHAR2(1);

Line 3180: l_file_version := AK_ON_OBJECTS_PUB.G_UPLOAD_FILE_VERSION;

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
3182: l_file_version = AK_ON_OBJECTS_PUB.G_OLD_FILE_FORMAT_VER2 or
3183: l_file_version = AK_ON_OBJECTS_PUB.G_OLD_FILE_FORMAT_VER3 or
3184: l_file_version = AK_ON_OBJECTS_PUB.G_OLD_FILE_FORMAT_VER4 or

Line 3181: if ( l_file_version = AK_ON_OBJECTS_PUB.G_OLD_FILE_FORMAT_VER1 or

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
3182: l_file_version = AK_ON_OBJECTS_PUB.G_OLD_FILE_FORMAT_VER2 or
3183: l_file_version = AK_ON_OBJECTS_PUB.G_OLD_FILE_FORMAT_VER3 or
3184: l_file_version = AK_ON_OBJECTS_PUB.G_OLD_FILE_FORMAT_VER4 or
3185: l_file_version = AK_ON_OBJECTS_PUB.G_OLD_FILE_FORMAT_VER5 or

Line 3182: l_file_version = AK_ON_OBJECTS_PUB.G_OLD_FILE_FORMAT_VER2 or

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
3182: l_file_version = AK_ON_OBJECTS_PUB.G_OLD_FILE_FORMAT_VER2 or
3183: l_file_version = AK_ON_OBJECTS_PUB.G_OLD_FILE_FORMAT_VER3 or
3184: l_file_version = AK_ON_OBJECTS_PUB.G_OLD_FILE_FORMAT_VER4 or
3185: l_file_version = AK_ON_OBJECTS_PUB.G_OLD_FILE_FORMAT_VER5 or
3186: l_file_version = AK_ON_OBJECTS_PUB.G_OLD_FILE_FORMAT_VER6 or

Line 3183: l_file_version = AK_ON_OBJECTS_PUB.G_OLD_FILE_FORMAT_VER3 or

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
3182: l_file_version = AK_ON_OBJECTS_PUB.G_OLD_FILE_FORMAT_VER2 or
3183: l_file_version = AK_ON_OBJECTS_PUB.G_OLD_FILE_FORMAT_VER3 or
3184: l_file_version = AK_ON_OBJECTS_PUB.G_OLD_FILE_FORMAT_VER4 or
3185: l_file_version = AK_ON_OBJECTS_PUB.G_OLD_FILE_FORMAT_VER5 or
3186: l_file_version = AK_ON_OBJECTS_PUB.G_OLD_FILE_FORMAT_VER6 or
3187: l_file_version = AK_ON_OBJECTS_PUB.G_OLD_FILE_FORMAT_VER7 or

Line 3184: l_file_version = AK_ON_OBJECTS_PUB.G_OLD_FILE_FORMAT_VER4 or

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
3182: l_file_version = AK_ON_OBJECTS_PUB.G_OLD_FILE_FORMAT_VER2 or
3183: l_file_version = AK_ON_OBJECTS_PUB.G_OLD_FILE_FORMAT_VER3 or
3184: l_file_version = AK_ON_OBJECTS_PUB.G_OLD_FILE_FORMAT_VER4 or
3185: l_file_version = AK_ON_OBJECTS_PUB.G_OLD_FILE_FORMAT_VER5 or
3186: l_file_version = AK_ON_OBJECTS_PUB.G_OLD_FILE_FORMAT_VER6 or
3187: l_file_version = AK_ON_OBJECTS_PUB.G_OLD_FILE_FORMAT_VER7 or
3188: l_file_version = AK_ON_OBJECTS_PUB.G_OLD_FILE_FORMAT_VER8 or

Line 3185: l_file_version = AK_ON_OBJECTS_PUB.G_OLD_FILE_FORMAT_VER5 or

3181: if ( l_file_version = AK_ON_OBJECTS_PUB.G_OLD_FILE_FORMAT_VER1 or
3182: l_file_version = AK_ON_OBJECTS_PUB.G_OLD_FILE_FORMAT_VER2 or
3183: l_file_version = AK_ON_OBJECTS_PUB.G_OLD_FILE_FORMAT_VER3 or
3184: l_file_version = AK_ON_OBJECTS_PUB.G_OLD_FILE_FORMAT_VER4 or
3185: l_file_version = AK_ON_OBJECTS_PUB.G_OLD_FILE_FORMAT_VER5 or
3186: l_file_version = AK_ON_OBJECTS_PUB.G_OLD_FILE_FORMAT_VER6 or
3187: l_file_version = AK_ON_OBJECTS_PUB.G_OLD_FILE_FORMAT_VER7 or
3188: l_file_version = AK_ON_OBJECTS_PUB.G_OLD_FILE_FORMAT_VER8 or
3189: l_file_version = AK_ON_OBJECTS_PUB.G_OLD_FILE_FORMAT_VER9 or

Line 3186: l_file_version = AK_ON_OBJECTS_PUB.G_OLD_FILE_FORMAT_VER6 or

3182: l_file_version = AK_ON_OBJECTS_PUB.G_OLD_FILE_FORMAT_VER2 or
3183: l_file_version = AK_ON_OBJECTS_PUB.G_OLD_FILE_FORMAT_VER3 or
3184: l_file_version = AK_ON_OBJECTS_PUB.G_OLD_FILE_FORMAT_VER4 or
3185: l_file_version = AK_ON_OBJECTS_PUB.G_OLD_FILE_FORMAT_VER5 or
3186: l_file_version = AK_ON_OBJECTS_PUB.G_OLD_FILE_FORMAT_VER6 or
3187: l_file_version = AK_ON_OBJECTS_PUB.G_OLD_FILE_FORMAT_VER7 or
3188: l_file_version = AK_ON_OBJECTS_PUB.G_OLD_FILE_FORMAT_VER8 or
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

Line 3187: l_file_version = AK_ON_OBJECTS_PUB.G_OLD_FILE_FORMAT_VER7 or

3183: l_file_version = AK_ON_OBJECTS_PUB.G_OLD_FILE_FORMAT_VER3 or
3184: l_file_version = AK_ON_OBJECTS_PUB.G_OLD_FILE_FORMAT_VER4 or
3185: l_file_version = AK_ON_OBJECTS_PUB.G_OLD_FILE_FORMAT_VER5 or
3186: l_file_version = AK_ON_OBJECTS_PUB.G_OLD_FILE_FORMAT_VER6 or
3187: l_file_version = AK_ON_OBJECTS_PUB.G_OLD_FILE_FORMAT_VER7 or
3188: l_file_version = AK_ON_OBJECTS_PUB.G_OLD_FILE_FORMAT_VER8 or
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

Line 3188: l_file_version = AK_ON_OBJECTS_PUB.G_OLD_FILE_FORMAT_VER8 or

3184: l_file_version = AK_ON_OBJECTS_PUB.G_OLD_FILE_FORMAT_VER4 or
3185: l_file_version = AK_ON_OBJECTS_PUB.G_OLD_FILE_FORMAT_VER5 or
3186: l_file_version = AK_ON_OBJECTS_PUB.G_OLD_FILE_FORMAT_VER6 or
3187: l_file_version = AK_ON_OBJECTS_PUB.G_OLD_FILE_FORMAT_VER7 or
3188: l_file_version = AK_ON_OBJECTS_PUB.G_OLD_FILE_FORMAT_VER8 or
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

Line 3189: l_file_version = AK_ON_OBJECTS_PUB.G_OLD_FILE_FORMAT_VER9 or

3185: l_file_version = AK_ON_OBJECTS_PUB.G_OLD_FILE_FORMAT_VER5 or
3186: l_file_version = AK_ON_OBJECTS_PUB.G_OLD_FILE_FORMAT_VER6 or
3187: l_file_version = AK_ON_OBJECTS_PUB.G_OLD_FILE_FORMAT_VER7 or
3188: l_file_version = AK_ON_OBJECTS_PUB.G_OLD_FILE_FORMAT_VER8 or
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

Line 3190: l_file_version = AK_ON_OBJECTS_PUB.G_OLD_FILE_FORMAT_VER10 or

3186: l_file_version = AK_ON_OBJECTS_PUB.G_OLD_FILE_FORMAT_VER6 or
3187: l_file_version = AK_ON_OBJECTS_PUB.G_OLD_FILE_FORMAT_VER7 or
3188: l_file_version = AK_ON_OBJECTS_PUB.G_OLD_FILE_FORMAT_VER8 or
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;

Line 3191: l_file_version = AK_ON_OBJECTS_PUB.G_OLD_FILE_FORMAT_VER11 or

3187: l_file_version = AK_ON_OBJECTS_PUB.G_OLD_FILE_FORMAT_VER7 or
3188: l_file_version = AK_ON_OBJECTS_PUB.G_OLD_FILE_FORMAT_VER8 or
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

Line 3192: l_file_version = AK_ON_OBJECTS_PUB.G_OLD_FILE_FORMAT_VER12) then

3188: l_file_version = AK_ON_OBJECTS_PUB.G_OLD_FILE_FORMAT_VER8 or
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

Line 3207: elsif ( l_file_version = AK_ON_OBJECTS_PUB.G_OLD_FILE_FORMAT_VER15 or

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
3210: p_created_by := 2;
3211: p_creation_date := AK_UPLOAD_GRP.G_UPLOAD_DATE;

Line 3208: l_file_version = AK_ON_OBJECTS_PUB.G_OLD_FILE_FORMAT_VER14) then

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
3210: p_created_by := 2;
3211: p_creation_date := AK_UPLOAD_GRP.G_UPLOAD_DATE;
3212: p_last_updated_by := 2;

Line 3306: l_file_version := AK_ON_OBJECTS_PUB.G_UPLOAD_FILE_VERSION;

3302: l_last_updated_by number;
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';

Line 3315: if (l_file_version = AK_ON_OBJECTS_PUB.G_FILE_FORMAT_VER and

3311: else
3312: l_custom_mode := 'INVALID';
3313: end if;
3314: -- IF VERSION 120.1 OR GREATER USE FND_LOAD_UTIL COMPARISON LOGIC
3315: if (l_file_version = AK_ON_OBJECTS_PUB.G_FILE_FORMAT_VER and
3316: (p_create_or_update = 'UPDATE' or p_create_or_update = 'FORCE')) then
3317: if FND_LOAD_UTIL.UPLOAD_TEST (
3318: p_file_id => p_last_updated_by,
3319: p_file_lud => p_last_update_date,

Line 3330: elsif (l_file_version <> AK_ON_OBJECTS_PUB.G_FILE_FORMAT_VER) then

3326: return FALSE;
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;

Line 3362: (l_file_version = AK_ON_OBJECTS_PUB.G_OLD_FILE_FORMAT_VER15 or

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
3366: ( l_file_version = AK_ON_OBJECTS_PUB.G_OLD_FILE_FORMAT_VER1 or

Line 3363: l_file_version = AK_ON_OBJECTS_PUB.G_OLD_FILE_FORMAT_VER14) and

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
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

Line 3366: ( l_file_version = AK_ON_OBJECTS_PUB.G_OLD_FILE_FORMAT_VER1 or

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
3370: l_file_version = AK_ON_OBJECTS_PUB.G_OLD_FILE_FORMAT_VER5 or

Line 3367: l_file_version = AK_ON_OBJECTS_PUB.G_OLD_FILE_FORMAT_VER2 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
3370: l_file_version = AK_ON_OBJECTS_PUB.G_OLD_FILE_FORMAT_VER5 or
3371: l_file_version = AK_ON_OBJECTS_PUB.G_OLD_FILE_FORMAT_VER6 or

Line 3368: l_file_version = AK_ON_OBJECTS_PUB.G_OLD_FILE_FORMAT_VER3 or

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
3370: l_file_version = AK_ON_OBJECTS_PUB.G_OLD_FILE_FORMAT_VER5 or
3371: l_file_version = AK_ON_OBJECTS_PUB.G_OLD_FILE_FORMAT_VER6 or
3372: l_file_version = AK_ON_OBJECTS_PUB.G_OLD_FILE_FORMAT_VER7 or

Line 3369: l_file_version = AK_ON_OBJECTS_PUB.G_OLD_FILE_FORMAT_VER4 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
3370: l_file_version = AK_ON_OBJECTS_PUB.G_OLD_FILE_FORMAT_VER5 or
3371: l_file_version = AK_ON_OBJECTS_PUB.G_OLD_FILE_FORMAT_VER6 or
3372: l_file_version = AK_ON_OBJECTS_PUB.G_OLD_FILE_FORMAT_VER7 or
3373: l_file_version = AK_ON_OBJECTS_PUB.G_OLD_FILE_FORMAT_VER8 or

Line 3370: l_file_version = AK_ON_OBJECTS_PUB.G_OLD_FILE_FORMAT_VER5 or

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
3370: l_file_version = AK_ON_OBJECTS_PUB.G_OLD_FILE_FORMAT_VER5 or
3371: l_file_version = AK_ON_OBJECTS_PUB.G_OLD_FILE_FORMAT_VER6 or
3372: l_file_version = AK_ON_OBJECTS_PUB.G_OLD_FILE_FORMAT_VER7 or
3373: l_file_version = AK_ON_OBJECTS_PUB.G_OLD_FILE_FORMAT_VER8 or
3374: l_file_version = AK_ON_OBJECTS_PUB.G_OLD_FILE_FORMAT_VER9 or

Line 3371: l_file_version = AK_ON_OBJECTS_PUB.G_OLD_FILE_FORMAT_VER6 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
3370: l_file_version = AK_ON_OBJECTS_PUB.G_OLD_FILE_FORMAT_VER5 or
3371: l_file_version = AK_ON_OBJECTS_PUB.G_OLD_FILE_FORMAT_VER6 or
3372: l_file_version = AK_ON_OBJECTS_PUB.G_OLD_FILE_FORMAT_VER7 or
3373: l_file_version = AK_ON_OBJECTS_PUB.G_OLD_FILE_FORMAT_VER8 or
3374: l_file_version = AK_ON_OBJECTS_PUB.G_OLD_FILE_FORMAT_VER9 or
3375: l_file_version = AK_ON_OBJECTS_PUB.G_OLD_FILE_FORMAT_VER10 or

Line 3372: l_file_version = AK_ON_OBJECTS_PUB.G_OLD_FILE_FORMAT_VER7 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
3370: l_file_version = AK_ON_OBJECTS_PUB.G_OLD_FILE_FORMAT_VER5 or
3371: l_file_version = AK_ON_OBJECTS_PUB.G_OLD_FILE_FORMAT_VER6 or
3372: l_file_version = AK_ON_OBJECTS_PUB.G_OLD_FILE_FORMAT_VER7 or
3373: l_file_version = AK_ON_OBJECTS_PUB.G_OLD_FILE_FORMAT_VER8 or
3374: l_file_version = AK_ON_OBJECTS_PUB.G_OLD_FILE_FORMAT_VER9 or
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

Line 3373: l_file_version = AK_ON_OBJECTS_PUB.G_OLD_FILE_FORMAT_VER8 or

3369: l_file_version = AK_ON_OBJECTS_PUB.G_OLD_FILE_FORMAT_VER4 or
3370: l_file_version = AK_ON_OBJECTS_PUB.G_OLD_FILE_FORMAT_VER5 or
3371: l_file_version = AK_ON_OBJECTS_PUB.G_OLD_FILE_FORMAT_VER6 or
3372: l_file_version = AK_ON_OBJECTS_PUB.G_OLD_FILE_FORMAT_VER7 or
3373: l_file_version = AK_ON_OBJECTS_PUB.G_OLD_FILE_FORMAT_VER8 or
3374: l_file_version = AK_ON_OBJECTS_PUB.G_OLD_FILE_FORMAT_VER9 or
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

Line 3374: l_file_version = AK_ON_OBJECTS_PUB.G_OLD_FILE_FORMAT_VER9 or

3370: l_file_version = AK_ON_OBJECTS_PUB.G_OLD_FILE_FORMAT_VER5 or
3371: l_file_version = AK_ON_OBJECTS_PUB.G_OLD_FILE_FORMAT_VER6 or
3372: l_file_version = AK_ON_OBJECTS_PUB.G_OLD_FILE_FORMAT_VER7 or
3373: l_file_version = AK_ON_OBJECTS_PUB.G_OLD_FILE_FORMAT_VER8 or
3374: l_file_version = AK_ON_OBJECTS_PUB.G_OLD_FILE_FORMAT_VER9 or
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

Line 3375: l_file_version = AK_ON_OBJECTS_PUB.G_OLD_FILE_FORMAT_VER10 or

3371: l_file_version = AK_ON_OBJECTS_PUB.G_OLD_FILE_FORMAT_VER6 or
3372: l_file_version = AK_ON_OBJECTS_PUB.G_OLD_FILE_FORMAT_VER7 or
3373: l_file_version = AK_ON_OBJECTS_PUB.G_OLD_FILE_FORMAT_VER8 or
3374: l_file_version = AK_ON_OBJECTS_PUB.G_OLD_FILE_FORMAT_VER9 or
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)

Line 3376: l_file_version = AK_ON_OBJECTS_PUB.G_OLD_FILE_FORMAT_VER11 or

3372: l_file_version = AK_ON_OBJECTS_PUB.G_OLD_FILE_FORMAT_VER7 or
3373: l_file_version = AK_ON_OBJECTS_PUB.G_OLD_FILE_FORMAT_VER8 or
3374: l_file_version = AK_ON_OBJECTS_PUB.G_OLD_FILE_FORMAT_VER9 or
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

Line 3377: l_file_version = AK_ON_OBJECTS_PUB.G_OLD_FILE_FORMAT_VER12) and

3373: l_file_version = AK_ON_OBJECTS_PUB.G_OLD_FILE_FORMAT_VER8 or
3374: l_file_version = AK_ON_OBJECTS_PUB.G_OLD_FILE_FORMAT_VER9 or
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;

Line 3420: p_buffer_tbl IN AK_ON_OBJECTS_PUB.Buffer_Tbl_Type,

3416: -- contents in the PL/SQL table.
3417: --=======================================================
3418: procedure WRITE_FILE (
3419: p_return_status OUT NOCOPY VARCHAR2,
3420: p_buffer_tbl IN AK_ON_OBJECTS_PUB.Buffer_Tbl_Type,
3421: p_write_mode IN VARCHAR2 := AK_ON_OBJECTS_PUB.G_APPEND
3422: ) is
3423: l_api_name CONSTANT varchar2(30) := 'Write_File';
3424: l_buf_len NUMBER;

Line 3421: p_write_mode IN VARCHAR2 := AK_ON_OBJECTS_PUB.G_APPEND

3417: --=======================================================
3418: procedure WRITE_FILE (
3419: p_return_status OUT NOCOPY VARCHAR2,
3420: p_buffer_tbl IN AK_ON_OBJECTS_PUB.Buffer_Tbl_Type,
3421: p_write_mode IN VARCHAR2 := AK_ON_OBJECTS_PUB.G_APPEND
3422: ) is
3423: l_api_name CONSTANT varchar2(30) := 'Write_File';
3424: l_buf_len NUMBER;
3425: l_buf_written NUMBER := 0;

Line 3444: if (p_write_mode <> AK_ON_OBJECTS_PUB.G_APPEND) and

3440:
3441: --
3442: -- indicate error if write mode is not G_APPEND or G_OVERWRITE
3443: --
3444: if (p_write_mode <> AK_ON_OBJECTS_PUB.G_APPEND) and
3445: (p_write_mode <> AK_ON_OBJECTS_PUB.G_OVERWRITE) then
3446: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then
3447: FND_MESSAGE.SET_NAME('AK','AK_INVALID_WRITE_MODE');
3448: FND_MSG_PUB.Add;

Line 3445: (p_write_mode <> AK_ON_OBJECTS_PUB.G_OVERWRITE) then

3441: --
3442: -- indicate error if write mode is not G_APPEND or G_OVERWRITE
3443: --
3444: if (p_write_mode <> AK_ON_OBJECTS_PUB.G_APPEND) and
3445: (p_write_mode <> AK_ON_OBJECTS_PUB.G_OVERWRITE) then
3446: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then
3447: FND_MESSAGE.SET_NAME('AK','AK_INVALID_WRITE_MODE');
3448: FND_MSG_PUB.Add;
3449: end if;

Line 3455: if (p_write_mode = AK_ON_OBJECTS_PUB.G_OVERWRITE AND AK_DOWNLOAD_GRP.G_WRITE_HEADER) then

3451: end if;
3452:
3453: -- If it's append mode, start appending to the end of the global table
3454: --
3455: if (p_write_mode = AK_ON_OBJECTS_PUB.G_OVERWRITE AND AK_DOWNLOAD_GRP.G_WRITE_HEADER) then
3456: G_TBL_INDEX := 0;
3457: end if;
3458:
3459: --

Line 3547: p_buffer_tbl IN AK_ON_OBJECTS_PUB.Buffer_Tbl_Type,

3543: -- contents in the PL/SQL table.
3544: --=======================================================
3545: procedure WRITE_LOG_FILE (
3546: p_return_status OUT NOCOPY VARCHAR2,
3547: p_buffer_tbl IN AK_ON_OBJECTS_PUB.Buffer_Tbl_Type,
3548: p_write_mode IN VARCHAR2 := AK_ON_OBJECTS_PUB.G_APPEND
3549: ) is
3550: l_api_name CONSTANT varchar2(30) := 'Write_File';
3551: l_buf_len NUMBER;

Line 3548: p_write_mode IN VARCHAR2 := AK_ON_OBJECTS_PUB.G_APPEND

3544: --=======================================================
3545: procedure WRITE_LOG_FILE (
3546: p_return_status OUT NOCOPY VARCHAR2,
3547: p_buffer_tbl IN AK_ON_OBJECTS_PUB.Buffer_Tbl_Type,
3548: p_write_mode IN VARCHAR2 := AK_ON_OBJECTS_PUB.G_APPEND
3549: ) is
3550: l_api_name CONSTANT varchar2(30) := 'Write_File';
3551: l_buf_len NUMBER;
3552: l_buf_written NUMBER := 0;

Line 3570: if (p_write_mode <> AK_ON_OBJECTS_PUB.G_APPEND) and

3566:
3567: --
3568: -- indicate error if write mode is not G_APPEND or G_OVERWRITE
3569: --
3570: if (p_write_mode <> AK_ON_OBJECTS_PUB.G_APPEND) and
3571: (p_write_mode <> AK_ON_OBJECTS_PUB.G_OVERWRITE) then
3572: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then
3573: FND_MESSAGE.SET_NAME('AK','AK_INVALID_WRITE_MODE');
3574: FND_MSG_PUB.Add;

Line 3571: (p_write_mode <> AK_ON_OBJECTS_PUB.G_OVERWRITE) then

3567: --
3568: -- indicate error if write mode is not G_APPEND or G_OVERWRITE
3569: --
3570: if (p_write_mode <> AK_ON_OBJECTS_PUB.G_APPEND) and
3571: (p_write_mode <> AK_ON_OBJECTS_PUB.G_OVERWRITE) then
3572: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then
3573: FND_MESSAGE.SET_NAME('AK','AK_INVALID_WRITE_MODE');
3574: FND_MSG_PUB.Add;
3575: end if;

Line 3581: if (p_write_mode = AK_ON_OBJECTS_PUB.G_APPEND) then

3577: end if;
3578:
3579: -- If it's append mode, start appending to the end of the global table
3580: --
3581: if (p_write_mode = AK_ON_OBJECTS_PUB.G_APPEND) then
3582: l_tbl_index := G_LOG_BUFFER_TBL.count;
3583: else
3584: l_tbl_index := 0;
3585: end if;