APPS.IGF_SL_DL_PRINT_MANIFEST dependencies on IGF_SL_DL_SETUP

Line 72: l_ci_cal_type igf_sl_dl_setup.ci_cal_type%TYPE;

68: *****************************************************************/
69:
70: /* Local Variable Declaration */
71:
72: l_ci_cal_type igf_sl_dl_setup.ci_cal_type%TYPE;
73: l_ci_sequence_number igf_sl_dl_setup.ci_sequence_number%TYPE;
74: l_print_option igf_sl_dl_setup_v.pnote_print_ind%TYPE;
75: l_batch_seq_num NUMBER;
76: l_id igf_sl_dl_manifest.pnmn_id%TYPE;

Line 73: l_ci_sequence_number igf_sl_dl_setup.ci_sequence_number%TYPE;

69:
70: /* Local Variable Declaration */
71:
72: l_ci_cal_type igf_sl_dl_setup.ci_cal_type%TYPE;
73: l_ci_sequence_number igf_sl_dl_setup.ci_sequence_number%TYPE;
74: l_print_option igf_sl_dl_setup_v.pnote_print_ind%TYPE;
75: l_batch_seq_num NUMBER;
76: l_id igf_sl_dl_manifest.pnmn_id%TYPE;
77: l_row_id igf_sl_dl_manifest.row_id%TYPE;

Line 74: l_print_option igf_sl_dl_setup_v.pnote_print_ind%TYPE;

70: /* Local Variable Declaration */
71:
72: l_ci_cal_type igf_sl_dl_setup.ci_cal_type%TYPE;
73: l_ci_sequence_number igf_sl_dl_setup.ci_sequence_number%TYPE;
74: l_print_option igf_sl_dl_setup_v.pnote_print_ind%TYPE;
75: l_batch_seq_num NUMBER;
76: l_id igf_sl_dl_manifest.pnmn_id%TYPE;
77: l_row_id igf_sl_dl_manifest.row_id%TYPE;
78: l_log_mesg VARCHAR2(2000);

Line 80: l_awd_year igf_sl_dl_setup_v.ci_alternate_code%TYPE;

76: l_id igf_sl_dl_manifest.pnmn_id%TYPE;
77: l_row_id igf_sl_dl_manifest.row_id%TYPE;
78: l_log_mesg VARCHAR2(2000);
79: l_total_pnote NUMBER := 0;
80: l_awd_year igf_sl_dl_setup_v.ci_alternate_code%TYPE;
81: l_person_num igf_aw_award_v.person_number%TYPE;
82: l_alternate_code igs_ca_inst.alternate_code%TYPE;
83: l_heading VARCHAR2(2000);
84:

Line 86: CURSOR c_prnt_ind(l_cal igf_sl_dl_setup.ci_cal_type%TYPE, l_seq igf_sl_dl_setup.ci_sequence_number%TYPE) IS

82: l_alternate_code igs_ca_inst.alternate_code%TYPE;
83: l_heading VARCHAR2(2000);
84:
85: /* get the print configuration status of the school for the given award year */
86: CURSOR c_prnt_ind(l_cal igf_sl_dl_setup.ci_cal_type%TYPE, l_seq igf_sl_dl_setup.ci_sequence_number%TYPE) IS
87: SELECT pnote_print_ind, ci_alternate_code
88: FROM igf_sl_dl_setup_v
89: WHERE ci_cal_type = l_cal
90: AND ci_sequence_number = l_seq;

Line 88: FROM igf_sl_dl_setup_v

84:
85: /* get the print configuration status of the school for the given award year */
86: CURSOR c_prnt_ind(l_cal igf_sl_dl_setup.ci_cal_type%TYPE, l_seq igf_sl_dl_setup.ci_sequence_number%TYPE) IS
87: SELECT pnote_print_ind, ci_alternate_code
88: FROM igf_sl_dl_setup_v
89: WHERE ci_cal_type = l_cal
90: AND ci_sequence_number = l_seq;
91:
92: /* get all the records which have the pnote_status set as 'Signed' for the given award year,loan_category etc */

Line 93: CURSOR c_lor_signed(l_cal igf_sl_dl_setup.ci_cal_type%TYPE,

89: WHERE ci_cal_type = l_cal
90: AND ci_sequence_number = l_seq;
91:
92: /* get all the records which have the pnote_status set as 'Signed' for the given award year,loan_category etc */
93: CURSOR c_lor_signed(l_cal igf_sl_dl_setup.ci_cal_type%TYPE,
94: l_seq igf_sl_dl_setup.ci_sequence_number%TYPE,
95: cp_person_id igf_ap_fa_base_rec.person_id%TYPE) IS
96: SELECT lor.student_id,
97: lor.p_person_id,

Line 94: l_seq igf_sl_dl_setup.ci_sequence_number%TYPE,

90: AND ci_sequence_number = l_seq;
91:
92: /* get all the records which have the pnote_status set as 'Signed' for the given award year,loan_category etc */
93: CURSOR c_lor_signed(l_cal igf_sl_dl_setup.ci_cal_type%TYPE,
94: l_seq igf_sl_dl_setup.ci_sequence_number%TYPE,
95: cp_person_id igf_ap_fa_base_rec.person_id%TYPE) IS
96: SELECT lor.student_id,
97: lor.p_person_id,
98: lor.loan_id,