3654: BEGIN
3655:
3656: DELETE FROM pa_commitment_txns_tmp;
3657:
3658: x_last_updated_by := NVL(FND_GLOBAL.USER_ID,-1);
3659: x_last_update_date := NVL(FND_GLOBAL.USER_ID,-1);
3660: x_created_by := NVL(FND_GLOBAL.USER_ID,-1);
3661: x_last_update_login := NVL(FND_GLOBAL.LOGIN_ID,-1);
3662: x_request_id := NVL(FND_GLOBAL.CONC_REQUEST_ID,-1);
3655:
3656: DELETE FROM pa_commitment_txns_tmp;
3657:
3658: x_last_updated_by := NVL(FND_GLOBAL.USER_ID,-1);
3659: x_last_update_date := NVL(FND_GLOBAL.USER_ID,-1);
3660: x_created_by := NVL(FND_GLOBAL.USER_ID,-1);
3661: x_last_update_login := NVL(FND_GLOBAL.LOGIN_ID,-1);
3662: x_request_id := NVL(FND_GLOBAL.CONC_REQUEST_ID,-1);
3663: x_program_application_id := NVL(FND_GLOBAL.PROG_APPL_ID,-1);
3656: DELETE FROM pa_commitment_txns_tmp;
3657:
3658: x_last_updated_by := NVL(FND_GLOBAL.USER_ID,-1);
3659: x_last_update_date := NVL(FND_GLOBAL.USER_ID,-1);
3660: x_created_by := NVL(FND_GLOBAL.USER_ID,-1);
3661: x_last_update_login := NVL(FND_GLOBAL.LOGIN_ID,-1);
3662: x_request_id := NVL(FND_GLOBAL.CONC_REQUEST_ID,-1);
3663: x_program_application_id := NVL(FND_GLOBAL.PROG_APPL_ID,-1);
3664: x_program_id := NVL(FND_GLOBAL.CONC_PROGRAM_ID,-1);
3657:
3658: x_last_updated_by := NVL(FND_GLOBAL.USER_ID,-1);
3659: x_last_update_date := NVL(FND_GLOBAL.USER_ID,-1);
3660: x_created_by := NVL(FND_GLOBAL.USER_ID,-1);
3661: x_last_update_login := NVL(FND_GLOBAL.LOGIN_ID,-1);
3662: x_request_id := NVL(FND_GLOBAL.CONC_REQUEST_ID,-1);
3663: x_program_application_id := NVL(FND_GLOBAL.PROG_APPL_ID,-1);
3664: x_program_id := NVL(FND_GLOBAL.CONC_PROGRAM_ID,-1);
3665:
3658: x_last_updated_by := NVL(FND_GLOBAL.USER_ID,-1);
3659: x_last_update_date := NVL(FND_GLOBAL.USER_ID,-1);
3660: x_created_by := NVL(FND_GLOBAL.USER_ID,-1);
3661: x_last_update_login := NVL(FND_GLOBAL.LOGIN_ID,-1);
3662: x_request_id := NVL(FND_GLOBAL.CONC_REQUEST_ID,-1);
3663: x_program_application_id := NVL(FND_GLOBAL.PROG_APPL_ID,-1);
3664: x_program_id := NVL(FND_GLOBAL.CONC_PROGRAM_ID,-1);
3665:
3666: l_sql := NULL;
3659: x_last_update_date := NVL(FND_GLOBAL.USER_ID,-1);
3660: x_created_by := NVL(FND_GLOBAL.USER_ID,-1);
3661: x_last_update_login := NVL(FND_GLOBAL.LOGIN_ID,-1);
3662: x_request_id := NVL(FND_GLOBAL.CONC_REQUEST_ID,-1);
3663: x_program_application_id := NVL(FND_GLOBAL.PROG_APPL_ID,-1);
3664: x_program_id := NVL(FND_GLOBAL.CONC_PROGRAM_ID,-1);
3665:
3666: l_sql := NULL;
3667: l_proj_id_condition := NULL;
3660: x_created_by := NVL(FND_GLOBAL.USER_ID,-1);
3661: x_last_update_login := NVL(FND_GLOBAL.LOGIN_ID,-1);
3662: x_request_id := NVL(FND_GLOBAL.CONC_REQUEST_ID,-1);
3663: x_program_application_id := NVL(FND_GLOBAL.PROG_APPL_ID,-1);
3664: x_program_id := NVL(FND_GLOBAL.CONC_PROGRAM_ID,-1);
3665:
3666: l_sql := NULL;
3667: l_proj_id_condition := NULL;
3668:
3898: DELETE FROM pa_pjm_req_commitments_tmp; /* Bug 6408874 */
3899: DELETE FROM pa_proj_summ_tmp; -- BUG 10107257 Addition of DELETE
3900: -- DELETE FROM pa_fp_ra_map_tmp;
3901:
3902: x_last_updated_by := NVL(FND_GLOBAL.USER_ID,-1);
3903: x_last_update_date := NVL(FND_GLOBAL.USER_ID,-1);
3904: x_created_by := NVL(FND_GLOBAL.USER_ID,-1);
3905: x_last_update_login := NVL(FND_GLOBAL.LOGIN_ID,-1);
3906: x_request_id := NVL(FND_GLOBAL.CONC_REQUEST_ID,-1);
3899: DELETE FROM pa_proj_summ_tmp; -- BUG 10107257 Addition of DELETE
3900: -- DELETE FROM pa_fp_ra_map_tmp;
3901:
3902: x_last_updated_by := NVL(FND_GLOBAL.USER_ID,-1);
3903: x_last_update_date := NVL(FND_GLOBAL.USER_ID,-1);
3904: x_created_by := NVL(FND_GLOBAL.USER_ID,-1);
3905: x_last_update_login := NVL(FND_GLOBAL.LOGIN_ID,-1);
3906: x_request_id := NVL(FND_GLOBAL.CONC_REQUEST_ID,-1);
3907: x_program_application_id := NVL(FND_GLOBAL.PROG_APPL_ID,-1);
3900: -- DELETE FROM pa_fp_ra_map_tmp;
3901:
3902: x_last_updated_by := NVL(FND_GLOBAL.USER_ID,-1);
3903: x_last_update_date := NVL(FND_GLOBAL.USER_ID,-1);
3904: x_created_by := NVL(FND_GLOBAL.USER_ID,-1);
3905: x_last_update_login := NVL(FND_GLOBAL.LOGIN_ID,-1);
3906: x_request_id := NVL(FND_GLOBAL.CONC_REQUEST_ID,-1);
3907: x_program_application_id := NVL(FND_GLOBAL.PROG_APPL_ID,-1);
3908: x_program_id := NVL(FND_GLOBAL.CONC_PROGRAM_ID,-1);
3901:
3902: x_last_updated_by := NVL(FND_GLOBAL.USER_ID,-1);
3903: x_last_update_date := NVL(FND_GLOBAL.USER_ID,-1);
3904: x_created_by := NVL(FND_GLOBAL.USER_ID,-1);
3905: x_last_update_login := NVL(FND_GLOBAL.LOGIN_ID,-1);
3906: x_request_id := NVL(FND_GLOBAL.CONC_REQUEST_ID,-1);
3907: x_program_application_id := NVL(FND_GLOBAL.PROG_APPL_ID,-1);
3908: x_program_id := NVL(FND_GLOBAL.CONC_PROGRAM_ID,-1);
3909:
3902: x_last_updated_by := NVL(FND_GLOBAL.USER_ID,-1);
3903: x_last_update_date := NVL(FND_GLOBAL.USER_ID,-1);
3904: x_created_by := NVL(FND_GLOBAL.USER_ID,-1);
3905: x_last_update_login := NVL(FND_GLOBAL.LOGIN_ID,-1);
3906: x_request_id := NVL(FND_GLOBAL.CONC_REQUEST_ID,-1);
3907: x_program_application_id := NVL(FND_GLOBAL.PROG_APPL_ID,-1);
3908: x_program_id := NVL(FND_GLOBAL.CONC_PROGRAM_ID,-1);
3909:
3910: l_sql := NULL;
3903: x_last_update_date := NVL(FND_GLOBAL.USER_ID,-1);
3904: x_created_by := NVL(FND_GLOBAL.USER_ID,-1);
3905: x_last_update_login := NVL(FND_GLOBAL.LOGIN_ID,-1);
3906: x_request_id := NVL(FND_GLOBAL.CONC_REQUEST_ID,-1);
3907: x_program_application_id := NVL(FND_GLOBAL.PROG_APPL_ID,-1);
3908: x_program_id := NVL(FND_GLOBAL.CONC_PROGRAM_ID,-1);
3909:
3910: l_sql := NULL;
3911: l_proj_id_condition := NULL;
3904: x_created_by := NVL(FND_GLOBAL.USER_ID,-1);
3905: x_last_update_login := NVL(FND_GLOBAL.LOGIN_ID,-1);
3906: x_request_id := NVL(FND_GLOBAL.CONC_REQUEST_ID,-1);
3907: x_program_application_id := NVL(FND_GLOBAL.PROG_APPL_ID,-1);
3908: x_program_id := NVL(FND_GLOBAL.CONC_PROGRAM_ID,-1);
3909:
3910: l_sql := NULL;
3911: l_proj_id_condition := NULL;
3912: