APPS.PA_FP_GEN_FCST_AMT_PUB3 dependencies on PA_TASKS

Line 32: P_TASK_ID IN PA_TASKS.TASK_ID%TYPE,

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,
34: P_ETC_SOURCE_CODE IN PA_TASKS.GEN_ETC_SOURCE_CODE%TYPE,
35: P_WP_STRUCTURE_VERSION_ID IN PA_PROJ_ELEM_VER_STRUCTURE.ELEMENT_VERSION_ID%TYPE,
36: P_ACTUALS_THRU_DATE IN PA_PERIODS_ALL.END_DATE%TYPE,

Line 34: P_ETC_SOURCE_CODE IN PA_TASKS.GEN_ETC_SOURCE_CODE%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,
34: P_ETC_SOURCE_CODE IN PA_TASKS.GEN_ETC_SOURCE_CODE%TYPE,
35: P_WP_STRUCTURE_VERSION_ID IN PA_PROJ_ELEM_VER_STRUCTURE.ELEMENT_VERSION_ID%TYPE,
36: P_ACTUALS_THRU_DATE IN PA_PERIODS_ALL.END_DATE%TYPE,
37: P_PLANNING_OPTIONS_FLAG IN VARCHAR2,
38: X_RETURN_STATUS OUT NOCOPY VARCHAR2,

Line 138: l_task_id pa_tasks.task_id%type;

134: l_pc_revenue_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;
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;

Line 1304: l_task_id pa_tasks.task_id%type;

1300:
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;

Line 2444: l_task_id pa_tasks.task_id%type;

2440: l_pc_revenue_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;
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;

Line 2466: l_curr_task_id PA_TASKS.TASK_ID%TYPE;

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
2469: l_etc_source_code PA_TASKS.GEN_ETC_SOURCE_CODE%TYPE;
2470:

Line 2469: l_etc_source_code PA_TASKS.GEN_ETC_SOURCE_CODE%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. */
2473: continue_loop EXCEPTION;