APPS.IGS_UC_INST_CONTROL_PKG dependencies on IGS_UC_INST_CONTROL

Line 1: PACKAGE BODY igs_uc_inst_control_pkg AS

1: PACKAGE BODY igs_uc_inst_control_pkg AS
2: /* $Header: IGSXI20B.pls 115.6 2003/07/10 13:45:39 smaddali noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_uc_inst_control%ROWTYPE;

Line 5: old_references igs_uc_inst_control%ROWTYPE;

1: PACKAGE BODY igs_uc_inst_control_pkg AS
2: /* $Header: IGSXI20B.pls 115.6 2003/07/10 13:45:39 smaddali noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_uc_inst_control%ROWTYPE;
6: new_references igs_uc_inst_control%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,

Line 6: new_references igs_uc_inst_control%ROWTYPE;

2: /* $Header: IGSXI20B.pls 115.6 2003/07/10 13:45:39 smaddali noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_uc_inst_control%ROWTYPE;
6: new_references igs_uc_inst_control%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,
10: x_rowid IN VARCHAR2,

Line 76: FROM IGS_UC_INST_CONTROL

72: */
73:
74: CURSOR cur_old_ref_values IS
75: SELECT *
76: FROM IGS_UC_INST_CONTROL
77: WHERE rowid = x_rowid;
78:
79: BEGIN
80:

Line 378: FROM igs_uc_inst_control;

374: || (reverse chronological order - newest change first)
375: */
376: CURSOR c IS
377: SELECT rowid
378: FROM igs_uc_inst_control;
379:
380:
381: x_last_update_date DATE;
382: x_last_updated_by NUMBER;

Line 462: INSERT INTO igs_uc_inst_control (

458: x_last_update_login => x_last_update_login ,
459: x_starx => x_starx
460: );
461:
462: INSERT INTO igs_uc_inst_control (
463: updater,
464: inst_type,
465: inst_short_name,
466: inst_name,

Line 686: FROM igs_uc_inst_control

682: clearing_accept_copy_form,
683: online_message,
684: ethnic_list_seq,
685: starx
686: FROM igs_uc_inst_control
687: WHERE rowid = x_rowid
688: FOR UPDATE NOWAIT;
689:
690: tlinfo c1%ROWTYPE;

Line 906: UPDATE igs_uc_inst_control

902: x_last_update_login => x_last_update_login ,
903: x_starx => x_starx
904: );
905:
906: UPDATE igs_uc_inst_control
907: SET
908: updater = new_references.updater,
909: inst_type = new_references.inst_type,
910: inst_short_name = new_references.inst_short_name,

Line 1028: FROM igs_uc_inst_control;

1024: || (reverse chronological order - newest change first)
1025: */
1026: CURSOR c1 IS
1027: SELECT rowid
1028: FROM igs_uc_inst_control;
1029:
1030:
1031: BEGIN
1032:

Line 1165: DELETE FROM igs_uc_inst_control

1161: p_action => 'DELETE',
1162: x_rowid => x_rowid
1163: );
1164:
1165: DELETE FROM igs_uc_inst_control
1166: WHERE rowid = x_rowid;
1167:
1168: IF (SQL%NOTFOUND) THEN
1169: RAISE NO_DATA_FOUND;

Line 1175: END igs_uc_inst_control_pkg;

1171:
1172: END delete_row;
1173:
1174:
1175: END igs_uc_inst_control_pkg;