APPS.OE_LINE_SCREDIT_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 262: l_validation_result := OE_PC_GLOBALS.NO;

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

Line 264: IF p_operation = OE_PC_GLOBALS.CREATE_OP THEN

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

Line 274: OR l_validation_result = OE_PC_GLOBALS.YES) then

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

Line 292: OR l_validation_result = OE_PC_GLOBALS.YES) then

288: ,x_valid_condition_group => l_valid_condition_group
289: ,x_result => l_validation_result
290: );
291: IF (l_condition_count = 0
292: OR l_validation_result = OE_PC_GLOBALS.YES) then
293: x_constraint_id := c_rec.constraint_id;
294: x_on_operation_action := c_rec.on_operation_action;
295: x_constraining_conditions_grp := l_valid_condition_group;
296: EXIT;

Line 306: RETURN OE_PC_GLOBALS.ERROR;

302: return l_validation_result;
303:
304: EXCEPTION
305: WHEN OTHERS THEN
306: RETURN OE_PC_GLOBALS.ERROR;
307: END Is_Op_Constrained;
308:
309: -------------------------------------------
310: END OE_LINE_SCREDIT_PCFWK;