DBA Data[Home] [Help]

APPS.PA_FP_GEN_FCST_AMT_PUB1 dependencies on PA_TASKS

Line 2006: p_object_type => 'PA_TASKS',

2002: PA_PROGRESS_UTILS.REDEFAULT_BASE_PC (
2003: p_Project_ID => P_FP_COLS_REC.X_PROJECT_ID,
2004: p_Proj_element_id => P_TASK_ID,
2005: p_Structure_type => l_structure_type,
2006: p_object_type => 'PA_TASKS',
2007: p_As_Of_Date => P_ACTUALS_THRU_DATE,
2008: P_STRUCTURE_VERSION_ID => l_WP_STRUCTURE_VERSION_ID,
2009: P_STRUCTURE_STATUS => l_structure_status,
2010: p_calling_context => 'FINANCIAL_PLANNING',

Line 2298: p_object_type => 'PA_TASKS',

2294: PA_PROGRESS_UTILS.REDEFAULT_BASE_PC (
2295: p_Project_ID => P_FP_COLS_REC.X_PROJECT_ID,
2296: p_Proj_element_id => P_TASK_ID,
2297: p_Structure_type => l_structure_type,
2298: p_object_type => 'PA_TASKS',
2299: p_As_Of_Date => P_ACTUALS_THRU_DATE,
2300: P_STRUCTURE_VERSION_ID => l_WP_STRUCTURE_VERSION_ID,
2301: P_STRUCTURE_STATUS => l_structure_status,
2302: p_calling_context => 'FINANCIAL_PLANNING',

Line 2905: AND OBJECT_TYPE = 'PA_TASKS';

2901: SELECT proj_element_id
2902: BULK COLLECT INTO l_wp_task_tab
2903: FROM pa_proj_element_versions
2904: WHERE PARENT_STRUCTURE_VERSION_ID = P_WP_STRUCTURE_VERSION_ID
2905: AND OBJECT_TYPE = 'PA_TASKS';
2906:
2907: FOR i IN 1..l_wp_task_tab.count LOOP
2908: IF P_PA_DEBUG_MODE = 'Y' THEN
2909: pa_fp_gen_amount_utils.fp_debug

Line 3019: FROM pa_tasks

3015: IF p_task_id IS NOT NULL THEN
3016: SELECT nvl(start_date,l_sysdate),
3017: nvl(completion_date,l_sysdate)
3018: INTO l_start_date, l_completion_date
3019: FROM pa_tasks
3020: WHERE task_id = P_TASK_ID;
3021: ELSE
3022: SELECT nvl(start_date,l_sysdate),
3023: nvl(completion_date,l_sysdate)

Line 3148: FROM pa_tasks

3144: IF nvl(p_task_id,0) > 0 THEN
3145: SELECT nvl(start_date,l_sysdate),
3146: nvl(completion_date,l_sysdate)
3147: INTO l_task_start_date, l_task_completion_date
3148: FROM pa_tasks
3149: WHERE task_id = P_TASK_ID;
3150: ELSE
3151: SELECT nvl(start_date,l_sysdate),
3152: nvl(completion_date,l_sysdate)

Line 4190: P_TASK_ID IN PA_TASKS.TASK_ID%TYPE,

4186: PROCEDURE GET_WP_ACTUALS_FOR_RA
4187: (P_FP_COLS_SRC_REC IN PA_FP_GEN_AMOUNT_UTILS.FP_COLS,
4188: P_FP_COLS_TGT_REC IN PA_FP_GEN_AMOUNT_UTILS.FP_COLS,
4189: P_SRC_RES_ASG_ID IN PA_RESOURCE_ASSIGNMENTS.RESOURCE_ASSIGNMENT_ID%TYPE,
4190: P_TASK_ID IN PA_TASKS.TASK_ID%TYPE,
4191: P_RES_LIST_MEM_ID IN PA_RESOURCE_LIST_MEMBERS.RESOURCE_LIST_MEMBER_ID%TYPE,
4192: P_ACTUALS_THRU_DATE IN DATE,
4193: X_ACT_QUANTITY OUT NOCOPY NUMBER,
4194: X_ACT_TXN_CURRENCY_CODE OUT NOCOPY PA_BUDGET_LINES.TXN_CURRENCY_CODE%TYPE,