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_PVT

Line 1: package body AK_ON_OBJECTS_PVT as

1: package body AK_ON_OBJECTS_PVT as
2: /* $Header: akdvonb.pls 120.6 2006/08/10 21:23:15 tshort ship $ */
3:
4: --
5: -- Type definitions (only used within this package body)

Line 189: -- AK_ON_OBJECTS_PVT package:

185: -- p_application_id or p_application_short_name must
186: -- be provided.
187: -- p_download_by_object : IN required
188: -- Must be one of the following literal defined in
189: -- AK_ON_OBJECTS_PVT package:
190: -- G_ATTRIBUTE - Caller is DOWNLOAD_ATTRIBUTE API
191: -- G_OBJECT - Caller is DOWNLOAD_OBJECT API
192: -- G_REGION - Caller is DOWNLOAD_REGION API
193: -- G_FLOW - Caller is DOWNLOAD_FLOW API

Line 314: if ( p_download_by_object = AK_ON_OBJECTS_PVT.G_REGION ) then

310: where name = 'db_name';
311:
312: -- determine sub-phase
313: --
314: if ( p_download_by_object = AK_ON_OBJECTS_PVT.G_REGION ) then
315: l_sub_phase := '24';
316: elsif ( p_download_by_object = AK_ON_OBJECTS_PVT.G_FLOW or p_download_by_object = AK_ON_OBJECTS_PVT.G_SECURITY) then
317: l_sub_phase := '20';
318: elsif ( p_download_by_object = AK_ON_OBJECTS_PVT.G_ATTRIBUTE ) then

Line 316: elsif ( p_download_by_object = AK_ON_OBJECTS_PVT.G_FLOW or p_download_by_object = AK_ON_OBJECTS_PVT.G_SECURITY) then

312: -- determine sub-phase
313: --
314: if ( p_download_by_object = AK_ON_OBJECTS_PVT.G_REGION ) then
315: l_sub_phase := '24';
316: elsif ( p_download_by_object = AK_ON_OBJECTS_PVT.G_FLOW or p_download_by_object = AK_ON_OBJECTS_PVT.G_SECURITY) then
317: l_sub_phase := '20';
318: elsif ( p_download_by_object = AK_ON_OBJECTS_PVT.G_ATTRIBUTE ) then
319: l_sub_phase := '16';
320: elsif ( p_download_by_object = AK_ON_OBJECTS_PVT.G_CUSTOM_REGION ) then

Line 318: elsif ( p_download_by_object = AK_ON_OBJECTS_PVT.G_ATTRIBUTE ) then

314: if ( p_download_by_object = AK_ON_OBJECTS_PVT.G_REGION ) then
315: l_sub_phase := '24';
316: elsif ( p_download_by_object = AK_ON_OBJECTS_PVT.G_FLOW or p_download_by_object = AK_ON_OBJECTS_PVT.G_SECURITY) then
317: l_sub_phase := '20';
318: elsif ( p_download_by_object = AK_ON_OBJECTS_PVT.G_ATTRIBUTE ) then
319: l_sub_phase := '16';
320: elsif ( p_download_by_object = AK_ON_OBJECTS_PVT.G_CUSTOM_REGION ) then
321: l_sub_phase := '25';
322: end if;

Line 320: elsif ( p_download_by_object = AK_ON_OBJECTS_PVT.G_CUSTOM_REGION ) then

316: elsif ( p_download_by_object = AK_ON_OBJECTS_PVT.G_FLOW or p_download_by_object = AK_ON_OBJECTS_PVT.G_SECURITY) then
317: l_sub_phase := '20';
318: elsif ( p_download_by_object = AK_ON_OBJECTS_PVT.G_ATTRIBUTE ) then
319: l_sub_phase := '16';
320: elsif ( p_download_by_object = AK_ON_OBJECTS_PVT.G_CUSTOM_REGION ) then
321: l_sub_phase := '25';
322: end if;
323:
324: --

Line 383: if (p_download_by_object in (AK_ON_OBJECTS_PVT.G_OBJECT,

379: -- Check if the Object type is valid values
380: l_index := l_index + 1;
381: l_header_tbl(l_index) := ' ';
382:
383: if (p_download_by_object in (AK_ON_OBJECTS_PVT.G_OBJECT,
384: AK_ON_OBJECTS_PVT.G_REGION, AK_ON_OBJECTS_PVT.G_CUSTOM_REGION,
385: AK_ON_OBJECTS_PVT.G_FLOW, AK_ON_OBJECTS_PVT.G_ATTRIBUTE)) then
386:
387: l_index := l_index + 1;

Line 384: AK_ON_OBJECTS_PVT.G_REGION, AK_ON_OBJECTS_PVT.G_CUSTOM_REGION,

380: l_index := l_index + 1;
381: l_header_tbl(l_index) := ' ';
382:
383: if (p_download_by_object in (AK_ON_OBJECTS_PVT.G_OBJECT,
384: AK_ON_OBJECTS_PVT.G_REGION, AK_ON_OBJECTS_PVT.G_CUSTOM_REGION,
385: AK_ON_OBJECTS_PVT.G_FLOW, AK_ON_OBJECTS_PVT.G_ATTRIBUTE)) then
386:
387: l_index := l_index + 1;
388: l_header_tbl(l_index) := 'DEFINE ATTRIBUTE ';

Line 385: AK_ON_OBJECTS_PVT.G_FLOW, AK_ON_OBJECTS_PVT.G_ATTRIBUTE)) then

381: l_header_tbl(l_index) := ' ';
382:
383: if (p_download_by_object in (AK_ON_OBJECTS_PVT.G_OBJECT,
384: AK_ON_OBJECTS_PVT.G_REGION, AK_ON_OBJECTS_PVT.G_CUSTOM_REGION,
385: AK_ON_OBJECTS_PVT.G_FLOW, AK_ON_OBJECTS_PVT.G_ATTRIBUTE)) then
386:
387: l_index := l_index + 1;
388: l_header_tbl(l_index) := 'DEFINE ATTRIBUTE ';
389: l_index := l_index + 1;

Line 495: if (p_download_by_object in (AK_ON_OBJECTS_PVT.G_OBJECT,

491: l_index := l_index + 1;
492: l_header_tbl(l_index) := ' ';
493:
494: -- Check if the Object type is valid values
495: if (p_download_by_object in (AK_ON_OBJECTS_PVT.G_OBJECT,
496: AK_ON_OBJECTS_PVT.G_REGION, AK_ON_OBJECTS_PVT.G_CUSTOM_REGION,
497: AK_ON_OBJECTS_PVT.G_FLOW)) then
498: l_index := l_index + 1;
499: l_header_tbl(l_index) := 'DEFINE OBJECT';

Line 496: AK_ON_OBJECTS_PVT.G_REGION, AK_ON_OBJECTS_PVT.G_CUSTOM_REGION,

492: l_header_tbl(l_index) := ' ';
493:
494: -- Check if the Object type is valid values
495: if (p_download_by_object in (AK_ON_OBJECTS_PVT.G_OBJECT,
496: AK_ON_OBJECTS_PVT.G_REGION, AK_ON_OBJECTS_PVT.G_CUSTOM_REGION,
497: AK_ON_OBJECTS_PVT.G_FLOW)) then
498: l_index := l_index + 1;
499: l_header_tbl(l_index) := 'DEFINE OBJECT';
500: l_index := l_index + 1;

Line 497: AK_ON_OBJECTS_PVT.G_FLOW)) then

493:
494: -- Check if the Object type is valid values
495: if (p_download_by_object in (AK_ON_OBJECTS_PVT.G_OBJECT,
496: AK_ON_OBJECTS_PVT.G_REGION, AK_ON_OBJECTS_PVT.G_CUSTOM_REGION,
497: AK_ON_OBJECTS_PVT.G_FLOW)) then
498: l_index := l_index + 1;
499: l_header_tbl(l_index) := 'DEFINE OBJECT';
500: l_index := l_index + 1;
501: l_header_tbl(l_index) := ' KEY DATABASE_OBJECT_NAME VARCHAR2(30)';

Line 1405: if (p_download_by_object = AK_ON_OBJECTS_PVT.G_CUSTOM_REGION) then

1401: l_index := l_index + 1;
1402: l_header_tbl(l_index) := ' ';
1403: end if;
1404:
1405: if (p_download_by_object = AK_ON_OBJECTS_PVT.G_CUSTOM_REGION) then
1406: l_index := l_index + 1;
1407: l_header_tbl(l_index) := 'DEFINE CUSTOMIZATION';
1408: l_index := l_index + 1;
1409: l_header_tbl(l_index) := ' KEY CUSTOMIZATION_APPLICATION_ID NUMBER(15)';

Line 1560: if (p_download_by_object = AK_ON_OBJECTS_PVT.G_FLOW) then

1556: l_index := l_index + 1;
1557: l_header_tbl(l_index) := ' ';
1558: end if;
1559:
1560: if (p_download_by_object = AK_ON_OBJECTS_PVT.G_FLOW) then
1561: l_index := l_index + 1;
1562: l_header_tbl(l_index) := 'DEFINE FLOW';
1563: l_index := l_index + 1;
1564: l_header_tbl(l_index) := ' KEY FLOW_APPLICATION_ID NUMBER(15)';

Line 1867: if (p_download_by_object = AK_ON_OBJECTS_PVT.G_SECURITY) then

1863:
1864: end if;
1865: end if; -- the first if for checking Attribute, Flow, Region and Object
1866:
1867: if (p_download_by_object = AK_ON_OBJECTS_PVT.G_SECURITY) then
1868: l_index := l_index + 1;
1869: l_header_tbl(l_index) := 'DEFINE EXCLUDED_ITEMS';
1870: l_index := l_index + 1;
1871: l_header_tbl(l_index) := ' KEY RESPONSIBILITY_ID NUMBER(15)';

Line 1920: if (p_download_by_object = AK_ON_OBJECTS_PVT.G_QUERYOBJ) then

1916: l_header_tbl(l_index) := ' ';
1917: end if;
1918:
1919: -- Check if the Object type is valid values
1920: if (p_download_by_object = AK_ON_OBJECTS_PVT.G_QUERYOBJ) then
1921:
1922: l_index := l_index + 1;
1923: l_header_tbl(l_index) := 'DEFINE QUERY_OBJECT';
1924: l_index := l_index + 1;

Line 1974: if (p_download_by_object = AK_ON_OBJECTS_PVT.G_AMPARAM_REGISTRY) then

1970:
1971: end if; -- if G_QUERYOBJ
1972:
1973: -- Check if the Object type is valid values
1974: if (p_download_by_object = AK_ON_OBJECTS_PVT.G_AMPARAM_REGISTRY) then
1975:
1976: l_index := l_index + 1;
1977: l_header_tbl(l_index) := 'DEFINE AMPARAM_REGISTRY';
1978: l_index := l_index + 1;

Line 1999: AK_ON_OBJECTS_PVT.WRITE_FILE (

1995:
1996: --
1997: -- Write the header information out to the flat file
1998: --
1999: AK_ON_OBJECTS_PVT.WRITE_FILE (
2000: p_return_status => l_return_status,
2001: p_buffer_tbl => l_header_tbl,
2002: p_write_mode => AK_ON_OBJECTS_PUB.G_OVERWRITE
2003: );

Line 2132: where session_id = AK_ON_OBJECTS_PVT.G_SESSION_ID

2128: --dbms_output.put_line('**** Processing pass # ' || to_char(l_index) || ' ****');
2129:
2130: -- Open Upload Loader Cursor
2131: OPEN l_upl_loader_cur FOR SELECT TBL_INDEX,LINE_CONTENT FROM ak_loader_temp
2132: where session_id = AK_ON_OBJECTS_PVT.G_SESSION_ID
2133: order by tbl_index;
2134:
2135: while (l_buffer is null and l_eof_flag = 'N' and l_tbl_index <= G_UPL_TABLE_NUM) loop
2136: AK_ON_OBJECTS_PVT.READ_LINE (

Line 2136: AK_ON_OBJECTS_PVT.READ_LINE (

2132: where session_id = AK_ON_OBJECTS_PVT.G_SESSION_ID
2133: order by tbl_index;
2134:
2135: while (l_buffer is null and l_eof_flag = 'N' and l_tbl_index <= G_UPL_TABLE_NUM) loop
2136: AK_ON_OBJECTS_PVT.READ_LINE (
2137: p_return_status => l_return_status,
2138: p_index => l_tbl_index,
2139: p_buffer => l_buffer,
2140: p_lines_read => l_lines_read,

Line 2191: AK_ON_OBJECTS_PVT.GET_TOKEN(

2187: --
2188: -- - get next token from buffer
2189: --
2190:
2191: AK_ON_OBJECTS_PVT.GET_TOKEN(
2192: p_return_status => l_return_status,
2193: p_in_buf => l_buffer,
2194: p_token => l_token
2195: );

Line 2263: if (UPPER(l_token) NOT IN (AK_ON_OBJECTS_PVT.G_ATTRIBUTE,

2259: elsif (l_state = 2) then
2260: if (l_column = 'LANGUAGE') then
2261: l_language := UPPER(l_token);
2262: elsif (l_column = 'EXTRACT_BY_OBJECT') then
2263: if (UPPER(l_token) NOT IN (AK_ON_OBJECTS_PVT.G_ATTRIBUTE,
2264: AK_ON_OBJECTS_PVT.G_FLOW,
2265: AK_ON_OBJECTS_PVT.G_OBJECT,
2266: AK_ON_OBJECTS_PVT.G_REGION,
2267: AK_ON_OBJECTS_PVT.G_CUSTOM_REGION,

Line 2264: AK_ON_OBJECTS_PVT.G_FLOW,

2260: if (l_column = 'LANGUAGE') then
2261: l_language := UPPER(l_token);
2262: elsif (l_column = 'EXTRACT_BY_OBJECT') then
2263: if (UPPER(l_token) NOT IN (AK_ON_OBJECTS_PVT.G_ATTRIBUTE,
2264: AK_ON_OBJECTS_PVT.G_FLOW,
2265: AK_ON_OBJECTS_PVT.G_OBJECT,
2266: AK_ON_OBJECTS_PVT.G_REGION,
2267: AK_ON_OBJECTS_PVT.G_CUSTOM_REGION,
2268: AK_ON_OBJECTS_PVT.G_SECURITY,

Line 2265: AK_ON_OBJECTS_PVT.G_OBJECT,

2261: l_language := UPPER(l_token);
2262: elsif (l_column = 'EXTRACT_BY_OBJECT') then
2263: if (UPPER(l_token) NOT IN (AK_ON_OBJECTS_PVT.G_ATTRIBUTE,
2264: AK_ON_OBJECTS_PVT.G_FLOW,
2265: AK_ON_OBJECTS_PVT.G_OBJECT,
2266: AK_ON_OBJECTS_PVT.G_REGION,
2267: AK_ON_OBJECTS_PVT.G_CUSTOM_REGION,
2268: AK_ON_OBJECTS_PVT.G_SECURITY,
2269: AK_ON_OBJECTS_PVT.G_QUERYOBJ,

Line 2266: AK_ON_OBJECTS_PVT.G_REGION,

2262: elsif (l_column = 'EXTRACT_BY_OBJECT') then
2263: if (UPPER(l_token) NOT IN (AK_ON_OBJECTS_PVT.G_ATTRIBUTE,
2264: AK_ON_OBJECTS_PVT.G_FLOW,
2265: AK_ON_OBJECTS_PVT.G_OBJECT,
2266: AK_ON_OBJECTS_PVT.G_REGION,
2267: AK_ON_OBJECTS_PVT.G_CUSTOM_REGION,
2268: AK_ON_OBJECTS_PVT.G_SECURITY,
2269: AK_ON_OBJECTS_PVT.G_QUERYOBJ,
2270: AK_ON_OBJECTS_PVT.G_AMPARAM_REGISTRY) ) then

Line 2267: AK_ON_OBJECTS_PVT.G_CUSTOM_REGION,

2263: if (UPPER(l_token) NOT IN (AK_ON_OBJECTS_PVT.G_ATTRIBUTE,
2264: AK_ON_OBJECTS_PVT.G_FLOW,
2265: AK_ON_OBJECTS_PVT.G_OBJECT,
2266: AK_ON_OBJECTS_PVT.G_REGION,
2267: AK_ON_OBJECTS_PVT.G_CUSTOM_REGION,
2268: AK_ON_OBJECTS_PVT.G_SECURITY,
2269: AK_ON_OBJECTS_PVT.G_QUERYOBJ,
2270: AK_ON_OBJECTS_PVT.G_AMPARAM_REGISTRY) ) then
2271: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

Line 2268: AK_ON_OBJECTS_PVT.G_SECURITY,

2264: AK_ON_OBJECTS_PVT.G_FLOW,
2265: AK_ON_OBJECTS_PVT.G_OBJECT,
2266: AK_ON_OBJECTS_PVT.G_REGION,
2267: AK_ON_OBJECTS_PVT.G_CUSTOM_REGION,
2268: AK_ON_OBJECTS_PVT.G_SECURITY,
2269: AK_ON_OBJECTS_PVT.G_QUERYOBJ,
2270: AK_ON_OBJECTS_PVT.G_AMPARAM_REGISTRY) ) then
2271: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2272: FND_MESSAGE.SET_NAME('AK','AK_INVALID_COLUMN_VALUE');

Line 2269: AK_ON_OBJECTS_PVT.G_QUERYOBJ,

2265: AK_ON_OBJECTS_PVT.G_OBJECT,
2266: AK_ON_OBJECTS_PVT.G_REGION,
2267: AK_ON_OBJECTS_PVT.G_CUSTOM_REGION,
2268: AK_ON_OBJECTS_PVT.G_SECURITY,
2269: AK_ON_OBJECTS_PVT.G_QUERYOBJ,
2270: AK_ON_OBJECTS_PVT.G_AMPARAM_REGISTRY) ) then
2271: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2272: FND_MESSAGE.SET_NAME('AK','AK_INVALID_COLUMN_VALUE');
2273: FND_MESSAGE.SET_TOKEN('COLUMN','EXTRACT_BY_OBJECT');

Line 2270: AK_ON_OBJECTS_PVT.G_AMPARAM_REGISTRY) ) then

2266: AK_ON_OBJECTS_PVT.G_REGION,
2267: AK_ON_OBJECTS_PVT.G_CUSTOM_REGION,
2268: AK_ON_OBJECTS_PVT.G_SECURITY,
2269: AK_ON_OBJECTS_PVT.G_QUERYOBJ,
2270: AK_ON_OBJECTS_PVT.G_AMPARAM_REGISTRY) ) then
2271: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2272: FND_MESSAGE.SET_NAME('AK','AK_INVALID_COLUMN_VALUE');
2273: FND_MESSAGE.SET_TOKEN('COLUMN','EXTRACT_BY_OBJECT');
2274: FND_MSG_PUB.Add;

Line 2630: AK_ON_OBJECTS_PVT.READ_LINE (

2626: -- Get the next non-blank, non-comment line if current line is
2627: -- fully parsed
2628: --
2629: while (l_buffer is null and l_eof_flag = 'N' and l_tbl_index <= G_UPL_TABLE_NUM) loop
2630: AK_ON_OBJECTS_PVT.READ_LINE (
2631: p_return_status => l_return_status,
2632: p_index => l_tbl_index,
2633: p_buffer => l_buffer,
2634: p_lines_read => l_lines_read,

Line 3242: AK_ON_OBJECTS_PVT.SET_WHO (

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,
3246: p_creation_date => l_creation_date,

Line 3556: AK_ON_OBJECTS_PVT.G_SESSION_ID

3552: session_id
3553: ) values (
3554: G_TBL_INDEX,
3555: p_buffer,
3556: AK_ON_OBJECTS_PVT.G_SESSION_ID
3557: );
3558:
3559: if SQL%ROWCOUNT = 0 then
3560: -- dbms_output.put_line('no rows has been inserted into ak_loader_temp');

Line 3758: end AK_ON_OBJECTS_PVT;

3754: begin
3755: return ((p_value = 'Y') or (p_value = 'N'));
3756: end VALID_YES_NO;
3757:
3758: end AK_ON_OBJECTS_PVT;