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_KEY_PVT dependencies on AK_KEY_PVT

Line 1: package body AK_KEY_PVT as

1: package body AK_KEY_PVT as
2: /* $Header: akdvkeyb.pls 120.3 2005/09/15 22:18:28 tshort ship $: AKDVKEYB.pls */
3:
4: --=======================================================
5: -- Procedure CREATE_FOREIGN_KEY

Line 117: if AK_KEY_PVT.FOREIGN_KEY_EXISTS (

113:
114: savepoint start_create_foreign_key;
115:
116: --** check to see if row already exists **
117: if AK_KEY_PVT.FOREIGN_KEY_EXISTS (
118: p_api_version_number => 1.0,
119: p_return_status => l_return_status,
120: p_foreign_key_name => p_foreign_key_name) then
121: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then

Line 325: if NOT AK_KEY_PVT.FOREIGN_KEY_EXISTS (

321: l_last_update_login
322: );
323:
324: --** row should exists before inserting rows for other languages **
325: if NOT AK_KEY_PVT.FOREIGN_KEY_EXISTS (
326: p_api_version_number => 1.0,
327: p_return_status => l_return_status,
328: p_foreign_key_name => p_foreign_key_name) then
329: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) THEN

Line 523: if AK_KEY_PVT.FOREIGN_KEY_COLUMN_EXISTS (

519:
520: savepoint start_create_key_column;
521:
522: --** check to see if row already exists **
523: if AK_KEY_PVT.FOREIGN_KEY_COLUMN_EXISTS (
524: p_api_version_number => 1.0,
525: p_return_status => l_return_status,
526: p_foreign_key_name => p_foreign_key_name,
527: p_attribute_application_id => p_attribute_application_id,

Line 875: if AK_KEY_PVT.UNIQUE_KEY_EXISTS (

871:
872: savepoint start_create_unique_key;
873:
874: --** check to see if row already exists **
875: if AK_KEY_PVT.UNIQUE_KEY_EXISTS (
876: p_api_version_number => 1.0,
877: p_return_status => l_return_status,
878: p_unique_key_name => p_unique_key_name) then
879: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then

Line 1209: if AK_KEY_PVT.UNIQUE_KEY_COLUMN_EXISTS (

1205:
1206: savepoint start_create_key_column;
1207:
1208: --** check to see if row already exists **
1209: if AK_KEY_PVT.UNIQUE_KEY_COLUMN_EXISTS (
1210: p_api_version_number => 1.0,
1211: p_return_status => l_return_status,
1212: p_unique_key_name => p_unique_key_name,
1213: p_attribute_application_id => p_attribute_application_id,

Line 1532: if NOT AK_KEY_PVT.FOREIGN_KEY_EXISTS (

1528:
1529: --
1530: -- error if foreign key to be deleted does not exists
1531: --
1532: if NOT AK_KEY_PVT.FOREIGN_KEY_EXISTS (
1533: p_api_version_number => 1.0,
1534: p_return_status => l_return_status,
1535: p_foreign_key_name => p_foreign_key_name) then
1536: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then

Line 1591: AK_KEY_PVT.DELETE_FOREIGN_KEY_COLUMN (

1587: open l_get_columns_csr;
1588: loop
1589: fetch l_get_columns_csr into l_attribute_appl_id, l_attribute_code;
1590: exit when l_get_columns_csr%notfound;
1591: AK_KEY_PVT.DELETE_FOREIGN_KEY_COLUMN (
1592: p_validation_level => p_validation_level,
1593: p_api_version_number => 1.0,
1594: p_msg_count => l_msg_count,
1595: p_msg_data => l_msg_data,

Line 1774: if NOT AK_KEY_PVT.FOREIGN_KEY_COLUMN_EXISTS (

1770:
1771: --
1772: -- error if foreign key to be deleted does not exists
1773: --
1774: if NOT AK_KEY_PVT.FOREIGN_KEY_COLUMN_EXISTS (
1775: p_api_version_number => 1.0,
1776: p_return_status => l_return_status,
1777: p_foreign_key_name => p_foreign_key_name,
1778: p_attribute_application_id => p_attribute_application_id,

Line 1936: if NOT AK_KEY_PVT.UNIQUE_KEY_EXISTS (

1932:
1933: --
1934: -- error if foreign key to be deleted does not exists
1935: --
1936: if NOT AK_KEY_PVT.UNIQUE_KEY_EXISTS (
1937: p_api_version_number => 1.0,
1938: p_return_status => l_return_status,
1939: p_unique_key_name => p_unique_key_name) then
1940: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then

Line 1991: AK_KEY_PVT.DELETE_UNIQUE_KEY_COLUMN (

1987: open l_get_columns_csr;
1988: loop
1989: fetch l_get_columns_csr into l_attribute_appl_id, l_attribute_code;
1990: exit when l_get_columns_csr%notfound;
1991: AK_KEY_PVT.DELETE_UNIQUE_KEY_COLUMN (
1992: p_validation_level => p_validation_level,
1993: p_api_version_number => 1.0,
1994: p_msg_count => l_msg_count,
1995: p_msg_data => l_msg_data,

Line 2016: AK_KEY_PVT.DELETE_FOREIGN_KEY (

2012: open l_get_fk_csr;
2013: loop
2014: fetch l_get_fk_csr into l_foreign_key_name;
2015: exit when l_get_fk_csr%notfound;
2016: AK_KEY_PVT.DELETE_FOREIGN_KEY (
2017: p_validation_level => p_validation_level,
2018: p_api_version_number => 1.0,
2019: p_msg_count => l_msg_count,
2020: p_msg_data => l_msg_data,

Line 2167: if NOT AK_KEY_PVT.UNIQUE_KEY_COLUMN_EXISTS (

2163:
2164: --
2165: -- error if unique key to be deleted does not exists
2166: --
2167: if NOT AK_KEY_PVT.UNIQUE_KEY_COLUMN_EXISTS (
2168: p_api_version_number => 1.0,
2169: p_return_status => l_return_status,
2170: p_unique_key_name => p_unique_key_name,
2171: p_attribute_application_id => p_attribute_application_id,

Line 2214: AK_KEY_PVT.DELETE_FOREIGN_KEY_COLUMN(

2210: loop
2211: fetch l_get_fkc_csr into l_foreign_key_name, l_attribute_appl_id,
2212: l_attribute_code;
2213: exit when l_get_fkc_csr%notfound;
2214: AK_KEY_PVT.DELETE_FOREIGN_KEY_COLUMN(
2215: p_validation_level => p_validation_level,
2216: p_api_version_number => 1.0,
2217: p_msg_count => l_msg_count,
2218: p_msg_data => l_msg_data,

Line 4008: if (NOT AK_KEY_PVT.UNIQUE_KEY_EXISTS (

4004: end if;
4005:
4006: -- - unique_key_name
4007: if (p_unique_key_name <> FND_API.G_MISS_CHAR) then
4008: if (NOT AK_KEY_PVT.UNIQUE_KEY_EXISTS (
4009: p_api_version_number => 1.0,
4010: p_return_status => l_return_status,
4011: p_unique_key_name => p_unique_key_name) ) then
4012: l_error := TRUE;

Line 4630: AK_KEY_PVT.DELETE_FOREIGN_KEY_COLUMN (

4626: -- Delete the record in foreign_key_column that has the same
4627: -- foreign_key_name and foreign_key_sequence, but has different
4628: -- attribute_code or attribute_application_id
4629: --
4630: AK_KEY_PVT.DELETE_FOREIGN_KEY_COLUMN (
4631: p_validation_level => p_validation_level,
4632: p_api_version_number => 1.0,
4633: p_msg_count => l_msg_count,
4634: p_msg_data => l_msg_data,

Line 4711: AK_KEY_PVT.DELETE_FOREIGN_KEY_COLUMN (

4707:
4708: savepoint start_delete_rel_foreign_col;
4709:
4710: for csr_rec in l_get_columns_csr loop
4711: AK_KEY_PVT.DELETE_FOREIGN_KEY_COLUMN (
4712: p_validation_level => p_validation_level,
4713: p_api_version_number => 1.0,
4714: p_msg_count => l_msg_count,
4715: p_msg_data => l_msg_data,

Line 4807: AK_KEY_PVT.DELETE_UNIQUE_KEY_COLUMN (

4803: --
4804: -- p_override flag is set to 'Y' here so that only AK_UNIQUE_KEY_COLUMNS
4805: -- get deleted, other references would not be deleted and would not be
4806: -- checked.
4807: AK_KEY_PVT.DELETE_UNIQUE_KEY_COLUMN (
4808: p_validation_level => p_validation_level,
4809: p_api_version_number => 1.0,
4810: p_msg_count => l_msg_count,
4811: p_msg_data => l_msg_data,

Line 4856: end AK_KEY_PVT;

4852: p_count => p_msg_count,
4853: p_data => p_msg_data);
4854: end DELETE_RELATED_UNIQUE_KEY_COL;
4855:
4856: end AK_KEY_PVT;