APPS.IGS_GE_VAL_PARAM dependencies on IGS_PS_UNIT_VER

Line 15: FUNCTION repp_val_unit_cd( p_unit_cd IN OUT NOCOPY IGS_PS_UNIT_VER_all.unit_cd%TYPE,

11: -- IGS_PE_PERSON Date Comments
12: -- --------- -------- ------------------------------------------
13: -- MSONTER 21/08/98 Initial creation of function
14: -- smvk 09-Jul-2004 Bug # 3676145. Modified the cursors c_uc and c_mode to select active (not closed) unit classes.
15: FUNCTION repp_val_unit_cd( p_unit_cd IN OUT NOCOPY IGS_PS_UNIT_VER_all.unit_cd%TYPE,
16: p_msg_name OUT NOCOPY VARCHAR2)
17: RETURN BOOLEAN
18: AS
19: --

Line 21: CURSOR c_unit(cp_unit_cd IGS_PS_UNIT_VER.unit_cd%TYPE)

17: RETURN BOOLEAN
18: AS
19: --
20: -- Local Cursors
21: CURSOR c_unit(cp_unit_cd IGS_PS_UNIT_VER.unit_cd%TYPE)
22: IS
23: SELECT
24: 'x'
25: FROM IGS_PS_UNIT_VER UV,

Line 25: FROM IGS_PS_UNIT_VER UV,

21: CURSOR c_unit(cp_unit_cd IGS_PS_UNIT_VER.unit_cd%TYPE)
22: IS
23: SELECT
24: 'x'
25: FROM IGS_PS_UNIT_VER UV,
26: IGS_PS_UNIT_STAT UNS
27: WHERE
28: uv.unit_cd LIKE cp_unit_cd
29: AND uns.unit_status = uv.unit_status

Line 37: IF IGS_GE_GEN_001.GENP_CHK_COL_UPPER('UNIT_CD','IGS_PS_UNIT_VER')

33: v_unit_ok VARCHAR2(1) := NULL;
34: BEGIN
35: --
36: -- check for uppper case requirement
37: IF IGS_GE_GEN_001.GENP_CHK_COL_UPPER('UNIT_CD','IGS_PS_UNIT_VER')
38: THEN
39: p_unit_cd := UPPER(p_unit_cd);
40: END IF;
41: --

Line 583: FUNCTION repp_val_unit_cal( p_unit_cd IN IGS_PS_UNIT_VER_ALL.unit_cd%TYPE,

579: -- MODIFICATION HISTORY
580: -- Person Date Comments
581: -- --------- -------- ------------------------------------------
582: -- MSONTER 28/08/98 Initial creation of function
583: FUNCTION repp_val_unit_cal( p_unit_cd IN IGS_PS_UNIT_VER_ALL.unit_cd%TYPE,
584: p_ass_cal_type IN IGS_CA_INST_ALL.CAL_TYPE%TYPE,
585: p_ass_seq_num IN IGS_CA_INST_ALL.sequence_number%TYPE,
586: p_teach_cal_type IN IGS_CA_INST_ALL.cal_type%TYPE,
587: p_teach_seq_num IN IGS_CA_INST_ALL.sequence_number%TYPE,