APPS.OE_HEADER_PAYMENT_SECURITY dependencies on OE_PC_CONSTRAINTS

Line 32: OE_PC_Constraints_Admin_Pvt.Clear_Cached_Results;

28: --
29: BEGIN
30:
31: IF p_record.header_id <> g_header_id THEN
32: OE_PC_Constraints_Admin_Pvt.Clear_Cached_Results;
33: g_header_id := p_record.header_id;
34: END IF;
35:
36: IF l_code_level >= '110510' THEN

Line 41: l_result := OE_PC_Constraints_Admin_PVT.Is_OP_constrained

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

Line 62: FROM oe_pc_constraints

58: IF g_check_all_cols_constraint = 'Y' AND (p_operation = OE_PC_GLOBALS.UPDATE_OP
59: OR p_operation = OE_PC_GLOBALS.CREATE_OP) AND p_column_name IS NOT NULL THEN
60: SELECT column_name
61: INTO l_constrained_column
62: FROM oe_pc_constraints
63: WHERE constraint_id = l_constraint_id;
64: if l_constrained_column is null AND x_on_operation_action = 0 then
65: oe_debug_pub.add('There is an UPDATE constraint on all columns - Error',1);
66: RAISE FND_API.G_EXC_ERROR;

Line 959: IF NOT OE_PC_Constraints_Admin_PVT.Check_On_Insert_Exists

955: -- Bug 1755817: if there are no attribute-specific insert
956: -- constraints, then no need to go further. Entity level
957: -- security check for CREATE will be called again from
958: -- process order after defaulting.
959: IF NOT OE_PC_Constraints_Admin_PVT.Check_On_Insert_Exists
960: (p_entity_id => OE_PC_GLOBALS.G_ENTITY_HEADER_PAYMENT
961: ,p_responsibility_id => nvl(fnd_global.resp_id, -1)
962: , p_application_id => nvl(fnd_global.resp_appl_id,-1) --added for bug3631547
963: )