APPS.IGS_UC_CRSE_DETS_PKG dependencies on IGS_UC_CRSE_DETS

Line 1: PACKAGE BODY igs_uc_crse_dets_pkg AS

1: PACKAGE BODY igs_uc_crse_dets_pkg AS
2: /* $Header: IGSXI14B.pls 115.12 2003/06/11 10:57:55 smaddali noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_uc_crse_dets%ROWTYPE;

Line 5: old_references igs_uc_crse_dets%ROWTYPE;

1: PACKAGE BODY igs_uc_crse_dets_pkg AS
2: /* $Header: IGSXI14B.pls 115.12 2003/06/11 10:57:55 smaddali noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_uc_crse_dets%ROWTYPE;
6: new_references igs_uc_crse_dets%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,

Line 6: new_references igs_uc_crse_dets%ROWTYPE;

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

Line 71: FROM IGS_UC_CRSE_DETS

67: */
68:
69: CURSOR cur_old_ref_values IS
70: SELECT *
71: FROM IGS_UC_CRSE_DETS
72: WHERE rowid = x_rowid;
73:
74: BEGIN
75:

Line 191: FROM igs_uc_crse_dets

187: || (reverse chronological order - newest change first)
188: */
189: CURSOR cur_rowid IS
190: SELECT rowid
191: FROM igs_uc_crse_dets
192: WHERE ucas_program_code = x_ucas_program_code
193: AND institute = x_institute
194: AND ucas_campus = x_ucas_campus
195: AND system_code = x_system_code ;

Line 227: FROM igs_uc_crse_dets

223: || (reverse chronological order - newest change first)
224: */
225: CURSOR cur_rowid IS
226: SELECT rowid
227: FROM igs_uc_crse_dets
228: WHERE ((system_code = x_system_code));
229:
230: lv_rowid cur_rowid%RowType;
231:

Line 452: FROM igs_uc_crse_dets

448: || (reverse chronological order - newest change first)
449: */
450: CURSOR c IS
451: SELECT rowid
452: FROM igs_uc_crse_dets
453: WHERE ucas_program_code = x_ucas_program_code
454: AND institute = x_institute
455: AND ucas_campus = x_ucas_campus;
456:

Line 533: INSERT INTO igs_uc_crse_dets (

529: x_imported => x_imported,
530: x_keywrds_changed => x_keywrds_changed
531: );
532:
533: INSERT INTO igs_uc_crse_dets (
534: ucas_program_code,
535: oss_program_code,
536: oss_program_version,
537: institute,

Line 734: FROM igs_uc_crse_dets

730: system_code ,
731: clearing_options,
732: imported,
733: keywrds_changed
734: FROM igs_uc_crse_dets
735: WHERE rowid = x_rowid
736: FOR UPDATE NOWAIT;
737:
738: tlinfo c1%ROWTYPE;

Line 936: UPDATE igs_uc_crse_dets

932: x_imported => x_imported ,
933: x_keywrds_changed => x_keywrds_changed
934: );
935:
936: UPDATE igs_uc_crse_dets
937: SET
938: oss_program_code = new_references.oss_program_code,
939: oss_program_version = new_references.oss_program_version,
940: uvcourse_updater = new_references.uvcourse_updater,

Line 1044: FROM igs_uc_crse_dets

1040: || (reverse chronological order - newest change first)
1041: */
1042: CURSOR c1 IS
1043: SELECT rowid
1044: FROM igs_uc_crse_dets
1045: WHERE ucas_program_code = x_ucas_program_code
1046: AND institute = x_institute
1047: AND ucas_campus = x_ucas_campus;
1048:

Line 1154: END igs_uc_crse_dets_pkg;

1150:
1151: END add_row;
1152:
1153:
1154: END igs_uc_crse_dets_pkg;