DBA Data[Home] [Help]

APPS.PA_RETN_BILLING_PKG dependencies on PA_CURRENCY

Line 1027: PA_CURRENCY.ROUND_TRANS_CURRENCY_AMT(p_invproc_amount,p_invproc_currency),

1023: task_id)
1024: VALUES (p_project_id,
1025: p_draft_invoice_num,
1026: LastLineNum,
1027: PA_CURRENCY.ROUND_TRANS_CURRENCY_AMT(p_invproc_amount,p_invproc_currency),
1028: SUBSTR(l_task_name || SUBSTR(RetnLineText,1,LastEndPosition),1,240),
1029: 'RETENTION',
1030: p_projfunc_currency,
1031: PA_CURRENCY.ROUND_TRANS_CURRENCY_AMT(p_projfunc_amount,p_projfunc_currency),

Line 1031: PA_CURRENCY.ROUND_TRANS_CURRENCY_AMT(p_projfunc_amount,p_projfunc_currency),

1027: PA_CURRENCY.ROUND_TRANS_CURRENCY_AMT(p_invproc_amount,p_invproc_currency),
1028: SUBSTR(l_task_name || SUBSTR(RetnLineText,1,LastEndPosition),1,240),
1029: 'RETENTION',
1030: p_projfunc_currency,
1031: PA_CURRENCY.ROUND_TRANS_CURRENCY_AMT(p_projfunc_amount,p_projfunc_currency),
1032: p_project_currency,
1033: PA_CURRENCY.ROUND_TRANS_CURRENCY_AMT(p_project_amount,p_project_currency),
1034: p_funding_currency,
1035: PA_CURRENCY.ROUND_TRANS_CURRENCY_AMT(p_funding_amount,p_funding_currency),

Line 1033: PA_CURRENCY.ROUND_TRANS_CURRENCY_AMT(p_project_amount,p_project_currency),

1029: 'RETENTION',
1030: p_projfunc_currency,
1031: PA_CURRENCY.ROUND_TRANS_CURRENCY_AMT(p_projfunc_amount,p_projfunc_currency),
1032: p_project_currency,
1033: PA_CURRENCY.ROUND_TRANS_CURRENCY_AMT(p_project_amount,p_project_currency),
1034: p_funding_currency,
1035: PA_CURRENCY.ROUND_TRANS_CURRENCY_AMT(p_funding_amount,p_funding_currency),
1036: p_invproc_currency,
1037: l_last_update_login,

Line 1035: PA_CURRENCY.ROUND_TRANS_CURRENCY_AMT(p_funding_amount,p_funding_currency),

1031: PA_CURRENCY.ROUND_TRANS_CURRENCY_AMT(p_projfunc_amount,p_projfunc_currency),
1032: p_project_currency,
1033: PA_CURRENCY.ROUND_TRANS_CURRENCY_AMT(p_project_amount,p_project_currency),
1034: p_funding_currency,
1035: PA_CURRENCY.ROUND_TRANS_CURRENCY_AMT(p_funding_amount,p_funding_currency),
1036: p_invproc_currency,
1037: l_last_update_login,
1038: sysdate,
1039: l_last_updated_by,

Line 1052: PA_CURRENCY.ROUND_TRANS_CURRENCY_AMT(p_invproc_amount,

1048: p_Output_tax_exempt_number ,
1049: p_Output_exempt_reason_code,
1050: DECODE(pa_retn_billing_pkg.G_Inv_By_Bill_Trans_Currency,
1051: 'Y',
1052: PA_CURRENCY.ROUND_TRANS_CURRENCY_AMT(p_invproc_amount,
1053: p_invproc_currency),
1054: PA_CURRENCY.ROUND_TRANS_CURRENCY_AMT(
1055: p_projfunc_amount,p_projfunc_currency)),
1056: p_billing_method_code,

Line 1054: PA_CURRENCY.ROUND_TRANS_CURRENCY_AMT(

1050: DECODE(pa_retn_billing_pkg.G_Inv_By_Bill_Trans_Currency,
1051: 'Y',
1052: PA_CURRENCY.ROUND_TRANS_CURRENCY_AMT(p_invproc_amount,
1053: p_invproc_currency),
1054: PA_CURRENCY.ROUND_TRANS_CURRENCY_AMT(
1055: p_projfunc_amount,p_projfunc_currency)),
1056: p_billing_method_code,
1057: p_comp_percent,
1058: p_TotRetenion,

Line 1062: PA_CURRENCY.ROUND_TRANS_CURRENCY_AMT(

1058: p_TotRetenion,
1059: p_client_extn_flag,
1060: p_bill_cycle_id,
1061: p_billing_percentage,
1062: PA_CURRENCY.ROUND_TRANS_CURRENCY_AMT(
1063: p_billing_amount,
1064: p_invproc_currency),
1065: p_task_id);
1066:

Line 1213: PA_CURRENCY.ROUND_TRANS_CURRENCY_AMT(ProjRetnRec.total_retained,

1209: p_project_id,
1210: p_draft_invoice_num,
1211: p_line_num,
1212: ProjRetnRec.project_retention_id,
1213: PA_CURRENCY.ROUND_TRANS_CURRENCY_AMT(ProjRetnRec.total_retained,
1214: ProjRetnRec.invproc_currency_code),
1215: ProjRetnRec.invproc_currency_code,
1216: ProjRetnRec.projfunc_currency_code,
1217: PA_CURRENCY.ROUND_TRANS_CURRENCY_AMT(ProjRetnRec.projfunc_total_retained,

Line 1217: PA_CURRENCY.ROUND_TRANS_CURRENCY_AMT(ProjRetnRec.projfunc_total_retained,

1213: PA_CURRENCY.ROUND_TRANS_CURRENCY_AMT(ProjRetnRec.total_retained,
1214: ProjRetnRec.invproc_currency_code),
1215: ProjRetnRec.invproc_currency_code,
1216: ProjRetnRec.projfunc_currency_code,
1217: PA_CURRENCY.ROUND_TRANS_CURRENCY_AMT(ProjRetnRec.projfunc_total_retained,
1218: ProjRetnRec.projfunc_currency_code),
1219: ProjRetnRec.project_currency_code,
1220: PA_CURRENCY.ROUND_TRANS_CURRENCY_AMT(ProjRetnRec.project_total_retained,
1221: ProjRetnRec.project_currency_code),

Line 1220: PA_CURRENCY.ROUND_TRANS_CURRENCY_AMT(ProjRetnRec.project_total_retained,

1216: ProjRetnRec.projfunc_currency_code,
1217: PA_CURRENCY.ROUND_TRANS_CURRENCY_AMT(ProjRetnRec.projfunc_total_retained,
1218: ProjRetnRec.projfunc_currency_code),
1219: ProjRetnRec.project_currency_code,
1220: PA_CURRENCY.ROUND_TRANS_CURRENCY_AMT(ProjRetnRec.project_total_retained,
1221: ProjRetnRec.project_currency_code),
1222: ProjRetnRec.funding_currency_code,
1223: PA_CURRENCY.ROUND_TRANS_CURRENCY_AMT(ProjRetnRec.funding_total_retained,
1224: ProjRetnRec.funding_currency_code),

Line 1223: PA_CURRENCY.ROUND_TRANS_CURRENCY_AMT(ProjRetnRec.funding_total_retained,

1219: ProjRetnRec.project_currency_code,
1220: PA_CURRENCY.ROUND_TRANS_CURRENCY_AMT(ProjRetnRec.project_total_retained,
1221: ProjRetnRec.project_currency_code),
1222: ProjRetnRec.funding_currency_code,
1223: PA_CURRENCY.ROUND_TRANS_CURRENCY_AMT(ProjRetnRec.funding_total_retained,
1224: ProjRetnRec.funding_currency_code),
1225: l_program_application_id,
1226: l_program_id,
1227: l_program_update_date,