DBA Data[Home] [Help]

APPS.PA_PROJ_ACCUM_MAIN dependencies on FND_GLOBAL

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

3591: BEGIN
3592:
3593: DELETE FROM pa_commitment_txns_tmp;
3594:
3595: x_last_updated_by := NVL(FND_GLOBAL.USER_ID,-1);
3596: x_last_update_date := NVL(FND_GLOBAL.USER_ID,-1);
3597: x_created_by := NVL(FND_GLOBAL.USER_ID,-1);
3598: x_last_update_login := NVL(FND_GLOBAL.LOGIN_ID,-1);
3599: x_request_id := NVL(FND_GLOBAL.CONC_REQUEST_ID,-1);

Line 3596: x_last_update_date := NVL(FND_GLOBAL.USER_ID,-1);

3592:
3593: DELETE FROM pa_commitment_txns_tmp;
3594:
3595: x_last_updated_by := NVL(FND_GLOBAL.USER_ID,-1);
3596: x_last_update_date := NVL(FND_GLOBAL.USER_ID,-1);
3597: x_created_by := NVL(FND_GLOBAL.USER_ID,-1);
3598: x_last_update_login := NVL(FND_GLOBAL.LOGIN_ID,-1);
3599: x_request_id := NVL(FND_GLOBAL.CONC_REQUEST_ID,-1);
3600: x_program_application_id := NVL(FND_GLOBAL.PROG_APPL_ID,-1);

Line 3597: x_created_by := NVL(FND_GLOBAL.USER_ID,-1);

3593: DELETE FROM pa_commitment_txns_tmp;
3594:
3595: x_last_updated_by := NVL(FND_GLOBAL.USER_ID,-1);
3596: x_last_update_date := NVL(FND_GLOBAL.USER_ID,-1);
3597: x_created_by := NVL(FND_GLOBAL.USER_ID,-1);
3598: x_last_update_login := NVL(FND_GLOBAL.LOGIN_ID,-1);
3599: x_request_id := NVL(FND_GLOBAL.CONC_REQUEST_ID,-1);
3600: x_program_application_id := NVL(FND_GLOBAL.PROG_APPL_ID,-1);
3601: x_program_id := NVL(FND_GLOBAL.CONC_PROGRAM_ID,-1);

Line 3598: x_last_update_login := NVL(FND_GLOBAL.LOGIN_ID,-1);

3594:
3595: x_last_updated_by := NVL(FND_GLOBAL.USER_ID,-1);
3596: x_last_update_date := NVL(FND_GLOBAL.USER_ID,-1);
3597: x_created_by := NVL(FND_GLOBAL.USER_ID,-1);
3598: x_last_update_login := NVL(FND_GLOBAL.LOGIN_ID,-1);
3599: x_request_id := NVL(FND_GLOBAL.CONC_REQUEST_ID,-1);
3600: x_program_application_id := NVL(FND_GLOBAL.PROG_APPL_ID,-1);
3601: x_program_id := NVL(FND_GLOBAL.CONC_PROGRAM_ID,-1);
3602:

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

3595: x_last_updated_by := NVL(FND_GLOBAL.USER_ID,-1);
3596: x_last_update_date := NVL(FND_GLOBAL.USER_ID,-1);
3597: x_created_by := NVL(FND_GLOBAL.USER_ID,-1);
3598: x_last_update_login := NVL(FND_GLOBAL.LOGIN_ID,-1);
3599: x_request_id := NVL(FND_GLOBAL.CONC_REQUEST_ID,-1);
3600: x_program_application_id := NVL(FND_GLOBAL.PROG_APPL_ID,-1);
3601: x_program_id := NVL(FND_GLOBAL.CONC_PROGRAM_ID,-1);
3602:
3603: l_sql := NULL;

Line 3600: x_program_application_id := NVL(FND_GLOBAL.PROG_APPL_ID,-1);

3596: x_last_update_date := NVL(FND_GLOBAL.USER_ID,-1);
3597: x_created_by := NVL(FND_GLOBAL.USER_ID,-1);
3598: x_last_update_login := NVL(FND_GLOBAL.LOGIN_ID,-1);
3599: x_request_id := NVL(FND_GLOBAL.CONC_REQUEST_ID,-1);
3600: x_program_application_id := NVL(FND_GLOBAL.PROG_APPL_ID,-1);
3601: x_program_id := NVL(FND_GLOBAL.CONC_PROGRAM_ID,-1);
3602:
3603: l_sql := NULL;
3604: l_proj_id_condition := NULL;

Line 3601: x_program_id := NVL(FND_GLOBAL.CONC_PROGRAM_ID,-1);

3597: x_created_by := NVL(FND_GLOBAL.USER_ID,-1);
3598: x_last_update_login := NVL(FND_GLOBAL.LOGIN_ID,-1);
3599: x_request_id := NVL(FND_GLOBAL.CONC_REQUEST_ID,-1);
3600: x_program_application_id := NVL(FND_GLOBAL.PROG_APPL_ID,-1);
3601: x_program_id := NVL(FND_GLOBAL.CONC_PROGRAM_ID,-1);
3602:
3603: l_sql := NULL;
3604: l_proj_id_condition := NULL;
3605:

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

3832: DELETE FROM pa_pjm_po_commitments_tmp; /* Bug 6408874 */
3833: DELETE FROM pa_pjm_req_commitments_tmp; /* Bug 6408874 */
3834: -- DELETE FROM pa_fp_ra_map_tmp;
3835:
3836: x_last_updated_by := NVL(FND_GLOBAL.USER_ID,-1);
3837: x_last_update_date := NVL(FND_GLOBAL.USER_ID,-1);
3838: x_created_by := NVL(FND_GLOBAL.USER_ID,-1);
3839: x_last_update_login := NVL(FND_GLOBAL.LOGIN_ID,-1);
3840: x_request_id := NVL(FND_GLOBAL.CONC_REQUEST_ID,-1);

Line 3837: x_last_update_date := NVL(FND_GLOBAL.USER_ID,-1);

3833: DELETE FROM pa_pjm_req_commitments_tmp; /* Bug 6408874 */
3834: -- DELETE FROM pa_fp_ra_map_tmp;
3835:
3836: x_last_updated_by := NVL(FND_GLOBAL.USER_ID,-1);
3837: x_last_update_date := NVL(FND_GLOBAL.USER_ID,-1);
3838: x_created_by := NVL(FND_GLOBAL.USER_ID,-1);
3839: x_last_update_login := NVL(FND_GLOBAL.LOGIN_ID,-1);
3840: x_request_id := NVL(FND_GLOBAL.CONC_REQUEST_ID,-1);
3841: x_program_application_id := NVL(FND_GLOBAL.PROG_APPL_ID,-1);

Line 3838: x_created_by := NVL(FND_GLOBAL.USER_ID,-1);

3834: -- DELETE FROM pa_fp_ra_map_tmp;
3835:
3836: x_last_updated_by := NVL(FND_GLOBAL.USER_ID,-1);
3837: x_last_update_date := NVL(FND_GLOBAL.USER_ID,-1);
3838: x_created_by := NVL(FND_GLOBAL.USER_ID,-1);
3839: x_last_update_login := NVL(FND_GLOBAL.LOGIN_ID,-1);
3840: x_request_id := NVL(FND_GLOBAL.CONC_REQUEST_ID,-1);
3841: x_program_application_id := NVL(FND_GLOBAL.PROG_APPL_ID,-1);
3842: x_program_id := NVL(FND_GLOBAL.CONC_PROGRAM_ID,-1);

Line 3839: x_last_update_login := NVL(FND_GLOBAL.LOGIN_ID,-1);

3835:
3836: x_last_updated_by := NVL(FND_GLOBAL.USER_ID,-1);
3837: x_last_update_date := NVL(FND_GLOBAL.USER_ID,-1);
3838: x_created_by := NVL(FND_GLOBAL.USER_ID,-1);
3839: x_last_update_login := NVL(FND_GLOBAL.LOGIN_ID,-1);
3840: x_request_id := NVL(FND_GLOBAL.CONC_REQUEST_ID,-1);
3841: x_program_application_id := NVL(FND_GLOBAL.PROG_APPL_ID,-1);
3842: x_program_id := NVL(FND_GLOBAL.CONC_PROGRAM_ID,-1);
3843:

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

3836: x_last_updated_by := NVL(FND_GLOBAL.USER_ID,-1);
3837: x_last_update_date := NVL(FND_GLOBAL.USER_ID,-1);
3838: x_created_by := NVL(FND_GLOBAL.USER_ID,-1);
3839: x_last_update_login := NVL(FND_GLOBAL.LOGIN_ID,-1);
3840: x_request_id := NVL(FND_GLOBAL.CONC_REQUEST_ID,-1);
3841: x_program_application_id := NVL(FND_GLOBAL.PROG_APPL_ID,-1);
3842: x_program_id := NVL(FND_GLOBAL.CONC_PROGRAM_ID,-1);
3843:
3844: l_sql := NULL;

Line 3841: x_program_application_id := NVL(FND_GLOBAL.PROG_APPL_ID,-1);

3837: x_last_update_date := NVL(FND_GLOBAL.USER_ID,-1);
3838: x_created_by := NVL(FND_GLOBAL.USER_ID,-1);
3839: x_last_update_login := NVL(FND_GLOBAL.LOGIN_ID,-1);
3840: x_request_id := NVL(FND_GLOBAL.CONC_REQUEST_ID,-1);
3841: x_program_application_id := NVL(FND_GLOBAL.PROG_APPL_ID,-1);
3842: x_program_id := NVL(FND_GLOBAL.CONC_PROGRAM_ID,-1);
3843:
3844: l_sql := NULL;
3845: l_proj_id_condition := NULL;

Line 3842: x_program_id := NVL(FND_GLOBAL.CONC_PROGRAM_ID,-1);

3838: x_created_by := NVL(FND_GLOBAL.USER_ID,-1);
3839: x_last_update_login := NVL(FND_GLOBAL.LOGIN_ID,-1);
3840: x_request_id := NVL(FND_GLOBAL.CONC_REQUEST_ID,-1);
3841: x_program_application_id := NVL(FND_GLOBAL.PROG_APPL_ID,-1);
3842: x_program_id := NVL(FND_GLOBAL.CONC_PROGRAM_ID,-1);
3843:
3844: l_sql := NULL;
3845: l_proj_id_condition := NULL;
3846: