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_EN_VAL_SCA dependencies on IGS_FI_FUND_SRC

Line 2499: v_closed_ind IGS_FI_FUND_SRC.closed_ind%TYPE;

2495: p_message_name OUT NOCOPY VARCHAR2)
2496: RETURN BOOLEAN AS
2497: BEGIN
2498: DECLARE
2499: v_closed_ind IGS_FI_FUND_SRC.closed_ind%TYPE;
2500: v_fsr_fs_exists VARCHAR2(1) := 'N';
2501: v_fsr_cv_exists VARCHAR2(1) := 'N';
2502: CURSOR c_fs_closed_ind IS
2503: SELECT closed_ind

Line 2504: FROM IGS_FI_FUND_SRC

2500: v_fsr_fs_exists VARCHAR2(1) := 'N';
2501: v_fsr_cv_exists VARCHAR2(1) := 'N';
2502: CURSOR c_fs_closed_ind IS
2503: SELECT closed_ind
2504: FROM IGS_FI_FUND_SRC
2505: WHERE funding_source = p_funding_source;
2506: CURSOR c_chk_fsr_fs IS
2507: SELECT 'Y'
2508: FROM IGS_FI_FND_SRC_RSTN

Line 2520: -- This module validates the IGS_FI_FUND_SRC

2516: WHERE course_cd = p_course_cd AND
2517: version_number = p_version_number AND
2518: restricted_ind = 'Y';
2519: BEGIN
2520: -- This module validates the IGS_FI_FUND_SRC
2521: -- from the IGS_EN_STDNT_PS_ATT.
2522: -- checking if p_funding_source is not set
2523: IF (p_funding_source IS NULL) THEN
2524: p_message_name := null;

Line 2527: -- checking whether the IGS_FI_FUND_SRC is

2523: IF (p_funding_source IS NULL) THEN
2524: p_message_name := null;
2525: RETURN TRUE;
2526: END IF;
2527: -- checking whether the IGS_FI_FUND_SRC is
2528: -- closed in the IGS_FI_FUND_SRC table
2529: OPEN c_fs_closed_ind;
2530: FETCH c_fs_closed_ind INTO v_closed_ind;
2531: CLOSE c_fs_closed_ind;

Line 2528: -- closed in the IGS_FI_FUND_SRC table

2524: p_message_name := null;
2525: RETURN TRUE;
2526: END IF;
2527: -- checking whether the IGS_FI_FUND_SRC is
2528: -- closed in the IGS_FI_FUND_SRC table
2529: OPEN c_fs_closed_ind;
2530: FETCH c_fs_closed_ind INTO v_closed_ind;
2531: CLOSE c_fs_closed_ind;
2532: IF (v_closed_ind = 'Y') THEN

Line 2536: -- the IGS_FI_FUND_SRC isn't closed in

2532: IF (v_closed_ind = 'Y') THEN
2533: p_message_name := 'IGS_PS_FUND_SOURCE_CLOSED';
2534: RETURN FALSE;
2535: END IF;
2536: -- the IGS_FI_FUND_SRC isn't closed in
2537: -- the IGS_FI_FUND_SRC table so
2538: -- check that the IGS_FI_FUND_SRC in the
2539: -- IGS_FI_FND_SRC_RSTN table
2540: -- doesn't breach existing restrictions

Line 2537: -- the IGS_FI_FUND_SRC table so

2533: p_message_name := 'IGS_PS_FUND_SOURCE_CLOSED';
2534: RETURN FALSE;
2535: END IF;
2536: -- the IGS_FI_FUND_SRC isn't closed in
2537: -- the IGS_FI_FUND_SRC table so
2538: -- check that the IGS_FI_FUND_SRC in the
2539: -- IGS_FI_FND_SRC_RSTN table
2540: -- doesn't breach existing restrictions
2541: OPEN c_chk_fsr_cv;

Line 2538: -- check that the IGS_FI_FUND_SRC in the

2534: RETURN FALSE;
2535: END IF;
2536: -- the IGS_FI_FUND_SRC isn't closed in
2537: -- the IGS_FI_FUND_SRC table so
2538: -- check that the IGS_FI_FUND_SRC in the
2539: -- IGS_FI_FND_SRC_RSTN table
2540: -- doesn't breach existing restrictions
2541: OPEN c_chk_fsr_cv;
2542: FETCH c_chk_fsr_cv INTO v_fsr_cv_exists;

Line 2555: -- there were no closed_inds, and no IGS_FI_FUND_SRC

2551: p_message_name := 'IGS_EN_FUND_SOURCE_NOT_ALLOWD';
2552: RETURN FALSE;
2553: END IF;
2554: END IF;
2555: -- there were no closed_inds, and no IGS_FI_FUND_SRC
2556: -- restrictions
2557: p_message_name := null;
2558: RETURN TRUE;
2559: EXCEPTION