DBA Data[Home] [Help]

APPS.PA_PROGRESS_PUB dependencies on PA_PROGRESS_ROLLUP_PKG

Line 2617: PA_PROGRESS_ROLLUP_PKG.INSERT_ROW(

2613: pa_debug.write(x_Module=>'PA_PROGRESS_PUB.UPDATE_TASK_PROGRESS', x_Msg => 'Inserting in PA_PROGRESS_ROLLUP ', x_Log_Level=> 3);
2614: END IF;
2615:
2616:
2617: PA_PROGRESS_ROLLUP_PKG.INSERT_ROW(
2618: x_progress_rollup_id => l_progress_rollup_id
2619: ,x_project_id => p_project_id
2620: ,x_object_id => p_object_id
2621: ,x_object_type => p_object_type

Line 2815: PA_PROGRESS_ROLLUP_PKG.UPDATE_ROW(

2811: END IF;
2812: -- Bug 4506461 End
2813:
2814:
2815: PA_PROGRESS_ROLLUP_PKG.UPDATE_ROW(
2816: x_progress_rollup_id => l_progress_rollup_id
2817: ,x_project_id => p_project_id
2818: ,x_object_id => p_object_id
2819: ,x_object_type => p_object_type

Line 3142: pa_progress_rollup_pkg.update_row(

3138: IF g1_debug_mode = 'Y' THEN
3139: pa_debug.write(x_Module=>'PA_PROGRESS_PUB.UPDATE_TASK_PROGRESS', x_Msg => 'Update Action: Updating PA_PROGRESS_ROLLUP ', x_Log_Level=> 3);
3140: END IF;
3141:
3142: pa_progress_rollup_pkg.update_row(
3143: x_progress_rollup_id => l_progress_rollup_id
3144: ,x_project_id => p_project_id
3145: ,x_object_id => p_object_id
3146: ,x_object_type => p_object_type

Line 3368: PA_PROGRESS_ROLLUP_PKG.INSERT_ROW(

3364: -- Bug 4506461 End
3365:
3366:
3367: -- changed this for effort to cost conversion
3368: PA_PROGRESS_ROLLUP_PKG.INSERT_ROW(
3369: x_progress_rollup_id => l_progress_rollup_id
3370: ,x_project_id => p_project_id
3371: ,x_object_id => p_object_id
3372: ,x_object_type => p_object_type

Line 5086: PA_PROGRESS_ROLLUP_PKG.DELETE_ROW( l_rollup_row_id );

5082: CLOSE cur_pa_ppr_tsk;
5083: END IF;
5084:
5085: PA_PERCENT_COMPLETES_PKG.DELETE_ROW( l_ppc_row_id );
5086: PA_PROGRESS_ROLLUP_PKG.DELETE_ROW( l_rollup_row_id );
5087:
5088: EXCEPTION
5089: when FND_API.G_EXC_ERROR then
5090: if p_commit = FND_API.G_TRUE then

Line 5587: PA_PROGRESS_ROLLUP_PKG.INSERT_ROW(

5583: l_PROGRESS_ROLLUP_ID := null;
5584: l_prog_pa_period_name := PA_PROGRESS_UTILS.Prog_Get_Pa_Period_Name(l_push_as_of_date);
5585: l_prog_gl_period_name := PA_PROGRESS_UTILS.Prog_Get_GL_Period_Name(l_push_as_of_date);
5586:
5587: PA_PROGRESS_ROLLUP_PKG.INSERT_ROW(
5588: X_PROGRESS_ROLLUP_ID => l_PROGRESS_ROLLUP_ID
5589: ,X_PROJECT_ID => p_project_id
5590: ,X_OBJECT_ID => cur_task_assignments_rec.resource_list_member_id
5591: ,X_OBJECT_TYPE => 'PA_ASSIGNMENTS'

Line 5908: PA_PROGRESS_ROLLUP_PKG.INSERT_ROW(

5904: l_PROGRESS_ROLLUP_ID := null;
5905: l_prog_pa_period_name := PA_PROGRESS_UTILS.Prog_Get_Pa_Period_Name(l_push_as_of_date);
5906: l_prog_gl_period_name := PA_PROGRESS_UTILS.Prog_Get_GL_Period_Name(l_push_as_of_date);
5907:
5908: PA_PROGRESS_ROLLUP_PKG.INSERT_ROW(
5909: X_PROGRESS_ROLLUP_ID => l_PROGRESS_ROLLUP_ID
5910: ,X_PROJECT_ID => p_project_id
5911: ,X_OBJECT_ID => cur_task_assignments_rec.proj_element_id
5912: ,X_OBJECT_TYPE => 'PA_TASKS'

Line 6042: PA_PROGRESS_ROLLUP_PKG.INSERT_ROW(

6038: -- Bug 3922325 : Hidden Assignment record also shd get created
6039:
6040: l_PROGRESS_ROLLUP_ID := null;
6041:
6042: PA_PROGRESS_ROLLUP_PKG.INSERT_ROW(
6043: X_PROGRESS_ROLLUP_ID => l_PROGRESS_ROLLUP_ID
6044: ,X_PROJECT_ID => p_project_id
6045: ,X_OBJECT_ID => cur_task_assignments_rec.resource_list_member_id
6046: ,X_OBJECT_TYPE => 'PA_ASSIGNMENTS'

Line 6342: PA_PROGRESS_ROLLUP_PKG.INSERT_ROW(

6338: l_push_as_of_date := p_as_of_date;
6339: l_prog_pa_period_name := PA_PROGRESS_UTILS.Prog_Get_Pa_Period_Name(l_push_as_of_date);
6340: l_prog_gl_period_name := PA_PROGRESS_UTILS.Prog_Get_GL_Period_Name(l_push_as_of_date);
6341:
6342: PA_PROGRESS_ROLLUP_PKG.INSERT_ROW(
6343: X_PROGRESS_ROLLUP_ID => l_PROGRESS_ROLLUP_ID
6344: ,X_PROJECT_ID =>p_project_id
6345: ,X_OBJECT_ID => cur_tasks_rec.proj_element_id
6346: ,X_OBJECT_TYPE => 'PA_TASKS'

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

11785: -- delete it
11786: -- IF g1_debug_mode = 'Y' THEN
11787: -- pa_debug.write(x_Module=>'PA_PROGRESS_PUB.PUBLISH_PROGRESS', x_Msg => 'Working PPR Record Found, Deleting it', x_Log_Level=> 3);
11788: -- END IF;
11789: -- PA_PROGRESS_ROLLUP_PKG.DELETE_ROW(l_ppr_rec.rowid);
11790: --END IF;
11791:
11792: l_last_ppr_rec := null;
11793: 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);

Line 18854: PA_PROGRESS_ROLLUP_PKG.INSERT_ROW(

18850: );
18851:
18852: IF l_PROGRESS_ROLLUP_ID IS NULL
18853: THEN
18854: PA_PROGRESS_ROLLUP_PKG.INSERT_ROW(
18855: X_PROGRESS_ROLLUP_ID => l_PROGRESS_ROLLUP_ID
18856: ,X_PROJECT_ID => p_project_id
18857: ,X_OBJECT_ID => l_object_id
18858: ,X_OBJECT_TYPE => l_object_type

Line 18979: PA_PROGRESS_ROLLUP_PKG.UPDATE_ROW(

18975: ,X_SUBPRJ_EQPMT_ETC_RAWCOST_TC => null
18976: ,X_SUBPRJ_EQPMT_ETC_RAWCOST_FC => null
18977: ,X_SUBPRJ_EQPMT_ETC_RAWCOST_PC => null);
18978: ELSE
18979: PA_PROGRESS_ROLLUP_PKG.UPDATE_ROW(
18980: X_PROGRESS_ROLLUP_ID => l_PROGRESS_ROLLUP_ID
18981: ,X_PROJECT_ID => p_project_id
18982: ,X_OBJECT_ID => l_object_id
18983: ,X_OBJECT_TYPE => l_object_type

Line 19216: PA_PROGRESS_ROLLUP_PKG.UPDATE_ROW(

19212: 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);
19213: END IF;
19214:
19215:
19216: PA_PROGRESS_ROLLUP_PKG.UPDATE_ROW(
19217: X_PROGRESS_ROLLUP_ID => l_PROGRESS_ROLLUP_ID
19218: ,X_PROJECT_ID => p_project_id
19219: ,X_OBJECT_ID => l_object_id
19220: ,X_OBJECT_TYPE => l_object_type