APPS.PA_FP_ROLLUP_TMP_PKG dependencies on PA_FP_ROLLUP_TMP

Line 1: PACKAGE BODY PA_FP_ROLLUP_TMP_PKG AS

1: PACKAGE BODY PA_FP_ROLLUP_TMP_PKG AS
2: /* $Header: PAFPRLTB.pls 120.1.12010000.2 2009/06/17 22:00:08 djanaswa ship $*/
3:
4: g_module_name VARCHAR2(100) := 'pa.plsql.pa_fp_rollup_tmp_pkg';
5:

Line 4: g_module_name VARCHAR2(100) := 'pa.plsql.pa_fp_rollup_tmp_pkg';

1: PACKAGE BODY PA_FP_ROLLUP_TMP_PKG AS
2: /* $Header: PAFPRLTB.pls 120.1.12010000.2 2009/06/17 22:00:08 djanaswa ship $*/
3:
4: g_module_name VARCHAR2(100) := 'pa.plsql.pa_fp_rollup_tmp_pkg';
5:
6: PROCEDURE POPULATE_IN_BULK
7: ( p_res_assignment_id_tbl IN pa_fp_webadi_pkg.l_res_assignment_id_tbl_typ
8: , p_parent_assignment_id_tbl IN pa_fp_webadi_pkg.l_parent_assign_id_tbl_typ

Line 82: pa_debug.set_err_stack('PA_FP_ROLLUP_TMP_PKG.POPULATE_IN_BULK');

78: x_return_status := FND_API.G_RET_STS_SUCCESS;
79: l_debug_mode := NVL(FND_PROFILE.value('PA_DEBUG_MODE'), 'N');
80: IF l_debug_mode = 'Y' THEN
81:
82: pa_debug.set_err_stack('PA_FP_ROLLUP_TMP_PKG.POPULATE_IN_BULK');
83: pa_debug.set_process('PLSQL','LOG',l_debug_mode);
84:
85: END IF;
86:

Line 88: pa_debug.g_err_stage := ':In PA_FP_ROLLUP_TMP_PKG.POPULATE_IN_BULK p_res_assignment_id_tbl.last = ' || p_res_assignment_id_tbl.last;

84:
85: END IF;
86:
87: IF l_debug_mode = 'Y' THEN
88: pa_debug.g_err_stage := ':In PA_FP_ROLLUP_TMP_PKG.POPULATE_IN_BULK p_res_assignment_id_tbl.last = ' || p_res_assignment_id_tbl.last;
89: pa_debug.write(g_module_name,pa_debug.g_err_stage,3);
90: END IF;
91:
92: IF nvl(p_res_assignment_id_tbl.LAST,0) > 0 THEN

Line 96: INSERT INTO PA_FP_ROLLUP_TMP(

92: IF nvl(p_res_assignment_id_tbl.LAST,0) > 0 THEN
93:
94: FORALL i in p_res_assignment_id_tbl.first..p_res_assignment_id_tbl.last
95:
96: INSERT INTO PA_FP_ROLLUP_TMP(
97: ROLLUP_ID
98: , RESOURCE_ASSIGNMENT_ID
99: , PARENT_ASSIGNMENT_ID
100: , START_DATE

Line 163: pa_fp_rollup_tmp_s.nextval

159: , QUANTITY_SOURCE
160: , REVENUE_SOURCE
161: )
162: VALUES (
163: pa_fp_rollup_tmp_s.nextval
164: , p_res_assignment_id_tbl(i)
165: , p_parent_assignment_id_tbl(i)
166: , p_start_date_tbl(i)
167: , p_end_date_tbl(i)

Line 330: pa_debug.set_err_stack('PA_FP_ROLLUP_TMP_PKG.POPULATE_IN_MATRIX');

326: x_return_status := FND_API.G_RET_STS_SUCCESS;
327: l_debug_mode := NVL(FND_PROFILE.value('PA_DEBUG_MODE'), 'N');
328:
329: IF l_debug_mode = 'Y' THEN
330: pa_debug.set_err_stack('PA_FP_ROLLUP_TMP_PKG.POPULATE_IN_MATRIX');
331: pa_debug.set_process('PLSQL','LOG',l_debug_mode);
332: END IF;
333:
334: IF l_debug_mode = 'Y' THEN

Line 343: INSERT INTO PA_FP_ROLLUP_TMP(

339: IF nvl(p_period_name_tbl.LAST,0) > 0 THEN
340:
341: FORALL i in p_period_name_tbl.FIRST..p_period_name_tbl.LAST
342:
343: INSERT INTO PA_FP_ROLLUP_TMP(
344: ROLLUP_ID
345: , RESOURCE_ASSIGNMENT_ID
346: , PARENT_ASSIGNMENT_ID
347: , TXN_CURRENCY_CODE

Line 399: pa_fp_rollup_tmp_s.nextval

395: , TXN_REVENUE
396: , QUANTITY
397: , BUCKETING_PERIOD_CODE )
398: (SELECT
399: pa_fp_rollup_tmp_s.nextval
400: , p_res_assignment_id
401: , p_parent_assignment_id
402: , p_txn_currency_code
403: , p_proj_currency_code

Line 474: ( p_pkg_name => 'PA_FP_ROLLUP_TMP_PKG'

470: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
471: x_msg_count := 1;
472: x_msg_data := SQLERRM;
473: FND_MSG_PUB.add_exc_msg
474: ( p_pkg_name => 'PA_FP_ROLLUP_TMP_PKG'
475: ,p_procedure_name => 'POPULATE_IN_MATRIX' );
476: IF l_debug_mode = 'Y' THEN
477: pa_debug.write('POPULATE_IN_MATRIX' || g_module_name,SQLERRM,4);
478: pa_debug.write('POPULATE_IN_MATRIX' || g_module_name,pa_debug.G_Err_Stack,4);

Line 484: END PA_FP_ROLLUP_TMP_PKG;

480: pa_debug.reset_err_stack;
481: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
482:
483: END POPULATE_IN_MATRIX ;
484: END PA_FP_ROLLUP_TMP_PKG;