APPS.QP_QUALIFIER_RULES_PVT dependencies on QP_QUALIFIERS_UTIL

Line 413: QP_Qualifiers_Util.Convert_Miss_To_Null (l_old_QUALIFIERS_rec);

409:
410:
411:
412: l_old_QUALIFIERS_rec :=
413: QP_Qualifiers_Util.Convert_Miss_To_Null (l_old_QUALIFIERS_rec);
414:
415: ELSIF l_QUALIFIERS_rec.operation = QP_GLOBALS.G_OPR_UPDATE
416: OR l_QUALIFIERS_rec.operation = QP_GLOBALS.G_OPR_DELETE
417: THEN

Line 426: l_old_QUALIFIERS_rec := QP_Qualifiers_Util.Query_Row

422:
423: IF l_old_QUALIFIERS_rec.qualifier_id = FND_API.G_MISS_NUM
424: THEN
425:
426: l_old_QUALIFIERS_rec := QP_Qualifiers_Util.Query_Row
427: ( p_qualifier_id => l_QUALIFIERS_rec.qualifier_id
428: );
429:
430: ELSE

Line 435: QP_Qualifiers_Util.Convert_Miss_To_Null (l_old_QUALIFIERS_rec);

431:
432: -- Set missing old record elements to NULL.
433:
434: l_old_QUALIFIERS_rec :=
435: QP_Qualifiers_Util.Convert_Miss_To_Null (l_old_QUALIFIERS_rec);
436:
437: END IF;
438:
439: -- Complete new record from old

Line 443: l_QUALIFIERS_rec := QP_Qualifiers_Util.Complete_Record

439: -- Complete new record from old
440: --dbms_output.put_line('completing record');
441: oe_debug_pub.add('completing new reocrd');
442:
443: l_QUALIFIERS_rec := QP_Qualifiers_Util.Complete_Record
444: ( p_QUALIFIERS_rec => l_QUALIFIERS_rec
445: , p_old_QUALIFIERS_rec => l_old_QUALIFIERS_rec
446: );
447:

Line 486: QP_Qualifiers_Util.Clear_Dependent_Attr

482:
483: oe_debug_pub.add('clearing dependent records');
484:
485: l_p_QUALIFIERS_rec := l_QUALIFIERS_rec; -- added for nocopy hint
486: QP_Qualifiers_Util.Clear_Dependent_Attr
487: ( p_QUALIFIERS_rec => l_p_QUALIFIERS_rec
488: , p_old_QUALIFIERS_rec => l_old_QUALIFIERS_rec
489: , x_QUALIFIERS_rec => l_QUALIFIERS_rec
490: );

Line 523: QP_Qualifiers_Util.Apply_Attribute_Changes

519: oe_debug_pub.add('applying change attribute ');
520:
521:
522: l_p_QUALIFIERS_rec := l_QUALIFIERS_rec; -- added for nocopy hint
523: QP_Qualifiers_Util.Apply_Attribute_Changes
524: ( p_QUALIFIERS_rec => l_p_QUALIFIERS_rec
525: , p_old_QUALIFIERS_rec => l_old_QUALIFIERS_rec
526: , x_QUALIFIERS_rec => l_QUALIFIERS_rec
527: );

Line 571: QP_QUALIFIERS_UTIL.PRE_WRITE_PROCESS

567: --added by spgopal for list_qual_ind delayed req
568:
569: IF l_control_rec.write_to_db THEN
570: l_p_QUALIFIERS_rec := l_QUALIFIERS_rec; -- added for nocopy hint
571: QP_QUALIFIERS_UTIL.PRE_WRITE_PROCESS
572: ( p_QUALIFIERS_rec => l_p_QUALIFIERS_rec
573: , p_old_QUALIFIERS_rec => l_old_QUALIFIERS_rec
574: , x_QUALIFIERS_rec => l_QUALIFIERS_rec);
575:

Line 584: QP_Qualifiers_Util.Delete_Row

580: IF l_control_rec.write_to_db THEN
581:
582: IF l_QUALIFIERS_rec.operation = QP_GLOBALS.G_OPR_DELETE THEN
583:
584: QP_Qualifiers_Util.Delete_Row
585: ( p_qualifier_id => l_QUALIFIERS_rec.qualifier_id
586: );
587:
588: ELSE

Line 598: QP_Qualifiers_Util.Update_Row (l_QUALIFIERS_rec);

594: l_QUALIFIERS_rec.last_update_login := FND_GLOBAL.LOGIN_ID;
595:
596: IF l_QUALIFIERS_rec.operation = QP_GLOBALS.G_OPR_UPDATE THEN
597:
598: QP_Qualifiers_Util.Update_Row (l_QUALIFIERS_rec);
599:
600: ELSIF l_QUALIFIERS_rec.operation = QP_GLOBALS.G_OPR_CREATE THEN
601:
602: l_QUALIFIERS_rec.creation_date := SYSDATE;

Line 609: QP_Qualifiers_Util.Insert_Row (l_QUALIFIERS_rec);

605:
606: --dbms_output.put_line('claiing insert');
607: oe_debug_pub.add('calling insert for qualifiers');
608:
609: QP_Qualifiers_Util.Insert_Row (l_QUALIFIERS_rec);
610:
611: END IF;
612:
613: END IF;

Line 1205: QP_Qualifiers_Util.Lock_Row

1201: FOR I IN 1..p_QUALIFIERS_tbl.COUNT LOOP
1202:
1203: IF p_QUALIFIERS_tbl(I).operation = QP_GLOBALS.G_OPR_LOCK THEN
1204:
1205: QP_Qualifiers_Util.Lock_Row
1206: ( p_QUALIFIERS_rec => p_QUALIFIERS_tbl(I)
1207: , x_QUALIFIERS_rec => l_QUALIFIERS_rec
1208: , x_return_status => l_return_status
1209: );

Line 1351: l_QUALIFIERS_tbl := QP_Qualifiers_Util.Query_Rows

1347: );
1348:
1349: -- Get QUALIFIERS ( parent = QUALIFIER_RULES )
1350:
1351: l_QUALIFIERS_tbl := QP_Qualifiers_Util.Query_Rows
1352: ( p_qualifier_rule_id => l_QUALIFIER_RULES_rec.qualifier_rule_id
1353: );
1354:
1355: