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 3269: if (AK_ON_OBJECTS_PVT.IS_UPDATEABLE(

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

Line 3280: AK_ON_OBJECTS_PVT.IS_UPDATEABLE(

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

Line 4066: -- in package AK_ON_OBJECTS_PVT:

4062: -- validation tests are passed, or FALSE otherwise.
4063: -- Parameters Region graph column columns
4064: -- p_caller : IN required
4065: -- Must be one of the following values defined
4066: -- in package AK_ON_OBJECTS_PVT:
4067: -- - G_CREATE (if calling from the Create API)
4068: -- - G_DOWNLOAD (if calling from the Download API)
4069: -- - G_UPDATE (if calling from the Update API)
4070: --

Line 4249: -- in package AK_ON_OBJECTS_PVT:

4245: -- validation tests are passed, or FALSE otherwise.
4246: -- Parameters Region lov relation columns
4247: -- p_caller : IN required
4248: -- Must be one of the following values defined
4249: -- in package AK_ON_OBJECTS_PVT:
4250: -- - G_CREATE (if calling from the Create API)
4251: -- - G_DOWNLOAD (if calling from the Download API)
4252: -- - G_UPDATE (if calling from the Update API)
4253: --

Line 4514: if (NOT AK_ON_OBJECTS_PVT.VALID_LOOKUP_CODE (

4510:
4511: -- direction_flag
4512: if ( (p_direction_flag <> FND_API.G_MISS_CHAR) and
4513: (p_direction_flag is not null) )then
4514: if (NOT AK_ON_OBJECTS_PVT.VALID_LOOKUP_CODE (
4515: p_api_version_number => 1.0,
4516: p_return_status => l_return_status,
4517: p_lookup_type => 'LOV_DIRECTION',
4518: p_lookup_code => p_direction_flag)) then

Line 4652: p_caller => AK_ON_OBJECTS_PVT.G_CREATE,

4648: p_region_code => p_region_code,
4649: p_attribute_application_id => p_attribute_application_id,
4650: p_attribute_code => p_attribute_code,
4651: p_graph_number => p_graph_number,
4652: p_caller => AK_ON_OBJECTS_PVT.G_CREATE,
4653: p_pass => p_pass
4654: ) then
4655: -- Do not raise an error if it's the first pass
4656: if (p_pass = 1) then

Line 4668: AK_ON_OBJECTS_PVT.SET_WHO (

4664: -- Create record if no validation error was found
4665:
4666: -- Set WHO columns
4667: AK_UPLOAD_GRP.G_UPLOAD_DATE := p_last_update_date;
4668: AK_ON_OBJECTS_PVT.SET_WHO (
4669: p_return_status => l_return_status,
4670: p_loader_timestamp => p_loader_timestamp,
4671: p_created_by => l_created_by,
4672: p_creation_date => l_creation_date,

Line 4881: p_caller => AK_ON_OBJECTS_PVT.G_CREATE,

4877: p_base_attribute_code => p_base_attribute_code,
4878: p_direction_flag => p_direction_flag,
4879: p_base_region_appl_id => p_base_region_appl_id,
4880: p_base_region_code => p_base_region_code,
4881: p_caller => AK_ON_OBJECTS_PVT.G_CREATE,
4882: p_pass => p_pass
4883: ) then
4884: -- Do not raise an error if it's the first pass
4885: if (p_pass = 1) then

Line 4925: if AK_ON_OBJECTS_PVT.IS_UPDATEABLE(

4921: -- old jlt files didn't have who columns and IS_UPDATEABLE
4922: -- calls SET_WHO which populates those columns, for later
4923: -- jlt files IS_UPDATEABLE will always return TRUE for CREATE
4924:
4925: if AK_ON_OBJECTS_PVT.IS_UPDATEABLE(
4926: p_loader_timestamp => p_loader_timestamp,
4927: p_created_by => l_created_by,
4928: p_creation_date => l_creation_date,
4929: p_last_updated_by => l_last_updated_by,

Line 5152: p_caller => AK_ON_OBJECTS_PVT.G_UPDATE,

5148: p_region_code => p_region_code,
5149: p_attribute_application_id => p_attribute_application_id,
5150: p_attribute_code => p_attribute_code,
5151: p_graph_number => p_graph_number,
5152: p_caller => AK_ON_OBJECTS_PVT.G_UPDATE,
5153: p_pass => p_pass
5154: ) then
5155: --dbms_output.put_line(l_api_name || 'validation failed');
5156: -- Do not raise an error if it's the first pass

Line 5173: AK_ON_OBJECTS_PVT.SET_WHO (

5169: --** - next, load non-null, non-key columns **
5170:
5171: -- Set WHO columns
5172: AK_UPLOAD_GRP.G_UPLOAD_DATE := p_last_update_date;
5173: AK_ON_OBJECTS_PVT.SET_WHO (
5174: p_return_status => l_return_status,
5175: p_loader_timestamp => p_loader_timestamp,
5176: p_created_by => l_created_by,
5177: p_creation_date => l_creation_date,

Line 5397: p_caller => AK_ON_OBJECTS_PVT.G_UPDATE,

5393: p_base_attribute_code => p_base_attribute_code,
5394: p_direction_flag => p_direction_flag,
5395: p_base_region_appl_id => p_base_region_appl_id,
5396: p_base_region_code => p_base_region_code,
5397: p_caller => AK_ON_OBJECTS_PVT.G_UPDATE,
5398: p_pass => p_pass
5399: ) then
5400: --dbms_output.put_line(l_api_name || 'validation failed');
5401: -- Do not raise an error if it's the first pass

Line 5444: if AK_ON_OBJECTS_PVT.IS_UPDATEABLE(

5440: l_last_update_login := p_last_update_login;
5441: end if;
5442:
5443: -- Set WHO columns
5444: if AK_ON_OBJECTS_PVT.IS_UPDATEABLE(
5445: p_loader_timestamp => p_loader_timestamp,
5446: p_created_by => l_created_by,
5447: p_creation_date => l_creation_date,
5448: p_last_updated_by => l_last_updated_by,

Line 5643: -- in package AK_ON_OBJECTS_PVT:

5639: -- validation tests are passed, or FALSE otherwise.
5640: -- Parameters Region lov relation columns
5641: -- p_caller : IN required
5642: -- Must be one of the following values defined
5643: -- in package AK_ON_OBJECTS_PVT:
5644: -- - G_CREATE (if calling from the Create API)
5645: -- - G_DOWNLOAD (if calling from the Download API)
5646: -- - G_UPDATE (if calling from the Update API)
5647: --

Line 5912: p_caller => AK_ON_OBJECTS_PVT.G_CREATE,

5908: p_category_name => p_category_name,
5909: p_category_id => p_category_id,
5910: p_application_id => p_application_id,
5911: p_show_all => p_show_all,
5912: p_caller => AK_ON_OBJECTS_PVT.G_CREATE,
5913: p_pass => p_pass
5914: ) then
5915: -- Do not raise an error if it's the first pass
5916: if (p_pass = 1) then

Line 5950: if AK_ON_OBJECTS_PVT.IS_UPDATEABLE(

5946: -- old jlt files didn't have who columns and IS_UPDATEABLE
5947: -- calls SET_WHO which populates those columns, for later
5948: -- jlt files IS_UPDATEABLE will always return TRUE for CREATE
5949:
5950: if AK_ON_OBJECTS_PVT.IS_UPDATEABLE(
5951: p_loader_timestamp => p_loader_timestamp,
5952: p_created_by => l_created_by,
5953: p_creation_date => l_creation_date,
5954: p_last_updated_by => l_last_updated_by,

Line 6165: p_caller => AK_ON_OBJECTS_PVT.G_UPDATE,

6161: p_category_name => p_category_name,
6162: p_category_id => p_category_id,
6163: p_application_id => p_application_id,
6164: p_show_all => p_show_all,
6165: p_caller => AK_ON_OBJECTS_PVT.G_UPDATE,
6166: p_pass => p_pass
6167: ) then
6168: -- Do not raise an error if it's the first pass
6169: if (p_pass = 1) then

Line 6195: if AK_ON_OBJECTS_PVT.IS_UPDATEABLE(

6191: end if;
6192:
6193: --** Load record to be updated to the database **
6194:
6195: if AK_ON_OBJECTS_PVT.IS_UPDATEABLE(
6196: p_loader_timestamp => p_loader_timestamp,
6197: p_created_by => l_created_by,
6198: p_creation_date => l_creation_date,
6199: p_last_updated_by => l_last_updated_by,