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.

APPS.IGS_PS_FIELD_STUDY_PKG dependencies on IGS_PS_FIELD_STUDY

Line 1: package body IGS_PS_FIELD_STUDY_PKG AS

1: package body IGS_PS_FIELD_STUDY_PKG AS
2: /* $Header: IGSPI13B.pls 120.1 2006/07/25 15:11:10 sommukhe noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references IGS_PS_FIELD_STUDY%RowType;

Line 5: old_references IGS_PS_FIELD_STUDY%RowType;

1: package body IGS_PS_FIELD_STUDY_PKG AS
2: /* $Header: IGSPI13B.pls 120.1 2006/07/25 15:11:10 sommukhe noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references IGS_PS_FIELD_STUDY%RowType;
6: new_references IGS_PS_FIELD_STUDY%RowType;
7:
8: PROCEDURE Set_Column_Values (
9: p_action IN VARCHAR2,

Line 6: new_references IGS_PS_FIELD_STUDY%RowType;

2: /* $Header: IGSPI13B.pls 120.1 2006/07/25 15:11:10 sommukhe noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references IGS_PS_FIELD_STUDY%RowType;
6: new_references IGS_PS_FIELD_STUDY%RowType;
7:
8: PROCEDURE Set_Column_Values (
9: p_action IN VARCHAR2,
10: x_rowid IN VARCHAR2 DEFAULT NULL,

Line 25: FROM IGS_PS_FIELD_STUDY

21: ) AS
22:
23: CURSOR cur_old_ref_values IS
24: SELECT *
25: FROM IGS_PS_FIELD_STUDY
26: WHERE rowid = x_rowid;
27:
28: BEGIN
29:

Line 67: -- ON IGS_PS_FIELD_STUDY

63:
64: -- Trigger description :-
65: -- "OSS_TST".trg_cfos_br_iud
66: -- BEFORE INSERT OR DELETE OR UPDATE
67: -- ON IGS_PS_FIELD_STUDY
68: -- FOR EACH ROW
69:
70: PROCEDURE BeforeRowInsertUpdateDelete1(
71: p_inserting IN BOOLEAN DEFAULT FALSE,

Line 76: v_course_cd IGS_PS_FIELD_STUDY.course_cd%TYPE;

72: p_updating IN BOOLEAN DEFAULT FALSE,
73: p_deleting IN BOOLEAN DEFAULT FALSE
74: ) AS
75: v_message_name varchar2(30);
76: v_course_cd IGS_PS_FIELD_STUDY.course_cd%TYPE;
77: v_version_number IGS_PS_FIELD_STUDY.version_number%TYPE;
78: v_major_field_ind IGS_PS_FIELD_STUDY.major_field_ind%TYPE;
79: v_percentage IGS_PS_FIELD_STUDY.percentage%TYPE;
80: BEGIN

Line 77: v_version_number IGS_PS_FIELD_STUDY.version_number%TYPE;

73: p_deleting IN BOOLEAN DEFAULT FALSE
74: ) AS
75: v_message_name varchar2(30);
76: v_course_cd IGS_PS_FIELD_STUDY.course_cd%TYPE;
77: v_version_number IGS_PS_FIELD_STUDY.version_number%TYPE;
78: v_major_field_ind IGS_PS_FIELD_STUDY.major_field_ind%TYPE;
79: v_percentage IGS_PS_FIELD_STUDY.percentage%TYPE;
80: BEGIN
81:

Line 78: v_major_field_ind IGS_PS_FIELD_STUDY.major_field_ind%TYPE;

74: ) AS
75: v_message_name varchar2(30);
76: v_course_cd IGS_PS_FIELD_STUDY.course_cd%TYPE;
77: v_version_number IGS_PS_FIELD_STUDY.version_number%TYPE;
78: v_major_field_ind IGS_PS_FIELD_STUDY.major_field_ind%TYPE;
79: v_percentage IGS_PS_FIELD_STUDY.percentage%TYPE;
80: BEGIN
81:
82: -- Set variables.

Line 79: v_percentage IGS_PS_FIELD_STUDY.percentage%TYPE;

75: v_message_name varchar2(30);
76: v_course_cd IGS_PS_FIELD_STUDY.course_cd%TYPE;
77: v_version_number IGS_PS_FIELD_STUDY.version_number%TYPE;
78: v_major_field_ind IGS_PS_FIELD_STUDY.major_field_ind%TYPE;
79: v_percentage IGS_PS_FIELD_STUDY.percentage%TYPE;
80: BEGIN
81:
82: -- Set variables.
83: IF p_deleting THEN

Line 210: FROM IGS_PS_FIELD_STUDY

206: RETURN BOOLEAN AS
207:
208: CURSOR cur_rowid IS
209: SELECT rowid
210: FROM IGS_PS_FIELD_STUDY
211: WHERE course_cd = x_course_cd
212: AND version_number = x_version_number
213: AND field_of_study = x_field_of_study
214: FOR UPDATE NOWAIT;

Line 238: FROM IGS_PS_FIELD_STUDY

234: ) AS
235:
236: CURSOR cur_rowid IS
237: SELECT rowid
238: FROM IGS_PS_FIELD_STUDY
239: WHERE course_cd = x_course_cd
240: AND version_number = x_version_number ;
241:
242: lv_rowid cur_rowid%RowType;

Line 346: cursor C is select ROWID from IGS_PS_FIELD_STUDY

342: X_MAJOR_FIELD_IND in VARCHAR2,
343: X_PERCENTAGE in NUMBER,
344: X_MODE in VARCHAR2 default 'R'
345: ) AS
346: cursor C is select ROWID from IGS_PS_FIELD_STUDY
347: where COURSE_CD = X_COURSE_CD
348: and FIELD_OF_STUDY = X_FIELD_OF_STUDY
349: and VERSION_NUMBER = X_VERSION_NUMBER;
350: X_LAST_UPDATE_DATE DATE;

Line 387: insert into IGS_PS_FIELD_STUDY (

383: x_last_updated_by => X_LAST_UPDATED_BY ,
384: x_last_update_login => X_LAST_UPDATE_LOGIN
385: );
386:
387: insert into IGS_PS_FIELD_STUDY (
388: COURSE_CD,
389: VERSION_NUMBER,
390: FIELD_OF_STUDY,
391: MAJOR_FIELD_IND,

Line 435: from IGS_PS_FIELD_STUDY

431: ) AS
432: cursor c1 is select
433: MAJOR_FIELD_IND,
434: PERCENTAGE
435: from IGS_PS_FIELD_STUDY
436: where ROWID = X_ROWID
437: for update nowait;
438: tlinfo c1%rowtype;
439:

Line 510: update IGS_PS_FIELD_STUDY set

506: x_last_updated_by => X_LAST_UPDATED_BY ,
507: x_last_update_login => X_LAST_UPDATE_LOGIN
508: );
509:
510: update IGS_PS_FIELD_STUDY set
511: MAJOR_FIELD_IND = NEW_REFERENCES.MAJOR_FIELD_IND,
512: PERCENTAGE = NEW_REFERENCES.PERCENTAGE,
513: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
514: LAST_UPDATED_BY = X_LAST_UPDATED_BY,

Line 536: cursor c1 is select rowid from IGS_PS_FIELD_STUDY

532: X_MAJOR_FIELD_IND in VARCHAR2,
533: X_PERCENTAGE in NUMBER,
534: X_MODE in VARCHAR2 default 'R'
535: ) AS
536: cursor c1 is select rowid from IGS_PS_FIELD_STUDY
537: where COURSE_CD = X_COURSE_CD
538: and FIELD_OF_STUDY = X_FIELD_OF_STUDY
539: and VERSION_NUMBER = X_VERSION_NUMBER
540: ;

Line 575: delete from IGS_PS_FIELD_STUDY

571: Before_DML (
572: p_action => 'DELETE',
573: x_rowid => X_ROWID
574: );
575: delete from IGS_PS_FIELD_STUDY
576: where ROWID = X_ROWID;
577: if (sql%notfound) then
578: raise no_data_found;
579: end if;

Line 586: end IGS_PS_FIELD_STUDY_PKG;

582: x_rowid => X_ROWID
583: );
584: end DELETE_ROW;
585:
586: end IGS_PS_FIELD_STUDY_PKG;