APPS.IGS_FI_APP_RULES_PKG dependencies on IGS_FI_APP_RULES

Line 1: PACKAGE BODY igs_fi_app_rules_pkg AS

1: PACKAGE BODY igs_fi_app_rules_pkg AS
2: /* $Header: IGSSI90B.pls 120.4 2005/10/10 23:19:28 appldev ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_fi_app_rules%ROWTYPE;

Line 5: old_references igs_fi_app_rules%ROWTYPE;

1: PACKAGE BODY igs_fi_app_rules_pkg AS
2: /* $Header: IGSSI90B.pls 120.4 2005/10/10 23:19:28 appldev ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_fi_app_rules%ROWTYPE;
6: new_references igs_fi_app_rules%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,

Line 6: new_references igs_fi_app_rules%ROWTYPE;

2: /* $Header: IGSSI90B.pls 120.4 2005/10/10 23:19:28 appldev ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_fi_app_rules%ROWTYPE;
6: new_references igs_fi_app_rules%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,
10: x_rowid IN VARCHAR2 DEFAULT NULL,

Line 35: FROM IGS_FI_APP_RULES

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

Line 95: FROM igs_fi_app_rules

91: CURSOR cur_app(cp_appl_hier_id IN NUMBER,
92: cp_rule_type IN VARCHAR2,
93: cp_fee_type IN VARCHAR2) IS
94: SELECT 'x'
95: FROM igs_fi_app_rules
96: WHERE appl_hierarchy_id = cp_appl_hier_id
97: AND rule_type = cp_rule_type
98: AND fee_type = cp_fee_type
99: AND enabled_flag = 'Y';

Line 154: FROM igs_fi_app_rules

150: || vvutukur 30-dec-2002 Bug#2725955.Modified cursor cur_rule to add check for rowid also.
151: */
152: CURSOR cur_rule IS
153: SELECT rowid
154: FROM igs_fi_app_rules
155: WHERE appl_hierarchy_id = x_appl_hierarchy_id
156: AND rule_type = x_rule_type
157: AND rule_sequence = x_rule_sequence
158: AND ((l_rowid IS NULL) OR (rowid <> l_rowid));

Line 270: FROM igs_fi_app_rules

266: || (reverse chronological order - newest change first)
267: */
268: CURSOR cur_rowid IS
269: SELECT rowid
270: FROM igs_fi_app_rules
271: WHERE appl_rule_id = x_appl_rule_id
272: FOR UPDATE NOWAIT;
273:
274: lv_rowid cur_rowid%RowType;

Line 308: FROM igs_fi_app_rules

304: || agairola 06-Oct-2005 For bug 4212082
305: */
306: CURSOR cur_rowid IS
307: SELECT rowid
308: FROM igs_fi_app_rules
309: WHERE appl_hierarchy_id = x_appl_hierarchy_id
310: AND fee_type = x_fee_type
311: AND rule_type = x_rule_type
312: AND ((l_rowid IS NULL) OR (rowid <> l_rowid));

Line 344: FROM igs_fi_app_rules

340: || (reverse chronological order - newest change first)
341: */
342: CURSOR cur_rowid IS
343: SELECT rowid
344: FROM igs_fi_app_rules
345: WHERE ((appl_hierarchy_id = x_appl_hierarchy_id));
346:
347: lv_rowid cur_rowid%RowType;
348:

Line 472: FROM igs_fi_app_rules

468: || (reverse chronological order - newest change first)
469: */
470: CURSOR c IS
471: SELECT rowid
472: FROM igs_fi_app_rules
473: WHERE appl_rule_id = x_appl_rule_id;
474:
475: x_last_update_date DATE;
476: x_last_updated_by NUMBER;

Line 500: SELECT igs_fi_app_rules_s.NEXTVAL

496: igs_ge_msg_stack.add;
497: app_exception.raise_exception;
498: END IF;
499:
500: SELECT igs_fi_app_rules_s.NEXTVAL
501: INTO x_appl_rule_id
502: FROM dual;
503:
504: before_dml(

Line 520: INSERT INTO igs_fi_app_rules (

516: x_last_updated_by => x_last_updated_by,
517: x_last_update_login => x_last_update_login
518: );
519:
520: INSERT INTO igs_fi_app_rules (
521: appl_rule_id,
522: appl_hierarchy_id,
523: rule_sequence,
524: fee_type,

Line 582: FROM igs_fi_app_rules

578: rule_sequence,
579: fee_type,
580: enabled_flag,
581: rule_type
582: FROM igs_fi_app_rules
583: WHERE rowid = x_rowid
584: FOR UPDATE NOWAIT;
585:
586: tlinfo c1%ROWTYPE;

Line 680: UPDATE igs_fi_app_rules

676: x_last_updated_by => x_last_updated_by,
677: x_last_update_login => x_last_update_login
678: );
679:
680: UPDATE igs_fi_app_rules
681: SET
682: appl_hierarchy_id = new_references.appl_hierarchy_id,
683: rule_sequence = new_references.rule_sequence,
684: fee_type = new_references.fee_type,

Line 720: FROM igs_fi_app_rules

716: || (reverse chronological order - newest change first)
717: */
718: CURSOR c1 IS
719: SELECT rowid
720: FROM igs_fi_app_rules
721: WHERE appl_rule_id = x_appl_rule_id;
722:
723: BEGIN
724:

Line 777: DELETE FROM igs_fi_app_rules

773: p_action => 'DELETE',
774: x_rowid => x_rowid
775: );
776:
777: DELETE FROM igs_fi_app_rules
778: WHERE rowid = x_rowid;
779:
780: IF (SQL%NOTFOUND) THEN
781: RAISE NO_DATA_FOUND;

Line 787: END igs_fi_app_rules_pkg;

783:
784: END delete_row;
785:
786:
787: END igs_fi_app_rules_pkg;