DBA Data[Home] [Help]

APPS.PA_FP_GEN_FCST_AMT_PUB1 dependencies on PA_TASKS

Line 1983: p_object_type => 'PA_TASKS',

1979: PA_PROGRESS_UTILS.REDEFAULT_BASE_PC (
1980: p_Project_ID => P_FP_COLS_REC.X_PROJECT_ID,
1981: p_Proj_element_id => P_TASK_ID,
1982: p_Structure_type => l_structure_type,
1983: p_object_type => 'PA_TASKS',
1984: p_As_Of_Date => P_ACTUALS_THRU_DATE,
1985: P_STRUCTURE_VERSION_ID => l_WP_STRUCTURE_VERSION_ID,
1986: P_STRUCTURE_STATUS => l_structure_status,
1987: p_calling_context => 'FINANCIAL_PLANNING',

Line 2275: p_object_type => 'PA_TASKS',

2271: PA_PROGRESS_UTILS.REDEFAULT_BASE_PC (
2272: p_Project_ID => P_FP_COLS_REC.X_PROJECT_ID,
2273: p_Proj_element_id => P_TASK_ID,
2274: p_Structure_type => l_structure_type,
2275: p_object_type => 'PA_TASKS',
2276: p_As_Of_Date => P_ACTUALS_THRU_DATE,
2277: P_STRUCTURE_VERSION_ID => l_WP_STRUCTURE_VERSION_ID,
2278: P_STRUCTURE_STATUS => l_structure_status,
2279: p_calling_context => 'FINANCIAL_PLANNING',

Line 2882: AND OBJECT_TYPE = 'PA_TASKS';

2878: SELECT proj_element_id
2879: BULK COLLECT INTO l_wp_task_tab
2880: FROM pa_proj_element_versions
2881: WHERE PARENT_STRUCTURE_VERSION_ID = P_WP_STRUCTURE_VERSION_ID
2882: AND OBJECT_TYPE = 'PA_TASKS';
2883:
2884: FOR i IN 1..l_wp_task_tab.count LOOP
2885: IF P_PA_DEBUG_MODE = 'Y' THEN
2886: pa_fp_gen_amount_utils.fp_debug

Line 2996: FROM pa_tasks

2992: IF p_task_id IS NOT NULL THEN
2993: SELECT nvl(start_date,l_sysdate),
2994: nvl(completion_date,l_sysdate)
2995: INTO l_start_date, l_completion_date
2996: FROM pa_tasks
2997: WHERE task_id = P_TASK_ID;
2998: ELSE
2999: SELECT nvl(start_date,l_sysdate),
3000: nvl(completion_date,l_sysdate)

Line 3125: FROM pa_tasks

3121: IF nvl(p_task_id,0) > 0 THEN
3122: SELECT nvl(start_date,l_sysdate),
3123: nvl(completion_date,l_sysdate)
3124: INTO l_task_start_date, l_task_completion_date
3125: FROM pa_tasks
3126: WHERE task_id = P_TASK_ID;
3127: ELSE
3128: SELECT nvl(start_date,l_sysdate),
3129: nvl(completion_date,l_sysdate)

Line 4166: P_TASK_ID IN PA_TASKS.TASK_ID%TYPE,

4162: PROCEDURE GET_WP_ACTUALS_FOR_RA
4163: (P_FP_COLS_SRC_REC IN PA_FP_GEN_AMOUNT_UTILS.FP_COLS,
4164: P_FP_COLS_TGT_REC IN PA_FP_GEN_AMOUNT_UTILS.FP_COLS,
4165: P_SRC_RES_ASG_ID IN PA_RESOURCE_ASSIGNMENTS.RESOURCE_ASSIGNMENT_ID%TYPE,
4166: P_TASK_ID IN PA_TASKS.TASK_ID%TYPE,
4167: P_RES_LIST_MEM_ID IN PA_RESOURCE_LIST_MEMBERS.RESOURCE_LIST_MEMBER_ID%TYPE,
4168: P_ACTUALS_THRU_DATE IN DATE,
4169: X_ACT_QUANTITY OUT NOCOPY NUMBER,
4170: X_ACT_TXN_CURRENCY_CODE OUT NOCOPY PA_BUDGET_LINES.TXN_CURRENCY_CODE%TYPE,