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_FP_GEN_FCST_AMT_PUB3 dependencies on PA_RESOURCE_ASSIGNMENTS

Line 28: (P_SRC_RES_ASG_ID IN PA_RESOURCE_ASSIGNMENTS.RESOURCE_ASSIGNMENT_ID%TYPE,

24: convert back from PC to TC.
25: */
26:
27: PROCEDURE GET_ETC_REMAIN_BDGT_AMTS
28: (P_SRC_RES_ASG_ID IN PA_RESOURCE_ASSIGNMENTS.RESOURCE_ASSIGNMENT_ID%TYPE,
29: P_TGT_RES_ASG_ID IN PA_RESOURCE_ASSIGNMENTS.RESOURCE_ASSIGNMENT_ID%TYPE,
30: P_FP_COLS_SRC_REC IN PA_FP_GEN_AMOUNT_UTILS.FP_COLS,
31: P_FP_COLS_TGT_REC IN PA_FP_GEN_AMOUNT_UTILS.FP_COLS,
32: P_TASK_ID IN PA_TASKS.TASK_ID%TYPE,

Line 29: P_TGT_RES_ASG_ID IN PA_RESOURCE_ASSIGNMENTS.RESOURCE_ASSIGNMENT_ID%TYPE,

25: */
26:
27: PROCEDURE GET_ETC_REMAIN_BDGT_AMTS
28: (P_SRC_RES_ASG_ID IN PA_RESOURCE_ASSIGNMENTS.RESOURCE_ASSIGNMENT_ID%TYPE,
29: P_TGT_RES_ASG_ID IN PA_RESOURCE_ASSIGNMENTS.RESOURCE_ASSIGNMENT_ID%TYPE,
30: P_FP_COLS_SRC_REC IN PA_FP_GEN_AMOUNT_UTILS.FP_COLS,
31: P_FP_COLS_TGT_REC IN PA_FP_GEN_AMOUNT_UTILS.FP_COLS,
32: P_TASK_ID IN PA_TASKS.TASK_ID%TYPE,
33: P_RESOURCE_LIST_MEMBER_ID IN PA_RESOURCE_LIST_MEMBERS.RESOURCE_LIST_MEMBER_ID%TYPE,

Line 139: l_planning_start_date pa_resource_assignments.planning_start_date%type;

135: l_transaction_source_code VARCHAR2(30);
136:
137: /*For txn currency conversion*/
138: l_task_id pa_tasks.task_id%type;
139: l_planning_start_date pa_resource_assignments.planning_start_date%type;
140: lx_acc_rate_date DATE;
141: lx_acct_rate_type VARCHAR2(50);
142: lx_acct_exch_rate NUMBER;
143: lx_acct_raw_cost NUMBER;

Line 181: FROM pa_resource_assignments

177:
178: IF nvl(p_tgt_res_asg_id,0) > 0 THEN
179: SELECT rate_based_flag
180: INTO l_rate_based_flag
181: FROM pa_resource_assignments
182: WHERE resource_assignment_id = p_tgt_res_asg_id;
183: ELSE
184: l_rate_based_flag:='N';
185: END IF;

Line 876: FROM pa_resource_assignments

872: SELECT task_id,
873: planning_start_date
874: INTO l_task_id,
875: l_planning_start_date
876: FROM pa_resource_assignments
877: WHERE resource_assignment_id = p_src_res_asg_id;
878: EXCEPTION
879: WHEN NO_DATA_FOUND THEN
880: l_task_id := NULL;

Line 1100: (P_TGT_RES_ASG_ID IN PA_RESOURCE_ASSIGNMENTS.RESOURCE_ASSIGNMENT_ID%TYPE,

1096: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1097: END GET_ETC_REMAIN_BDGT_AMTS;
1098:
1099: PROCEDURE CHECK_SINGLE_CURRENCY
1100: (P_TGT_RES_ASG_ID IN PA_RESOURCE_ASSIGNMENTS.RESOURCE_ASSIGNMENT_ID%TYPE,
1101: X_SINGLE_CURRENCY_FLAG OUT NOCOPY VARCHAR2,
1102: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
1103: X_MSG_COUNT OUT NOCOPY NUMBER,
1104: X_MSG_DATA OUT NOCOPY VARCHAR2)

Line 1305: l_planning_start_date pa_resource_assignments.planning_start_date%type;

1301: l_transaction_source_code VARCHAR2(30);
1302:
1303: /*For txn currency conversion*/
1304: l_task_id pa_tasks.task_id%type;
1305: l_planning_start_date pa_resource_assignments.planning_start_date%type;
1306: lx_acc_rate_date DATE;
1307: lx_acct_rate_type VARCHAR2(50);
1308: lx_acct_exch_rate NUMBER;
1309: lx_acct_raw_cost NUMBER;

Line 1589: FROM pa_resource_assignments

1585:
1586: IF nvl(l_tgt_res_asg_id_tab(i),0) > 0 THEN
1587: SELECT rate_based_flag
1588: INTO l_rate_based_flag
1589: FROM pa_resource_assignments
1590: WHERE resource_assignment_id = l_tgt_res_asg_id_tab(i);
1591: ELSE
1592: l_rate_based_flag:='N';
1593: END IF;

Line 2108: FROM pa_resource_assignments

2104: SELECT task_id,
2105: planning_start_date
2106: INTO l_task_id,
2107: l_planning_start_date
2108: FROM pa_resource_assignments
2109: WHERE resource_assignment_id = l_tgt_res_asg_id_tab(i);
2110: EXCEPTION
2111: WHEN NO_DATA_FOUND THEN
2112: l_task_id := NULL;

Line 2445: l_planning_start_date pa_resource_assignments.planning_start_date%type;

2441: l_transaction_source_code VARCHAR2(30);
2442:
2443: /*For txn currency conversion*/
2444: l_task_id pa_tasks.task_id%type;
2445: l_planning_start_date pa_resource_assignments.planning_start_date%type;
2446: lx_acc_rate_date DATE;
2447: lx_acct_rate_type VARCHAR2(50);
2448: lx_acct_exch_rate NUMBER;
2449: lx_acct_raw_cost NUMBER;

Line 2463: l_src_res_asg_id PA_RESOURCE_ASSIGNMENTS.RESOURCE_ASSIGNMENT_ID%TYPE;

2459: l_status Varchar2(100);
2460: g_project_name pa_projects_all.name%TYPE;
2461:
2462: /* Variables for Performance Bug 4194849 */
2463: l_src_res_asg_id PA_RESOURCE_ASSIGNMENTS.RESOURCE_ASSIGNMENT_ID%TYPE;
2464: l_tgt_res_asg_id PA_RESOURCE_ASSIGNMENTS.RESOURCE_ASSIGNMENT_ID%TYPE;
2465: l_fp_cols_src_rec PA_FP_GEN_AMOUNT_UTILS.FP_COLS;
2466: l_curr_task_id PA_TASKS.TASK_ID%TYPE;
2467: l_resource_list_member_id PA_RESOURCE_LIST_MEMBERS.RESOURCE_LIST_MEMBER_ID%TYPE;

Line 2464: l_tgt_res_asg_id PA_RESOURCE_ASSIGNMENTS.RESOURCE_ASSIGNMENT_ID%TYPE;

2460: g_project_name pa_projects_all.name%TYPE;
2461:
2462: /* Variables for Performance Bug 4194849 */
2463: l_src_res_asg_id PA_RESOURCE_ASSIGNMENTS.RESOURCE_ASSIGNMENT_ID%TYPE;
2464: l_tgt_res_asg_id PA_RESOURCE_ASSIGNMENTS.RESOURCE_ASSIGNMENT_ID%TYPE;
2465: l_fp_cols_src_rec PA_FP_GEN_AMOUNT_UTILS.FP_COLS;
2466: l_curr_task_id PA_TASKS.TASK_ID%TYPE;
2467: l_resource_list_member_id PA_RESOURCE_LIST_MEMBERS.RESOURCE_LIST_MEMBER_ID%TYPE;
2468: l_cbs_element_id PA_RESOURCE_ASSIGNMENTS.CBS_ELEMENT_ID%TYPE; --bug#16791711

Line 2468: l_cbs_element_id PA_RESOURCE_ASSIGNMENTS.CBS_ELEMENT_ID%TYPE; --bug#16791711

2464: l_tgt_res_asg_id PA_RESOURCE_ASSIGNMENTS.RESOURCE_ASSIGNMENT_ID%TYPE;
2465: l_fp_cols_src_rec PA_FP_GEN_AMOUNT_UTILS.FP_COLS;
2466: l_curr_task_id PA_TASKS.TASK_ID%TYPE;
2467: l_resource_list_member_id PA_RESOURCE_LIST_MEMBERS.RESOURCE_LIST_MEMBER_ID%TYPE;
2468: l_cbs_element_id PA_RESOURCE_ASSIGNMENTS.CBS_ELEMENT_ID%TYPE; --bug#16791711
2469: l_etc_source_code PA_TASKS.GEN_ETC_SOURCE_CODE%TYPE;
2470:
2471: /* This user-defined exception is used to skip processing of
2472: * a single task as we process all of the tasks in a loop. */

Line 2575: FROM pa_resource_assignments

2571:
2572: IF nvl(l_tgt_res_asg_id,0) > 0 THEN
2573: SELECT rate_based_flag
2574: INTO l_rate_based_flag
2575: FROM pa_resource_assignments
2576: WHERE resource_assignment_id = l_tgt_res_asg_id;
2577: ELSE
2578: l_rate_based_flag:='N';
2579: END IF;

Line 3449: FROM pa_resource_assignments

3445: SELECT task_id,
3446: planning_start_date
3447: INTO l_task_id,
3448: l_planning_start_date
3449: FROM pa_resource_assignments
3450: WHERE resource_assignment_id = l_src_res_asg_id;
3451: EXCEPTION
3452: WHEN NO_DATA_FOUND THEN
3453: l_task_id := NULL;

Line 3805: pa_resource_assignments ra

3801: NULL,
3802: NULL
3803: FROM PA_FP_CALC_AMT_TMP2 tmp4,
3804: pa_budget_lines sbl,
3805: pa_resource_assignments ra
3806: WHERE tmp4.resource_assignment_id = sbl.resource_assignment_id
3807: and (tmp4.TRANSACTION_SOURCE_CODE = 'WORKPLAN_RESOURCES' OR
3808: tmp4.TRANSACTION_SOURCE_CODE = 'FINANCIAL_PLAN')
3809: and tmp4.TARGET_RES_ASG_ID = ra.resource_assignment_id

Line 3873: pa_resource_assignments ra

3869: NULL,
3870: NULL
3871: FROM PA_FP_CALC_AMT_TMP2 tmp4,
3872: pa_budget_lines sbl,
3873: pa_resource_assignments ra
3874: WHERE tmp4.resource_assignment_id = sbl.resource_assignment_id
3875: and tmp4.TRANSACTION_SOURCE_CODE = c_gen_source
3876: and tmp4.TARGET_RES_ASG_ID = ra.resource_assignment_id
3877: and ra.budget_version_id = c_target_bv_id

Line 3941: pa_resource_assignments ra,

3937: NULL,
3938: NULL
3939: FROM PA_FP_CALC_AMT_TMP2 tmp4,
3940: pa_budget_lines sbl,
3941: pa_resource_assignments ra,
3942: PA_GL_PA_PERIODS_TMP pa_gl
3943: WHERE tmp4.resource_assignment_id = sbl.resource_assignment_id
3944: and (tmp4.TRANSACTION_SOURCE_CODE = 'WORKPLAN_RESOURCES' OR
3945: tmp4.TRANSACTION_SOURCE_CODE = 'FINANCIAL_PLAN')

Line 4014: pa_resource_assignments ra,

4010: NULL,
4011: NULL
4012: FROM PA_FP_CALC_AMT_TMP2 tmp4,
4013: pa_budget_lines sbl,
4014: pa_resource_assignments ra,
4015: PA_GL_PA_PERIODS_TMP pa_gl
4016: WHERE tmp4.resource_assignment_id = sbl.resource_assignment_id
4017: and tmp4.TRANSACTION_SOURCE_CODE = c_gen_source
4018: and tmp4.TARGET_RES_ASG_ID = ra.resource_assignment_id

Line 4086: pa_resource_assignments ra,

4082: NULL,
4083: NULL
4084: FROM PA_FP_CALC_AMT_TMP2 tmp4,
4085: pa_budget_lines sbl,
4086: pa_resource_assignments ra,
4087: PA_GL_PA_PERIODS_TMP pa_gl
4088: WHERE tmp4.resource_assignment_id = sbl.resource_assignment_id
4089: and (tmp4.TRANSACTION_SOURCE_CODE = 'WORKPLAN_RESOURCES' OR
4090: tmp4.TRANSACTION_SOURCE_CODE = 'FINANCIAL_PLAN')

Line 4159: pa_resource_assignments ra,

4155: NULL,
4156: NULL
4157: FROM PA_FP_CALC_AMT_TMP2 tmp4,
4158: pa_budget_lines sbl,
4159: pa_resource_assignments ra,
4160: PA_GL_PA_PERIODS_TMP pa_gl
4161: WHERE tmp4.resource_assignment_id = sbl.resource_assignment_id
4162: and tmp4.TRANSACTION_SOURCE_CODE = c_gen_source
4163: and tmp4.TARGET_RES_ASG_ID = ra.resource_assignment_id

Line 4225: l_last_updated_by PA_RESOURCE_ASSIGNMENTS.LAST_UPDATED_BY%TYPE

4221: l_pr_b_cost_rate_override_tab pa_plsql_datatypes.NumTabTyp;
4222:
4223:
4224:
4225: l_last_updated_by PA_RESOURCE_ASSIGNMENTS.LAST_UPDATED_BY%TYPE
4226: := FND_GLOBAL.user_id;
4227: l_last_update_login PA_RESOURCE_ASSIGNMENTS.LAST_UPDATE_LOGIN%TYPE
4228: := FND_GLOBAL.login_id;
4229:

Line 4227: l_last_update_login PA_RESOURCE_ASSIGNMENTS.LAST_UPDATE_LOGIN%TYPE

4223:
4224:
4225: l_last_updated_by PA_RESOURCE_ASSIGNMENTS.LAST_UPDATED_BY%TYPE
4226: := FND_GLOBAL.user_id;
4227: l_last_update_login PA_RESOURCE_ASSIGNMENTS.LAST_UPDATE_LOGIN%TYPE
4228: := FND_GLOBAL.login_id;
4229:
4230: l_override_quantity NUMBER;
4231: l_copy_lines varchar2(20);

Line 5041: FROM pa_resource_assignments ra,

5037: bl.txn_currency_code,
5038: rbc.txn_raw_cost_rate_override,
5039: rbc.txn_burden_cost_rate_override,
5040: rbc.txn_bill_rate_override
5041: FROM pa_resource_assignments ra,
5042: pa_budget_lines bl,
5043: pa_resource_asgn_curr rbc,
5044: PA_FP_CALC_AMT_TMP2 tmp4
5045: WHERE ra.budget_version_id = P_FP_COLS_TGT_REC.X_BUDGET_VERSION_ID

Line 5102: pa_resource_assignments ra

5098: sum(sbl.txn_burdened_cost),
5099: 'ETC'
5100: FROM PA_FP_CALC_AMT_TMP2 tmp4,
5101: pa_budget_lines sbl,
5102: pa_resource_assignments ra
5103: WHERE tmp4.TARGET_RES_ASG_ID = ra.resource_assignment_id
5104: AND sbl.resource_assignment_id=ra.resource_assignment_id
5105: AND ra.budget_version_id = P_FP_COLS_TGT_REC.X_BUDGET_VERSION_ID
5106: AND ra.project_id = P_FP_COLS_TGT_REC.x_project_id