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 721: (p_entity_code => OE_GLOBALS.G_ENTITY_ALL,

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

Line 723: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_LINE,

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

Line 725: p_request_type => OE_GLOBALS.G_VERIFY_PAYMENT,

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

Line 863: oe_globals.g_commitment_balance

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

Line 864: := oe_globals.g_original_commitment_applied - l_commitment_applied_amount;

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

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

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

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

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

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

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

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

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

Line 914: oe_globals.g_commitment_balance

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

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

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

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

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

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

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

Line 923: oe_globals.g_commitment_balance := 0;

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