DBA Data[Home] [Help]

APPS.OE_BLANKET_HEADER_SECURITY dependencies on OE_PC_CONSTRAINTS

Line 29: l_result := OE_PC_Constraints_Admin_PVT.Is_OP_constrained

25: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
26: --
27: BEGIN
28:
29: l_result := OE_PC_Constraints_Admin_PVT.Is_OP_constrained
30: ( p_responsibility_id => nvl(fnd_global.resp_id, -1)
31: , p_application_id => nvl(fnd_global.resp_appl_id,-1) --added for bug3631547
32: , p_operation => p_operation
33: , p_qualifier_attribute => p_record.transaction_phase_code

Line 51: FROM oe_pc_constraints

47: OR p_operation = OE_PC_GLOBALS.CREATE_OP)
48: AND p_column_name IS NOT NULL THEN
49: SELECT column_name
50: INTO l_column_name
51: FROM oe_pc_constraints
52: WHERE constraint_id = l_constraint_id;
53: if l_column_name is null and x_on_operation_action = 0 then
54: IF l_debug_level > 0 THEN
55: oe_debug_pub.add( 'CONSTRAINT ON UPDATE OF ALL COLUMNS!' ) ;

Line 1683: IF NOT OE_PC_Constraints_Admin_PVT.Check_On_Insert_Exists

1679: -- Bug 1755817: if there are no attribute-specific insert
1680: -- constraints, then no need to go further. Entity level
1681: -- security check for CREATE will be called again from
1682: -- process order after defaulting.
1683: IF NOT OE_PC_Constraints_Admin_PVT.Check_On_Insert_Exists
1684: (p_entity_id => OE_PC_GLOBALS.G_ENTITY_BLANKET_HEADER
1685: ,p_responsibility_id => nvl(fnd_global.resp_id, -1)
1686: ,p_application_id => nvl(fnd_global.resp_appl_id,-1) --added for bug3631547
1687: )