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.FTE_TRIP_MOVES_PVT dependencies on FND_API

Line 59: or p_trip_moves_info.sequence_number = FND_API.G_MISS_NUM) then

55:
56: --validate sequence
57:
58: if (p_trip_moves_info.sequence_number = null
59: or p_trip_moves_info.sequence_number = FND_API.G_MISS_NUM) then
60: RAISE empty_sequence;
61: end if;
62:
63: OPEN check_move_id(p_trip_moves_info.move_id);

Line 246: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,

242: --========================================================================
243:
244: PROCEDURE CREATE_TRIP_MOVES
245: (
246: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
247: p_trip_moves_info IN TRIP_MOVES_REC_TYPE,
248: x_trip_move_id OUT NOCOPY NUMBER,
249: x_return_status OUT NOCOPY VARCHAR2
250: ) IS

Line 262: IF FND_API.to_Boolean( p_init_msg_list )

258: BEGIN
259:
260: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
261:
262: IF FND_API.to_Boolean( p_init_msg_list )
263: THEN
264: FND_MSG_PUB.initialize;
265: END IF;
266:

Line 314: decode(p_trip_moves_info.creation_date,NULL,SYSDATE,FND_API.G_MISS_DATE,SYSDATE,p_trip_moves_info.creation_date),

310: x_trip_move_id,
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),

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 316: decode(p_trip_moves_info.last_update_date,NULL,SYSDATE,FND_API.G_MISS_DATE,SYSDATE, p_trip_moves_info.last_update_date),

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),
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),

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 321: decode(p_trip_moves_info.program_update_date,NULL,SYSDATE,FND_API.G_MISS_DATE,SYSDATE,p_trip_moves_info.program_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:
325: EXCEPTION

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 341: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,

337: -- COMMENT : Updates trip record with p_trip_info information
338: --========================================================================
339:
340: PROCEDURE Update_Trip_Moves(
341: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
342: p_trip_moves_info IN TRIP_MOVES_REC_TYPE,
343: x_return_status OUT NOCOPY VARCHAR2
344: ) IS
345:

Line 350: IF FND_API.to_Boolean( p_init_msg_list )

346: FTE_DUPLICATE_MOVE exception;
347:
348: BEGIN
349:
350: IF FND_API.to_Boolean( p_init_msg_list )
351: THEN
352: FND_MSG_PUB.initialize;
353: END IF;
354:

Line 381: FND_API.G_MISS_NUM,NULL,

377:
378: UPDATE fte_trip_moves SET
379: SEQUENCE_NUMBER = decode(p_trip_moves_info.SEQUENCE_NUMBER,
380: NULL,SEQUENCE_NUMBER,
381: FND_API.G_MISS_NUM,NULL,
382: p_trip_moves_info.SEQUENCE_NUMBER),
383: last_update_date = decode(p_trip_moves_info.last_update_date,
384: NULL,SYSDATE,
385: FND_API.G_MISS_DATE,SYSDATE,

Line 385: FND_API.G_MISS_DATE,SYSDATE,

381: FND_API.G_MISS_NUM,NULL,
382: p_trip_moves_info.SEQUENCE_NUMBER),
383: last_update_date = decode(p_trip_moves_info.last_update_date,
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,

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 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 400: NULL,program_id,FND_API.G_MISS_NUM,

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,
402: p_trip_moves_info.program_id),
403: program_update_date = decode(p_trip_moves_info.program_update_date,
404: NULL,program_update_date,

Line 405: FND_API.G_MISS_DATE,SYSDATE,

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,
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)

Line 408: NULL,request_id,FND_API.G_MISS_NUM,

404: NULL,program_update_date,
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

Line 433: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,

429: END Update_Trip_Moves;
430:
431:
432: PROCEDURE Delete_Trip_moves(
433: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
434: p_trip_move_id IN NUMBER,
435: x_return_status OUT NOCOPY VARCHAR2
436: ) IS
437:

Line 441: IF FND_API.to_Boolean( p_init_msg_list )

437:
438:
439: BEGIN
440:
441: IF FND_API.to_Boolean( p_init_msg_list )
442: THEN
443: FND_MSG_PUB.initialize;
444: END IF;
445: