APPS.IGS_UC_INST_CONTS_PKG dependencies on IGS_UC_INST_CONTS

Line 1: PACKAGE BODY igs_uc_inst_conts_pkg AS

1: PACKAGE BODY igs_uc_inst_conts_pkg AS
2: /* $Header: IGSXI21B.pls 115.7 2003/06/11 10:11:00 smaddali noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_uc_inst_conts%ROWTYPE;

Line 5: old_references igs_uc_inst_conts%ROWTYPE;

1: PACKAGE BODY igs_uc_inst_conts_pkg AS
2: /* $Header: IGSXI21B.pls 115.7 2003/06/11 10:11:00 smaddali noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_uc_inst_conts%ROWTYPE;
6: new_references igs_uc_inst_conts%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,

Line 6: new_references igs_uc_inst_conts%ROWTYPE;

2: /* $Header: IGSXI21B.pls 115.7 2003/06/11 10:11:00 smaddali noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_uc_inst_conts%ROWTYPE;
6: new_references igs_uc_inst_conts%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,
10: x_rowid IN VARCHAR2,

Line 42: FROM IGS_UC_INST_CONTS

38: */
39:
40: CURSOR cur_old_ref_values IS
41: SELECT *
42: FROM IGS_UC_INST_CONTS
43: WHERE rowid = x_rowid;
44:
45: BEGIN
46:

Line 103: igs_uc_inst_cnt_grp_pkg.get_fk_igs_uc_inst_conts (

99: || (reverse chronological order - newest change first)
100: */
101: BEGIN
102:
103: igs_uc_inst_cnt_grp_pkg.get_fk_igs_uc_inst_conts (
104: old_references.contact_code
105: );
106:
107: END check_child_existance;

Line 124: FROM igs_uc_inst_conts

120: || (reverse chronological order - newest change first)
121: */
122: CURSOR cur_rowid IS
123: SELECT rowid
124: FROM igs_uc_inst_conts
125: WHERE contact_code = x_contact_code ;
126:
127: lv_rowid cur_rowid%RowType;
128:

Line 258: FROM igs_uc_inst_conts

254: || (reverse chronological order - newest change first)
255: */
256: CURSOR c IS
257: SELECT rowid
258: FROM igs_uc_inst_conts
259: WHERE contact_code = x_contact_code;
260:
261: x_last_update_date DATE;
262: x_last_updated_by NUMBER;

Line 286: /* SELECT igs_uc_inst_conts_s.NEXTVAL

282: igs_ge_msg_stack.add;
283: app_exception.raise_exception;
284: END IF;
285:
286: /* SELECT igs_uc_inst_conts_s.NEXTVAL
287: INTO x_contact_code
288: FROM dual;
289: */
290: before_dml(

Line 312: INSERT INTO igs_uc_inst_conts (

308: x_last_updated_by => x_last_updated_by,
309: x_last_update_login => x_last_update_login
310: );
311:
312: INSERT INTO igs_uc_inst_conts (
313: contact_code,
314: updater,
315: name,
316: post,

Line 399: FROM igs_uc_inst_conts

395: telephone,
396: fax,
397: email,
398: sent_to_ucas
399: FROM igs_uc_inst_conts
400: WHERE rowid = x_rowid
401: FOR UPDATE NOWAIT;
402:
403: tlinfo c1%ROWTYPE;

Line 516: UPDATE igs_uc_inst_conts

512: x_last_updated_by => x_last_updated_by,
513: x_last_update_login => x_last_update_login
514: );
515:
516: UPDATE igs_uc_inst_conts
517: SET
518: updater = new_references.updater,
519: name = new_references.name,
520: post = new_references.post,

Line 569: FROM igs_uc_inst_conts

565: || (reverse chronological order - newest change first)
566: */
567: CURSOR c1 IS
568: SELECT rowid
569: FROM igs_uc_inst_conts
570: WHERE contact_code = x_contact_code;
571:
572: BEGIN
573:

Line 638: DELETE FROM igs_uc_inst_conts

634: p_action => 'DELETE',
635: x_rowid => x_rowid
636: );
637:
638: DELETE FROM igs_uc_inst_conts
639: WHERE rowid = x_rowid;
640:
641: IF (SQL%NOTFOUND) THEN
642: RAISE NO_DATA_FOUND;

Line 648: END igs_uc_inst_conts_pkg;

644:
645: END delete_row;
646:
647:
648: END igs_uc_inst_conts_pkg;