DBA Data[Home] [Help]

APPS.AK_OBJECT2_PVT dependencies on AK_KEY_PVT

Line 854: not AK_KEY_PVT.VALIDATE_FOREIGN_KEY (

850: fetch l_get_foreign_key_tl_csr into l_foreign_keys_tl_rec;
851: if (l_get_foreign_key_tl_csr%found) then
852: -- write this foreign key to buffer if it is valid
853: if (p_validation_level <> FND_API.G_VALID_LEVEL_NONE) and
854: not AK_KEY_PVT.VALIDATE_FOREIGN_KEY (
855: p_validation_level => p_validation_level,
856: p_api_version_number => 1.0,
857: p_return_status => l_return_status,
858: p_foreign_key_name => l_foreign_keys_rec.foreign_key_name,

Line 1053: not AK_KEY_PVT.VALIDATE_FOREIGN_KEY_COLUMN (

1049: fetch l_get_key_columns_csr into l_key_columns_rec;
1050: exit when l_get_key_columns_csr%notfound;
1051: -- Write foreign key column if it is valid
1052: if (p_validation_level <> FND_API.G_VALID_LEVEL_NONE) and
1053: not AK_KEY_PVT.VALIDATE_FOREIGN_KEY_COLUMN (
1054: p_validation_level => p_validation_level,
1055: p_api_version_number => 1.0,
1056: p_return_status => l_return_status,
1057: p_foreign_key_name => l_key_columns_rec.foreign_key_name,

Line 1362: not AK_KEY_PVT.VALIDATE_UNIQUE_KEY (

1358: fetch l_get_unique_keys_csr into l_unique_keys_rec;
1359: exit when l_get_unique_keys_csr%notfound;
1360: -- write this unique key to buffer if it is valid
1361: if (p_validation_level <> FND_API.G_VALID_LEVEL_NONE) and
1362: not AK_KEY_PVT.VALIDATE_UNIQUE_KEY (
1363: p_validation_level => p_validation_level,
1364: p_api_version_number => 1.0,
1365: p_return_status => l_return_status,
1366: p_unique_key_name => l_unique_keys_rec.unique_key_name,

Line 1527: not AK_KEY_PVT.VALIDATE_UNIQUE_KEY_COLUMN (

1523: loop
1524: fetch l_get_key_columns_csr into l_key_columns_rec;
1525: exit when l_get_key_columns_csr%notfound;
1526: if (p_validation_level <> FND_API.G_VALID_LEVEL_NONE) and
1527: not AK_KEY_PVT.VALIDATE_UNIQUE_KEY_COLUMN (
1528: p_validation_level => p_validation_level,
1529: p_api_version_number => 1.0,
1530: p_return_status => l_return_status,
1531: p_unique_key_name => l_key_columns_rec.unique_key_name,

Line 3037: if AK_KEY_PVT.UNIQUE_KEY_EXISTS (

3033: --
3034: if (G_UNIQUE_KEY_REDO_INDEX > 0) then
3035: for l_index in G_UNIQUE_KEY_REDO_TBL.FIRST .. G_UNIQUE_KEY_REDO_TBL.LAST loop
3036: if (G_UNIQUE_KEY_REDO_TBL.exists(l_index)) then
3037: if AK_KEY_PVT.UNIQUE_KEY_EXISTS (
3038: p_api_version_number => 1.0,
3039: p_return_status => l_return_status,
3040: p_unique_key_name =>
3041: G_UNIQUE_KEY_REDO_TBL(l_index).unique_key_name) then

Line 3042: AK_KEY_PVT.UPDATE_UNIQUE_KEY (

3038: p_api_version_number => 1.0,
3039: p_return_status => l_return_status,
3040: p_unique_key_name =>
3041: G_UNIQUE_KEY_REDO_TBL(l_index).unique_key_name) then
3042: AK_KEY_PVT.UPDATE_UNIQUE_KEY (
3043: p_validation_level => p_validation_level,
3044: p_api_version_number => 1.0,
3045: p_msg_count => l_msg_count,
3046: p_msg_data => l_msg_data,

Line 3074: AK_KEY_PVT.CREATE_UNIQUE_KEY (

3070: p_pass => p_pass,
3071: p_copy_redo_flag => l_copy_redo_flag
3072: );
3073: else
3074: AK_KEY_PVT.CREATE_UNIQUE_KEY (
3075: p_validation_level => p_validation_level,
3076: p_api_version_number => 1.0,
3077: p_msg_count => l_msg_count,
3078: p_msg_data => l_msg_data,

Line 3126: if AK_KEY_PVT.UNIQUE_KEY_COLUMN_EXISTS (

3122: --
3123: if (G_UNIQUE_KEY_COL_REDO_INDEX > 0) then
3124: for l_index in G_UNIQUE_KEY_COL_REDO_TBL.FIRST .. G_UNIQUE_KEY_COL_REDO_TBL.LAST loop
3125: if (G_UNIQUE_KEY_COL_REDO_TBL.exists(l_index)) then
3126: if AK_KEY_PVT.UNIQUE_KEY_COLUMN_EXISTS (
3127: p_api_version_number => 1.0,
3128: p_return_status => l_return_status,
3129: p_unique_key_name =>
3130: G_UNIQUE_KEY_COL_REDO_TBL(l_index).unique_key_name,

Line 3135: AK_KEY_PVT.UPDATE_UNIQUE_KEY_COLUMN (

3131: p_attribute_application_id =>
3132: G_UNIQUE_KEY_COL_REDO_TBL(l_index).attribute_application_id,
3133: p_attribute_code =>
3134: G_UNIQUE_KEY_COL_REDO_TBL(l_index).attribute_code) then
3135: AK_KEY_PVT.UPDATE_UNIQUE_KEY_COLUMN (
3136: p_validation_level => p_validation_level,
3137: p_api_version_number => 1.0,
3138: p_msg_count => l_msg_count,
3139: p_msg_data => l_msg_data,

Line 3170: AK_KEY_PVT.CREATE_UNIQUE_KEY_COLUMN (

3166: p_pass => p_pass,
3167: p_copy_redo_flag => l_copy_redo_flag
3168: );
3169: else
3170: AK_KEY_PVT.CREATE_UNIQUE_KEY_COLUMN (
3171: p_validation_level => p_validation_level,
3172: p_api_version_number => 1.0,
3173: p_msg_count => l_msg_count,
3174: p_msg_data => l_msg_data,

Line 3225: if AK_KEY_PVT.FOREIGN_KEY_EXISTS (

3221: --
3222: if (G_FOREIGN_KEY_REDO_INDEX > 0) then
3223: for l_index in G_FOREIGN_KEY_REDO_TBL.FIRST .. G_FOREIGN_KEY_REDO_TBL.LAST loop
3224: if (G_FOREIGN_KEY_REDO_TBL.exists(l_index)) then
3225: if AK_KEY_PVT.FOREIGN_KEY_EXISTS (
3226: p_api_version_number => 1.0,
3227: p_return_status => l_return_status,
3228: p_foreign_key_name =>
3229: G_FOREIGN_KEY_REDO_TBL(l_index).foreign_key_name) then

Line 3230: AK_KEY_PVT.UPDATE_FOREIGN_KEY (

3226: p_api_version_number => 1.0,
3227: p_return_status => l_return_status,
3228: p_foreign_key_name =>
3229: G_FOREIGN_KEY_REDO_TBL(l_index).foreign_key_name) then
3230: AK_KEY_PVT.UPDATE_FOREIGN_KEY (
3231: p_validation_level => p_validation_level,
3232: p_api_version_number => 1.0,
3233: p_msg_count => l_msg_count,
3234: p_msg_data => l_msg_data,

Line 3270: AK_KEY_PVT.CREATE_FOREIGN_KEY (

3266: p_pass => p_pass,
3267: p_copy_redo_flag => l_copy_redo_flag
3268: );
3269: else
3270: AK_KEY_PVT.CREATE_FOREIGN_KEY (
3271: p_validation_level => p_validation_level,
3272: p_api_version_number => 1.0,
3273: p_msg_count => l_msg_count,
3274: p_msg_data => l_msg_data,

Line 3330: if AK_KEY_PVT.FOREIGN_KEY_COLUMN_EXISTS (

3326: --
3327: if (G_FOREIGN_KEY_COL_REDO_INDEX > 0) then
3328: for l_index in G_FOREIGN_KEY_COL_REDO_TBL.FIRST .. G_FOREIGN_KEY_COL_REDO_TBL.LAST loop
3329: if (G_FOREIGN_KEY_COL_REDO_TBL.exists(l_index)) then
3330: if AK_KEY_PVT.FOREIGN_KEY_COLUMN_EXISTS (
3331: p_api_version_number => 1.0,
3332: p_return_status => l_return_status,
3333: p_foreign_key_name =>
3334: G_FOREIGN_KEY_COL_REDO_TBL(l_index).foreign_key_name,

Line 3339: AK_KEY_PVT.UPDATE_FOREIGN_KEY_COLUMN (

3335: p_attribute_application_id =>
3336: G_FOREIGN_KEY_COL_REDO_TBL(l_index).attribute_application_id,
3337: p_attribute_code =>
3338: G_FOREIGN_KEY_COL_REDO_TBL(l_index).attribute_code) then
3339: AK_KEY_PVT.UPDATE_FOREIGN_KEY_COLUMN (
3340: p_validation_level => p_validation_level,
3341: p_api_version_number => 1.0,
3342: p_msg_count => l_msg_count,
3343: p_msg_data => l_msg_data,

Line 3374: AK_KEY_PVT.CREATE_FOREIGN_KEY_COLUMN (

3370: p_pass => p_pass,
3371: p_copy_redo_flag => l_copy_redo_flag
3372: );
3373: else
3374: AK_KEY_PVT.CREATE_FOREIGN_KEY_COLUMN (
3375: p_validation_level => p_validation_level,
3376: p_api_version_number => 1.0,
3377: p_msg_count => l_msg_count,
3378: p_msg_data => l_msg_data,