APPS.IGS_FI_POSTING_INT_PKG dependencies on IGS_FI_POSTING_INT_ALL

Line 5: old_references igs_fi_posting_int_all%ROWTYPE;

1: PACKAGE BODY igs_fi_posting_int_pkg AS
2: /* $Header: IGSSIA1B.pls 115.13 2003/02/17 09:14:52 pathipat ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_fi_posting_int_all%ROWTYPE;
6: new_references igs_fi_posting_int_all%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,

Line 6: new_references igs_fi_posting_int_all%ROWTYPE;

2: /* $Header: IGSSIA1B.pls 115.13 2003/02/17 09:14:52 pathipat ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_fi_posting_int_all%ROWTYPE;
6: new_references igs_fi_posting_int_all%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,
10: x_rowid IN VARCHAR2 ,

Line 46: FROM IGS_FI_POSTING_INT_ALL

42: */
43:
44: CURSOR cur_old_ref_values IS
45: SELECT *
46: FROM IGS_FI_POSTING_INT_ALL
47: WHERE rowid = x_rowid;
48:
49: BEGIN
50:

Line 160: igs_fi_applications_pkg.get_fk_igs_fi_posting_int_all (

156: || (reverse chronological order - newest change first)
157: */
158: BEGIN
159:
160: igs_fi_applications_pkg.get_fk_igs_fi_posting_int_all (
161: old_references.posting_id
162: );
163:
164: igs_fi_cr_activities_pkg.get_fk_igs_fi_posting_int_all (

Line 164: igs_fi_cr_activities_pkg.get_fk_igs_fi_posting_int_all (

160: igs_fi_applications_pkg.get_fk_igs_fi_posting_int_all (
161: old_references.posting_id
162: );
163:
164: igs_fi_cr_activities_pkg.get_fk_igs_fi_posting_int_all (
165: old_references.posting_id
166: );
167:
168: igs_fi_invln_int_pkg.get_fk_igs_fi_posting_int_all (

Line 168: igs_fi_invln_int_pkg.get_fk_igs_fi_posting_int_all (

164: igs_fi_cr_activities_pkg.get_fk_igs_fi_posting_int_all (
165: old_references.posting_id
166: );
167:
168: igs_fi_invln_int_pkg.get_fk_igs_fi_posting_int_all (
169: old_references.posting_id
170: );
171:
172: END check_child_existance;

Line 189: FROM igs_fi_posting_int_all

185: || (reverse chronological order - newest change first)
186: */
187: CURSOR cur_rowid IS
188: SELECT rowid
189: FROM igs_fi_posting_int_all
190: WHERE posting_id = x_posting_id
191: FOR UPDATE NOWAIT;
192:
193: lv_rowid cur_rowid%RowType;

Line 339: FROM igs_fi_posting_int_all

335: || (reverse chronological order - newest change first)
336: */
337: CURSOR c IS
338: SELECT rowid
339: FROM igs_fi_posting_int_all
340: WHERE posting_id = x_posting_id;
341:
342: x_last_update_date DATE;
343: x_last_updated_by NUMBER;

Line 414: INSERT INTO igs_fi_posting_int_all (

410: x_last_update_login => x_last_update_login ,
411: x_posting_control_id => x_posting_control_id
412: );
413:
414: INSERT INTO igs_fi_posting_int_all (
415: posting_id,
416: batch_name,
417: accounting_date,
418: transaction_date,

Line 524: FROM igs_fi_posting_int_all

520: source_transaction_type,
521: status,
522: orig_appl_fee_ref,
523: posting_control_id
524: FROM igs_fi_posting_int_all
525: WHERE rowid = x_rowid
526: FOR UPDATE NOWAIT;
527:
528: tlinfo c1%ROWTYPE;

Line 669: UPDATE igs_fi_posting_int_all

665: x_program_update_date := SYSDATE;
666: END IF;
667: END IF;
668:
669: UPDATE igs_fi_posting_int_all
670: SET
671: batch_name = new_references.batch_name,
672: accounting_date = new_references.accounting_date,
673: transaction_date = new_references.transaction_date,

Line 733: FROM igs_fi_posting_int_all

729: || (reverse chronological order - newest change first)
730: */
731: CURSOR c1 IS
732: SELECT rowid
733: FROM igs_fi_posting_int_all
734: WHERE posting_id = x_posting_id;
735:
736: BEGIN
737:

Line 808: DELETE FROM igs_fi_posting_int_all

804: p_action => 'DELETE',
805: x_rowid => x_rowid
806: );
807:
808: DELETE FROM igs_fi_posting_int_all
809: WHERE rowid = x_rowid;
810:
811: IF (SQL%NOTFOUND) THEN
812: RAISE NO_DATA_FOUND;