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

Line 405: NVL(FND_GLOBAL.USER_ID,-1),

401: UPPER(p_lgcy_adstlvl_rec.basis_program_type),
402: p_lgcy_adstlvl_rec.basis_year,
403: p_lgcy_adstlvl_rec.basis_completion_ind,
404: SYSDATE,
405: NVL(FND_GLOBAL.USER_ID,-1),
406: SYSDATE,
407: NVL(FND_GLOBAL.USER_ID,-1),
408: NVL(FND_GLOBAL.LOGIN_ID,-1),
409: igs_ge_gen_003.get_org_id

Line 407: NVL(FND_GLOBAL.USER_ID,-1),

403: p_lgcy_adstlvl_rec.basis_completion_ind,
404: SYSDATE,
405: NVL(FND_GLOBAL.USER_ID,-1),
406: SYSDATE,
407: NVL(FND_GLOBAL.USER_ID,-1),
408: NVL(FND_GLOBAL.LOGIN_ID,-1),
409: igs_ge_gen_003.get_org_id
410: );
411:

Line 408: NVL(FND_GLOBAL.LOGIN_ID,-1),

404: SYSDATE,
405: NVL(FND_GLOBAL.USER_ID,-1),
406: SYSDATE,
407: NVL(FND_GLOBAL.USER_ID,-1),
408: NVL(FND_GLOBAL.LOGIN_ID,-1),
409: igs_ge_gen_003.get_org_id
410: );
411:
412: ELSE -- validate_lvl_bas

Line 454: NVL(FND_GLOBAL.USER_ID,-1),

450: p_lgcy_adstlvl_rec.total_exmptn_granted,
451: p_lgcy_adstlvl_rec.total_exmptn_perc_grntd,
452: UPPER(p_lgcy_adstlvl_rec.exemption_institution_cd),
453: SYSDATE,
454: NVL(FND_GLOBAL.USER_ID,-1),
455: SYSDATE,
456: NVL(FND_GLOBAL.USER_ID,-1),
457: NVL(FND_GLOBAL.LOGIN_ID,-1),
458: igs_ge_gen_003.get_org_id

Line 456: NVL(FND_GLOBAL.USER_ID,-1),

452: UPPER(p_lgcy_adstlvl_rec.exemption_institution_cd),
453: SYSDATE,
454: NVL(FND_GLOBAL.USER_ID,-1),
455: SYSDATE,
456: NVL(FND_GLOBAL.USER_ID,-1),
457: NVL(FND_GLOBAL.LOGIN_ID,-1),
458: igs_ge_gen_003.get_org_id
459: );
460: END IF; --l_check = 'Y'

Line 457: NVL(FND_GLOBAL.LOGIN_ID,-1),

453: SYSDATE,
454: NVL(FND_GLOBAL.USER_ID,-1),
455: SYSDATE,
456: NVL(FND_GLOBAL.USER_ID,-1),
457: NVL(FND_GLOBAL.LOGIN_ID,-1),
458: igs_ge_gen_003.get_org_id
459: );
460: END IF; --l_check = 'Y'
461: -- step 8 of TD

Line 555: NVL(FND_GLOBAL.USER_ID,-1),

551: p_lgcy_adstlvl_rec.institution_cd,
552: l_unit_details_id,
553: l_tst_rslt_dtls_id,
554: SYSDATE,
555: NVL(FND_GLOBAL.USER_ID,-1),
556: SYSDATE,
557: NVL(FND_GLOBAL.USER_ID,-1),
558: NVL(FND_GLOBAL.LOGIN_ID,-1),
559: DECODE(FND_GLOBAL.CONC_REQUEST_ID,-1,NULL,FND_GLOBAL.CONC_REQUEST_ID),

Line 557: NVL(FND_GLOBAL.USER_ID,-1),

553: l_tst_rslt_dtls_id,
554: SYSDATE,
555: NVL(FND_GLOBAL.USER_ID,-1),
556: SYSDATE,
557: NVL(FND_GLOBAL.USER_ID,-1),
558: NVL(FND_GLOBAL.LOGIN_ID,-1),
559: DECODE(FND_GLOBAL.CONC_REQUEST_ID,-1,NULL,FND_GLOBAL.CONC_REQUEST_ID),
560: DECODE(FND_GLOBAL.CONC_REQUEST_ID,-1,NULL,FND_GLOBAL.CONC_PROGRAM_ID),
561: DECODE(FND_GLOBAL.CONC_REQUEST_ID,-1,NULL,FND_GLOBAL.PROG_APPL_ID),

Line 558: NVL(FND_GLOBAL.LOGIN_ID,-1),

554: SYSDATE,
555: NVL(FND_GLOBAL.USER_ID,-1),
556: SYSDATE,
557: NVL(FND_GLOBAL.USER_ID,-1),
558: NVL(FND_GLOBAL.LOGIN_ID,-1),
559: DECODE(FND_GLOBAL.CONC_REQUEST_ID,-1,NULL,FND_GLOBAL.CONC_REQUEST_ID),
560: DECODE(FND_GLOBAL.CONC_REQUEST_ID,-1,NULL,FND_GLOBAL.CONC_PROGRAM_ID),
561: DECODE(FND_GLOBAL.CONC_REQUEST_ID,-1,NULL,FND_GLOBAL.PROG_APPL_ID),
562: DECODE(FND_GLOBAL.CONC_REQUEST_ID,-1,NULL,SYSDATE),

Line 559: DECODE(FND_GLOBAL.CONC_REQUEST_ID,-1,NULL,FND_GLOBAL.CONC_REQUEST_ID),

555: NVL(FND_GLOBAL.USER_ID,-1),
556: SYSDATE,
557: NVL(FND_GLOBAL.USER_ID,-1),
558: NVL(FND_GLOBAL.LOGIN_ID,-1),
559: DECODE(FND_GLOBAL.CONC_REQUEST_ID,-1,NULL,FND_GLOBAL.CONC_REQUEST_ID),
560: DECODE(FND_GLOBAL.CONC_REQUEST_ID,-1,NULL,FND_GLOBAL.CONC_PROGRAM_ID),
561: DECODE(FND_GLOBAL.CONC_REQUEST_ID,-1,NULL,FND_GLOBAL.PROG_APPL_ID),
562: DECODE(FND_GLOBAL.CONC_REQUEST_ID,-1,NULL,SYSDATE),
563: igs_ge_gen_003.get_org_id,

Line 560: DECODE(FND_GLOBAL.CONC_REQUEST_ID,-1,NULL,FND_GLOBAL.CONC_PROGRAM_ID),

556: SYSDATE,
557: NVL(FND_GLOBAL.USER_ID,-1),
558: NVL(FND_GLOBAL.LOGIN_ID,-1),
559: DECODE(FND_GLOBAL.CONC_REQUEST_ID,-1,NULL,FND_GLOBAL.CONC_REQUEST_ID),
560: DECODE(FND_GLOBAL.CONC_REQUEST_ID,-1,NULL,FND_GLOBAL.CONC_PROGRAM_ID),
561: DECODE(FND_GLOBAL.CONC_REQUEST_ID,-1,NULL,FND_GLOBAL.PROG_APPL_ID),
562: DECODE(FND_GLOBAL.CONC_REQUEST_ID,-1,NULL,SYSDATE),
563: igs_ge_gen_003.get_org_id,
564: NULL, -- aiyer NEW_REFERENCES.DEG_AUD_DETAIL_ID,

Line 561: DECODE(FND_GLOBAL.CONC_REQUEST_ID,-1,NULL,FND_GLOBAL.PROG_APPL_ID),

557: NVL(FND_GLOBAL.USER_ID,-1),
558: NVL(FND_GLOBAL.LOGIN_ID,-1),
559: DECODE(FND_GLOBAL.CONC_REQUEST_ID,-1,NULL,FND_GLOBAL.CONC_REQUEST_ID),
560: DECODE(FND_GLOBAL.CONC_REQUEST_ID,-1,NULL,FND_GLOBAL.CONC_PROGRAM_ID),
561: DECODE(FND_GLOBAL.CONC_REQUEST_ID,-1,NULL,FND_GLOBAL.PROG_APPL_ID),
562: DECODE(FND_GLOBAL.CONC_REQUEST_ID,-1,NULL,SYSDATE),
563: igs_ge_gen_003.get_org_id,
564: NULL, -- aiyer NEW_REFERENCES.DEG_AUD_DETAIL_ID,
565: l_qual_dets_id,

Line 562: DECODE(FND_GLOBAL.CONC_REQUEST_ID,-1,NULL,SYSDATE),

558: NVL(FND_GLOBAL.LOGIN_ID,-1),
559: DECODE(FND_GLOBAL.CONC_REQUEST_ID,-1,NULL,FND_GLOBAL.CONC_REQUEST_ID),
560: DECODE(FND_GLOBAL.CONC_REQUEST_ID,-1,NULL,FND_GLOBAL.CONC_PROGRAM_ID),
561: DECODE(FND_GLOBAL.CONC_REQUEST_ID,-1,NULL,FND_GLOBAL.PROG_APPL_ID),
562: DECODE(FND_GLOBAL.CONC_REQUEST_ID,-1,NULL,SYSDATE),
563: igs_ge_gen_003.get_org_id,
564: NULL, -- aiyer NEW_REFERENCES.DEG_AUD_DETAIL_ID,
565: l_qual_dets_id,
566: p_lgcy_adstlvl_rec.UNIT_LEVEL_MARK

Line 612: NVL(FND_GLOBAL.USER_ID,-1),

608: UPPER(p_lgcy_adstlvl_rec.basis_program_type),
609: p_lgcy_adstlvl_rec.basis_year,
610: p_lgcy_adstlvl_rec.basis_completion_ind,
611: SYSDATE,
612: NVL(FND_GLOBAL.USER_ID,-1),
613: SYSDATE,
614: NVL(FND_GLOBAL.USER_ID,-1),
615: NVL(FND_GLOBAL.LOGIN_ID,-1),
616: igs_ge_gen_003.get_org_id

Line 614: NVL(FND_GLOBAL.USER_ID,-1),

610: p_lgcy_adstlvl_rec.basis_completion_ind,
611: SYSDATE,
612: NVL(FND_GLOBAL.USER_ID,-1),
613: SYSDATE,
614: NVL(FND_GLOBAL.USER_ID,-1),
615: NVL(FND_GLOBAL.LOGIN_ID,-1),
616: igs_ge_gen_003.get_org_id
617: );
618: ELSE -- validate_lvl_bas

Line 615: NVL(FND_GLOBAL.LOGIN_ID,-1),

611: SYSDATE,
612: NVL(FND_GLOBAL.USER_ID,-1),
613: SYSDATE,
614: NVL(FND_GLOBAL.USER_ID,-1),
615: NVL(FND_GLOBAL.LOGIN_ID,-1),
616: igs_ge_gen_003.get_org_id
617: );
618: ELSE -- validate_lvl_bas
619: x_return_status := l_return; --it can be either E or W