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_AD_OS_SEC_EDU_PKG dependencies on IGS_AD_OS_SEC_EDU

Line 1: package body IGS_AD_OS_SEC_EDU_PKG as

1: package body IGS_AD_OS_SEC_EDU_PKG as
2: /* $Header: IGSAI42B.pls 115.4 2003/10/30 13:20:32 rghosh ship $ */
3: l_rowid VARCHAR2(25);
4: old_references IGS_AD_OS_SEC_EDU%RowType;
5: new_references IGS_AD_OS_SEC_EDU%RowType;

Line 4: old_references IGS_AD_OS_SEC_EDU%RowType;

1: package body IGS_AD_OS_SEC_EDU_PKG as
2: /* $Header: IGSAI42B.pls 115.4 2003/10/30 13:20:32 rghosh ship $ */
3: l_rowid VARCHAR2(25);
4: old_references IGS_AD_OS_SEC_EDU%RowType;
5: new_references IGS_AD_OS_SEC_EDU%RowType;
6:
7: PROCEDURE Set_Column_Values (
8: p_action IN VARCHAR2,

Line 5: new_references IGS_AD_OS_SEC_EDU%RowType;

1: package body IGS_AD_OS_SEC_EDU_PKG as
2: /* $Header: IGSAI42B.pls 115.4 2003/10/30 13:20:32 rghosh ship $ */
3: l_rowid VARCHAR2(25);
4: old_references IGS_AD_OS_SEC_EDU%RowType;
5: new_references IGS_AD_OS_SEC_EDU%RowType;
6:
7: PROCEDURE Set_Column_Values (
8: p_action IN VARCHAR2,
9: x_rowid IN VARCHAR2 DEFAULT NULL,

Line 28: FROM IGS_AD_OS_SEC_EDU

24: ) AS
25:
26: CURSOR cur_old_ref_values IS
27: SELECT *
28: FROM IGS_AD_OS_SEC_EDU
29: WHERE rowid = x_rowid;
30:
31: BEGIN
32:

Line 197: IF NOT IGS_AD_OS_SEC_EDU_QF_PKG.Get_PK_For_Validation (

193: IF (((old_references.os_scndry_edu_qualification = new_references.os_scndry_edu_qualification)) OR
194: ((new_references.os_scndry_edu_qualification IS NULL))) THEN
195: NULL;
196: ELSE
197: IF NOT IGS_AD_OS_SEC_EDU_QF_PKG.Get_PK_For_Validation (
198: new_references.os_scndry_edu_qualification,
199: 'N'
200: ) THEN
201: Fnd_Message.Set_Name('FND','FORM_RECORD_DELETED');

Line 225: IGS_AD_OS_SEC_ED_SUB_PKG.GET_FK_IGS_AD_OS_SEC_EDU (

221:
222: PROCEDURE Check_Child_Existance AS
223: BEGIN
224:
225: IGS_AD_OS_SEC_ED_SUB_PKG.GET_FK_IGS_AD_OS_SEC_EDU (
226: old_references.person_id,
227: old_references.sequence_number
228: );
229:

Line 239: FROM IGS_AD_OS_SEC_EDU

235: )return BOOLEAN AS
236:
237: CURSOR cur_rowid IS
238: SELECT rowid
239: FROM IGS_AD_OS_SEC_EDU
240: WHERE person_id = x_person_id
241: AND sequence_number = x_sequence_number
242: FOR UPDATE NOWAIT;
243:

Line 266: FROM IGS_AD_OS_SEC_EDU

262: ) AS
263:
264: CURSOR cur_rowid IS
265: SELECT rowid
266: FROM IGS_AD_OS_SEC_EDU
267: WHERE country_cd = x_country_cd ;
268:
269: lv_rowid cur_rowid%RowType;
270:

Line 286: PROCEDURE GET_FK_IGS_AD_OS_SEC_EDU_QF (

282: Close cur_rowid;
283:
284: END GET_FK_IGS_PE_COUNTRY_CD;
285:
286: PROCEDURE GET_FK_IGS_AD_OS_SEC_EDU_QF (
287: x_os_scndry_edu_qualification IN VARCHAR2
288: ) AS
289:
290: CURSOR cur_rowid IS

Line 292: FROM IGS_AD_OS_SEC_EDU

288: ) AS
289:
290: CURSOR cur_rowid IS
291: SELECT rowid
292: FROM IGS_AD_OS_SEC_EDU
293: WHERE os_scndry_edu_qualification = x_os_scndry_edu_qualification ;
294:
295: lv_rowid cur_rowid%RowType;
296:

Line 310: END GET_FK_IGS_AD_OS_SEC_EDU_QF;

306: Return;
307: END IF;
308: Close cur_rowid;
309:
310: END GET_FK_IGS_AD_OS_SEC_EDU_QF;
311:
312: PROCEDURE GET_FK_IGS_PE_PERSON (
313: x_person_id IN NUMBER
314: ) AS

Line 318: FROM IGS_AD_OS_SEC_EDU

314: ) AS
315:
316: CURSOR cur_rowid IS
317: SELECT rowid
318: FROM IGS_AD_OS_SEC_EDU
319: WHERE person_id = x_person_id ;
320:
321: lv_rowid cur_rowid%RowType;
322:

Line 436: cursor C is select ROWID from IGS_AD_OS_SEC_EDU

432: X_COUNTRY_CD in VARCHAR2,
433: X_COMMENTS in VARCHAR2,
434: X_MODE in VARCHAR2 default 'R'
435: ) AS
436: cursor C is select ROWID from IGS_AD_OS_SEC_EDU
437: where PERSON_ID = X_PERSON_ID
438: and SEQUENCE_NUMBER = X_SEQUENCE_NUMBER;
439: X_LAST_UPDATE_DATE DATE;
440: X_LAST_UPDATED_BY NUMBER;

Line 482: insert into IGS_AD_OS_SEC_EDU (

478: x_last_updated_by=>X_LAST_UPDATED_BY ,
479: x_last_update_login=> X_LAST_UPDATE_LOGIN
480: );
481:
482: insert into IGS_AD_OS_SEC_EDU (
483: PERSON_ID,
484: SEQUENCE_NUMBER,
485: RESULT_OBTAINED_YR,
486: OS_SCNDRY_EDU_QUALIFICATION,

Line 549: from IGS_AD_OS_SEC_EDU

545: CANDIDATE_NUMBER,
546: SCHOOL_NAME,
547: COUNTRY_CD,
548: COMMENTS
549: from IGS_AD_OS_SEC_EDU
550: WHERE ROWID = X_ROWID for update nowait ;
551: tlinfo c1%rowtype;
552:
553: begin

Line 649: update IGS_AD_OS_SEC_EDU set

645: x_last_updated_by=>X_LAST_UPDATED_BY ,
646: x_last_update_login=> X_LAST_UPDATE_LOGIN
647: );
648:
649: update IGS_AD_OS_SEC_EDU set
650: RESULT_OBTAINED_YR = NEW_REFERENCES.RESULT_OBTAINED_YR,
651: OS_SCNDRY_EDU_QUALIFICATION = NEW_REFERENCES.OS_SCNDRY_EDU_QUALIFICATION,
652: RESULT = NEW_REFERENCES.RESULT,
653: CANDIDATE_NUMBER = NEW_REFERENCES.CANDIDATE_NUMBER,

Line 685: cursor c1 is select rowid from IGS_AD_OS_SEC_EDU

681: X_COUNTRY_CD in VARCHAR2,
682: X_COMMENTS in VARCHAR2,
683: X_MODE in VARCHAR2 default 'R'
684: ) AS
685: cursor c1 is select rowid from IGS_AD_OS_SEC_EDU
686: where PERSON_ID = X_PERSON_ID
687: and SEQUENCE_NUMBER = X_SEQUENCE_NUMBER
688: ;
689:

Line 734: delete from IGS_AD_OS_SEC_EDU

730: p_action=>'DELETE',
731: x_rowid=> X_ROWID
732: );
733:
734: delete from IGS_AD_OS_SEC_EDU
735: where ROWID = X_ROWID;
736: if (sql%notfound) then
737: raise no_data_found;
738: end if;

Line 749: end IGS_AD_OS_SEC_EDU_PKG;

745:
746:
747: end DELETE_ROW;
748:
749: end IGS_AD_OS_SEC_EDU_PKG;