APPS.IGS_PR_UPLOAD_EXT_RESULTS dependencies on IGS_PR_STAT_TYPE

Line 57: cp_stat_type igs_pr_stat_type.stat_type%TYPE

53:
54: CURSOR cur_org_stat_type (
55: cp_person_id igs_en_stdnt_ps_att.person_id%TYPE,
56: cp_course_cd igs_en_stdnt_ps_att.course_cd%TYPE,
57: cp_stat_type igs_pr_stat_type.stat_type%TYPE
58: ) IS
59: SELECT ost.timeframe,
60: stty.closed_ind,
61: stty.derivation

Line 65: igs_pr_stat_type stty

61: stty.derivation
62: FROM igs_en_stdnt_ps_att spa,
63: igs_ps_ver pv,
64: igs_pr_org_stat ost,
65: igs_pr_stat_type stty
66: WHERE spa.person_id = cp_person_id
67: AND spa.course_cd = cp_course_cd
68: AND spa.course_cd = pv.course_cd
69: AND spa.version_number = pv.version_number

Line 75: cp_stat_type igs_pr_stat_type.stat_type%TYPE

71: AND ost.stat_type = cp_stat_type
72: AND ost.stat_type = stty.stat_type;
73:
74: CURSOR cur_inst_stat_type (
75: cp_stat_type igs_pr_stat_type.stat_type%TYPE
76: ) IS
77: SELECT ist.timeframe,
78: stty.closed_ind,
79: stty.derivation

Line 81: igs_pr_stat_type stty

77: SELECT ist.timeframe,
78: stty.closed_ind,
79: stty.derivation
80: FROM igs_pr_inst_stat ist,
81: igs_pr_stat_type stty
82: WHERE ist.stat_type = cp_stat_type
83: AND ist.stat_type = stty.stat_type;
84:
85: CURSOR cur_stat_ele (

Line 86: cp_stat_type igs_pr_stat_type.stat_type%TYPE,

82: WHERE ist.stat_type = cp_stat_type
83: AND ist.stat_type = stty.stat_type;
84:
85: CURSOR cur_stat_ele (
86: cp_stat_type igs_pr_stat_type.stat_type%TYPE,
87: cp_s_stat_element igs_pr_sta_type_ele.s_stat_element%TYPE
88: ) IS
89: SELECT 'X'
90: FROM igs_pr_sta_type_ele stte

Line 100: l_stat_closed_ind igs_pr_stat_type.closed_ind%TYPE;

96: ci_exists_rec cur_ci_exists%ROWTYPE;
97: org_stat_type_rec cur_org_stat_type%ROWTYPE;
98: inst_stat_type_rec cur_inst_stat_type%ROWTYPE;
99: stat_ele_rec cur_stat_ele%ROWTYPE;
100: l_stat_closed_ind igs_pr_stat_type.closed_ind%TYPE;
101: l_stat_derivation igs_pr_stat_type.derivation%TYPE;
102: l_stat_timeframe igs_pr_org_stat.timeframe%TYPE;
103: BEGIN
104: IF (igs_ge_gen_004.genp_get_lookup (

Line 101: l_stat_derivation igs_pr_stat_type.derivation%TYPE;

97: org_stat_type_rec cur_org_stat_type%ROWTYPE;
98: inst_stat_type_rec cur_inst_stat_type%ROWTYPE;
99: stat_ele_rec cur_stat_ele%ROWTYPE;
100: l_stat_closed_ind igs_pr_stat_type.closed_ind%TYPE;
101: l_stat_derivation igs_pr_stat_type.derivation%TYPE;
102: l_stat_timeframe igs_pr_org_stat.timeframe%TYPE;
103: BEGIN
104: IF (igs_ge_gen_004.genp_get_lookup (
105: 'PR_EXTERNAL_STAT_SOURCE',