DBA Data[Home] [Help]

APPS.AHL_AVF_OPER_VSTS_PVT dependencies on FND_GLOBAL

Line 1202: LAST_UPDATED_BY = Fnd_Global.USER_ID,

1198: UPDATE AHL_UNIT_SCHEDULES
1199: set AUTOVISIT_PROCESS_STATUS = 'R',
1200: OBJECT_VERSION_NUMBER = object_version_number + 1,
1201: LAST_UPDATE_DATE = SYSDATE,
1202: LAST_UPDATED_BY = Fnd_Global.USER_ID,
1203: LAST_UPDATE_LOGIN = Fnd_Global.LOGIN_ID
1204: WHERE UNIT_SCHEDULE_ID = flight_schedule_rec.UNIT_SCHEDULE_ID;
1205: END LOOP;
1206:

Line 1203: LAST_UPDATE_LOGIN = Fnd_Global.LOGIN_ID

1199: set AUTOVISIT_PROCESS_STATUS = 'R',
1200: OBJECT_VERSION_NUMBER = object_version_number + 1,
1201: LAST_UPDATE_DATE = SYSDATE,
1202: LAST_UPDATED_BY = Fnd_Global.USER_ID,
1203: LAST_UPDATE_LOGIN = Fnd_Global.LOGIN_ID
1204: WHERE UNIT_SCHEDULE_ID = flight_schedule_rec.UNIT_SCHEDULE_ID;
1205: END LOOP;
1206:
1207: ---------------------------End of Body-------------------------------------

Line 4047: LAST_UPDATED_BY = Fnd_Global.USER_ID,

4043: UPDATE AHL_UNIT_SCHEDULES
4044: set AUTOVISIT_PROCESS_STATUS = 'R',
4045: OBJECT_VERSION_NUMBER = object_version_number + 1,
4046: LAST_UPDATE_DATE = SYSDATE,
4047: LAST_UPDATED_BY = Fnd_Global.USER_ID,
4048: LAST_UPDATE_LOGIN = Fnd_Global.LOGIN_ID
4049: WHERE UNIT_SCHEDULE_ID = flight_schedule_rec.UNIT_SCHEDULE_ID;
4050: END LOOP;
4051:

Line 4048: LAST_UPDATE_LOGIN = Fnd_Global.LOGIN_ID

4044: set AUTOVISIT_PROCESS_STATUS = 'R',
4045: OBJECT_VERSION_NUMBER = object_version_number + 1,
4046: LAST_UPDATE_DATE = SYSDATE,
4047: LAST_UPDATED_BY = Fnd_Global.USER_ID,
4048: LAST_UPDATE_LOGIN = Fnd_Global.LOGIN_ID
4049: WHERE UNIT_SCHEDULE_ID = flight_schedule_rec.UNIT_SCHEDULE_ID;
4050: END LOOP;
4051:
4052: -- END of API body.

Line 5078: fnd_file.put_line(fnd_file.log, 'fnd_global.USER_ID -> '|| fnd_global.USER_ID);

5074:
5075: -- 2. Dump all input parameters
5076: fnd_file.put_line(fnd_file.log, '*************API input parameters**************');
5077: fnd_file.put_line(fnd_file.log, 'p_oper_flag -> '|| p_oper_flag);
5078: fnd_file.put_line(fnd_file.log, 'fnd_global.USER_ID -> '|| fnd_global.USER_ID);
5079: fnd_file.put_line(fnd_file.log, 'fnd_global.RESP_ID -> '||fnd_global.RESP_ID);
5080: fnd_file.put_line(fnd_file.log, 'fnd_global.PROG_APPL_ID -> '|| fnd_global.PROG_APPL_ID);
5081: fnd_file.put_line(fnd_file.log, 'mo_global.get_current_org_id -> '|| mo_global.get_current_org_id());
5082:

Line 5079: fnd_file.put_line(fnd_file.log, 'fnd_global.RESP_ID -> '||fnd_global.RESP_ID);

5075: -- 2. Dump all input parameters
5076: fnd_file.put_line(fnd_file.log, '*************API input parameters**************');
5077: fnd_file.put_line(fnd_file.log, 'p_oper_flag -> '|| p_oper_flag);
5078: fnd_file.put_line(fnd_file.log, 'fnd_global.USER_ID -> '|| fnd_global.USER_ID);
5079: fnd_file.put_line(fnd_file.log, 'fnd_global.RESP_ID -> '||fnd_global.RESP_ID);
5080: fnd_file.put_line(fnd_file.log, 'fnd_global.PROG_APPL_ID -> '|| fnd_global.PROG_APPL_ID);
5081: fnd_file.put_line(fnd_file.log, 'mo_global.get_current_org_id -> '|| mo_global.get_current_org_id());
5082:
5083:

Line 5080: fnd_file.put_line(fnd_file.log, 'fnd_global.PROG_APPL_ID -> '|| fnd_global.PROG_APPL_ID);

5076: fnd_file.put_line(fnd_file.log, '*************API input parameters**************');
5077: fnd_file.put_line(fnd_file.log, 'p_oper_flag -> '|| p_oper_flag);
5078: fnd_file.put_line(fnd_file.log, 'fnd_global.USER_ID -> '|| fnd_global.USER_ID);
5079: fnd_file.put_line(fnd_file.log, 'fnd_global.RESP_ID -> '||fnd_global.RESP_ID);
5080: fnd_file.put_line(fnd_file.log, 'fnd_global.PROG_APPL_ID -> '|| fnd_global.PROG_APPL_ID);
5081: fnd_file.put_line(fnd_file.log, 'mo_global.get_current_org_id -> '|| mo_global.get_current_org_id());
5082:
5083:
5084: IF p_oper_flag = 'C' THEN

Line 5992: LAST_UPDATED_BY = Fnd_Global.USER_ID,

5988: UPDATE ahl_visits_b
5989: SET UNIT_SCHEDULE_ID = null,
5990: OBJECT_VERSION_NUMBER = object_version_number + 1,
5991: LAST_UPDATE_DATE = SYSDATE,
5992: LAST_UPDATED_BY = Fnd_Global.USER_ID,
5993: LAST_UPDATE_LOGIN = Fnd_Global.LOGIN_ID
5994: WHERE visit_id = p_visit_id;
5995:
5996: -- Send a visit disconnect notification

Line 5993: LAST_UPDATE_LOGIN = Fnd_Global.LOGIN_ID

5989: SET UNIT_SCHEDULE_ID = null,
5990: OBJECT_VERSION_NUMBER = object_version_number + 1,
5991: LAST_UPDATE_DATE = SYSDATE,
5992: LAST_UPDATED_BY = Fnd_Global.USER_ID,
5993: LAST_UPDATE_LOGIN = Fnd_Global.LOGIN_ID
5994: WHERE visit_id = p_visit_id;
5995:
5996: -- Send a visit disconnect notification
5997: AHL_AVF_OPER_VSTS_PVT.Launch_Visit_Disc_Notification (