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_PROJECT_ASSIGNMENTS

Line 523: l_asg_fcst_job_id Pa_Project_Assignments.Fcst_Job_Id%TYPE;

519:
520:
521: /* Project Assignment info */
522:
523: l_asg_fcst_job_id Pa_Project_Assignments.Fcst_Job_Id%TYPE;
524: l_asg_fcst_job_group_id Pa_Project_Assignments.Fcst_Job_Group_Id%TYPE;
525: l_asg_project_role_id Pa_Project_Assignments.Project_Role_Id%TYPE;
526: l_asg_markup_percent Pa_Project_Assignments.Markup_Percent%TYPE;
527: l_asg_bill_rate_override Pa_Project_Assignments.Bill_Rate_Override%TYPE;

Line 524: l_asg_fcst_job_group_id Pa_Project_Assignments.Fcst_Job_Group_Id%TYPE;

520:
521: /* Project Assignment info */
522:
523: l_asg_fcst_job_id Pa_Project_Assignments.Fcst_Job_Id%TYPE;
524: l_asg_fcst_job_group_id Pa_Project_Assignments.Fcst_Job_Group_Id%TYPE;
525: l_asg_project_role_id Pa_Project_Assignments.Project_Role_Id%TYPE;
526: l_asg_markup_percent Pa_Project_Assignments.Markup_Percent%TYPE;
527: l_asg_bill_rate_override Pa_Project_Assignments.Bill_Rate_Override%TYPE;
528: l_asg_bill_rate_curr_override Pa_Project_Assignments.BILL_RATE_CURR_OVERRIDE%TYPE;

Line 525: l_asg_project_role_id Pa_Project_Assignments.Project_Role_Id%TYPE;

521: /* Project Assignment info */
522:
523: l_asg_fcst_job_id Pa_Project_Assignments.Fcst_Job_Id%TYPE;
524: l_asg_fcst_job_group_id Pa_Project_Assignments.Fcst_Job_Group_Id%TYPE;
525: l_asg_project_role_id Pa_Project_Assignments.Project_Role_Id%TYPE;
526: l_asg_markup_percent Pa_Project_Assignments.Markup_Percent%TYPE;
527: l_asg_bill_rate_override Pa_Project_Assignments.Bill_Rate_Override%TYPE;
528: l_asg_bill_rate_curr_override Pa_Project_Assignments.BILL_RATE_CURR_OVERRIDE%TYPE;
529: l_asg_markup_percent_override Pa_Project_Assignments.MARKUP_PERCENT_OVERRIDE%TYPE;

Line 526: l_asg_markup_percent Pa_Project_Assignments.Markup_Percent%TYPE;

522:
523: l_asg_fcst_job_id Pa_Project_Assignments.Fcst_Job_Id%TYPE;
524: l_asg_fcst_job_group_id Pa_Project_Assignments.Fcst_Job_Group_Id%TYPE;
525: l_asg_project_role_id Pa_Project_Assignments.Project_Role_Id%TYPE;
526: l_asg_markup_percent Pa_Project_Assignments.Markup_Percent%TYPE;
527: l_asg_bill_rate_override Pa_Project_Assignments.Bill_Rate_Override%TYPE;
528: l_asg_bill_rate_curr_override Pa_Project_Assignments.BILL_RATE_CURR_OVERRIDE%TYPE;
529: l_asg_markup_percent_override Pa_Project_Assignments.MARKUP_PERCENT_OVERRIDE%TYPE;
530: l_asg_tp_rate_override Pa_Project_Assignments.TP_RATE_OVERRIDE%TYPE;

Line 527: l_asg_bill_rate_override Pa_Project_Assignments.Bill_Rate_Override%TYPE;

523: l_asg_fcst_job_id Pa_Project_Assignments.Fcst_Job_Id%TYPE;
524: l_asg_fcst_job_group_id Pa_Project_Assignments.Fcst_Job_Group_Id%TYPE;
525: l_asg_project_role_id Pa_Project_Assignments.Project_Role_Id%TYPE;
526: l_asg_markup_percent Pa_Project_Assignments.Markup_Percent%TYPE;
527: l_asg_bill_rate_override Pa_Project_Assignments.Bill_Rate_Override%TYPE;
528: l_asg_bill_rate_curr_override Pa_Project_Assignments.BILL_RATE_CURR_OVERRIDE%TYPE;
529: l_asg_markup_percent_override Pa_Project_Assignments.MARKUP_PERCENT_OVERRIDE%TYPE;
530: l_asg_tp_rate_override Pa_Project_Assignments.TP_RATE_OVERRIDE%TYPE;
531: l_asg_tp_curr_override Pa_Project_Assignments.TP_CURRENCY_OVERRIDE%TYPE;

Line 528: l_asg_bill_rate_curr_override Pa_Project_Assignments.BILL_RATE_CURR_OVERRIDE%TYPE;

524: l_asg_fcst_job_group_id Pa_Project_Assignments.Fcst_Job_Group_Id%TYPE;
525: l_asg_project_role_id Pa_Project_Assignments.Project_Role_Id%TYPE;
526: l_asg_markup_percent Pa_Project_Assignments.Markup_Percent%TYPE;
527: l_asg_bill_rate_override Pa_Project_Assignments.Bill_Rate_Override%TYPE;
528: l_asg_bill_rate_curr_override Pa_Project_Assignments.BILL_RATE_CURR_OVERRIDE%TYPE;
529: l_asg_markup_percent_override Pa_Project_Assignments.MARKUP_PERCENT_OVERRIDE%TYPE;
530: l_asg_tp_rate_override Pa_Project_Assignments.TP_RATE_OVERRIDE%TYPE;
531: l_asg_tp_curr_override Pa_Project_Assignments.TP_CURRENCY_OVERRIDE%TYPE;
532: l_asg_tp_calc_base_code_ovr Pa_Project_Assignments.TP_CALC_BASE_CODE_OVERRIDE%TYPE;

Line 529: l_asg_markup_percent_override Pa_Project_Assignments.MARKUP_PERCENT_OVERRIDE%TYPE;

525: l_asg_project_role_id Pa_Project_Assignments.Project_Role_Id%TYPE;
526: l_asg_markup_percent Pa_Project_Assignments.Markup_Percent%TYPE;
527: l_asg_bill_rate_override Pa_Project_Assignments.Bill_Rate_Override%TYPE;
528: l_asg_bill_rate_curr_override Pa_Project_Assignments.BILL_RATE_CURR_OVERRIDE%TYPE;
529: l_asg_markup_percent_override Pa_Project_Assignments.MARKUP_PERCENT_OVERRIDE%TYPE;
530: l_asg_tp_rate_override Pa_Project_Assignments.TP_RATE_OVERRIDE%TYPE;
531: l_asg_tp_curr_override Pa_Project_Assignments.TP_CURRENCY_OVERRIDE%TYPE;
532: l_asg_tp_calc_base_code_ovr Pa_Project_Assignments.TP_CALC_BASE_CODE_OVERRIDE%TYPE;
533: l_asg_tp_percent_applied_ovr Pa_Project_Assignments.TP_PERCENT_APPLIED_OVERRIDE%TYPE;

Line 530: l_asg_tp_rate_override Pa_Project_Assignments.TP_RATE_OVERRIDE%TYPE;

526: l_asg_markup_percent Pa_Project_Assignments.Markup_Percent%TYPE;
527: l_asg_bill_rate_override Pa_Project_Assignments.Bill_Rate_Override%TYPE;
528: l_asg_bill_rate_curr_override Pa_Project_Assignments.BILL_RATE_CURR_OVERRIDE%TYPE;
529: l_asg_markup_percent_override Pa_Project_Assignments.MARKUP_PERCENT_OVERRIDE%TYPE;
530: l_asg_tp_rate_override Pa_Project_Assignments.TP_RATE_OVERRIDE%TYPE;
531: l_asg_tp_curr_override Pa_Project_Assignments.TP_CURRENCY_OVERRIDE%TYPE;
532: l_asg_tp_calc_base_code_ovr Pa_Project_Assignments.TP_CALC_BASE_CODE_OVERRIDE%TYPE;
533: l_asg_tp_percent_applied_ovr Pa_Project_Assignments.TP_PERCENT_APPLIED_OVERRIDE%TYPE;
534: l_prj_assignment_type PA_PROJECT_ASSIGNMENTS.ASSIGNMENT_TYPE%TYPE;

Line 531: l_asg_tp_curr_override Pa_Project_Assignments.TP_CURRENCY_OVERRIDE%TYPE;

527: l_asg_bill_rate_override Pa_Project_Assignments.Bill_Rate_Override%TYPE;
528: l_asg_bill_rate_curr_override Pa_Project_Assignments.BILL_RATE_CURR_OVERRIDE%TYPE;
529: l_asg_markup_percent_override Pa_Project_Assignments.MARKUP_PERCENT_OVERRIDE%TYPE;
530: l_asg_tp_rate_override Pa_Project_Assignments.TP_RATE_OVERRIDE%TYPE;
531: l_asg_tp_curr_override Pa_Project_Assignments.TP_CURRENCY_OVERRIDE%TYPE;
532: l_asg_tp_calc_base_code_ovr Pa_Project_Assignments.TP_CALC_BASE_CODE_OVERRIDE%TYPE;
533: l_asg_tp_percent_applied_ovr Pa_Project_Assignments.TP_PERCENT_APPLIED_OVERRIDE%TYPE;
534: l_prj_assignment_type PA_PROJECT_ASSIGNMENTS.ASSIGNMENT_TYPE%TYPE;
535: l_prj_status_code PA_PROJECT_ASSIGNMENTS.STATUS_CODE%TYPE;

Line 532: l_asg_tp_calc_base_code_ovr Pa_Project_Assignments.TP_CALC_BASE_CODE_OVERRIDE%TYPE;

528: l_asg_bill_rate_curr_override Pa_Project_Assignments.BILL_RATE_CURR_OVERRIDE%TYPE;
529: l_asg_markup_percent_override Pa_Project_Assignments.MARKUP_PERCENT_OVERRIDE%TYPE;
530: l_asg_tp_rate_override Pa_Project_Assignments.TP_RATE_OVERRIDE%TYPE;
531: l_asg_tp_curr_override Pa_Project_Assignments.TP_CURRENCY_OVERRIDE%TYPE;
532: l_asg_tp_calc_base_code_ovr Pa_Project_Assignments.TP_CALC_BASE_CODE_OVERRIDE%TYPE;
533: l_asg_tp_percent_applied_ovr Pa_Project_Assignments.TP_PERCENT_APPLIED_OVERRIDE%TYPE;
534: l_prj_assignment_type PA_PROJECT_ASSIGNMENTS.ASSIGNMENT_TYPE%TYPE;
535: l_prj_status_code PA_PROJECT_ASSIGNMENTS.STATUS_CODE%TYPE;
536:

Line 533: l_asg_tp_percent_applied_ovr Pa_Project_Assignments.TP_PERCENT_APPLIED_OVERRIDE%TYPE;

529: l_asg_markup_percent_override Pa_Project_Assignments.MARKUP_PERCENT_OVERRIDE%TYPE;
530: l_asg_tp_rate_override Pa_Project_Assignments.TP_RATE_OVERRIDE%TYPE;
531: l_asg_tp_curr_override Pa_Project_Assignments.TP_CURRENCY_OVERRIDE%TYPE;
532: l_asg_tp_calc_base_code_ovr Pa_Project_Assignments.TP_CALC_BASE_CODE_OVERRIDE%TYPE;
533: l_asg_tp_percent_applied_ovr Pa_Project_Assignments.TP_PERCENT_APPLIED_OVERRIDE%TYPE;
534: l_prj_assignment_type PA_PROJECT_ASSIGNMENTS.ASSIGNMENT_TYPE%TYPE;
535: l_prj_status_code PA_PROJECT_ASSIGNMENTS.STATUS_CODE%TYPE;
536:
537: /* Project Assignments PL SQL Tables */

Line 534: l_prj_assignment_type PA_PROJECT_ASSIGNMENTS.ASSIGNMENT_TYPE%TYPE;

530: l_asg_tp_rate_override Pa_Project_Assignments.TP_RATE_OVERRIDE%TYPE;
531: l_asg_tp_curr_override Pa_Project_Assignments.TP_CURRENCY_OVERRIDE%TYPE;
532: l_asg_tp_calc_base_code_ovr Pa_Project_Assignments.TP_CALC_BASE_CODE_OVERRIDE%TYPE;
533: l_asg_tp_percent_applied_ovr Pa_Project_Assignments.TP_PERCENT_APPLIED_OVERRIDE%TYPE;
534: l_prj_assignment_type PA_PROJECT_ASSIGNMENTS.ASSIGNMENT_TYPE%TYPE;
535: l_prj_status_code PA_PROJECT_ASSIGNMENTS.STATUS_CODE%TYPE;
536:
537: /* Project Assignments PL SQL Tables */
538:

Line 535: l_prj_status_code PA_PROJECT_ASSIGNMENTS.STATUS_CODE%TYPE;

531: l_asg_tp_curr_override Pa_Project_Assignments.TP_CURRENCY_OVERRIDE%TYPE;
532: l_asg_tp_calc_base_code_ovr Pa_Project_Assignments.TP_CALC_BASE_CODE_OVERRIDE%TYPE;
533: l_asg_tp_percent_applied_ovr Pa_Project_Assignments.TP_PERCENT_APPLIED_OVERRIDE%TYPE;
534: l_prj_assignment_type PA_PROJECT_ASSIGNMENTS.ASSIGNMENT_TYPE%TYPE;
535: l_prj_status_code PA_PROJECT_ASSIGNMENTS.STATUS_CODE%TYPE;
536:
537: /* Project Assignments PL SQL Tables */
538:
539: l_asg_fcst_jobid_tab PA_PLSQL_DATATYPES.IdTabTyp;

Line 822: l_prev_rt_fcst_jobid Pa_Project_Assignments.Fcst_Job_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;
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;

Line 823: l_prev_rt_fcst_jobgroupid Pa_Project_Assignments.Fcst_Job_Group_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;
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;

Line 914: l_assignment_id pa_project_assignments.assignment_id%TYPE;

910: l_process_fis_flag VARCHAR2(1);
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);

Line 1703: FROM PA_PROJECT_ASSIGNMENTS P

1699: l_asg_tp_calc_base_code_ovr,
1700: l_asg_tp_percent_applied_ovr,
1701: l_prj_assignment_type,
1702: l_prj_status_code
1703: FROM PA_PROJECT_ASSIGNMENTS P
1704: WHERE P.Assignment_Id = l_prev_asg_id;
1705: l_asg_fcst_jobid_tab(i) := l_asg_fcst_job_id;
1706: l_asg_fcst_jobgroupid_tab(i) := l_asg_fcst_job_group_id;
1707: EXCEPTION

Line 4249: /* Bug 3051110 - Code added for populating two columns in pa_project_assignments table

4245: COMMIT;
4246: END LOOP;
4247: /* main loop for bulk fetch from FIs */
4248:
4249: /* Bug 3051110 - Code added for populating two columns in pa_project_assignments table
4250: TP Enhancement */
4251:
4252: IF p_debug_mode = 'Y' THEN
4253: pa_debug.write('Pa_Fi_Amt_Calc_Pkg.Calculate_Fcst_Amounts', 'Start of populating TP Rate columns', 3);