APPS.IGS_FI_BILL_EXTRACT dependencies on IGS_FI_BILL_PLN_CRD

Line 296: -- igf_aw_fund_mast MO view. Also the insert row call to IGS_FI_BILL_PLN_CRD_PKG modified

292: --vchappid 13-Jun-2002 Bug#2411529, Incorrectly used message name has been modified
293: --vchappid 06-Jun-2002 Bug# 2349394, incase the fund code is sponsor then credit type description is passed else the
294: -- bill description from the fund master is passed
295: --smadathi 31-May-2002 Bug 2349394. Cursor cur_planned_crd modified to select the column bill_desc from
296: -- igf_aw_fund_mast MO view. Also the insert row call to IGS_FI_BILL_PLN_CRD_PKG modified
297: -- to add new column bill_desc.
298: --vchappid 29-Apr-2002 Bug# 2347609, Changed the cursor 'cur_remitt_addr' which is having additional where clause
299: -- removed clause 'person_id = p_n_person_id'
300: -- Bug# 2337820, removed the correspondance flag reference in the cursors 'cur_bill_to_addr',

Line 681: l_planned_credits igs_fi_bill_pln_crd.pln_credit_amount%TYPE;

677: FOR UPDATE OF credit_activity_id NOWAIT;
678: rec_bill_deposits c_bill_deposits%ROWTYPE;
679: l_c_bill_deposits_row_id VARCHAR2(25);
680:
681: l_planned_credits igs_fi_bill_pln_crd.pln_credit_amount%TYPE;
682: l_to_pay_amount igs_fi_bill.to_pay_amount%TYPE;
683: l_message_name fnd_new_messages.message_name%TYPE:=NULL;
684: l_pln_crd_setup igs_fi_control_all.planned_credits_ind%TYPE;
685: l_pln_crd_rowid VARCHAR2(25);

Line 686: l_fee_cal_type igs_fi_bill_pln_crd.fee_cal_type%TYPE;

682: l_to_pay_amount igs_fi_bill.to_pay_amount%TYPE;
683: l_message_name fnd_new_messages.message_name%TYPE:=NULL;
684: l_pln_crd_setup igs_fi_control_all.planned_credits_ind%TYPE;
685: l_pln_crd_rowid VARCHAR2(25);
686: l_fee_cal_type igs_fi_bill_pln_crd.fee_cal_type%TYPE;
687: l_fee_ci_seq_num igs_fi_bill_pln_crd.fee_ci_sequence_number%TYPE;
688: l_flag BOOLEAN := TRUE;
689: l_bill_desc igs_fi_bill_pln_crd.bill_desc%TYPE;
690: l_c_rec_installed igs_fi_control.rec_installed%TYPE;

Line 687: l_fee_ci_seq_num igs_fi_bill_pln_crd.fee_ci_sequence_number%TYPE;

683: l_message_name fnd_new_messages.message_name%TYPE:=NULL;
684: l_pln_crd_setup igs_fi_control_all.planned_credits_ind%TYPE;
685: l_pln_crd_rowid VARCHAR2(25);
686: l_fee_cal_type igs_fi_bill_pln_crd.fee_cal_type%TYPE;
687: l_fee_ci_seq_num igs_fi_bill_pln_crd.fee_ci_sequence_number%TYPE;
688: l_flag BOOLEAN := TRUE;
689: l_bill_desc igs_fi_bill_pln_crd.bill_desc%TYPE;
690: l_c_rec_installed igs_fi_control.rec_installed%TYPE;
691:

Line 689: l_bill_desc igs_fi_bill_pln_crd.bill_desc%TYPE;

685: l_pln_crd_rowid VARCHAR2(25);
686: l_fee_cal_type igs_fi_bill_pln_crd.fee_cal_type%TYPE;
687: l_fee_ci_seq_num igs_fi_bill_pln_crd.fee_ci_sequence_number%TYPE;
688: l_flag BOOLEAN := TRUE;
689: l_bill_desc igs_fi_bill_pln_crd.bill_desc%TYPE;
690: l_c_rec_installed igs_fi_control.rec_installed%TYPE;
691:
692: -- Bug #3813498 To get system fee type and fee class associated with the fee_type
693: CURSOR cur_fee_type(cp_fee_type igs_fi_fee_type.fee_type%TYPE) IS

Line 984: --Fetching all the planned credits and inserting into igs_fi_bill_pln_crd table

980: );
981: END LOOP;
982:
983: --Added as a part of bug:2293676
984: --Fetching all the planned credits and inserting into igs_fi_bill_pln_crd table
985: IF l_pln_crd_setup = 'Y' THEN
986:
987: FOR l_cur_planned_crd IN cur_planned_crd(p_n_person_id,p_d_cutoff_dt) LOOP
988:

Line 1013: igs_fi_bill_pln_crd_pkg.insert_row(

1009: l_bill_desc := l_cur_planned_crd.bill_desc;
1010: END IF;
1011:
1012: l_pln_crd_rowid := NULL;
1013: igs_fi_bill_pln_crd_pkg.insert_row(
1014: x_rowid => l_pln_crd_rowid,
1015: x_bill_id => l_n_bill_id_seq,
1016: x_award_id => l_cur_planned_crd.award_id,
1017: x_disb_num => l_cur_planned_crd.disb_num,