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 4681: ( p_assignment_id IN pa_project_assignments.assignment_id%TYPE

4677:
4678: /* Bug 3051110-Added procedure Get_Initial_Transfer_Price for TP Enhancement. */
4679:
4680: PROCEDURE Get_Initial_Transfer_Price
4681: ( p_assignment_id IN pa_project_assignments.assignment_id%TYPE
4682: ,p_start_date IN pa_project_assignments.start_date%TYPE
4683: ,p_debug_mode IN VARCHAR2 DEFAULT 'N'
4684: ,x_transfer_price_rate OUT NOCOPY pa_project_assignments.transfer_price_rate%TYPE /*file.sql.39*/
4685: ,x_transfer_pr_rate_curr OUT NOCOPY pa_project_assignments.transfer_pr_rate_curr%TYPE /*file.sql.39*/

Line 4682: ,p_start_date IN pa_project_assignments.start_date%TYPE

4678: /* Bug 3051110-Added procedure Get_Initial_Transfer_Price for TP Enhancement. */
4679:
4680: PROCEDURE Get_Initial_Transfer_Price
4681: ( p_assignment_id IN pa_project_assignments.assignment_id%TYPE
4682: ,p_start_date IN pa_project_assignments.start_date%TYPE
4683: ,p_debug_mode IN VARCHAR2 DEFAULT 'N'
4684: ,x_transfer_price_rate OUT NOCOPY pa_project_assignments.transfer_price_rate%TYPE /*file.sql.39*/
4685: ,x_transfer_pr_rate_curr OUT NOCOPY pa_project_assignments.transfer_pr_rate_curr%TYPE /*file.sql.39*/
4686: ,x_return_status OUT NOCOPY VARCHAR2 /*file.sql.39*/

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

4680: PROCEDURE Get_Initial_Transfer_Price
4681: ( p_assignment_id IN pa_project_assignments.assignment_id%TYPE
4682: ,p_start_date IN pa_project_assignments.start_date%TYPE
4683: ,p_debug_mode IN VARCHAR2 DEFAULT 'N'
4684: ,x_transfer_price_rate OUT NOCOPY pa_project_assignments.transfer_price_rate%TYPE /*file.sql.39*/
4685: ,x_transfer_pr_rate_curr OUT NOCOPY pa_project_assignments.transfer_pr_rate_curr%TYPE /*file.sql.39*/
4686: ,x_return_status OUT NOCOPY VARCHAR2 /*file.sql.39*/
4687: ,x_msg_data OUT NOCOPY VARCHAR2 /*file.sql.39*/
4688: ,x_msg_count OUT NOCOPY Number /*file.sql.39*/

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

4681: ( p_assignment_id IN pa_project_assignments.assignment_id%TYPE
4682: ,p_start_date IN pa_project_assignments.start_date%TYPE
4683: ,p_debug_mode IN VARCHAR2 DEFAULT 'N'
4684: ,x_transfer_price_rate OUT NOCOPY pa_project_assignments.transfer_price_rate%TYPE /*file.sql.39*/
4685: ,x_transfer_pr_rate_curr OUT NOCOPY pa_project_assignments.transfer_pr_rate_curr%TYPE /*file.sql.39*/
4686: ,x_return_status OUT NOCOPY VARCHAR2 /*file.sql.39*/
4687: ,x_msg_data OUT NOCOPY VARCHAR2 /*file.sql.39*/
4688: ,x_msg_count OUT NOCOPY Number /*file.sql.39*/
4689: )

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

4688: ,x_msg_count OUT NOCOPY Number /*file.sql.39*/
4689: )
4690: IS
4691:
4692: CURSOR Cur_Forecast_Items(c_assignment_id pa_project_assignments.assignment_id%TYPE,
4693: c_start_date pa_project_assignments.start_date%TYPE) IS SELECT
4694: FI.forecast_item_id,
4695: FI.forecast_item_type,
4696: FI.EXPENDITURE_ORG_ID,

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

4689: )
4690: IS
4691:
4692: CURSOR Cur_Forecast_Items(c_assignment_id pa_project_assignments.assignment_id%TYPE,
4693: c_start_date pa_project_assignments.start_date%TYPE) IS SELECT
4694: FI.forecast_item_id,
4695: FI.forecast_item_type,
4696: FI.EXPENDITURE_ORG_ID,
4697: FI.EXPENDITURE_ORGANIZATION_ID,

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

4767: LABOR_SCH_TYPE
4768: FROM Pa_Projects_All P
4769: WHERE P.Project_Id = c_project_id;
4770:
4771: Cursor Proj_Assignment(c_assignment_id pa_project_assignments.assignment_id%type) IS
4772: SELECT Fcst_Job_Id,
4773: Fcst_Job_Group_Id,
4774: Project_Role_Id,
4775: ASSIGNMENT_TYPE,

Line 4778: PA_PROJECT_ASSIGNMENTS PA

4774: Project_Role_Id,
4775: ASSIGNMENT_TYPE,
4776: STATUS_CODE
4777: FROM
4778: PA_PROJECT_ASSIGNMENTS PA
4779: WHERE PA.Assignment_id= c_assignment_id;
4780:
4781: l_calling_mode VARCHAR2(20);
4782:

Line 4854: l_asg_fcst_job_id Pa_Project_Assignments.Fcst_Job_Id%TYPE;

4850: l_fcst_opt_jobcostrate_sch_id NUMBER;
4851:
4852: /* Project Assignment Info */
4853:
4854: l_asg_fcst_job_id Pa_Project_Assignments.Fcst_Job_Id%TYPE;
4855: l_asg_fcst_job_group_id Pa_Project_Assignments.Fcst_Job_Group_Id%TYPE;
4856: l_asg_project_role_id Pa_Project_Assignments.Project_Role_Id%TYPE;
4857: l_prj_assignment_type PA_PROJECT_ASSIGNMENTS.ASSIGNMENT_TYPE%TYPE;
4858: l_prj_status_code PA_PROJECT_ASSIGNMENTS.STATUS_CODE%TYPE;

Line 4855: l_asg_fcst_job_group_id Pa_Project_Assignments.Fcst_Job_Group_Id%TYPE;

4851:
4852: /* Project Assignment Info */
4853:
4854: l_asg_fcst_job_id Pa_Project_Assignments.Fcst_Job_Id%TYPE;
4855: l_asg_fcst_job_group_id Pa_Project_Assignments.Fcst_Job_Group_Id%TYPE;
4856: l_asg_project_role_id Pa_Project_Assignments.Project_Role_Id%TYPE;
4857: l_prj_assignment_type PA_PROJECT_ASSIGNMENTS.ASSIGNMENT_TYPE%TYPE;
4858: l_prj_status_code PA_PROJECT_ASSIGNMENTS.STATUS_CODE%TYPE;
4859:

Line 4856: l_asg_project_role_id Pa_Project_Assignments.Project_Role_Id%TYPE;

4852: /* Project Assignment Info */
4853:
4854: l_asg_fcst_job_id Pa_Project_Assignments.Fcst_Job_Id%TYPE;
4855: l_asg_fcst_job_group_id Pa_Project_Assignments.Fcst_Job_Group_Id%TYPE;
4856: l_asg_project_role_id Pa_Project_Assignments.Project_Role_Id%TYPE;
4857: l_prj_assignment_type PA_PROJECT_ASSIGNMENTS.ASSIGNMENT_TYPE%TYPE;
4858: l_prj_status_code PA_PROJECT_ASSIGNMENTS.STATUS_CODE%TYPE;
4859:
4860: l_projfunc_rev_rt_dt_code_tab PA_PLSQL_DATATYPES.Char30TabTyp;

Line 4857: l_prj_assignment_type PA_PROJECT_ASSIGNMENTS.ASSIGNMENT_TYPE%TYPE;

4853:
4854: l_asg_fcst_job_id Pa_Project_Assignments.Fcst_Job_Id%TYPE;
4855: l_asg_fcst_job_group_id Pa_Project_Assignments.Fcst_Job_Group_Id%TYPE;
4856: l_asg_project_role_id Pa_Project_Assignments.Project_Role_Id%TYPE;
4857: l_prj_assignment_type PA_PROJECT_ASSIGNMENTS.ASSIGNMENT_TYPE%TYPE;
4858: l_prj_status_code PA_PROJECT_ASSIGNMENTS.STATUS_CODE%TYPE;
4859:
4860: l_projfunc_rev_rt_dt_code_tab PA_PLSQL_DATATYPES.Char30TabTyp;
4861: l_projfunc_rev_rt_date_tab PA_PLSQL_DATATYPES.DateTabTyp;

Line 4858: l_prj_status_code PA_PROJECT_ASSIGNMENTS.STATUS_CODE%TYPE;

4854: l_asg_fcst_job_id Pa_Project_Assignments.Fcst_Job_Id%TYPE;
4855: l_asg_fcst_job_group_id Pa_Project_Assignments.Fcst_Job_Group_Id%TYPE;
4856: l_asg_project_role_id Pa_Project_Assignments.Project_Role_Id%TYPE;
4857: l_prj_assignment_type PA_PROJECT_ASSIGNMENTS.ASSIGNMENT_TYPE%TYPE;
4858: l_prj_status_code PA_PROJECT_ASSIGNMENTS.STATUS_CODE%TYPE;
4859:
4860: l_projfunc_rev_rt_dt_code_tab PA_PLSQL_DATATYPES.Char30TabTyp;
4861: l_projfunc_rev_rt_date_tab PA_PLSQL_DATATYPES.DateTabTyp;
4862: l_projfunc_rev_rt_type_tab PA_PLSQL_DATATYPES.Char30TabTyp;