APPS.IGS_FI_BALANCE_RULES_PKG dependencies on IGS_FI_BALANCE_RULES

Line 1: PACKAGE BODY igs_fi_balance_rules_pkg AS

1: PACKAGE BODY igs_fi_balance_rules_pkg AS
2: /* $Header: IGSSI95B.pls 115.9 2003/02/14 05:34:10 pathipat ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_fi_balance_rules%ROWTYPE;

Line 5: old_references igs_fi_balance_rules%ROWTYPE;

1: PACKAGE BODY igs_fi_balance_rules_pkg AS
2: /* $Header: IGSSI95B.pls 115.9 2003/02/14 05:34:10 pathipat ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_fi_balance_rules%ROWTYPE;
6: new_references igs_fi_balance_rules%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,

Line 6: new_references igs_fi_balance_rules%ROWTYPE;

2: /* $Header: IGSSI95B.pls 115.9 2003/02/14 05:34:10 pathipat ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_fi_balance_rules%ROWTYPE;
6: new_references igs_fi_balance_rules%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,
10: x_rowid IN VARCHAR2,

Line 37: FROM IGS_FI_BALANCE_RULES

33: */
34:
35: CURSOR cur_old_ref_values IS
36: SELECT *
37: FROM IGS_FI_BALANCE_RULES
38: WHERE rowid = x_rowid;
39:
40: BEGIN
41:

Line 155: FROM igs_fi_balance_rules

151: */
152:
153: CURSOR cur_rowid IS
154: SELECT rowid
155: FROM igs_fi_balance_rules
156: WHERE balance_rule_id = x_balance_rule_id ;
157:
158: lv_rowid cur_rowid%RowType;
159:

Line 276: FROM igs_fi_balance_rules

272: || vvutukur 24-Sep-2002 Enh#2564643.Removed DEFAULT clause from parameters as gscc fix.
273: */
274: CURSOR c IS
275: SELECT rowid
276: FROM igs_fi_balance_rules
277: WHERE balance_rule_id = x_balance_rule_id;
278:
279: x_last_update_date DATE;
280: x_last_updated_by NUMBER;

Line 304: SELECT igs_fi_balance_rules_s.NEXTVAL

300: igs_ge_msg_stack.add;
301: app_exception.raise_exception;
302: END IF;
303:
304: SELECT igs_fi_balance_rules_s.NEXTVAL
305: INTO x_balance_rule_id
306: FROM dual;
307:
308: before_dml(

Line 322: INSERT INTO igs_fi_balance_rules (

318: x_last_updated_by => x_last_updated_by,
319: x_last_update_login => x_last_update_login
320: );
321:
322: INSERT INTO igs_fi_balance_rules (
323: balance_rule_id,
324: balance_name,
325: version_number,
326: last_conversion_date,

Line 379: FROM igs_fi_balance_rules

375: SELECT
376: balance_name,
377: version_number,
378: last_conversion_date
379: FROM igs_fi_balance_rules
380: WHERE rowid = x_rowid
381: FOR UPDATE NOWAIT;
382:
383: tlinfo c1%ROWTYPE;

Line 475: UPDATE igs_fi_balance_rules

471: x_last_updated_by => x_last_updated_by,
472: x_last_update_login => x_last_update_login
473: );
474:
475: UPDATE igs_fi_balance_rules
476: SET
477: balance_name = new_references.balance_name,
478: version_number = new_references.version_number,
479: last_conversion_date = new_references.last_conversion_date,

Line 515: FROM igs_fi_balance_rules

511: || vvutukur 24-Sep-2002 Enh#2564643.Removed DEFAULT clause from parameters as gscc fix.
512: */
513: CURSOR c1 IS
514: SELECT rowid
515: FROM igs_fi_balance_rules
516: WHERE balance_rule_id = x_balance_rule_id;
517:
518: BEGIN
519:

Line 548: END igs_fi_balance_rules_pkg;

544: );
545:
546: END add_row;
547:
548: END igs_fi_balance_rules_pkg;