APPS.PA_PROGRESS_REPORT_PVT dependencies on FND_GLOBAL

Line 3305: usr.user_id = fnd_global.user_id

3301: select usr.employee_id
3302: from
3303: fnd_user usr
3304: WHERE
3305: usr.user_id = fnd_global.user_id
3306: and trunc(sysdate) between USR.START_DATE and nvl(USR.END_DATE, sysdate+1);
3307:
3308: /*CURSOR get_resource_id
3309: IS

Line 3312: where user_id = fnd_global.user_id;*/

3308: /*CURSOR get_resource_id
3309: IS
3310: select resource_id
3311: from pa_project_parties_v
3312: where user_id = fnd_global.user_id;*/
3313:
3314: l_mgr_id number;
3315: l_overview VARCHAR2(240);
3316: l_person_id NUMBER;

Line 3429: --debug_msg('*********before insert: reported by ' || To_char(fnd_global.user_id));

3425:
3426: IF (p_validate_only <>FND_API.g_true AND x_return_status = FND_API.g_ret_sts_success) THEN
3427:
3428:
3429: --debug_msg('*********before insert: reported by ' || To_char(fnd_global.user_id));
3430:
3431: /* Get the Reported by Person Id
3432:
3433: OPEN get_person_id;

Line 3440: l_person_id := pa_resource_utils.get_resource_id(p_user_id => FND_GLOBAL.user_id);

3436:
3437: ------OPEN get_resource_id;
3438: ------FETCH get_resource_id INTO l_person_id;
3439: ------CLOSE get_resource_id;
3440: l_person_id := pa_resource_utils.get_resource_id(p_user_id => FND_GLOBAL.user_id);
3441:
3442: --debug_msg ('l_person_id' || To_char(l_person_id));
3443: pa_progress_report_pkg.insert_PROGRESS_REPORT_ver_row
3444: (

Line 3454: --fnd_global.user_id ,

3450:
3451: Trunc(l_report_start_date) ,
3452: Trunc(l_report_end_date) ,
3453:
3454: --fnd_global.user_id ,
3455: l_person_id,
3456: 'PROGRESS_STAT_ON_TRACK',
3457: --'PROGRESS_STAT_NOT_STARTED',
3458: l_overview,

Line 3822: fnd_global.user_id,

3818: l_percent_complete,
3819: l_asof_date,
3820: NULL,
3821: Sysdate,
3822: fnd_global.user_id,
3823: Sysdate,
3824: fnd_global.user_id,
3825: fnd_global.user_id,
3826: x_return_status,

Line 3824: fnd_global.user_id,

3820: NULL,
3821: Sysdate,
3822: fnd_global.user_id,
3823: Sysdate,
3824: fnd_global.user_id,
3825: fnd_global.user_id,
3826: x_return_status,
3827: x_msg_data
3828: );

Line 3825: fnd_global.user_id,

3821: Sysdate,
3822: fnd_global.user_id,
3823: Sysdate,
3824: fnd_global.user_id,
3825: fnd_global.user_id,
3826: x_return_status,
3827: x_msg_data
3828: );
3829: