DBA Data[Home] [Help]

APPS.OE_LINE_SCREDIT_SECURITY dependencies on OE_PC_CONSTRAINTS

Line 42: l_result := OE_PC_Constraints_Admin_PVT.Is_OP_constrained

38: OE_Order_Cache.Load_Order_Header(p_record.header_id);
39: l_transaction_phase_code := oe_order_cache.g_header_rec.transaction_phase_code;
40: END IF;
41:
42: l_result := OE_PC_Constraints_Admin_PVT.Is_OP_constrained
43: ( p_responsibility_id => nvl(fnd_global.resp_id, -1)
44: , p_application_id => nvl(fnd_global.resp_appl_id,-1) --added for bug3631547
45: , p_operation => p_operation
46: , p_qualifier_attribute => l_transaction_phase_code

Line 65: FROM oe_pc_constraints

61: AND x_on_operation_action = 0
62: AND p_column_name IS NOT NULL THEN
63: SELECT column_name
64: INTO l_constrained_column
65: FROM oe_pc_constraints
66: WHERE constraint_id = l_constraint_id;
67: if l_constrained_column is null then
68: oe_debug_pub.add('There is an UPDATE constraint on all columns - Error',1);
69: RAISE FND_API.G_EXC_ERROR;

Line 810: IF NOT OE_PC_Constraints_Admin_PVT.Check_On_Insert_Exists

806: -- Bug 1755817: if there are no attribute-specific insert
807: -- constraints, then no need to go further. Entity level
808: -- security check for CREATE will be called again from
809: -- process order after defaulting.
810: IF NOT OE_PC_Constraints_Admin_PVT.Check_On_Insert_Exists
811: (p_entity_id => OE_PC_GLOBALS.G_ENTITY_LINE_SCREDIT
812: ,p_responsibility_id => nvl(fnd_global.resp_id, -1)
813: ,p_application_id => nvl(fnd_global.resp_appl_id,-1) --added for bug3631547
814: )