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_RE_CANDIDATURE_PKG dependencies on IGS_RE_CANDIDATURE_ALL

Line 10: old_references IGS_RE_CANDIDATURE_ALL%RowType;

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

Line 11: new_references IGS_RE_CANDIDATURE_ALL%RowType;

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

Line 36: FROM IGS_RE_CANDIDATURE_ALL

32: x_org_id IN NUMBER
33: ) AS
34: CURSOR cur_old_ref_values IS
35: SELECT *
36: FROM IGS_RE_CANDIDATURE_ALL
37: WHERE rowid = x_rowid;
38: BEGIN
39: l_rowid := x_rowid;
40: -- Code for setting the Old and New Reference Values.

Line 391: IF igs_as_val_suaap.genp_val_sdtt_sess('IGS_RE_CANDIDATURE_ALL') THEN

387: v_message_name VARCHAR2(30);
388:
389: BEGIN
390: -- If trigger has not been disabled, perform required processing
391: IF igs_as_val_suaap.genp_val_sdtt_sess('IGS_RE_CANDIDATURE_ALL') THEN
392: -- Insert IGS_RE_CANDIDATURE attendance history from row ids saved
393: -- when IGS_RE_CANDIDATURE attendance percentage changed
394:
395: -- Mutation logic pasted

Line 672: FROM IGS_RE_CANDIDATURE_ALL

668: RETURN BOOLEAN
669: AS
670: CURSOR cur_rowid IS
671: SELECT rowid
672: FROM IGS_RE_CANDIDATURE_ALL
673: WHERE person_id = x_person_id
674: AND sequence_number = x_sequence_number
675: FOR UPDATE NOWAIT;
676: lv_rowid cur_rowid%RowType;

Line 697: FROM IGS_RE_CANDIDATURE_ALL

693: x_sequence_number IN NUMBER
694: ) AS
695: CURSOR cur_rowid IS
696: SELECT rowid
697: FROM IGS_RE_CANDIDATURE_ALL
698: WHERE person_id = x_person_id
699: AND acai_admission_appl_number = x_admission_appl_number
700: AND acai_nominated_course_cd = x_nominated_course_cd
701: AND acai_sequence_number = x_sequence_number ;

Line 721: FROM IGS_RE_CANDIDATURE_ALL

717: x_govt_toa_class_cd IN VARCHAR2
718: ) AS
719: CURSOR cur_rowid IS
720: SELECT rowid
721: FROM IGS_RE_CANDIDATURE_ALL
722: WHERE govt_type_of_activity_cd = x_govt_toa_class_cd ;
723: lv_rowid cur_rowid%RowType;
724: BEGIN
725: Open cur_rowid;

Line 741: FROM IGS_RE_CANDIDATURE_ALL

737: x_person_id IN NUMBER
738: ) AS
739: CURSOR cur_rowid IS
740: SELECT rowid
741: FROM IGS_RE_CANDIDATURE_ALL
742: WHERE person_id = x_person_id ;
743: lv_rowid cur_rowid%RowType;
744: BEGIN
745: Open cur_rowid;

Line 763: FROM IGS_RE_CANDIDATURE_ALL

759: x_course_cd IN VARCHAR2
760: ) AS
761: CURSOR cur_rowid IS
762: SELECT rowid
763: FROM IGS_RE_CANDIDATURE_ALL
764: WHERE person_id = x_person_id
765: AND sca_course_cd = x_course_cd ;
766: lv_rowid cur_rowid%RowType;
767: BEGIN

Line 929: cursor C is select ROWID from IGS_RE_CANDIDATURE_ALL

925: X_INDUSTRY_LINKS in VARCHAR2,
926: X_MODE in VARCHAR2,
927: X_ORG_ID in NUMBER
928: ) as
929: cursor C is select ROWID from IGS_RE_CANDIDATURE_ALL
930: where PERSON_ID = X_PERSON_ID
931: and SEQUENCE_NUMBER = X_SEQUENCE_NUMBER;
932: X_LAST_UPDATE_DATE DATE;
933: X_LAST_UPDATED_BY NUMBER;

Line 994: insert into IGS_RE_CANDIDATURE_ALL (

990: ) ;
991: IF (x_mode = 'S') THEN
992: igs_sc_gen_001.set_ctx('R');
993: END IF;
994: insert into IGS_RE_CANDIDATURE_ALL (
995: PERSON_ID,
996: SEQUENCE_NUMBER,
997: SCA_COURSE_CD,
998: ACAI_ADMISSION_APPL_NUMBER,

Line 1096: from IGS_RE_CANDIDATURE_ALL

1092: MAX_SUBMISSION_DT,
1093: MIN_SUBMISSION_DT,
1094: RESEARCH_TOPIC,
1095: INDUSTRY_LINKS
1096: from IGS_RE_CANDIDATURE_ALL
1097: where ROWID = X_ROWID
1098: for update nowait;
1099: tlinfo c1%rowtype;
1100: begin

Line 1227: update IGS_RE_CANDIDATURE_ALL set

1223: end if;
1224: IF (x_mode = 'S') THEN
1225: igs_sc_gen_001.set_ctx('R');
1226: END IF;
1227: update IGS_RE_CANDIDATURE_ALL set
1228: SCA_COURSE_CD = NEW_REFERENCES.SCA_COURSE_CD,
1229: ACAI_ADMISSION_APPL_NUMBER = NEW_REFERENCES.ACAI_ADMISSION_APPL_NUMBER,
1230: ACAI_NOMINATED_COURSE_CD = NEW_REFERENCES.ACAI_NOMINATED_COURSE_CD,
1231: ACAI_SEQUENCE_NUMBER = NEW_REFERENCES.ACAI_SEQUENCE_NUMBER,

Line 1291: cursor c1 is select rowid from IGS_RE_CANDIDATURE_ALL

1287: X_INDUSTRY_LINKS in VARCHAR2,
1288: X_MODE in VARCHAR2 ,
1289: X_ORG_ID in NUMBER
1290: ) as
1291: cursor c1 is select rowid from IGS_RE_CANDIDATURE_ALL
1292: where PERSON_ID = X_PERSON_ID
1293: and SEQUENCE_NUMBER = X_SEQUENCE_NUMBER
1294: ;
1295: begin

Line 1347: delete from IGS_RE_CANDIDATURE_ALL

1343: );
1344: IF (x_mode = 'S') THEN
1345: igs_sc_gen_001.set_ctx('R');
1346: END IF;
1347: delete from IGS_RE_CANDIDATURE_ALL
1348: where ROWID = X_ROWID;
1349: if (sql%notfound) then
1350: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');
1351: igs_ge_msg_stack.add;