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_CA_INST_REL_PKG dependencies on IGS_CA_INST_REL

Line 1: package body IGS_CA_INST_REL_PKG AS

1: package body IGS_CA_INST_REL_PKG AS
2: /* $Header: IGSCI13B.pls 120.0 2005/06/02 03:52:17 appldev noship $ */
3: l_rowid VARCHAR2(25);
4: old_references IGS_CA_INST_REL%RowType;
5: new_references IGS_CA_INST_REL%RowType;

Line 4: old_references IGS_CA_INST_REL%RowType;

1: package body IGS_CA_INST_REL_PKG AS
2: /* $Header: IGSCI13B.pls 120.0 2005/06/02 03:52:17 appldev noship $ */
3: l_rowid VARCHAR2(25);
4: old_references IGS_CA_INST_REL%RowType;
5: new_references IGS_CA_INST_REL%RowType;
6:
7: PROCEDURE Set_Column_Values (
8: p_action IN VARCHAR2,

Line 5: new_references IGS_CA_INST_REL%RowType;

1: package body IGS_CA_INST_REL_PKG AS
2: /* $Header: IGSCI13B.pls 120.0 2005/06/02 03:52:17 appldev noship $ */
3: l_rowid VARCHAR2(25);
4: old_references IGS_CA_INST_REL%RowType;
5: new_references IGS_CA_INST_REL%RowType;
6:
7: PROCEDURE Set_Column_Values (
8: p_action IN VARCHAR2,
9: x_rowid IN VARCHAR2 DEFAULT NULL,

Line 24: FROM IGS_CA_INST_REL

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

Line 66: -- ON IGS_CA_INST_REL

62:
63: -- Trigger description :-
64: -- "OSS_TST".trg_cir_as_i
65: -- AFTER INSERT
66: -- ON IGS_CA_INST_REL
67:
68: PROCEDURE BeforeRowInsertUpdateDelete(
69: p_inserting IN BOOLEAN DEFAULT FALSE,
70: p_updating IN BOOLEAN DEFAULT FALSE,

Line 104: FROM igs_ca_inst_rel cir,

100: cp_sup_ci_sequence_number IN igs_ca_inst.sequence_number%TYPE,
101: cp_sub_cal_type IN igs_ca_inst.cal_type%TYPE,
102: cp_sub_ci_sequence_number IN igs_ca_inst.sequence_number%TYPE) IS
103: SELECT 'x'
104: FROM igs_ca_inst_rel cir,
105: igs_ca_type ct1,
106: igs_ca_type ct2
107: WHERE cir.sub_cal_type = ct1.cal_type
108: AND ct1.s_cal_cat = cst_load

Line 191: FROM igs_ca_inst_rel a ,

187: FUNCTION Check_acad_adm_cal_rel(p_rowid IN ROWID )
188: RETURN BOOLEAN AS
189: CURSOR c_acad_adm_rel IS
190: SELECT 'X'
191: FROM igs_ca_inst_rel a ,
192: igs_ca_type b ,
193: igs_ca_type c ,
194: igs_ca_inst d ,
195: igs_ca_inst e ,

Line 300: IGS_AD_APPL_PKG.GET_FK_IGS_CA_INST_REL (

296:
297: PROCEDURE Check_Child_Existance AS
298: BEGIN
299:
300: IGS_AD_APPL_PKG.GET_FK_IGS_CA_INST_REL (
301: old_references.sub_cal_type,
302: old_references.sub_ci_sequence_number,
303: old_references.sup_cal_type,
304: old_references.sup_ci_sequence_number

Line 309: 'begin IGR_I_APPL_PKG.GET_FK_IGS_CA_INST_REL ( :1, :2, :3, :4); end;'

305: );
306:
307: IF NVL(fnd_profile.value('IGS_RECRUITING_ENABLED'), 'N') = 'Y' THEN
308: EXECUTE IMMEDIATE
309: 'begin IGR_I_APPL_PKG.GET_FK_IGS_CA_INST_REL ( :1, :2, :3, :4); end;'
310: USING old_references.sub_cal_type,
311: old_references.sub_ci_sequence_number,
312: old_references.sup_cal_type,
313: old_references.sup_ci_sequence_number;

Line 327: FROM IGS_CA_INST_REL

323: ) RETURN BOOLEAN AS
324:
325: CURSOR cur_rowid IS
326: SELECT rowid
327: FROM IGS_CA_INST_REL
328: WHERE sub_cal_type = x_sub_cal_type
329: AND sub_ci_sequence_number = x_sub_ci_sequence_number
330: AND sup_cal_type = x_sup_cal_type
331: AND sup_ci_sequence_number = x_sup_ci_sequence_number;

Line 355: FROM IGS_CA_INST_REL

351: ) AS
352:
353: CURSOR cur_rowid IS
354: SELECT rowid
355: FROM IGS_CA_INST_REL
356: WHERE (sub_cal_type = x_cal_type
357: AND sub_ci_sequence_number = x_sequence_number)
358: OR (sup_cal_type = x_cal_type
359: AND sup_ci_sequence_number = x_sequence_number);

Line 498: cursor C is select ROWID from IGS_CA_INST_REL

494: X_SUP_CI_SEQUENCE_NUMBER in NUMBER,
495: X_LOAD_RESEARCH_PERCENTAGE in NUMBER,
496: X_MODE in VARCHAR2 default 'R'
497: ) AS
498: cursor C is select ROWID from IGS_CA_INST_REL
499: where SUB_CAL_TYPE = X_SUB_CAL_TYPE
500: and SUB_CI_SEQUENCE_NUMBER = X_SUB_CI_SEQUENCE_NUMBER
501: and SUP_CAL_TYPE = X_SUP_CAL_TYPE
502: and SUP_CI_SEQUENCE_NUMBER = X_SUP_CI_SEQUENCE_NUMBER;

Line 539: insert into IGS_CA_INST_REL (

535: x_last_update_date =>X_LAST_UPDATE_DATE,
536: x_last_updated_by =>X_LAST_UPDATED_BY,
537: x_last_update_login =>X_LAST_UPDATE_LOGIN
538: );
539: insert into IGS_CA_INST_REL (
540: SUB_CAL_TYPE,
541: SUB_CI_SEQUENCE_NUMBER,
542: SUP_CAL_TYPE,
543: SUP_CI_SEQUENCE_NUMBER,

Line 586: from IGS_CA_INST_REL

582: X_LOAD_RESEARCH_PERCENTAGE in NUMBER
583: ) AS
584: cursor c1 is select
585: LOAD_RESEARCH_PERCENTAGE
586: from IGS_CA_INST_REL
587: where ROWID=X_ROWID
588: for update nowait;
589: tlinfo c1%rowtype;
590:

Line 661: update IGS_CA_INST_REL set

657: x_last_update_date =>X_LAST_UPDATE_DATE,
658: x_last_updated_by =>X_LAST_UPDATED_BY,
659: x_last_update_login =>X_LAST_UPDATE_LOGIN
660: );
661: update IGS_CA_INST_REL set
662: LOAD_RESEARCH_PERCENTAGE = NEW_REFERENCES.LOAD_RESEARCH_PERCENTAGE,
663: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
664: LAST_UPDATED_BY = X_LAST_UPDATED_BY,
665: LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN

Line 686: cursor c1 is select rowid from IGS_CA_INST_REL

682: X_SUP_CI_SEQUENCE_NUMBER in NUMBER,
683: X_LOAD_RESEARCH_PERCENTAGE in NUMBER,
684: X_MODE in VARCHAR2 default 'R'
685: ) AS
686: cursor c1 is select rowid from IGS_CA_INST_REL
687: where SUB_CAL_TYPE = X_SUB_CAL_TYPE
688: and SUB_CI_SEQUENCE_NUMBER = X_SUB_CI_SEQUENCE_NUMBER
689: and SUP_CAL_TYPE = X_SUP_CAL_TYPE
690: and SUP_CI_SEQUENCE_NUMBER = X_SUP_CI_SEQUENCE_NUMBER

Line 726: delete from IGS_CA_INST_REL

722: Before_DML (
723: p_action =>'DELETE',
724: x_rowid =>X_ROWID
725: );
726: delete from IGS_CA_INST_REL
727: where ROWID=X_ROWID;
728: if (sql%notfound) then
729: raise no_data_found;
730: end if;

Line 737: end IGS_CA_INST_REL_PKG;

733: x_rowid =>X_ROWID
734: );
735: end DELETE_ROW;
736:
737: end IGS_CA_INST_REL_PKG;