DBA Data[Home] [Help]

APPS.PA_FUNDS_CONTROL_PKG1 dependencies on PA_CURRENCY

Line 994: l_cwk_multiplier := pa_currency.round_trans_currency_amt

990: ,cwk.expenditure_type
991: ,cwk.burden_amt_display_method
992: ,'GL');
993: If l_cwk_multiplier is NOT NULL Then
994: l_cwk_multiplier := pa_currency.round_trans_currency_amt
995: (l_cwk_multiplier,g_acct_currency_code);
996: End If;
997: UPDATE pa_bc_commitments_all cmt
998: SET cmt.compiled_multiplier = decode (cmt.document_line_id,NULL,cmt.compiled_multiplier,

Line 1031: l_cwk_multiplier := pa_currency.round_trans_currency_amt

1027: ,cwk.expenditure_type
1028: ,cwk.burden_amt_display_method
1029: ,'GL');
1030: If l_cwk_multiplier is NOT NULL Then
1031: l_cwk_multiplier := pa_currency.round_trans_currency_amt
1032: (l_cwk_multiplier,g_acct_currency_code);
1033: End If;
1034: UPDATE pa_bc_packets cmt
1035: SET cmt.compiled_multiplier = decode (cmt.document_line_id,NULL,cmt.compiled_multiplier

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

4323: g_tab_doc_distribution_id(i),
4324: g_tab_actual_flag(i),
4325: g_tab_result_code(i),
4326: g_tab_status_code(i),
4327: NVL(pa_currency.round_trans_currency_amt(g_tab_entered_dr(i),g_acct_currency_code),0),
4328: NVL(pa_currency.round_trans_currency_amt(g_tab_entered_cr(i),g_acct_currency_code),0),
4329: NVL(pa_currency.round_trans_currency_amt(g_tab_accounted_dr(i),g_acct_currency_code),0),
4330: NVL(pa_currency.round_trans_currency_amt(g_tab_accounted_cr(i),g_acct_currency_code),0),
4331: g_tab_balance_posted_flag(i),

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

4324: g_tab_actual_flag(i),
4325: g_tab_result_code(i),
4326: g_tab_status_code(i),
4327: NVL(pa_currency.round_trans_currency_amt(g_tab_entered_dr(i),g_acct_currency_code),0),
4328: NVL(pa_currency.round_trans_currency_amt(g_tab_entered_cr(i),g_acct_currency_code),0),
4329: NVL(pa_currency.round_trans_currency_amt(g_tab_accounted_dr(i),g_acct_currency_code),0),
4330: NVL(pa_currency.round_trans_currency_amt(g_tab_accounted_cr(i),g_acct_currency_code),0),
4331: g_tab_balance_posted_flag(i),
4332: g_tab_funds_process_mode(i),

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

4325: g_tab_result_code(i),
4326: g_tab_status_code(i),
4327: NVL(pa_currency.round_trans_currency_amt(g_tab_entered_dr(i),g_acct_currency_code),0),
4328: NVL(pa_currency.round_trans_currency_amt(g_tab_entered_cr(i),g_acct_currency_code),0),
4329: NVL(pa_currency.round_trans_currency_amt(g_tab_accounted_dr(i),g_acct_currency_code),0),
4330: NVL(pa_currency.round_trans_currency_amt(g_tab_accounted_cr(i),g_acct_currency_code),0),
4331: g_tab_balance_posted_flag(i),
4332: g_tab_funds_process_mode(i),
4333: g_tab_trxn_ccid(i),

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

4326: g_tab_status_code(i),
4327: NVL(pa_currency.round_trans_currency_amt(g_tab_entered_dr(i),g_acct_currency_code),0),
4328: NVL(pa_currency.round_trans_currency_amt(g_tab_entered_cr(i),g_acct_currency_code),0),
4329: NVL(pa_currency.round_trans_currency_amt(g_tab_accounted_dr(i),g_acct_currency_code),0),
4330: NVL(pa_currency.round_trans_currency_amt(g_tab_accounted_cr(i),g_acct_currency_code),0),
4331: g_tab_balance_posted_flag(i),
4332: g_tab_funds_process_mode(i),
4333: g_tab_trxn_ccid(i),
4334: g_tab_burden_cost_flag(i),

Line 4853: pa_currency.round_trans_currency_amt(

4849: pbc.period_year,
4850: pbc.period_num,
4851: pbc.result_code,
4852: pbc.status_code,
4853: pa_currency.round_trans_currency_amt(
4854: DECODE ( NVL ( pbc.entered_dr, 0 ), 0, 0,
4855: (( NVL (pbc.entered_dr ,0) *
4856: NVL (pa_funds_control_utils.get_fc_compiled_multiplier
4857: ( pbc.expenditure_organization_id,

Line 4863: pa_currency.round_trans_currency_amt(

4859: pbc.expenditure_item_date,
4860: 'C',
4861: pbc.expenditure_type
4862: ), 0)))),g_acct_currency_code),
4863: pa_currency.round_trans_currency_amt(
4864: DECODE ( NVL ( pbc.entered_cr, 0 ), 0, 0,
4865: (( NVL (pbc.entered_cr ,0) *
4866: NVL (pa_funds_control_utils.get_fc_compiled_multiplier
4867: ( pbc.expenditure_organization_id,

Line 4873: pa_currency.round_trans_currency_amt(

4869: pbc.expenditure_item_date,
4870: 'C',
4871: pbc.expenditure_type
4872: ), 0)))),g_acct_currency_code),
4873: pa_currency.round_trans_currency_amt(
4874: DECODE ( NVL ( pbc.accounted_dr, 0 ), 0, 0,
4875: (( NVL (pbc.accounted_dr ,0) *
4876: NVL (pa_funds_control_utils.get_fc_compiled_multiplier
4877: ( pbc.expenditure_organization_id,

Line 4883: pa_currency.round_trans_currency_amt(

4879: pbc.expenditure_item_date,
4880: 'C',
4881: pbc.expenditure_type
4882: ), 0)))),g_acct_currency_code),
4883: pa_currency.round_trans_currency_amt(
4884: DECODE ( NVL ( pbc.accounted_cr, 0 ), 0, 0,
4885: (( NVL (pbc.accounted_cr ,0) *
4886: NVL (pa_funds_control_utils.get_fc_compiled_multiplier
4887: ( pbc.expenditure_organization_id,

Line 5034: pa_currency.round_trans_currency_amt(

5030: pbc.period_year,
5031: pbc.period_num,
5032: pbc.result_code,
5033: pbc.status_code,
5034: pa_currency.round_trans_currency_amt(
5035: decode(nvl(pbc.entered_dr,0),0,0,(nvl(pbc.entered_dr,0)*
5036: cm.compiled_multiplier)),g_acct_currency_code),
5037: pa_currency.round_trans_currency_amt(
5038: decode(nvl(pbc.entered_cr,0),0,0,(nvl(pbc.entered_cr,0)*

Line 5037: pa_currency.round_trans_currency_amt(

5033: pbc.status_code,
5034: pa_currency.round_trans_currency_amt(
5035: decode(nvl(pbc.entered_dr,0),0,0,(nvl(pbc.entered_dr,0)*
5036: cm.compiled_multiplier)),g_acct_currency_code),
5037: pa_currency.round_trans_currency_amt(
5038: decode(nvl(pbc.entered_cr,0),0,0,(nvl(pbc.entered_cr,0)*
5039: cm.compiled_multiplier)),g_acct_currency_code),
5040: pa_currency.round_trans_currency_amt(
5041: decode(nvl(pbc.accounted_dr,0),0,0,(nvl(pbc.accounted_dr,0)*

Line 5040: pa_currency.round_trans_currency_amt(

5036: cm.compiled_multiplier)),g_acct_currency_code),
5037: pa_currency.round_trans_currency_amt(
5038: decode(nvl(pbc.entered_cr,0),0,0,(nvl(pbc.entered_cr,0)*
5039: cm.compiled_multiplier)),g_acct_currency_code),
5040: pa_currency.round_trans_currency_amt(
5041: decode(nvl(pbc.accounted_dr,0),0,0,(nvl(pbc.accounted_dr,0)*
5042: cm.compiled_multiplier)),g_acct_currency_code),
5043: pa_currency.round_trans_currency_amt(
5044: decode(nvl(pbc.accounted_cr,0),0,0,(nvl(pbc.accounted_cr,0)*

Line 5043: pa_currency.round_trans_currency_amt(

5039: cm.compiled_multiplier)),g_acct_currency_code),
5040: pa_currency.round_trans_currency_amt(
5041: decode(nvl(pbc.accounted_dr,0),0,0,(nvl(pbc.accounted_dr,0)*
5042: cm.compiled_multiplier)),g_acct_currency_code),
5043: pa_currency.round_trans_currency_amt(
5044: decode(nvl(pbc.accounted_cr,0),0,0,(nvl(pbc.accounted_cr,0)*
5045: cm.compiled_multiplier)),g_acct_currency_code),
5046: NULL, --gl_row_bc_packet_row_id
5047: pbc.balance_posted_flag,

Line 5819: pa_currency.round_trans_currency_amt(

5815: pbc.period_year,
5816: pbc.period_num,
5817: pbc.result_code,
5818: pbc.status_code,
5819: pa_currency.round_trans_currency_amt(
5820: DECODE ( NVL ( pbc.entered_dr, 0 ), 0, 0,
5821: (( NVL (pbc.entered_dr ,0) *
5822: l_tab_multiplier(indx)))),g_acct_currency_code),
5823: pa_currency.round_trans_currency_amt(

Line 5823: pa_currency.round_trans_currency_amt(

5819: pa_currency.round_trans_currency_amt(
5820: DECODE ( NVL ( pbc.entered_dr, 0 ), 0, 0,
5821: (( NVL (pbc.entered_dr ,0) *
5822: l_tab_multiplier(indx)))),g_acct_currency_code),
5823: pa_currency.round_trans_currency_amt(
5824: DECODE ( NVL ( pbc.entered_cr, 0 ), 0, 0,
5825: (( NVL (pbc.entered_cr ,0) *
5826: l_tab_multiplier(indx) ))),g_acct_currency_code),
5827: pa_currency.round_trans_currency_amt(

Line 5827: pa_currency.round_trans_currency_amt(

5823: pa_currency.round_trans_currency_amt(
5824: DECODE ( NVL ( pbc.entered_cr, 0 ), 0, 0,
5825: (( NVL (pbc.entered_cr ,0) *
5826: l_tab_multiplier(indx) ))),g_acct_currency_code),
5827: pa_currency.round_trans_currency_amt(
5828: DECODE ( NVL ( pbc.accounted_dr, 0 ), 0, 0,
5829: (( NVL (pbc.accounted_dr ,0) *
5830: l_tab_multiplier(indx)))),g_acct_currency_code),
5831: pa_currency.round_trans_currency_amt(

Line 5831: pa_currency.round_trans_currency_amt(

5827: pa_currency.round_trans_currency_amt(
5828: DECODE ( NVL ( pbc.accounted_dr, 0 ), 0, 0,
5829: (( NVL (pbc.accounted_dr ,0) *
5830: l_tab_multiplier(indx)))),g_acct_currency_code),
5831: pa_currency.round_trans_currency_amt(
5832: DECODE ( NVL ( pbc.accounted_cr, 0 ), 0, 0,
5833: (( NVL (pbc.accounted_cr ,0) *
5834: l_tab_multiplier(indx)))),g_acct_currency_code),
5835: NULL, --gl_row_bc_packet_row_id

Line 5999: pa_currency.round_trans_currency_amt

5995: pbc.period_num,
5996: pbc.result_code,
5997: pbc.status_code,
5998: /* Incorrect Burden amts Bug fix:
5999: pa_currency.round_trans_currency_amt
6000: (p_entered_cr,g_acct_currency_code),
6001: -- amount from pa_bc_commitments (flip the amts)
6002: pa_currency.round_trans_currency_amt
6003: (p_entered_dr,g_acct_currency_code), -- amount from pa_bc_commitments

Line 6002: pa_currency.round_trans_currency_amt

5998: /* Incorrect Burden amts Bug fix:
5999: pa_currency.round_trans_currency_amt
6000: (p_entered_cr,g_acct_currency_code),
6001: -- amount from pa_bc_commitments (flip the amts)
6002: pa_currency.round_trans_currency_amt
6003: (p_entered_dr,g_acct_currency_code), -- amount from pa_bc_commitments
6004: pa_currency.round_trans_currency_amt
6005: (p_accounted_cr,g_acct_currency_code),-- amount from pa_bc_commitments
6006: pa_currency.round_trans_currency_amt

Line 6004: pa_currency.round_trans_currency_amt

6000: (p_entered_cr,g_acct_currency_code),
6001: -- amount from pa_bc_commitments (flip the amts)
6002: pa_currency.round_trans_currency_amt
6003: (p_entered_dr,g_acct_currency_code), -- amount from pa_bc_commitments
6004: pa_currency.round_trans_currency_amt
6005: (p_accounted_cr,g_acct_currency_code),-- amount from pa_bc_commitments
6006: pa_currency.round_trans_currency_amt
6007: (p_accounted_dr,g_acct_currency_code), -- amount from pa_bc_commitments
6008: End Of bug fix: */

Line 6006: pa_currency.round_trans_currency_amt

6002: pa_currency.round_trans_currency_amt
6003: (p_entered_dr,g_acct_currency_code), -- amount from pa_bc_commitments
6004: pa_currency.round_trans_currency_amt
6005: (p_accounted_cr,g_acct_currency_code),-- amount from pa_bc_commitments
6006: pa_currency.round_trans_currency_amt
6007: (p_accounted_dr,g_acct_currency_code), -- amount from pa_bc_commitments
6008: End Of bug fix: */
6009: pa_currency.round_trans_currency_amt
6010: (p_entered_dr,g_acct_currency_code),

Line 6009: pa_currency.round_trans_currency_amt

6005: (p_accounted_cr,g_acct_currency_code),-- amount from pa_bc_commitments
6006: pa_currency.round_trans_currency_amt
6007: (p_accounted_dr,g_acct_currency_code), -- amount from pa_bc_commitments
6008: End Of bug fix: */
6009: pa_currency.round_trans_currency_amt
6010: (p_entered_dr,g_acct_currency_code),
6011: pa_currency.round_trans_currency_amt
6012: (p_entered_cr,g_acct_currency_code),
6013: pa_currency.round_trans_currency_amt

Line 6011: pa_currency.round_trans_currency_amt

6007: (p_accounted_dr,g_acct_currency_code), -- amount from pa_bc_commitments
6008: End Of bug fix: */
6009: pa_currency.round_trans_currency_amt
6010: (p_entered_dr,g_acct_currency_code),
6011: pa_currency.round_trans_currency_amt
6012: (p_entered_cr,g_acct_currency_code),
6013: pa_currency.round_trans_currency_amt
6014: (p_accounted_dr,g_acct_currency_code),
6015: pa_currency.round_trans_currency_amt

Line 6013: pa_currency.round_trans_currency_amt

6009: pa_currency.round_trans_currency_amt
6010: (p_entered_dr,g_acct_currency_code),
6011: pa_currency.round_trans_currency_amt
6012: (p_entered_cr,g_acct_currency_code),
6013: pa_currency.round_trans_currency_amt
6014: (p_accounted_dr,g_acct_currency_code),
6015: pa_currency.round_trans_currency_amt
6016: (p_accounted_cr,g_acct_currency_code),
6017: NULL, --gl_row_bc_packet_row_id to be updated later

Line 6015: pa_currency.round_trans_currency_amt

6011: pa_currency.round_trans_currency_amt
6012: (p_entered_cr,g_acct_currency_code),
6013: pa_currency.round_trans_currency_amt
6014: (p_accounted_dr,g_acct_currency_code),
6015: pa_currency.round_trans_currency_amt
6016: (p_accounted_cr,g_acct_currency_code),
6017: NULL, --gl_row_bc_packet_row_id to be updated later
6018: pbc.balance_posted_flag,
6019: pbc.funds_process_mode,

Line 6186: pa_currency.round_trans_currency_amt(

6182: pbc.period_year,
6183: pbc.period_num,
6184: pbc.result_code,
6185: pbc.status_code,
6186: pa_currency.round_trans_currency_amt(
6187: decode(nvl(pbc.entered_dr,0),0,0,(nvl(pbc.entered_dr,0)*
6188: l_tab_multiplier(indx))),g_acct_currency_code),
6189: pa_currency.round_trans_currency_amt(
6190: decode(nvl(pbc.entered_cr,0),0,0,(nvl(pbc.entered_cr,0)*

Line 6189: pa_currency.round_trans_currency_amt(

6185: pbc.status_code,
6186: pa_currency.round_trans_currency_amt(
6187: decode(nvl(pbc.entered_dr,0),0,0,(nvl(pbc.entered_dr,0)*
6188: l_tab_multiplier(indx))),g_acct_currency_code),
6189: pa_currency.round_trans_currency_amt(
6190: decode(nvl(pbc.entered_cr,0),0,0,(nvl(pbc.entered_cr,0)*
6191: l_tab_multiplier(indx))),g_acct_currency_code),
6192: pa_currency.round_trans_currency_amt(
6193: decode(nvl(pbc.accounted_dr,0),0,0,(nvl(pbc.accounted_dr,0)*

Line 6192: pa_currency.round_trans_currency_amt(

6188: l_tab_multiplier(indx))),g_acct_currency_code),
6189: pa_currency.round_trans_currency_amt(
6190: decode(nvl(pbc.entered_cr,0),0,0,(nvl(pbc.entered_cr,0)*
6191: l_tab_multiplier(indx))),g_acct_currency_code),
6192: pa_currency.round_trans_currency_amt(
6193: decode(nvl(pbc.accounted_dr,0),0,0,(nvl(pbc.accounted_dr,0)*
6194: l_tab_multiplier(indx))),g_acct_currency_code),
6195: pa_currency.round_trans_currency_amt(
6196: decode(nvl(pbc.accounted_cr,0),0,0,(nvl(pbc.accounted_cr,0)*

Line 6195: pa_currency.round_trans_currency_amt(

6191: l_tab_multiplier(indx))),g_acct_currency_code),
6192: pa_currency.round_trans_currency_amt(
6193: decode(nvl(pbc.accounted_dr,0),0,0,(nvl(pbc.accounted_dr,0)*
6194: l_tab_multiplier(indx))),g_acct_currency_code),
6195: pa_currency.round_trans_currency_amt(
6196: decode(nvl(pbc.accounted_cr,0),0,0,(nvl(pbc.accounted_cr,0)*
6197: l_tab_multiplier(indx))),g_acct_currency_code),
6198: NULL, --gl_row_bc_packet_row_id
6199: pbc.balance_posted_flag,

Line 6373: pa_currency.round_trans_currency_amt

6369: pbc.period_num,
6370: pbc.result_code,
6371: pbc.status_code,
6372: /* Incorrect Burden amts Bug fix:
6373: pa_currency.round_trans_currency_amt
6374: (p_entered_cr,g_acct_currency_code),
6375: -- amount from pa_bc_commitments (flip amts)
6376: pa_currency.round_trans_currency_amt
6377: (p_entered_dr,g_acct_currency_code), -- amount from pa_bc_commitments

Line 6376: pa_currency.round_trans_currency_amt

6372: /* Incorrect Burden amts Bug fix:
6373: pa_currency.round_trans_currency_amt
6374: (p_entered_cr,g_acct_currency_code),
6375: -- amount from pa_bc_commitments (flip amts)
6376: pa_currency.round_trans_currency_amt
6377: (p_entered_dr,g_acct_currency_code), -- amount from pa_bc_commitments
6378: pa_currency.round_trans_currency_amt
6379: (p_accounted_cr,g_acct_currency_code), -- amount from pa_bc_commitments
6380: pa_currency.round_trans_currency_amt

Line 6378: pa_currency.round_trans_currency_amt

6374: (p_entered_cr,g_acct_currency_code),
6375: -- amount from pa_bc_commitments (flip amts)
6376: pa_currency.round_trans_currency_amt
6377: (p_entered_dr,g_acct_currency_code), -- amount from pa_bc_commitments
6378: pa_currency.round_trans_currency_amt
6379: (p_accounted_cr,g_acct_currency_code), -- amount from pa_bc_commitments
6380: pa_currency.round_trans_currency_amt
6381: (p_accounted_dr,g_acct_currency_code), -- amount from pa_bc_commitments
6382: End of Bug fix: */

Line 6380: pa_currency.round_trans_currency_amt

6376: pa_currency.round_trans_currency_amt
6377: (p_entered_dr,g_acct_currency_code), -- amount from pa_bc_commitments
6378: pa_currency.round_trans_currency_amt
6379: (p_accounted_cr,g_acct_currency_code), -- amount from pa_bc_commitments
6380: pa_currency.round_trans_currency_amt
6381: (p_accounted_dr,g_acct_currency_code), -- amount from pa_bc_commitments
6382: End of Bug fix: */
6383: pa_currency.round_trans_currency_amt
6384: (p_entered_dr,g_acct_currency_code),

Line 6383: pa_currency.round_trans_currency_amt

6379: (p_accounted_cr,g_acct_currency_code), -- amount from pa_bc_commitments
6380: pa_currency.round_trans_currency_amt
6381: (p_accounted_dr,g_acct_currency_code), -- amount from pa_bc_commitments
6382: End of Bug fix: */
6383: pa_currency.round_trans_currency_amt
6384: (p_entered_dr,g_acct_currency_code),
6385: pa_currency.round_trans_currency_amt
6386: (p_entered_cr,g_acct_currency_code),
6387: pa_currency.round_trans_currency_amt

Line 6385: pa_currency.round_trans_currency_amt

6381: (p_accounted_dr,g_acct_currency_code), -- amount from pa_bc_commitments
6382: End of Bug fix: */
6383: pa_currency.round_trans_currency_amt
6384: (p_entered_dr,g_acct_currency_code),
6385: pa_currency.round_trans_currency_amt
6386: (p_entered_cr,g_acct_currency_code),
6387: pa_currency.round_trans_currency_amt
6388: (p_accounted_dr,g_acct_currency_code),
6389: pa_currency.round_trans_currency_amt

Line 6387: pa_currency.round_trans_currency_amt

6383: pa_currency.round_trans_currency_amt
6384: (p_entered_dr,g_acct_currency_code),
6385: pa_currency.round_trans_currency_amt
6386: (p_entered_cr,g_acct_currency_code),
6387: pa_currency.round_trans_currency_amt
6388: (p_accounted_dr,g_acct_currency_code),
6389: pa_currency.round_trans_currency_amt
6390: (p_accounted_cr,g_acct_currency_code),
6391: NULL, --gl_row_bc_packet_row_id to be updated later

Line 6389: pa_currency.round_trans_currency_amt

6385: pa_currency.round_trans_currency_amt
6386: (p_entered_cr,g_acct_currency_code),
6387: pa_currency.round_trans_currency_amt
6388: (p_accounted_dr,g_acct_currency_code),
6389: pa_currency.round_trans_currency_amt
6390: (p_accounted_cr,g_acct_currency_code),
6391: NULL, --gl_row_bc_packet_row_id to be updated later
6392: pbc.balance_posted_flag,
6393: pbc.funds_process_mode,