DBA Data[Home] [Help]

APPS.AHL_APPR_DEPT_SHIFTS_PUB dependencies on FND_GLOBAL

Line 697: l_appr_deptshift_rec.LAST_UPDATED_BY:=fnd_global.user_id;

693: from dual;
694:
695: l_appr_deptshift_rec.OBJECT_VERSION_NUMBER:=1;
696: l_appr_deptshift_rec.LAST_UPDATE_DATE:=sysdate;
697: l_appr_deptshift_rec.LAST_UPDATED_BY:=fnd_global.user_id;
698: l_appr_deptshift_rec.CREATION_DATE:=sysdate;
699: l_appr_deptshift_rec.CREATED_BY:=fnd_global.user_id;
700: l_appr_deptshift_rec.LAST_UPDATE_LOGIN:=fnd_global.user_id;
701: l_appr_deptshift_rec.AHL_DEPARTMENT_SHIFTS_ID:=l_department_shifts_id;

Line 699: l_appr_deptshift_rec.CREATED_BY:=fnd_global.user_id;

695: l_appr_deptshift_rec.OBJECT_VERSION_NUMBER:=1;
696: l_appr_deptshift_rec.LAST_UPDATE_DATE:=sysdate;
697: l_appr_deptshift_rec.LAST_UPDATED_BY:=fnd_global.user_id;
698: l_appr_deptshift_rec.CREATION_DATE:=sysdate;
699: l_appr_deptshift_rec.CREATED_BY:=fnd_global.user_id;
700: l_appr_deptshift_rec.LAST_UPDATE_LOGIN:=fnd_global.user_id;
701: l_appr_deptshift_rec.AHL_DEPARTMENT_SHIFTS_ID:=l_department_shifts_id;
702:
703: INSERT INTO AHL_DEPARTMENT_SHIFTS

Line 700: l_appr_deptshift_rec.LAST_UPDATE_LOGIN:=fnd_global.user_id;

696: l_appr_deptshift_rec.LAST_UPDATE_DATE:=sysdate;
697: l_appr_deptshift_rec.LAST_UPDATED_BY:=fnd_global.user_id;
698: l_appr_deptshift_rec.CREATION_DATE:=sysdate;
699: l_appr_deptshift_rec.CREATED_BY:=fnd_global.user_id;
700: l_appr_deptshift_rec.LAST_UPDATE_LOGIN:=fnd_global.user_id;
701: l_appr_deptshift_rec.AHL_DEPARTMENT_SHIFTS_ID:=l_department_shifts_id;
702:
703: INSERT INTO AHL_DEPARTMENT_SHIFTS
704: (

Line 1087: l_appr_deptshift_rec.LAST_UPDATED_BY:=fnd_global.user_id;

1083: l_department_shifts_id
1084: from dual; */
1085:
1086: l_appr_deptshift_rec.LAST_UPDATE_DATE:=sysdate;
1087: l_appr_deptshift_rec.LAST_UPDATED_BY:=fnd_global.user_id;
1088: l_appr_deptshift_rec.CREATION_DATE:=sysdate;
1089: l_appr_deptshift_rec.CREATED_BY:=fnd_global.user_id;
1090: l_appr_deptshift_rec.LAST_UPDATE_LOGIN:=fnd_global.user_id;
1091: --l_appr_deptshift_rec.AHL_DEPARTMENT_SHIFTS_ID:=l_department_shifts_id;

Line 1089: l_appr_deptshift_rec.CREATED_BY:=fnd_global.user_id;

1085:
1086: l_appr_deptshift_rec.LAST_UPDATE_DATE:=sysdate;
1087: l_appr_deptshift_rec.LAST_UPDATED_BY:=fnd_global.user_id;
1088: l_appr_deptshift_rec.CREATION_DATE:=sysdate;
1089: l_appr_deptshift_rec.CREATED_BY:=fnd_global.user_id;
1090: l_appr_deptshift_rec.LAST_UPDATE_LOGIN:=fnd_global.user_id;
1091: --l_appr_deptshift_rec.AHL_DEPARTMENT_SHIFTS_ID:=l_department_shifts_id;
1092:
1093: UPDATE AHL_DEPARTMENT_SHIFTS SET

Line 1090: l_appr_deptshift_rec.LAST_UPDATE_LOGIN:=fnd_global.user_id;

1086: l_appr_deptshift_rec.LAST_UPDATE_DATE:=sysdate;
1087: l_appr_deptshift_rec.LAST_UPDATED_BY:=fnd_global.user_id;
1088: l_appr_deptshift_rec.CREATION_DATE:=sysdate;
1089: l_appr_deptshift_rec.CREATED_BY:=fnd_global.user_id;
1090: l_appr_deptshift_rec.LAST_UPDATE_LOGIN:=fnd_global.user_id;
1091: --l_appr_deptshift_rec.AHL_DEPARTMENT_SHIFTS_ID:=l_department_shifts_id;
1092:
1093: UPDATE AHL_DEPARTMENT_SHIFTS SET
1094: OBJECT_VERSION_NUMBER = l_appr_deptshift_rec.OBJECT_VERSION_NUMBER + 1,