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_COMMITMENT_PVT dependencies on OE_GLOBALS

Line 83: l_commitment_bal := nvl(oe_globals.g_commitment_balance, 0);

79: IF l_debug_level > 0 THEN
80: oe_debug_pub.add( 'COMMITMENT AFTER CALLING FND_PROFILE.VALUE' ) ;
81: END IF;
82:
83: l_commitment_bal := nvl(oe_globals.g_commitment_balance, 0);
84:
85: l_total_balance := l_commitment_bal - p_unit_selling_price;
86: IF l_debug_level > 0 THEN
87: oe_debug_pub.add( 'TOTAL COMMITMENT BALANCE:'|| TO_CHAR ( L_TOTAL_BALANCE ) , 1 ) ;

Line 442: -- l_commitment_bal := nvl(oe_globals.g_commitment_balance, 0);

438: ,l_so_source_code
439: ,l_oe_installed_flag );
440: END IF;
441:
442: -- l_commitment_bal := nvl(oe_globals.g_commitment_balance, 0);
443:
444: IF l_debug_level > 0 THEN
445: oe_debug_pub.add( 'COMMITMENT BALANCE IS: '||L_COMMITMENT_BAL ) ;
446: END IF;

Line 507: IF l_commitment_applied_amount > oe_globals.g_original_commitment_applied THEN

503: l_overdrawn_amount := l_total - l_commitment_applied_amount;
504: END IF;
505:
506: IF l_split_by is not null THEN
507: IF l_commitment_applied_amount > oe_globals.g_original_commitment_applied THEN
508: l_commitment_applied_amount := oe_globals.g_original_commitment_applied;
509: l_overdrawn_amount := 0;
510: END IF;
511: END IF;

Line 508: l_commitment_applied_amount := oe_globals.g_original_commitment_applied;

504: END IF;
505:
506: IF l_split_by is not null THEN
507: IF l_commitment_applied_amount > oe_globals.g_original_commitment_applied THEN
508: l_commitment_applied_amount := oe_globals.g_original_commitment_applied;
509: l_overdrawn_amount := 0;
510: END IF;
511: END IF;
512:

Line 528: IF NOT OE_GLOBALS.Equal(l_new_commitment_id, l_payment_types_tbl(1).payment_trx_id) THEN

524: -- Fix Bug # 2511389: Delete payment record if applied amount has been set to <= 0.
525: IF nvl(l_commitment_applied_amount, 0) <= 0 THEN
526: oe_payments_Util.Delete_Row(p_line_id => l_line_id, p_header_id => l_header_id);
527: ELSE
528: IF NOT OE_GLOBALS.Equal(l_new_commitment_id, l_payment_types_tbl(1).payment_trx_id) THEN
529:
530: IF l_debug_level > 0 THEN
531: oe_debug_pub.add( 'UPDATING BOTH APPLIED AMOUNT AND COMMITMENT' ) ;
532: END IF;

Line 649: OE_GLOBALS.G_UPDATE_COMMITMENT_APPLIED

645: oe_debug_pub.add('p_request_rec.request_type : '||p_request_rec.request_type);
646: END IF;
647: l_result := Oe_Delayed_Requests_Pvt.Check_For_Request(p_request_rec.entity_code,
648: p_request_rec.entity_id,
649: OE_GLOBALS.G_UPDATE_COMMITMENT_APPLIED
650: );
651: IF l_result THEN
652: oe_debug_pub.add('setting l_show_balance to false');
653: l_show_balance := FALSE;

Line 722: (p_entity_code => OE_GLOBALS.G_ENTITY_ALL,

718: IF l_debug_level > 0 THEN
719: oe_debug_pub.add( 'LOGGING DELAYED REQUEST FOR VERIFY PAYMENT IN COMMITMENTS' , 2 ) ;
720: END IF;
721: OE_delayed_requests_Pvt.log_request
722: (p_entity_code => OE_GLOBALS.G_ENTITY_ALL,
723: p_entity_id => l_header_id,
724: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_LINE,
725: p_requesting_entity_id => l_line_id,
726: p_request_type => OE_GLOBALS.G_VERIFY_PAYMENT,

Line 724: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_LINE,

720: END IF;
721: OE_delayed_requests_Pvt.log_request
722: (p_entity_code => OE_GLOBALS.G_ENTITY_ALL,
723: p_entity_id => l_header_id,
724: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_LINE,
725: p_requesting_entity_id => l_line_id,
726: p_request_type => OE_GLOBALS.G_VERIFY_PAYMENT,
727: x_return_status => l_return_status);
728:

Line 726: p_request_type => OE_GLOBALS.G_VERIFY_PAYMENT,

722: (p_entity_code => OE_GLOBALS.G_ENTITY_ALL,
723: p_entity_id => l_header_id,
724: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_LINE,
725: p_requesting_entity_id => l_line_id,
726: p_request_type => OE_GLOBALS.G_VERIFY_PAYMENT,
727: x_return_status => l_return_status);
728:
729: END IF;
730:

Line 864: oe_globals.g_commitment_balance

860: END;
861:
862: IF l_split_by IS NOT NULL THEN
863:
864: oe_globals.g_commitment_balance
865: := oe_globals.g_original_commitment_applied - l_commitment_applied_amount;
866: END IF;
867:
868: IF l_debug_level > 0 THEN

Line 865: := oe_globals.g_original_commitment_applied - l_commitment_applied_amount;

861:
862: IF l_split_by IS NOT NULL THEN
863:
864: oe_globals.g_commitment_balance
865: := oe_globals.g_original_commitment_applied - l_commitment_applied_amount;
866: END IF;
867:
868: IF l_debug_level > 0 THEN
869: oe_debug_pub.add('commitment balance is: '||oe_globals.g_commitment_balance,3);

Line 869: oe_debug_pub.add('commitment balance is: '||oe_globals.g_commitment_balance,3);

865: := oe_globals.g_original_commitment_applied - l_commitment_applied_amount;
866: END IF;
867:
868: IF l_debug_level > 0 THEN
869: oe_debug_pub.add('commitment balance is: '||oe_globals.g_commitment_balance,3);
870: oe_debug_pub.add('commitment applied amount is: '||l_commitment_applied_amount,3);
871: oe_debug_pub.add('original commitment applied is: '||oe_globals.g_original_commitment_applied,3);
872: END IF;
873:

Line 871: oe_debug_pub.add('original commitment applied is: '||oe_globals.g_original_commitment_applied,3);

867:
868: IF l_debug_level > 0 THEN
869: oe_debug_pub.add('commitment balance is: '||oe_globals.g_commitment_balance,3);
870: oe_debug_pub.add('commitment applied amount is: '||l_commitment_applied_amount,3);
871: oe_debug_pub.add('original commitment applied is: '||oe_globals.g_original_commitment_applied,3);
872: END IF;
873:
874: OPEN l_split_lines_cur;
875: LOOP

Line 901: IF nvl(oe_globals.g_commitment_balance,0) <= 0 THEN

897: := get_line_total(p_line_rec => l_children_line_rec);
898:
899: oe_debug_pub.add('Linda0721 -- child commit applied is: '||l_children_commitment,1);
900:
901: IF nvl(oe_globals.g_commitment_balance,0) <= 0 THEN
902: update oe_payments
903: set commitment_applied_amount = 0
904: WHERE line_id = l_children_line_id
905: AND header_id = l_header_id

Line 908: ELSIF nvl(oe_globals.g_commitment_balance, 0) >= l_children_commitment THEN

904: WHERE line_id = l_children_line_id
905: AND header_id = l_header_id
906: AND nvl(payment_type_code, 'COMMITMENT') = 'COMMITMENT';
907:
908: ELSIF nvl(oe_globals.g_commitment_balance, 0) >= l_children_commitment THEN
909: update oe_payments
910: set commitment_applied_amount = l_children_commitment
911: where line_id = l_children_line_id
912: and header_id = l_header_id

Line 915: oe_globals.g_commitment_balance

911: where line_id = l_children_line_id
912: and header_id = l_header_id
913: and nvl(payment_type_code, 'COMMITMENT') = 'COMMITMENT';
914:
915: oe_globals.g_commitment_balance
916: := nvl(oe_globals.g_commitment_balance, 0) - l_children_commitment;
917: ELSIF nvl(oe_globals.g_commitment_balance, 0) < l_children_commitment THEN
918: update oe_payments
919: set commitment_applied_amount = nvl(oe_globals.g_commitment_balance, 0)

Line 916: := nvl(oe_globals.g_commitment_balance, 0) - l_children_commitment;

912: and header_id = l_header_id
913: and nvl(payment_type_code, 'COMMITMENT') = 'COMMITMENT';
914:
915: oe_globals.g_commitment_balance
916: := nvl(oe_globals.g_commitment_balance, 0) - l_children_commitment;
917: ELSIF nvl(oe_globals.g_commitment_balance, 0) < l_children_commitment THEN
918: update oe_payments
919: set commitment_applied_amount = nvl(oe_globals.g_commitment_balance, 0)
920: where line_id = l_children_line_id

Line 917: ELSIF nvl(oe_globals.g_commitment_balance, 0) < l_children_commitment THEN

913: and nvl(payment_type_code, 'COMMITMENT') = 'COMMITMENT';
914:
915: oe_globals.g_commitment_balance
916: := nvl(oe_globals.g_commitment_balance, 0) - l_children_commitment;
917: ELSIF nvl(oe_globals.g_commitment_balance, 0) < l_children_commitment THEN
918: update oe_payments
919: set commitment_applied_amount = nvl(oe_globals.g_commitment_balance, 0)
920: where line_id = l_children_line_id
921: and header_id =l_header_id

Line 919: set commitment_applied_amount = nvl(oe_globals.g_commitment_balance, 0)

915: oe_globals.g_commitment_balance
916: := nvl(oe_globals.g_commitment_balance, 0) - l_children_commitment;
917: ELSIF nvl(oe_globals.g_commitment_balance, 0) < l_children_commitment THEN
918: update oe_payments
919: set commitment_applied_amount = nvl(oe_globals.g_commitment_balance, 0)
920: where line_id = l_children_line_id
921: and header_id =l_header_id
922: and nvl(payment_type_code, 'COMMITMENT') = 'COMMITMENT';
923:

Line 924: oe_globals.g_commitment_balance := 0;

920: where line_id = l_children_line_id
921: and header_id =l_header_id
922: and nvl(payment_type_code, 'COMMITMENT') = 'COMMITMENT';
923:
924: oe_globals.g_commitment_balance := 0;
925: END IF;
926:
927: END LOOP;
928: CLOSE l_split_lines_cur;