APPS.IGS_FI_BAL_EX_C_TYPS_PKG dependencies on IGS_FI_BAL_EX_C_TYPS

Line 1: PACKAGE BODY igs_fi_bal_ex_c_typs_pkg AS

1: PACKAGE BODY igs_fi_bal_ex_c_typs_pkg AS
2: /* $Header: IGSSI98B.pls 115.9 2003/03/19 08:36:16 smadathi ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_fi_bal_ex_c_typs%ROWTYPE;

Line 5: old_references igs_fi_bal_ex_c_typs%ROWTYPE;

1: PACKAGE BODY igs_fi_bal_ex_c_typs_pkg AS
2: /* $Header: IGSSI98B.pls 115.9 2003/03/19 08:36:16 smadathi ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_fi_bal_ex_c_typs%ROWTYPE;
6: new_references igs_fi_bal_ex_c_typs%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,

Line 6: new_references igs_fi_bal_ex_c_typs%ROWTYPE;

2: /* $Header: IGSSI98B.pls 115.9 2003/03/19 08:36:16 smadathi ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_fi_bal_ex_c_typs%ROWTYPE;
6: new_references igs_fi_bal_ex_c_typs%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,
10: x_rowid IN VARCHAR2 DEFAULT NULL,

Line 33: FROM IGS_FI_BAL_EX_C_TYPS

29: */
30:
31: CURSOR cur_old_ref_values IS
32: SELECT *
33: FROM IGS_FI_BAL_EX_C_TYPS
34: WHERE rowid = x_rowid;
35:
36: BEGIN
37:

Line 147: FROM igs_fi_bal_ex_c_typs

143: || (reverse chronological order - newest change first)
144: */
145: CURSOR cur_rowid IS
146: SELECT rowid
147: FROM igs_fi_bal_ex_c_typs
148: WHERE bal_exc_credit_type_id = x_bal_exc_credit_type_id
149: FOR UPDATE NOWAIT;
150:
151: lv_rowid cur_rowid%RowType;

Line 181: FROM igs_fi_bal_ex_c_typs

177: || (reverse chronological order - newest change first)
178: */
179: CURSOR cur_rowid IS
180: SELECT rowid
181: FROM igs_fi_bal_ex_c_typs
182: WHERE balance_rule_id = x_balance_rule_id
183: AND credit_type_id = x_credit_type_id
184: AND ((l_rowid IS NULL) OR (rowid <> l_rowid));
185:

Line 217: FROM igs_fi_bal_ex_c_typs

213: || (reverse chronological order - newest change first)
214: */
215: CURSOR cur_rowid IS
216: SELECT rowid
217: FROM igs_fi_bal_ex_c_typs
218: WHERE ((credit_type_id = x_credit_type_id));
219:
220: lv_rowid cur_rowid%RowType;
221:

Line 329: FROM igs_fi_bal_ex_c_typs

325: || smadathi 10-Apr-2002 Bug 2289191. Enabled_flag column reference removed.
326: */
327: CURSOR c IS
328: SELECT rowid
329: FROM igs_fi_bal_ex_c_typs
330: WHERE bal_exc_credit_type_id = x_bal_exc_credit_type_id;
331:
332: x_last_update_date DATE;
333: x_last_updated_by NUMBER;

Line 357: SELECT igs_fi_bal_ex_c_typs_s.NEXTVAL

353: igs_ge_msg_stack.add;
354: app_exception.raise_exception;
355: END IF;
356:
357: SELECT igs_fi_bal_ex_c_typs_s.NEXTVAL
358: INTO x_bal_exc_credit_type_id
359: FROM dual;
360:
361: before_dml(

Line 374: INSERT INTO igs_fi_bal_ex_c_typs (

370: x_last_updated_by => x_last_updated_by,
371: x_last_update_login => x_last_update_login
372: );
373:
374: INSERT INTO igs_fi_bal_ex_c_typs (
375: bal_exc_credit_type_id,
376: balance_rule_id,
377: credit_type_id,
378: creation_date,

Line 425: FROM igs_fi_bal_ex_c_typs

421: CURSOR c1 IS
422: SELECT
423: balance_rule_id,
424: credit_type_id
425: FROM igs_fi_bal_ex_c_typs
426: WHERE rowid = x_rowid
427: FOR UPDATE NOWAIT;
428:
429: tlinfo c1%ROWTYPE;

Line 515: UPDATE igs_fi_bal_ex_c_typs

511: x_last_updated_by => x_last_updated_by,
512: x_last_update_login => x_last_update_login
513: );
514:
515: UPDATE igs_fi_bal_ex_c_typs
516: SET
517: balance_rule_id = new_references.balance_rule_id,
518: credit_type_id = new_references.credit_type_id,
519: last_update_date = x_last_update_date,

Line 550: FROM igs_fi_bal_ex_c_typs

546: || smadathi 10-Apr-2002 Bug 2289191. Enabled_flag column reference removed.
547: */
548: CURSOR c1 IS
549: SELECT rowid
550: FROM igs_fi_bal_ex_c_typs
551: WHERE bal_exc_credit_type_id = x_bal_exc_credit_type_id;
552:
553: BEGIN
554:

Line 601: DELETE FROM igs_fi_bal_ex_c_typs

597: p_action => 'DELETE',
598: x_rowid => x_rowid
599: );
600:
601: DELETE FROM igs_fi_bal_ex_c_typs
602: WHERE rowid = x_rowid;
603:
604: IF (SQL%NOTFOUND) THEN
605: RAISE NO_DATA_FOUND;

Line 611: END igs_fi_bal_ex_c_typs_pkg;

607:
608: END delete_row;
609:
610:
611: END igs_fi_bal_ex_c_typs_pkg;