APPS.QA_TXN_GRP dependencies on QLTCOMPB

Line 304: condition when null is returned by qltcompb.compare.Before

300: END IF;
301:
302: /*
303: Added NVL condition for the IF condition below to handle the
304: condition when null is returned by qltcompb.compare.Before
305: the fix if qltcompb.compare returns null then the following
306: condition is not satisfied and True is returned which is not
307: correct.Take for Eg., elements(plan_record.char_id).value is
308: Null and plan_record.Low_Value has the value 'Test' and

Line 305: the fix if qltcompb.compare returns null then the following

301:
302: /*
303: Added NVL condition for the IF condition below to handle the
304: condition when null is returned by qltcompb.compare.Before
305: the fix if qltcompb.compare returns null then the following
306: condition is not satisfied and True is returned which is not
307: correct.Take for Eg., elements(plan_record.char_id).value is
308: Null and plan_record.Low_Value has the value 'Test' and
309: plan_record.operator is 1(equals) then qltcompb.compare will

Line 309: plan_record.operator is 1(equals) then qltcompb.compare will

305: the fix if qltcompb.compare returns null then the following
306: condition is not satisfied and True is returned which is not
307: correct.Take for Eg., elements(plan_record.char_id).value is
308: Null and plan_record.Low_Value has the value 'Test' and
309: plan_record.operator is 1(equals) then qltcompb.compare will
310: return Null and because of that the following call fails. If
311: Null is retruned then it has to be considered as False.
312: Bug 3810082. suramasw.
313: */

Line 315: IF NOT (NVL(qltcompb.compare(

311: Null is retruned then it has to be considered as False.
312: Bug 3810082. suramasw.
313: */
314:
315: IF NOT (NVL(qltcompb.compare(
316: elements(plan_record.char_id).value,
317: plan_record.operator,
318: plan_record.Low_Value,
319: plan_record.High_Value,