APPS.IGS_PR_UL_MARK_CNFG_PKG dependencies on IGS_PR_UL_MARK_CNFG

Line 1: PACKAGE BODY igs_pr_ul_mark_cnfg_pkg AS

1: PACKAGE BODY igs_pr_ul_mark_cnfg_pkg AS
2: /* $Header: IGSQI46B.pls 115.0 2003/11/07 10:54:54 ijeddy noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_pr_ul_mark_cnfg%ROWTYPE;

Line 5: old_references igs_pr_ul_mark_cnfg%ROWTYPE;

1: PACKAGE BODY igs_pr_ul_mark_cnfg_pkg AS
2: /* $Header: IGSQI46B.pls 115.0 2003/11/07 10:54:54 ijeddy noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_pr_ul_mark_cnfg%ROWTYPE;
6: new_references igs_pr_ul_mark_cnfg%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,

Line 6: new_references igs_pr_ul_mark_cnfg%ROWTYPE;

2: /* $Header: IGSQI46B.pls 115.0 2003/11/07 10:54:54 ijeddy noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_pr_ul_mark_cnfg%ROWTYPE;
6: new_references igs_pr_ul_mark_cnfg%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,
10: x_rowid IN VARCHAR2,

Line 35: FROM igs_pr_ul_mark_cnfg

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

Line 154: igs_pr_ul_mark_dtl_pkg.get_fk_igs_pr_ul_mark_cnfg (

150: || (reverse chronological order - newest change first)
151: */
152: BEGIN
153:
154: igs_pr_ul_mark_dtl_pkg.get_fk_igs_pr_ul_mark_cnfg (
155: old_references.mark_config_id
156: );
157:
158: END check_child_existance;

Line 175: FROM igs_pr_ul_mark_cnfg

171: || (reverse chronological order - newest change first)
172: */
173: CURSOR cur_rowid IS
174: SELECT rowid
175: FROM igs_pr_ul_mark_cnfg
176: WHERE mark_config_id = x_mark_config_id
177: FOR UPDATE NOWAIT;
178:
179: lv_rowid cur_rowid%RowType;

Line 211: FROM igs_pr_ul_mark_cnfg

207: || (reverse chronological order - newest change first)
208: */
209: CURSOR cur_rowid IS
210: SELECT rowid
211: FROM igs_pr_ul_mark_cnfg
212: WHERE (unit_level = x_unit_level)
213: AND ((course_cd = x_course_cd) OR ((course_cd IS NULL) AND (x_course_cd IS NULL)))
214: AND ((version_number = x_version_number) OR ((version_number IS NULL) AND (x_version_number IS NULL)));
215:

Line 247: FROM igs_pr_ul_mark_cnfg

243: || (reverse chronological order - newest change first)
244: */
245: CURSOR cur_rowid IS
246: SELECT rowid
247: FROM igs_pr_ul_mark_cnfg
248: WHERE ((unit_level = x_unit_level));
249:
250: lv_rowid cur_rowid%RowType;
251:

Line 283: FROM igs_pr_ul_mark_cnfg

279: || (reverse chronological order - newest change first)
280: */
281: CURSOR cur_rowid IS
282: SELECT rowid
283: FROM igs_pr_ul_mark_cnfg
284: WHERE ((course_cd = x_course_cd) AND
285: (version_number = x_version_number));
286:
287: lv_rowid cur_rowid%RowType;

Line 426: fnd_message.set_token ('ROUTINE', 'IGS_PR_UL_MARK_CNFG_PKG.INSERT_ROW');

422: x_last_update_login := -1;
423: END IF;
424: ELSE
425: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
426: fnd_message.set_token ('ROUTINE', 'IGS_PR_UL_MARK_CNFG_PKG.INSERT_ROW');
427: igs_ge_msg_stack.add;
428: app_exception.raise_exception;
429: END IF;
430:

Line 449: INSERT INTO igs_pr_ul_mark_cnfg (

445: x_last_updated_by => x_last_updated_by,
446: x_last_update_login => x_last_update_login
447: );
448:
449: INSERT INTO igs_pr_ul_mark_cnfg (
450: mark_config_id,
451: unit_level,
452: course_cd,
453: version_number,

Line 462: igs_pr_ul_mark_cnfg_s.NEXTVAL,

458: last_update_date,
459: last_updated_by,
460: last_update_login
461: ) VALUES (
462: igs_pr_ul_mark_cnfg_s.NEXTVAL,
463: new_references.unit_level,
464: new_references.course_cd,
465: new_references.version_number,
466: new_references.total_unit_level_credits,

Line 503: FROM igs_pr_ul_mark_cnfg

499: course_cd,
500: version_number,
501: total_unit_level_credits,
502: selection_method_code
503: FROM igs_pr_ul_mark_cnfg
504: WHERE rowid = x_rowid
505: FOR UPDATE NOWAIT;
506:
507: tlinfo c1%ROWTYPE;

Line 581: fnd_message.set_token ('ROUTINE', 'IGS_PR_UL_MARK_CNFG_PKG.UPDATE_ROW');

577: x_last_update_login := -1;
578: END IF;
579: ELSE
580: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
581: fnd_message.set_token ('ROUTINE', 'IGS_PR_UL_MARK_CNFG_PKG.UPDATE_ROW');
582: igs_ge_msg_stack.add;
583: app_exception.raise_exception;
584: END IF;
585:

Line 602: UPDATE igs_pr_ul_mark_cnfg

598: x_last_updated_by => x_last_updated_by,
599: x_last_update_login => x_last_update_login
600: );
601:
602: UPDATE igs_pr_ul_mark_cnfg
603: SET
604: unit_level = new_references.unit_level,
605: course_cd = new_references.course_cd,
606: version_number = new_references.version_number,

Line 642: FROM igs_pr_ul_mark_cnfg

638: || (reverse chronological order - newest change first)
639: */
640: CURSOR c1 IS
641: SELECT rowid
642: FROM igs_pr_ul_mark_cnfg
643: WHERE mark_config_id = x_mark_config_id;
644:
645: BEGIN
646:

Line 699: DELETE FROM igs_pr_ul_mark_cnfg

695: p_action => 'DELETE',
696: x_rowid => x_rowid
697: );
698:
699: DELETE FROM igs_pr_ul_mark_cnfg
700: WHERE rowid = x_rowid;
701:
702: IF (SQL%NOTFOUND) THEN
703: RAISE NO_DATA_FOUND;

Line 709: END igs_pr_ul_mark_cnfg_pkg;

705:
706: END delete_row;
707:
708:
709: END igs_pr_ul_mark_cnfg_pkg;