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.PA_CI_SUPPLIER_PKG dependencies on PA_CURRENCY

Line 400: ,pa_currency.round_trans_currency_amt

396: ,p_PO_HEADER_ID
397: ,p_PO_LINE_ID
398: ,p_ADJUSTED_TRANSACTION_ID
399: ,p_CURRENCY_CODE
400: ,pa_currency.round_trans_currency_amt
401: (decode(p_CHANGE_AMOUNT,null,0,p_CHANGE_AMOUNT),p_CURRENCY_CODE)
402: ,p_CHANGE_TYPE
403: ,NVL(p_CHANGE_DESCRIPTION,l_CHANGE_DESCRIPTION)
404: ,p_CREATED_BY

Line 413: ,pa_currency.round_trans_currency_amt

409: ,p_Task_Id
410: ,p_Resource_List_Mem_Id
411: ,to_date(p_From_Date)
412: ,to_date(p_To_Date)
413: ,pa_currency.round_trans_currency_amt
414: (decode(p_Estimated_Cost,null,0,p_Estimated_Cost),p_CURRENCY_CODE)
415: ,pa_currency.round_trans_currency_amt
416: (decode(p_Quoted_Cost,null,0,p_Quoted_Cost),p_CURRENCY_CODE)
417: ,pa_currency.round_trans_currency_amt

Line 415: ,pa_currency.round_trans_currency_amt

411: ,to_date(p_From_Date)
412: ,to_date(p_To_Date)
413: ,pa_currency.round_trans_currency_amt
414: (decode(p_Estimated_Cost,null,0,p_Estimated_Cost),p_CURRENCY_CODE)
415: ,pa_currency.round_trans_currency_amt
416: (decode(p_Quoted_Cost,null,0,p_Quoted_Cost),p_CURRENCY_CODE)
417: ,pa_currency.round_trans_currency_amt
418: (decode(p_Negotiated_Cost,null,0,p_Negotiated_Cost),p_CURRENCY_CODE)
419: ,pa_currency.round_trans_currency_amt

Line 417: ,pa_currency.round_trans_currency_amt

413: ,pa_currency.round_trans_currency_amt
414: (decode(p_Estimated_Cost,null,0,p_Estimated_Cost),p_CURRENCY_CODE)
415: ,pa_currency.round_trans_currency_amt
416: (decode(p_Quoted_Cost,null,0,p_Quoted_Cost),p_CURRENCY_CODE)
417: ,pa_currency.round_trans_currency_amt
418: (decode(p_Negotiated_Cost,null,0,p_Negotiated_Cost),p_CURRENCY_CODE)
419: ,pa_currency.round_trans_currency_amt
420: (decode(p_Burdened_cost,null,(p_CHANGE_AMOUNT+(p_CHANGE_AMOUNT*0.1)),p_Burdened_cost),p_CURRENCY_CODE)
421: ,pa_currency.round_trans_currency_amt

Line 419: ,pa_currency.round_trans_currency_amt

415: ,pa_currency.round_trans_currency_amt
416: (decode(p_Quoted_Cost,null,0,p_Quoted_Cost),p_CURRENCY_CODE)
417: ,pa_currency.round_trans_currency_amt
418: (decode(p_Negotiated_Cost,null,0,p_Negotiated_Cost),p_CURRENCY_CODE)
419: ,pa_currency.round_trans_currency_amt
420: (decode(p_Burdened_cost,null,(p_CHANGE_AMOUNT+(p_CHANGE_AMOUNT*0.1)),p_Burdened_cost),p_CURRENCY_CODE)
421: ,pa_currency.round_trans_currency_amt
422: (decode(p_CHANGE_AMOUNT,null,0,p_CHANGE_AMOUNT),p_CURRENCY_CODE)
423: --,pa_currency.round_trans_currency_amt

Line 421: ,pa_currency.round_trans_currency_amt

417: ,pa_currency.round_trans_currency_amt
418: (decode(p_Negotiated_Cost,null,0,p_Negotiated_Cost),p_CURRENCY_CODE)
419: ,pa_currency.round_trans_currency_amt
420: (decode(p_Burdened_cost,null,(p_CHANGE_AMOUNT+(p_CHANGE_AMOUNT*0.1)),p_Burdened_cost),p_CURRENCY_CODE)
421: ,pa_currency.round_trans_currency_amt
422: (decode(p_CHANGE_AMOUNT,null,0,p_CHANGE_AMOUNT),p_CURRENCY_CODE)
423: --,pa_currency.round_trans_currency_amt
424: -- (decode(p_Burdened_cost,null,(p_CHANGE_AMOUNT+(p_CHANGE_AMOUNT*0.1)),p_Burdened_cost),p_CURRENCY_CODE)
425: ,pa_currency.round_trans_currency_amt(p_Burdened_cost,p_CURRENCY_CODE)

Line 423: --,pa_currency.round_trans_currency_amt

419: ,pa_currency.round_trans_currency_amt
420: (decode(p_Burdened_cost,null,(p_CHANGE_AMOUNT+(p_CHANGE_AMOUNT*0.1)),p_Burdened_cost),p_CURRENCY_CODE)
421: ,pa_currency.round_trans_currency_amt
422: (decode(p_CHANGE_AMOUNT,null,0,p_CHANGE_AMOUNT),p_CURRENCY_CODE)
423: --,pa_currency.round_trans_currency_amt
424: -- (decode(p_Burdened_cost,null,(p_CHANGE_AMOUNT+(p_CHANGE_AMOUNT*0.1)),p_Burdened_cost),p_CURRENCY_CODE)
425: ,pa_currency.round_trans_currency_amt(p_Burdened_cost,p_CURRENCY_CODE)
426: ,l_revenue_rate
427: ,p_revenue_override_rate

Line 425: ,pa_currency.round_trans_currency_amt(p_Burdened_cost,p_CURRENCY_CODE)

421: ,pa_currency.round_trans_currency_amt
422: (decode(p_CHANGE_AMOUNT,null,0,p_CHANGE_AMOUNT),p_CURRENCY_CODE)
423: --,pa_currency.round_trans_currency_amt
424: -- (decode(p_Burdened_cost,null,(p_CHANGE_AMOUNT+(p_CHANGE_AMOUNT*0.1)),p_Burdened_cost),p_CURRENCY_CODE)
425: ,pa_currency.round_trans_currency_amt(p_Burdened_cost,p_CURRENCY_CODE)
426: ,l_revenue_rate
427: ,p_revenue_override_rate
428: ,pa_currency.round_trans_currency_amt
429: (decode(l_revenue,null,0,l_revenue),p_CURRENCY_CODE)

Line 428: ,pa_currency.round_trans_currency_amt

424: -- (decode(p_Burdened_cost,null,(p_CHANGE_AMOUNT+(p_CHANGE_AMOUNT*0.1)),p_Burdened_cost),p_CURRENCY_CODE)
425: ,pa_currency.round_trans_currency_amt(p_Burdened_cost,p_CURRENCY_CODE)
426: ,l_revenue_rate
427: ,p_revenue_override_rate
428: ,pa_currency.round_trans_currency_amt
429: (decode(l_revenue,null,0,l_revenue),p_CURRENCY_CODE)
430: ,pa_currency.round_trans_currency_amt
431: (decode(l_revenue,null,0,l_revenue),p_CURRENCY_CODE)
432: ,'Y'

Line 430: ,pa_currency.round_trans_currency_amt

426: ,l_revenue_rate
427: ,p_revenue_override_rate
428: ,pa_currency.round_trans_currency_amt
429: (decode(l_revenue,null,0,l_revenue),p_CURRENCY_CODE)
430: ,pa_currency.round_trans_currency_amt
431: (decode(l_revenue,null,0,l_revenue),p_CURRENCY_CODE)
432: ,'Y'
433: ,p_version_type
434: ,l_audit_history_number

Line 1150: ,CHANGE_AMOUNT = pa_currency.round_trans_currency_amt

1146: ,PO_HEADER_ID = p_po_header_id
1147: ,PO_LINE_ID = p_po_line_id
1148: ,ADJUSTED_CI_TRANSACTION_ID = p_adjusted_transaction_id
1149: ,CURRENCY_CODE = p_currency_code
1150: ,CHANGE_AMOUNT = pa_currency.round_trans_currency_amt
1151: (decode(p_CHANGE_AMOUNT,null,0,p_CHANGE_AMOUNT),p_CURRENCY_CODE)
1152: ,CHANGE_TYPE = p_change_type
1153: ,CHANGE_DESCRIPTION = p_change_description
1154: ,LAST_UPDATED_BY = p_last_updated_by

Line 1383: TOTAL_QUANTITY = pa_currency.round_trans_currency_amt

1379:
1380: --nag_test('Done with resource assignment insert');
1381:
1382: UPDATE pa_resource_asgn_curr SET
1383: TOTAL_QUANTITY = pa_currency.round_trans_currency_amt
1384: (decode(p_CHANGE_AMOUNT,null,0,p_CHANGE_AMOUNT),p_CURRENCY_CODE)
1385: ,TXN_AVERAGE_RAW_COST_RATE = 1
1386: ,TXN_AVERAGE_BURDEN_COST_RATE = 0.1
1387: ,TXN_AVERAGE_BILL_RATE = l_revenue_rate

Line 1388: ,TOTAL_TXN_RAW_COST = pa_currency.round_trans_currency_amt

1384: (decode(p_CHANGE_AMOUNT,null,0,p_CHANGE_AMOUNT),p_CURRENCY_CODE)
1385: ,TXN_AVERAGE_RAW_COST_RATE = 1
1386: ,TXN_AVERAGE_BURDEN_COST_RATE = 0.1
1387: ,TXN_AVERAGE_BILL_RATE = l_revenue_rate
1388: ,TOTAL_TXN_RAW_COST = pa_currency.round_trans_currency_amt
1389: (decode(p_CHANGE_AMOUNT,null,0,p_CHANGE_AMOUNT),p_CURRENCY_CODE)
1390: ,TOTAL_TXN_BURDENED_COST = decode(p_Burdened_cost,null,(p_CHANGE_AMOUNT+(p_CHANGE_AMOUNT*0.1)),p_Burdened_cost)
1391: ,TOTAL_TXN_REVENUE = l_revenue
1392: ,TOTAL_PROJECT_RAW_COST = pa_currency.round_trans_currency_amt

Line 1392: ,TOTAL_PROJECT_RAW_COST = pa_currency.round_trans_currency_amt

1388: ,TOTAL_TXN_RAW_COST = pa_currency.round_trans_currency_amt
1389: (decode(p_CHANGE_AMOUNT,null,0,p_CHANGE_AMOUNT),p_CURRENCY_CODE)
1390: ,TOTAL_TXN_BURDENED_COST = decode(p_Burdened_cost,null,(p_CHANGE_AMOUNT+(p_CHANGE_AMOUNT*0.1)),p_Burdened_cost)
1391: ,TOTAL_TXN_REVENUE = l_revenue
1392: ,TOTAL_PROJECT_RAW_COST = pa_currency.round_trans_currency_amt
1393: (decode(p_CHANGE_AMOUNT,null,0,p_CHANGE_AMOUNT),p_CURRENCY_CODE)
1394: ,TOTAL_PROJECT_BURDENED_COST = decode(p_Burdened_cost,null,(p_CHANGE_AMOUNT+(p_CHANGE_AMOUNT*0.1)),p_Burdened_cost)
1395: ,TOTAL_PROJECT_REVENUE = l_revenue
1396: ,TOTAL_PROJFUNC_RAW_COST = pa_currency.round_trans_currency_amt

Line 1396: ,TOTAL_PROJFUNC_RAW_COST = pa_currency.round_trans_currency_amt

1392: ,TOTAL_PROJECT_RAW_COST = pa_currency.round_trans_currency_amt
1393: (decode(p_CHANGE_AMOUNT,null,0,p_CHANGE_AMOUNT),p_CURRENCY_CODE)
1394: ,TOTAL_PROJECT_BURDENED_COST = decode(p_Burdened_cost,null,(p_CHANGE_AMOUNT+(p_CHANGE_AMOUNT*0.1)),p_Burdened_cost)
1395: ,TOTAL_PROJECT_REVENUE = l_revenue
1396: ,TOTAL_PROJFUNC_RAW_COST = pa_currency.round_trans_currency_amt
1397: (decode(p_CHANGE_AMOUNT,null,0,p_CHANGE_AMOUNT),p_CURRENCY_CODE)
1398: ,TOTAL_PROJFUNC_BURDENED_COST = decode(p_Burdened_cost,null,(p_CHANGE_AMOUNT+(p_CHANGE_AMOUNT*0.1)),p_Burdened_cost)
1399: ,TOTAL_PROJFUNC_REVENUE = l_revenue
1400: ,LAST_UPDATE_DATE = p_LAST_UPDATE_DATE