DBA Data[Home] [Help]

APPS.PA_PROJ_ACCUM_MAIN dependencies on FND_GLOBAL

Line 3658: x_last_updated_by := NVL(FND_GLOBAL.USER_ID,-1);

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);

Line 3659: x_last_update_date := NVL(FND_GLOBAL.USER_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);

Line 3660: x_created_by := NVL(FND_GLOBAL.USER_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);

Line 3661: x_last_update_login := NVL(FND_GLOBAL.LOGIN_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:

Line 3662: x_request_id := NVL(FND_GLOBAL.CONC_REQUEST_ID,-1);

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;

Line 3663: x_program_application_id := NVL(FND_GLOBAL.PROG_APPL_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;
3667: l_proj_id_condition := NULL;

Line 3664: x_program_id := NVL(FND_GLOBAL.CONC_PROGRAM_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;
3668:

Line 3902: x_last_updated_by := NVL(FND_GLOBAL.USER_ID,-1);

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);

Line 3903: x_last_update_date := NVL(FND_GLOBAL.USER_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);

Line 3904: x_created_by := NVL(FND_GLOBAL.USER_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);

Line 3905: x_last_update_login := NVL(FND_GLOBAL.LOGIN_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:

Line 3906: x_request_id := NVL(FND_GLOBAL.CONC_REQUEST_ID,-1);

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;

Line 3907: x_program_application_id := NVL(FND_GLOBAL.PROG_APPL_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;
3911: l_proj_id_condition := NULL;

Line 3908: x_program_id := NVL(FND_GLOBAL.CONC_PROGRAM_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;
3912: