DBA Data[Home] [Help]

APPS.FTE_TRIP_MOVES_PVT dependencies on FND_GLOBAL

Line 315: decode(p_trip_moves_info.created_by,NULL,FND_GLOBAL.USER_ID,FND_API.G_MISS_NUM,FND_GLOBAL.USER_ID,p_trip_moves_info.created_by),

311: p_trip_moves_info.MOVE_ID,
312: p_trip_moves_info.TRIP_ID,
313: p_trip_moves_info.SEQUENCE_NUMBER,
314: decode(p_trip_moves_info.creation_date,NULL,SYSDATE,FND_API.G_MISS_DATE,SYSDATE,p_trip_moves_info.creation_date),
315: decode(p_trip_moves_info.created_by,NULL,FND_GLOBAL.USER_ID,FND_API.G_MISS_NUM,FND_GLOBAL.USER_ID,p_trip_moves_info.created_by),
316: decode(p_trip_moves_info.last_update_date,NULL,SYSDATE,FND_API.G_MISS_DATE,SYSDATE, p_trip_moves_info.last_update_date),
317: decode(p_trip_moves_info.last_updated_by,NULL,FND_GLOBAL.USER_ID,FND_API.G_MISS_NUM,FND_GLOBAL.USER_ID,p_trip_moves_info.last_updated_by),
318: decode(p_trip_moves_info.last_update_login,NULL,FND_GLOBAL.USER_ID,FND_API.G_MISS_NUM,FND_GLOBAL.LOGIN_ID,p_trip_moves_info.last_update_login),
319: decode(p_trip_moves_info.program_application_id,NULL,FND_GLOBAL.PROG_APPL_ID,FND_API.G_MISS_NUM,FND_GLOBAL.PROG_APPL_ID,p_trip_moves_info.program_application_id),

Line 317: decode(p_trip_moves_info.last_updated_by,NULL,FND_GLOBAL.USER_ID,FND_API.G_MISS_NUM,FND_GLOBAL.USER_ID,p_trip_moves_info.last_updated_by),

313: p_trip_moves_info.SEQUENCE_NUMBER,
314: decode(p_trip_moves_info.creation_date,NULL,SYSDATE,FND_API.G_MISS_DATE,SYSDATE,p_trip_moves_info.creation_date),
315: decode(p_trip_moves_info.created_by,NULL,FND_GLOBAL.USER_ID,FND_API.G_MISS_NUM,FND_GLOBAL.USER_ID,p_trip_moves_info.created_by),
316: decode(p_trip_moves_info.last_update_date,NULL,SYSDATE,FND_API.G_MISS_DATE,SYSDATE, p_trip_moves_info.last_update_date),
317: decode(p_trip_moves_info.last_updated_by,NULL,FND_GLOBAL.USER_ID,FND_API.G_MISS_NUM,FND_GLOBAL.USER_ID,p_trip_moves_info.last_updated_by),
318: decode(p_trip_moves_info.last_update_login,NULL,FND_GLOBAL.USER_ID,FND_API.G_MISS_NUM,FND_GLOBAL.LOGIN_ID,p_trip_moves_info.last_update_login),
319: decode(p_trip_moves_info.program_application_id,NULL,FND_GLOBAL.PROG_APPL_ID,FND_API.G_MISS_NUM,FND_GLOBAL.PROG_APPL_ID,p_trip_moves_info.program_application_id),
320: decode(p_trip_moves_info.program_id,NULL,FND_GLOBAL.CONC_PROGRAM_ID,FND_API.G_MISS_NUM, FND_GLOBAL.CONC_PROGRAM_ID,p_trip_moves_info.program_id),
321: decode(p_trip_moves_info.program_update_date,NULL,SYSDATE,FND_API.G_MISS_DATE,SYSDATE,p_trip_moves_info.program_update_date),

Line 318: decode(p_trip_moves_info.last_update_login,NULL,FND_GLOBAL.USER_ID,FND_API.G_MISS_NUM,FND_GLOBAL.LOGIN_ID,p_trip_moves_info.last_update_login),

314: decode(p_trip_moves_info.creation_date,NULL,SYSDATE,FND_API.G_MISS_DATE,SYSDATE,p_trip_moves_info.creation_date),
315: decode(p_trip_moves_info.created_by,NULL,FND_GLOBAL.USER_ID,FND_API.G_MISS_NUM,FND_GLOBAL.USER_ID,p_trip_moves_info.created_by),
316: decode(p_trip_moves_info.last_update_date,NULL,SYSDATE,FND_API.G_MISS_DATE,SYSDATE, p_trip_moves_info.last_update_date),
317: decode(p_trip_moves_info.last_updated_by,NULL,FND_GLOBAL.USER_ID,FND_API.G_MISS_NUM,FND_GLOBAL.USER_ID,p_trip_moves_info.last_updated_by),
318: decode(p_trip_moves_info.last_update_login,NULL,FND_GLOBAL.USER_ID,FND_API.G_MISS_NUM,FND_GLOBAL.LOGIN_ID,p_trip_moves_info.last_update_login),
319: decode(p_trip_moves_info.program_application_id,NULL,FND_GLOBAL.PROG_APPL_ID,FND_API.G_MISS_NUM,FND_GLOBAL.PROG_APPL_ID,p_trip_moves_info.program_application_id),
320: decode(p_trip_moves_info.program_id,NULL,FND_GLOBAL.CONC_PROGRAM_ID,FND_API.G_MISS_NUM, FND_GLOBAL.CONC_PROGRAM_ID,p_trip_moves_info.program_id),
321: decode(p_trip_moves_info.program_update_date,NULL,SYSDATE,FND_API.G_MISS_DATE,SYSDATE,p_trip_moves_info.program_update_date),
322: decode(p_trip_moves_info.request_id,NULL,FND_GLOBAL.CONC_REQUEST_ID,FND_API.G_MISS_NUM,FND_GLOBAL.CONC_REQUEST_ID, p_trip_moves_info.request_id)

Line 319: decode(p_trip_moves_info.program_application_id,NULL,FND_GLOBAL.PROG_APPL_ID,FND_API.G_MISS_NUM,FND_GLOBAL.PROG_APPL_ID,p_trip_moves_info.program_application_id),

315: decode(p_trip_moves_info.created_by,NULL,FND_GLOBAL.USER_ID,FND_API.G_MISS_NUM,FND_GLOBAL.USER_ID,p_trip_moves_info.created_by),
316: decode(p_trip_moves_info.last_update_date,NULL,SYSDATE,FND_API.G_MISS_DATE,SYSDATE, p_trip_moves_info.last_update_date),
317: decode(p_trip_moves_info.last_updated_by,NULL,FND_GLOBAL.USER_ID,FND_API.G_MISS_NUM,FND_GLOBAL.USER_ID,p_trip_moves_info.last_updated_by),
318: decode(p_trip_moves_info.last_update_login,NULL,FND_GLOBAL.USER_ID,FND_API.G_MISS_NUM,FND_GLOBAL.LOGIN_ID,p_trip_moves_info.last_update_login),
319: decode(p_trip_moves_info.program_application_id,NULL,FND_GLOBAL.PROG_APPL_ID,FND_API.G_MISS_NUM,FND_GLOBAL.PROG_APPL_ID,p_trip_moves_info.program_application_id),
320: decode(p_trip_moves_info.program_id,NULL,FND_GLOBAL.CONC_PROGRAM_ID,FND_API.G_MISS_NUM, FND_GLOBAL.CONC_PROGRAM_ID,p_trip_moves_info.program_id),
321: decode(p_trip_moves_info.program_update_date,NULL,SYSDATE,FND_API.G_MISS_DATE,SYSDATE,p_trip_moves_info.program_update_date),
322: decode(p_trip_moves_info.request_id,NULL,FND_GLOBAL.CONC_REQUEST_ID,FND_API.G_MISS_NUM,FND_GLOBAL.CONC_REQUEST_ID, p_trip_moves_info.request_id)
323: );

Line 320: decode(p_trip_moves_info.program_id,NULL,FND_GLOBAL.CONC_PROGRAM_ID,FND_API.G_MISS_NUM, FND_GLOBAL.CONC_PROGRAM_ID,p_trip_moves_info.program_id),

316: decode(p_trip_moves_info.last_update_date,NULL,SYSDATE,FND_API.G_MISS_DATE,SYSDATE, p_trip_moves_info.last_update_date),
317: decode(p_trip_moves_info.last_updated_by,NULL,FND_GLOBAL.USER_ID,FND_API.G_MISS_NUM,FND_GLOBAL.USER_ID,p_trip_moves_info.last_updated_by),
318: decode(p_trip_moves_info.last_update_login,NULL,FND_GLOBAL.USER_ID,FND_API.G_MISS_NUM,FND_GLOBAL.LOGIN_ID,p_trip_moves_info.last_update_login),
319: decode(p_trip_moves_info.program_application_id,NULL,FND_GLOBAL.PROG_APPL_ID,FND_API.G_MISS_NUM,FND_GLOBAL.PROG_APPL_ID,p_trip_moves_info.program_application_id),
320: decode(p_trip_moves_info.program_id,NULL,FND_GLOBAL.CONC_PROGRAM_ID,FND_API.G_MISS_NUM, FND_GLOBAL.CONC_PROGRAM_ID,p_trip_moves_info.program_id),
321: decode(p_trip_moves_info.program_update_date,NULL,SYSDATE,FND_API.G_MISS_DATE,SYSDATE,p_trip_moves_info.program_update_date),
322: decode(p_trip_moves_info.request_id,NULL,FND_GLOBAL.CONC_REQUEST_ID,FND_API.G_MISS_NUM,FND_GLOBAL.CONC_REQUEST_ID, p_trip_moves_info.request_id)
323: );
324:

Line 322: decode(p_trip_moves_info.request_id,NULL,FND_GLOBAL.CONC_REQUEST_ID,FND_API.G_MISS_NUM,FND_GLOBAL.CONC_REQUEST_ID, p_trip_moves_info.request_id)

318: decode(p_trip_moves_info.last_update_login,NULL,FND_GLOBAL.USER_ID,FND_API.G_MISS_NUM,FND_GLOBAL.LOGIN_ID,p_trip_moves_info.last_update_login),
319: decode(p_trip_moves_info.program_application_id,NULL,FND_GLOBAL.PROG_APPL_ID,FND_API.G_MISS_NUM,FND_GLOBAL.PROG_APPL_ID,p_trip_moves_info.program_application_id),
320: decode(p_trip_moves_info.program_id,NULL,FND_GLOBAL.CONC_PROGRAM_ID,FND_API.G_MISS_NUM, FND_GLOBAL.CONC_PROGRAM_ID,p_trip_moves_info.program_id),
321: decode(p_trip_moves_info.program_update_date,NULL,SYSDATE,FND_API.G_MISS_DATE,SYSDATE,p_trip_moves_info.program_update_date),
322: decode(p_trip_moves_info.request_id,NULL,FND_GLOBAL.CONC_REQUEST_ID,FND_API.G_MISS_NUM,FND_GLOBAL.CONC_REQUEST_ID, p_trip_moves_info.request_id)
323: );
324:
325: EXCEPTION
326: WHEN others THEN

Line 388: NULL,FND_GLOBAL.USER_ID,

384: NULL,SYSDATE,
385: FND_API.G_MISS_DATE,SYSDATE,
386: p_trip_moves_info.last_update_date),
387: last_updated_by = decode(p_trip_moves_info.last_updated_by,
388: NULL,FND_GLOBAL.USER_ID,
389: FND_API.G_MISS_NUM,FND_GLOBAL.USER_ID,
390: p_trip_moves_info.last_updated_by),
391: last_update_login = decode(p_trip_moves_info.last_update_login,
392: NULL,FND_GLOBAL.LOGIN_ID,

Line 389: FND_API.G_MISS_NUM,FND_GLOBAL.USER_ID,

385: FND_API.G_MISS_DATE,SYSDATE,
386: p_trip_moves_info.last_update_date),
387: last_updated_by = decode(p_trip_moves_info.last_updated_by,
388: NULL,FND_GLOBAL.USER_ID,
389: FND_API.G_MISS_NUM,FND_GLOBAL.USER_ID,
390: p_trip_moves_info.last_updated_by),
391: last_update_login = decode(p_trip_moves_info.last_update_login,
392: NULL,FND_GLOBAL.LOGIN_ID,
393: FND_API.G_MISS_NUM, FND_GLOBAL.LOGIN_ID,

Line 392: NULL,FND_GLOBAL.LOGIN_ID,

388: NULL,FND_GLOBAL.USER_ID,
389: FND_API.G_MISS_NUM,FND_GLOBAL.USER_ID,
390: p_trip_moves_info.last_updated_by),
391: last_update_login = decode(p_trip_moves_info.last_update_login,
392: NULL,FND_GLOBAL.LOGIN_ID,
393: FND_API.G_MISS_NUM, FND_GLOBAL.LOGIN_ID,
394: p_trip_moves_info.last_update_login),
395: program_application_id = decode(p_trip_moves_info.program_application_id,
396: NULL,program_application_id,

Line 393: FND_API.G_MISS_NUM, FND_GLOBAL.LOGIN_ID,

389: FND_API.G_MISS_NUM,FND_GLOBAL.USER_ID,
390: p_trip_moves_info.last_updated_by),
391: last_update_login = decode(p_trip_moves_info.last_update_login,
392: NULL,FND_GLOBAL.LOGIN_ID,
393: FND_API.G_MISS_NUM, FND_GLOBAL.LOGIN_ID,
394: p_trip_moves_info.last_update_login),
395: program_application_id = decode(p_trip_moves_info.program_application_id,
396: NULL,program_application_id,
397: FND_API.G_MISS_NUM,FND_GLOBAL.PROG_APPL_ID,

Line 397: FND_API.G_MISS_NUM,FND_GLOBAL.PROG_APPL_ID,

393: FND_API.G_MISS_NUM, FND_GLOBAL.LOGIN_ID,
394: p_trip_moves_info.last_update_login),
395: program_application_id = decode(p_trip_moves_info.program_application_id,
396: NULL,program_application_id,
397: FND_API.G_MISS_NUM,FND_GLOBAL.PROG_APPL_ID,
398: p_trip_moves_info.program_application_id),
399: program_id = decode(p_trip_moves_info.program_id,
400: NULL,program_id,FND_API.G_MISS_NUM,
401: FND_GLOBAL.CONC_PROGRAM_ID,

Line 401: FND_GLOBAL.CONC_PROGRAM_ID,

397: FND_API.G_MISS_NUM,FND_GLOBAL.PROG_APPL_ID,
398: p_trip_moves_info.program_application_id),
399: program_id = decode(p_trip_moves_info.program_id,
400: NULL,program_id,FND_API.G_MISS_NUM,
401: FND_GLOBAL.CONC_PROGRAM_ID,
402: p_trip_moves_info.program_id),
403: program_update_date = decode(p_trip_moves_info.program_update_date,
404: NULL,program_update_date,
405: FND_API.G_MISS_DATE,SYSDATE,

Line 409: FND_GLOBAL.CONC_REQUEST_ID,p_trip_moves_info.request_id)

405: FND_API.G_MISS_DATE,SYSDATE,
406: p_trip_moves_info.program_update_date),
407: request_id = decode(p_trip_moves_info.request_id,
408: NULL,request_id,FND_API.G_MISS_NUM,
409: FND_GLOBAL.CONC_REQUEST_ID,p_trip_moves_info.request_id)
410: WHERE trip_move_id = p_trip_moves_info.trip_move_id;
411:
412: IF (SQL%NOTFOUND) THEN
413: RAISE no_data_found;