APPS.OE_LINE_ADJ_PCFWK dependencies on OE_PC_GLOBALS

Line 67: l_ConstrainedStatus := OE_PC_GLOBALS.NO;

63: l_currGrpNumber number;
64: l_currGrpResult boolean;
65: BEGIN
66:
67: l_ConstrainedStatus := OE_PC_GLOBALS.NO;
68: l_rule_count := 0;
69: i := 0;
70: l_currGrpNumber := -1;
71: l_currGrpResult := FALSE;

Line 92: l_ConstrainedStatus := OE_PC_GLOBALS.YES;

88:
89: -- EXIT from loop
90: IF (C_R%NOTFOUND) THEN
91: IF (l_currGrpNumber <> -1 AND l_currGrpResult = TRUE) THEN
92: l_ConstrainedStatus := OE_PC_GLOBALS.YES;
93: END IF;
94: EXIT; -- exit the loop
95: END IF;
96:

Line 101: -- to TRUE (OE_PC_GLOBALS.YES) then no need to evaluvate this group.

97: IF (l_currGrpNumber <> l_constraintRuleRec.group_number) THEN
98:
99: -- we are entering the new group of conditions..
100: -- groups are ORd together, so if the previous group was evaluated
101: -- to TRUE (OE_PC_GLOBALS.YES) then no need to evaluvate this group.
102: IF (l_currGrpResult = TRUE) THEN
103: l_ConstrainedStatus := OE_PC_GLOBALS.YES;
104: EXIT; -- exit the loop
105: END IF;

Line 103: l_ConstrainedStatus := OE_PC_GLOBALS.YES;

99: -- we are entering the new group of conditions..
100: -- groups are ORd together, so if the previous group was evaluated
101: -- to TRUE (OE_PC_GLOBALS.YES) then no need to evaluvate this group.
102: IF (l_currGrpResult = TRUE) THEN
103: l_ConstrainedStatus := OE_PC_GLOBALS.YES;
104: EXIT; -- exit the loop
105: END IF;
106:
107: -- previous group did not evaluvate to TRUE, so lets pursue this new group

Line 149: if(l_constraintRuleRec.modifier_flag = OE_PC_GLOBALS.YES_FLAG) then

145: ELSE
146: l_tempResult := TRUE;
147: END IF;
148: -- apply the modifier on the result
149: if(l_constraintRuleRec.modifier_flag = OE_PC_GLOBALS.YES_FLAG) then
150: l_tempResult := NOT(l_tempResult);
151: end if;
152:
153: IF (i = 0) THEN

Line 168: x_result := OE_PC_GLOBALS.YES;

164: -- constraint is valid and we will return YES
165: IF (l_rule_count = 0) THEN
166: x_condition_count := 0;
167: x_valid_condition_group := -1;
168: x_result := OE_PC_GLOBALS.YES;
169: ELSE
170: x_condition_count := l_rule_count;
171: x_valid_condition_group := l_currGrpNumber;
172: x_result := l_ConstrainedStatus;

Line 177: x_result := OE_PC_GLOBALS.ERROR;

173: END IF;
174: -------------------------------------------
175: EXCEPTION
176: WHEN OTHERS THEN
177: x_result := OE_PC_GLOBALS.ERROR;
178: END Validate_Constraint;
179: -------------------------------------------
180: -------------------------------------------
181: FUNCTION Is_Op_Constrained

Line 237: AND ( ( c.constrained_operation = OE_PC_GLOBALS.CREATE_OP

233: oe_pc_assignments a
234: WHERE (a.responsibility_id = p_responsibility_id OR a.responsibility_id IS NULL)
235: AND a.constraint_id = c.constraint_id
236: AND c.entity_id = G_ENTITY_ID
237: AND ( ( c.constrained_operation = OE_PC_GLOBALS.CREATE_OP
238: AND p_column_name IS NULL )
239: OR ( c.constrained_operation = OE_PC_GLOBALS.UPDATE_OP
240: AND c.check_on_insert_flag = 'Y'
241: AND nvl(c.column_name, '#NULL')= NVL(p_column_name,'#NULL' ) )

Line 239: OR ( c.constrained_operation = OE_PC_GLOBALS.UPDATE_OP

235: AND a.constraint_id = c.constraint_id
236: AND c.entity_id = G_ENTITY_ID
237: AND ( ( c.constrained_operation = OE_PC_GLOBALS.CREATE_OP
238: AND p_column_name IS NULL )
239: OR ( c.constrained_operation = OE_PC_GLOBALS.UPDATE_OP
240: AND c.check_on_insert_flag = 'Y'
241: AND nvl(c.column_name, '#NULL')= NVL(p_column_name,'#NULL' ) )
242: )
243: -- if caller is defaulting then DO NOT CHECK those constraints

Line 260: l_validation_result := OE_PC_GLOBALS.NO;

256: l_condition_count number;
257: l_valid_condition_group number;
258: BEGIN
259: g_record := p_record;
260: l_validation_result := OE_PC_GLOBALS.NO;
261:
262: IF p_operation = OE_PC_GLOBALS.CREATE_OP THEN
263:
264: FOR c_rec in C_CREATE_OP LOOP

Line 262: IF p_operation = OE_PC_GLOBALS.CREATE_OP THEN

258: BEGIN
259: g_record := p_record;
260: l_validation_result := OE_PC_GLOBALS.NO;
261:
262: IF p_operation = OE_PC_GLOBALS.CREATE_OP THEN
263:
264: FOR c_rec in C_CREATE_OP LOOP
265: Validate_Constraint (
266: p_constraint_id => c_rec.constraint_id

Line 271: IF (l_condition_count = 0 OR l_validation_result = OE_PC_GLOBALS.YES) then

267: ,x_condition_count => l_condition_count
268: ,x_valid_condition_group => l_valid_condition_group
269: ,x_result => l_validation_result
270: );
271: IF (l_condition_count = 0 OR l_validation_result = OE_PC_GLOBALS.YES) then
272: x_constraint_id := c_rec.constraint_id;
273: x_on_operation_action := c_rec.on_operation_action;
274: x_constraining_conditions_grp := l_valid_condition_group;
275: EXIT;

Line 287: IF (l_condition_count = 0 OR l_validation_result = OE_PC_GLOBALS.YES) then

283: ,x_condition_count => l_condition_count
284: ,x_valid_condition_group => l_valid_condition_group
285: ,x_result => l_validation_result
286: );
287: IF (l_condition_count = 0 OR l_validation_result = OE_PC_GLOBALS.YES) then
288: x_constraint_id := c_rec.constraint_id;
289: x_on_operation_action := c_rec.on_operation_action;
290: x_constraining_conditions_grp := l_valid_condition_group;
291: EXIT;

Line 299: RETURN OE_PC_GLOBALS.ERROR;

295:
296: return l_validation_result;
297: EXCEPTION
298: WHEN OTHERS THEN
299: RETURN OE_PC_GLOBALS.ERROR;
300: END Is_Op_Constrained;
301: -------------------------------------------
302: END OE_LINE_ADJ_PCFWK;