[Home] [Help]
42: -- Bug 1755817: if line belongs to a different order, then
43: -- clear the cached results so that the cache is reset for
44: -- the new order
45: IF p_record.header_id <> g_header_id THEN
46: OE_PC_Constraints_Admin_Pvt.Clear_Cached_Results;
47: g_header_id := p_record.header_id;
48: END IF;
49:
50: l_result := OE_PC_Constraints_Admin_PVT.Is_OP_constrained
46: OE_PC_Constraints_Admin_Pvt.Clear_Cached_Results;
47: g_header_id := p_record.header_id;
48: END IF;
49:
50: l_result := OE_PC_Constraints_Admin_PVT.Is_OP_constrained
51: ( p_responsibility_id => nvl(fnd_global.resp_id, -1)
52: , p_application_id => nvl(fnd_global.resp_appl_id,-1) --added for bug3631547
53: , p_operation => p_operation
54: , p_qualifier_attribute => p_record.transaction_phase_code
70: AND x_on_operation_action = 0
71: AND p_column_name IS NOT NULL THEN
72: SELECT column_name
73: INTO l_column_name
74: FROM oe_pc_constraints
75: WHERE constraint_id = l_constraint_id;
76: if l_column_name is null then
77: IF l_debug_level > 0 THEN
78: oe_debug_pub.add('There is an UPDATE constraint on all columns - Error',1);
3283: -- Bug 1755817: if there are no attribute-specific insert
3284: -- constraints, then no need to go further. Entity level
3285: -- security check for CREATE will be called again from
3286: -- process order after defaulting.
3287: IF NOT OE_PC_Constraints_Admin_PVT.Check_On_Insert_Exists
3288: (p_entity_id => OE_PC_GLOBALS.G_ENTITY_LINE
3289: ,p_responsibility_id => nvl(fnd_global.resp_id, -1)
3290: ,p_application_id => nvl(fnd_global.resp_appl_id,-1) --added for bug3631547
3291: )