APPS.IGS_PR_GEN_005 dependencies on IGS_OR_UNIT

Line 22: v_org_unit_cd igs_or_unit.org_unit_cd%TYPE;

18: cst_ap CONSTANT VARCHAR2 (2) := 'AP';
19: v_expiry_dt DATE;
20: v_cutoff_dt DATE;
21: v_level VARCHAR2 (10);
22: v_org_unit_cd igs_or_unit.org_unit_cd%TYPE;
23: v_ou_start_dt igs_or_unit.start_dt%TYPE;
24: v_stream_number igs_pr_s_prg_cal.stream_num%TYPE;
25: v_show_cause_length igs_pr_s_prg_cal.show_cause_length%TYPE;
26: v_appeal_length igs_pr_s_prg_cal.appeal_length%TYPE;

Line 23: v_ou_start_dt igs_or_unit.start_dt%TYPE;

19: v_expiry_dt DATE;
20: v_cutoff_dt DATE;
21: v_level VARCHAR2 (10);
22: v_org_unit_cd igs_or_unit.org_unit_cd%TYPE;
23: v_ou_start_dt igs_or_unit.start_dt%TYPE;
24: v_stream_number igs_pr_s_prg_cal.stream_num%TYPE;
25: v_show_cause_length igs_pr_s_prg_cal.show_cause_length%TYPE;
26: v_appeal_length igs_pr_s_prg_cal.appeal_length%TYPE;
27: BEGIN

Line 95: v_org_unit_cd igs_or_unit.org_unit_cd%TYPE;

91: -- show case is actually permitted; if not, the date is returned as null.
92: DECLARE
93: cst_sc CONSTANT VARCHAR2 (10) := 'SC';
94: v_level VARCHAR2 (10);
95: v_org_unit_cd igs_or_unit.org_unit_cd%TYPE;
96: v_ou_start_dt igs_or_unit.start_dt%TYPE;
97: v_stream_number igs_pr_s_prg_cal.stream_num%TYPE;
98: v_show_cause_length igs_pr_s_prg_cal.show_cause_length%TYPE;
99: v_appeal_length igs_pr_s_prg_cal.appeal_length%TYPE;

Line 96: v_ou_start_dt igs_or_unit.start_dt%TYPE;

92: DECLARE
93: cst_sc CONSTANT VARCHAR2 (10) := 'SC';
94: v_level VARCHAR2 (10);
95: v_org_unit_cd igs_or_unit.org_unit_cd%TYPE;
96: v_ou_start_dt igs_or_unit.start_dt%TYPE;
97: v_stream_number igs_pr_s_prg_cal.stream_num%TYPE;
98: v_show_cause_length igs_pr_s_prg_cal.show_cause_length%TYPE;
99: v_appeal_length igs_pr_s_prg_cal.appeal_length%TYPE;
100: v_expiry_dt DATE;

Line 1429: cp_cow_org_unit_cd igs_or_unit.org_unit_cd%TYPE,

1425: AND crv.version_number = sca.version_number
1426: AND crv.course_cd = cow.course_cd
1427: AND crv.version_number = cow.version_number;
1428: CURSOR c_our (
1429: cp_cow_org_unit_cd igs_or_unit.org_unit_cd%TYPE,
1430: cp_cow_ou_start_dt igs_or_unit.start_dt%TYPE,
1431: cp_course_type igs_ps_ver.course_type%TYPE
1432: ) IS
1433: SELECT 'X'

Line 1430: cp_cow_ou_start_dt igs_or_unit.start_dt%TYPE,

1426: AND crv.course_cd = cow.course_cd
1427: AND crv.version_number = cow.version_number;
1428: CURSOR c_our (
1429: cp_cow_org_unit_cd igs_or_unit.org_unit_cd%TYPE,
1430: cp_cow_ou_start_dt igs_or_unit.start_dt%TYPE,
1431: cp_course_type igs_ps_ver.course_type%TYPE
1432: ) IS
1433: SELECT 'X'
1434: FROM igs_or_unit_rel our

Line 1434: FROM igs_or_unit_rel our

1430: cp_cow_ou_start_dt igs_or_unit.start_dt%TYPE,
1431: cp_course_type igs_ps_ver.course_type%TYPE
1432: ) IS
1433: SELECT 'X'
1434: FROM igs_or_unit_rel our
1435: WHERE our.parent_org_unit_cd = p_org_unit_cd
1436: AND our.parent_start_dt = p_ou_start_dt
1437: AND our.child_org_unit_cd = cp_cow_org_unit_cd
1438: AND our.child_start_dt = cp_cow_ou_start_dt