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.OE_PC_CONSTRAINTS_ADMIN_PVT dependencies on OE_PC_CONSTRAINTS

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 1523: FROM oe_pc_constraints c

1519: IS
1520: SELECT
1521: c.constraint_id, c.entity_id
1522: ,c.on_operation_action, c.column_name
1523: FROM oe_pc_constraints c
1524: WHERE c.entity_id = P_ENTITY_ID
1525: AND c.constrained_operation = OE_PC_GLOBALS.UPDATE_OP
1526: AND c.check_on_insert_flag = 'Y'
1527: AND nvl(c.enabled_flag, 'Y') = 'Y'

Line 2064: FROM oe_pc_constraints c

2060: IS
2061: SELECT
2062: c.constraint_id, c.entity_id
2063: ,c.on_operation_action, c.column_name
2064: FROM oe_pc_constraints c
2065: WHERE c.entity_id = P_ENTITY_ID
2066: AND c.constrained_operation = OE_PC_GLOBALS.CREATE_OP
2067: AND EXISTS (
2068: SELECT 'EXISTS'

Line 2095: FROM oe_pc_constraints c

2091: IS
2092: SELECT
2093: c.constraint_id, c.entity_id
2094: ,c.on_operation_action, c.column_name
2095: FROM oe_pc_constraints c
2096: WHERE c.entity_id = P_ENTITY_ID
2097: AND c.constrained_operation = OE_PC_GLOBALS.UPDATE_OP
2098: -- if p_column_name is NULL then check only for constraints with NULL column
2099: -- name

Line 2142: FROM oe_pc_constraints c,

2138: IS
2139: SELECT DISTINCT
2140: c.constraint_id, c.entity_id
2141: ,c.on_operation_action, c.column_name
2142: FROM oe_pc_constraints c,
2143: oe_pc_assignments a
2144: WHERE (a.responsibility_id = p_responsibility_id OR a.responsibility_id IS NULL)
2145: AND a.constraint_id = c.constraint_id
2146: AND c.entity_id = P_ENTITY_ID

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 2333: OE_PC_Constraints_Admin_PUB.Add_Constraint_Message

2329: END IF;
2330: -- l_column_name is the name of the column on the constraint
2331: -- This maybe NULL if update on all columns is constrained
2332: -- (even if p_column_name is not null)
2333: OE_PC_Constraints_Admin_PUB.Add_Constraint_Message
2334: ( p_application_id => 660
2335: , p_database_object_name => l_db_object_name
2336: , p_column_name => l_column_name
2337: , p_operation => p_operation

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;