eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

APPS.IGS_PR_CS_SCHDL_PKG dependencies on IGS_PR_CS_SCHDL

Line 1: PACKAGE BODY igs_pr_cs_schdl_pkg AS

1: PACKAGE BODY igs_pr_cs_schdl_pkg AS
2: /* $Header: IGSQI30B.pls 115.6 2003/06/05 13:06:40 sarakshi ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_pr_cs_schdl%ROWTYPE;

Line 5: old_references igs_pr_cs_schdl%ROWTYPE;

1: PACKAGE BODY igs_pr_cs_schdl_pkg AS
2: /* $Header: IGSQI30B.pls 115.6 2003/06/05 13:06:40 sarakshi ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_pr_cs_schdl%ROWTYPE;
6: new_references igs_pr_cs_schdl%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,

Line 6: new_references igs_pr_cs_schdl%ROWTYPE;

2: /* $Header: IGSQI30B.pls 115.6 2003/06/05 13:06:40 sarakshi ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_pr_cs_schdl%ROWTYPE;
6: new_references igs_pr_cs_schdl%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,
10: x_rowid IN VARCHAR2 DEFAULT NULL,

Line 11: x_igs_pr_cs_schdl_id IN NUMBER DEFAULT NULL,

7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,
10: x_rowid IN VARCHAR2 DEFAULT NULL,
11: x_igs_pr_cs_schdl_id IN NUMBER DEFAULT NULL,
12: x_course_type IN VARCHAR2 DEFAULT NULL,
13: x_consider_changes IN VARCHAR2 DEFAULT NULL,
14: x_start_dt IN DATE DEFAULT NULL,
15: x_end_dt IN DATE DEFAULT NULL,

Line 34: FROM IGS_PR_CS_SCHDL

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

Line 55: new_references.igs_pr_cs_schdl_id := x_igs_pr_cs_schdl_id;

51: END IF;
52: CLOSE cur_old_ref_values;
53:
54: -- Populate New Values.
55: new_references.igs_pr_cs_schdl_id := x_igs_pr_cs_schdl_id;
56: new_references.course_type := x_course_type;
57: new_references.consider_changes := x_consider_changes;
58: new_references.start_dt := x_start_dt;
59: new_references.end_dt := x_end_dt;

Line 139: igs_pr_css_class_std_pkg.get_fk_igs_pr_cs_schdl (

135: || (reverse chronological order - newest change first)
136: */
137: BEGIN
138:
139: igs_pr_css_class_std_pkg.get_fk_igs_pr_cs_schdl (
140: old_references.igs_pr_cs_schdl_id
141: );
142:
143: END check_child_existance;

Line 140: old_references.igs_pr_cs_schdl_id

136: */
137: BEGIN
138:
139: igs_pr_css_class_std_pkg.get_fk_igs_pr_cs_schdl (
140: old_references.igs_pr_cs_schdl_id
141: );
142:
143: END check_child_existance;
144:

Line 147: x_igs_pr_cs_schdl_id IN NUMBER

143: END check_child_existance;
144:
145:
146: FUNCTION get_pk_for_validation (
147: x_igs_pr_cs_schdl_id IN NUMBER
148: ) RETURN BOOLEAN AS
149: /*
150: || Created By : avenkatr
151: || Created On : 12-JUL-2001

Line 160: FROM igs_pr_cs_schdl

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

Line 161: WHERE igs_pr_cs_schdl_id = x_igs_pr_cs_schdl_id

157: */
158: CURSOR cur_rowid IS
159: SELECT rowid
160: FROM igs_pr_cs_schdl
161: WHERE igs_pr_cs_schdl_id = x_igs_pr_cs_schdl_id
162: FOR UPDATE NOWAIT;
163:
164: lv_rowid cur_rowid%RowType;
165:

Line 195: FROM igs_pr_cs_schdl

191: || (reverse chronological order - newest change first)
192: */
193: CURSOR cur_rowid IS
194: SELECT rowid
195: FROM igs_pr_cs_schdl
196: WHERE start_dt = x_start_dt
197: AND course_type = x_course_type
198: AND ((l_rowid IS NULL) OR (rowid <> l_rowid));
199:

Line 220: x_igs_pr_cs_schdl_id IN NUMBER DEFAULT NULL,

216:
217: PROCEDURE before_dml (
218: p_action IN VARCHAR2,
219: x_rowid IN VARCHAR2 DEFAULT NULL,
220: x_igs_pr_cs_schdl_id IN NUMBER DEFAULT NULL,
221: x_course_type IN VARCHAR2 DEFAULT NULL,
222: x_consider_changes IN VARCHAR2 DEFAULT NULL,
223: x_start_dt IN DATE DEFAULT NULL,
224: x_end_dt IN DATE DEFAULT NULL,

Line 246: x_igs_pr_cs_schdl_id,

242:
243: set_column_values (
244: p_action,
245: x_rowid,
246: x_igs_pr_cs_schdl_id,
247: x_course_type,
248: x_consider_changes,
249: x_start_dt,
250: x_end_dt,

Line 261: new_references.igs_pr_cs_schdl_id

257:
258: IF (p_action = 'INSERT') THEN
259: -- Call all the procedures related to Before Insert.
260: IF ( get_pk_for_validation(
261: new_references.igs_pr_cs_schdl_id
262: )
263: ) THEN
264: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
265: igs_ge_msg_stack.add;

Line 280: new_references.igs_pr_cs_schdl_id

276: check_child_existance;
277: ELSIF (p_action = 'VALIDATE_INSERT') THEN
278: -- Call all the procedures related to Before Insert.
279: IF ( get_pk_for_validation (
280: new_references.igs_pr_cs_schdl_id
281: )
282: ) THEN
283: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
284: igs_ge_msg_stack.add;

Line 299: x_igs_pr_cs_schdl_id IN OUT NOCOPY NUMBER,

295:
296:
297: PROCEDURE insert_row (
298: x_rowid IN OUT NOCOPY VARCHAR2,
299: x_igs_pr_cs_schdl_id IN OUT NOCOPY NUMBER,
300: x_course_type IN VARCHAR2,
301: x_consider_changes IN VARCHAR2,
302: x_start_dt IN DATE,
303: x_end_dt IN DATE,

Line 317: FROM igs_pr_cs_schdl

313: || (reverse chronological order - newest change first)
314: */
315: CURSOR c IS
316: SELECT rowid
317: FROM igs_pr_cs_schdl
318: WHERE igs_pr_cs_schdl_id = x_igs_pr_cs_schdl_id;
319:
320: x_last_update_date DATE;
321: x_last_updated_by NUMBER;

Line 318: WHERE igs_pr_cs_schdl_id = x_igs_pr_cs_schdl_id;

314: */
315: CURSOR c IS
316: SELECT rowid
317: FROM igs_pr_cs_schdl
318: WHERE igs_pr_cs_schdl_id = x_igs_pr_cs_schdl_id;
319:
320: x_last_update_date DATE;
321: x_last_updated_by NUMBER;
322: x_last_update_login NUMBER;

Line 345: SELECT igs_pr_cs_schdl_s.NEXTVAL

341: igs_ge_msg_stack.add;
342: app_exception.raise_exception;
343: END IF;
344:
345: SELECT igs_pr_cs_schdl_s.NEXTVAL
346: INTO x_igs_pr_cs_schdl_id
347: FROM dual;
348:
349: before_dml(

Line 346: INTO x_igs_pr_cs_schdl_id

342: app_exception.raise_exception;
343: END IF;
344:
345: SELECT igs_pr_cs_schdl_s.NEXTVAL
346: INTO x_igs_pr_cs_schdl_id
347: FROM dual;
348:
349: before_dml(
350: p_action => 'INSERT',

Line 352: x_igs_pr_cs_schdl_id => x_igs_pr_cs_schdl_id,

348:
349: before_dml(
350: p_action => 'INSERT',
351: x_rowid => x_rowid,
352: x_igs_pr_cs_schdl_id => x_igs_pr_cs_schdl_id,
353: x_course_type => x_course_type,
354: x_consider_changes => x_consider_changes,
355: x_start_dt => x_start_dt,
356: x_end_dt => x_end_dt,

Line 364: INSERT INTO igs_pr_cs_schdl (

360: x_last_updated_by => x_last_updated_by,
361: x_last_update_login => x_last_update_login
362: );
363:
364: INSERT INTO igs_pr_cs_schdl (
365: igs_pr_cs_schdl_id,
366: course_type,
367: consider_changes,
368: start_dt,

Line 365: igs_pr_cs_schdl_id,

361: x_last_update_login => x_last_update_login
362: );
363:
364: INSERT INTO igs_pr_cs_schdl (
365: igs_pr_cs_schdl_id,
366: course_type,
367: consider_changes,
368: start_dt,
369: end_dt,

Line 376: new_references.igs_pr_cs_schdl_id,

372: last_update_date,
373: last_updated_by,
374: last_update_login
375: ) VALUES (
376: new_references.igs_pr_cs_schdl_id,
377: new_references.course_type,
378: new_references.consider_changes,
379: new_references.start_dt,
380: new_references.end_dt,

Line 401: x_igs_pr_cs_schdl_id IN NUMBER,

397:
398:
399: PROCEDURE lock_row (
400: x_rowid IN VARCHAR2,
401: x_igs_pr_cs_schdl_id IN NUMBER,
402: x_course_type IN VARCHAR2,
403: x_consider_changes IN VARCHAR2,
404: x_start_dt IN DATE,
405: x_end_dt IN DATE

Line 422: FROM igs_pr_cs_schdl

418: course_type,
419: consider_changes,
420: start_dt,
421: end_dt
422: FROM igs_pr_cs_schdl
423: WHERE rowid = x_rowid
424: FOR UPDATE NOWAIT;
425:
426: tlinfo c1%ROWTYPE;

Line 461: x_igs_pr_cs_schdl_id IN NUMBER,

457:
458:
459: PROCEDURE update_row (
460: x_rowid IN VARCHAR2,
461: x_igs_pr_cs_schdl_id IN NUMBER,
462: x_course_type IN VARCHAR2,
463: x_consider_changes IN VARCHAR2,
464: x_start_dt IN DATE,
465: x_end_dt IN DATE,

Line 505: x_igs_pr_cs_schdl_id => x_igs_pr_cs_schdl_id,

501:
502: before_dml(
503: p_action => 'UPDATE',
504: x_rowid => x_rowid,
505: x_igs_pr_cs_schdl_id => x_igs_pr_cs_schdl_id,
506: x_course_type => x_course_type,
507: x_consider_changes => x_consider_changes,
508: x_start_dt => x_start_dt,
509: x_end_dt => x_end_dt,

Line 517: UPDATE igs_pr_cs_schdl

513: x_last_updated_by => x_last_updated_by,
514: x_last_update_login => x_last_update_login
515: );
516:
517: UPDATE igs_pr_cs_schdl
518: SET
519: course_type = new_references.course_type,
520: consider_changes = new_references.consider_changes,
521: start_dt = new_references.start_dt,

Line 537: x_igs_pr_cs_schdl_id IN OUT NOCOPY NUMBER,

533:
534:
535: PROCEDURE add_row (
536: x_rowid IN OUT NOCOPY VARCHAR2,
537: x_igs_pr_cs_schdl_id IN OUT NOCOPY NUMBER,
538: x_course_type IN VARCHAR2,
539: x_consider_changes IN VARCHAR2,
540: x_start_dt IN DATE,
541: x_end_dt IN DATE,

Line 555: FROM igs_pr_cs_schdl

551: || (reverse chronological order - newest change first)
552: */
553: CURSOR c1 IS
554: SELECT rowid
555: FROM igs_pr_cs_schdl
556: WHERE igs_pr_cs_schdl_id = x_igs_pr_cs_schdl_id;
557:
558: BEGIN
559:

Line 556: WHERE igs_pr_cs_schdl_id = x_igs_pr_cs_schdl_id;

552: */
553: CURSOR c1 IS
554: SELECT rowid
555: FROM igs_pr_cs_schdl
556: WHERE igs_pr_cs_schdl_id = x_igs_pr_cs_schdl_id;
557:
558: BEGIN
559:
560: OPEN c1;

Line 567: x_igs_pr_cs_schdl_id,

563: CLOSE c1;
564:
565: insert_row (
566: x_rowid,
567: x_igs_pr_cs_schdl_id,
568: x_course_type,
569: x_consider_changes,
570: x_start_dt,
571: x_end_dt,

Line 580: x_igs_pr_cs_schdl_id,

576: CLOSE c1;
577:
578: update_row (
579: x_rowid,
580: x_igs_pr_cs_schdl_id,
581: x_course_type,
582: x_consider_changes,
583: x_start_dt,
584: x_end_dt,

Line 610: DELETE FROM igs_pr_cs_schdl

606: p_action => 'DELETE',
607: x_rowid => x_rowid
608: );
609:
610: DELETE FROM igs_pr_cs_schdl
611: WHERE rowid = x_rowid;
612:
613: IF (SQL%NOTFOUND) THEN
614: RAISE NO_DATA_FOUND;

Line 620: END igs_pr_cs_schdl_pkg;

616:
617: END delete_row;
618:
619:
620: END igs_pr_cs_schdl_pkg;