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.IGF_DB_CL_ROSTER dependencies on IGF_SL_CL_BATCH_ALL

Line 68: PROCEDURE cl_load_data(p_cbth_id OUT NOCOPY igf_sl_cl_batch_all.cbth_id%TYPE)

64: -- and IGF_DB_CL_DISB_RESP tables.
65: -- Before loading, it does lot of checks to ensure it is the right file
66:
67:
68: PROCEDURE cl_load_data(p_cbth_id OUT NOCOPY igf_sl_cl_batch_all.cbth_id%TYPE)
69: IS
70:
71:
72: /*************************************************************

Line 87: l_batch_id igf_sl_cl_batch_all.batch_id%TYPE;

83: svuppala 27-Oct-2004 Added new fields as per FA 134
84: (reverse chronological order - newest change first)
85: ***************************************************************/
86:
87: l_batch_id igf_sl_cl_batch_all.batch_id%TYPE;
88: l_file_creation_dt igf_sl_cl_batch_all.file_creation_date%TYPE;
89: l_file_trans_dt igf_sl_cl_batch_all.file_trans_date%TYPE;
90: l_file_ident_name VARCHAR2(100);
91: l_file_ident_code igf_sl_cl_batch_all.file_ident_code%TYPE;

Line 88: l_file_creation_dt igf_sl_cl_batch_all.file_creation_date%TYPE;

84: (reverse chronological order - newest change first)
85: ***************************************************************/
86:
87: l_batch_id igf_sl_cl_batch_all.batch_id%TYPE;
88: l_file_creation_dt igf_sl_cl_batch_all.file_creation_date%TYPE;
89: l_file_trans_dt igf_sl_cl_batch_all.file_trans_date%TYPE;
90: l_file_ident_name VARCHAR2(100);
91: l_file_ident_code igf_sl_cl_batch_all.file_ident_code%TYPE;
92: l_source_id igf_sl_cl_batch_all.source_id%TYPE;

Line 89: l_file_trans_dt igf_sl_cl_batch_all.file_trans_date%TYPE;

85: ***************************************************************/
86:
87: l_batch_id igf_sl_cl_batch_all.batch_id%TYPE;
88: l_file_creation_dt igf_sl_cl_batch_all.file_creation_date%TYPE;
89: l_file_trans_dt igf_sl_cl_batch_all.file_trans_date%TYPE;
90: l_file_ident_name VARCHAR2(100);
91: l_file_ident_code igf_sl_cl_batch_all.file_ident_code%TYPE;
92: l_source_id igf_sl_cl_batch_all.source_id%TYPE;
93: l_recipient_id igf_sl_cl_batch_all.recipient_id%TYPE;

Line 91: l_file_ident_code igf_sl_cl_batch_all.file_ident_code%TYPE;

87: l_batch_id igf_sl_cl_batch_all.batch_id%TYPE;
88: l_file_creation_dt igf_sl_cl_batch_all.file_creation_date%TYPE;
89: l_file_trans_dt igf_sl_cl_batch_all.file_trans_date%TYPE;
90: l_file_ident_name VARCHAR2(100);
91: l_file_ident_code igf_sl_cl_batch_all.file_ident_code%TYPE;
92: l_source_id igf_sl_cl_batch_all.source_id%TYPE;
93: l_recipient_id igf_sl_cl_batch_all.recipient_id%TYPE;
94: l_recip_non_ed_brc_id igf_sl_cl_batch_all.recip_non_ed_brc_id%TYPE;
95: l_source_non_ed_brc_id igf_sl_cl_batch_all.source_non_ed_brc_id%TYPE;

Line 92: l_source_id igf_sl_cl_batch_all.source_id%TYPE;

88: l_file_creation_dt igf_sl_cl_batch_all.file_creation_date%TYPE;
89: l_file_trans_dt igf_sl_cl_batch_all.file_trans_date%TYPE;
90: l_file_ident_name VARCHAR2(100);
91: l_file_ident_code igf_sl_cl_batch_all.file_ident_code%TYPE;
92: l_source_id igf_sl_cl_batch_all.source_id%TYPE;
93: l_recipient_id igf_sl_cl_batch_all.recipient_id%TYPE;
94: l_recip_non_ed_brc_id igf_sl_cl_batch_all.recip_non_ed_brc_id%TYPE;
95: l_source_non_ed_brc_id igf_sl_cl_batch_all.source_non_ed_brc_id%TYPE;
96: l_rowid ROWID;

Line 93: l_recipient_id igf_sl_cl_batch_all.recipient_id%TYPE;

89: l_file_trans_dt igf_sl_cl_batch_all.file_trans_date%TYPE;
90: l_file_ident_name VARCHAR2(100);
91: l_file_ident_code igf_sl_cl_batch_all.file_ident_code%TYPE;
92: l_source_id igf_sl_cl_batch_all.source_id%TYPE;
93: l_recipient_id igf_sl_cl_batch_all.recipient_id%TYPE;
94: l_recip_non_ed_brc_id igf_sl_cl_batch_all.recip_non_ed_brc_id%TYPE;
95: l_source_non_ed_brc_id igf_sl_cl_batch_all.source_non_ed_brc_id%TYPE;
96: l_rowid ROWID;
97: l_cbth_id igf_sl_cl_batch_all.cbth_id%TYPE;

Line 94: l_recip_non_ed_brc_id igf_sl_cl_batch_all.recip_non_ed_brc_id%TYPE;

90: l_file_ident_name VARCHAR2(100);
91: l_file_ident_code igf_sl_cl_batch_all.file_ident_code%TYPE;
92: l_source_id igf_sl_cl_batch_all.source_id%TYPE;
93: l_recipient_id igf_sl_cl_batch_all.recipient_id%TYPE;
94: l_recip_non_ed_brc_id igf_sl_cl_batch_all.recip_non_ed_brc_id%TYPE;
95: l_source_non_ed_brc_id igf_sl_cl_batch_all.source_non_ed_brc_id%TYPE;
96: l_rowid ROWID;
97: l_cbth_id igf_sl_cl_batch_all.cbth_id%TYPE;
98: l_number_rec NUMBER;

Line 95: l_source_non_ed_brc_id igf_sl_cl_batch_all.source_non_ed_brc_id%TYPE;

91: l_file_ident_code igf_sl_cl_batch_all.file_ident_code%TYPE;
92: l_source_id igf_sl_cl_batch_all.source_id%TYPE;
93: l_recipient_id igf_sl_cl_batch_all.recipient_id%TYPE;
94: l_recip_non_ed_brc_id igf_sl_cl_batch_all.recip_non_ed_brc_id%TYPE;
95: l_source_non_ed_brc_id igf_sl_cl_batch_all.source_non_ed_brc_id%TYPE;
96: l_rowid ROWID;
97: l_cbth_id igf_sl_cl_batch_all.cbth_id%TYPE;
98: l_number_rec NUMBER;
99: l_last_lort_id NUMBER;

Line 97: l_cbth_id igf_sl_cl_batch_all.cbth_id%TYPE;

93: l_recipient_id igf_sl_cl_batch_all.recipient_id%TYPE;
94: l_recip_non_ed_brc_id igf_sl_cl_batch_all.recip_non_ed_brc_id%TYPE;
95: l_source_non_ed_brc_id igf_sl_cl_batch_all.source_non_ed_brc_id%TYPE;
96: l_rowid ROWID;
97: l_cbth_id igf_sl_cl_batch_all.cbth_id%TYPE;
98: l_number_rec NUMBER;
99: l_last_lort_id NUMBER;
100: l_tot_net_disb_amt NUMBER;
101: l_tot_net_eft_amt NUMBER;

Line 944: l_cbth_id igf_sl_cl_batch_all.cbth_id%TYPE;

940: veramach 3-NOV-2003 FA 125 Multiple Distr Methods
941: Changed the call of igf_aw_awd_disb_pkg.update_row to reflect the addition of attendance_type_code
942: ***************************************************************/
943:
944: l_cbth_id igf_sl_cl_batch_all.cbth_id%TYPE;
945: l_loan_number igf_db_cl_disb_resp_all.loan_number%TYPE;
946: l_disb_num igf_aw_awd_disb_all.disb_num%TYPE;
947:
948: l_disb_gross_amt igf_db_cl_disb_resp_all.gross_disb_amt%TYPE;

Line 964: CURSOR cur_db_resp(l_cbth_id igf_sl_cl_batch_all.cbth_id%TYPE) IS

960: l_rec_type igf_db_cl_disb_resp_all.record_type%TYPE;
961: lv_rec_status igf_db_cl_disb_resp_all.status%TYPE;
962: l_direct_to_borr_ind igf_db_cl_disb_resp_all.direct_to_borr_flag%TYPE;
963:
964: CURSOR cur_db_resp(l_cbth_id igf_sl_cl_batch_all.cbth_id%TYPE) IS
965: SELECT cdresp.* FROM igf_db_cl_disb_resp cdresp
966: WHERE cbth_id = l_cbth_id
967: AND status = 'N'
968: FOR UPDATE OF status NOWAIT;