APPS.IGS_EN_PSV_TERM_IT_PKG dependencies on IGS_EN_PSV_TERM_IT

Line 1: PACKAGE BODY igs_en_psv_term_it_pkg AS

1: PACKAGE BODY igs_en_psv_term_it_pkg AS
2: /* $Header: IGSEI78B.pls 120.0 2005/06/01 18:06:37 appldev noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_en_psv_term_it%ROWTYPE;

Line 5: old_references igs_en_psv_term_it%ROWTYPE;

1: PACKAGE BODY igs_en_psv_term_it_pkg AS
2: /* $Header: IGSEI78B.pls 120.0 2005/06/01 18:06:37 appldev noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_en_psv_term_it%ROWTYPE;
6: new_references igs_en_psv_term_it%ROWTYPE;
7:
8:
9: PROCEDURE Check_Parent_Existance AS

Line 6: new_references igs_en_psv_term_it%ROWTYPE;

2: /* $Header: IGSEI78B.pls 120.0 2005/06/01 18:06:37 appldev noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_en_psv_term_it%ROWTYPE;
6: new_references igs_en_psv_term_it%ROWTYPE;
7:
8:
9: PROCEDURE Check_Parent_Existance AS
10: /*----------------------------------------------------------------------------

Line 81: FROM igs_en_psv_term_it

77: */
78:
79: CURSOR cur_old_ref_values IS
80: SELECT *
81: FROM igs_en_psv_term_it
82: WHERE rowid = x_rowid;
83:
84: BEGIN
85:

Line 138: FROM igs_en_psv_term_it

134: || (reverse chronological order - newest change first)
135: */
136: CURSOR cur_rowid IS
137: SELECT ROWID
138: FROM igs_en_psv_term_it
139: WHERE CAL_TYPE = X_CAL_TYPE AND
140: SEQUENCE_NUMBER = X_SEQUENCE_NUMBER ;
141: lv_rowid cur_rowid%ROWTYPE;
142:

Line 171: FROM igs_en_psv_term_it

167: || (reverse chronological order - newest change first)
168: */
169: CURSOR cur_rowid IS
170: SELECT ROWID
171: FROM igs_en_psv_term_it
172: WHERE course_cd = x_course_cd
173: AND version_number = x_version_number ;
174: lv_rowid cur_rowid%ROWTYPE;
175: BEGIN

Line 205: FROM igs_en_psv_term_it

201: || (reverse chronological order - newest change first)
202: */
203: CURSOR cur_rowid IS
204: SELECT rowid
205: FROM igs_en_psv_term_it
206: WHERE cal_type = x_cal_type
207: AND sequence_number = x_sequence_number
208: AND course_cd = x_course_cd
209: AND version_number = x_version_number

Line 342: fnd_message.set_token ('ROUTINE', 'IGS_EN_PSV_TERM_IT_PKG.INSERT_ROW');

338: x_last_update_login := -1;
339: END IF;
340: ELSE
341: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
342: fnd_message.set_token ('ROUTINE', 'IGS_EN_PSV_TERM_IT_PKG.INSERT_ROW');
343: igs_ge_msg_stack.add;
344: app_exception.raise_exception;
345: END IF;
346:

Line 362: INSERT INTO igs_en_psv_term_it (

358: x_last_updated_by => x_last_updated_by,
359: x_last_update_login => x_last_update_login
360: );
361:
362: INSERT INTO igs_en_psv_term_it (
363: cal_type,
364: sequence_number,
365: course_cd,
366: version_number,

Line 409: FROM igs_en_psv_term_it

405: */
406: CURSOR c1 IS
407: SELECT
408: term_instruction_time
409: FROM igs_en_psv_term_it
410: WHERE rowid = x_rowid
411: FOR UPDATE NOWAIT;
412:
413: tlinfo c1%ROWTYPE;

Line 482: fnd_message.set_token ('ROUTINE', 'IGS_EN_PSV_TERM_IT_PKG.UPDATE_ROW');

478: x_last_update_login := -1;
479: END IF;
480: ELSE
481: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
482: fnd_message.set_token ('ROUTINE', 'IGS_EN_PSV_TERM_IT_PKG.UPDATE_ROW');
483: igs_ge_msg_stack.add;
484: app_exception.raise_exception;
485: END IF;
486:

Line 502: UPDATE igs_en_psv_term_it

498: x_last_updated_by => x_last_updated_by,
499: x_last_update_login => x_last_update_login
500: );
501:
502: UPDATE igs_en_psv_term_it
503: SET
504: term_instruction_time = new_references.term_instruction_time,
505: last_update_date = x_last_update_date,
506: last_updated_by = x_last_updated_by,

Line 537: FROM igs_en_psv_term_it

533: || (reverse chronological order - newest change first)
534: */
535: CURSOR c1 IS
536: SELECT rowid
537: FROM igs_en_psv_term_it
538: WHERE cal_type = x_cal_type
539: AND sequence_number = x_sequence_number
540: AND course_cd = x_course_cd
541: AND version_number = x_version_number;

Line 595: DELETE FROM igs_en_psv_term_it

591: p_action => 'DELETE',
592: x_rowid => x_rowid
593: );
594:
595: DELETE FROM igs_en_psv_term_it
596: WHERE rowid = x_rowid;
597:
598: IF (SQL%NOTFOUND) THEN
599: RAISE NO_DATA_FOUND;

Line 605: END igs_en_psv_term_it_pkg;

601:
602: END delete_row;
603:
604:
605: END igs_en_psv_term_it_pkg;