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_QUERYOBJ_PVT dependencies on AK_ON_OBJECTS_PUB

Line 43: l_databuffer_tbl AK_ON_OBJECTS_PUB.Buffer_Tbl_Type;

39: where query_code = param_query_code
40: order by seq_num;
41:
42: l_api_name CONSTANT varchar2(30) := 'Write_lines_to_buffer';
43: l_databuffer_tbl AK_ON_OBJECTS_PUB.Buffer_Tbl_Type;
44: l_index NUMBER;
45: l_queryobj_lines_rec AK_QUERY_OBJECT_LINES%ROWTYPE;
46: l_return_status varchar2(1);
47: l_line_count NUMBER := 0;

Line 98: AK_ON_OBJECTS_PUB.G_DATE_FORMAT) || '"';

94: nvl(to_char(l_queryobj_lines_rec.created_by),'""');
95: l_index := l_index + 1;
96: l_databuffer_tbl(l_index) := ' CREATION_DATE = "' ||
97: to_char(l_queryobj_lines_rec.creation_date,
98: AK_ON_OBJECTS_PUB.G_DATE_FORMAT) || '"';
99: l_index := l_index + 1;
100: -- CHANGED TO OWNER FOR R12
101: -- l_databuffer_tbl(l_index) := ' LAST_UPDATED_BY = ' ||
102: -- nvl(to_char(l_queryobj_lines_rec.last_updated_by),'""');

Line 108: AK_ON_OBJECTS_PUB.G_DATE_FORMAT) || '"';

104: FND_LOAD_UTIL.OWNER_NAME(l_queryobj_lines_rec.last_updated_by) || '"';
105: l_index := l_index + 1;
106: l_databuffer_tbl(l_index) := ' LAST_UPDATE_DATE = "' ||
107: to_char(l_queryobj_lines_rec.last_update_date,
108: AK_ON_OBJECTS_PUB.G_DATE_FORMAT) || '"';
109: l_index := l_index + 1;
110: l_databuffer_tbl(l_index) := ' LAST_UPDATE_LOGIN = ' ||
111: nvl(to_char(l_queryobj_lines_rec.last_update_login),'""');
112:

Line 122: p_write_mode => AK_ON_OBJECTS_PUB.G_APPEND

118: -- - Write object data out to the specified file
119: AK_ON_OBJECTS_PVT.WRITE_FILE (
120: p_return_status => l_return_status,
121: p_buffer_tbl => l_databuffer_tbl,
122: p_write_mode => AK_ON_OBJECTS_PUB.G_APPEND
123: );
124: -- If API call returns with an error status...
125: if (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) or
126: (l_return_status = FND_API.G_RET_STS_ERROR) then

Line 143: p_write_mode => AK_ON_OBJECTS_PUB.G_APPEND

139: -- - Finish up writing object data out to the specified file
140: AK_ON_OBJECTS_PVT.WRITE_FILE (
141: p_return_status => l_return_status,
142: p_buffer_tbl => l_databuffer_tbl,
143: p_write_mode => AK_ON_OBJECTS_PUB.G_APPEND
144: );
145:
146: -- If API call returns with an error status...
147: if (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) or

Line 227: l_databuffer_tbl AK_ON_OBJECTS_PUB.Buffer_Tbl_Type;

223: from AK_QUERY_OBJECTS
224: where query_code = p_query_code;
225:
226: l_api_name CONSTANT varchar2(30) := 'Write_to_buffer';
227: l_databuffer_tbl AK_ON_OBJECTS_PUB.Buffer_Tbl_Type;
228: l_index NUMBER;
229: l_queryobj_rec AK_QUERY_OBJECTS%ROWTYPE;
230: l_return_status varchar2(1);
231:

Line 264: AK_ON_OBJECTS_PUB.G_DATE_FORMAT) || '"';

260: nvl(to_char(l_queryobj_rec.created_by),'""');
261: l_index := l_index + 1;
262: l_databuffer_tbl(l_index) := ' CREATION_DATE = "' ||
263: to_char(l_queryobj_rec.creation_date,
264: AK_ON_OBJECTS_PUB.G_DATE_FORMAT) || '"';
265: l_index := l_index + 1;
266: -- CHANGED TO OWNER FOR R12
267: -- l_databuffer_tbl(l_index) := ' LAST_UPDATED_BY = ' ||
268: -- nvl(to_char(l_queryobj_rec.last_updated_by),'""');

Line 274: AK_ON_OBJECTS_PUB.G_DATE_FORMAT) || '"';

270: FND_LOAD_UTIL.OWNER_NAME(l_queryobj_rec.last_updated_by) || '"';
271: l_index := l_index + 1;
272: l_databuffer_tbl(l_index) := ' LAST_UPDATE_DATE = "' ||
273: to_char(l_queryobj_rec.last_update_date,
274: AK_ON_OBJECTS_PUB.G_DATE_FORMAT) || '"';
275: l_index := l_index + 1;
276: l_databuffer_tbl(l_index) := ' LAST_UPDATE_LOGIN = ' ||
277: nvl(to_char(l_queryobj_rec.last_update_login),'""');
278:

Line 286: p_write_mode => AK_ON_OBJECTS_PUB.G_APPEND

282: -- - Write object data out to the specified file
283: AK_ON_OBJECTS_PVT.WRITE_FILE (
284: p_return_status => l_return_status,
285: p_buffer_tbl => l_databuffer_tbl,
286: p_write_mode => AK_ON_OBJECTS_PUB.G_APPEND
287: );
288: -- If API call returns with an error status...
289: if (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) or
290: (l_return_status = FND_API.G_RET_STS_ERROR) then

Line 316: p_write_mode => AK_ON_OBJECTS_PUB.G_APPEND

312: -- - Finish up writing object data out to the specified file
313: AK_ON_OBJECTS_PVT.WRITE_FILE (
314: p_return_status => l_return_status,
315: p_buffer_tbl => l_databuffer_tbl,
316: p_write_mode => AK_ON_OBJECTS_PUB.G_APPEND
317: );
318:
319: -- If API call returns with an error status...
320: if (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) or

Line 1495: p_buffer IN AK_ON_OBJECTS_PUB.Buffer_Type,

1491: p_return_status OUT NOCOPY VARCHAR2,
1492: p_index IN OUT NOCOPY NUMBER,
1493: p_loader_timestamp IN DATE,
1494: p_line_num IN NUMBER := FND_API.G_MISS_NUM,
1495: p_buffer IN AK_ON_OBJECTS_PUB.Buffer_Type,
1496: p_line_num_out OUT NOCOPY NUMBER,
1497: p_buffer_out OUT NOCOPY AK_ON_OBJECTS_PUB.Buffer_Type,
1498: p_upl_loader_cur IN OUT NOCOPY AK_ON_OBJECTS_PUB.LoaderCurTyp,
1499: p_pass IN NUMBER := 1 -- we don't need 2 passes for query objects, changed from 2 to 1 to match spec for 9i

Line 1497: p_buffer_out OUT NOCOPY AK_ON_OBJECTS_PUB.Buffer_Type,

1493: p_loader_timestamp IN DATE,
1494: p_line_num IN NUMBER := FND_API.G_MISS_NUM,
1495: p_buffer IN AK_ON_OBJECTS_PUB.Buffer_Type,
1496: p_line_num_out OUT NOCOPY NUMBER,
1497: p_buffer_out OUT NOCOPY AK_ON_OBJECTS_PUB.Buffer_Type,
1498: p_upl_loader_cur IN OUT NOCOPY AK_ON_OBJECTS_PUB.LoaderCurTyp,
1499: p_pass IN NUMBER := 1 -- we don't need 2 passes for query objects, changed from 2 to 1 to match spec for 9i
1500: ) is
1501: l_api_version_number CONSTANT number := 1.0;

Line 1498: p_upl_loader_cur IN OUT NOCOPY AK_ON_OBJECTS_PUB.LoaderCurTyp,

1494: p_line_num IN NUMBER := FND_API.G_MISS_NUM,
1495: p_buffer IN AK_ON_OBJECTS_PUB.Buffer_Type,
1496: p_line_num_out OUT NOCOPY NUMBER,
1497: p_buffer_out OUT NOCOPY AK_ON_OBJECTS_PUB.Buffer_Type,
1498: p_upl_loader_cur IN OUT NOCOPY AK_ON_OBJECTS_PUB.LoaderCurTyp,
1499: p_pass IN NUMBER := 1 -- we don't need 2 passes for query objects, changed from 2 to 1 to match spec for 9i
1500: ) is
1501: l_api_version_number CONSTANT number := 1.0;
1502: l_api_name CONSTANT varchar2(30) := 'Upload_queryobj';

Line 1506: l_buffer AK_ON_OBJECTS_PUB.Buffer_Type;

1502: l_api_name CONSTANT varchar2(30) := 'Upload_queryobj';
1503: l_line_index NUMBER := 0;
1504: l_line_rec ak_query_object_lines%ROWTYPE;
1505: l_line_tbl AK_queryobj_PUB.queryobj_lines_Tbl_Type;
1506: l_buffer AK_ON_OBJECTS_PUB.Buffer_Type;
1507: l_column varchar2(30);
1508: l_dummy NUMBER;
1509: l_eof_flag VARCHAR2(1);
1510: l_index NUMBER;

Line 1520: l_saved_token AK_ON_OBJECTS_PUB.Buffer_Type;

1516: l_query_index NUMBER := 0;
1517: l_query_rec ak_query_objects%ROWTYPE;
1518: l_query_tbl AK_QUERYOBJ_PUB.queryobj_Tbl_Type;
1519: l_return_status varchar2(1);
1520: l_saved_token AK_ON_OBJECTS_PUB.Buffer_Type;
1521: l_state NUMBER;
1522: l_token AK_ON_OBJECTS_PUB.Buffer_Type;
1523: l_value_count NUMBER;
1524: l_copy_redo_flag BOOLEAN := FALSE;

Line 1522: l_token AK_ON_OBJECTS_PUB.Buffer_Type;

1518: l_query_tbl AK_QUERYOBJ_PUB.queryobj_Tbl_Type;
1519: l_return_status varchar2(1);
1520: l_saved_token AK_ON_OBJECTS_PUB.Buffer_Type;
1521: l_state NUMBER;
1522: l_token AK_ON_OBJECTS_PUB.Buffer_Type;
1523: l_value_count NUMBER;
1524: l_copy_redo_flag BOOLEAN := FALSE;
1525: l_user_id1 NUMBER;
1526: l_user_id2 NUMBER;

Line 1693: if (l_value_count > AK_ON_OBJECTS_PUB.G_MAX_NUM_LOADER_VALUES) or

1689: --
1690: if (l_value_count = 2) then
1691: l_saved_token := l_token;
1692: end if;
1693: if (l_value_count > AK_ON_OBJECTS_PUB.G_MAX_NUM_LOADER_VALUES) or
1694: (l_value_count is null) then
1695: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1696: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR_EFIELD');
1697: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));

Line 1733: AK_ON_OBJECTS_PUB.G_DATE_FORMAT);

1729: l_query_rec.created_by := to_number(l_token);
1730: l_state := 10;
1731: elsif (l_column = 'CREATION_DATE') then
1732: l_query_rec.creation_date := to_date(l_token,
1733: AK_ON_OBJECTS_PUB.G_DATE_FORMAT);
1734: l_state := 10;
1735: elsif (l_column = 'LAST_UPDATED_BY') then
1736: l_query_rec.last_updated_by := to_number(l_token);
1737: l_state := 10;

Line 1743: AK_ON_OBJECTS_PUB.G_DATE_FORMAT);

1739: l_query_rec.last_updated_by := FND_LOAD_UTIL.OWNER_ID(l_token);
1740: l_state := 10;
1741: elsif (l_column = 'LAST_UPDATE_DATE') then
1742: l_query_rec.last_update_date := to_date(l_token,
1743: AK_ON_OBJECTS_PUB.G_DATE_FORMAT);
1744: l_state := 10;
1745: elsif (l_column = 'LAST_UPDATE_LOGIN') then
1746: l_query_rec.last_update_login := to_number(l_token);
1747: l_state := 10;

Line 1838: if (l_value_count > AK_ON_OBJECTS_PUB.G_MAX_NUM_LOADER_VALUES) or

1834: --
1835: if (l_value_count = 2) then
1836: l_saved_token := l_token;
1837: end if;
1838: if (l_value_count > AK_ON_OBJECTS_PUB.G_MAX_NUM_LOADER_VALUES) or
1839: (l_value_count is null) then
1840: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1841: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR_EFIELD');
1842: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));

Line 1883: AK_ON_OBJECTS_PUB.G_DATE_FORMAT);

1879: l_line_rec.created_by := to_number(l_token);
1880: l_state := 30;
1881: elsif (l_column = 'CREATION_DATE') then
1882: l_line_rec.creation_date := to_date(l_token,
1883: AK_ON_OBJECTS_PUB.G_DATE_FORMAT);
1884: l_state := 30;
1885: elsif (l_column = 'LAST_UPDATED_BY') then
1886: l_line_rec.last_updated_by := to_number(l_token);
1887: l_state := 30;

Line 1893: AK_ON_OBJECTS_PUB.G_DATE_FORMAT);

1889: l_line_rec.last_updated_by := FND_LOAD_UTIL.OWNER_ID(l_token);
1890: l_state := 30;
1891: elsif (l_column = 'LAST_UPDATE_DATE') then
1892: l_line_rec.last_update_date := to_date(l_token,
1893: AK_ON_OBJECTS_PUB.G_DATE_FORMAT);
1894: l_state := 30;
1895: elsif (l_column = 'LAST_UPDATE_LOGIN') then
1896: l_line_rec.last_update_login := to_number(l_token);
1897: l_state := 30;