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

Line 152: p_caller => AK_ON_OBJECTS_PVT.G_UPDATE,

148: p_defaulting_api_pkg => p_defaulting_api_pkg,
149: p_defaulting_api_proc => p_defaulting_api_proc,
150: p_validation_api_pkg => p_validation_api_pkg,
151: p_validation_api_proc => p_validation_api_proc,
152: p_caller => AK_ON_OBJECTS_PVT.G_UPDATE,
153: p_pass => p_pass
154: ) then
155: if (p_pass = 1) then
156: p_copy_redo_flag := TRUE;

Line 285: if AK_ON_OBJECTS_PVT.IS_UPDATEABLE(

281: if (p_last_update_login <> FND_API.G_MISS_NUM) then
282: l_last_update_login := p_last_update_login;
283: end if;
284:
285: if AK_ON_OBJECTS_PVT.IS_UPDATEABLE(
286: p_loader_timestamp => p_loader_timestamp,
287: p_created_by => l_created_by,
288: p_creation_date => l_creation_date,
289: p_last_updated_by => l_last_updated_by,

Line 592: p_caller => AK_ON_OBJECTS_PVT.G_UPDATE,

588: p_validation_api_pkg => p_validation_api_pkg,
589: p_validation_api_proc => p_validation_api_proc,
590: p_attribute_label_long => p_attribute_label_long,
591: p_attribute_label_short => p_attribute_label_short,
592: p_caller => AK_ON_OBJECTS_PVT.G_UPDATE,
593: p_pass => p_pass
594: ) then
595: -- Do not raise an error if it's the first pass
596: if (p_pass = 1) then

Line 788: if AK_ON_OBJECTS_PVT.IS_UPDATEABLE(

784: if (p_last_update_login <> FND_API.G_MISS_NUM) then
785: l_last_update_login := p_last_update_login;
786: end if;
787:
788: if AK_ON_OBJECTS_PVT.IS_UPDATEABLE(
789: p_loader_timestamp => p_loader_timestamp,
790: p_created_by => l_created_by,
791: p_creation_date => l_creation_date,
792: p_last_updated_by => l_last_updated_by,

Line 1135: p_caller => AK_ON_OBJECTS_PVT.G_UPDATE,

1131: p_value_date => p_value_date,
1132: p_value_number => p_value_number,
1133: p_to_region_appl_id => p_to_region_appl_id,
1134: p_to_region_code => p_to_region_code,
1135: p_caller => AK_ON_OBJECTS_PVT.G_UPDATE,
1136: p_pass => p_pass
1137: ) then
1138: -- dbms_output.put_line(l_api_name || ' validation failed');
1139: -- Do not raise an error if it's the first pass

Line 1239: if AK_ON_OBJECTS_PVT.IS_UPDATEABLE(

1235: if (p_last_update_login <> FND_API.G_MISS_NUM) then
1236: l_last_update_login := p_last_update_login;
1237: end if;
1238:
1239: if AK_ON_OBJECTS_PVT.IS_UPDATEABLE(
1240: p_loader_timestamp => p_loader_timestamp,
1241: p_created_by => l_created_by,
1242: p_creation_date => l_creation_date,
1243: p_last_updated_by => l_last_updated_by,

Line 1632: p_caller => AK_ON_OBJECTS_PVT.G_UPDATE

1628: p_key_value10 => p_key_value10,
1629: p_value_varchar2 => p_value_varchar2,
1630: p_value_date => p_value_date,
1631: p_value_number => p_value_number,
1632: p_caller => AK_ON_OBJECTS_PVT.G_UPDATE
1633: ) then
1634: -- dbms_output.put_line(l_api_name || ' validation failed');
1635: raise FND_API.G_EXC_ERROR;
1636: end if;

Line 1657: AK_ON_OBJECTS_PVT.SET_WHO (

1653: end if;
1654:
1655: -- Set WHO columns
1656: AK_UPLOAD_GRP.G_UPLOAD_DATE := p_last_update_date;
1657: AK_ON_OBJECTS_PVT.SET_WHO (
1658: p_return_status => l_return_status,
1659: p_loader_timestamp => p_loader_timestamp,
1660: p_created_by => l_created_by,
1661: p_creation_date => l_creation_date,

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

1961: else
1962: l_line_num := p_line_num;
1963: end if;
1964:
1965: while (l_buffer is null and l_eof_flag = 'N' and p_index <= AK_ON_OBJECTS_PVT.G_UPL_TABLE_NUM) loop
1966: AK_ON_OBJECTS_PVT.READ_LINE (
1967: p_return_status => l_return_status,
1968: p_index => p_index,
1969: p_buffer => l_buffer,

Line 1966: AK_ON_OBJECTS_PVT.READ_LINE (

1962: l_line_num := p_line_num;
1963: end if;
1964:
1965: while (l_buffer is null and l_eof_flag = 'N' and p_index <= AK_ON_OBJECTS_PVT.G_UPL_TABLE_NUM) loop
1966: AK_ON_OBJECTS_PVT.READ_LINE (
1967: p_return_status => l_return_status,
1968: p_index => p_index,
1969: p_buffer => l_buffer,
1970: p_lines_read => l_lines_read,

Line 2005: AK_ON_OBJECTS_PVT.GET_TOKEN(

2001:
2002: while (l_eof_flag = 'N') and (l_buffer is not null)
2003: and (l_more_object) loop
2004:
2005: AK_ON_OBJECTS_PVT.GET_TOKEN(
2006: p_return_status => l_return_status,
2007: p_in_buf => l_buffer,
2008: p_token => l_token
2009: );

Line 2046: -- (ak_on_objects_pvt.upload).

2042: l_state := 2;
2043: else
2044: -- Found the beginning of a non-object object,
2045: -- rebuild last line and pass it back to the caller
2046: -- (ak_on_objects_pvt.upload).
2047: p_buffer_out := 'BEGIN ' || l_token || ' ' || l_buffer;
2048: l_more_object := FALSE;
2049: end if;
2050: elsif (l_state = 2) then

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

3739: l_buffer := LTRIM(l_buffer);
3740:
3741: -- Get the next non-blank, non-comment line if current line is
3742: -- fully parsed
3743: while (l_buffer is null and l_eof_flag = 'N' and p_index <= AK_ON_OBJECTS_PVT.G_UPL_TABLE_NUM) loop
3744: AK_ON_OBJECTS_PVT.READ_LINE (
3745: p_return_status => l_return_status,
3746: p_index => p_index,
3747: p_buffer => l_buffer,

Line 3744: AK_ON_OBJECTS_PVT.READ_LINE (

3740:
3741: -- Get the next non-blank, non-comment line if current line is
3742: -- fully parsed
3743: while (l_buffer is null and l_eof_flag = 'N' and p_index <= AK_ON_OBJECTS_PVT.G_UPL_TABLE_NUM) loop
3744: AK_ON_OBJECTS_PVT.READ_LINE (
3745: p_return_status => l_return_status,
3746: p_index => p_index,
3747: p_buffer => l_buffer,
3748: p_lines_read => l_lines_read,

Line 3851: if (AK_ON_OBJECTS_PVT.IS_UPDATEABLE(

3847: and ao.database_object_name = aot.database_object_name
3848: and aot.language = userenv('LANG');
3849: /*if (( l_user_id1 = 1 or l_user_id1 = 2 ) and
3850: ( l_user_id2 = 1 or l_user_id2 = 2)) then*/
3851: if (AK_ON_OBJECTS_PVT.IS_UPDATEABLE(
3852: p_loader_timestamp => p_loader_timestamp,
3853: p_created_by => l_object_tbl(l_index).created_by,
3854: p_creation_date => l_object_tbl(l_index).creation_date,
3855: p_last_updated_by => l_object_tbl(l_index).last_updated_by,

Line 3862: AK_ON_OBJECTS_PVT.IS_UPDATEABLE(

3858: p_db_last_update_date => l_update1,
3859: p_last_update_login => l_object_tbl(l_index).last_update_login,
3860: p_create_or_update => 'UPDATE') and
3861:
3862: AK_ON_OBJECTS_PVT.IS_UPDATEABLE(
3863: p_loader_timestamp => p_loader_timestamp,
3864: p_created_by => l_object_tbl(l_index).created_by,
3865: p_creation_date => l_object_tbl(l_index).creation_date,
3866: p_last_updated_by => l_object_tbl(l_index).last_updated_by,

Line 4088: if (AK_ON_OBJECTS_PVT.IS_UPDATEABLE(

4084: and aoa.attribute_application_id = aoat.attribute_application_id
4085: and aoat.language = userenv('LANG');
4086: /*if (( l_user_id1 = 1 or l_user_id1 = 2) and
4087: (l_user_id2 = 1 or l_user_id2 = 2)) then*/
4088: if (AK_ON_OBJECTS_PVT.IS_UPDATEABLE(
4089: p_loader_timestamp => p_loader_timestamp,
4090: p_created_by => l_attribute_tbl(l_index).created_by,
4091: p_creation_date => l_attribute_tbl(l_index).creation_date,
4092: p_last_updated_by => l_attribute_tbl(l_index).last_updated_by,

Line 4099: AK_ON_OBJECTS_PVT.IS_UPDATEABLE(

4095: p_db_last_update_date => l_update1,
4096: p_last_update_login => l_attribute_tbl(l_index).last_update_login,
4097: p_create_or_update => 'UPDATE') and
4098:
4099: AK_ON_OBJECTS_PVT.IS_UPDATEABLE(
4100: p_loader_timestamp => p_loader_timestamp,
4101: p_created_by => l_attribute_tbl(l_index).created_by,
4102: p_creation_date => l_attribute_tbl(l_index).creation_date,
4103: p_last_updated_by => l_attribute_tbl(l_index).last_updated_by,

Line 4362: if AK_ON_OBJECTS_PVT.IS_UPDATEABLE(

4358: and aoan.value_varchar2 = l_navigation_tbl(l_index).value_varchar2
4359: and aoan.value_date = l_navigation_tbl(l_index).value_date
4360: and aoan.value_number = l_navigation_tbl(l_index).value_number;
4361: /*if ( l_user_id1 = 1 or l_user_id1 = 2) then*/
4362: if AK_ON_OBJECTS_PVT.IS_UPDATEABLE(
4363: p_loader_timestamp => p_loader_timestamp,
4364: p_created_by => l_navigation_tbl(l_index).created_by,
4365: p_creation_date => l_navigation_tbl(l_index).creation_date,
4366: p_last_updated_by => l_navigation_tbl(l_index).last_updated_by,

Line 4651: if AK_ON_OBJECTS_PVT.IS_UPDATEABLE(

4647: where database_object_name = l_unique_key_tbl(l_index).database_object_name
4648: and unique_key_name = l_unique_key_tbl(l_index).unique_key_name;
4649:
4650: /*if ( l_user_id1 = 1 or l_user_id1 = 2) then*/
4651: if AK_ON_OBJECTS_PVT.IS_UPDATEABLE(
4652: p_loader_timestamp => p_loader_timestamp,
4653: p_created_by => l_unique_key_tbl(l_index).created_by,
4654: p_creation_date => l_unique_key_tbl(l_index).creation_date,
4655: p_last_updated_by => l_unique_key_tbl(l_index).last_updated_by,

Line 4833: if AK_ON_OBJECTS_PVT.IS_UPDATEABLE(

4829: where unique_key_name = l_unique_key_column_tbl(l_index).unique_key_name
4830: and attribute_code = l_unique_key_column_tbl(l_index).attribute_code
4831: and attribute_application_id = l_unique_key_column_tbl(l_index).attribute_application_id;
4832: /*if ( l_user_id1 = 1 or l_user_id1 = 2) then */
4833: if AK_ON_OBJECTS_PVT.IS_UPDATEABLE(
4834: p_loader_timestamp => p_loader_timestamp,
4835: p_created_by => l_unique_key_column_tbl(l_index).created_by,
4836: p_creation_date => l_unique_key_column_tbl(l_index).creation_date,
4837: p_last_updated_by => l_unique_key_column_tbl(l_index).last_updated_by,

Line 5027: if (AK_ON_OBJECTS_PVT.IS_UPDATEABLE(

5023: and afk.foreign_key_name = afkt.foreign_key_name
5024: and afkt.language = userenv('LANG');
5025: /*if (( l_user_id1 = 1 or l_user_id1 = 2 ) and
5026: (l_user_id2 = 1 or l_user_id2 = 2)) then*/
5027: if (AK_ON_OBJECTS_PVT.IS_UPDATEABLE(
5028: p_loader_timestamp => p_loader_timestamp,
5029: p_created_by => l_foreign_key_tbl(l_index).created_by,
5030: p_creation_date => l_foreign_key_tbl(l_index).creation_date,
5031: p_last_updated_by => l_foreign_key_tbl(l_index).last_updated_by,

Line 5038: AK_ON_OBJECTS_PVT.IS_UPDATEABLE(

5034: p_db_last_update_date => l_update1,
5035: p_last_update_login => l_foreign_key_tbl(l_index).last_update_login,
5036: p_create_or_update => 'UPDATE') and
5037:
5038: AK_ON_OBJECTS_PVT.IS_UPDATEABLE(
5039: p_loader_timestamp => p_loader_timestamp,
5040: p_created_by => l_foreign_key_tbl(l_index).created_by,
5041: p_creation_date => l_foreign_key_tbl(l_index).creation_date,
5042: p_last_updated_by => l_foreign_key_tbl(l_index).last_updated_by,

Line 5239: if AK_ON_OBJECTS_PVT.IS_UPDATEABLE(

5235: where foreign_key_name = l_foreign_key_column_tbl(l_index).foreign_key_name
5236: and attribute_code = l_foreign_key_column_tbl(l_index).attribute_code
5237: and attribute_application_id = l_foreign_key_column_tbl(l_index).attribute_application_id;
5238: /*if ( l_user_id1 = 1 or l_user_id1 = 2) then*/
5239: if AK_ON_OBJECTS_PVT.IS_UPDATEABLE(
5240: p_loader_timestamp => p_loader_timestamp,
5241: p_created_by => l_foreign_key_column_tbl(l_index).created_by,
5242: p_creation_date => l_foreign_key_column_tbl(l_index).creation_date,
5243: p_last_updated_by => l_foreign_key_column_tbl(l_index).last_updated_by,