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

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 86: smvk 05-Feb-2002 Added call to IGS_FI_CREDITS_PKG.GET_FK_IGS_CA_INST_2

82: enhancements,
83: remarks :
84: Change History
85: Who When What
86: smvk 05-Feb-2002 Added call to IGS_FI_CREDITS_PKG.GET_FK_IGS_CA_INST_2
87: This is as per new Application Hierarchicy Compliance DLD
88: Enhancement Bug No. 2191470
89: ******************************************************************/
90: cst_load CONSTANT VARCHAR2(10):= 'LOAD';

Line 99: CURSOR c_fci_lci(cp_sup_cal_type IN igs_ca_inst.cal_type%TYPE,

95: SELECT s_cal_cat
96: FROM igs_ca_type
97: WHERE cal_type = cp_cal_type;
98:
99: CURSOR c_fci_lci(cp_sup_cal_type IN igs_ca_inst.cal_type%TYPE,
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'

Line 100: cp_sup_ci_sequence_number IN igs_ca_inst.sequence_number%TYPE,

96: FROM igs_ca_type
97: WHERE cal_type = cp_cal_type;
98:
99: CURSOR c_fci_lci(cp_sup_cal_type IN igs_ca_inst.cal_type%TYPE,
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,

Line 101: cp_sub_cal_type IN igs_ca_inst.cal_type%TYPE,

97: WHERE cal_type = cp_cal_type;
98:
99: CURSOR c_fci_lci(cp_sup_cal_type IN igs_ca_inst.cal_type%TYPE,
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,

Line 102: cp_sub_ci_sequence_number IN igs_ca_inst.sequence_number%TYPE) IS

98:
99: CURSOR c_fci_lci(cp_sup_cal_type IN igs_ca_inst.cal_type%TYPE,
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

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 143: IGS_FI_F_TYP_CA_INST_PKG.GET_FK_IGS_CA_INST (

139:
140: IF p_deleting THEN
141:
142: -- Prevents delete of a Fee Cal Instance relation if it is used in the FTCI table
143: IGS_FI_F_TYP_CA_INST_PKG.GET_FK_IGS_CA_INST (
144: old_references.sup_cal_type,
145: old_references.sup_ci_sequence_number
146: );
147:

Line 149: IGS_FI_F_CAT_CA_INST_PKG.GET_FK_IGS_CA_INST (

145: old_references.sup_ci_sequence_number
146: );
147:
148: -- Prevents delete of a Fee Cal Instance relation if it is used in the FCCI table
149: IGS_FI_F_CAT_CA_INST_PKG.GET_FK_IGS_CA_INST (
150: old_references.sup_cal_type,
151: old_references.sup_ci_sequence_number
152: );
153:

Line 155: IGS_FI_CREDITS_PKG.GET_FK_IGS_CA_INST_2(

151: old_references.sup_ci_sequence_number
152: );
153:
154: -- Prevents delete if Fee Cal Instance is used in igs_fi_credits_all table Bug No. 2191470
155: IGS_FI_CREDITS_PKG.GET_FK_IGS_CA_INST_2(
156: old_references.sup_cal_type,
157: old_references.sup_ci_sequence_number
158: );
159:

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 194: igs_ca_inst d ,

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 ,
196: igs_ca_stat f,
197: igs_ca_stat g
198: WHERE a.rowid = p_rowid

Line 195: igs_ca_inst e ,

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 ,
196: igs_ca_stat f,
197: igs_ca_stat g
198: WHERE a.rowid = p_rowid
199: AND a.sub_cal_type = b.cal_type

Line 272: ELSIF NOT IGS_CA_INST_PKG.Get_PK_For_Validation (

268: (old_references.sub_ci_sequence_number = new_references.sub_ci_sequence_number)) OR
269: ((new_references.sub_cal_type IS NULL) OR
270: (new_references.sub_ci_sequence_number IS NULL))) THEN
271: NULL;
272: ELSIF NOT IGS_CA_INST_PKG.Get_PK_For_Validation (
273: new_references.sub_cal_type,
274: new_references.sub_ci_sequence_number
275: ) THEN
276: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');

Line 286: ELSIF NOT IGS_CA_INST_PKG.Get_PK_For_Validation (

282: (old_references.sup_ci_sequence_number = new_references.sup_ci_sequence_number)) OR
283: ((new_references.sup_cal_type IS NULL) OR
284: (new_references.sup_ci_sequence_number IS NULL))) THEN
285: NULL;
286: ELSIF NOT IGS_CA_INST_PKG.Get_PK_For_Validation (
287: new_references.sup_cal_type,
288: new_references.sup_ci_sequence_number
289: ) THEN
290: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');

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 348: PROCEDURE GET_FK_IGS_CA_INST (

344: Return (FALSE);
345: END IF;
346: END Get_PK_For_Validation;
347:
348: PROCEDURE GET_FK_IGS_CA_INST (
349: x_cal_type IN VARCHAR2,
350: x_sequence_number IN NUMBER
351: ) AS
352:

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 375: END GET_FK_IGS_CA_INST;

371: Return;
372: END IF;
373: Close cur_rowid;
374:
375: END GET_FK_IGS_CA_INST;
376:
377:
378:
379: PROCEDURE Before_DML (

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;