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.

[Home] [Help]

APPS.IGS_PR_VAL_PRO dependencies on IGS_PR_OU_TYPE

Line 31: FROM IGS_PR_OU_TYPE pot

27: DECLARE
28: v_dummy VARCHAR2(1);
29: CURSOR c_pot IS
30: SELECT 'X'
31: FROM IGS_PR_OU_TYPE pot
32: WHERE pot.progression_outcome_type = p_progression_outcome_type AND
33: pot.closed_ind = 'N';
34: BEGIN
35: -- Set the default message number

Line 79: FROM IGS_PR_OU_TYPE pot,

75: cst_rstr_at_ty CONSTANT VARCHAR(10) := 'RSTR_AT_TY';
76: v_dummy VARCHAR2(1);
77: CURSOR c_pot IS
78: SELECT 'X'
79: FROM IGS_PR_OU_TYPE pot,
80: IGS_FI_ENC_DFLT_EFT etde
81: WHERE pot.progression_outcome_type = p_progression_outcome_type AND
82: pot.encumbrance_type = etde.encumbrance_type AND
83: etde.s_encmb_effect_type = cst_rstr_at_ty;

Line 147: FROM IGS_PR_OU_TYPE pot,

143: v_exit BOOLEAN := FALSE;
144: v_dummy VARCHAR2(1);
145: CURSOR c_pot_etde IS
146: SELECT etde.s_encmb_effect_type
147: FROM IGS_PR_OU_TYPE pot,
148: IGS_FI_ENC_DFLT_EFT etde
149: WHERE pot.progression_outcome_type = p_progression_outcome_type AND
150: pot.encumbrance_type = etde.encumbrance_type;
151: CURSOR c_pous IS

Line 304: FROM IGS_PR_OU_TYPE pot,

300: cst_exc_crs_gp CONSTANT VARCHAR2(10) := 'EXC_CRS_GP';
301: v_dummy VARCHAR2(1);
302: CURSOR c_pot IS
303: SELECT 'X'
304: FROM IGS_PR_OU_TYPE pot,
305: IGS_FI_ENC_DFLT_EFT etde
306: WHERE pot.progression_outcome_type = p_progression_outcome_type AND
307: pot.encumbrance_type = etde.encumbrance_type AND
308: etde.s_encmb_effect_type = cst_exc_crs_gp;

Line 356: FROM IGS_PR_OU_TYPE pot,

352: cst_rstr_le_cp CONSTANT VARCHAR2(10) := 'RSTR_LE_CP';
353: v_dummy VARCHAR2(1);
354: CURSOR c_pot IS
355: SELECT 'X'
356: FROM IGS_PR_OU_TYPE pot,
357: IGS_FI_ENC_DFLT_EFT etde
358: WHERE pot.progression_outcome_type = p_progression_outcome_type AND
359: pot.encumbrance_type = etde.encumbrance_type AND
360: etde.s_encmb_effect_type IN ( cst_rstr_ge_cp,

Line 438: FROM IGS_PR_OU_TYPE pot,

434: poc.pra_sequence_number = p_pra_sequence_number AND
435: poc.pro_sequence_number = p_sequence_number;
436: CURSOR c_pot_etde1 IS
437: SELECT 'X'
438: FROM IGS_PR_OU_TYPE pot,
439: IGS_FI_ENC_DFLT_EFT etde
440: WHERE pot.progression_outcome_type = p_progression_outcome_type AND
441: pot.encumbrance_type = etde.encumbrance_type AND
442: etde.s_encmb_effect_type IN (

Line 453: FROM IGS_PR_OU_TYPE pot,

449: pous.pra_sequence_number = p_pra_sequence_number AND
450: pous.pro_sequence_number = p_sequence_number;
451: CURSOR c_pot_etde2 IS
452: SELECT 'X'
453: FROM IGS_PR_OU_TYPE pot,
454: IGS_FI_ENC_DFLT_EFT etde
455: WHERE pot.progression_outcome_type = p_progression_outcome_type AND
456: pot.encumbrance_type = etde.encumbrance_type AND
457: etde.s_encmb_effect_type = cst_exc_crs_us;

Line 466: FROM IGS_PR_OU_TYPE pot,

462: popu.pra_sequence_number = p_pra_sequence_number AND
463: popu.pro_sequence_number = p_sequence_number;
464: CURSOR c_pot_etde3 IS
465: SELECT 'X'
466: FROM IGS_PR_OU_TYPE pot,
467: IGS_FI_ENC_DFLT_EFT etde
468: WHERE pot.progression_outcome_type = p_progression_outcome_type AND
469: pot.encumbrance_type = etde.encumbrance_type AND
470: etde.s_encmb_effect_type = cst_exc_crs_u;

Line 473: FROM IGS_PR_OU_TYPE pot,

469: pot.encumbrance_type = etde.encumbrance_type AND
470: etde.s_encmb_effect_type = cst_exc_crs_u;
471: CURSOR c_pot_etde4 IS
472: SELECT 'X'
473: FROM IGS_PR_OU_TYPE pot,
474: IGS_FI_ENC_DFLT_EFT etde
475: WHERE pot.progression_outcome_type = p_progression_outcome_type AND
476: pot.encumbrance_type = etde.encumbrance_type AND
477: etde.s_encmb_effect_type = cst_rqrd_crs_u;

Line 488: FROM IGS_PR_OU_TYPE pot,

484: pof.pro_sequence_number = p_sequence_number;
485:
486: CURSOR c_pot_etde5 IS
487: SELECT 'X'
488: FROM IGS_PR_OU_TYPE pot,
489: IGS_FI_ENC_DFLT_EFT etde
490: WHERE pot.progression_outcome_type = p_progression_outcome_type AND
491: pot.encumbrance_type = etde.encumbrance_type AND
492: etde.s_encmb_effect_type = cst_exe_fund;

Line 636: v_s_progression_outcome_type IGS_PR_OU_TYPE.s_progression_outcome_type%TYPE;

632: -- MANUAL or EX_FUND, then duration and duration_type cannot be specified
633: --4. If related s_progress_outcome_type not PROBATION then duration_type
634: --cannot be effective
635: DECLARE
636: v_s_progression_outcome_type IGS_PR_OU_TYPE.s_progression_outcome_type%TYPE;
637: cst_suspension CONSTANT VARCHAR2(10) := 'SUSPENSION';
638: cst_exclusion CONSTANT VARCHAR2(10) := 'EXCLUSION';
639: cst_expulsion CONSTANT VARCHAR2(10) := 'EXPULSION';
640: cst_nopenalty CONSTANT VARCHAR2(10) := 'NOPENALTY';

Line 647: FROM IGS_PR_OU_TYPE pot

643: cst_effective CONSTANT VARCHAR2(10) := 'EFFECTIVE';
644: cst_ex_fund CONSTANT VARCHAR2(10) := 'EX_FUND';
645: CURSOR c_pot IS
646: SELECT pot.s_progression_outcome_type
647: FROM IGS_PR_OU_TYPE pot
648: WHERE pot.progression_outcome_type = p_progression_outcome_type;
649: BEGIN
650: -- Set the default message number
651: p_message_name := null;