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 3031: if AK_KEY_PVT.UNIQUE_KEY_EXISTS (

3027: --
3028: if (G_UNIQUE_KEY_REDO_INDEX > 0) then
3029: for l_index in G_UNIQUE_KEY_REDO_TBL.FIRST .. G_UNIQUE_KEY_REDO_TBL.LAST loop
3030: if (G_UNIQUE_KEY_REDO_TBL.exists(l_index)) then
3031: if AK_KEY_PVT.UNIQUE_KEY_EXISTS (
3032: p_api_version_number => 1.0,
3033: p_return_status => l_return_status,
3034: p_unique_key_name =>
3035: G_UNIQUE_KEY_REDO_TBL(l_index).unique_key_name) then

Line 3036: AK_KEY_PVT.UPDATE_UNIQUE_KEY (

3032: p_api_version_number => 1.0,
3033: p_return_status => l_return_status,
3034: p_unique_key_name =>
3035: G_UNIQUE_KEY_REDO_TBL(l_index).unique_key_name) then
3036: AK_KEY_PVT.UPDATE_UNIQUE_KEY (
3037: p_validation_level => p_validation_level,
3038: p_api_version_number => 1.0,
3039: p_msg_count => l_msg_count,
3040: p_msg_data => l_msg_data,

Line 3068: AK_KEY_PVT.CREATE_UNIQUE_KEY (

3064: p_pass => p_pass,
3065: p_copy_redo_flag => l_copy_redo_flag
3066: );
3067: else
3068: AK_KEY_PVT.CREATE_UNIQUE_KEY (
3069: p_validation_level => p_validation_level,
3070: p_api_version_number => 1.0,
3071: p_msg_count => l_msg_count,
3072: p_msg_data => l_msg_data,

Line 3118: if AK_KEY_PVT.UNIQUE_KEY_COLUMN_EXISTS (

3114: --
3115: if (G_UNIQUE_KEY_COL_REDO_INDEX > 0) then
3116: for l_index in G_UNIQUE_KEY_COL_REDO_TBL.FIRST .. G_UNIQUE_KEY_COL_REDO_TBL.LAST loop
3117: if (G_UNIQUE_KEY_COL_REDO_TBL.exists(l_index)) then
3118: if AK_KEY_PVT.UNIQUE_KEY_COLUMN_EXISTS (
3119: p_api_version_number => 1.0,
3120: p_return_status => l_return_status,
3121: p_unique_key_name =>
3122: G_UNIQUE_KEY_COL_REDO_TBL(l_index).unique_key_name,

Line 3127: AK_KEY_PVT.UPDATE_UNIQUE_KEY_COLUMN (

3123: p_attribute_application_id =>
3124: G_UNIQUE_KEY_COL_REDO_TBL(l_index).attribute_application_id,
3125: p_attribute_code =>
3126: G_UNIQUE_KEY_COL_REDO_TBL(l_index).attribute_code) then
3127: AK_KEY_PVT.UPDATE_UNIQUE_KEY_COLUMN (
3128: p_validation_level => p_validation_level,
3129: p_api_version_number => 1.0,
3130: p_msg_count => l_msg_count,
3131: p_msg_data => l_msg_data,

Line 3162: AK_KEY_PVT.CREATE_UNIQUE_KEY_COLUMN (

3158: p_pass => p_pass,
3159: p_copy_redo_flag => l_copy_redo_flag
3160: );
3161: else
3162: AK_KEY_PVT.CREATE_UNIQUE_KEY_COLUMN (
3163: p_validation_level => p_validation_level,
3164: p_api_version_number => 1.0,
3165: p_msg_count => l_msg_count,
3166: p_msg_data => l_msg_data,

Line 3215: if AK_KEY_PVT.FOREIGN_KEY_EXISTS (

3211: --
3212: if (G_FOREIGN_KEY_REDO_INDEX > 0) then
3213: for l_index in G_FOREIGN_KEY_REDO_TBL.FIRST .. G_FOREIGN_KEY_REDO_TBL.LAST loop
3214: if (G_FOREIGN_KEY_REDO_TBL.exists(l_index)) then
3215: if AK_KEY_PVT.FOREIGN_KEY_EXISTS (
3216: p_api_version_number => 1.0,
3217: p_return_status => l_return_status,
3218: p_foreign_key_name =>
3219: G_FOREIGN_KEY_REDO_TBL(l_index).foreign_key_name) then

Line 3220: AK_KEY_PVT.UPDATE_FOREIGN_KEY (

3216: p_api_version_number => 1.0,
3217: p_return_status => l_return_status,
3218: p_foreign_key_name =>
3219: G_FOREIGN_KEY_REDO_TBL(l_index).foreign_key_name) then
3220: AK_KEY_PVT.UPDATE_FOREIGN_KEY (
3221: p_validation_level => p_validation_level,
3222: p_api_version_number => 1.0,
3223: p_msg_count => l_msg_count,
3224: p_msg_data => l_msg_data,

Line 3260: AK_KEY_PVT.CREATE_FOREIGN_KEY (

3256: p_pass => p_pass,
3257: p_copy_redo_flag => l_copy_redo_flag
3258: );
3259: else
3260: AK_KEY_PVT.CREATE_FOREIGN_KEY (
3261: p_validation_level => p_validation_level,
3262: p_api_version_number => 1.0,
3263: p_msg_count => l_msg_count,
3264: p_msg_data => l_msg_data,

Line 3318: if AK_KEY_PVT.FOREIGN_KEY_COLUMN_EXISTS (

3314: --
3315: if (G_FOREIGN_KEY_COL_REDO_INDEX > 0) then
3316: for l_index in G_FOREIGN_KEY_COL_REDO_TBL.FIRST .. G_FOREIGN_KEY_COL_REDO_TBL.LAST loop
3317: if (G_FOREIGN_KEY_COL_REDO_TBL.exists(l_index)) then
3318: if AK_KEY_PVT.FOREIGN_KEY_COLUMN_EXISTS (
3319: p_api_version_number => 1.0,
3320: p_return_status => l_return_status,
3321: p_foreign_key_name =>
3322: G_FOREIGN_KEY_COL_REDO_TBL(l_index).foreign_key_name,

Line 3327: AK_KEY_PVT.UPDATE_FOREIGN_KEY_COLUMN (

3323: p_attribute_application_id =>
3324: G_FOREIGN_KEY_COL_REDO_TBL(l_index).attribute_application_id,
3325: p_attribute_code =>
3326: G_FOREIGN_KEY_COL_REDO_TBL(l_index).attribute_code) then
3327: AK_KEY_PVT.UPDATE_FOREIGN_KEY_COLUMN (
3328: p_validation_level => p_validation_level,
3329: p_api_version_number => 1.0,
3330: p_msg_count => l_msg_count,
3331: p_msg_data => l_msg_data,

Line 3362: AK_KEY_PVT.CREATE_FOREIGN_KEY_COLUMN (

3358: p_pass => p_pass,
3359: p_copy_redo_flag => l_copy_redo_flag
3360: );
3361: else
3362: AK_KEY_PVT.CREATE_FOREIGN_KEY_COLUMN (
3363: p_validation_level => p_validation_level,
3364: p_api_version_number => 1.0,
3365: p_msg_count => l_msg_count,
3366: p_msg_data => l_msg_data,