APPS.IGS_FI_IMP_CHGS_PKG dependencies on IGS_FI_IMP_CHGS_ALL

Line 5: old_references igs_fi_imp_chgs_all%ROWTYPE;

1: PACKAGE BODY igs_fi_imp_chgs_pkg AS
2: /* $Header: IGSSI84B.pls 115.11 2003/02/12 09:55:17 pathipat ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_fi_imp_chgs_all%ROWTYPE;
6: new_references igs_fi_imp_chgs_all%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,

Line 6: new_references igs_fi_imp_chgs_all%ROWTYPE;

2: /* $Header: IGSSI84B.pls 115.11 2003/02/12 09:55:17 pathipat ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_fi_imp_chgs_all%ROWTYPE;
6: new_references igs_fi_imp_chgs_all%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,
10: x_rowid IN VARCHAR2 DEFAULT NULL,

Line 35: FROM IGS_FI_IMP_CHGS_ALL

31: */
32:
33: CURSOR cur_old_ref_values IS
34: SELECT *
35: FROM IGS_FI_IMP_CHGS_ALL
36: WHERE rowid = x_rowid;
37:
38: BEGIN
39:

Line 163: igs_fi_impchgs_lines_pkg.get_fk_igs_fi_imp_chgs_all (

159: || (reverse chronological order - newest change first)
160: */
161: BEGIN
162:
163: igs_fi_impchgs_lines_pkg.get_fk_igs_fi_imp_chgs_all (
164: old_references.import_charges_id
165: );
166:
167: END check_child_existance;

Line 184: FROM igs_fi_imp_chgs_all

180: || (reverse chronological order - newest change first)
181: */
182: CURSOR cur_rowid IS
183: SELECT rowid
184: FROM igs_fi_imp_chgs_all
185: WHERE import_charges_id = x_import_charges_id
186: FOR UPDATE NOWAIT;
187:
188: lv_rowid cur_rowid%RowType;

Line 223: FROM igs_fi_imp_chgs_all

219: || (reverse chronological order - newest change first)
220: */
221: CURSOR cur_rowid IS
222: SELECT rowid
223: FROM igs_fi_imp_chgs_all
224: WHERE person_id = x_person_id
225: AND fee_type = x_fee_type
226: AND fee_cal_type = x_fee_cal_type
227: AND fee_ci_sequence_number = x_fee_ci_sequence_number

Line 254: FROM IGS_FI_IMP_CHGS_ALL

250: ) AS
251:
252: CURSOR cur_rowid IS
253: SELECT rowid
254: FROM IGS_FI_IMP_CHGS_ALL
255: WHERE transaction_type = x_transaction_type ;
256:
257: lv_rowid cur_rowid%RowType;
258:

Line 280: FROM IGS_FI_IMP_CHGS_ALL

276: ) AS
277:
278: CURSOR cur_rowid IS
279: SELECT rowid
280: FROM IGS_FI_IMP_CHGS_ALL
281: WHERE person_id = x_person_id ;
282:
283: lv_rowid cur_rowid%RowType;
284:

Line 404: FROM igs_fi_imp_chgs_all

400: || (reverse chronological order - newest change first)
401: */
402: CURSOR c IS
403: SELECT rowid
404: FROM igs_fi_imp_chgs_all
405: WHERE import_charges_id = x_import_charges_id;
406:
407: x_last_update_date DATE;
408: x_last_updated_by NUMBER;

Line 466: INSERT INTO igs_fi_imp_chgs_all (

462: x_last_updated_by => x_last_updated_by,
463: x_last_update_login => x_last_update_login
464: );
465:
466: INSERT INTO igs_fi_imp_chgs_all (
467: import_charges_id,
468: person_id,
469: fee_type,
470: fee_cal_type,

Line 541: FROM igs_fi_imp_chgs_all

537: fee_cal_type,
538: fee_ci_sequence_number,
539: transaction_type,
540: org_id
541: FROM igs_fi_imp_chgs_all
542: WHERE rowid = x_rowid
543: FOR UPDATE NOWAIT;
544:
545: tlinfo c1%ROWTYPE;

Line 658: UPDATE igs_fi_imp_chgs_all

654: x_program_update_date := SYSDATE;
655: END IF;
656: END IF;
657:
658: UPDATE igs_fi_imp_chgs_all
659: SET
660: person_id = new_references.person_id,
661: fee_type = new_references.fee_type,
662: fee_cal_type = new_references.fee_cal_type,

Line 704: FROM igs_fi_imp_chgs_all

700: || (reverse chronological order - newest change first)
701: */
702: CURSOR c1 IS
703: SELECT rowid
704: FROM igs_fi_imp_chgs_all
705: WHERE import_charges_id = x_import_charges_id;
706:
707: BEGIN
708:

Line 763: DELETE FROM igs_fi_imp_chgs_all

759: p_action => 'DELETE',
760: x_rowid => x_rowid
761: );
762:
763: DELETE FROM igs_fi_imp_chgs_all
764: WHERE rowid = x_rowid;
765:
766: IF (SQL%NOTFOUND) THEN
767: RAISE NO_DATA_FOUND;