eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PA_RESOURCE_PVT dependencies on FND_GLOBAL

Line 374: fnd_global.user_id, -- CREATED_BY

370: null, -- PROGRAM_APPLICATION_ID
371: null, -- PROGRAM_ID
372: null, -- PROGRAM_UPDATE_DATE
373: sysdate, -- CREATION_DATE
374: fnd_global.user_id, -- CREATED_BY
375: sysdate, -- LAST_UPDATE_DATE
376: fnd_global.user_id, -- LAST_UPDATED_BY
377: fnd_global.login_id -- LAST_UPDATE_LOGIN
378: -- ,l_resource_person_type

Line 376: fnd_global.user_id, -- LAST_UPDATED_BY

372: null, -- PROGRAM_UPDATE_DATE
373: sysdate, -- CREATION_DATE
374: fnd_global.user_id, -- CREATED_BY
375: sysdate, -- LAST_UPDATE_DATE
376: fnd_global.user_id, -- LAST_UPDATED_BY
377: fnd_global.login_id -- LAST_UPDATE_LOGIN
378: -- ,l_resource_person_type
379: );
380:

Line 377: fnd_global.login_id -- LAST_UPDATE_LOGIN

373: sysdate, -- CREATION_DATE
374: fnd_global.user_id, -- CREATED_BY
375: sysdate, -- LAST_UPDATE_DATE
376: fnd_global.user_id, -- LAST_UPDATED_BY
377: fnd_global.login_id -- LAST_UPDATE_LOGIN
378: -- ,l_resource_person_type
379: );
380:
381:

Line 670: LAST_UPDATED_by = fnd_global.user_id,

666: schedulable_flag,p_resource_denorm_rec.schedulable_flag),
667: resource_org_id = DECODE(p_resource_denorm_rec.resource_org_id, FND_API.G_MISS_NUM,
668: resource_org_id,p_resource_denorm_rec.resource_org_id),
669: LAST_UPDATE_date = sysdate,
670: LAST_UPDATED_by = fnd_global.user_id,
671: LAST_UPDATE_login = fnd_global.login_id
672: WHERE person_id = p_resource_denorm_rec.person_id
673: AND resource_effective_start_date = p_resource_denorm_rec.resource_effective_start_date;
674: --AND resource_effective_end_date > sysdate;

Line 671: LAST_UPDATE_login = fnd_global.login_id

667: resource_org_id = DECODE(p_resource_denorm_rec.resource_org_id, FND_API.G_MISS_NUM,
668: resource_org_id,p_resource_denorm_rec.resource_org_id),
669: LAST_UPDATE_date = sysdate,
670: LAST_UPDATED_by = fnd_global.user_id,
671: LAST_UPDATE_login = fnd_global.login_id
672: WHERE person_id = p_resource_denorm_rec.person_id
673: AND resource_effective_start_date = p_resource_denorm_rec.resource_effective_start_date;
674: --AND resource_effective_end_date > sysdate;
675:

Line 738: last_updated_by = fnd_global.user_id,

734: resource_region,p_resource_denorm_rec.resource_region),
735: resource_city = DECODE(p_resource_denorm_rec.resource_city, FND_API.G_MISS_CHAR,
736: resource_city,p_resource_denorm_rec.resource_city),
737: last_update_date = sysdate,
738: last_updated_by = fnd_global.user_id,
739: last_update_login = fnd_global.login_id
740: WHERE p_resource_denorm_rec.person_id = person_id;
741:
742: -- The following code has been commented out because resource name changes

Line 739: last_update_login = fnd_global.login_id

735: resource_city = DECODE(p_resource_denorm_rec.resource_city, FND_API.G_MISS_CHAR,
736: resource_city,p_resource_denorm_rec.resource_city),
737: last_update_date = sysdate,
738: last_updated_by = fnd_global.user_id,
739: last_update_login = fnd_global.login_id
740: WHERE p_resource_denorm_rec.person_id = person_id;
741:
742: -- The following code has been commented out because resource name changes
743: -- must be done for all resource records and not based on the system date.

Line 852: last_updated_by = fnd_global.user_id,

848: utilization_flag, p_resource_denorm_rec.utilization_flag),
849: schedulable_flag = DECODE(p_resource_denorm_rec.schedulable_flag, FND_API.G_MISS_CHAR,
850: schedulable_flag, p_resource_denorm_rec.schedulable_flag),
851: last_update_date = sysdate,
852: last_updated_by = fnd_global.user_id,
853: last_update_login = fnd_global.login_id
854: WHERE p_resource_denorm_rec.job_id = job_id
855: AND rowid between nvl(p_start_rowid, rowid)
856: and nvl(p_end_rowid, rowid);

Line 853: last_update_login = fnd_global.login_id

849: schedulable_flag = DECODE(p_resource_denorm_rec.schedulable_flag, FND_API.G_MISS_CHAR,
850: schedulable_flag, p_resource_denorm_rec.schedulable_flag),
851: last_update_date = sysdate,
852: last_updated_by = fnd_global.user_id,
853: last_update_login = fnd_global.login_id
854: WHERE p_resource_denorm_rec.job_id = job_id
855: AND rowid between nvl(p_start_rowid, rowid)
856: and nvl(p_end_rowid, rowid);
857:

Line 1218: , TO_NUMBER(FND_GLOBAL.USER_ID)

1214: , sysdate
1215: , TO_NUMBER(FND_PROFILE.VALUE('USER_ID'))
1216: , TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID'))
1217: End of Comment, added next 4 lines */
1218: , TO_NUMBER(FND_GLOBAL.USER_ID)
1219: , sysdate
1220: , TO_NUMBER(FND_GLOBAL.USER_ID)
1221: , TO_NUMBER(FND_GLOBAL.LOGIN_ID)
1222: , p_person_type

Line 1220: , TO_NUMBER(FND_GLOBAL.USER_ID)

1216: , TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID'))
1217: End of Comment, added next 4 lines */
1218: , TO_NUMBER(FND_GLOBAL.USER_ID)
1219: , sysdate
1220: , TO_NUMBER(FND_GLOBAL.USER_ID)
1221: , TO_NUMBER(FND_GLOBAL.LOGIN_ID)
1222: , p_person_type
1223: FROM dual;
1224: --end null location

Line 1221: , TO_NUMBER(FND_GLOBAL.LOGIN_ID)

1217: End of Comment, added next 4 lines */
1218: , TO_NUMBER(FND_GLOBAL.USER_ID)
1219: , sysdate
1220: , TO_NUMBER(FND_GLOBAL.USER_ID)
1221: , TO_NUMBER(FND_GLOBAL.LOGIN_ID)
1222: , p_person_type
1223: FROM dual;
1224: --end null location
1225: END IF;

Line 1339: , TO_NUMBER(FND_GLOBAL.USER_ID)

1335: , sysdate
1336: , TO_NUMBER(FND_PROFILE.VALUE('USER_ID'))
1337: , TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID'))
1338: End of Comment, added next 4 lines */
1339: , TO_NUMBER(FND_GLOBAL.USER_ID)
1340: , sysdate
1341: , TO_NUMBER(FND_GLOBAL.USER_ID)
1342: , TO_NUMBER(FND_GLOBAL.LOGIN_ID)
1343: , p_person_type

Line 1341: , TO_NUMBER(FND_GLOBAL.USER_ID)

1337: , TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID'))
1338: End of Comment, added next 4 lines */
1339: , TO_NUMBER(FND_GLOBAL.USER_ID)
1340: , sysdate
1341: , TO_NUMBER(FND_GLOBAL.USER_ID)
1342: , TO_NUMBER(FND_GLOBAL.LOGIN_ID)
1343: , p_person_type
1344: FROM dual;
1345: END LOOP;

Line 1342: , TO_NUMBER(FND_GLOBAL.LOGIN_ID)

1338: End of Comment, added next 4 lines */
1339: , TO_NUMBER(FND_GLOBAL.USER_ID)
1340: , sysdate
1341: , TO_NUMBER(FND_GLOBAL.USER_ID)
1342: , TO_NUMBER(FND_GLOBAL.LOGIN_ID)
1343: , p_person_type
1344: FROM dual;
1345: END LOOP;
1346:

Line 1835: l_created_by := fnd_global.user_id;

1831:
1832: -- Initialize the return status to success
1833: x_return_status := FND_API.G_RET_STS_SUCCESS;
1834:
1835: l_created_by := fnd_global.user_id;
1836: l_last_updated_by := fnd_global.user_id;
1837: l_last_update_login := fnd_global.login_id;
1838:
1839: -- commented out for perf bug 4930256

Line 1836: l_last_updated_by := fnd_global.user_id;

1832: -- Initialize the return status to success
1833: x_return_status := FND_API.G_RET_STS_SUCCESS;
1834:
1835: l_created_by := fnd_global.user_id;
1836: l_last_updated_by := fnd_global.user_id;
1837: l_last_update_login := fnd_global.login_id;
1838:
1839: -- commented out for perf bug 4930256
1840: -- l_profile := FND_PROFILE.VALUE_SPECIFIC('PA_AVAILABILITY_CAL_PERIOD');

Line 1837: l_last_update_login := fnd_global.login_id;

1833: x_return_status := FND_API.G_RET_STS_SUCCESS;
1834:
1835: l_created_by := fnd_global.user_id;
1836: l_last_updated_by := fnd_global.user_id;
1837: l_last_update_login := fnd_global.login_id;
1838:
1839: -- commented out for perf bug 4930256
1840: -- l_profile := FND_PROFILE.VALUE_SPECIFIC('PA_AVAILABILITY_CAL_PERIOD');
1841: