APPS.OE_PC_CONSTRAINTS_ADMIN_PVT dependencies on OE_PC_CONSTRAINTS_ADMIN_PVT

Line 1: PACKAGE BODY Oe_PC_Constraints_Admin_Pvt as

1: PACKAGE BODY Oe_PC_Constraints_Admin_Pvt as
2: /* $Header: OEXVPCAB.pls 120.1 2007/11/26 09:32:16 vbkapoor ship $ */
3:
4: -- Global constant holding the package name
5:

Line 6: G_PKG_NAME CONSTANT VARCHAR2(30) := 'Oe_PC_Constraints_Admin_Pvt';

2: /* $Header: OEXVPCAB.pls 120.1 2007/11/26 09:32:16 vbkapoor ship $ */
3:
4: -- Global constant holding the package name
5:
6: G_PKG_NAME CONSTANT VARCHAR2(30) := 'Oe_PC_Constraints_Admin_Pvt';
7:
8: -- Record/Table used to cache conditions for a constraint
9: TYPE ConstraintRule_Rec_Type IS RECORD
10: (

Line 2170: oe_debug_pub.add( 'ENTER OE_PC_CONSTRAINTS_ADMIN_PVT.IS_OP_CONSTRAINED , COLUMN:' || P_COLUMN_NAME , 1 ) ;

2166: --
2167: BEGIN
2168:
2169: IF l_debug_level > 0 THEN
2170: oe_debug_pub.add( 'ENTER OE_PC_CONSTRAINTS_ADMIN_PVT.IS_OP_CONSTRAINED , COLUMN:' || P_COLUMN_NAME , 1 ) ;
2171: END IF;
2172:
2173: l_validation_result := OE_PC_GLOBALS.NO;
2174:

Line 2191: OE_PC_Constraints_Admin_Pvt.Validate_Constraint (

2187: t_column_names;
2188: CLOSE c_create_op;
2189:
2190: FOR i IN 1..t_constraint_ids.count LOOP
2191: OE_PC_Constraints_Admin_Pvt.Validate_Constraint (
2192: p_constraint_id => t_constraint_ids(i)
2193: ,p_use_cached_results => p_use_cached_results
2194: ,x_condition_count => l_condition_count
2195: ,x_valid_condition_group => l_valid_condition_group

Line 2236: OE_PC_Constraints_Admin_Pvt.Validate_Constraint (

2232: END IF;
2233:
2234: IF G_Check_On_Insert_Cache(l_index).column_name = p_column_name THEN
2235:
2236: OE_PC_Constraints_Admin_Pvt.Validate_Constraint (
2237: p_constraint_id
2238: => G_Check_On_Insert_Cache(l_index).constraint_id
2239: ,p_use_cached_results => p_use_cached_results
2240: ,x_condition_count => l_condition_count

Line 2270: OE_PC_Constraints_Admin_Pvt.Validate_Constraint (

2266: t_column_names;
2267: CLOSE c_update_op;
2268:
2269: FOR i IN 1..t_constraint_ids.count LOOP
2270: OE_PC_Constraints_Admin_Pvt.Validate_Constraint (
2271: p_constraint_id => t_constraint_ids(i)
2272: ,p_use_cached_results => p_use_cached_results
2273: ,x_condition_count => l_condition_count
2274: ,x_valid_condition_group => l_valid_condition_group

Line 2298: OE_PC_Constraints_Admin_Pvt.Validate_Constraint (

2294: t_column_names;
2295: CLOSE c_c;
2296:
2297: FOR i IN 1..t_constraint_ids.count LOOP
2298: OE_PC_Constraints_Admin_Pvt.Validate_Constraint (
2299: p_constraint_id => t_constraint_ids(i)
2300: ,p_use_cached_results => p_use_cached_results
2301: ,x_condition_count => l_condition_count
2302: ,x_valid_condition_group => l_valid_condition_group

Line 2346: oe_debug_pub.add( 'EXIT OE_PC_CONSTRAINTS_ADMIN_PVT.IS_OP_CONSTRAINED , RESULT:' ||L_VALIDATION_RESULT , 1 ) ;

2342:
2343: END IF;
2344:
2345: IF l_debug_level > 0 THEN
2346: oe_debug_pub.add( 'EXIT OE_PC_CONSTRAINTS_ADMIN_PVT.IS_OP_CONSTRAINED , RESULT:' ||L_VALIDATION_RESULT , 1 ) ;
2347: END IF;
2348: RETURN l_validation_result;
2349:
2350: EXCEPTION

Line 2361: END Oe_PC_Constraints_Admin_Pvt;

2357: END IF;
2358: RETURN OE_PC_GLOBALS.ERROR;
2359: END Is_Op_Constrained;
2360:
2361: END Oe_PC_Constraints_Admin_Pvt;