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.QP_QUALIFIER_RULES_PVT dependencies on QP_QUALIFIERS

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 897: from qp_qualifiers

893: THEN
894: qual_count := 1;
895: BEGIN
896: select list_header_id into l_list_header_id
897: from qp_qualifiers
898: where qualifier_id = l_QUALIFIERS_rec.qualifier_id;
899:
900: BEGIN
901: select count(*) into qual_count

Line 902: from qp_qualifiers

898: where qualifier_id = l_QUALIFIERS_rec.qualifier_id;
899:
900: BEGIN
901: select count(*) into qual_count
902: from qp_qualifiers
903: where list_header_id = l_list_header_id
904: and qualifier_context = 'ORDER'
905: and qualifier_attribute = 'QUALIFIER_ATTRIBUTE5'
906: and qualifier_id <> l_QUALIFIERS_rec.qualifier_id;

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:

Line 1527: -- call Process qualifiers for inserting new qualifier rule and qualifiers in QP_QUALIFIERS

1523: l_QUALIFIERS_tbl(i).qualifier_rule_id :=FND_API.G_MISS_NUM;
1524:
1525: END LOOP;
1526:
1527: -- call Process qualifiers for inserting new qualifier rule and qualifiers in QP_QUALIFIERS
1528: l_p_QUALIFIER_RULES_rec := l_QUALIFIER_RULES_rec; -- added for nocopy hint
1529: l_p_QUALIFIERS_tbl := l_QUALIFIERS_tbl;
1530: QP_Qualifier_Rules_PVT.Process_Qualifier_Rules
1531: ( p_api_version_number => 1.0

Line 1684: delete from qp_qualifiers where

1680: oe_debug_pub.add('in if update : '||p_operation);
1681:
1682: if p_old_list_header_id <> p_list_header_id then
1683: oe_debug_pub.add('in else id!=id'||p_operation);
1684: delete from qp_qualifiers where
1685: list_header_id = p_old_list_header_id
1686: and qualifier_context = 'ORDER'
1687: and qualifier_attribute = 'QUALIFIER_ATTRIBUTE5'
1688: and qualifier_attr_value = p_blanket_id;

Line 1698: from qp_qualifiers where

1694: oe_debug_pub.add('in if id=id'||p_operation);
1695:
1696: BEGIN
1697: select count(list_header_id) into l_qual_count
1698: from qp_qualifiers where
1699: list_header_id = p_list_header_id
1700: and qualifier_context = 'ORDER'
1701: and qualifier_attribute = 'QUALIFIER_ATTRIBUTE5'
1702: and qualifier_attr_value = p_blanket_id;

Line 1749: delete from qp_qualifiers where

1745: oe_debug_pub.add('in if delete : '||p_operation);
1746:
1747: if p_old_list_header_id <> p_list_header_id then
1748: oe_debug_pub.add('in else id != id '||p_operation);
1749: delete from qp_qualifiers where
1750: list_header_id = p_old_list_header_id
1751: and qualifier_context = 'ORDER'
1752: and qualifier_attribute = 'QUALIFIER_ATTRIBUTE5'
1753: and qualifier_attr_value = p_blanket_id;

Line 1761: delete from qp_qualifiers where

1757: end if;
1758:
1759: BEGIN
1760: oe_debug_pub.add('in if id=id'||p_operation);
1761: delete from qp_qualifiers where
1762: list_header_id = p_old_list_header_id
1763: and qualifier_context = 'ORDER'
1764: and qualifier_attribute = 'QUALIFIER_ATTRIBUTE5'
1765: and qualifier_attr_value = p_blanket_id;