APPS.IGS_OR_GEN_001 dependencies on IGS_OR_INSTITUTION

Line 65: -- This module retrieves local active IGS_OR_INSTITUTION from profile value.

61:
62: FUNCTION orgp_get_local_inst
63: RETURN VARCHAR2 IS
64: BEGIN -- orgp_get_local_inst
65: -- This module retrieves local active IGS_OR_INSTITUTION from profile value.
66: DECLARE
67:
68: v_institution_cd IGS_OR_INSTITUTION.institution_cd%TYPE;
69: BEGIN

Line 68: v_institution_cd IGS_OR_INSTITUTION.institution_cd%TYPE;

64: BEGIN -- orgp_get_local_inst
65: -- This module retrieves local active IGS_OR_INSTITUTION from profile value.
66: DECLARE
67:
68: v_institution_cd IGS_OR_INSTITUTION.institution_cd%TYPE;
69: BEGIN
70: v_institution_cd := NULL;
71: v_institution_cd := FND_PROFILE.VALUE('IGS_OR_LOCAL_INST');
72: RETURN v_institution_cd;

Line 244: FROM IGS_OR_INSTITUTION

240: v_name := NULL;
241: ELSE
242: SELECT name
243: INTO v_name
244: FROM IGS_OR_INSTITUTION
245: WHERE institution_cd = p_institution_cd;
246: END IF;
247: -- Insert the IGS_OR_UNIT_HIST record.
248: INSERT INTO IGS_OR_UNIT_HIST

Line 456: -- IGS_OR_INSTITUTION codes match then update the org IGS_OR_UNIT

452:
453: IF v_update_ou AND
454: (p_institution_cd = p_org_instn_cd) THEN
455: -- If no active children, and
456: -- IGS_OR_INSTITUTION codes match then update the org IGS_OR_UNIT
457: -- and return true to indicate to the calling parent
458: -- that there is no active child.
459:
460: IF TRUNC(SYSDATE) >= p_start_dt THEN

Line 516: -- Select all active org units with the IGS_OR_INSTITUTION whose status has changed to inactive.

512: -- default message to say complete propagation.
513: v_message_name := 'IGS_OR_INS_STAT_PROPOGATED';
514: v_complete := TRUE;
515:
516: -- Select all active org units with the IGS_OR_INSTITUTION whose status has changed to inactive.
517: SAVEPOINT do_propagation;
518:
519: FOR ou_instn IN c_ou_instn LOOP
520: