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 1125: , TO_NUMBER(FND_GLOBAL.USER_ID)

1121: , sysdate
1122: , TO_NUMBER(FND_PROFILE.VALUE('USER_ID'))
1123: , TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID'))
1124: End of Comment, added next 4 lines */
1125: , TO_NUMBER(FND_GLOBAL.USER_ID)
1126: , sysdate
1127: , TO_NUMBER(FND_GLOBAL.USER_ID)
1128: , TO_NUMBER(FND_GLOBAL.LOGIN_ID)
1129: , p_person_type

Line 1127: , TO_NUMBER(FND_GLOBAL.USER_ID)

1123: , TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID'))
1124: End of Comment, added next 4 lines */
1125: , TO_NUMBER(FND_GLOBAL.USER_ID)
1126: , sysdate
1127: , TO_NUMBER(FND_GLOBAL.USER_ID)
1128: , TO_NUMBER(FND_GLOBAL.LOGIN_ID)
1129: , p_person_type
1130: FROM dual;
1131: --end null location

Line 1128: , TO_NUMBER(FND_GLOBAL.LOGIN_ID)

1124: End of Comment, added next 4 lines */
1125: , TO_NUMBER(FND_GLOBAL.USER_ID)
1126: , sysdate
1127: , TO_NUMBER(FND_GLOBAL.USER_ID)
1128: , TO_NUMBER(FND_GLOBAL.LOGIN_ID)
1129: , p_person_type
1130: FROM dual;
1131: --end null location
1132: END IF;

Line 1246: , TO_NUMBER(FND_GLOBAL.USER_ID)

1242: , sysdate
1243: , TO_NUMBER(FND_PROFILE.VALUE('USER_ID'))
1244: , TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID'))
1245: End of Comment, added next 4 lines */
1246: , TO_NUMBER(FND_GLOBAL.USER_ID)
1247: , sysdate
1248: , TO_NUMBER(FND_GLOBAL.USER_ID)
1249: , TO_NUMBER(FND_GLOBAL.LOGIN_ID)
1250: , p_person_type

Line 1248: , TO_NUMBER(FND_GLOBAL.USER_ID)

1244: , TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID'))
1245: End of Comment, added next 4 lines */
1246: , TO_NUMBER(FND_GLOBAL.USER_ID)
1247: , sysdate
1248: , TO_NUMBER(FND_GLOBAL.USER_ID)
1249: , TO_NUMBER(FND_GLOBAL.LOGIN_ID)
1250: , p_person_type
1251: FROM dual;
1252: END LOOP;

Line 1249: , TO_NUMBER(FND_GLOBAL.LOGIN_ID)

1245: End of Comment, added next 4 lines */
1246: , TO_NUMBER(FND_GLOBAL.USER_ID)
1247: , sysdate
1248: , TO_NUMBER(FND_GLOBAL.USER_ID)
1249: , TO_NUMBER(FND_GLOBAL.LOGIN_ID)
1250: , p_person_type
1251: FROM dual;
1252: END LOOP;
1253:

Line 1736: l_created_by := fnd_global.user_id;

1732:
1733: -- Initialize the return status to success
1734: x_return_status := FND_API.G_RET_STS_SUCCESS;
1735:
1736: l_created_by := fnd_global.user_id;
1737: l_last_updated_by := fnd_global.user_id;
1738: l_last_update_login := fnd_global.login_id;
1739:
1740: -- commented out for perf bug 4930256

Line 1737: l_last_updated_by := fnd_global.user_id;

1733: -- Initialize the return status to success
1734: x_return_status := FND_API.G_RET_STS_SUCCESS;
1735:
1736: l_created_by := fnd_global.user_id;
1737: l_last_updated_by := fnd_global.user_id;
1738: l_last_update_login := fnd_global.login_id;
1739:
1740: -- commented out for perf bug 4930256
1741: -- l_profile := FND_PROFILE.VALUE_SPECIFIC('PA_AVAILABILITY_CAL_PERIOD');

Line 1738: l_last_update_login := fnd_global.login_id;

1734: x_return_status := FND_API.G_RET_STS_SUCCESS;
1735:
1736: l_created_by := fnd_global.user_id;
1737: l_last_updated_by := fnd_global.user_id;
1738: l_last_update_login := fnd_global.login_id;
1739:
1740: -- commented out for perf bug 4930256
1741: -- l_profile := FND_PROFILE.VALUE_SPECIFIC('PA_AVAILABILITY_CAL_PERIOD');
1742: