APPS.IGS_UC_UCAS_CONTROL_PKG dependencies on IGS_UC_UCAS_CONTROL

Line 1: PACKAGE BODY igs_uc_ucas_control_pkg AS

1: PACKAGE BODY igs_uc_ucas_control_pkg AS
2: /* $Header: IGSXI33B.pls 120.2 2006/02/22 01:37:13 jchakrab noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_uc_ucas_control%ROWTYPE;

Line 5: old_references igs_uc_ucas_control%ROWTYPE;

1: PACKAGE BODY igs_uc_ucas_control_pkg AS
2: /* $Header: IGSXI33B.pls 120.2 2006/02/22 01:37:13 jchakrab noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_uc_ucas_control%ROWTYPE;
6: new_references igs_uc_ucas_control%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,

Line 6: new_references igs_uc_ucas_control%ROWTYPE;

2: /* $Header: IGSXI33B.pls 120.2 2006/02/22 01:37:13 jchakrab noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_uc_ucas_control%ROWTYPE;
6: new_references igs_uc_ucas_control%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,
10: x_rowid IN VARCHAR2,

Line 63: FROM IGS_UC_UCAS_CONTROL

59: */
60:
61: CURSOR cur_old_ref_values IS
62: SELECT *
63: FROM IGS_UC_UCAS_CONTROL
64: WHERE rowid = x_rowid;
65:
66: BEGIN
67:

Line 171: FROM igs_uc_ucas_control

167: || (reverse chronological order - newest change first)
168: */
169: CURSOR cur_rowid IS
170: SELECT rowid
171: FROM igs_uc_ucas_control
172: WHERE system_code = x_system_code
173: AND ucas_cycle = x_ucas_cycle;
174:
175: lv_rowid cur_rowid%RowType;

Line 363: FROM igs_uc_ucas_control

359: || (reverse chronological order - newest change first)
360: */
361: CURSOR c IS
362: SELECT rowid
363: FROM igs_uc_ucas_control
364: WHERE system_code = x_system_code
365: AND ucas_cycle = x_ucas_cycle;
366:
367:

Line 435: INSERT INTO igs_uc_ucas_control (

431: x_gttr_clear_toy_code => x_gttr_clear_toy_code,
432: x_transaction_toy_code => x_transaction_toy_code
433: );
434:
435: INSERT INTO igs_uc_ucas_control (
436: entry_year,
437: time_of_year,
438: time_of_day,
439: routeb_time_of_year,

Line 605: FROM igs_uc_ucas_control

601: ucas_cycle,
602: gttr_clear_toy_code,
603: transaction_toy_code
604:
605: FROM igs_uc_ucas_control
606: WHERE rowid = x_rowid
607: FOR UPDATE NOWAIT;
608:
609: tlinfo c1%ROWTYPE;

Line 780: UPDATE igs_uc_ucas_control

776: x_gttr_clear_toy_code => x_gttr_clear_toy_code,
777: x_transaction_toy_code => x_transaction_toy_code
778: );
779:
780: UPDATE igs_uc_ucas_control
781: SET
782: entry_year = new_references.entry_year,
783: time_of_year = new_references.time_of_year,
784: time_of_day = new_references.time_of_day,

Line 881: FROM igs_uc_ucas_control

877: || (reverse chronological order - newest change first)
878: */
879: CURSOR c1 IS
880: SELECT rowid
881: FROM igs_uc_ucas_control
882: WHERE system_code = x_system_code
883: AND ucas_cycle = x_ucas_cycle;
884:
885:

Line 990: DELETE FROM igs_uc_ucas_control

986: p_action => 'DELETE',
987: x_rowid => x_rowid
988: );
989:
990: DELETE FROM igs_uc_ucas_control
991: WHERE rowid = x_rowid;
992:
993: IF (SQL%NOTFOUND) THEN
994: RAISE NO_DATA_FOUND;

Line 1000: END igs_uc_ucas_control_pkg;

996:
997: END delete_row;
998:
999:
1000: END igs_uc_ucas_control_pkg;