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_PVT

Line 84: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(l_queryobj_lines_rec.query_line_type)||'"';

80:
81: l_databuffer_tbl(l_index) := ' BEGIN QUERY_OBJECT_LINE '||nvl(to_char(l_queryobj_lines_rec.seq_num),'""');
82: l_index := l_index + 1;
83: l_databuffer_tbl(l_index) := ' QUERY_LINE_TYPE = "' ||
84: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(l_queryobj_lines_rec.query_line_type)||'"';
85: l_index := l_index + 1;
86: l_databuffer_tbl(l_index) := ' QUERY_LINE = "' ||
87: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(l_queryobj_lines_rec.query_line)||'"';
88: l_index := l_index + 1;

Line 87: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(l_queryobj_lines_rec.query_line)||'"';

83: l_databuffer_tbl(l_index) := ' QUERY_LINE_TYPE = "' ||
84: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(l_queryobj_lines_rec.query_line_type)||'"';
85: l_index := l_index + 1;
86: l_databuffer_tbl(l_index) := ' QUERY_LINE = "' ||
87: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(l_queryobj_lines_rec.query_line)||'"';
88: l_index := l_index + 1;
89: l_databuffer_tbl(l_index) := ' LINKED_PARAMETER = "' ||
90: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(l_queryobj_lines_rec.linked_parameter)||'"';
91: -- - Write out who columns

Line 90: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(l_queryobj_lines_rec.linked_parameter)||'"';

86: l_databuffer_tbl(l_index) := ' QUERY_LINE = "' ||
87: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(l_queryobj_lines_rec.query_line)||'"';
88: l_index := l_index + 1;
89: l_databuffer_tbl(l_index) := ' LINKED_PARAMETER = "' ||
90: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(l_queryobj_lines_rec.linked_parameter)||'"';
91: -- - Write out who columns
92: l_index := l_index + 1;
93: l_databuffer_tbl(l_index) := ' CREATED_BY = ' ||
94: nvl(to_char(l_queryobj_lines_rec.created_by),'""');

Line 119: AK_ON_OBJECTS_PVT.WRITE_FILE (

115: l_index := l_index + 1;
116: l_databuffer_tbl(l_index) := ' ';
117:
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: );

Line 140: AK_ON_OBJECTS_PVT.WRITE_FILE (

136: RAISE FND_API.G_EXC_ERROR;
137: end if;
138:
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: );

Line 253: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(l_queryobj_rec.query_code) || '"';

249: -- Write object into buffer
250: l_index := 1;
251:
252: l_databuffer_tbl(l_index) := 'BEGIN QUERY_OBJECT "' ||
253: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(l_queryobj_rec.query_code) || '"';
254: l_index := l_index + 1;
255: l_databuffer_tbl(l_index) := ' APPLICATION_ID = ' ||
256: nvl(to_char(l_queryobj_rec.application_id),'""');
257: -- - Write out who columns

Line 283: AK_ON_OBJECTS_PVT.WRITE_FILE (

279: l_index := l_index + 1;
280: l_databuffer_tbl(l_index) := ' ';
281:
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: );

Line 313: AK_ON_OBJECTS_PVT.WRITE_FILE (

309: l_index := l_index + 1;
310: l_databuffer_tbl(l_index) := ' ';
311:
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: );

Line 780: if AK_ON_OBJECTS_PVT.IS_UPDATEABLE(

776: -- old jlt files didn't have who columns and IS_UPDATEABLE
777: -- calls SET_WHO which populates those columns, for later
778: -- jlt files IS_UPDATEABLE will always return TRUE for CREATE
779:
780: if AK_ON_OBJECTS_PVT.IS_UPDATEABLE(
781: p_loader_timestamp => p_loader_timestamp,
782: p_created_by => l_created_by,
783: p_creation_date => l_creation_date,
784: p_last_updated_by => l_last_updated_by,

Line 967: if AK_ON_OBJECTS_PVT.IS_UPDATEABLE(

963: -- old jlt files didn't have who columns and IS_UPDATEABLE
964: -- calls SET_WHO which populates those columns, for later
965: -- jlt files IS_UPDATEABLE will always return TRUE for CREATE
966:
967: if AK_ON_OBJECTS_PVT.IS_UPDATEABLE(
968: p_loader_timestamp => p_loader_timestamp,
969: p_created_by => l_created_by,
970: p_creation_date => l_creation_date,
971: p_last_updated_by => l_last_updated_by,

Line 1137: if ( NOT AK_ON_OBJECTS_PVT.VALID_APPLICATION_ID (

1133: raise FND_API.G_EXC_ERROR;
1134: end if;
1135: close l_get_query_csr;
1136:
1137: if ( NOT AK_ON_OBJECTS_PVT.VALID_APPLICATION_ID (
1138: p_api_version_number => 1.0,
1139: p_return_status => l_return_status,
1140: p_application_id => p_application_id) ) then
1141: FND_MESSAGE.SET_NAME('AK','AK_INVALID_COLUMN_VALUE');

Line 1171: if AK_ON_OBJECTS_PVT.IS_UPDATEABLE(

1167: end if;
1168:
1169: -- THIS UPDATES NO MATTER WHAT - CALLING IS_UPDATEABLE BECAUSE STILL
1170: -- NECESSARY FOR PRE-12 CODE
1171: if AK_ON_OBJECTS_PVT.IS_UPDATEABLE(
1172: p_loader_timestamp => p_loader_timestamp,
1173: p_created_by => l_created_by,
1174: p_creation_date => l_creation_date,
1175: p_last_updated_by => l_last_updated_by,

Line 1355: if AK_ON_OBJECTS_PVT.IS_UPDATEABLE(

1351: end if;
1352:
1353: -- THIS UPDATES NO MATTER WHAT - CALLING IS_UPDATEABLE BECAUSE STILL
1354: -- NECESSARY FOR PRE-12 CODE
1355: if AK_ON_OBJECTS_PVT.IS_UPDATEABLE(
1356: p_loader_timestamp => p_loader_timestamp,
1357: p_created_by => l_created_by,
1358: p_creation_date => l_creation_date,
1359: p_last_updated_by => l_last_updated_by,

Line 1563: while (l_buffer is null and l_eof_flag = 'N' and p_index <= AK_ON_OBJECTS_PVT.G_UPL_TABLE_NUM) loop

1559: else
1560: l_line_num := p_line_num;
1561: end if;
1562:
1563: while (l_buffer is null and l_eof_flag = 'N' and p_index <= AK_ON_OBJECTS_PVT.G_UPL_TABLE_NUM) loop
1564: AK_ON_OBJECTS_PVT.READ_LINE (
1565: p_return_status => l_return_status,
1566: p_index => p_index,
1567: p_buffer => l_buffer,

Line 1564: AK_ON_OBJECTS_PVT.READ_LINE (

1560: l_line_num := p_line_num;
1561: end if;
1562:
1563: while (l_buffer is null and l_eof_flag = 'N' and p_index <= AK_ON_OBJECTS_PVT.G_UPL_TABLE_NUM) loop
1564: AK_ON_OBJECTS_PVT.READ_LINE (
1565: p_return_status => l_return_status,
1566: p_index => p_index,
1567: p_buffer => l_buffer,
1568: p_lines_read => l_lines_read,

Line 1602: AK_ON_OBJECTS_PVT.GET_TOKEN(

1598:
1599: while (l_eof_flag = 'N') and (l_buffer is not null)
1600: and (l_more_queryobj) loop
1601:
1602: AK_ON_OBJECTS_PVT.GET_TOKEN(
1603: p_return_status => l_return_status,
1604: p_in_buf => l_buffer,
1605: p_token => l_token
1606: );

Line 1645: -- (ak_on_objects_pvt.upload).

1641: l_state := 2;
1642: else
1643: -- Found the beginning of a non-region object,
1644: -- rebuild last line and pass it back to the caller
1645: -- (ak_on_objects_pvt.upload).
1646: p_buffer_out := 'BEGIN ' || l_token || ' ' || l_buffer;
1647: l_more_queryobj := FALSE;
1648: end if;
1649: elsif (l_state = 2) then

Line 1934: while (l_buffer is null and l_eof_flag = 'N' and p_index <= AK_ON_OBJECTS_PVT.G_UPL_TABLE_NUM) loop

1930: l_buffer := LTRIM(l_buffer);
1931:
1932: -- Get the next non-blank, non-comment line if current line is
1933: -- fully parsed
1934: while (l_buffer is null and l_eof_flag = 'N' and p_index <= AK_ON_OBJECTS_PVT.G_UPL_TABLE_NUM) loop
1935: AK_ON_OBJECTS_PVT.READ_LINE (
1936: p_return_status => l_return_status,
1937: p_index => p_index,
1938: p_buffer => l_buffer,

Line 1935: AK_ON_OBJECTS_PVT.READ_LINE (

1931:
1932: -- Get the next non-blank, non-comment line if current line is
1933: -- fully parsed
1934: while (l_buffer is null and l_eof_flag = 'N' and p_index <= AK_ON_OBJECTS_PVT.G_UPL_TABLE_NUM) loop
1935: AK_ON_OBJECTS_PVT.READ_LINE (
1936: p_return_status => l_return_status,
1937: p_index => p_index,
1938: p_buffer => l_buffer,
1939: p_lines_read => l_lines_read,

Line 2016: if AK_ON_OBJECTS_PVT.IS_UPDATEABLE(

2012: from ak_query_objects aqo
2013: where aqo.query_code = l_query_tbl(l_index).query_code
2014: and aqo.application_id = l_query_tbl(l_index).application_id;
2015: /*if ( l_user_id1 = 1 or l_user_id1 = 2 ) then*/
2016: if AK_ON_OBJECTS_PVT.IS_UPDATEABLE(
2017: p_loader_timestamp => p_loader_timestamp,
2018: p_created_by => l_query_tbl(l_index).created_by,
2019: p_creation_date => l_query_tbl(l_index).creation_date,
2020: p_last_updated_by => l_query_tbl(l_index).last_updated_by,

Line 2127: if AK_ON_OBJECTS_PVT.IS_UPDATEABLE(

2123: from ak_query_object_lines aqol
2124: where aqol.query_code = l_line_tbl(l_index).query_code
2125: and aqol.seq_num = l_line_tbl(l_index).seq_num;
2126: /*if ( l_user_id1 = 1 or l_user_id1 = 2 ) then*/
2127: if AK_ON_OBJECTS_PVT.IS_UPDATEABLE(
2128: p_loader_timestamp => p_loader_timestamp,
2129: p_created_by => l_line_tbl(l_index).created_by,
2130: p_creation_date => l_line_tbl(l_index).creation_date,
2131: p_last_updated_by => l_line_tbl(l_index).last_updated_by,