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_CC_TRANSFER_PRICE dependencies on PA_PROJECT_ASSIGNMENTS

Line 1072: pa_project_assignments

1068: l_tp_currency_ovrd,
1069: l_tp_calc_base_code_ovrd,
1070: l_tp_percent_applied_ovrd
1071: from
1072: pa_project_assignments
1073: where
1074: assignment_id = p_assignment_id(i)
1075: and p_expenditure_item_date(i) between
1076: start_date and end_date ;

Line 4777: ( p_assignment_id IN pa_project_assignments.assignment_id%TYPE

4773:
4774: /* Bug 3051110-Added procedure Get_Initial_Transfer_Price for TP Enhancement. */
4775:
4776: PROCEDURE Get_Initial_Transfer_Price
4777: ( p_assignment_id IN pa_project_assignments.assignment_id%TYPE
4778: ,p_start_date IN pa_project_assignments.start_date%TYPE
4779: ,p_debug_mode IN VARCHAR2 DEFAULT 'N'
4780: ,x_transfer_price_rate OUT NOCOPY pa_project_assignments.transfer_price_rate%TYPE /*file.sql.39*/
4781: ,x_transfer_pr_rate_curr OUT NOCOPY pa_project_assignments.transfer_pr_rate_curr%TYPE /*file.sql.39*/

Line 4778: ,p_start_date IN pa_project_assignments.start_date%TYPE

4774: /* Bug 3051110-Added procedure Get_Initial_Transfer_Price for TP Enhancement. */
4775:
4776: PROCEDURE Get_Initial_Transfer_Price
4777: ( p_assignment_id IN pa_project_assignments.assignment_id%TYPE
4778: ,p_start_date IN pa_project_assignments.start_date%TYPE
4779: ,p_debug_mode IN VARCHAR2 DEFAULT 'N'
4780: ,x_transfer_price_rate OUT NOCOPY pa_project_assignments.transfer_price_rate%TYPE /*file.sql.39*/
4781: ,x_transfer_pr_rate_curr OUT NOCOPY pa_project_assignments.transfer_pr_rate_curr%TYPE /*file.sql.39*/
4782: ,x_return_status OUT NOCOPY VARCHAR2 /*file.sql.39*/

Line 4780: ,x_transfer_price_rate OUT NOCOPY pa_project_assignments.transfer_price_rate%TYPE /file.sql.39/

4776: PROCEDURE Get_Initial_Transfer_Price
4777: ( p_assignment_id IN pa_project_assignments.assignment_id%TYPE
4778: ,p_start_date IN pa_project_assignments.start_date%TYPE
4779: ,p_debug_mode IN VARCHAR2 DEFAULT 'N'
4780: ,x_transfer_price_rate OUT NOCOPY pa_project_assignments.transfer_price_rate%TYPE /*file.sql.39*/
4781: ,x_transfer_pr_rate_curr OUT NOCOPY pa_project_assignments.transfer_pr_rate_curr%TYPE /*file.sql.39*/
4782: ,x_return_status OUT NOCOPY VARCHAR2 /*file.sql.39*/
4783: ,x_msg_data OUT NOCOPY VARCHAR2 /*file.sql.39*/
4784: ,x_msg_count OUT NOCOPY Number /*file.sql.39*/

Line 4781: ,x_transfer_pr_rate_curr OUT NOCOPY pa_project_assignments.transfer_pr_rate_curr%TYPE /file.sql.39/

4777: ( p_assignment_id IN pa_project_assignments.assignment_id%TYPE
4778: ,p_start_date IN pa_project_assignments.start_date%TYPE
4779: ,p_debug_mode IN VARCHAR2 DEFAULT 'N'
4780: ,x_transfer_price_rate OUT NOCOPY pa_project_assignments.transfer_price_rate%TYPE /*file.sql.39*/
4781: ,x_transfer_pr_rate_curr OUT NOCOPY pa_project_assignments.transfer_pr_rate_curr%TYPE /*file.sql.39*/
4782: ,x_return_status OUT NOCOPY VARCHAR2 /*file.sql.39*/
4783: ,x_msg_data OUT NOCOPY VARCHAR2 /*file.sql.39*/
4784: ,x_msg_count OUT NOCOPY Number /*file.sql.39*/
4785: )

Line 4788: CURSOR Cur_Forecast_Items(c_assignment_id pa_project_assignments.assignment_id%TYPE,

4784: ,x_msg_count OUT NOCOPY Number /*file.sql.39*/
4785: )
4786: IS
4787:
4788: CURSOR Cur_Forecast_Items(c_assignment_id pa_project_assignments.assignment_id%TYPE,
4789: c_start_date pa_project_assignments.start_date%TYPE) IS SELECT
4790: FI.forecast_item_id,
4791: FI.forecast_item_type,
4792: FI.EXPENDITURE_ORG_ID,

Line 4789: c_start_date pa_project_assignments.start_date%TYPE) IS SELECT

4785: )
4786: IS
4787:
4788: CURSOR Cur_Forecast_Items(c_assignment_id pa_project_assignments.assignment_id%TYPE,
4789: c_start_date pa_project_assignments.start_date%TYPE) IS SELECT
4790: FI.forecast_item_id,
4791: FI.forecast_item_type,
4792: FI.EXPENDITURE_ORG_ID,
4793: FI.EXPENDITURE_ORGANIZATION_ID,

Line 4867: Cursor Proj_Assignment(c_assignment_id pa_project_assignments.assignment_id%type) IS

4863: LABOR_SCH_TYPE
4864: FROM Pa_Projects_All P
4865: WHERE P.Project_Id = c_project_id;
4866:
4867: Cursor Proj_Assignment(c_assignment_id pa_project_assignments.assignment_id%type) IS
4868: SELECT Fcst_Job_Id,
4869: Fcst_Job_Group_Id,
4870: Project_Role_Id,
4871: ASSIGNMENT_TYPE,

Line 4874: PA_PROJECT_ASSIGNMENTS PA

4870: Project_Role_Id,
4871: ASSIGNMENT_TYPE,
4872: STATUS_CODE
4873: FROM
4874: PA_PROJECT_ASSIGNMENTS PA
4875: WHERE PA.Assignment_id= c_assignment_id;
4876:
4877: l_calling_mode VARCHAR2(20);
4878:

Line 4950: l_asg_fcst_job_id Pa_Project_Assignments.Fcst_Job_Id%TYPE;

4946: l_fcst_opt_jobcostrate_sch_id NUMBER;
4947:
4948: /* Project Assignment Info */
4949:
4950: l_asg_fcst_job_id Pa_Project_Assignments.Fcst_Job_Id%TYPE;
4951: l_asg_fcst_job_group_id Pa_Project_Assignments.Fcst_Job_Group_Id%TYPE;
4952: l_asg_project_role_id Pa_Project_Assignments.Project_Role_Id%TYPE;
4953: l_prj_assignment_type PA_PROJECT_ASSIGNMENTS.ASSIGNMENT_TYPE%TYPE;
4954: l_prj_status_code PA_PROJECT_ASSIGNMENTS.STATUS_CODE%TYPE;

Line 4951: l_asg_fcst_job_group_id Pa_Project_Assignments.Fcst_Job_Group_Id%TYPE;

4947:
4948: /* Project Assignment Info */
4949:
4950: l_asg_fcst_job_id Pa_Project_Assignments.Fcst_Job_Id%TYPE;
4951: l_asg_fcst_job_group_id Pa_Project_Assignments.Fcst_Job_Group_Id%TYPE;
4952: l_asg_project_role_id Pa_Project_Assignments.Project_Role_Id%TYPE;
4953: l_prj_assignment_type PA_PROJECT_ASSIGNMENTS.ASSIGNMENT_TYPE%TYPE;
4954: l_prj_status_code PA_PROJECT_ASSIGNMENTS.STATUS_CODE%TYPE;
4955:

Line 4952: l_asg_project_role_id Pa_Project_Assignments.Project_Role_Id%TYPE;

4948: /* Project Assignment Info */
4949:
4950: l_asg_fcst_job_id Pa_Project_Assignments.Fcst_Job_Id%TYPE;
4951: l_asg_fcst_job_group_id Pa_Project_Assignments.Fcst_Job_Group_Id%TYPE;
4952: l_asg_project_role_id Pa_Project_Assignments.Project_Role_Id%TYPE;
4953: l_prj_assignment_type PA_PROJECT_ASSIGNMENTS.ASSIGNMENT_TYPE%TYPE;
4954: l_prj_status_code PA_PROJECT_ASSIGNMENTS.STATUS_CODE%TYPE;
4955:
4956: l_projfunc_rev_rt_dt_code_tab PA_PLSQL_DATATYPES.Char30TabTyp;

Line 4953: l_prj_assignment_type PA_PROJECT_ASSIGNMENTS.ASSIGNMENT_TYPE%TYPE;

4949:
4950: l_asg_fcst_job_id Pa_Project_Assignments.Fcst_Job_Id%TYPE;
4951: l_asg_fcst_job_group_id Pa_Project_Assignments.Fcst_Job_Group_Id%TYPE;
4952: l_asg_project_role_id Pa_Project_Assignments.Project_Role_Id%TYPE;
4953: l_prj_assignment_type PA_PROJECT_ASSIGNMENTS.ASSIGNMENT_TYPE%TYPE;
4954: l_prj_status_code PA_PROJECT_ASSIGNMENTS.STATUS_CODE%TYPE;
4955:
4956: l_projfunc_rev_rt_dt_code_tab PA_PLSQL_DATATYPES.Char30TabTyp;
4957: l_projfunc_rev_rt_date_tab PA_PLSQL_DATATYPES.DateTabTyp;

Line 4954: l_prj_status_code PA_PROJECT_ASSIGNMENTS.STATUS_CODE%TYPE;

4950: l_asg_fcst_job_id Pa_Project_Assignments.Fcst_Job_Id%TYPE;
4951: l_asg_fcst_job_group_id Pa_Project_Assignments.Fcst_Job_Group_Id%TYPE;
4952: l_asg_project_role_id Pa_Project_Assignments.Project_Role_Id%TYPE;
4953: l_prj_assignment_type PA_PROJECT_ASSIGNMENTS.ASSIGNMENT_TYPE%TYPE;
4954: l_prj_status_code PA_PROJECT_ASSIGNMENTS.STATUS_CODE%TYPE;
4955:
4956: l_projfunc_rev_rt_dt_code_tab PA_PLSQL_DATATYPES.Char30TabTyp;
4957: l_projfunc_rev_rt_date_tab PA_PLSQL_DATATYPES.DateTabTyp;
4958: l_projfunc_rev_rt_type_tab PA_PLSQL_DATATYPES.Char30TabTyp;