APPS.IGS_CA_DA_OVD_VALS_PKG dependencies on IGS_CA_DA_OVD_VALS

Line 1: PACKAGE BODY igs_ca_da_ovd_vals_pkg AS

1: PACKAGE BODY igs_ca_da_ovd_vals_pkg AS
2: /* $Header: IGSCI20B.pls 120.1 2005/08/11 05:48:17 appldev noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_ca_da_ovd_vals%ROWTYPE;

Line 5: old_references igs_ca_da_ovd_vals%ROWTYPE;

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

Line 6: new_references igs_ca_da_ovd_vals%ROWTYPE;

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

Line 34: FROM igs_ca_da_ovd_vals

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

Line 116: FROM igs_ca_da_ovd_vals

112: || (reverse chronological order - newest change first)
113: */
114: CURSOR cur_rowid IS
115: SELECT rowid
116: FROM igs_ca_da_ovd_vals
117: WHERE ovrd_val_id = x_ovrd_val_id
118: FOR UPDATE NOWAIT;
119:
120: lv_rowid cur_rowid%RowType;

Line 151: FROM igs_ca_da_ovd_vals

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

Line 282: fnd_message.set_token ('ROUTINE', 'IGS_CA_DA_OVD_VALS_PKG.INSERT_ROW');

278: x_last_update_login := -1;
279: END IF;
280: ELSE
281: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
282: fnd_message.set_token ('ROUTINE', 'IGS_CA_DA_OVD_VALS_PKG.INSERT_ROW');
283: igs_ge_msg_stack.add;
284: app_exception.raise_exception;
285: END IF;
286:

Line 304: INSERT INTO igs_ca_da_ovd_vals (

300: x_last_updated_by => x_last_updated_by,
301: x_last_update_login => x_last_update_login
302: );
303:
304: INSERT INTO igs_ca_da_ovd_vals (
305: ovrd_val_id,
306: sys_date_type,
307: element_code,
308: element_code_value,

Line 316: igs_ca_da_ovd_vals_s.NEXTVAL,

312: last_update_date,
313: last_updated_by,
314: last_update_login
315: ) VALUES (
316: igs_ca_da_ovd_vals_s.NEXTVAL,
317: new_references.sys_date_type,
318: new_references.element_code,
319: new_references.element_code_value,
320: new_references.date_alias,

Line 354: FROM igs_ca_da_ovd_vals

350: sys_date_type,
351: element_code,
352: element_code_value,
353: date_alias
354: FROM igs_ca_da_ovd_vals
355: WHERE rowid = x_rowid
356: FOR UPDATE NOWAIT;
357:
358: tlinfo c1%ROWTYPE;

Line 430: fnd_message.set_token ('ROUTINE', 'IGS_CA_DA_OVD_VALS_PKG.UPDATE_ROW');

426: x_last_update_login := -1;
427: END IF;
428: ELSE
429: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
430: fnd_message.set_token ('ROUTINE', 'IGS_CA_DA_OVD_VALS_PKG.UPDATE_ROW');
431: igs_ge_msg_stack.add;
432: app_exception.raise_exception;
433: END IF;
434:

Line 450: UPDATE igs_ca_da_ovd_vals

446: x_last_updated_by => x_last_updated_by,
447: x_last_update_login => x_last_update_login
448: );
449:
450: UPDATE igs_ca_da_ovd_vals
451: SET
452: sys_date_type = new_references.sys_date_type,
453: element_code = new_references.element_code,
454: element_code_value = new_references.element_code_value,

Line 488: FROM igs_ca_da_ovd_vals

484: || (reverse chronological order - newest change first)
485: */
486: CURSOR c1 IS
487: SELECT rowid
488: FROM igs_ca_da_ovd_vals
489: WHERE ovrd_val_id = x_ovrd_val_id;
490:
491: BEGIN
492:

Line 543: DELETE FROM igs_ca_da_ovd_vals

539: p_action => 'DELETE',
540: x_rowid => x_rowid
541: );
542:
543: DELETE FROM igs_ca_da_ovd_vals
544: WHERE rowid = x_rowid;
545:
546: IF (SQL%NOTFOUND) THEN
547: RAISE NO_DATA_FOUND;

Line 553: END igs_ca_da_ovd_vals_pkg;

549:
550: END delete_row;
551:
552:
553: END igs_ca_da_ovd_vals_pkg;