DBA Data[Home] [Help]

APPS.PA_FUNDS_CONTROL_PKG1 dependencies on PA_CURRENCY

Line 979: l_cwk_multiplier := pa_currency.round_trans_currency_amt

975: ,cwk.expenditure_type
976: ,cwk.burden_amt_display_method
977: ,'GL');
978: If l_cwk_multiplier is NOT NULL Then
979: l_cwk_multiplier := pa_currency.round_trans_currency_amt
980: (l_cwk_multiplier,g_acct_currency_code);
981: End If;
982: UPDATE pa_bc_commitments_all cmt
983: SET cmt.compiled_multiplier = decode (cmt.document_line_id,NULL,cmt.compiled_multiplier,

Line 1016: l_cwk_multiplier := pa_currency.round_trans_currency_amt

1012: ,cwk.expenditure_type
1013: ,cwk.burden_amt_display_method
1014: ,'GL');
1015: If l_cwk_multiplier is NOT NULL Then
1016: l_cwk_multiplier := pa_currency.round_trans_currency_amt
1017: (l_cwk_multiplier,g_acct_currency_code);
1018: End If;
1019: UPDATE pa_bc_packets cmt
1020: SET cmt.compiled_multiplier = decode (cmt.document_line_id,NULL,cmt.compiled_multiplier

Line 4042: NVL(pa_currency.round_trans_currency_amt(g_tab_entered_dr(i),g_acct_currency_code),0),

4038: g_tab_doc_distribution_id(i),
4039: g_tab_actual_flag(i),
4040: g_tab_result_code(i),
4041: g_tab_status_code(i),
4042: NVL(pa_currency.round_trans_currency_amt(g_tab_entered_dr(i),g_acct_currency_code),0),
4043: NVL(pa_currency.round_trans_currency_amt(g_tab_entered_cr(i),g_acct_currency_code),0),
4044: NVL(pa_currency.round_trans_currency_amt(g_tab_accounted_dr(i),g_acct_currency_code),0),
4045: NVL(pa_currency.round_trans_currency_amt(g_tab_accounted_cr(i),g_acct_currency_code),0),
4046: g_tab_balance_posted_flag(i),

Line 4043: NVL(pa_currency.round_trans_currency_amt(g_tab_entered_cr(i),g_acct_currency_code),0),

4039: g_tab_actual_flag(i),
4040: g_tab_result_code(i),
4041: g_tab_status_code(i),
4042: NVL(pa_currency.round_trans_currency_amt(g_tab_entered_dr(i),g_acct_currency_code),0),
4043: NVL(pa_currency.round_trans_currency_amt(g_tab_entered_cr(i),g_acct_currency_code),0),
4044: NVL(pa_currency.round_trans_currency_amt(g_tab_accounted_dr(i),g_acct_currency_code),0),
4045: NVL(pa_currency.round_trans_currency_amt(g_tab_accounted_cr(i),g_acct_currency_code),0),
4046: g_tab_balance_posted_flag(i),
4047: g_tab_funds_process_mode(i),

Line 4044: NVL(pa_currency.round_trans_currency_amt(g_tab_accounted_dr(i),g_acct_currency_code),0),

4040: g_tab_result_code(i),
4041: g_tab_status_code(i),
4042: NVL(pa_currency.round_trans_currency_amt(g_tab_entered_dr(i),g_acct_currency_code),0),
4043: NVL(pa_currency.round_trans_currency_amt(g_tab_entered_cr(i),g_acct_currency_code),0),
4044: NVL(pa_currency.round_trans_currency_amt(g_tab_accounted_dr(i),g_acct_currency_code),0),
4045: NVL(pa_currency.round_trans_currency_amt(g_tab_accounted_cr(i),g_acct_currency_code),0),
4046: g_tab_balance_posted_flag(i),
4047: g_tab_funds_process_mode(i),
4048: g_tab_trxn_ccid(i),

Line 4045: NVL(pa_currency.round_trans_currency_amt(g_tab_accounted_cr(i),g_acct_currency_code),0),

4041: g_tab_status_code(i),
4042: NVL(pa_currency.round_trans_currency_amt(g_tab_entered_dr(i),g_acct_currency_code),0),
4043: NVL(pa_currency.round_trans_currency_amt(g_tab_entered_cr(i),g_acct_currency_code),0),
4044: NVL(pa_currency.round_trans_currency_amt(g_tab_accounted_dr(i),g_acct_currency_code),0),
4045: NVL(pa_currency.round_trans_currency_amt(g_tab_accounted_cr(i),g_acct_currency_code),0),
4046: g_tab_balance_posted_flag(i),
4047: g_tab_funds_process_mode(i),
4048: g_tab_trxn_ccid(i),
4049: g_tab_burden_cost_flag(i),

Line 4554: pa_currency.round_trans_currency_amt(

4550: pbc.period_year,
4551: pbc.period_num,
4552: pbc.result_code,
4553: pbc.status_code,
4554: pa_currency.round_trans_currency_amt(
4555: DECODE ( NVL ( pbc.entered_dr, 0 ), 0, 0,
4556: (( NVL (pbc.entered_dr ,0) *
4557: NVL (pa_funds_control_utils.get_fc_compiled_multiplier
4558: ( pbc.expenditure_organization_id,

Line 4564: pa_currency.round_trans_currency_amt(

4560: pbc.expenditure_item_date,
4561: 'C',
4562: pbc.expenditure_type
4563: ), 0)))),g_acct_currency_code),
4564: pa_currency.round_trans_currency_amt(
4565: DECODE ( NVL ( pbc.entered_cr, 0 ), 0, 0,
4566: (( NVL (pbc.entered_cr ,0) *
4567: NVL (pa_funds_control_utils.get_fc_compiled_multiplier
4568: ( pbc.expenditure_organization_id,

Line 4574: pa_currency.round_trans_currency_amt(

4570: pbc.expenditure_item_date,
4571: 'C',
4572: pbc.expenditure_type
4573: ), 0)))),g_acct_currency_code),
4574: pa_currency.round_trans_currency_amt(
4575: DECODE ( NVL ( pbc.accounted_dr, 0 ), 0, 0,
4576: (( NVL (pbc.accounted_dr ,0) *
4577: NVL (pa_funds_control_utils.get_fc_compiled_multiplier
4578: ( pbc.expenditure_organization_id,

Line 4584: pa_currency.round_trans_currency_amt(

4580: pbc.expenditure_item_date,
4581: 'C',
4582: pbc.expenditure_type
4583: ), 0)))),g_acct_currency_code),
4584: pa_currency.round_trans_currency_amt(
4585: DECODE ( NVL ( pbc.accounted_cr, 0 ), 0, 0,
4586: (( NVL (pbc.accounted_cr ,0) *
4587: NVL (pa_funds_control_utils.get_fc_compiled_multiplier
4588: ( pbc.expenditure_organization_id,

Line 4735: pa_currency.round_trans_currency_amt(

4731: pbc.period_year,
4732: pbc.period_num,
4733: pbc.result_code,
4734: pbc.status_code,
4735: pa_currency.round_trans_currency_amt(
4736: decode(nvl(pbc.entered_dr,0),0,0,(nvl(pbc.entered_dr,0)*
4737: cm.compiled_multiplier)),g_acct_currency_code),
4738: pa_currency.round_trans_currency_amt(
4739: decode(nvl(pbc.entered_cr,0),0,0,(nvl(pbc.entered_cr,0)*

Line 4738: pa_currency.round_trans_currency_amt(

4734: pbc.status_code,
4735: pa_currency.round_trans_currency_amt(
4736: decode(nvl(pbc.entered_dr,0),0,0,(nvl(pbc.entered_dr,0)*
4737: cm.compiled_multiplier)),g_acct_currency_code),
4738: pa_currency.round_trans_currency_amt(
4739: decode(nvl(pbc.entered_cr,0),0,0,(nvl(pbc.entered_cr,0)*
4740: cm.compiled_multiplier)),g_acct_currency_code),
4741: pa_currency.round_trans_currency_amt(
4742: decode(nvl(pbc.accounted_dr,0),0,0,(nvl(pbc.accounted_dr,0)*

Line 4741: pa_currency.round_trans_currency_amt(

4737: cm.compiled_multiplier)),g_acct_currency_code),
4738: pa_currency.round_trans_currency_amt(
4739: decode(nvl(pbc.entered_cr,0),0,0,(nvl(pbc.entered_cr,0)*
4740: cm.compiled_multiplier)),g_acct_currency_code),
4741: pa_currency.round_trans_currency_amt(
4742: decode(nvl(pbc.accounted_dr,0),0,0,(nvl(pbc.accounted_dr,0)*
4743: cm.compiled_multiplier)),g_acct_currency_code),
4744: pa_currency.round_trans_currency_amt(
4745: decode(nvl(pbc.accounted_cr,0),0,0,(nvl(pbc.accounted_cr,0)*

Line 4744: pa_currency.round_trans_currency_amt(

4740: cm.compiled_multiplier)),g_acct_currency_code),
4741: pa_currency.round_trans_currency_amt(
4742: decode(nvl(pbc.accounted_dr,0),0,0,(nvl(pbc.accounted_dr,0)*
4743: cm.compiled_multiplier)),g_acct_currency_code),
4744: pa_currency.round_trans_currency_amt(
4745: decode(nvl(pbc.accounted_cr,0),0,0,(nvl(pbc.accounted_cr,0)*
4746: cm.compiled_multiplier)),g_acct_currency_code),
4747: NULL, --gl_row_bc_packet_row_id
4748: pbc.balance_posted_flag,

Line 5498: pa_currency.round_trans_currency_amt(

5494: pbc.period_year,
5495: pbc.period_num,
5496: pbc.result_code,
5497: pbc.status_code,
5498: pa_currency.round_trans_currency_amt(
5499: DECODE ( NVL ( pbc.entered_dr, 0 ), 0, 0,
5500: (( NVL (pbc.entered_dr ,0) *
5501: l_tab_multiplier(indx)))),g_acct_currency_code),
5502: pa_currency.round_trans_currency_amt(

Line 5502: pa_currency.round_trans_currency_amt(

5498: pa_currency.round_trans_currency_amt(
5499: DECODE ( NVL ( pbc.entered_dr, 0 ), 0, 0,
5500: (( NVL (pbc.entered_dr ,0) *
5501: l_tab_multiplier(indx)))),g_acct_currency_code),
5502: pa_currency.round_trans_currency_amt(
5503: DECODE ( NVL ( pbc.entered_cr, 0 ), 0, 0,
5504: (( NVL (pbc.entered_cr ,0) *
5505: l_tab_multiplier(indx) ))),g_acct_currency_code),
5506: pa_currency.round_trans_currency_amt(

Line 5506: pa_currency.round_trans_currency_amt(

5502: pa_currency.round_trans_currency_amt(
5503: DECODE ( NVL ( pbc.entered_cr, 0 ), 0, 0,
5504: (( NVL (pbc.entered_cr ,0) *
5505: l_tab_multiplier(indx) ))),g_acct_currency_code),
5506: pa_currency.round_trans_currency_amt(
5507: DECODE ( NVL ( pbc.accounted_dr, 0 ), 0, 0,
5508: (( NVL (pbc.accounted_dr ,0) *
5509: l_tab_multiplier(indx)))),g_acct_currency_code),
5510: pa_currency.round_trans_currency_amt(

Line 5510: pa_currency.round_trans_currency_amt(

5506: pa_currency.round_trans_currency_amt(
5507: DECODE ( NVL ( pbc.accounted_dr, 0 ), 0, 0,
5508: (( NVL (pbc.accounted_dr ,0) *
5509: l_tab_multiplier(indx)))),g_acct_currency_code),
5510: pa_currency.round_trans_currency_amt(
5511: DECODE ( NVL ( pbc.accounted_cr, 0 ), 0, 0,
5512: (( NVL (pbc.accounted_cr ,0) *
5513: l_tab_multiplier(indx)))),g_acct_currency_code),
5514: NULL, --gl_row_bc_packet_row_id

Line 5678: pa_currency.round_trans_currency_amt

5674: pbc.period_num,
5675: pbc.result_code,
5676: pbc.status_code,
5677: /* Incorrect Burden amts Bug fix:
5678: pa_currency.round_trans_currency_amt
5679: (p_entered_cr,g_acct_currency_code),
5680: -- amount from pa_bc_commitments (flip the amts)
5681: pa_currency.round_trans_currency_amt
5682: (p_entered_dr,g_acct_currency_code), -- amount from pa_bc_commitments

Line 5681: pa_currency.round_trans_currency_amt

5677: /* Incorrect Burden amts Bug fix:
5678: pa_currency.round_trans_currency_amt
5679: (p_entered_cr,g_acct_currency_code),
5680: -- amount from pa_bc_commitments (flip the amts)
5681: pa_currency.round_trans_currency_amt
5682: (p_entered_dr,g_acct_currency_code), -- amount from pa_bc_commitments
5683: pa_currency.round_trans_currency_amt
5684: (p_accounted_cr,g_acct_currency_code),-- amount from pa_bc_commitments
5685: pa_currency.round_trans_currency_amt

Line 5683: pa_currency.round_trans_currency_amt

5679: (p_entered_cr,g_acct_currency_code),
5680: -- amount from pa_bc_commitments (flip the amts)
5681: pa_currency.round_trans_currency_amt
5682: (p_entered_dr,g_acct_currency_code), -- amount from pa_bc_commitments
5683: pa_currency.round_trans_currency_amt
5684: (p_accounted_cr,g_acct_currency_code),-- amount from pa_bc_commitments
5685: pa_currency.round_trans_currency_amt
5686: (p_accounted_dr,g_acct_currency_code), -- amount from pa_bc_commitments
5687: End Of bug fix: */

Line 5685: pa_currency.round_trans_currency_amt

5681: pa_currency.round_trans_currency_amt
5682: (p_entered_dr,g_acct_currency_code), -- amount from pa_bc_commitments
5683: pa_currency.round_trans_currency_amt
5684: (p_accounted_cr,g_acct_currency_code),-- amount from pa_bc_commitments
5685: pa_currency.round_trans_currency_amt
5686: (p_accounted_dr,g_acct_currency_code), -- amount from pa_bc_commitments
5687: End Of bug fix: */
5688: pa_currency.round_trans_currency_amt
5689: (p_entered_dr,g_acct_currency_code),

Line 5688: pa_currency.round_trans_currency_amt

5684: (p_accounted_cr,g_acct_currency_code),-- amount from pa_bc_commitments
5685: pa_currency.round_trans_currency_amt
5686: (p_accounted_dr,g_acct_currency_code), -- amount from pa_bc_commitments
5687: End Of bug fix: */
5688: pa_currency.round_trans_currency_amt
5689: (p_entered_dr,g_acct_currency_code),
5690: pa_currency.round_trans_currency_amt
5691: (p_entered_cr,g_acct_currency_code),
5692: pa_currency.round_trans_currency_amt

Line 5690: pa_currency.round_trans_currency_amt

5686: (p_accounted_dr,g_acct_currency_code), -- amount from pa_bc_commitments
5687: End Of bug fix: */
5688: pa_currency.round_trans_currency_amt
5689: (p_entered_dr,g_acct_currency_code),
5690: pa_currency.round_trans_currency_amt
5691: (p_entered_cr,g_acct_currency_code),
5692: pa_currency.round_trans_currency_amt
5693: (p_accounted_dr,g_acct_currency_code),
5694: pa_currency.round_trans_currency_amt

Line 5692: pa_currency.round_trans_currency_amt

5688: pa_currency.round_trans_currency_amt
5689: (p_entered_dr,g_acct_currency_code),
5690: pa_currency.round_trans_currency_amt
5691: (p_entered_cr,g_acct_currency_code),
5692: pa_currency.round_trans_currency_amt
5693: (p_accounted_dr,g_acct_currency_code),
5694: pa_currency.round_trans_currency_amt
5695: (p_accounted_cr,g_acct_currency_code),
5696: NULL, --gl_row_bc_packet_row_id to be updated later

Line 5694: pa_currency.round_trans_currency_amt

5690: pa_currency.round_trans_currency_amt
5691: (p_entered_cr,g_acct_currency_code),
5692: pa_currency.round_trans_currency_amt
5693: (p_accounted_dr,g_acct_currency_code),
5694: pa_currency.round_trans_currency_amt
5695: (p_accounted_cr,g_acct_currency_code),
5696: NULL, --gl_row_bc_packet_row_id to be updated later
5697: pbc.balance_posted_flag,
5698: pbc.funds_process_mode,

Line 5865: pa_currency.round_trans_currency_amt(

5861: pbc.period_year,
5862: pbc.period_num,
5863: pbc.result_code,
5864: pbc.status_code,
5865: pa_currency.round_trans_currency_amt(
5866: decode(nvl(pbc.entered_dr,0),0,0,(nvl(pbc.entered_dr,0)*
5867: l_tab_multiplier(indx))),g_acct_currency_code),
5868: pa_currency.round_trans_currency_amt(
5869: decode(nvl(pbc.entered_cr,0),0,0,(nvl(pbc.entered_cr,0)*

Line 5868: pa_currency.round_trans_currency_amt(

5864: pbc.status_code,
5865: pa_currency.round_trans_currency_amt(
5866: decode(nvl(pbc.entered_dr,0),0,0,(nvl(pbc.entered_dr,0)*
5867: l_tab_multiplier(indx))),g_acct_currency_code),
5868: pa_currency.round_trans_currency_amt(
5869: decode(nvl(pbc.entered_cr,0),0,0,(nvl(pbc.entered_cr,0)*
5870: l_tab_multiplier(indx))),g_acct_currency_code),
5871: pa_currency.round_trans_currency_amt(
5872: decode(nvl(pbc.accounted_dr,0),0,0,(nvl(pbc.accounted_dr,0)*

Line 5871: pa_currency.round_trans_currency_amt(

5867: l_tab_multiplier(indx))),g_acct_currency_code),
5868: pa_currency.round_trans_currency_amt(
5869: decode(nvl(pbc.entered_cr,0),0,0,(nvl(pbc.entered_cr,0)*
5870: l_tab_multiplier(indx))),g_acct_currency_code),
5871: pa_currency.round_trans_currency_amt(
5872: decode(nvl(pbc.accounted_dr,0),0,0,(nvl(pbc.accounted_dr,0)*
5873: l_tab_multiplier(indx))),g_acct_currency_code),
5874: pa_currency.round_trans_currency_amt(
5875: decode(nvl(pbc.accounted_cr,0),0,0,(nvl(pbc.accounted_cr,0)*

Line 5874: pa_currency.round_trans_currency_amt(

5870: l_tab_multiplier(indx))),g_acct_currency_code),
5871: pa_currency.round_trans_currency_amt(
5872: decode(nvl(pbc.accounted_dr,0),0,0,(nvl(pbc.accounted_dr,0)*
5873: l_tab_multiplier(indx))),g_acct_currency_code),
5874: pa_currency.round_trans_currency_amt(
5875: decode(nvl(pbc.accounted_cr,0),0,0,(nvl(pbc.accounted_cr,0)*
5876: l_tab_multiplier(indx))),g_acct_currency_code),
5877: NULL, --gl_row_bc_packet_row_id
5878: pbc.balance_posted_flag,

Line 6052: pa_currency.round_trans_currency_amt

6048: pbc.period_num,
6049: pbc.result_code,
6050: pbc.status_code,
6051: /* Incorrect Burden amts Bug fix:
6052: pa_currency.round_trans_currency_amt
6053: (p_entered_cr,g_acct_currency_code),
6054: -- amount from pa_bc_commitments (flip amts)
6055: pa_currency.round_trans_currency_amt
6056: (p_entered_dr,g_acct_currency_code), -- amount from pa_bc_commitments

Line 6055: pa_currency.round_trans_currency_amt

6051: /* Incorrect Burden amts Bug fix:
6052: pa_currency.round_trans_currency_amt
6053: (p_entered_cr,g_acct_currency_code),
6054: -- amount from pa_bc_commitments (flip amts)
6055: pa_currency.round_trans_currency_amt
6056: (p_entered_dr,g_acct_currency_code), -- amount from pa_bc_commitments
6057: pa_currency.round_trans_currency_amt
6058: (p_accounted_cr,g_acct_currency_code), -- amount from pa_bc_commitments
6059: pa_currency.round_trans_currency_amt

Line 6057: pa_currency.round_trans_currency_amt

6053: (p_entered_cr,g_acct_currency_code),
6054: -- amount from pa_bc_commitments (flip amts)
6055: pa_currency.round_trans_currency_amt
6056: (p_entered_dr,g_acct_currency_code), -- amount from pa_bc_commitments
6057: pa_currency.round_trans_currency_amt
6058: (p_accounted_cr,g_acct_currency_code), -- amount from pa_bc_commitments
6059: pa_currency.round_trans_currency_amt
6060: (p_accounted_dr,g_acct_currency_code), -- amount from pa_bc_commitments
6061: End of Bug fix: */

Line 6059: pa_currency.round_trans_currency_amt

6055: pa_currency.round_trans_currency_amt
6056: (p_entered_dr,g_acct_currency_code), -- amount from pa_bc_commitments
6057: pa_currency.round_trans_currency_amt
6058: (p_accounted_cr,g_acct_currency_code), -- amount from pa_bc_commitments
6059: pa_currency.round_trans_currency_amt
6060: (p_accounted_dr,g_acct_currency_code), -- amount from pa_bc_commitments
6061: End of Bug fix: */
6062: pa_currency.round_trans_currency_amt
6063: (p_entered_dr,g_acct_currency_code),

Line 6062: pa_currency.round_trans_currency_amt

6058: (p_accounted_cr,g_acct_currency_code), -- amount from pa_bc_commitments
6059: pa_currency.round_trans_currency_amt
6060: (p_accounted_dr,g_acct_currency_code), -- amount from pa_bc_commitments
6061: End of Bug fix: */
6062: pa_currency.round_trans_currency_amt
6063: (p_entered_dr,g_acct_currency_code),
6064: pa_currency.round_trans_currency_amt
6065: (p_entered_cr,g_acct_currency_code),
6066: pa_currency.round_trans_currency_amt

Line 6064: pa_currency.round_trans_currency_amt

6060: (p_accounted_dr,g_acct_currency_code), -- amount from pa_bc_commitments
6061: End of Bug fix: */
6062: pa_currency.round_trans_currency_amt
6063: (p_entered_dr,g_acct_currency_code),
6064: pa_currency.round_trans_currency_amt
6065: (p_entered_cr,g_acct_currency_code),
6066: pa_currency.round_trans_currency_amt
6067: (p_accounted_dr,g_acct_currency_code),
6068: pa_currency.round_trans_currency_amt

Line 6066: pa_currency.round_trans_currency_amt

6062: pa_currency.round_trans_currency_amt
6063: (p_entered_dr,g_acct_currency_code),
6064: pa_currency.round_trans_currency_amt
6065: (p_entered_cr,g_acct_currency_code),
6066: pa_currency.round_trans_currency_amt
6067: (p_accounted_dr,g_acct_currency_code),
6068: pa_currency.round_trans_currency_amt
6069: (p_accounted_cr,g_acct_currency_code),
6070: NULL, --gl_row_bc_packet_row_id to be updated later

Line 6068: pa_currency.round_trans_currency_amt

6064: pa_currency.round_trans_currency_amt
6065: (p_entered_cr,g_acct_currency_code),
6066: pa_currency.round_trans_currency_amt
6067: (p_accounted_dr,g_acct_currency_code),
6068: pa_currency.round_trans_currency_amt
6069: (p_accounted_cr,g_acct_currency_code),
6070: NULL, --gl_row_bc_packet_row_id to be updated later
6071: pbc.balance_posted_flag,
6072: pbc.funds_process_mode,