DBA Data[Home] [Help]

APPS.PA_PROGRESS_PUB dependencies on PA_PROGRESS_ROLLUP_PKG

Line 2924: PA_PROGRESS_ROLLUP_PKG.INSERT_ROW(

2920: pa_debug.write(x_Module=>'PA_PROGRESS_PUB.UPDATE_TASK_PROGRESS', x_Msg => 'Inserting in PA_PROGRESS_ROLLUP ', x_Log_Level=> 3);
2921: END IF;
2922:
2923:
2924: PA_PROGRESS_ROLLUP_PKG.INSERT_ROW(
2925: x_progress_rollup_id => l_progress_rollup_id
2926: ,x_project_id => p_project_id
2927: ,x_object_id => p_object_id
2928: ,x_object_type => p_object_type

Line 3122: PA_PROGRESS_ROLLUP_PKG.UPDATE_ROW(

3118: END IF;
3119: -- Bug 4506461 End
3120:
3121:
3122: PA_PROGRESS_ROLLUP_PKG.UPDATE_ROW(
3123: x_progress_rollup_id => l_progress_rollup_id
3124: ,x_project_id => p_project_id
3125: ,x_object_id => p_object_id
3126: ,x_object_type => p_object_type

Line 3449: pa_progress_rollup_pkg.update_row(

3445: IF g1_debug_mode = 'Y' THEN
3446: pa_debug.write(x_Module=>'PA_PROGRESS_PUB.UPDATE_TASK_PROGRESS', x_Msg => 'Update Action: Updating PA_PROGRESS_ROLLUP ', x_Log_Level=> 3);
3447: END IF;
3448:
3449: pa_progress_rollup_pkg.update_row(
3450: x_progress_rollup_id => l_progress_rollup_id
3451: ,x_project_id => p_project_id
3452: ,x_object_id => p_object_id
3453: ,x_object_type => p_object_type

Line 3675: PA_PROGRESS_ROLLUP_PKG.INSERT_ROW(

3671: -- Bug 4506461 End
3672:
3673:
3674: -- changed this for effort to cost conversion
3675: PA_PROGRESS_ROLLUP_PKG.INSERT_ROW(
3676: x_progress_rollup_id => l_progress_rollup_id
3677: ,x_project_id => p_project_id
3678: ,x_object_id => p_object_id
3679: ,x_object_type => p_object_type

Line 5490: PA_PROGRESS_ROLLUP_PKG.DELETE_ROW( l_rollup_row_id );

5486: CLOSE cur_pa_ppr_tsk;
5487: END IF;
5488:
5489: PA_PERCENT_COMPLETES_PKG.DELETE_ROW( l_ppc_row_id );
5490: PA_PROGRESS_ROLLUP_PKG.DELETE_ROW( l_rollup_row_id );
5491:
5492: EXCEPTION
5493: when FND_API.G_EXC_ERROR then
5494: if p_commit = FND_API.G_TRUE then

Line 5991: PA_PROGRESS_ROLLUP_PKG.INSERT_ROW(

5987: l_PROGRESS_ROLLUP_ID := null;
5988: l_prog_pa_period_name := PA_PROGRESS_UTILS.Prog_Get_Pa_Period_Name(l_push_as_of_date);
5989: l_prog_gl_period_name := PA_PROGRESS_UTILS.Prog_Get_GL_Period_Name(l_push_as_of_date);
5990:
5991: PA_PROGRESS_ROLLUP_PKG.INSERT_ROW(
5992: X_PROGRESS_ROLLUP_ID => l_PROGRESS_ROLLUP_ID
5993: ,X_PROJECT_ID => p_project_id
5994: ,X_OBJECT_ID => cur_task_assignments_rec.resource_list_member_id
5995: ,X_OBJECT_TYPE => 'PA_ASSIGNMENTS'

Line 6312: PA_PROGRESS_ROLLUP_PKG.INSERT_ROW(

6308: l_PROGRESS_ROLLUP_ID := null;
6309: l_prog_pa_period_name := PA_PROGRESS_UTILS.Prog_Get_Pa_Period_Name(l_push_as_of_date);
6310: l_prog_gl_period_name := PA_PROGRESS_UTILS.Prog_Get_GL_Period_Name(l_push_as_of_date);
6311:
6312: PA_PROGRESS_ROLLUP_PKG.INSERT_ROW(
6313: X_PROGRESS_ROLLUP_ID => l_PROGRESS_ROLLUP_ID
6314: ,X_PROJECT_ID => p_project_id
6315: ,X_OBJECT_ID => cur_task_assignments_rec.proj_element_id
6316: ,X_OBJECT_TYPE => 'PA_TASKS'

Line 6446: PA_PROGRESS_ROLLUP_PKG.INSERT_ROW(

6442: -- Bug 3922325 : Hidden Assignment record also shd get created
6443:
6444: l_PROGRESS_ROLLUP_ID := null;
6445:
6446: PA_PROGRESS_ROLLUP_PKG.INSERT_ROW(
6447: X_PROGRESS_ROLLUP_ID => l_PROGRESS_ROLLUP_ID
6448: ,X_PROJECT_ID => p_project_id
6449: ,X_OBJECT_ID => cur_task_assignments_rec.resource_list_member_id
6450: ,X_OBJECT_TYPE => 'PA_ASSIGNMENTS'

Line 6746: PA_PROGRESS_ROLLUP_PKG.INSERT_ROW(

6742: l_push_as_of_date := p_as_of_date;
6743: l_prog_pa_period_name := PA_PROGRESS_UTILS.Prog_Get_Pa_Period_Name(l_push_as_of_date);
6744: l_prog_gl_period_name := PA_PROGRESS_UTILS.Prog_Get_GL_Period_Name(l_push_as_of_date);
6745:
6746: PA_PROGRESS_ROLLUP_PKG.INSERT_ROW(
6747: X_PROGRESS_ROLLUP_ID => l_PROGRESS_ROLLUP_ID
6748: ,X_PROJECT_ID =>p_project_id
6749: ,X_OBJECT_ID => cur_tasks_rec.proj_element_id
6750: ,X_OBJECT_TYPE => 'PA_TASKS'

Line 12242: -- PA_PROGRESS_ROLLUP_PKG.DELETE_ROW(l_ppr_rec.rowid);

12238: -- delete it
12239: -- IF g1_debug_mode = 'Y' THEN
12240: -- pa_debug.write(x_Module=>'PA_PROGRESS_PUB.PUBLISH_PROGRESS', x_Msg => 'Working PPR Record Found, Deleting it', x_Log_Level=> 3);
12241: -- END IF;
12242: -- PA_PROGRESS_ROLLUP_PKG.DELETE_ROW(l_ppr_rec.rowid);
12243: --END IF;
12244:
12245: l_last_ppr_rec := null;
12246: OPEN c_get_last_ppr_rec(l_rec.project_id, l_rec.object_id, l_rec.proj_element_id, l_rec.object_type, l_as_of_date,l_rec.cbs_element_id);

Line 20317: PA_PROGRESS_ROLLUP_PKG.INSERT_ROW(

20313: );
20314:
20315: IF l_PROGRESS_ROLLUP_ID IS NULL
20316: THEN
20317: PA_PROGRESS_ROLLUP_PKG.INSERT_ROW(
20318: X_PROGRESS_ROLLUP_ID => l_PROGRESS_ROLLUP_ID
20319: ,X_PROJECT_ID => p_project_id
20320: ,X_OBJECT_ID => l_object_id
20321: ,X_OBJECT_TYPE => l_object_type

Line 20442: PA_PROGRESS_ROLLUP_PKG.UPDATE_ROW(

20438: ,X_SUBPRJ_EQPMT_ETC_RAWCOST_TC => null
20439: ,X_SUBPRJ_EQPMT_ETC_RAWCOST_FC => null
20440: ,X_SUBPRJ_EQPMT_ETC_RAWCOST_PC => null);
20441: ELSE
20442: PA_PROGRESS_ROLLUP_PKG.UPDATE_ROW(
20443: X_PROGRESS_ROLLUP_ID => l_PROGRESS_ROLLUP_ID
20444: ,X_PROJECT_ID => p_project_id
20445: ,X_OBJECT_ID => l_object_id
20446: ,X_OBJECT_TYPE => l_object_type

Line 20679: PA_PROGRESS_ROLLUP_PKG.UPDATE_ROW(

20675: pa_debug.write(x_Module=>'PA_PROGRESS_PUB.UPDATE_FINANCIAL_TASK_PROGRESS', x_Msg => 'l_PROGRESS_ROLLUP_ID: '||l_PROGRESS_ROLLUP_ID, x_Log_Level=> 3);
20676: END IF;
20677:
20678:
20679: PA_PROGRESS_ROLLUP_PKG.UPDATE_ROW(
20680: X_PROGRESS_ROLLUP_ID => l_PROGRESS_ROLLUP_ID
20681: ,X_PROJECT_ID => p_project_id
20682: ,X_OBJECT_ID => l_object_id
20683: ,X_OBJECT_TYPE => l_object_type