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_FI_AMT_CALC_PKG dependencies on PA_FORECAST_ITEMS

Line 234: Pa_Forecast_Items

230: EXPENDITURE_TYPE_CLASS,
231: Tp_Amount_Type,
232: Delete_Flag
233: FROM
234: Pa_Forecast_Items
235: WHERE Error_Flag = 'N' AND Item_Date >= c_start_date
236: ORDER BY PROJECT_ID,ASSIGNMENT_ID;
237:
238: CURSOR fcst_item_Inc IS SELECT

Line 260: Pa_Forecast_Items WHERE

256: EXPENDITURE_TYPE_CLASS,
257: Tp_Amount_Type,
258: Delete_Flag
259: FROM
260: Pa_Forecast_Items WHERE
261: forecast_amt_calc_flag = 'N' AND
262: Error_Flag = 'N'
263: ORDER BY PROJECT_ID,ASSIGNMENT_ID;
264:

Line 287: Pa_Forecast_Items WHERE

283: EXPENDITURE_TYPE_CLASS,
284: Tp_Amount_Type,
285: Delete_Flag
286: FROM
287: Pa_Forecast_Items WHERE
288: Project_Id = c_project_id AND
289: Error_Flag = 'N'
290: ORDER BY PROJECT_ID,ASSIGNMENT_ID;
291:

Line 315: Pa_Forecast_Items WHERE

311: EXPENDITURE_TYPE_CLASS,
312: Tp_Amount_Type,
313: Delete_Flag
314: FROM
315: Pa_Forecast_Items WHERE
316: Project_Id = c_project_id AND
317: Assignment_Id = c_assignment_id AND
318: Error_Flag = 'N';
319:

Line 366: Pa_Forecast_Items WHERE

362: EXPENDITURE_TYPE_CLASS,
363: Tp_Amount_Type,
364: Delete_Flag
365: FROM
366: Pa_Forecast_Items WHERE
367: EXPENDITURE_ORGANIZATION_ID = c_organization_id AND
368: Error_Flag = 'N'
369: UNION
370: SELECT

Line 392: Pa_Forecast_Items WHERE

388: EXPENDITURE_TYPE_CLASS,
389: Tp_Amount_Type,
390: Delete_Flag
391: FROM
392: Pa_Forecast_Items WHERE
393: PROJECT_ORGANIZATION_ID = c_organization_id AND
394: Error_Flag = 'N' ) DUAL
395: ORDER BY Project_Id,Assignment_Id;
396:

Line 415: Select distinct assignment_id from PA_FORECAST_ITEMS

411:
412: /* Added this cursor for bug 3051110 */
413:
414: CURSOR Cur_Assignments(c_request_id NUMBER) IS
415: Select distinct assignment_id from PA_FORECAST_ITEMS
416: Where request_id = c_request_id and Forecast_amt_calc_flag = 'Y'
417: and assignment_id is NOT NULL;
418:
419: l_fi_id_tab PA_PLSQL_DATATYPES.IdTabTyp;

Line 449: l_prev_fi_pvdr_papd Pa_Forecast_Items.PVDR_PA_PERIOD_NAME%TYPE;

445: l_fi_process_flag_tab PA_PLSQL_DATATYPES.Char30TabTyp;
446: l_line_num Pa_Forecast_Item_Details.Line_Num%TYPE;
447: l_temp_line_num Pa_Forecast_Item_Details.Line_Num%TYPE;
448:
449: l_prev_fi_pvdr_papd Pa_Forecast_Items.PVDR_PA_PERIOD_NAME%TYPE;
450:
451: l_prev_project_id NUMBER;
452: l_prev_asg_id NUMBER;
453: l_prev_proj_orgid NUMBER;

Line 816: l_prev_rt_prj_id Pa_Forecast_Items.Project_Id%TYPE;

812: l_fid_upd_line_num PA_PLSQL_DATATYPES.NumTabTyp;
813: l_fid_upd_reversed_flag PA_PLSQL_DATATYPES.Char1TabTyp;
814: l_fid_upd_net_zero_flag PA_PLSQL_DATATYPES.Char1TabTyp;
815:
816: l_prev_rt_prj_id Pa_Forecast_Items.Project_Id%TYPE;
817: l_prev_rt_asg_id Pa_Forecast_Items.Assignment_Id%TYPE;
818: l_prev_rt_personid Pa_Forecast_Items.Person_Id%TYPE;
819: l_prev_rt_fi_itemtype Pa_Forecast_Items.Forecast_Item_Type%TYPE;
820: l_prev_rt_fi_proc_flag VARCHAR2(1);

Line 817: l_prev_rt_asg_id Pa_Forecast_Items.Assignment_Id%TYPE;

813: l_fid_upd_reversed_flag PA_PLSQL_DATATYPES.Char1TabTyp;
814: l_fid_upd_net_zero_flag PA_PLSQL_DATATYPES.Char1TabTyp;
815:
816: l_prev_rt_prj_id Pa_Forecast_Items.Project_Id%TYPE;
817: l_prev_rt_asg_id Pa_Forecast_Items.Assignment_Id%TYPE;
818: l_prev_rt_personid Pa_Forecast_Items.Person_Id%TYPE;
819: l_prev_rt_fi_itemtype Pa_Forecast_Items.Forecast_Item_Type%TYPE;
820: l_prev_rt_fi_proc_flag VARCHAR2(1);
821: l_prev_rt_calling_mode VARCHAR2(30);

Line 818: l_prev_rt_personid Pa_Forecast_Items.Person_Id%TYPE;

814: l_fid_upd_net_zero_flag PA_PLSQL_DATATYPES.Char1TabTyp;
815:
816: l_prev_rt_prj_id Pa_Forecast_Items.Project_Id%TYPE;
817: l_prev_rt_asg_id Pa_Forecast_Items.Assignment_Id%TYPE;
818: l_prev_rt_personid Pa_Forecast_Items.Person_Id%TYPE;
819: l_prev_rt_fi_itemtype Pa_Forecast_Items.Forecast_Item_Type%TYPE;
820: l_prev_rt_fi_proc_flag VARCHAR2(1);
821: l_prev_rt_calling_mode VARCHAR2(30);
822: l_prev_rt_fcst_jobid Pa_Project_Assignments.Fcst_Job_Id%TYPE;

Line 819: l_prev_rt_fi_itemtype Pa_Forecast_Items.Forecast_Item_Type%TYPE;

815:
816: l_prev_rt_prj_id Pa_Forecast_Items.Project_Id%TYPE;
817: l_prev_rt_asg_id Pa_Forecast_Items.Assignment_Id%TYPE;
818: l_prev_rt_personid Pa_Forecast_Items.Person_Id%TYPE;
819: l_prev_rt_fi_itemtype Pa_Forecast_Items.Forecast_Item_Type%TYPE;
820: l_prev_rt_fi_proc_flag VARCHAR2(1);
821: l_prev_rt_calling_mode VARCHAR2(30);
822: l_prev_rt_fcst_jobid Pa_Project_Assignments.Fcst_Job_Id%TYPE;
823: l_prev_rt_fcst_jobgroupid Pa_Project_Assignments.Fcst_Job_Group_Id%TYPE;

Line 824: l_prev_rt_exp_type Pa_Forecast_Items.Expenditure_Type%TYPE;

820: l_prev_rt_fi_proc_flag VARCHAR2(1);
821: l_prev_rt_calling_mode VARCHAR2(30);
822: l_prev_rt_fcst_jobid Pa_Project_Assignments.Fcst_Job_Id%TYPE;
823: l_prev_rt_fcst_jobgroupid Pa_Project_Assignments.Fcst_Job_Group_Id%TYPE;
824: l_prev_rt_exp_type Pa_Forecast_Items.Expenditure_Type%TYPE;
825: l_prev_rt_org_id Pa_Forecast_Items.Expenditure_Org_Id%TYPE;
826: l_prev_rt_prj_type Pa_Projects_All.Project_Type%TYPE;
827: l_prev_rt_projfunc_currcode Pa_Projects_All.Project_Currency_Code%TYPE;
828: l_prev_rt_proj_currcode Pa_Projects_All.Project_Currency_Code%TYPE;

Line 825: l_prev_rt_org_id Pa_Forecast_Items.Expenditure_Org_Id%TYPE;

821: l_prev_rt_calling_mode VARCHAR2(30);
822: l_prev_rt_fcst_jobid Pa_Project_Assignments.Fcst_Job_Id%TYPE;
823: l_prev_rt_fcst_jobgroupid Pa_Project_Assignments.Fcst_Job_Group_Id%TYPE;
824: l_prev_rt_exp_type Pa_Forecast_Items.Expenditure_Type%TYPE;
825: l_prev_rt_org_id Pa_Forecast_Items.Expenditure_Org_Id%TYPE;
826: l_prev_rt_prj_type Pa_Projects_All.Project_Type%TYPE;
827: l_prev_rt_projfunc_currcode Pa_Projects_All.Project_Currency_Code%TYPE;
828: l_prev_rt_proj_currcode Pa_Projects_All.Project_Currency_Code%TYPE;
829: l_prev_rt_bill_jobgroup_id Pa_Projects_All.Bill_Job_Group_Id%TYPE;

Line 915: l_sum_transfer_price PA_FORECAST_ITEMS.PROJFUNC_TRANSFER_PRICE%TYPE;

911: l_asgmt_status_flag VARCHAR2(1);
912:
913: /* Variables added for bug 3051110 */
914: l_assignment_id pa_project_assignments.assignment_id%TYPE;
915: l_sum_transfer_price PA_FORECAST_ITEMS.PROJFUNC_TRANSFER_PRICE%TYPE;
916: l_sum_item_quantity PA_FORECAST_ITEMS.ITEM_QUANTITY%TYPE;
917: l_average_transfer_price_rate PA_FORECAST_ITEMS.PROJFUNC_TRANSFER_PRICE%TYPE;
918: l_return_status VARCHAR2(1);
919:

Line 916: l_sum_item_quantity PA_FORECAST_ITEMS.ITEM_QUANTITY%TYPE;

912:
913: /* Variables added for bug 3051110 */
914: l_assignment_id pa_project_assignments.assignment_id%TYPE;
915: l_sum_transfer_price PA_FORECAST_ITEMS.PROJFUNC_TRANSFER_PRICE%TYPE;
916: l_sum_item_quantity PA_FORECAST_ITEMS.ITEM_QUANTITY%TYPE;
917: l_average_transfer_price_rate PA_FORECAST_ITEMS.PROJFUNC_TRANSFER_PRICE%TYPE;
918: l_return_status VARCHAR2(1);
919:
920: BEGIN

Line 917: l_average_transfer_price_rate PA_FORECAST_ITEMS.PROJFUNC_TRANSFER_PRICE%TYPE;

913: /* Variables added for bug 3051110 */
914: l_assignment_id pa_project_assignments.assignment_id%TYPE;
915: l_sum_transfer_price PA_FORECAST_ITEMS.PROJFUNC_TRANSFER_PRICE%TYPE;
916: l_sum_item_quantity PA_FORECAST_ITEMS.ITEM_QUANTITY%TYPE;
917: l_average_transfer_price_rate PA_FORECAST_ITEMS.PROJFUNC_TRANSFER_PRICE%TYPE;
918: l_return_status VARCHAR2(1);
919:
920: BEGIN
921: retcode := '0';

Line 1436: UPDATE Pa_Forecast_Items SET Forecast_Amt_Calc_Flag = 'P'

1432: /* Forecast Item records should be locked to prevent Update from
1433: Forecast Item generation Process */
1434:
1435: FORALL l_fi_lck_idx IN 1 .. l_fi_id_tab.COUNT
1436: UPDATE Pa_Forecast_Items SET Forecast_Amt_Calc_Flag = 'P'
1437: WHERE
1438: Forecast_Item_Id = l_fi_id_tab(l_fi_lck_idx);
1439:
1440: FOR I IN 1 .. l_fi_id_tab.count LOOP

Line 4192: UPDATE Pa_Forecast_Items SET

4188: dbms_output.put_line(' fi id '||l_fi_id_tab.count); */
4189:
4190:
4191: FORALL l_fi_upd_index IN 1 .. l_fi_id_tab.COUNT
4192: UPDATE Pa_Forecast_Items SET
4193: FORECAST_AMT_CALC_FLAG = l_fi_process_flag_tab(l_fi_upd_index),
4194: TP_AMOUNT_TYPE = l_fi_amount_type_tab(l_fi_upd_index),
4195: COST_TXN_CURRENCY_CODE = l_fia_cost_txn_curr_code(l_fi_upd_index),
4196: REVENUE_TXN_CURRENCY_CODE = l_fia_rev_txn_curr_code(l_fi_upd_index),

Line 4268: Getting the sum of projfunc_transfer_price and item_quantity from pa_forecast_items table for the assignment_id,

4264: pa_debug.write('Pa_Fi_Amt_Calc_Pkg.Calculate_Fcst_Amounts', 'Currently Populating for assignment_id :'||l_assignment_id, 3);
4265: END IF;
4266:
4267: /*
4268: Getting the sum of projfunc_transfer_price and item_quantity from pa_forecast_items table for the assignment_id,
4269: if any of the sum is NULL we populate the transfer_price_rate as NULL and transfer_pr_rate_curr as NULL and if
4270: any of the sum is 0, we populate the transfer_price_rate as 0 and transfer_pr_rate_curr as the project
4271: functional currency. If both the sums have non zero value and they are not null, we calculate the average
4272: transfer_price_rate and call the api to populate the transfer_price_rate as average Transfer_price_Rate and

Line 4279: From PA_FORECAST_ITEMS

4275:
4276: BEGIN
4277: Select sum(PROJFUNC_TRANSFER_PRICE), Sum(ITEM_QUANTITY)
4278: INTO l_sum_transfer_price, l_sum_item_quantity
4279: From PA_FORECAST_ITEMS
4280: Where assignment_id = l_assignment_ID and delete_flag = 'N'
4281: and error_flag = 'N' And forecast_amt_Calc_flag ='Y';
4282: EXCEPTION WHEN NO_DATA_FOUND THEN
4283: l_sum_transfer_price := Null;