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_KEY_PVT

Line 4586: if AK_KEY_PVT.UNIQUE_KEY_EXISTS (

4582: --
4583: if (l_unique_key_tbl.count > 0) then
4584: for l_index in l_unique_key_tbl.FIRST .. l_unique_key_tbl.LAST loop
4585: if (l_unique_key_tbl.exists(l_index)) then
4586: if AK_KEY_PVT.UNIQUE_KEY_EXISTS (
4587: p_api_version_number => 1.0,
4588: p_return_status => l_return_status,
4589: p_unique_key_name =>
4590: l_unique_key_tbl(l_index).unique_key_name) then

Line 4595: AK_KEY_PVT.UPDATE_UNIQUE_KEY (

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,
4599: p_msg_data => l_msg_data,

Line 4634: AK_KEY_PVT.DELETE_RELATED_UNIQUE_KEY_COL (

4630: );
4631: --
4632: -- Delete all children records in AK_UNIQUE_KEY_COLUMNS so
4633: -- that obsolete columns would not exist after upload.
4634: AK_KEY_PVT.DELETE_RELATED_UNIQUE_KEY_COL (
4635: p_validation_level => p_validation_level,
4636: p_api_version_number => 1.0,
4637: p_msg_count => l_msg_count,
4638: p_msg_data => l_msg_data,

Line 4662: AK_KEY_PVT.UPDATE_UNIQUE_KEY (

4658: p_db_last_update_date => l_update1,
4659: p_last_update_login => l_unique_key_tbl(l_index).last_update_login,
4660: p_create_or_update => 'UPDATE') then
4661:
4662: AK_KEY_PVT.UPDATE_UNIQUE_KEY (
4663: p_validation_level => p_validation_level,
4664: p_api_version_number => 1.0,
4665: p_msg_count => l_msg_count,
4666: p_msg_data => l_msg_data,

Line 4701: AK_KEY_PVT.DELETE_RELATED_UNIQUE_KEY_COL (

4697: );
4698: --
4699: -- Delete all children records in AK_UNIQUE_KEY_COLUMNS so
4700: -- that obsolete columns would not exist after upload.
4701: AK_KEY_PVT.DELETE_RELATED_UNIQUE_KEY_COL (
4702: p_validation_level => p_validation_level,
4703: p_api_version_number => 1.0,
4704: p_msg_count => l_msg_count,
4705: p_msg_data => l_msg_data,

Line 4713: AK_KEY_PVT.CREATE_UNIQUE_KEY (

4709: );
4710: end if; -- /* if l_user_id1 = 1 */
4711: end if; -- /* if G_UPDATE_MODE G_NO_CUSTOM_UPDATE */
4712: else
4713: AK_KEY_PVT.CREATE_UNIQUE_KEY (
4714: p_validation_level => p_validation_level,
4715: p_api_version_number => 1.0,
4716: p_msg_count => l_msg_count,
4717: p_msg_data => l_msg_data,

Line 4773: if AK_KEY_PVT.UNIQUE_KEY_COLUMN_EXISTS (

4769: --
4770: if (l_unique_key_column_tbl.count > 0) then
4771: for l_index in l_unique_key_column_tbl.FIRST .. l_unique_key_column_tbl.LAST loop
4772: if (l_unique_key_column_tbl.exists(l_index)) then
4773: if AK_KEY_PVT.UNIQUE_KEY_COLUMN_EXISTS (
4774: p_api_version_number => 1.0,
4775: p_return_status => l_return_status,
4776: p_unique_key_name =>
4777: l_unique_key_column_tbl(l_index).unique_key_name,

Line 4786: AK_KEY_PVT.UPDATE_UNIQUE_KEY_COLUMN (

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,
4790: p_msg_data => l_msg_data,

Line 4844: AK_KEY_PVT.UPDATE_UNIQUE_KEY_COLUMN (

4840: p_db_last_update_date => l_update1,
4841: p_last_update_login => l_unique_key_column_tbl(l_index).last_update_login,
4842: p_create_or_update => 'UPDATE') then
4843:
4844: AK_KEY_PVT.UPDATE_UNIQUE_KEY_COLUMN (
4845: p_validation_level => p_validation_level,
4846: p_api_version_number => 1.0,
4847: p_msg_count => l_msg_count,
4848: p_msg_data => l_msg_data,

Line 4886: AK_KEY_PVT.CREATE_UNIQUE_KEY_COLUMN (

4882: );
4883: end if; -- /* if l_user_id1 = 1 */
4884: end if; -- /* if G_UPDATE_MODE G_NO_CUSTOM_UPDATE */
4885: else
4886: AK_KEY_PVT.CREATE_UNIQUE_KEY_COLUMN (
4887: p_validation_level => p_validation_level,
4888: p_api_version_number => 1.0,
4889: p_msg_count => l_msg_count,
4890: p_msg_data => l_msg_data,

Line 4950: if AK_KEY_PVT.FOREIGN_KEY_EXISTS (

4946: --
4947: if (l_foreign_key_tbl.count > 0) then
4948: for l_index in l_foreign_key_tbl.FIRST .. l_foreign_key_tbl.LAST loop
4949: if (l_foreign_key_tbl.exists(l_index)) then
4950: if AK_KEY_PVT.FOREIGN_KEY_EXISTS (
4951: p_api_version_number => 1.0,
4952: p_return_status => l_return_status,
4953: p_foreign_key_name =>
4954: l_foreign_key_tbl(l_index).foreign_key_name) then

Line 4959: AK_KEY_PVT.UPDATE_FOREIGN_KEY (

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,
4963: p_msg_data => l_msg_data,

Line 5007: AK_KEY_PVT.DELETE_RELATED_FOREIGN_KEY_COL (

5003: --
5004: -- Delete all children records in AK_FOREIGN_KEY_COLUMNS so
5005: -- that obsolete columns would not exist after upload.
5006:
5007: AK_KEY_PVT.DELETE_RELATED_FOREIGN_KEY_COL (
5008: p_validation_level => p_validation_level,
5009: p_api_version_number => 1.0,
5010: p_msg_count => l_msg_count,
5011: p_msg_data => l_msg_data,

Line 5049: AK_KEY_PVT.UPDATE_FOREIGN_KEY (

5045: p_db_last_update_date => l_update2,
5046: p_last_update_login => l_foreign_key_tbl(l_index).last_update_login,
5047: p_create_or_update => 'UPDATE')) then
5048:
5049: AK_KEY_PVT.UPDATE_FOREIGN_KEY (
5050: p_validation_level => p_validation_level,
5051: p_api_version_number => 1.0,
5052: p_msg_count => l_msg_count,
5053: p_msg_data => l_msg_data,

Line 5097: AK_KEY_PVT.DELETE_RELATED_FOREIGN_KEY_COL (

5093: --
5094: -- Delete all children records in AK_FOREIGN_KEY_COLUMNS so
5095: -- that obsolete columns would not exist after upload.
5096:
5097: AK_KEY_PVT.DELETE_RELATED_FOREIGN_KEY_COL (
5098: p_validation_level => p_validation_level,
5099: p_api_version_number => 1.0,
5100: p_msg_count => l_msg_count,
5101: p_msg_data => l_msg_data,

Line 5109: AK_KEY_PVT.CREATE_FOREIGN_KEY (

5105: );
5106: end if; -- /* if l_user_id1 = 1 and l_user_id2 = 1 */
5107: end if; -- /* G_UPDATE_MODE G_NO_CUSTOM_UPDATE */
5108: else
5109: AK_KEY_PVT.CREATE_FOREIGN_KEY (
5110: p_validation_level => p_validation_level,
5111: p_api_version_number => 1.0,
5112: p_msg_count => l_msg_count,
5113: p_msg_data => l_msg_data,

Line 5177: if AK_KEY_PVT.FOREIGN_KEY_COLUMN_EXISTS (

5173: --
5174: if (l_foreign_key_column_tbl.count > 0) then
5175: for l_index in l_foreign_key_column_tbl.FIRST .. l_foreign_key_column_tbl.LAST loop
5176: if (l_foreign_key_column_tbl.exists(l_index)) then
5177: if AK_KEY_PVT.FOREIGN_KEY_COLUMN_EXISTS (
5178: p_api_version_number => 1.0,
5179: p_return_status => l_return_status,
5180: p_foreign_key_name =>
5181: l_foreign_key_column_tbl(l_index).foreign_key_name,

Line 5190: AK_KEY_PVT.UPDATE_FOREIGN_KEY_COLUMN (

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,
5194: p_msg_data => l_msg_data,

Line 5250: AK_KEY_PVT.UPDATE_FOREIGN_KEY_COLUMN (

5246: p_db_last_update_date => l_update1,
5247: p_last_update_login => l_foreign_key_column_tbl(l_index).last_update_login,
5248: p_create_or_update => 'UPDATE') then
5249:
5250: AK_KEY_PVT.UPDATE_FOREIGN_KEY_COLUMN (
5251: p_validation_level => p_validation_level,
5252: p_api_version_number => 1.0,
5253: p_msg_count => l_msg_count,
5254: p_msg_data => l_msg_data,

Line 5292: AK_KEY_PVT.CREATE_FOREIGN_KEY_COLUMN (

5288: );
5289: end if; -- /* if l_user_id1 = 1 */
5290: end if; -- /* if G_UPDATE_MODE G_NO_CUSTOM_UPDATE */
5291: else
5292: AK_KEY_PVT.CREATE_FOREIGN_KEY_COLUMN (
5293: p_validation_level => p_validation_level,
5294: p_api_version_number => 1.0,
5295: p_msg_count => l_msg_count,
5296: p_msg_data => l_msg_data,