APPS.IGS_CA_DA_OVD_RULES_PKG dependencies on IGS_CA_DA_OVD_RULES

Line 1: PACKAGE BODY igs_ca_da_ovd_rules_pkg AS

1: PACKAGE BODY igs_ca_da_ovd_rules_pkg AS
2: /* $Header: IGSCI19B.pls 120.1 2005/08/11 05:47:41 appldev noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_ca_da_ovd_rules%ROWTYPE;

Line 5: old_references igs_ca_da_ovd_rules%ROWTYPE;

1: PACKAGE BODY igs_ca_da_ovd_rules_pkg AS
2: /* $Header: IGSCI19B.pls 120.1 2005/08/11 05:47:41 appldev noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_ca_da_ovd_rules%ROWTYPE;
6: new_references igs_ca_da_ovd_rules%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,

Line 6: new_references igs_ca_da_ovd_rules%ROWTYPE;

2: /* $Header: IGSCI19B.pls 120.1 2005/08/11 05:47:41 appldev noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_ca_da_ovd_rules%ROWTYPE;
6: new_references igs_ca_da_ovd_rules%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,
10: x_rowid IN VARCHAR2,

Line 34: FROM igs_ca_da_ovd_rules

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

Line 117: FROM igs_ca_da_ovd_rules

113: || (reverse chronological order - newest change first)
114: */
115: CURSOR cur_rowid IS
116: SELECT rowid
117: FROM igs_ca_da_ovd_rules
118: WHERE sys_date_type = x_sys_date_type
119: AND element_code = x_element_code
120: FOR UPDATE NOWAIT;
121:

Line 153: FROM igs_ca_da_ovd_rules

149: || (reverse chronological order - newest change first)
150: */
151: CURSOR cur_rowid IS
152: SELECT rowid
153: FROM igs_ca_da_ovd_rules
154: WHERE ((sys_date_type = x_sys_date_type));
155:
156: lv_rowid cur_rowid%RowType;
157:

Line 286: fnd_message.set_token ('ROUTINE', 'IGS_CA_DA_OVD_RULES_PKG.INSERT_ROW');

282: x_last_update_login := -1;
283: END IF;
284: ELSE
285: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
286: fnd_message.set_token ('ROUTINE', 'IGS_CA_DA_OVD_RULES_PKG.INSERT_ROW');
287: igs_ge_msg_stack.add;
288: app_exception.raise_exception;
289: END IF;
290:

Line 307: INSERT INTO igs_ca_da_ovd_rules (

303: x_last_updated_by => x_last_updated_by,
304: x_last_update_login => x_last_update_login
305: );
306:
307: INSERT INTO igs_ca_da_ovd_rules (
308: sys_date_type,
309: element_code,
310: sql_val,
311: sql_val_ovrd_flag,

Line 358: FROM igs_ca_da_ovd_rules

354: element_code,
355: sql_val,
356: sql_val_ovrd_flag,
357: closed_ind
358: FROM igs_ca_da_ovd_rules
359: WHERE rowid = x_rowid
360: FOR UPDATE NOWAIT;
361:
362: tlinfo c1%ROWTYPE;

Line 435: fnd_message.set_token ('ROUTINE', 'IGS_CA_DA_OVD_RULES_PKG.UPDATE_ROW');

431: x_last_update_login := -1;
432: END IF;
433: ELSE
434: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
435: fnd_message.set_token ('ROUTINE', 'IGS_CA_DA_OVD_RULES_PKG.UPDATE_ROW');
436: igs_ge_msg_stack.add;
437: app_exception.raise_exception;
438: END IF;
439:

Line 455: UPDATE igs_ca_da_ovd_rules

451: x_last_updated_by => x_last_updated_by,
452: x_last_update_login => x_last_update_login
453: );
454:
455: UPDATE igs_ca_da_ovd_rules
456: SET
457: sys_date_type = new_references.sys_date_type,
458: element_code = new_references.element_code,
459: sql_val = new_references.sql_val,

Line 494: FROM igs_ca_da_ovd_rules

490: || (reverse chronological order - newest change first)
491: */
492: CURSOR c1 IS
493: SELECT rowid
494: FROM igs_ca_da_ovd_rules
495: WHERE sys_date_type = x_sys_date_type
496: AND element_code = x_element_code;
497:
498: BEGIN

Line 529: END igs_ca_da_ovd_rules_pkg;

525: );
526:
527: END add_row;
528:
529: END igs_ca_da_ovd_rules_pkg;