eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OE_HEADER_ADJ_PCFWK dependencies on OE_PC_GLOBALS

Line 70: l_ConstrainedStatus := OE_PC_GLOBALS.NO;

66: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
67: --
68: BEGIN
69:
70: l_ConstrainedStatus := OE_PC_GLOBALS.NO;
71: l_rule_count := 0;
72: i := 0;
73: l_currGrpNumber := -1;
74: l_currGrpResult := FALSE;

Line 95: l_ConstrainedStatus := OE_PC_GLOBALS.YES;

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

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

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

Line 106: l_ConstrainedStatus := OE_PC_GLOBALS.YES;

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

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

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

Line 172: x_result := OE_PC_GLOBALS.YES;

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

Line 181: x_result := OE_PC_GLOBALS.ERROR;

177: END IF;
178: -------------------------------------------
179: EXCEPTION
180: WHEN OTHERS THEN
181: x_result := OE_PC_GLOBALS.ERROR;
182: END Validate_Constraint;
183: -------------------------------------------
184: -------------------------------------------
185: FUNCTION Is_Op_Constrained

Line 241: AND ( ( c.constrained_operation = OE_PC_GLOBALS.UPDATE_OP

237: oe_pc_assignments a
238: WHERE (a.responsibility_id = p_responsibility_id OR a.responsibility_id IS NULL)
239: AND a.constraint_id = c.constraint_id
240: AND c.entity_id = G_ENTITY_ID
241: AND ( ( c.constrained_operation = OE_PC_GLOBALS.UPDATE_OP
242: and p_column_name is null )
243: OR ( c.constrained_operation = OE_PC_GLOBALS.UPDATE_OP
244: AND c.check_on_insert_flag = 'Y'
245: AND nvl(c.column_name, '#NULL') = NVL(p_column_name,'#NULL') )

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

239: AND a.constraint_id = c.constraint_id
240: AND c.entity_id = G_ENTITY_ID
241: AND ( ( c.constrained_operation = OE_PC_GLOBALS.UPDATE_OP
242: and p_column_name is null )
243: OR ( c.constrained_operation = OE_PC_GLOBALS.UPDATE_OP
244: AND c.check_on_insert_flag = 'Y'
245: AND nvl(c.column_name, '#NULL') = NVL(p_column_name,'#NULL') )
246: )
247: -- if caller is defaulting then DO NOT CHECK those constraints

Line 264: l_validation_result := OE_PC_GLOBALS.NO;

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

Line 265: IF p_operation = OE_PC_GLOBALS.CREATE_OP THEN

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

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

270: ,x_condition_count => l_condition_count
271: ,x_valid_condition_group => l_valid_condition_group
272: ,x_result => l_validation_result
273: );
274: IF (l_condition_count = 0 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:

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

289: ,x_condition_count => l_condition_count
290: ,x_valid_condition_group => l_valid_condition_group
291: ,x_result => l_validation_result
292: );
293: IF (l_condition_count = 0 OR l_validation_result = OE_PC_GLOBALS.YES) then
294: x_constraint_id := c_rec.constraint_id;
295: x_on_operation_action := c_rec.on_operation_action;
296: x_constraining_conditions_grp := l_valid_condition_group;
297: 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: END OE_HEADER_ADJ_PCFWK;