DBA Data[Home] [Help]

APPS.PA_PROGRESS_REPORT_PVT dependencies on FND_GLOBAL

Line 3306: usr.user_id = fnd_global.user_id

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

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

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

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

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

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

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

Line 3455: --fnd_global.user_id ,

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

Line 3823: fnd_global.user_id,

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

Line 3825: fnd_global.user_id,

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

Line 3826: fnd_global.user_id,

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