[Home] [Help]
77: /*------------------------------------------------------------------
78: Created by : vvutukur, Oracle IDC
79: Date created: 23-May-2003
80:
81: Purpose: Inserts record into igs_fi_ftci_accts table using the specified parameters.
82:
83: Known limitations/enhancements and/or remarks:
84:
85: Change History:
86: Who When What
87: gurprsin 02-Jun-2005 Enh# 3442712, Added 4 new paramters for Unit Level Attributes
88: -------------------------------------------------------------------*/
89: l_rowid VARCHAR2(25);
90: l_n_acct_id igs_fi_ftci_accts.acct_id%TYPE;
91:
92: BEGIN
93:
94: l_rowid := NULL;
93:
94: l_rowid := NULL;
95: l_n_acct_id := NULL;
96:
97: igs_fi_ftci_accts_pkg.insert_row (
98: x_rowid => l_rowid,
99: x_acct_id => l_n_acct_id,
100: x_fee_type => p_v_fee_type,
101: x_fee_cal_type => p_v_fee_cal_type,
207: cp_v_fee_cal_type igs_fi_f_typ_ca_inst.fee_cal_type%TYPE,
208: cp_n_seq_number igs_fi_f_typ_ca_inst.fee_ci_sequence_number%TYPE
209: )IS
210: SELECT 'x'
211: FROM igs_fi_ftci_accts
212: WHERE fee_type = cp_v_fee_type
213: AND fee_cal_type = cp_v_fee_cal_type
214: AND fee_ci_sequence_number = cp_n_seq_number;
215:
213: AND fee_cal_type = cp_v_fee_cal_type
214: AND fee_ci_sequence_number = cp_n_seq_number;
215:
216: l_v_var VARCHAR2(1);
217: l_n_seq igs_fi_ftci_accts.order_sequence%TYPE;
218:
219: CURSOR cur_hier(cp_n_acct_hier_id igs_fi_hier_acct_tbl.acct_hier_id%TYPE) IS
220: SELECT entity_type_code
221: FROM igs_fi_hier_acct_tbl
432: l_cur_ftci.fee_ci_sequence_number);
433: FETCH cur_chk_acct_rec_exists INTO l_v_var;
434:
435: --For a Fee Type Calendar Instance in context, if the user has already defined the Accounting details in the Account Table,
436: --(igs_fi_ftci_accts), log the error message in the log file, skip the current FTCI record and process the next one.
437: IF cur_chk_acct_rec_exists%FOUND THEN
438: CLOSE cur_chk_acct_rec_exists;
439: fnd_message.set_name('IGS','IGS_FI_FTCI_ACCT_REC_EXISTS');
440: fnd_file.put_line(fnd_file.log,l_v_message_text||RPAD(' ',6,' ')||': '||fnd_message.get);
451: IF l_cur_hier.entity_type_code IN ('FTCI','SA') THEN
452:
453: --Check there is no record in the accounts table with the context FTCI details and other attributes as NULL.
454: --Added 4 new paramters for Unit Level Attributes
455: IF NOT igs_fi_ftci_accts_pkg.get_uk2_for_validation( x_fee_type => l_cur_ftci.fee_type,
456: x_fee_cal_type => l_cur_ftci.fee_cal_type,
457: x_fee_ci_sequence_number => l_cur_ftci.fee_ci_sequence_number,
458: x_location_cd => NULL,
459: x_attendance_type => NULL,
482:
483: --Increment the order sequence as this is part of unique key.
484: l_n_seq := l_n_seq + 1;
485:
486: --Insert a record in igs_fi_ftci_accts table.
487: --Added 4 new paramters for Unit Level Attributes
488: insert_ftci_accounts(p_v_fee_type => l_cur_ftci.fee_type,
489: p_v_fee_cal_type => l_cur_ftci.fee_cal_type,
490: p_n_fee_ci_sequence_number => l_cur_ftci.fee_ci_sequence_number,
512: FOR i IN prg_tbl.FIRST .. prg_tbl.LAST LOOP
513: IF prg_tbl.EXISTS(i) THEN
514: --Increment the order sequence as this is part of unique key.
515: l_n_seq := l_n_seq + 1;
516: --Insert a record in igs_fi_ftci_accts table with corresponding program details.
517: --Added 4 new paramters for Unit Level Attributes
518: insert_ftci_accounts(p_v_fee_type => l_cur_ftci.fee_type,
519: p_v_fee_cal_type => l_cur_ftci.fee_cal_type,
520: p_n_fee_ci_sequence_number => l_cur_ftci.fee_ci_sequence_number,
545:
546: --Increment the order sequence as this is part of unique key.
547: l_n_seq := l_n_seq + 1;
548:
549: --Insert a record in igs_fi_ftci_accts table with corresponding unit details.
550: --Added 4 new paramters for Unit Level Attributes
551: insert_ftci_accounts(p_v_fee_type => l_cur_ftci.fee_type,
552: p_v_fee_cal_type => l_cur_ftci.fee_cal_type,
553: p_n_fee_ci_sequence_number => l_cur_ftci.fee_ci_sequence_number,
576: FOR i IN usec_tbl.FIRST .. usec_tbl.LAST LOOP
577: IF usec_tbl.EXISTS(i) THEN
578: l_n_seq := l_n_seq + 1;
579:
580: --Insert a record in igs_fi_ftci_accts table with corresponding unit section details.
581: --Added 4 new paramters for Unit Level Attributes
582: insert_ftci_accounts(p_v_fee_type => l_cur_ftci.fee_type,
583: p_v_fee_cal_type => l_cur_ftci.fee_cal_type,
584: p_n_fee_ci_sequence_number => l_cur_ftci.fee_ci_sequence_number,
609:
610: --Increment the order sequence as this is part of unique key.
611: l_n_seq := l_n_seq + 1;
612:
613: --Insert a record in igs_fi_ftci_accts table with corresponding location details.
614: --Added 4 new paramters for Unit Level Attributes
615: insert_ftci_accounts(p_v_fee_type => l_cur_ftci.fee_type,
616: p_v_fee_cal_type => l_cur_ftci.fee_cal_type,
617: p_n_fee_ci_sequence_number => l_cur_ftci.fee_ci_sequence_number,
642:
643: --Increment the order sequence as this is part of unique key.
644: l_n_seq := l_n_seq + 1;
645:
646: --Insert a record in igs_fi_ftci_accts table with corresponding org unit code details.
647: --Added 4 new paramters for Unit Level Attributes
648: insert_ftci_accounts(p_v_fee_type => l_cur_ftci.fee_type,
649: p_v_fee_cal_type => l_cur_ftci.fee_cal_type,
650: p_n_fee_ci_sequence_number => l_cur_ftci.fee_ci_sequence_number,