APPS.IGS_AV_LVL_LGCY_PUB dependencies on IGS_GE_GEN_003

Line 409: igs_ge_gen_003.get_org_id

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
413: x_return_status := l_return; --it can be either E or W

Line 458: igs_ge_gen_003.get_org_id

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
462: /*

Line 563: igs_ge_gen_003.get_org_id,

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
567: );

Line 616: igs_ge_gen_003.get_org_id

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
620: END IF; -- validate_lvl_bas

Line 921: p_person_id := IGS_GE_GEN_003.GET_PERSON_ID(p_lgcy_adstlvl_rec.person_number);

917: p_s_adv_stnd_unit_level := 'LEVEL';
918: /*
919: get person_id
920: */
921: p_person_id := IGS_GE_GEN_003.GET_PERSON_ID(p_lgcy_adstlvl_rec.person_number);
922: IF p_person_id IS NULL THEN
923: FND_MESSAGE.SET_NAME('IGS', 'IGS_GE_INVALID_PERSON_NUMBER');
924: FND_MSG_PUB.ADD;
925: x_return_status := FALSE;

Line 935: IGS_GE_GEN_003.GET_CALENDAR_INSTANCE

931: l_start_dt igs_ca_inst.start_dt%TYPE;
932: l_end_dt igs_ca_inst.end_dt%TYPE;
933: l_return_status VARCHAR2(2000);
934: BEGIN
935: IGS_GE_GEN_003.GET_CALENDAR_INSTANCE
936: (
937: P_ALTERNATE_CD => p_lgcy_adstlvl_rec.load_cal_alt_code,
938: P_S_CAL_CATEGORY => NULL,
939: P_CAL_TYPE => p_cal_type,

Line 954: p_auth_pers_id := IGS_GE_GEN_003.GET_PERSON_ID(p_lgcy_adstlvl_rec.authorising_person_number);

950: END;
951: /*
952: derive p_authorizing_person_id
953: */
954: p_auth_pers_id := IGS_GE_GEN_003.GET_PERSON_ID(p_lgcy_adstlvl_rec.authorising_person_number);
955:
956: /*
957: derive p_qual_dets_id
958: Code modified for the bug #2732975.

Line 1099: p_as_version_number := IGS_GE_GEN_003.GET_PROGRAM_VERSION

1095:
1096: /*
1097: derive p_as_version_number
1098: */
1099: p_as_version_number := IGS_GE_GEN_003.GET_PROGRAM_VERSION
1100: (
1101: p_person_id => p_person_id,
1102: p_program_cd => p_lgcy_adstlvl_rec.program_cd
1103: );