APPS.IGS_FI_CONTROL_PKG dependencies on IGS_FI_CONTROL

Line 1: PACKAGE BODY igs_fi_control_pkg AS

1: PACKAGE BODY igs_fi_control_pkg AS
2: /* $Header: IGSSI78B.pls 120.2 2006/06/19 09:25:06 sapanigr ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_fi_control_all%RowType;

Line 5: old_references igs_fi_control_all%RowType;

1: PACKAGE BODY igs_fi_control_pkg AS
2: /* $Header: IGSSI78B.pls 120.2 2006/06/19 09:25:06 sapanigr ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_fi_control_all%RowType;
6: new_references igs_fi_control_all%RowType;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,

Line 6: new_references igs_fi_control_all%RowType;

2: /* $Header: IGSSI78B.pls 120.2 2006/06/19 09:25:06 sapanigr ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_fi_control_all%RowType;
6: new_references igs_fi_control_all%RowType;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,
10: x_rowid IN VARCHAR2 ,

Line 78: FROM IGS_FI_CONTROL_ALL

74: msrinivi 17 Jul, 2001 Added a new column, set_of_books_id
75: ***************************************************************/
76: CURSOR cur_old_ref_values IS
77: SELECT *
78: FROM IGS_FI_CONTROL_ALL
79: WHERE rowid = x_rowid;
80: BEGIN
81: l_rowid := x_rowid;
82: -- Code for setting the Old and New Reference Values.

Line 386: FROM igs_fi_control

382: (reverse chronological order - newest change first)
383: ***************************************************************/
384: CURSOR cur_rowid IS
385: SELECT row_id
386: FROM igs_fi_control
387: WHERE rec_installed = x_rec_installed
388: FOR UPDATE NOWAIT;
389:
390: lv_rowid cur_rowid%ROWTYPE;

Line 635: FROM igs_fi_control

631: msrinivi 17 Jul,2001 Added a new column, set_of_books_id
632: ***************************************************************/
633: CURSOR c IS
634: SELECT ROWID
635: FROM igs_fi_control
636: WHERE rec_installed= x_rec_installed;
637:
638: x_last_update_date DATE ;
639: x_last_updated_by NUMBER ;

Line 709: INSERT INTO igs_fi_control_all (

705: x_post_waiver_gl_flag => x_post_waiver_gl_flag,
706: x_waiver_notify_finaid_flag => x_waiver_notify_finaid_flag
707: );
708:
709: INSERT INTO igs_fi_control_all (
710: rec_installed,
711: creation_date,
712: created_by,
713: last_update_date,

Line 882: FROM igs_fi_control_all

878: manage_accounts,
879: acct_conv_flag,
880: post_waiver_gl_flag,
881: waiver_notify_finaid_flag
882: FROM igs_fi_control_all
883: WHERE rowid = x_rowid
884: FOR UPDATE NOWAIT;
885:
886: tlinfo c1%ROWTYPE;

Line 1085: UPDATE igs_fi_control_all

1081: x_post_waiver_gl_flag => x_post_waiver_gl_flag,
1082: x_waiver_notify_finaid_flag => x_waiver_notify_finaid_flag
1083: );
1084:
1085: UPDATE igs_fi_control_all
1086: SET
1087: rec_installed = new_references.rec_installed,
1088: last_update_date = new_references.last_update_date,
1089: last_updated_by = new_references.last_updated_by,

Line 1150: DELETE FROM IGS_FI_CONTROL_ALL

1146: p_action => 'DELETE',
1147: x_rowid => x_rowid
1148: );
1149:
1150: DELETE FROM IGS_FI_CONTROL_ALL
1151: WHERE rowid = x_rowid;
1152: IF (sql%NOTFOUND) THEN
1153: RAISE NO_DATA_FOUND;
1154: END IF;

Line 1172: coulmn in IGS_FI_CONTROL table with dt_alias coulmn in IGS_CA_DA table.

1168: Date created: 03-Apr-2006
1169:
1170: Purpose:
1171: This procedure is created as part of the bug 4025077 to add FK relation for refund_dt_alias
1172: coulmn in IGS_FI_CONTROL table with dt_alias coulmn in IGS_CA_DA table.
1173:
1174: Change History: (who, when, what: NO CREATION RECORDS HERE!)
1175: Who When What
1176: *******************************************************************************/

Line 1179: FROM IGS_FI_CONTROL_ALL

1175: Who When What
1176: *******************************************************************************/
1177: CURSOR cur_rowid IS
1178: SELECT rowid
1179: FROM IGS_FI_CONTROL_ALL
1180: WHERE ((REFUND_DT_ALIAS = x_dt_alias));
1181:
1182: lv_rowid cur_rowid%RowType;
1183:

Line 1199: END igs_fi_control_pkg;

1195: CLOSE cur_rowid;
1196:
1197: END get_fk_igs_ca_da;
1198:
1199: END igs_fi_control_pkg;