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_RE_THESIS_EXAM_PKG dependencies on IGS_RE_THESIS_EXAM

Line 1: PACKAGE BODY IGS_RE_THESIS_EXAM_PKG AS

1: PACKAGE BODY IGS_RE_THESIS_EXAM_PKG AS
2: /* $Header: IGSRI16B.pls 120.1 2005/07/04 00:42:30 appldev ship $ */
3: -------------------------------------------------------------------------------------------
4: --Change History:
5: --Who When What

Line 12: old_references IGS_RE_THESIS_EXAM%RowType;

8: --smadathi 24-AUG-2001 Bug No. 1956374 .The call to igs_re_val_tex.genp_val_sdtt_sess
9: -- is changed to igs_as_val_suaap.genp_val_sdtt_sess
10: -------------------------------------------------------------------------------------------
11: l_rowid VARCHAR2(25);
12: old_references IGS_RE_THESIS_EXAM%RowType;
13: new_references IGS_RE_THESIS_EXAM%RowType;
14:
15: PROCEDURE Set_Column_Values (
16: p_action IN VARCHAR2,

Line 13: new_references IGS_RE_THESIS_EXAM%RowType;

9: -- is changed to igs_as_val_suaap.genp_val_sdtt_sess
10: -------------------------------------------------------------------------------------------
11: l_rowid VARCHAR2(25);
12: old_references IGS_RE_THESIS_EXAM%RowType;
13: new_references IGS_RE_THESIS_EXAM%RowType;
14:
15: PROCEDURE Set_Column_Values (
16: p_action IN VARCHAR2,
17: x_rowid IN VARCHAR2,

Line 36: FROM IGS_RE_THESIS_EXAM

32: ) AS
33:
34: CURSOR cur_old_ref_values IS
35: SELECT *
36: FROM IGS_RE_THESIS_EXAM
37: WHERE rowid = x_rowid;
38:
39: BEGIN
40:

Line 104: -- Validate the IGS_RE_THESIS examination type

100: END IF;
101: IF p_inserting OR
102: ( p_updating AND
103: old_references.thesis_exam_type <> new_references.thesis_exam_type) THEN
104: -- Validate the IGS_RE_THESIS examination type
105: IF IGS_RE_VAL_TEX.resp_val_tex_tet( new_references.thesis_exam_type,
106: v_message_name) = FALSE THEN
107: Fnd_Message.Set_Name ('IGS', v_message_name);
108: IGS_GE_MSG_STACK.ADD;

Line 228: -- Validate update transactions against the IGS_RE_THESIS examination.

224: v_transaction_type := 'INSERT';
225: ELSE
226: v_transaction_type := 'UPDATE';
227: END IF;
228: -- Validate update transactions against the IGS_RE_THESIS examination.
229: IF IGS_RE_VAL_TEX.resp_val_tex_upd( new_references.person_id,
230: new_references.ca_sequence_number,
231: new_references.the_sequence_number,
232: v_transaction_type,

Line 274: -- Validate for deletion of IGS_RE_THESIS examination details.

270: IGS_GE_MSG_STACK.ADD;
271: App_Exception.Raise_Exception;
272: END IF;
273: ELSE -- Deleting!
274: -- Validate for deletion of IGS_RE_THESIS examination details.
275: IF IGS_RE_VAL_TEX.resp_val_tex_upd( old_references.person_id,
276: old_references.ca_sequence_number,
277: old_references.the_sequence_number,
278: 'DELETE',

Line 428: IGS_RE_THS_PNL_MBR_PKG.GET_FK_IGS_RE_THESIS_EXAM (

424:
425: PROCEDURE Check_Child_Existance AS
426: BEGIN
427:
428: IGS_RE_THS_PNL_MBR_PKG.GET_FK_IGS_RE_THESIS_EXAM (
429: old_references.person_id,
430: old_references.ca_sequence_number,
431: old_references.the_sequence_number,
432: old_references.creation_dt

Line 447: FROM IGS_RE_THESIS_EXAM

443: AS
444:
445: CURSOR cur_rowid IS
446: SELECT rowid
447: FROM IGS_RE_THESIS_EXAM
448: WHERE person_id = x_person_id
449: AND ca_sequence_number = x_ca_sequence_number
450: AND the_sequence_number = x_the_sequence_number
451: AND creation_dt = x_creation_dt

Line 476: FROM IGS_RE_THESIS_EXAM

472: ) AS
473:
474: CURSOR cur_rowid IS
475: SELECT rowid
476: FROM IGS_RE_THESIS_EXAM
477: WHERE thesis_exam_type = x_thesis_exam_type ;
478:
479: lv_rowid cur_rowid%RowType;
480:

Line 504: FROM IGS_RE_THESIS_EXAM

500: ) AS
501:
502: CURSOR cur_rowid IS
503: SELECT rowid
504: FROM IGS_RE_THESIS_EXAM
505: WHERE person_id = x_person_id
506: AND ca_sequence_number = x_ca_sequence_number
507: AND the_sequence_number = x_sequence_number ;
508:

Line 532: FROM IGS_RE_THESIS_EXAM

528: ) AS
529:
530: CURSOR cur_rowid IS
531: SELECT rowid
532: FROM IGS_RE_THESIS_EXAM
533: WHERE thesis_result_cd = x_thesis_result_cd ;
534:
535: lv_rowid cur_rowid%RowType;
536:

Line 558: FROM IGS_RE_THESIS_EXAM

554: ) AS
555:
556: CURSOR cur_rowid IS
557: SELECT rowid
558: FROM IGS_RE_THESIS_EXAM
559: WHERE thesis_panel_type = x_thesis_panel_type ;
560:
561: lv_rowid cur_rowid%RowType;
562:

Line 584: FROM IGS_RE_THESIS_EXAM

580: ) AS
581:
582: CURSOR cur_rowid IS
583: SELECT rowid
584: FROM IGS_RE_THESIS_EXAM
585: WHERE tracking_id = x_tracking_id ;
586:
587: lv_rowid cur_rowid%RowType;
588:

Line 736: cursor C is select ROWID from IGS_RE_THESIS_EXAM

732: X_TRACKING_ID in NUMBER,
733: X_THESIS_RESULT_CD in VARCHAR2,
734: X_MODE in VARCHAR2
735: ) as
736: cursor C is select ROWID from IGS_RE_THESIS_EXAM
737: where PERSON_ID = X_PERSON_ID
738: and CA_SEQUENCE_NUMBER = X_CA_SEQUENCE_NUMBER
739: and THE_SEQUENCE_NUMBER = X_THE_SEQUENCE_NUMBER
740: and CREATION_DT = X_CREATION_DT;

Line 786: insert into IGS_RE_THESIS_EXAM (

782:
783: IF (x_mode = 'S') THEN
784: igs_sc_gen_001.set_ctx('R');
785: END IF;
786: insert into IGS_RE_THESIS_EXAM (
787: PERSON_ID,
788: CA_SEQUENCE_NUMBER,
789: THE_SEQUENCE_NUMBER,
790: CREATION_DT,

Line 869: from IGS_RE_THESIS_EXAM

865: THESIS_EXAM_TYPE,
866: THESIS_PANEL_TYPE,
867: TRACKING_ID,
868: THESIS_RESULT_CD
869: from IGS_RE_THESIS_EXAM
870: where ROWID = X_ROWID
871: for update nowait;
872: tlinfo c1%rowtype;
873:

Line 963: update IGS_RE_THESIS_EXAM set

959:
960: IF (x_mode = 'S') THEN
961: igs_sc_gen_001.set_ctx('R');
962: END IF;
963: update IGS_RE_THESIS_EXAM set
964: SUBMISSION_DT = NEW_REFERENCES.SUBMISSION_DT,
965: THESIS_EXAM_TYPE = NEW_REFERENCES.THESIS_EXAM_TYPE,
966: THESIS_PANEL_TYPE = NEW_REFERENCES.THESIS_PANEL_TYPE,
967: TRACKING_ID = NEW_REFERENCES.TRACKING_ID,

Line 1018: cursor c1 is select rowid from IGS_RE_THESIS_EXAM

1014: X_TRACKING_ID in NUMBER,
1015: X_THESIS_RESULT_CD in VARCHAR2,
1016: X_MODE in VARCHAR2
1017: ) as
1018: cursor c1 is select rowid from IGS_RE_THESIS_EXAM
1019: where PERSON_ID = X_PERSON_ID
1020: and CA_SEQUENCE_NUMBER = X_CA_SEQUENCE_NUMBER
1021: and THE_SEQUENCE_NUMBER = X_THE_SEQUENCE_NUMBER
1022: and CREATION_DT = X_CREATION_DT

Line 1072: delete from IGS_RE_THESIS_EXAM

1068:
1069: IF (x_mode = 'S') THEN
1070: igs_sc_gen_001.set_ctx('R');
1071: END IF;
1072: delete from IGS_RE_THESIS_EXAM
1073: where ROWID = X_ROWID;
1074: if (sql%notfound) then
1075: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');
1076: igs_ge_msg_stack.add;

Line 1093: end igs_re_thesis_exam_pkg;

1089:
1090:
1091: end DELETE_ROW;
1092:
1093: end igs_re_thesis_exam_pkg;