eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PA_FP_MAINTAIN_ACTUAL_PUB dependencies on PA_FP_MAINTAIN_ACTUAL_PUB

Line 1: PACKAGE body PA_FP_MAINTAIN_ACTUAL_PUB as

1: PACKAGE body PA_FP_MAINTAIN_ACTUAL_PUB as
2: /* $Header: PAFPMAPB.pls 120.16 2007/04/13 16:17:29 rthumma noship $ */
3:
4: P_PA_DEBUG_MODE varchar2(1) := NVL(FND_PROFILE.value('PA_DEBUG_MODE'), 'N');
5:

Line 29: l_module_name VARCHAR2(200) := 'pa.plsql.pa_fp_maintain_actual_pub.maintain_actual_amt_wrp';

25: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
26: X_MSG_COUNT OUT NOCOPY NUMBER,
27: X_MSG_DATA OUT NOCOPY VARCHAR2)
28: IS
29: l_module_name VARCHAR2(200) := 'pa.plsql.pa_fp_maintain_actual_pub.maintain_actual_amt_wrp';
30: l_count NUMBER;
31: l_msg_count NUMBER;
32: l_cnt NUMBER;
33: l_data VARCHAR2(2000);

Line 117: l_amt_dtls_tbl pa_fp_maintain_actual_pub.l_amt_dtls_tbl_typ;

113: l_end_date_tab pa_plsql_datatypes.DateTabTyp;
114: l_start_date Date;
115: l_end_date Date;
116:
117: l_amt_dtls_tbl pa_fp_maintain_actual_pub.l_amt_dtls_tbl_typ;
118:
119: l_txn_bd_cost_tab pa_plsql_datatypes.NumTabTyp;
120: l_proj_bd_cost_tab pa_plsql_datatypes.NumTabTyp;
121: l_pou_bd_cost_tab pa_plsql_datatypes.NumTabTyp;

Line 148: PA_DEBUG.init_err_stack('PA_FP_MAINTAIN_ACTUAL_PUB.MAINTAIN_ACTUAL_AMT_WRP');

144: X_MSG_COUNT := 0;
145: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
146:
147: IF p_pa_debug_mode = 'Y' AND p_init_msg_flag = 'Y' THEN
148: PA_DEBUG.init_err_stack('PA_FP_MAINTAIN_ACTUAL_PUB.MAINTAIN_ACTUAL_AMT_WRP');
149: ELSIF p_pa_debug_mode = 'Y' AND p_init_msg_flag = 'N' THEN
150: pa_debug.set_curr_function( p_function => 'MAINTAIN_ACTUAL_AMT_WRP'
151: ,p_debug_mode => p_pa_debug_mode);
152: END IF;

Line 266: p_msg => 'Before calling PA_FP_MAINTAIN_ACTUAL_PUB.'

262:
263: IF p_pa_debug_mode = 'Y' THEN
264: pa_fp_gen_amount_utils.fp_debug
265: (p_called_mode => p_calling_mode,
266: p_msg => 'Before calling PA_FP_MAINTAIN_ACTUAL_PUB.'
267: ||'BLK_UPD_REPORTING_LINES_WRP',
268: p_module_name => l_module_name,
269: p_log_level => 5);
270: END IF;

Line 272: | Bug 4141131: Calling PA_FP_MAINTAIN_ACTUAL_PUB.BLK_UPD_REPORTING_LINES_WRP |

268: p_module_name => l_module_name,
269: p_log_level => 5);
270: END IF;
271: /*============================================================================+
272: | Bug 4141131: Calling PA_FP_MAINTAIN_ACTUAL_PUB.BLK_UPD_REPORTING_LINES_WRP |
273: | only if P_EXTRACTION_TYPE is 'INCREMENTAL'. |
274: | Bug 4164532: Calling PA_FP_MAINTAIN_ACTUAL_PUB.BLK_UPD_REPORTING_LINES_WRP |
275: | only if NOT (P_CALLING_CONTEXT = 'WP_SUMMARIZED_ACTUAL' |
276: | AND P_EXTRACTION_TYPE = 'INCREMENTAL') |

Line 274: | Bug 4164532: Calling PA_FP_MAINTAIN_ACTUAL_PUB.BLK_UPD_REPORTING_LINES_WRP |

270: END IF;
271: /*============================================================================+
272: | Bug 4141131: Calling PA_FP_MAINTAIN_ACTUAL_PUB.BLK_UPD_REPORTING_LINES_WRP |
273: | only if P_EXTRACTION_TYPE is 'INCREMENTAL'. |
274: | Bug 4164532: Calling PA_FP_MAINTAIN_ACTUAL_PUB.BLK_UPD_REPORTING_LINES_WRP |
275: | only if NOT (P_CALLING_CONTEXT = 'WP_SUMMARIZED_ACTUAL' |
276: | AND P_EXTRACTION_TYPE = 'INCREMENTAL') |
277: +============================================================================*/
278: IF NOT ( P_CALLING_CONTEXT = 'WP_SUMMARIZED_ACTUAL' AND P_EXTRACTION_TYPE = 'FULL' )

Line 280: PA_FP_MAINTAIN_ACTUAL_PUB.BLK_UPD_REPORTING_LINES_WRP (

276: | AND P_EXTRACTION_TYPE = 'INCREMENTAL') |
277: +============================================================================*/
278: IF NOT ( P_CALLING_CONTEXT = 'WP_SUMMARIZED_ACTUAL' AND P_EXTRACTION_TYPE = 'FULL' )
279: THEN
280: PA_FP_MAINTAIN_ACTUAL_PUB.BLK_UPD_REPORTING_LINES_WRP (
281: P_BUDGET_VERSION_ID => l_bv_id,
282: P_ENTIRE_VERSION_FLAG => 'N',
283: P_RES_ASG_ID_TAB => l_ra_id_upd_reprt_tab,
284: P_ACTIVITY_CODE => 'DELETE',

Line 291: p_msg => 'Status after calling PA_FP_MAINTAIN_ACTUAL_PUB.'

287: X_MSG_DATA => x_msg_data);
288: IF p_pa_debug_mode = 'Y' THEN
289: pa_fp_gen_amount_utils.fp_debug
290: (p_called_mode => p_calling_mode,
291: p_msg => 'Status after calling PA_FP_MAINTAIN_ACTUAL_PUB.'
292: ||'BLK_UPD_REPORTING_LINES_WRP:'||x_return_status,
293: p_module_name => l_module_name,
294: p_log_level => 5);
295: END IF;

Line 431: pa_fp_maintain_actual_pub.maintain_actual_amt_ra',

427: IF p_pa_debug_mode = 'Y' THEN
428: pa_fp_gen_amount_utils.fp_debug
429: (p_called_mode => p_calling_mode,
430: p_msg => 'Before calling
431: pa_fp_maintain_actual_pub.maintain_actual_amt_ra',
432: p_module_name => l_module_name,
433: p_log_level => 5);
434: END IF;
435: PA_FP_MAINTAIN_ACTUAL_PUB.MAINTAIN_ACTUAL_AMT_RA (

Line 435: PA_FP_MAINTAIN_ACTUAL_PUB.MAINTAIN_ACTUAL_AMT_RA (

431: pa_fp_maintain_actual_pub.maintain_actual_amt_ra',
432: p_module_name => l_module_name,
433: p_log_level => 5);
434: END IF;
435: PA_FP_MAINTAIN_ACTUAL_PUB.MAINTAIN_ACTUAL_AMT_RA (
436: P_PROJECT_ID => l_project_id_tab(i),
437: P_BUDGET_VERSION_ID => l_budget_ver_id_tab(i),
438: P_RESOURCE_ASSIGNMENT_ID => l_res_asg_id_tab(i),
439: P_TXN_CURRENCY_CODE => l_txn_currency_code_tab(i),

Line 455: pa_fp_maintain_actual_pub.maintain_actual_amt_ra'

451: IF p_pa_debug_mode = 'Y' THEN
452: pa_fp_gen_amount_utils.fp_debug
453: (p_called_mode => p_calling_mode,
454: p_msg => 'Status after calling
455: pa_fp_maintain_actual_pub.maintain_actual_amt_ra'
456: ||x_return_status,
457: p_module_name => l_module_name,
458: p_log_level => 5);
459: END IF;

Line 554: p_msg => 'Before calling PA_FP_MAINTAIN_ACTUAL_PUB.'

550:
551: IF p_pa_debug_mode = 'Y' THEN
552: pa_fp_gen_amount_utils.fp_debug
553: (p_called_mode => p_calling_mode,
554: p_msg => 'Before calling PA_FP_MAINTAIN_ACTUAL_PUB.'
555: ||'BLK_UPD_REPORTING_LINES_WRP',
556: p_module_name => l_module_name,
557: p_log_level => 5);
558: END IF;

Line 560: | Bug 4141131: Calling PA_FP_MAINTAIN_ACTUAL_PUB.BLK_UPD_REPORTING_LINES_WRP |

556: p_module_name => l_module_name,
557: p_log_level => 5);
558: END IF;
559: /*============================================================================+
560: | Bug 4141131: Calling PA_FP_MAINTAIN_ACTUAL_PUB.BLK_UPD_REPORTING_LINES_WRP |
561: | only if P_EXTRACTION_TYPE is 'INCREMENTAL'. |
562: | Bug 4164532: Calling PA_FP_MAINTAIN_ACTUAL_PUB.BLK_UPD_REPORTING_LINES_WRP |
563: | only if NOT (P_CALLING_CONTEXT = 'WP_SUMMARIZED_ACTUAL' |
564: | AND P_EXTRACTION_TYPE = 'INCREMENTAL') |

Line 562: | Bug 4164532: Calling PA_FP_MAINTAIN_ACTUAL_PUB.BLK_UPD_REPORTING_LINES_WRP |

558: END IF;
559: /*============================================================================+
560: | Bug 4141131: Calling PA_FP_MAINTAIN_ACTUAL_PUB.BLK_UPD_REPORTING_LINES_WRP |
561: | only if P_EXTRACTION_TYPE is 'INCREMENTAL'. |
562: | Bug 4164532: Calling PA_FP_MAINTAIN_ACTUAL_PUB.BLK_UPD_REPORTING_LINES_WRP |
563: | only if NOT (P_CALLING_CONTEXT = 'WP_SUMMARIZED_ACTUAL' |
564: | AND P_EXTRACTION_TYPE = 'INCREMENTAL') |
565: +============================================================================*/
566: IF NOT ( P_CALLING_CONTEXT = 'WP_SUMMARIZED_ACTUAL' AND P_EXTRACTION_TYPE = 'FULL' )

Line 568: PA_FP_MAINTAIN_ACTUAL_PUB.BLK_UPD_REPORTING_LINES_WRP (

564: | AND P_EXTRACTION_TYPE = 'INCREMENTAL') |
565: +============================================================================*/
566: IF NOT ( P_CALLING_CONTEXT = 'WP_SUMMARIZED_ACTUAL' AND P_EXTRACTION_TYPE = 'FULL' )
567: THEN
568: PA_FP_MAINTAIN_ACTUAL_PUB.BLK_UPD_REPORTING_LINES_WRP (
569: P_BUDGET_VERSION_ID => l_bv_id,
570: P_ENTIRE_VERSION_FLAG => 'N',
571: P_RES_ASG_ID_TAB => l_ra_id_upd_reprt_tab,
572: P_ACTIVITY_CODE => 'UPDATE',

Line 579: p_msg => 'Status after calling PA_FP_MAINTAIN_ACTUAL_PUB.'

575: X_MSG_DATA => x_msg_data);
576: IF p_pa_debug_mode = 'Y' THEN
577: pa_fp_gen_amount_utils.fp_debug
578: (p_called_mode => p_calling_mode,
579: p_msg => 'Status after calling PA_FP_MAINTAIN_ACTUAL_PUB.'
580: ||'BLK_UPD_REPORTING_LINES_WRP:'||x_return_status,
581: p_module_name => l_module_name,
582: p_log_level => 5);
583: END IF;

Line 607: /* Calling the pa_fp_maintain_actual_pub.sync_up_planning_dates api */

603: AND nvl(unplanned_flag,'N') = 'Y';
604: END IF;
605:
606: FOR jj in 1..l_bv_id_tab.count LOOP
607: /* Calling the pa_fp_maintain_actual_pub.sync_up_planning_dates api */
608: IF p_pa_debug_mode = 'Y' THEN
609: pa_fp_gen_amount_utils.fp_debug
610: (p_called_mode => p_calling_mode,
611: p_msg => 'Before calling

Line 612: pa_fp_maintain_actual_pub.sync_up_planning_dates',

608: IF p_pa_debug_mode = 'Y' THEN
609: pa_fp_gen_amount_utils.fp_debug
610: (p_called_mode => p_calling_mode,
611: p_msg => 'Before calling
612: pa_fp_maintain_actual_pub.sync_up_planning_dates',
613: p_module_name => l_module_name,
614: p_log_level => 5);
615: END IF;
616: PA_FP_MAINTAIN_ACTUAL_PUB.SYNC_UP_PLANNING_DATES

Line 616: PA_FP_MAINTAIN_ACTUAL_PUB.SYNC_UP_PLANNING_DATES

612: pa_fp_maintain_actual_pub.sync_up_planning_dates',
613: p_module_name => l_module_name,
614: p_log_level => 5);
615: END IF;
616: PA_FP_MAINTAIN_ACTUAL_PUB.SYNC_UP_PLANNING_DATES
617: (P_BUDGET_VERSION_ID => l_bv_id_tab(jj),
618: P_CALLING_CONTEXT => 'SYNC_VERSION_LEVEL',
619: X_RETURN_STATUS => x_return_Status,
620: X_MSG_COUNT => x_msg_count,

Line 626: pa_fp_maintain_actual_pub.sync_up_planning_dates'

622: IF p_pa_debug_mode = 'Y' THEN
623: pa_fp_gen_amount_utils.fp_debug
624: (p_called_mode => p_calling_mode,
625: p_msg => 'Status after calling
626: pa_fp_maintain_actual_pub.sync_up_planning_dates'
627: ||x_return_status,
628: p_module_name => l_module_name,
629: p_log_level => 5);
630: END IF;

Line 683: ( p_pkg_name => 'PA_FP_MAINTAIN_ACTUAL_PUB',

679: x_msg_count := 1;
680: x_msg_data := substr(sqlerrm,1,240);
681: -- dbms_output.put_line('error msg :'||x_msg_data);
682: FND_MSG_PUB.add_exc_msg
683: ( p_pkg_name => 'PA_FP_MAINTAIN_ACTUAL_PUB',
684: p_procedure_name => 'MAINTAIN_ACTUAL_AMT_WRP',
685: p_error_text => substr(sqlerrm,1,240));
686: IF P_PA_DEBUG_MODE = 'Y' THEN
687: pa_fp_gen_amount_utils.fp_debug

Line 714: 'pa.plsql.pa_fp_maintain_actual_pub.upd_reporting_lines_wrp';

710: ,x_msg_data OUT NOCOPY Varchar2
711: ,x_msg_count OUT NOCOPY Number
712: ,x_return_status OUT NOCOPY Varchar2) IS
713: l_module_name VARCHAR2(200) :=
714: 'pa.plsql.pa_fp_maintain_actual_pub.upd_reporting_lines_wrp';
715: l_count NUMBER;
716: l_msg_count NUMBER;
717: l_cnt NUMBER;
718: l_data VARCHAR2(2000);

Line 813: ( p_pkg_name => 'PA_FP_MAINTAIN_ACTUAL_PUB',

809: x_msg_count := 1;
810: x_msg_data := substr(sqlerrm,1,240);
811: -- dbms_output.put_line('error msg :'||x_msg_data);
812: FND_MSG_PUB.add_exc_msg
813: ( p_pkg_name => 'PA_FP_MAINTAIN_ACTUAL_PUB',
814: p_procedure_name => 'UPD_REPORTING_LINES_WRP',
815: p_error_text => substr(sqlerrm,1,240));
816: IF P_PA_DEBUG_MODE = 'Y' THEN
817: pa_fp_gen_amount_utils.fp_debug

Line 863: P_AMT_DTLS_REC_TAB IN PA_FP_MAINTAIN_ACTUAL_PUB.l_amt_dtls_tbl_typ,

859: (P_PROJECT_ID IN PA_PROJ_FP_OPTIONS.PROJECT_ID%TYPE,
860: P_BUDGET_VERSION_ID IN PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE,
861: P_RESOURCE_ASSIGNMENT_ID IN PA_RESOURCE_ASSIGNMENTS.RESOURCE_ASSIGNMENT_ID%TYPE,
862: P_TXN_CURRENCY_CODE IN PA_BUDGET_LINES.TXN_CURRENCY_CODE%TYPE,
863: P_AMT_DTLS_REC_TAB IN PA_FP_MAINTAIN_ACTUAL_PUB.l_amt_dtls_tbl_typ,
864: P_CALLING_CONTEXT IN VARCHAR2,
865: P_TXN_AMT_TYPE_CODE IN VARCHAR2,
866: P_CALLING_MODE IN VARCHAR2,
867: P_EXTRACTION_TYPE IN VARCHAR2,

Line 874: l_module_name VARCHAR2(200) := 'pa.plsql.pa_fp_maintain_actual_pub.maintain_actual_amt_ra';

870: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
871: X_MSG_COUNT OUT NOCOPY NUMBER,
872: X_MSG_DATA OUT NOCOPY VARCHAR2) IS
873:
874: l_module_name VARCHAR2(200) := 'pa.plsql.pa_fp_maintain_actual_pub.maintain_actual_amt_ra';
875: l_period_name_tab PA_PLSQL_DATATYPES.Char30TabTyp;
876: l_start_date_tab PA_PLSQL_DATATYPES.DateTabTyp;
877: l_end_date_tab PA_PLSQL_DATATYPES.DateTabTyp;
878: l_txn_raw_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;

Line 2497: ( p_pkg_name => 'PA_FP_MAINTAIN_ACTUAL_PUB',

2493: x_msg_count := 1;
2494: x_msg_data := substr(sqlerrm,1,240);
2495: -- dbms_output.put_line('error msg :'||x_msg_data);
2496: FND_MSG_PUB.add_exc_msg
2497: ( p_pkg_name => 'PA_FP_MAINTAIN_ACTUAL_PUB',
2498: p_procedure_name => 'MAINTAIN_ACTUAL_AMT_RA',
2499: p_error_text => substr(sqlerrm,1,240));
2500: IF P_PA_DEBUG_MODE = 'Y' THEN
2501: pa_fp_gen_amount_utils.fp_debug

Line 2562: l_module_name VARCHAR2(200) := 'pa.plsql.pa_fp_maintain_actual_pub.sync_up_planning_dates';

2558: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
2559: X_MSG_COUNT OUT NOCOPY NUMBER,
2560: X_MSG_DATA OUT NOCOPY VARCHAR2) IS
2561:
2562: l_module_name VARCHAR2(200) := 'pa.plsql.pa_fp_maintain_actual_pub.sync_up_planning_dates';
2563:
2564: l_fp_cols_rec PA_FP_GEN_AMOUNT_UTILS.FP_COLS;
2565:
2566: /* Cursors for Version Level sync by target time phase */

Line 3107: ( p_pkg_name => 'PA_FP_MAINTAIN_ACTUAL_PUB',

3103: x_msg_count := 1;
3104: x_msg_data := substr(sqlerrm,1,240);
3105: -- dbms_output.put_line('error msg :'||x_msg_data);
3106: FND_MSG_PUB.add_exc_msg
3107: ( p_pkg_name => 'PA_FP_MAINTAIN_ACTUAL_PUB',
3108: p_procedure_name => 'SYNC_UP_PLANNING_DATES',
3109: p_error_text => substr(sqlerrm,1,240));
3110: IF P_PA_DEBUG_MODE = 'Y' THEN
3111: pa_fp_gen_amount_utils.fp_debug

Line 3140: l_module_name VARCHAR2(200) := 'pa.plsql.pa_fp_maintain_actual_pub.blk_upd_reporting_lines_wrp';

3136: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
3137: X_MSG_COUNT OUT NOCOPY NUMBER,
3138: X_MSG_DATA OUT NOCOPY VARCHAR2) IS
3139:
3140: l_module_name VARCHAR2(200) := 'pa.plsql.pa_fp_maintain_actual_pub.blk_upd_reporting_lines_wrp';
3141:
3142: l_rep_budget_line_id_tab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
3143: l_rep_res_assignment_id_tab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
3144: l_rep_start_date_tab SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();

Line 3525: ( p_pkg_name => 'PA_FP_MAINTAIN_ACTUAL_PUB',

3521: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3522: x_msg_count := 1;
3523: x_msg_data := substr(sqlerrm,1,240);
3524: FND_MSG_PUB.add_exc_msg
3525: ( p_pkg_name => 'PA_FP_MAINTAIN_ACTUAL_PUB',
3526: p_procedure_name => 'BLK_UPD_REPORTING_LINES_WRP',
3527: p_error_text => substr(sqlerrm,1,240));
3528: IF P_PA_DEBUG_MODE = 'Y' THEN
3529: pa_fp_gen_amount_utils.fp_debug

Line 3546: l_module_name VARCHAR2(200) := 'pa.plsql.pa_fp_maintain_actual_pub.SYNC_UP_PLANNING_DATES_NONE_TP';

3542: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
3543: X_MSG_COUNT OUT NOCOPY NUMBER,
3544: X_MSG_DATA OUT NOCOPY VARCHAR2) IS
3545:
3546: l_module_name VARCHAR2(200) := 'pa.plsql.pa_fp_maintain_actual_pub.SYNC_UP_PLANNING_DATES_NONE_TP';
3547:
3548: l_res_asg_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
3549: l_planning_start_date_tab pa_plsql_datatypes.DateTabTyp;
3550: l_planning_end_date_tab pa_plsql_datatypes.DateTabTyp;

Line 3697: ( p_pkg_name => 'PA_FP_MAINTAIN_ACTUAL_PUB',

3693: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3694: x_msg_count := 1;
3695: x_msg_data := substr(sqlerrm,1,240);
3696: FND_MSG_PUB.add_exc_msg
3697: ( p_pkg_name => 'PA_FP_MAINTAIN_ACTUAL_PUB',
3698: p_procedure_name => 'SYNC_UP_PLANNING_DATES_NONE_TP',
3699: p_error_text => substr(sqlerrm,1,240));
3700: IF P_PA_DEBUG_MODE = 'Y' THEN
3701: pa_fp_gen_amount_utils.fp_debug

Line 3712: END PA_FP_MAINTAIN_ACTUAL_PUB;

3708:
3709: END SYNC_UP_PLANNING_DATES_NONE_TP;
3710:
3711:
3712: END PA_FP_MAINTAIN_ACTUAL_PUB;