DBA Data[Home] [Help]

APPS.GMS_AWARD_DIST_ENG dependencies on PA_CURRENCY

Line 475: -- Call to pa_currency.round_currency_amt function will use

471: x_curr_amount := 0 ;
472:
473:
474: -- Bug 1980810 : Added to set currency related global variables
475: -- Call to pa_currency.round_currency_amt function will use
476: -- global variables and thus improves performance
477:
478: pa_currency.set_currency_info;
479:

Line 478: pa_currency.set_currency_info;

474: -- Bug 1980810 : Added to set currency related global variables
475: -- Call to pa_currency.round_currency_amt function will use
476: -- global variables and thus improves performance
477:
478: pa_currency.set_currency_info;
479:
480:
481: l_tab_ndx := 0 ;
482: valid_fp_tab.delete;

Line 532: valid_fp_tab(l_tab_ndx).award_amount := pa_currency.round_currency_amt( ( recs.amount * x_dist_percent)/100);

528: valid_fp_tab(l_tab_ndx).quantity := ROUND( ( recs.quantity * x_dist_percent)/100, 3 ) ;
529:
530: -- Bug 1980810 PA Rounding function added
531:
532: valid_fp_tab(l_tab_ndx).award_amount := pa_currency.round_currency_amt( ( recs.amount * x_dist_percent)/100);
533: valid_fp_tab(l_tab_ndx).old_award_amount := pa_currency.round_currency_amt( ( recs.amount * x_dist_percent)/100); /*BUG 13697251 added new field */
534: valid_fp_tab(l_tab_ndx).burdened_cost := pa_currency.round_currency_amt( (recs.burdened_cost * x_dist_percent)/100);
535: valid_fp_tab(l_tab_ndx).denom_burdened_cost := pa_currency.round_currency_amt( (recs.denom_burdened_cost * x_dist_percent)/100 );
536: valid_fp_tab(l_tab_ndx).acct_burdened_cost := pa_currency.round_currency_amt( (recs.acct_burdened_cost * x_dist_percent)/100);

Line 533: valid_fp_tab(l_tab_ndx).old_award_amount := pa_currency.round_currency_amt( ( recs.amount * x_dist_percent)/100); /*BUG 13697251 added new field */

529:
530: -- Bug 1980810 PA Rounding function added
531:
532: valid_fp_tab(l_tab_ndx).award_amount := pa_currency.round_currency_amt( ( recs.amount * x_dist_percent)/100);
533: valid_fp_tab(l_tab_ndx).old_award_amount := pa_currency.round_currency_amt( ( recs.amount * x_dist_percent)/100); /*BUG 13697251 added new field */
534: valid_fp_tab(l_tab_ndx).burdened_cost := pa_currency.round_currency_amt( (recs.burdened_cost * x_dist_percent)/100);
535: valid_fp_tab(l_tab_ndx).denom_burdened_cost := pa_currency.round_currency_amt( (recs.denom_burdened_cost * x_dist_percent)/100 );
536: valid_fp_tab(l_tab_ndx).acct_burdened_cost := pa_currency.round_currency_amt( (recs.acct_burdened_cost * x_dist_percent)/100);
537: valid_fp_tab(l_tab_ndx).acct_raw_cost := pa_currency.round_currency_amt( (recs.acct_raw_cost * x_dist_percent)/100);

Line 534: valid_fp_tab(l_tab_ndx).burdened_cost := pa_currency.round_currency_amt( (recs.burdened_cost * x_dist_percent)/100);

530: -- Bug 1980810 PA Rounding function added
531:
532: valid_fp_tab(l_tab_ndx).award_amount := pa_currency.round_currency_amt( ( recs.amount * x_dist_percent)/100);
533: valid_fp_tab(l_tab_ndx).old_award_amount := pa_currency.round_currency_amt( ( recs.amount * x_dist_percent)/100); /*BUG 13697251 added new field */
534: valid_fp_tab(l_tab_ndx).burdened_cost := pa_currency.round_currency_amt( (recs.burdened_cost * x_dist_percent)/100);
535: valid_fp_tab(l_tab_ndx).denom_burdened_cost := pa_currency.round_currency_amt( (recs.denom_burdened_cost * x_dist_percent)/100 );
536: valid_fp_tab(l_tab_ndx).acct_burdened_cost := pa_currency.round_currency_amt( (recs.acct_burdened_cost * x_dist_percent)/100);
537: valid_fp_tab(l_tab_ndx).acct_raw_cost := pa_currency.round_currency_amt( (recs.acct_raw_cost * x_dist_percent)/100);
538: valid_fp_tab(l_tab_ndx).denom_raw_cost := pa_currency.round_currency_amt( (recs.denom_raw_cost * x_dist_percent)/100);

Line 535: valid_fp_tab(l_tab_ndx).denom_burdened_cost := pa_currency.round_currency_amt( (recs.denom_burdened_cost * x_dist_percent)/100 );

531:
532: valid_fp_tab(l_tab_ndx).award_amount := pa_currency.round_currency_amt( ( recs.amount * x_dist_percent)/100);
533: valid_fp_tab(l_tab_ndx).old_award_amount := pa_currency.round_currency_amt( ( recs.amount * x_dist_percent)/100); /*BUG 13697251 added new field */
534: valid_fp_tab(l_tab_ndx).burdened_cost := pa_currency.round_currency_amt( (recs.burdened_cost * x_dist_percent)/100);
535: valid_fp_tab(l_tab_ndx).denom_burdened_cost := pa_currency.round_currency_amt( (recs.denom_burdened_cost * x_dist_percent)/100 );
536: valid_fp_tab(l_tab_ndx).acct_burdened_cost := pa_currency.round_currency_amt( (recs.acct_burdened_cost * x_dist_percent)/100);
537: valid_fp_tab(l_tab_ndx).acct_raw_cost := pa_currency.round_currency_amt( (recs.acct_raw_cost * x_dist_percent)/100);
538: valid_fp_tab(l_tab_ndx).denom_raw_cost := pa_currency.round_currency_amt( (recs.denom_raw_cost * x_dist_percent)/100);
539: valid_fp_tab(l_tab_ndx).receipt_currency_amount := pa_currency.round_currency_amt( (recs.receipt_currency_amount * x_dist_percent)/100) ;

Line 536: valid_fp_tab(l_tab_ndx).acct_burdened_cost := pa_currency.round_currency_amt( (recs.acct_burdened_cost * x_dist_percent)/100);

532: valid_fp_tab(l_tab_ndx).award_amount := pa_currency.round_currency_amt( ( recs.amount * x_dist_percent)/100);
533: valid_fp_tab(l_tab_ndx).old_award_amount := pa_currency.round_currency_amt( ( recs.amount * x_dist_percent)/100); /*BUG 13697251 added new field */
534: valid_fp_tab(l_tab_ndx).burdened_cost := pa_currency.round_currency_amt( (recs.burdened_cost * x_dist_percent)/100);
535: valid_fp_tab(l_tab_ndx).denom_burdened_cost := pa_currency.round_currency_amt( (recs.denom_burdened_cost * x_dist_percent)/100 );
536: valid_fp_tab(l_tab_ndx).acct_burdened_cost := pa_currency.round_currency_amt( (recs.acct_burdened_cost * x_dist_percent)/100);
537: valid_fp_tab(l_tab_ndx).acct_raw_cost := pa_currency.round_currency_amt( (recs.acct_raw_cost * x_dist_percent)/100);
538: valid_fp_tab(l_tab_ndx).denom_raw_cost := pa_currency.round_currency_amt( (recs.denom_raw_cost * x_dist_percent)/100);
539: valid_fp_tab(l_tab_ndx).receipt_currency_amount := pa_currency.round_currency_amt( (recs.receipt_currency_amount * x_dist_percent)/100) ;
540: ELSE --Bug 6754773

Line 537: valid_fp_tab(l_tab_ndx).acct_raw_cost := pa_currency.round_currency_amt( (recs.acct_raw_cost * x_dist_percent)/100);

533: valid_fp_tab(l_tab_ndx).old_award_amount := pa_currency.round_currency_amt( ( recs.amount * x_dist_percent)/100); /*BUG 13697251 added new field */
534: valid_fp_tab(l_tab_ndx).burdened_cost := pa_currency.round_currency_amt( (recs.burdened_cost * x_dist_percent)/100);
535: valid_fp_tab(l_tab_ndx).denom_burdened_cost := pa_currency.round_currency_amt( (recs.denom_burdened_cost * x_dist_percent)/100 );
536: valid_fp_tab(l_tab_ndx).acct_burdened_cost := pa_currency.round_currency_amt( (recs.acct_burdened_cost * x_dist_percent)/100);
537: valid_fp_tab(l_tab_ndx).acct_raw_cost := pa_currency.round_currency_amt( (recs.acct_raw_cost * x_dist_percent)/100);
538: valid_fp_tab(l_tab_ndx).denom_raw_cost := pa_currency.round_currency_amt( (recs.denom_raw_cost * x_dist_percent)/100);
539: valid_fp_tab(l_tab_ndx).receipt_currency_amount := pa_currency.round_currency_amt( (recs.receipt_currency_amount * x_dist_percent)/100) ;
540: ELSE --Bug 6754773
541: valid_fp_tab(l_tab_ndx).quantity := recs.quantity * x_dist_percent/100;

Line 538: valid_fp_tab(l_tab_ndx).denom_raw_cost := pa_currency.round_currency_amt( (recs.denom_raw_cost * x_dist_percent)/100);

534: valid_fp_tab(l_tab_ndx).burdened_cost := pa_currency.round_currency_amt( (recs.burdened_cost * x_dist_percent)/100);
535: valid_fp_tab(l_tab_ndx).denom_burdened_cost := pa_currency.round_currency_amt( (recs.denom_burdened_cost * x_dist_percent)/100 );
536: valid_fp_tab(l_tab_ndx).acct_burdened_cost := pa_currency.round_currency_amt( (recs.acct_burdened_cost * x_dist_percent)/100);
537: valid_fp_tab(l_tab_ndx).acct_raw_cost := pa_currency.round_currency_amt( (recs.acct_raw_cost * x_dist_percent)/100);
538: valid_fp_tab(l_tab_ndx).denom_raw_cost := pa_currency.round_currency_amt( (recs.denom_raw_cost * x_dist_percent)/100);
539: valid_fp_tab(l_tab_ndx).receipt_currency_amount := pa_currency.round_currency_amt( (recs.receipt_currency_amount * x_dist_percent)/100) ;
540: ELSE --Bug 6754773
541: valid_fp_tab(l_tab_ndx).quantity := recs.quantity * x_dist_percent/100;
542: /* Starts - Modified following columns derivation for bug#6822240 */

Line 539: valid_fp_tab(l_tab_ndx).receipt_currency_amount := pa_currency.round_currency_amt( (recs.receipt_currency_amount * x_dist_percent)/100) ;

535: valid_fp_tab(l_tab_ndx).denom_burdened_cost := pa_currency.round_currency_amt( (recs.denom_burdened_cost * x_dist_percent)/100 );
536: valid_fp_tab(l_tab_ndx).acct_burdened_cost := pa_currency.round_currency_amt( (recs.acct_burdened_cost * x_dist_percent)/100);
537: valid_fp_tab(l_tab_ndx).acct_raw_cost := pa_currency.round_currency_amt( (recs.acct_raw_cost * x_dist_percent)/100);
538: valid_fp_tab(l_tab_ndx).denom_raw_cost := pa_currency.round_currency_amt( (recs.denom_raw_cost * x_dist_percent)/100);
539: valid_fp_tab(l_tab_ndx).receipt_currency_amount := pa_currency.round_currency_amt( (recs.receipt_currency_amount * x_dist_percent)/100) ;
540: ELSE --Bug 6754773
541: valid_fp_tab(l_tab_ndx).quantity := recs.quantity * x_dist_percent/100;
542: /* Starts - Modified following columns derivation for bug#6822240 */
543: valid_fp_tab(l_tab_ndx).award_amount :=

Line 544: pa_currency.round_currency_amt(recs.amount * valid_fp_tab(l_tab_ndx).quantity/recs.quantity);

540: ELSE --Bug 6754773
541: valid_fp_tab(l_tab_ndx).quantity := recs.quantity * x_dist_percent/100;
542: /* Starts - Modified following columns derivation for bug#6822240 */
543: valid_fp_tab(l_tab_ndx).award_amount :=
544: pa_currency.round_currency_amt(recs.amount * valid_fp_tab(l_tab_ndx).quantity/recs.quantity);
545: valid_fp_tab(l_tab_ndx).old_award_amount :=
546: pa_currency.round_currency_amt(recs.amount * valid_fp_tab(l_tab_ndx).quantity/recs.quantity); /*BUG 13697251 added new field */
547: valid_fp_tab(l_tab_ndx).burdened_cost :=
548: pa_currency.round_currency_amt(recs.burdened_cost * valid_fp_tab(l_tab_ndx).quantity/recs.quantity);

Line 546: pa_currency.round_currency_amt(recs.amount * valid_fp_tab(l_tab_ndx).quantity/recs.quantity); /*BUG 13697251 added new field */

542: /* Starts - Modified following columns derivation for bug#6822240 */
543: valid_fp_tab(l_tab_ndx).award_amount :=
544: pa_currency.round_currency_amt(recs.amount * valid_fp_tab(l_tab_ndx).quantity/recs.quantity);
545: valid_fp_tab(l_tab_ndx).old_award_amount :=
546: pa_currency.round_currency_amt(recs.amount * valid_fp_tab(l_tab_ndx).quantity/recs.quantity); /*BUG 13697251 added new field */
547: valid_fp_tab(l_tab_ndx).burdened_cost :=
548: pa_currency.round_currency_amt(recs.burdened_cost * valid_fp_tab(l_tab_ndx).quantity/recs.quantity);
549: valid_fp_tab(l_tab_ndx).denom_burdened_cost :=
550: pa_currency.round_currency_amt( recs.denom_burdened_cost * valid_fp_tab(l_tab_ndx).quantity/recs.quantity);

Line 548: pa_currency.round_currency_amt(recs.burdened_cost * valid_fp_tab(l_tab_ndx).quantity/recs.quantity);

544: pa_currency.round_currency_amt(recs.amount * valid_fp_tab(l_tab_ndx).quantity/recs.quantity);
545: valid_fp_tab(l_tab_ndx).old_award_amount :=
546: pa_currency.round_currency_amt(recs.amount * valid_fp_tab(l_tab_ndx).quantity/recs.quantity); /*BUG 13697251 added new field */
547: valid_fp_tab(l_tab_ndx).burdened_cost :=
548: pa_currency.round_currency_amt(recs.burdened_cost * valid_fp_tab(l_tab_ndx).quantity/recs.quantity);
549: valid_fp_tab(l_tab_ndx).denom_burdened_cost :=
550: pa_currency.round_currency_amt( recs.denom_burdened_cost * valid_fp_tab(l_tab_ndx).quantity/recs.quantity);
551: valid_fp_tab(l_tab_ndx).acct_burdened_cost :=
552: pa_currency.round_currency_amt( recs.acct_burdened_cost * valid_fp_tab(l_tab_ndx).quantity/recs.quantity);

Line 550: pa_currency.round_currency_amt( recs.denom_burdened_cost * valid_fp_tab(l_tab_ndx).quantity/recs.quantity);

546: pa_currency.round_currency_amt(recs.amount * valid_fp_tab(l_tab_ndx).quantity/recs.quantity); /*BUG 13697251 added new field */
547: valid_fp_tab(l_tab_ndx).burdened_cost :=
548: pa_currency.round_currency_amt(recs.burdened_cost * valid_fp_tab(l_tab_ndx).quantity/recs.quantity);
549: valid_fp_tab(l_tab_ndx).denom_burdened_cost :=
550: pa_currency.round_currency_amt( recs.denom_burdened_cost * valid_fp_tab(l_tab_ndx).quantity/recs.quantity);
551: valid_fp_tab(l_tab_ndx).acct_burdened_cost :=
552: pa_currency.round_currency_amt( recs.acct_burdened_cost * valid_fp_tab(l_tab_ndx).quantity/recs.quantity);
553: valid_fp_tab(l_tab_ndx).acct_raw_cost :=
554: pa_currency.round_currency_amt( recs.acct_raw_cost * valid_fp_tab(l_tab_ndx).quantity/recs.quantity);

Line 552: pa_currency.round_currency_amt( recs.acct_burdened_cost * valid_fp_tab(l_tab_ndx).quantity/recs.quantity);

548: pa_currency.round_currency_amt(recs.burdened_cost * valid_fp_tab(l_tab_ndx).quantity/recs.quantity);
549: valid_fp_tab(l_tab_ndx).denom_burdened_cost :=
550: pa_currency.round_currency_amt( recs.denom_burdened_cost * valid_fp_tab(l_tab_ndx).quantity/recs.quantity);
551: valid_fp_tab(l_tab_ndx).acct_burdened_cost :=
552: pa_currency.round_currency_amt( recs.acct_burdened_cost * valid_fp_tab(l_tab_ndx).quantity/recs.quantity);
553: valid_fp_tab(l_tab_ndx).acct_raw_cost :=
554: pa_currency.round_currency_amt( recs.acct_raw_cost * valid_fp_tab(l_tab_ndx).quantity/recs.quantity);
555: valid_fp_tab(l_tab_ndx).denom_raw_cost :=
556: pa_currency.round_currency_amt( recs.denom_raw_cost * valid_fp_tab(l_tab_ndx).quantity/recs.quantity);

Line 554: pa_currency.round_currency_amt( recs.acct_raw_cost * valid_fp_tab(l_tab_ndx).quantity/recs.quantity);

550: pa_currency.round_currency_amt( recs.denom_burdened_cost * valid_fp_tab(l_tab_ndx).quantity/recs.quantity);
551: valid_fp_tab(l_tab_ndx).acct_burdened_cost :=
552: pa_currency.round_currency_amt( recs.acct_burdened_cost * valid_fp_tab(l_tab_ndx).quantity/recs.quantity);
553: valid_fp_tab(l_tab_ndx).acct_raw_cost :=
554: pa_currency.round_currency_amt( recs.acct_raw_cost * valid_fp_tab(l_tab_ndx).quantity/recs.quantity);
555: valid_fp_tab(l_tab_ndx).denom_raw_cost :=
556: pa_currency.round_currency_amt( recs.denom_raw_cost * valid_fp_tab(l_tab_ndx).quantity/recs.quantity);
557: valid_fp_tab(l_tab_ndx).receipt_currency_amount :=
558: pa_currency.round_currency_amt( recs.receipt_currency_amount * valid_fp_tab(l_tab_ndx).quantity/recs.quantity);

Line 556: pa_currency.round_currency_amt( recs.denom_raw_cost * valid_fp_tab(l_tab_ndx).quantity/recs.quantity);

552: pa_currency.round_currency_amt( recs.acct_burdened_cost * valid_fp_tab(l_tab_ndx).quantity/recs.quantity);
553: valid_fp_tab(l_tab_ndx).acct_raw_cost :=
554: pa_currency.round_currency_amt( recs.acct_raw_cost * valid_fp_tab(l_tab_ndx).quantity/recs.quantity);
555: valid_fp_tab(l_tab_ndx).denom_raw_cost :=
556: pa_currency.round_currency_amt( recs.denom_raw_cost * valid_fp_tab(l_tab_ndx).quantity/recs.quantity);
557: valid_fp_tab(l_tab_ndx).receipt_currency_amount :=
558: pa_currency.round_currency_amt( recs.receipt_currency_amount * valid_fp_tab(l_tab_ndx).quantity/recs.quantity);
559: /* ENds - Modified following columns derivation for bug#6809323 */
560: END if;

Line 558: pa_currency.round_currency_amt( recs.receipt_currency_amount * valid_fp_tab(l_tab_ndx).quantity/recs.quantity);

554: pa_currency.round_currency_amt( recs.acct_raw_cost * valid_fp_tab(l_tab_ndx).quantity/recs.quantity);
555: valid_fp_tab(l_tab_ndx).denom_raw_cost :=
556: pa_currency.round_currency_amt( recs.denom_raw_cost * valid_fp_tab(l_tab_ndx).quantity/recs.quantity);
557: valid_fp_tab(l_tab_ndx).receipt_currency_amount :=
558: pa_currency.round_currency_amt( recs.receipt_currency_amount * valid_fp_tab(l_tab_ndx).quantity/recs.quantity);
559: /* ENds - Modified following columns derivation for bug#6809323 */
560: END if;
561:
562: x_acc_qty := x_acc_qty + valid_fp_tab(l_tab_ndx).quantity ;