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_SPRVSR_PKG dependencies on IGS_RE_SPRVSR

Line 1: package body IGS_RE_SPRVSR_PKG as

1: package body IGS_RE_SPRVSR_PKG as
2: /* $Header: IGSRI13B.pls 120.1 2005/07/04 00:42:01 appldev ship $ */
3: -------------------------------------------------------------------------------------------
4: --Change History:
5: --Who When What

Line 10: old_references IGS_RE_SPRVSR%RowType;

6: --smadathi 24-AUG-2001 Bug No. 1956374 .The call to igs_re_val_rsup.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_SPRVSR%RowType;
11: new_references IGS_RE_SPRVSR%RowType;
12:
13: PROCEDURE Set_Column_Values (
14: p_action IN VARCHAR2,

Line 11: new_references IGS_RE_SPRVSR%RowType;

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

Line 40: FROM IGS_RE_SPRVSR

36: ) AS
37:
38: CURSOR cur_old_ref_values IS
39: SELECT *
40: FROM IGS_RE_SPRVSR
41: WHERE rowid = x_rowid;
42:
43: BEGIN
44:

Line 411: -- ON IGS_RE_SPRVSR

407:
408: -- Trigger description :-
409: -- "OSS_TST".trg_rsup_as_iud
410: -- AFTER INSERT OR DELETE OR UPDATE
411: -- ON IGS_RE_SPRVSR
412:
413: PROCEDURE Check_Constraints (
414: Column_Name in VARCHAR2 ,
415: Column_Value in VARCHAR2

Line 558: IF NOT IGS_RE_SPRVSR_TYPE_PKG.Get_PK_For_Validation (

554: IF (((old_references.research_supervisor_type = new_references.research_supervisor_type)) OR
555: ((new_references.research_supervisor_type IS NULL))) THEN
556: NULL;
557: ELSE
558: IF NOT IGS_RE_SPRVSR_TYPE_PKG.Get_PK_For_Validation (
559: new_references.research_supervisor_type
560: ) THEN
561: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
562: IGS_GE_MSG_STACK.ADD;

Line 577: IF NOT IGS_RE_SPRVSR_PKG.Get_PK_For_Validation (

573: (new_references.replaced_person_id IS NULL) OR
574: (new_references.replaced_sequence_number IS NULL))) THEN
575: NULL;
576: ELSE
577: IF NOT IGS_RE_SPRVSR_PKG.Get_PK_For_Validation (
578: new_references.ca_person_id,
579: new_references.ca_sequence_number,
580: new_references.replaced_person_id,
581: new_references.replaced_sequence_number

Line 594: IGS_RE_SPRVSR_PKG.GET_FK_IGS_RE_SPRVSR (

590:
591: PROCEDURE Check_Child_Existance AS
592: BEGIN
593:
594: IGS_RE_SPRVSR_PKG.GET_FK_IGS_RE_SPRVSR (
595: old_references.ca_person_id,
596: old_references.ca_sequence_number,
597: old_references.person_id,
598: old_references.sequence_number

Line 614: FROM IGS_RE_SPRVSR

610: AS
611:
612: CURSOR cur_rowid IS
613: SELECT rowid
614: FROM IGS_RE_SPRVSR
615: WHERE ca_person_id = x_ca_person_id
616: AND ca_sequence_number = x_ca_sequence_number
617: AND person_id = x_person_id
618: AND sequence_number = x_sequence_number

Line 647: FROM IGS_RE_SPRVSR

643: RETURN BOOLEAN
644: AS
645: CURSOR cur_rowid IS
646: SELECT rowid
647: FROM IGS_RE_SPRVSR
648: WHERE ca_person_id = x_ca_person_id
649: AND ca_sequence_number = x_ca_sequence_number
650: AND person_id = x_person_id
651: AND start_dt = x_start_dt

Line 677: FROM IGS_RE_SPRVSR

673: ) AS
674:
675: CURSOR cur_rowid IS
676: SELECT rowid
677: FROM IGS_RE_SPRVSR
678: WHERE ca_person_id = x_person_id
679: AND ca_sequence_number = x_sequence_number ;
680:
681: lv_rowid cur_rowid%RowType;

Line 705: FROM IGS_RE_SPRVSR

701: ) AS
702:
703: CURSOR cur_rowid IS
704: SELECT rowid
705: FROM IGS_RE_SPRVSR
706: WHERE org_unit_cd = x_org_unit_cd
707: AND ou_start_dt = x_start_dt ;
708:
709: lv_rowid cur_rowid%RowType;

Line 732: FROM IGS_RE_SPRVSR

728: ) AS
729:
730: CURSOR cur_rowid IS
731: SELECT rowid
732: FROM IGS_RE_SPRVSR
733: WHERE person_id = x_person_id ;
734:
735: lv_rowid cur_rowid%RowType;
736:

Line 752: PROCEDURE GET_FK_IGS_RE_SPRVSR_TYPE (

748: Close cur_rowid;
749:
750: END GET_FK_IGS_PE_PERSON;
751:
752: PROCEDURE GET_FK_IGS_RE_SPRVSR_TYPE (
753: x_research_supervisor_type IN VARCHAR2
754: ) AS
755:
756: CURSOR cur_rowid IS

Line 758: FROM IGS_RE_SPRVSR

754: ) AS
755:
756: CURSOR cur_rowid IS
757: SELECT rowid
758: FROM IGS_RE_SPRVSR
759: WHERE research_supervisor_type = x_research_supervisor_type ;
760:
761: lv_rowid cur_rowid%RowType;
762:

Line 776: END GET_FK_IGS_RE_SPRVSR_TYPE;

772: Return;
773: END IF;
774: Close cur_rowid;
775:
776: END GET_FK_IGS_RE_SPRVSR_TYPE;
777:
778: PROCEDURE GET_FK_IGS_RE_SPRVSR (
779: x_ca_person_id IN NUMBER,
780: x_ca_sequence_number IN NUMBER,

Line 778: PROCEDURE GET_FK_IGS_RE_SPRVSR (

774: Close cur_rowid;
775:
776: END GET_FK_IGS_RE_SPRVSR_TYPE;
777:
778: PROCEDURE GET_FK_IGS_RE_SPRVSR (
779: x_ca_person_id IN NUMBER,
780: x_ca_sequence_number IN NUMBER,
781: x_person_id IN NUMBER,
782: x_sequence_number IN NUMBER

Line 787: FROM IGS_RE_SPRVSR

783: ) AS
784:
785: CURSOR cur_rowid IS
786: SELECT rowid
787: FROM IGS_RE_SPRVSR
788: WHERE ca_person_id = x_ca_person_id
789: AND ca_sequence_number = x_ca_sequence_number
790: AND replaced_person_id = x_person_id
791: AND replaced_sequence_number = x_sequence_number ;

Line 808: END GET_FK_IGS_RE_SPRVSR;

804: Return;
805: END IF;
806: Close cur_rowid;
807:
808: END GET_FK_IGS_RE_SPRVSR;
809:
810: PROCEDURE Before_DML (
811: p_action IN VARCHAR2,
812: x_rowid IN VARCHAR2 ,

Line 959: cursor C is select ROWID from IGS_RE_SPRVSR

955: X_REPLACED_SEQUENCE_NUMBER in NUMBER,
956: X_COMMENTS in VARCHAR2,
957: X_MODE in VARCHAR2
958: ) as
959: cursor C is select ROWID from IGS_RE_SPRVSR
960: where CA_PERSON_ID = X_CA_PERSON_ID
961: and CA_SEQUENCE_NUMBER = X_CA_SEQUENCE_NUMBER
962: and PERSON_ID = X_PERSON_ID
963: and SEQUENCE_NUMBER = X_SEQUENCE_NUMBER;

Line 1015: insert into IGS_RE_SPRVSR (

1011:
1012: IF (x_mode = 'S') THEN
1013: igs_sc_gen_001.set_ctx('R');
1014: END IF;
1015: insert into IGS_RE_SPRVSR (
1016: CA_PERSON_ID,
1017: CA_SEQUENCE_NUMBER,
1018: PERSON_ID,
1019: SEQUENCE_NUMBER,

Line 1121: from IGS_RE_SPRVSR

1117: OU_START_DT,
1118: REPLACED_PERSON_ID,
1119: REPLACED_SEQUENCE_NUMBER,
1120: COMMENTS
1121: from IGS_RE_SPRVSR
1122: where ROWID = X_ROWID
1123: for update nowait;
1124: tlinfo c1%rowtype;
1125:

Line 1245: update IGS_RE_SPRVSR set

1241:
1242: IF (x_mode = 'S') THEN
1243: igs_sc_gen_001.set_ctx('R');
1244: END IF;
1245: update IGS_RE_SPRVSR set
1246: START_DT = NEW_REFERENCES.START_DT,
1247: END_DT = NEW_REFERENCES.END_DT,
1248: RESEARCH_SUPERVISOR_TYPE = NEW_REFERENCES.RESEARCH_SUPERVISOR_TYPE,
1249: SUPERVISOR_PROFESSION = NEW_REFERENCES.SUPERVISOR_PROFESSION,

Line 1313: select rowid from IGS_RE_SPRVSR

1309: X_COMMENTS in VARCHAR2,
1310: X_MODE in VARCHAR2
1311: ) as
1312: cursor c1 is
1313: select rowid from IGS_RE_SPRVSR
1314: where CA_PERSON_ID = X_CA_PERSON_ID
1315: and CA_SEQUENCE_NUMBER = X_CA_SEQUENCE_NUMBER
1316: and PERSON_ID = X_PERSON_ID
1317: and SEQUENCE_NUMBER = X_SEQUENCE_NUMBER

Line 1379: delete from IGS_RE_SPRVSR

1375:
1376: IF (x_mode = 'S') THEN
1377: igs_sc_gen_001.set_ctx('R');
1378: END IF;
1379: delete from IGS_RE_SPRVSR
1380: where ROWID = X_ROWID;
1381: if (sql%notfound) then
1382: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');
1383: igs_ge_msg_stack.add;

Line 1393: end IGS_RE_SPRVSR_PKG;

1389: END IF;
1390:
1391: end DELETE_ROW;
1392:
1393: end IGS_RE_SPRVSR_PKG;