APPS.IGS_PS_USO_INSTRCTRS_PKG dependencies on IGS_PS_USO_INSTRCTRS

Line 1: PACKAGE BODY igs_ps_uso_instrctrs_pkg AS

1: PACKAGE BODY igs_ps_uso_instrctrs_pkg AS
2: /* $Header: IGSPI2PB.pls 115.4 2003/03/21 08:03:15 sarakshi ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_ps_uso_instrctrs%ROWTYPE;

Line 5: old_references igs_ps_uso_instrctrs%ROWTYPE;

1: PACKAGE BODY igs_ps_uso_instrctrs_pkg AS
2: /* $Header: IGSPI2PB.pls 115.4 2003/03/21 08:03:15 sarakshi ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_ps_uso_instrctrs%ROWTYPE;
6: new_references igs_ps_uso_instrctrs%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,

Line 6: new_references igs_ps_uso_instrctrs%ROWTYPE;

2: /* $Header: IGSPI2PB.pls 115.4 2003/03/21 08:03:15 sarakshi ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_ps_uso_instrctrs%ROWTYPE;
6: new_references igs_ps_uso_instrctrs%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,
10: x_rowid IN VARCHAR2 DEFAULT NULL,

Line 32: FROM IGS_PS_USO_INSTRCTRS

28: */
29:
30: CURSOR cur_old_ref_values IS
31: SELECT *
32: FROM IGS_PS_USO_INSTRCTRS
33: WHERE rowid = x_rowid;
34:
35: BEGIN
36:

Line 161: FROM igs_ps_uso_instrctrs

157: || (reverse chronological order - newest change first)
158: */
159: CURSOR cur_rowid IS
160: SELECT rowid
161: FROM igs_ps_uso_instrctrs
162: WHERE uso_instructor_id = x_uso_instructor_id
163: FOR UPDATE NOWAIT;
164:
165: lv_rowid cur_rowid%RowType;

Line 197: FROM igs_ps_uso_instrctrs

193: || (reverse chronological order - newest change first)
194: */
195: CURSOR cur_rowid IS
196: SELECT rowid
197: FROM igs_ps_uso_instrctrs
198: WHERE unit_section_occurrence_id = x_unit_section_occurrence_id
199: AND instructor_id = x_instructor_id
200: AND ((l_rowid IS NULL) OR (rowid <> l_rowid));
201:

Line 233: FROM igs_ps_uso_instrctrs

229: || (reverse chronological order - newest change first)
230: */
231: CURSOR cur_rowid IS
232: SELECT rowid
233: FROM igs_ps_uso_instrctrs
234: WHERE ((unit_section_occurrence_id = x_unit_section_occurrence_id));
235:
236: lv_rowid cur_rowid%RowType;
237:

Line 268: FROM igs_ps_uso_instrctrs

264: || (reverse chronological order - newest change first)
265: */
266: CURSOR cur_rowid IS
267: SELECT rowid
268: FROM igs_ps_uso_instrctrs
269: WHERE ((instructor_id = x_party_id));
270:
271: lv_rowid cur_rowid%RowType;
272:

Line 380: FROM igs_ps_uso_instrctrs

376: || (reverse chronological order - newest change first)
377: */
378: CURSOR c IS
379: SELECT rowid
380: FROM igs_ps_uso_instrctrs
381: WHERE uso_instructor_id = x_uso_instructor_id;
382:
383: x_last_update_date DATE;
384: x_last_updated_by NUMBER;

Line 408: SELECT igs_ps_uso_instrctrs_s.NEXTVAL

404: igs_ge_msg_stack.add;
405: app_exception.raise_exception;
406: END IF;
407:
408: SELECT igs_ps_uso_instrctrs_s.NEXTVAL
409: INTO x_uso_instructor_id
410: FROM dual;
411:
412: before_dml(

Line 425: INSERT INTO igs_ps_uso_instrctrs (

421: x_last_updated_by => x_last_updated_by,
422: x_last_update_login => x_last_update_login
423: );
424:
425: INSERT INTO igs_ps_uso_instrctrs (
426: uso_instructor_id,
427: unit_section_occurrence_id,
428: instructor_id,
429: creation_date,

Line 475: FROM igs_ps_uso_instrctrs

471: CURSOR c1 IS
472: SELECT
473: unit_section_occurrence_id,
474: instructor_id
475: FROM igs_ps_uso_instrctrs
476: WHERE rowid = x_rowid
477: FOR UPDATE NOWAIT;
478:
479: tlinfo c1%ROWTYPE;

Line 564: UPDATE igs_ps_uso_instrctrs

560: x_last_updated_by => x_last_updated_by,
561: x_last_update_login => x_last_update_login
562: );
563:
564: UPDATE igs_ps_uso_instrctrs
565: SET
566: unit_section_occurrence_id = new_references.unit_section_occurrence_id,
567: instructor_id = new_references.instructor_id,
568: last_update_date = x_last_update_date,

Line 598: FROM igs_ps_uso_instrctrs

594: || (reverse chronological order - newest change first)
595: */
596: CURSOR c1 IS
597: SELECT rowid
598: FROM igs_ps_uso_instrctrs
599: WHERE uso_instructor_id = x_uso_instructor_id;
600:
601: BEGIN
602:

Line 649: DELETE FROM igs_ps_uso_instrctrs

645: p_action => 'DELETE',
646: x_rowid => x_rowid
647: );
648:
649: DELETE FROM igs_ps_uso_instrctrs
650: WHERE rowid = x_rowid;
651:
652: IF (SQL%NOTFOUND) THEN
653: RAISE NO_DATA_FOUND;

Line 659: END igs_ps_uso_instrctrs_pkg;

655:
656: END delete_row;
657:
658:
659: END igs_ps_uso_instrctrs_pkg;