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.JMF_SHIKYU_ADJUSTMENT_PROC dependencies on FND_GLOBAL

Line 290: last_updated_by = FND_GLOBAL.user_id,

286:
287: UPDATE jmf_shikyu_adjustments
288: SET batch_id = l_batch_id,
289: last_update_date = sysdate,
290: last_updated_by = FND_GLOBAL.user_id,
291: last_update_login = FND_GLOBAL.login_id
292: WHERE adjustment_id >= l_cur_batch_min_adj_id
293: AND adjustment_id <= l_cur_batch_max_adj_id
294: AND request_id IS NULL

Line 291: last_update_login = FND_GLOBAL.login_id

287: UPDATE jmf_shikyu_adjustments
288: SET batch_id = l_batch_id,
289: last_update_date = sysdate,
290: last_updated_by = FND_GLOBAL.user_id,
291: last_update_login = FND_GLOBAL.login_id
292: WHERE adjustment_id >= l_cur_batch_min_adj_id
293: AND adjustment_id <= l_cur_batch_max_adj_id
294: AND request_id IS NULL
295: AND batch_id IS NULL

Line 332: last_updated_by = FND_GLOBAL.user_id,

328: THEN
329: /*UPDATE jmf_shikyu_adjustments
330: SET request_id = l_request_id,
331: last_update_date = sysdate,
332: last_updated_by = FND_GLOBAL.user_id,
333: last_update_login = FND_GLOBAL.login_id
334: WHERE batch_id = l_batch_id
335: --AND request_id IS NULL
336: ;*/

Line 333: last_update_login = FND_GLOBAL.login_id

329: /*UPDATE jmf_shikyu_adjustments
330: SET request_id = l_request_id,
331: last_update_date = sysdate,
332: last_updated_by = FND_GLOBAL.user_id,
333: last_update_login = FND_GLOBAL.login_id
334: WHERE batch_id = l_batch_id
335: --AND request_id IS NULL
336: ;*/
337: l_batch_request_id_tbl(l_batch_id) := l_request_id;

Line 353: last_updated_by = FND_GLOBAL.user_id,

349: ELSE
350: UPDATE jmf_shikyu_adjustments
351: SET batch_id = NULL,
352: last_update_date = sysdate,
353: last_updated_by = FND_GLOBAL.user_id,
354: last_update_login = FND_GLOBAL.login_id
355: WHERE batch_id = l_batch_id
356: --AND request_id IS NULL
357: ;

Line 354: last_update_login = FND_GLOBAL.login_id

350: UPDATE jmf_shikyu_adjustments
351: SET batch_id = NULL,
352: last_update_date = sysdate,
353: last_updated_by = FND_GLOBAL.user_id,
354: last_update_login = FND_GLOBAL.login_id
355: WHERE batch_id = l_batch_id
356: --AND request_id IS NULL
357: ;
358: END IF;

Line 419: last_updated_by = FND_GLOBAL.user_id,

415:
416: UPDATE jmf_shikyu_adjustments
417: SET batch_id = l_batch_id,
418: last_update_date = sysdate,
419: last_updated_by = FND_GLOBAL.user_id,
420: last_update_login = FND_GLOBAL.login_id
421: WHERE adjustment_id >= l_cur_batch_min_adj_id
422: AND adjustment_id <= l_cur_batch_max_adj_id
423: AND request_id IS NULL

Line 420: last_update_login = FND_GLOBAL.login_id

416: UPDATE jmf_shikyu_adjustments
417: SET batch_id = l_batch_id,
418: last_update_date = sysdate,
419: last_updated_by = FND_GLOBAL.user_id,
420: last_update_login = FND_GLOBAL.login_id
421: WHERE adjustment_id >= l_cur_batch_min_adj_id
422: AND adjustment_id <= l_cur_batch_max_adj_id
423: AND request_id IS NULL
424: AND batch_id IS NULL

Line 461: last_updated_by = FND_GLOBAL.user_id,

457: THEN
458: /*UPDATE jmf_shikyu_adjustments
459: SET request_id = l_request_id,
460: last_update_date = sysdate,
461: last_updated_by = FND_GLOBAL.user_id,
462: last_update_login = FND_GLOBAL.login_id
463: WHERE batch_id = l_batch_id*/
464: --AND request_id IS NULL
465: l_batch_request_id_tbl(l_batch_id) := l_request_id

Line 462: last_update_login = FND_GLOBAL.login_id

458: /*UPDATE jmf_shikyu_adjustments
459: SET request_id = l_request_id,
460: last_update_date = sysdate,
461: last_updated_by = FND_GLOBAL.user_id,
462: last_update_login = FND_GLOBAL.login_id
463: WHERE batch_id = l_batch_id*/
464: --AND request_id IS NULL
465: l_batch_request_id_tbl(l_batch_id) := l_request_id
466: ;

Line 481: last_updated_by = FND_GLOBAL.user_id,

477: ELSE
478: UPDATE jmf_shikyu_adjustments
479: SET batch_id = NULL,
480: last_update_date = sysdate,
481: last_updated_by = FND_GLOBAL.user_id,
482: last_update_login = FND_GLOBAL.login_id
483: WHERE batch_id = l_batch_id
484: --AND request_id IS NULL
485: ;

Line 482: last_update_login = FND_GLOBAL.login_id

478: UPDATE jmf_shikyu_adjustments
479: SET batch_id = NULL,
480: last_update_date = sysdate,
481: last_updated_by = FND_GLOBAL.user_id,
482: last_update_login = FND_GLOBAL.login_id
483: WHERE batch_id = l_batch_id
484: --AND request_id IS NULL
485: ;
486: END IF;

Line 545: last_updated_by = FND_GLOBAL.user_id,

541:
542: UPDATE jmf_shikyu_adjustments
543: SET request_id = l_batch_request_id_tbl(l_cur_batch_id_index),
544: last_update_date = sysdate,
545: last_updated_by = FND_GLOBAL.user_id,
546: last_update_login = FND_GLOBAL.login_id
547: WHERE batch_id = l_cur_batch_id_index
548: AND request_id IS NULL
549: ;

Line 546: last_update_login = FND_GLOBAL.login_id

542: UPDATE jmf_shikyu_adjustments
543: SET request_id = l_batch_request_id_tbl(l_cur_batch_id_index),
544: last_update_date = sysdate,
545: last_updated_by = FND_GLOBAL.user_id,
546: last_update_login = FND_GLOBAL.login_id
547: WHERE batch_id = l_cur_batch_id_index
548: AND request_id IS NULL
549: ;
550: UPDATE jmf_shikyu_adjustments

Line 554: last_updated_by = FND_GLOBAL.user_id,

550: UPDATE jmf_shikyu_adjustments
551: SET request_id = NULL,
552: batch_id = NULL,
553: last_update_date = sysdate,
554: last_updated_by = FND_GLOBAL.user_id,
555: last_update_login = FND_GLOBAL.login_id
556: WHERE batch_id = l_cur_batch_id_index
557: AND request_id = -1
558: ;

Line 555: last_update_login = FND_GLOBAL.login_id

551: SET request_id = NULL,
552: batch_id = NULL,
553: last_update_date = sysdate,
554: last_updated_by = FND_GLOBAL.user_id,
555: last_update_login = FND_GLOBAL.login_id
556: WHERE batch_id = l_cur_batch_id_index
557: AND request_id = -1
558: ;
559:

Line 568: last_updated_by = FND_GLOBAL.user_id,

564: --20051013 add to update the batch_id that without request rows to be process again.
565: UPDATE jmf_shikyu_adjustments
566: SET batch_id = NULL,
567: last_update_date = sysdate,
568: last_updated_by = FND_GLOBAL.user_id,
569: last_update_login = FND_GLOBAL.login_id
570: WHERE request_id IS NULL
571: AND batch_id IS NOT NULL;
572:

Line 569: last_update_login = FND_GLOBAL.login_id

565: UPDATE jmf_shikyu_adjustments
566: SET batch_id = NULL,
567: last_update_date = sysdate,
568: last_updated_by = FND_GLOBAL.user_id,
569: last_update_login = FND_GLOBAL.login_id
570: WHERE request_id IS NULL
571: AND batch_id IS NOT NULL;
572:
573: -- commit the data

Line 952: last_updated_by = FND_GLOBAL.user_id,

948: -- **** for debug information in readonly UT environment.--- end ****
949: UPDATE jmf_shikyu_adjustments
950: SET request_id = -1,
951: last_update_date = sysdate,
952: last_updated_by = FND_GLOBAL.user_id,
953: last_update_login = FND_GLOBAL.login_id
954: WHERE adjustment_id = l_adjustment_id;
955: END IF;
956:

Line 953: last_update_login = FND_GLOBAL.login_id

949: UPDATE jmf_shikyu_adjustments
950: SET request_id = -1,
951: last_update_date = sysdate,
952: last_updated_by = FND_GLOBAL.user_id,
953: last_update_login = FND_GLOBAL.login_id
954: WHERE adjustment_id = l_adjustment_id;
955: END IF;
956:
957: END LOOP;