APPS.IGS_UC_INST_CNT_GRP_PKG dependencies on IGS_UC_INST_CNT_GRP

Line 1: PACKAGE BODY igs_uc_inst_cnt_grp_pkg AS

1: PACKAGE BODY igs_uc_inst_cnt_grp_pkg AS
2: /* $Header: IGSXI19B.pls 115.8 2003/06/11 10:09:42 smaddali noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_uc_inst_cnt_grp%ROWTYPE;

Line 5: old_references igs_uc_inst_cnt_grp%ROWTYPE;

1: PACKAGE BODY igs_uc_inst_cnt_grp_pkg AS
2: /* $Header: IGSXI19B.pls 115.8 2003/06/11 10:09:42 smaddali noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_uc_inst_cnt_grp%ROWTYPE;
6: new_references igs_uc_inst_cnt_grp%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,

Line 6: new_references igs_uc_inst_cnt_grp%ROWTYPE;

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

Line 35: FROM IGS_UC_INST_CNT_GRP

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

Line 118: FROM igs_uc_inst_cnt_grp

114: || (reverse chronological order - newest change first)
115: */
116: CURSOR cur_rowid IS
117: SELECT rowid
118: FROM igs_uc_inst_cnt_grp
119: WHERE contact_code = x_contact_code
120: AND ucas_group = x_ucas_group ;
121:
122: lv_rowid cur_rowid%RowType;

Line 153: FROM igs_uc_inst_cnt_grp

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

Line 268: FROM igs_uc_inst_cnt_grp

264: || (reverse chronological order - newest change first)
265: */
266: CURSOR c IS
267: SELECT rowid
268: FROM igs_uc_inst_cnt_grp
269: WHERE contact_code = x_contact_code
270: AND ucas_group = x_ucas_group;
271:
272: x_last_update_date DATE;

Line 312: INSERT INTO igs_uc_inst_cnt_grp (

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_cnt_grp (
313: contact_code,
314: updater,
315: ucas_group,
316: sent_to_ucas,

Line 370: FROM igs_uc_inst_cnt_grp

366: SELECT
367: updater,
368: sent_to_ucas,
369: deleted
370: FROM igs_uc_inst_cnt_grp
371: WHERE rowid = x_rowid
372: FOR UPDATE NOWAIT;
373:
374: tlinfo c1%ROWTYPE;

Line 465: UPDATE igs_uc_inst_cnt_grp

461: x_last_updated_by => x_last_updated_by,
462: x_last_update_login => x_last_update_login
463: );
464:
465: UPDATE igs_uc_inst_cnt_grp
466: SET
467: updater = new_references.updater,
468: sent_to_ucas = new_references.sent_to_ucas,
469: deleted = new_references.deleted,

Line 503: FROM igs_uc_inst_cnt_grp

499: || (reverse chronological order - newest change first)
500: */
501: CURSOR c1 IS
502: SELECT rowid
503: FROM igs_uc_inst_cnt_grp
504: WHERE contact_code = x_contact_code
505: AND ucas_group = x_ucas_group;
506:
507: BEGIN

Line 559: DELETE FROM igs_uc_inst_cnt_grp

555: p_action => 'DELETE',
556: x_rowid => x_rowid
557: );
558:
559: DELETE FROM igs_uc_inst_cnt_grp
560: WHERE rowid = x_rowid;
561:
562: IF (SQL%NOTFOUND) THEN
563: RAISE NO_DATA_FOUND;

Line 569: END igs_uc_inst_cnt_grp_pkg;

565:
566: END delete_row;
567:
568:
569: END igs_uc_inst_cnt_grp_pkg;