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 2444: l_planning_start_date pa_resource_assignments.planning_start_date%type;

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

Line 2462: l_src_res_asg_id PA_RESOURCE_ASSIGNMENTS.RESOURCE_ASSIGNMENT_ID%TYPE;

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

Line 2463: l_tgt_res_asg_id PA_RESOURCE_ASSIGNMENTS.RESOURCE_ASSIGNMENT_ID%TYPE;

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

Line 2572: FROM pa_resource_assignments

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

Line 3435: FROM pa_resource_assignments

3431: SELECT task_id,
3432: planning_start_date
3433: INTO l_task_id,
3434: l_planning_start_date
3435: FROM pa_resource_assignments
3436: WHERE resource_assignment_id = l_src_res_asg_id;
3437: EXCEPTION
3438: WHEN NO_DATA_FOUND THEN
3439: l_task_id := NULL;