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_REGION2_PVT dependencies on AK_ON_OBJECTS_PVT

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

155: else
156: l_line_num := p_line_num;
157: end if;
158:
159: while (l_buffer is null and l_eof_flag = 'N' and p_index <= AK_ON_OBJECTS_PVT.G_UPL_TABLE_NUM) loop
160: AK_ON_OBJECTS_PVT.READ_LINE (
161: p_return_status => l_return_status,
162: p_index => p_index,
163: p_buffer => l_buffer,

Line 160: AK_ON_OBJECTS_PVT.READ_LINE (

156: l_line_num := p_line_num;
157: end if;
158:
159: while (l_buffer is null and l_eof_flag = 'N' and p_index <= AK_ON_OBJECTS_PVT.G_UPL_TABLE_NUM) loop
160: AK_ON_OBJECTS_PVT.READ_LINE (
161: p_return_status => l_return_status,
162: p_index => p_index,
163: p_buffer => l_buffer,
164: p_lines_read => l_lines_read,

Line 198: AK_ON_OBJECTS_PVT.GET_TOKEN(

194:
195: while (l_eof_flag = 'N') and (l_buffer is not null)
196: and (l_more_region) loop
197:
198: AK_ON_OBJECTS_PVT.GET_TOKEN(
199: p_return_status => l_return_status,
200: p_in_buf => l_buffer,
201: p_token => l_token
202: );

Line 241: -- (ak_on_objects_pvt.upload).

237: l_state := 2;
238: else
239: -- Found the beginning of a non-region object,
240: -- rebuild last line and pass it back to the caller
241: -- (ak_on_objects_pvt.upload).
242: p_buffer_out := 'BEGIN ' || l_token || ' ' || l_buffer;
243: l_more_region := FALSE;
244: end if;
245: elsif (l_state = 2) then

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

1624: l_buffer := LTRIM(l_buffer);
1625:
1626: -- Get the next non-blank, non-comment line if current line is
1627: -- fully parsed
1628: while (l_buffer is null and l_eof_flag = 'N' and p_index <= AK_ON_OBJECTS_PVT.G_UPL_TABLE_NUM) loop
1629: AK_ON_OBJECTS_PVT.READ_LINE (
1630: p_return_status => l_return_status,
1631: p_index => p_index,
1632: p_buffer => l_buffer,

Line 1629: AK_ON_OBJECTS_PVT.READ_LINE (

1625:
1626: -- Get the next non-blank, non-comment line if current line is
1627: -- fully parsed
1628: while (l_buffer is null and l_eof_flag = 'N' and p_index <= AK_ON_OBJECTS_PVT.G_UPL_TABLE_NUM) loop
1629: AK_ON_OBJECTS_PVT.READ_LINE (
1630: p_return_status => l_return_status,
1631: p_index => p_index,
1632: p_buffer => l_buffer,
1633: p_lines_read => l_lines_read,

Line 1795: if (AK_ON_OBJECTS_PVT.IS_UPDATEABLE(

1791: and ar.region_application_id = art.region_application_id
1792: and art.language = userenv('LANG');
1793: /*if (( l_user_id1 = 1 or l_user_id1 = 2 ) and
1794: ( l_user_id2 = 1 or l_user_id2 = 2 )) then*/
1795: if (AK_ON_OBJECTS_PVT.IS_UPDATEABLE(
1796: p_loader_timestamp => p_loader_timestamp,
1797: p_created_by => l_region_tbl(l_index).created_by,
1798: p_creation_date => l_region_tbl(l_index).creation_date,
1799: p_last_updated_by => l_region_tbl(l_index).last_updated_by,

Line 1806: AK_ON_OBJECTS_PVT.IS_UPDATEABLE(

1802: p_db_last_update_date => l_update1,
1803: p_last_update_login => l_region_tbl(l_index).last_update_login,
1804: p_create_or_update => 'UPDATE') and
1805:
1806: AK_ON_OBJECTS_PVT.IS_UPDATEABLE(
1807: p_loader_timestamp => p_loader_timestamp,
1808: p_created_by => l_region_tbl(l_index).created_by,
1809: p_creation_date => l_region_tbl(l_index).creation_date,
1810: p_last_updated_by => l_region_tbl(l_index).last_updated_by,

Line 2136: if (AK_ON_OBJECTS_PVT.IS_UPDATEABLE(

2132: and ari.attribute_application_id = arit.attribute_application_id
2133: and arit.language = userenv('LANG');
2134: /*if (( l_user_id1 = 1 or l_user_id1 = 2 ) and
2135: ( l_user_id2 = 1 or l_user_id2 = 2 )) then*/
2136: if (AK_ON_OBJECTS_PVT.IS_UPDATEABLE(
2137: p_loader_timestamp => p_loader_timestamp,
2138: p_created_by => l_item_tbl(l_index).created_by,
2139: p_creation_date => l_item_tbl(l_index).creation_date,
2140: p_last_updated_by => l_item_tbl(l_index).last_updated_by,

Line 2147: AK_ON_OBJECTS_PVT.IS_UPDATEABLE(

2143: p_db_last_update_date => l_update1,
2144: p_last_update_login => l_item_tbl(l_index).last_update_login,
2145: p_create_or_update => 'UPDATE') and
2146:
2147: AK_ON_OBJECTS_PVT.IS_UPDATEABLE(
2148: p_loader_timestamp => p_loader_timestamp,
2149: p_created_by => l_item_tbl(l_index).created_by,
2150: p_creation_date => l_item_tbl(l_index).creation_date,
2151: p_last_updated_by => l_item_tbl(l_index).last_updated_by,

Line 3271: if (AK_ON_OBJECTS_PVT.IS_UPDATEABLE(

3267: and ari.attribute_application_id = arit.attribute_application_id
3268: and arit.language = userenv('LANG');
3269: /*if (( l_user_id1 = 1 or l_user_id1 = 2) and
3270: ( l_user_id2 = 1 or l_user_id2 = 2 )) then*/
3271: if (AK_ON_OBJECTS_PVT.IS_UPDATEABLE(
3272: p_loader_timestamp => p_loader_timestamp,
3273: p_created_by => G_ITEM_REDO_TBL(l_index).created_by,
3274: p_creation_date => G_ITEM_REDO_TBL(l_index).creation_date,
3275: p_last_updated_by => G_ITEM_REDO_TBL(l_index).last_updated_by,

Line 3282: AK_ON_OBJECTS_PVT.IS_UPDATEABLE(

3278: p_db_last_update_date => l_update1,
3279: p_last_update_login => G_ITEM_REDO_TBL(l_index).last_update_login,
3280: p_create_or_update => 'UPDATE') and
3281:
3282: AK_ON_OBJECTS_PVT.IS_UPDATEABLE(
3283: p_loader_timestamp => p_loader_timestamp,
3284: p_created_by => G_ITEM_REDO_TBL(l_index).created_by,
3285: p_creation_date => G_ITEM_REDO_TBL(l_index).creation_date,
3286: p_last_updated_by => G_ITEM_REDO_TBL(l_index).last_updated_by,

Line 4083: -- in package AK_ON_OBJECTS_PVT:

4079: -- validation tests are passed, or FALSE otherwise.
4080: -- Parameters Region graph column columns
4081: -- p_caller : IN required
4082: -- Must be one of the following values defined
4083: -- in package AK_ON_OBJECTS_PVT:
4084: -- - G_CREATE (if calling from the Create API)
4085: -- - G_DOWNLOAD (if calling from the Download API)
4086: -- - G_UPDATE (if calling from the Update API)
4087: --

Line 4266: -- in package AK_ON_OBJECTS_PVT:

4262: -- validation tests are passed, or FALSE otherwise.
4263: -- Parameters Region lov relation columns
4264: -- p_caller : IN required
4265: -- Must be one of the following values defined
4266: -- in package AK_ON_OBJECTS_PVT:
4267: -- - G_CREATE (if calling from the Create API)
4268: -- - G_DOWNLOAD (if calling from the Download API)
4269: -- - G_UPDATE (if calling from the Update API)
4270: --

Line 4531: if (NOT AK_ON_OBJECTS_PVT.VALID_LOOKUP_CODE (

4527:
4528: -- direction_flag
4529: if ( (p_direction_flag <> FND_API.G_MISS_CHAR) and
4530: (p_direction_flag is not null) )then
4531: if (NOT AK_ON_OBJECTS_PVT.VALID_LOOKUP_CODE (
4532: p_api_version_number => 1.0,
4533: p_return_status => l_return_status,
4534: p_lookup_type => 'LOV_DIRECTION',
4535: p_lookup_code => p_direction_flag)) then

Line 4669: p_caller => AK_ON_OBJECTS_PVT.G_CREATE,

4665: p_region_code => p_region_code,
4666: p_attribute_application_id => p_attribute_application_id,
4667: p_attribute_code => p_attribute_code,
4668: p_graph_number => p_graph_number,
4669: p_caller => AK_ON_OBJECTS_PVT.G_CREATE,
4670: p_pass => p_pass
4671: ) then
4672: -- Do not raise an error if it's the first pass
4673: if (p_pass = 1) then

Line 4685: AK_ON_OBJECTS_PVT.SET_WHO (

4681: -- Create record if no validation error was found
4682:
4683: -- Set WHO columns
4684: AK_UPLOAD_GRP.G_UPLOAD_DATE := p_last_update_date;
4685: AK_ON_OBJECTS_PVT.SET_WHO (
4686: p_return_status => l_return_status,
4687: p_loader_timestamp => p_loader_timestamp,
4688: p_created_by => l_created_by,
4689: p_creation_date => l_creation_date,

Line 4898: p_caller => AK_ON_OBJECTS_PVT.G_CREATE,

4894: p_base_attribute_code => p_base_attribute_code,
4895: p_direction_flag => p_direction_flag,
4896: p_base_region_appl_id => p_base_region_appl_id,
4897: p_base_region_code => p_base_region_code,
4898: p_caller => AK_ON_OBJECTS_PVT.G_CREATE,
4899: p_pass => p_pass
4900: ) then
4901: -- Do not raise an error if it's the first pass
4902: if (p_pass = 1) then

Line 4945: if AK_ON_OBJECTS_PVT.IS_UPDATEABLE(

4941: -- old jlt files didn't have who columns and IS_UPDATEABLE
4942: -- calls SET_WHO which populates those columns, for later
4943: -- jlt files IS_UPDATEABLE will always return TRUE for CREATE
4944:
4945: if AK_ON_OBJECTS_PVT.IS_UPDATEABLE(
4946: p_loader_timestamp => p_loader_timestamp,
4947: p_created_by => l_created_by,
4948: p_creation_date => l_creation_date,
4949: p_last_updated_by => l_last_updated_by,

Line 5174: p_caller => AK_ON_OBJECTS_PVT.G_UPDATE,

5170: p_region_code => p_region_code,
5171: p_attribute_application_id => p_attribute_application_id,
5172: p_attribute_code => p_attribute_code,
5173: p_graph_number => p_graph_number,
5174: p_caller => AK_ON_OBJECTS_PVT.G_UPDATE,
5175: p_pass => p_pass
5176: ) then
5177: --dbms_output.put_line(l_api_name || 'validation failed');
5178: -- Do not raise an error if it's the first pass

Line 5195: AK_ON_OBJECTS_PVT.SET_WHO (

5191: --** - next, load non-null, non-key columns **
5192:
5193: -- Set WHO columns
5194: AK_UPLOAD_GRP.G_UPLOAD_DATE := p_last_update_date;
5195: AK_ON_OBJECTS_PVT.SET_WHO (
5196: p_return_status => l_return_status,
5197: p_loader_timestamp => p_loader_timestamp,
5198: p_created_by => l_created_by,
5199: p_creation_date => l_creation_date,

Line 5419: p_caller => AK_ON_OBJECTS_PVT.G_UPDATE,

5415: p_base_attribute_code => p_base_attribute_code,
5416: p_direction_flag => p_direction_flag,
5417: p_base_region_appl_id => p_base_region_appl_id,
5418: p_base_region_code => p_base_region_code,
5419: p_caller => AK_ON_OBJECTS_PVT.G_UPDATE,
5420: p_pass => p_pass
5421: ) then
5422: --dbms_output.put_line(l_api_name || 'validation failed');
5423: -- Do not raise an error if it's the first pass

Line 5469: if AK_ON_OBJECTS_PVT.IS_UPDATEABLE(

5465: l_last_update_login := p_last_update_login;
5466: end if;
5467:
5468: -- Set WHO columns
5469: if AK_ON_OBJECTS_PVT.IS_UPDATEABLE(
5470: p_loader_timestamp => p_loader_timestamp,
5471: p_created_by => l_created_by,
5472: p_creation_date => l_creation_date,
5473: p_last_updated_by => l_last_updated_by,

Line 5671: -- in package AK_ON_OBJECTS_PVT:

5667: -- validation tests are passed, or FALSE otherwise.
5668: -- Parameters Region lov relation columns
5669: -- p_caller : IN required
5670: -- Must be one of the following values defined
5671: -- in package AK_ON_OBJECTS_PVT:
5672: -- - G_CREATE (if calling from the Create API)
5673: -- - G_DOWNLOAD (if calling from the Download API)
5674: -- - G_UPDATE (if calling from the Update API)
5675: --

Line 5940: p_caller => AK_ON_OBJECTS_PVT.G_CREATE,

5936: p_category_name => p_category_name,
5937: p_category_id => p_category_id,
5938: p_application_id => p_application_id,
5939: p_show_all => p_show_all,
5940: p_caller => AK_ON_OBJECTS_PVT.G_CREATE,
5941: p_pass => p_pass
5942: ) then
5943: -- Do not raise an error if it's the first pass
5944: if (p_pass = 1) then

Line 5981: if AK_ON_OBJECTS_PVT.IS_UPDATEABLE(

5977: -- old jlt files didn't have who columns and IS_UPDATEABLE
5978: -- calls SET_WHO which populates those columns, for later
5979: -- jlt files IS_UPDATEABLE will always return TRUE for CREATE
5980:
5981: if AK_ON_OBJECTS_PVT.IS_UPDATEABLE(
5982: p_loader_timestamp => p_loader_timestamp,
5983: p_created_by => l_created_by,
5984: p_creation_date => l_creation_date,
5985: p_last_updated_by => l_last_updated_by,

Line 6198: p_caller => AK_ON_OBJECTS_PVT.G_UPDATE,

6194: p_category_name => p_category_name,
6195: p_category_id => p_category_id,
6196: p_application_id => p_application_id,
6197: p_show_all => p_show_all,
6198: p_caller => AK_ON_OBJECTS_PVT.G_UPDATE,
6199: p_pass => p_pass
6200: ) then
6201: -- Do not raise an error if it's the first pass
6202: if (p_pass = 1) then

Line 6231: if AK_ON_OBJECTS_PVT.IS_UPDATEABLE(

6227: end if;
6228:
6229: --** Load record to be updated to the database **
6230:
6231: if AK_ON_OBJECTS_PVT.IS_UPDATEABLE(
6232: p_loader_timestamp => p_loader_timestamp,
6233: p_created_by => l_created_by,
6234: p_creation_date => l_creation_date,
6235: p_last_updated_by => l_last_updated_by,