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_LIMITS_PVT dependencies on QP_LIMIT_BALANCES_UTIL

Line 725: QP_Limit_Balances_Util.Convert_Miss_To_Null (l_old_LIMIT_BALANCES_rec);

721:
722: -- Set missing old record elements to NULL.
723:
724: l_old_LIMIT_BALANCES_rec :=
725: QP_Limit_Balances_Util.Convert_Miss_To_Null (l_old_LIMIT_BALANCES_rec);
726:
727: ELSIF l_LIMIT_BALANCES_rec.operation = QP_GLOBALS.G_OPR_UPDATE
728: OR l_LIMIT_BALANCES_rec.operation = QP_GLOBALS.G_OPR_DELETE
729: THEN

Line 738: l_old_LIMIT_BALANCES_rec := QP_Limit_Balances_Util.Query_Row

734:
735: IF l_old_LIMIT_BALANCES_rec.limit_balance_id = FND_API.G_MISS_NUM
736: THEN
737:
738: l_old_LIMIT_BALANCES_rec := QP_Limit_Balances_Util.Query_Row
739: ( p_limit_balance_id => l_LIMIT_BALANCES_rec.limit_balance_id
740: );
741:
742: ELSE

Line 747: QP_Limit_Balances_Util.Convert_Miss_To_Null (l_old_LIMIT_BALANCES_rec);

743:
744: -- Set missing old record elements to NULL.
745:
746: l_old_LIMIT_BALANCES_rec :=
747: QP_Limit_Balances_Util.Convert_Miss_To_Null (l_old_LIMIT_BALANCES_rec);
748:
749: END IF;
750:
751: -- Complete new record from old

Line 753: --dbms_output.put_line('Processing Limit Balances - Calling QP_Limit_Balances_Util.Complete_Record ' || l_return_status);

749: END IF;
750:
751: -- Complete new record from old
752:
753: --dbms_output.put_line('Processing Limit Balances - Calling QP_Limit_Balances_Util.Complete_Record ' || l_return_status);
754: oe_debug_pub.add('Processing Limit Balances - Calling QP_Limit_Balances_Util.Complete_Record ' || l_return_status);
755: l_LIMIT_BALANCES_rec := QP_Limit_Balances_Util.Complete_Record
756: ( p_LIMIT_BALANCES_rec => l_LIMIT_BALANCES_rec
757: , p_old_LIMIT_BALANCES_rec => l_old_LIMIT_BALANCES_rec

Line 754: oe_debug_pub.add('Processing Limit Balances - Calling QP_Limit_Balances_Util.Complete_Record ' || l_return_status);

750:
751: -- Complete new record from old
752:
753: --dbms_output.put_line('Processing Limit Balances - Calling QP_Limit_Balances_Util.Complete_Record ' || l_return_status);
754: oe_debug_pub.add('Processing Limit Balances - Calling QP_Limit_Balances_Util.Complete_Record ' || l_return_status);
755: l_LIMIT_BALANCES_rec := QP_Limit_Balances_Util.Complete_Record
756: ( p_LIMIT_BALANCES_rec => l_LIMIT_BALANCES_rec
757: , p_old_LIMIT_BALANCES_rec => l_old_LIMIT_BALANCES_rec
758: );

Line 755: l_LIMIT_BALANCES_rec := QP_Limit_Balances_Util.Complete_Record

751: -- Complete new record from old
752:
753: --dbms_output.put_line('Processing Limit Balances - Calling QP_Limit_Balances_Util.Complete_Record ' || l_return_status);
754: oe_debug_pub.add('Processing Limit Balances - Calling QP_Limit_Balances_Util.Complete_Record ' || l_return_status);
755: l_LIMIT_BALANCES_rec := QP_Limit_Balances_Util.Complete_Record
756: ( p_LIMIT_BALANCES_rec => l_LIMIT_BALANCES_rec
757: , p_old_LIMIT_BALANCES_rec => l_old_LIMIT_BALANCES_rec
758: );
759:

Line 796: --dbms_output.put_line('Processing Limit Balances - Calling QP_Limit_Balances_Util.Clear_Dependent_Attr ' || l_return_status);

792: -- Clear dependent attributes.
793:
794: IF l_control_rec.change_attributes THEN
795:
796: --dbms_output.put_line('Processing Limit Balances - Calling QP_Limit_Balances_Util.Clear_Dependent_Attr ' || l_return_status);
797: oe_debug_pub.add('Processing Limit Balances - Calling QP_Limit_Balances_Util.Clear_Dependent_Attr ' || l_return_status);
798:
799: l_p_LIMIT_BALANCES_rec := l_LIMIT_BALANCES_rec; --[prarasto]
800:

Line 797: oe_debug_pub.add('Processing Limit Balances - Calling QP_Limit_Balances_Util.Clear_Dependent_Attr ' || l_return_status);

793:
794: IF l_control_rec.change_attributes THEN
795:
796: --dbms_output.put_line('Processing Limit Balances - Calling QP_Limit_Balances_Util.Clear_Dependent_Attr ' || l_return_status);
797: oe_debug_pub.add('Processing Limit Balances - Calling QP_Limit_Balances_Util.Clear_Dependent_Attr ' || l_return_status);
798:
799: l_p_LIMIT_BALANCES_rec := l_LIMIT_BALANCES_rec; --[prarasto]
800:
801: QP_Limit_Balances_Util.Clear_Dependent_Attr

Line 801: QP_Limit_Balances_Util.Clear_Dependent_Attr

797: oe_debug_pub.add('Processing Limit Balances - Calling QP_Limit_Balances_Util.Clear_Dependent_Attr ' || l_return_status);
798:
799: l_p_LIMIT_BALANCES_rec := l_LIMIT_BALANCES_rec; --[prarasto]
800:
801: QP_Limit_Balances_Util.Clear_Dependent_Attr
802: ( p_LIMIT_BALANCES_rec => l_p_LIMIT_BALANCES_rec
803: , p_old_LIMIT_BALANCES_rec => l_old_LIMIT_BALANCES_rec
804: , x_LIMIT_BALANCES_rec => l_LIMIT_BALANCES_rec
805: );

Line 835: --dbms_output.put_line('Processing Limit Balances - Calling QP_Limit_Balances_Util.Apply_Attribute_Changes ' || l_return_status);

831: IF l_control_rec.default_attributes
832: OR l_control_rec.change_attributes
833: THEN
834:
835: --dbms_output.put_line('Processing Limit Balances - Calling QP_Limit_Balances_Util.Apply_Attribute_Changes ' || l_return_status);
836: oe_debug_pub.add('Processing Limit Balances - Calling QP_Limit_Balances_Util.Apply_Attribute_Changes ' || l_return_status);
837:
838: l_p_LIMIT_BALANCES_rec := l_LIMIT_BALANCES_rec; --[prarasto]
839:

Line 836: oe_debug_pub.add('Processing Limit Balances - Calling QP_Limit_Balances_Util.Apply_Attribute_Changes ' || l_return_status);

832: OR l_control_rec.change_attributes
833: THEN
834:
835: --dbms_output.put_line('Processing Limit Balances - Calling QP_Limit_Balances_Util.Apply_Attribute_Changes ' || l_return_status);
836: oe_debug_pub.add('Processing Limit Balances - Calling QP_Limit_Balances_Util.Apply_Attribute_Changes ' || l_return_status);
837:
838: l_p_LIMIT_BALANCES_rec := l_LIMIT_BALANCES_rec; --[prarasto]
839:
840: QP_Limit_Balances_Util.Apply_Attribute_Changes

Line 840: QP_Limit_Balances_Util.Apply_Attribute_Changes

836: oe_debug_pub.add('Processing Limit Balances - Calling QP_Limit_Balances_Util.Apply_Attribute_Changes ' || l_return_status);
837:
838: l_p_LIMIT_BALANCES_rec := l_LIMIT_BALANCES_rec; --[prarasto]
839:
840: QP_Limit_Balances_Util.Apply_Attribute_Changes
841: ( p_LIMIT_BALANCES_rec => l_p_LIMIT_BALANCES_rec
842: , p_old_LIMIT_BALANCES_rec => l_old_LIMIT_BALANCES_rec
843: , x_LIMIT_BALANCES_rec => l_LIMIT_BALANCES_rec
844: );

Line 887: QP_Limit_Balances_Util.Delete_Row

883: IF l_control_rec.write_to_db THEN
884:
885: IF l_LIMIT_BALANCES_rec.operation = QP_GLOBALS.G_OPR_DELETE THEN
886:
887: QP_Limit_Balances_Util.Delete_Row
888: ( p_limit_balance_id => l_LIMIT_BALANCES_rec.limit_balance_id
889: );
890:
891: ELSE

Line 901: QP_Limit_Balances_Util.Update_Row (l_LIMIT_BALANCES_rec);

897: l_LIMIT_BALANCES_rec.last_update_login := FND_GLOBAL.LOGIN_ID;
898:
899: IF l_LIMIT_BALANCES_rec.operation = QP_GLOBALS.G_OPR_UPDATE THEN
900:
901: QP_Limit_Balances_Util.Update_Row (l_LIMIT_BALANCES_rec);
902:
903: ELSIF l_LIMIT_BALANCES_rec.operation = QP_GLOBALS.G_OPR_CREATE THEN
904:
905: l_LIMIT_BALANCES_rec.creation_date := SYSDATE;

Line 908: --dbms_output.put_line('Processing Limit Balances - Calling QP_Limit_Balances_Util.Insert_Row ' || l_return_status);

904:
905: l_LIMIT_BALANCES_rec.creation_date := SYSDATE;
906: l_LIMIT_BALANCES_rec.created_by := FND_GLOBAL.USER_ID;
907:
908: --dbms_output.put_line('Processing Limit Balances - Calling QP_Limit_Balances_Util.Insert_Row ' || l_return_status);
909: oe_debug_pub.add('Processing Limit Balances - Calling QP_Limit_Balances_Util.Insert_Row ' || l_return_status);
910: QP_Limit_Balances_Util.Insert_Row (l_LIMIT_BALANCES_rec);
911:
912: END IF;

Line 909: oe_debug_pub.add('Processing Limit Balances - Calling QP_Limit_Balances_Util.Insert_Row ' || l_return_status);

905: l_LIMIT_BALANCES_rec.creation_date := SYSDATE;
906: l_LIMIT_BALANCES_rec.created_by := FND_GLOBAL.USER_ID;
907:
908: --dbms_output.put_line('Processing Limit Balances - Calling QP_Limit_Balances_Util.Insert_Row ' || l_return_status);
909: oe_debug_pub.add('Processing Limit Balances - Calling QP_Limit_Balances_Util.Insert_Row ' || l_return_status);
910: QP_Limit_Balances_Util.Insert_Row (l_LIMIT_BALANCES_rec);
911:
912: END IF;
913:

Line 910: QP_Limit_Balances_Util.Insert_Row (l_LIMIT_BALANCES_rec);

906: l_LIMIT_BALANCES_rec.created_by := FND_GLOBAL.USER_ID;
907:
908: --dbms_output.put_line('Processing Limit Balances - Calling QP_Limit_Balances_Util.Insert_Row ' || l_return_status);
909: oe_debug_pub.add('Processing Limit Balances - Calling QP_Limit_Balances_Util.Insert_Row ' || l_return_status);
910: QP_Limit_Balances_Util.Insert_Row (l_LIMIT_BALANCES_rec);
911:
912: END IF;
913:
914: END IF;

Line 1460: QP_Limit_Balances_Util.Lock_Row

1456: FOR I IN 1..p_LIMIT_BALANCES_tbl.COUNT LOOP
1457:
1458: IF p_LIMIT_BALANCES_tbl(I).operation = QP_GLOBALS.G_OPR_LOCK THEN
1459:
1460: QP_Limit_Balances_Util.Lock_Row
1461: ( p_LIMIT_BALANCES_rec => p_LIMIT_BALANCES_tbl(I)
1462: , x_LIMIT_BALANCES_rec => l_LIMIT_BALANCES_rec
1463: , x_return_status => l_return_status
1464: );

Line 1615: l_LIMIT_BALANCES_tbl := QP_Limit_Balances_Util.Query_Rows

1611:
1612:
1613: -- Get LIMIT_BALANCES ( parent = LIMITS )
1614:
1615: l_LIMIT_BALANCES_tbl := QP_Limit_Balances_Util.Query_Rows
1616: ( p_limit_id => l_LIMITS_rec.limit_id
1617: );
1618:
1619: