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_UPLOAD_GRP

Line 1656: AK_UPLOAD_GRP.G_UPLOAD_DATE := p_last_update_date;

1652: l_value_number := p_value_number;
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,

Line 1666: if (AK_UPLOAD_GRP.G_NON_SEED_DATA) then

1662: p_last_updated_by => l_last_updated_by,
1663: p_last_update_date => l_last_update_date,
1664: p_last_update_login => l_last_update_login);
1665:
1666: if (AK_UPLOAD_GRP.G_NON_SEED_DATA) then
1667: l_created_by := p_created_by;
1668: l_last_updated_by := p_last_updated_by;
1669: l_last_update_login := p_last_update_login;
1670: end if;

Line 3799: if (AK_UPLOAD_GRP.G_UPDATE_MODE) then

3795: l_object_tbl(l_index).database_object_name) then
3796: --
3797: -- Update Object only if G_UPDATE_MODE is TRUE
3798: --
3799: if (AK_UPLOAD_GRP.G_UPDATE_MODE) then
3800: AK_OBJECT3_PVT.UPDATE_OBJECT (
3801: p_validation_level => p_validation_level,
3802: p_api_version_number => 1.0,
3803: p_msg_count => l_msg_count,

Line 3841: elsif ( AK_UPLOAD_GRP.G_NO_CUSTOM_UPDATE ) then

3837: p_loader_timestamp => p_loader_timestamp,
3838: p_pass => p_pass,
3839: p_copy_redo_flag => l_copy_redo_flag
3840: );
3841: elsif ( AK_UPLOAD_GRP.G_NO_CUSTOM_UPDATE ) then
3842: select ao.last_updated_by, aot.last_updated_by,
3843: ao.last_update_date, aot.last_update_date
3844: into l_user_id1, l_user_id2, l_update1, l_update2
3845: from ak_objects ao, ak_objects_tl aot

Line 3994: if (AK_UPLOAD_GRP.G_UPDATE_MODE) then

3990: l_attribute_tbl(l_index).attribute_code) then
3991: --
3992: -- Update Object Attributes only if G_UPDATE_MODE is TRUE
3993: --
3994: if (AK_UPLOAD_GRP.G_UPDATE_MODE) then
3995: AK_OBJECT3_PVT.UPDATE_ATTRIBUTE (
3996: p_validation_level => p_validation_level,
3997: p_api_version_number => 1.0,
3998: p_msg_count => l_msg_count,

Line 4074: elsif ( AK_UPLOAD_GRP.G_NO_CUSTOM_UPDATE ) then

4070: p_loader_timestamp => p_loader_timestamp,
4071: p_pass => p_pass,
4072: p_copy_redo_flag => l_copy_redo_flag
4073: );
4074: elsif ( AK_UPLOAD_GRP.G_NO_CUSTOM_UPDATE ) then
4075: select aoa.last_updated_by, aoat.last_updated_by,
4076: aoa.last_update_date, aoat.last_update_date
4077: into l_user_id1, l_user_id2, l_update1, l_update2
4078: from ak_object_attributes aoa, ak_object_attributes_tl aoat

Line 4309: if (AK_UPLOAD_GRP.G_UPDATE_MODE) then

4305: p_value_number => l_navigation_tbl(l_index).value_number) then
4306: --
4307: -- Update Object Attribute Navigation only if G_UPDATE_MODE is TRUE
4308: --
4309: if (AK_UPLOAD_GRP.G_UPDATE_MODE) then
4310: AK_OBJECT3_PVT.UPDATE_ATTRIBUTE_NAVIGATION (
4311: p_validation_level => p_validation_level,
4312: p_api_version_number => 1.0,
4313: p_msg_count => l_msg_count,

Line 4351: elsif ( AK_UPLOAD_GRP.G_NO_CUSTOM_UPDATE ) then

4347: p_loader_timestamp => p_loader_timestamp,
4348: p_pass => p_pass,
4349: p_copy_redo_flag => l_copy_redo_flag
4350: );
4351: elsif ( AK_UPLOAD_GRP.G_NO_CUSTOM_UPDATE ) then
4352: select aoan.last_updated_by, aoan.last_update_date
4353: into l_user_id1, l_update1
4354: from ak_object_attribute_navigation aoan
4355: where aoan.database_object_name = l_navigation_tbl(l_index).database_object_name

Line 4506: if (AK_UPLOAD_GRP.G_UPDATE_MODE) then

4502: ) then
4503: --
4504: -- Update Update Attribute Values only if G_UPDATE_MODE is TRUE
4505: --
4506: if (AK_UPLOAD_GRP.G_UPDATE_MODE) then
4507: AK_OBJECT3_PVT.UPDATE_ATTRIBUTE_VALUE (
4508: p_validation_level => p_validation_level,
4509: p_api_version_number => 1.0,
4510: p_msg_count => l_msg_count,

Line 4594: if (AK_UPLOAD_GRP.G_UPDATE_MODE) then

4590: l_unique_key_tbl(l_index).unique_key_name) then
4591: --
4592: -- Update Unique Keys only if G_UPDATE_MODE is TRUE
4593: --
4594: if (AK_UPLOAD_GRP.G_UPDATE_MODE) then
4595: AK_KEY_PVT.UPDATE_UNIQUE_KEY (
4596: p_validation_level => p_validation_level,
4597: p_api_version_number => 1.0,
4598: p_msg_count => l_msg_count,

Line 4643: elsif (AK_UPLOAD_GRP.G_NO_CUSTOM_UPDATE) then

4639: p_return_status => l_return_status,
4640: p_unique_key_name =>
4641: l_unique_key_tbl(l_index).unique_key_name
4642: );
4643: elsif (AK_UPLOAD_GRP.G_NO_CUSTOM_UPDATE) then
4644: select last_updated_by, last_update_date
4645: into l_user_id1, l_update1
4646: from ak_unique_keys
4647: where database_object_name = l_unique_key_tbl(l_index).database_object_name

Line 4785: if (AK_UPLOAD_GRP.G_UPDATE_MODE) then

4781: l_unique_key_column_tbl(l_index).attribute_code) then
4782: --
4783: -- Update Unique Key Columns only if G_UPDATE_MODE is TRUE
4784: --
4785: if (AK_UPLOAD_GRP.G_UPDATE_MODE) then
4786: AK_KEY_PVT.UPDATE_UNIQUE_KEY_COLUMN (
4787: p_validation_level => p_validation_level,
4788: p_api_version_number => 1.0,
4789: p_msg_count => l_msg_count,

Line 4825: elsif ( AK_UPLOAD_GRP.G_NO_CUSTOM_UPDATE ) then

4821: p_loader_timestamp => p_loader_timestamp,
4822: p_pass => p_pass,
4823: p_copy_redo_flag => l_copy_redo_flag
4824: );
4825: elsif ( AK_UPLOAD_GRP.G_NO_CUSTOM_UPDATE ) then
4826: select last_updated_by, last_update_date
4827: into l_user_id1, l_update1
4828: from ak_unique_key_columns
4829: where unique_key_name = l_unique_key_column_tbl(l_index).unique_key_name

Line 4958: if (AK_UPLOAD_GRP.G_UPDATE_MODE) then

4954: l_foreign_key_tbl(l_index).foreign_key_name) then
4955: --
4956: -- Update Foreign Keys only if G_UPDATE_MODE is TRUE
4957: --
4958: if (AK_UPLOAD_GRP.G_UPDATE_MODE) then
4959: AK_KEY_PVT.UPDATE_FOREIGN_KEY (
4960: p_validation_level => p_validation_level,
4961: p_api_version_number => 1.0,
4962: p_msg_count => l_msg_count,

Line 5017: elsif ( AK_UPLOAD_GRP.G_NO_CUSTOM_UPDATE ) then

5013: p_foreign_key_name =>
5014: l_foreign_key_tbl(l_index).foreign_key_name
5015: );
5016: -- update non-customized data only
5017: elsif ( AK_UPLOAD_GRP.G_NO_CUSTOM_UPDATE ) then
5018: select afk.last_updated_by, afkt.last_updated_by,
5019: afk.last_update_date, afkt.last_update_date
5020: into l_user_id1, l_user_id2, l_update1, l_update2
5021: from ak_foreign_keys afk, ak_foreign_keys_tl afkt

Line 5189: if (AK_UPLOAD_GRP.G_UPDATE_MODE) then

5185: l_foreign_key_column_tbl(l_index).attribute_code) then
5186: --
5187: -- Update Foreign Key Columns only if G_UPDATE_MODE is TRUE
5188: --
5189: if (AK_UPLOAD_GRP.G_UPDATE_MODE) then
5190: AK_KEY_PVT.UPDATE_FOREIGN_KEY_COLUMN (
5191: p_validation_level => p_validation_level,
5192: p_api_version_number => 1.0,
5193: p_msg_count => l_msg_count,

Line 5229: elsif ( AK_UPLOAD_GRP.G_NO_CUSTOM_UPDATE ) then

5225: p_loader_timestamp => p_loader_timestamp,
5226: p_pass => p_pass,
5227: p_copy_redo_flag => l_copy_redo_flag
5228: );
5229: elsif ( AK_UPLOAD_GRP.G_NO_CUSTOM_UPDATE ) then
5230: -- update non-customized data only
5231: --
5232: select last_updated_by, last_update_date
5233: into l_user_id1, l_update1