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_DA_INST_PKG dependencies on IGS_CA_DA_INST

Line 1: package body IGS_CA_DA_INST_PKG AS

1: package body IGS_CA_DA_INST_PKG AS
2: /* $Header: IGSCI04B.pls 120.0 2005/06/02 03:39:05 appldev noship $ */
3: l_rowid VARCHAR2(25);
4: old_references IGS_CA_DA_INST%RowType;
5: new_references IGS_CA_DA_INST%RowType;

Line 4: old_references IGS_CA_DA_INST%RowType;

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

Line 5: new_references IGS_CA_DA_INST%RowType;

1: package body IGS_CA_DA_INST_PKG AS
2: /* $Header: IGSCI04B.pls 120.0 2005/06/02 03:39:05 appldev noship $ */
3: l_rowid VARCHAR2(25);
4: old_references IGS_CA_DA_INST%RowType;
5: new_references IGS_CA_DA_INST%RowType;
6:
7: PROCEDURE Set_Column_Values (
8: p_action IN VARCHAR2,
9: x_rowid IN VARCHAR2,

Line 35: FROM IGS_CA_DA_INST

31: ----------------------------------------------------------------------------*/
32:
33: CURSOR cur_old_ref_values IS
34: SELECT *
35: FROM IGS_CA_DA_INST
36: WHERE rowid = x_rowid;
37:
38: BEGIN
39:

Line 77: -- ON IGS_CA_DA_INST

73:
74: -- Trigger description :-
75: -- "OSS_TST".trg_dai_br_iud
76: -- BEFORE INSERT OR DELETE OR UPDATE
77: -- ON IGS_CA_DA_INST
78: -- FOR EACH ROW
79:
80: PROCEDURE BeforeRowInsertUpdateDelete1(
81: p_inserting IN BOOLEAN,

Line 117: -- ON IGS_CA_DA_INST

113:
114: -- Trigger description :-
115: -- "OSS_TST".trg_dai_as_iud
116: -- AFTER INSERT OR DELETE OR UPDATE
117: -- ON IGS_CA_DA_INST
118:
119: PROCEDURE AfterStmtInsertUpdateDelete3(
120: p_inserting IN BOOLEAN,
121: p_updating IN BOOLEAN,

Line 241: || rmaddipa 07-Sep-2004 Enh#3316063 Added call to IGS_FI_TP_RET_SCHD_PKG.GET_FK_IGS_CA_DA_INST

237: || Known limitations, enhancements or remarks :
238: || Change History :
239: || Who When What
240: || (reverse chronological order - newest change first)
241: || rmaddipa 07-Sep-2004 Enh#3316063 Added call to IGS_FI_TP_RET_SCHD_PKG.GET_FK_IGS_CA_DA_INST
242: || vvutukur 26-Aug-2002 Bug#2531390.Removed call to IGS_FI_FEE_PAY_SCHD_PKG.GET_FK_IGS_CA_DA_INST
243: || to remove the foreign key relationship between tables igs_ca_da_inst
244: || and igs_fi_fee_pay_schd.
245: ----------------------------------------------------------------------------*/

Line 242: || vvutukur 26-Aug-2002 Bug#2531390.Removed call to IGS_FI_FEE_PAY_SCHD_PKG.GET_FK_IGS_CA_DA_INST

238: || Change History :
239: || Who When What
240: || (reverse chronological order - newest change first)
241: || rmaddipa 07-Sep-2004 Enh#3316063 Added call to IGS_FI_TP_RET_SCHD_PKG.GET_FK_IGS_CA_DA_INST
242: || vvutukur 26-Aug-2002 Bug#2531390.Removed call to IGS_FI_FEE_PAY_SCHD_PKG.GET_FK_IGS_CA_DA_INST
243: || to remove the foreign key relationship between tables igs_ca_da_inst
244: || and igs_fi_fee_pay_schd.
245: ----------------------------------------------------------------------------*/
246: AS

Line 243: || to remove the foreign key relationship between tables igs_ca_da_inst

239: || Who When What
240: || (reverse chronological order - newest change first)
241: || rmaddipa 07-Sep-2004 Enh#3316063 Added call to IGS_FI_TP_RET_SCHD_PKG.GET_FK_IGS_CA_DA_INST
242: || vvutukur 26-Aug-2002 Bug#2531390.Removed call to IGS_FI_FEE_PAY_SCHD_PKG.GET_FK_IGS_CA_DA_INST
243: || to remove the foreign key relationship between tables igs_ca_da_inst
244: || and igs_fi_fee_pay_schd.
245: ----------------------------------------------------------------------------*/
246: AS
247: BEGIN

Line 248: IGS_AD_PECRS_OFOP_DT_PKG.GET_FK_IGS_CA_DA_INST (

244: || and igs_fi_fee_pay_schd.
245: ----------------------------------------------------------------------------*/
246: AS
247: BEGIN
248: IGS_AD_PECRS_OFOP_DT_PKG.GET_FK_IGS_CA_DA_INST (
249: old_references.dt_alias,
250: old_references.sequence_number,
251: old_references.cal_type,
252: old_references.ci_sequence_number

Line 255: IGS_GR_CRMN_ROUND_PKG.GET_FK_IGS_CA_DA_INST (

251: old_references.cal_type,
252: old_references.ci_sequence_number
253: );
254:
255: IGS_GR_CRMN_ROUND_PKG.GET_FK_IGS_CA_DA_INST (
256: old_references.dt_alias,
257: old_references.sequence_number,
258: old_references.cal_type,
259: old_references.ci_sequence_number

Line 262: IGS_CA_DA_INST_OFST_PKG.GET_FK_IGS_CA_DA_INST (

258: old_references.cal_type,
259: old_references.ci_sequence_number
260: );
261:
262: IGS_CA_DA_INST_OFST_PKG.GET_FK_IGS_CA_DA_INST (
263: old_references.dt_alias,
264: old_references.sequence_number,
265: old_references.cal_type,
266: old_references.ci_sequence_number

Line 270: IGS_CA_DA_INST_PAIR_PKG.GET_FK_IGS_CA_DA_INST (

266: old_references.ci_sequence_number
267: );
268:
269:
270: IGS_CA_DA_INST_PAIR_PKG.GET_FK_IGS_CA_DA_INST (
271: old_references.dt_alias,
272: old_references.sequence_number,
273: old_references.cal_type,
274: old_references.ci_sequence_number

Line 278: IGS_AS_EXAM_SESSION_PKG.GET_FK_IGS_CA_DA_INST (

274: old_references.ci_sequence_number
275: );
276:
277:
278: IGS_AS_EXAM_SESSION_PKG.GET_FK_IGS_CA_DA_INST (
279: old_references.dt_alias,
280: old_references.sequence_number,
281: old_references.cal_type,
282: old_references.ci_sequence_number

Line 285: IGS_FI_F_CAT_CA_INST_PKG.GET_FK_IGS_CA_DA_INST (

281: old_references.cal_type,
282: old_references.ci_sequence_number
283: );
284:
285: IGS_FI_F_CAT_CA_INST_PKG.GET_FK_IGS_CA_DA_INST (
286: old_references.dt_alias,
287: old_references.sequence_number,
288: old_references.cal_type,
289: old_references.ci_sequence_number

Line 292: IGS_FI_F_CAT_FEE_LBL_PKG.GET_FK_IGS_CA_DA_INST (

288: old_references.cal_type,
289: old_references.ci_sequence_number
290: );
291:
292: IGS_FI_F_CAT_FEE_LBL_PKG.GET_FK_IGS_CA_DA_INST (
293: old_references.dt_alias,
294: old_references.sequence_number,
295: old_references.cal_type,
296: old_references.ci_sequence_number

Line 299: /* Removed call to IGS_FI_FEE_ENCMB_PKG.GET_FK_IGS_CA_DA_INST since the TBH is obseleted as part of

295: old_references.cal_type,
296: old_references.ci_sequence_number
297: );
298:
299: /* Removed call to IGS_FI_FEE_ENCMB_PKG.GET_FK_IGS_CA_DA_INST since the TBH is obseleted as part of
300: bug 2126091-sykrishn */
301:
302: --Removed call to IGS_FI_FEE_PAY_SCHD_PKG.GET_FK_IGS_CA_DA_INST as part of SFCR005 CleanUp.Bug#2531390.
303:

Line 302: --Removed call to IGS_FI_FEE_PAY_SCHD_PKG.GET_FK_IGS_CA_DA_INST as part of SFCR005 CleanUp.Bug#2531390.

298:
299: /* Removed call to IGS_FI_FEE_ENCMB_PKG.GET_FK_IGS_CA_DA_INST since the TBH is obseleted as part of
300: bug 2126091-sykrishn */
301:
302: --Removed call to IGS_FI_FEE_PAY_SCHD_PKG.GET_FK_IGS_CA_DA_INST as part of SFCR005 CleanUp.Bug#2531390.
303:
304: IGS_FI_FEE_RET_SCHD_PKG.GET_FK_IGS_CA_DA_INST (
305: old_references.dt_alias,
306: old_references.sequence_number,

Line 304: IGS_FI_FEE_RET_SCHD_PKG.GET_FK_IGS_CA_DA_INST (

300: bug 2126091-sykrishn */
301:
302: --Removed call to IGS_FI_FEE_PAY_SCHD_PKG.GET_FK_IGS_CA_DA_INST as part of SFCR005 CleanUp.Bug#2531390.
303:
304: IGS_FI_FEE_RET_SCHD_PKG.GET_FK_IGS_CA_DA_INST (
305: old_references.dt_alias,
306: old_references.sequence_number,
307: old_references.cal_type,
308: old_references.ci_sequence_number

Line 311: IGS_FI_F_TYP_CA_INST_PKG.GET_FK_IGS_CA_DA_INST (

307: old_references.cal_type,
308: old_references.ci_sequence_number
309: );
310:
311: IGS_FI_F_TYP_CA_INST_PKG.GET_FK_IGS_CA_DA_INST (
312: old_references.dt_alias,
313: old_references.sequence_number,
314: old_references.cal_type,
315: old_references.ci_sequence_number

Line 318: IGS_GR_CRMN_PKG.GET_FK_IGS_CA_DA_INST (

314: old_references.cal_type,
315: old_references.ci_sequence_number
316: );
317:
318: IGS_GR_CRMN_PKG.GET_FK_IGS_CA_DA_INST (
319: old_references.dt_alias,
320: old_references.sequence_number,
321: old_references.cal_type,
322: old_references.ci_sequence_number

Line 324: IGS_FI_TP_RET_SCHD_PKG.GET_FK_IGS_CA_DA_INST(

320: old_references.sequence_number,
321: old_references.cal_type,
322: old_references.ci_sequence_number
323: );
324: IGS_FI_TP_RET_SCHD_PKG.GET_FK_IGS_CA_DA_INST(
325: x_dt_alias => old_references.dt_alias,
326: x_dai_sequence_number => old_references.sequence_number,
327: x_teach_cal_type => old_references.cal_type,
328: x_teach_ci_sequence_number => old_references.ci_sequence_number

Line 341: FROM IGS_CA_DA_INST

337: )RETURN BOOLEAN AS
338:
339: CURSOR cur_rowid IS
340: SELECT rowid
341: FROM IGS_CA_DA_INST
342: WHERE dt_alias = x_dt_alias
343: AND sequence_number = x_sequence_number
344: AND cal_type = x_cal_type
345: AND ci_sequence_number = x_ci_sequence_number

Line 371: FROM IGS_CA_DA_INST

367: ) AS
368:
369: CURSOR cur_rowid IS
370: SELECT rowid
371: FROM IGS_CA_DA_INST
372: WHERE cal_type = x_cal_type
373: AND ci_sequence_number = x_sequence_number ;
374:
375: lv_rowid cur_rowid%RowType;

Line 398: FROM IGS_CA_DA_INST

394: ) AS
395:
396: CURSOR cur_rowid IS
397: SELECT rowid
398: FROM IGS_CA_DA_INST
399: WHERE dt_alias = x_dt_alias ;
400:
401: lv_rowid cur_rowid%RowType;
402:

Line 560: cursor C is select ROWID from IGS_CA_DA_INST

556: X_CI_SEQUENCE_NUMBER in NUMBER,
557: X_ABSOLUTE_VAL in DATE,
558: X_MODE in VARCHAR2
559: ) AS
560: cursor C is select ROWID from IGS_CA_DA_INST
561: where DT_ALIAS = X_DT_ALIAS
562: and SEQUENCE_NUMBER = X_SEQUENCE_NUMBER
563: and CAL_TYPE = X_CAL_TYPE
564: and CI_SEQUENCE_NUMBER = X_CI_SEQUENCE_NUMBER;

Line 601: insert into IGS_CA_DA_INST (

597: x_last_update_date =>X_LAST_UPDATE_DATE,
598: x_last_updated_by =>X_LAST_UPDATED_BY,
599: x_last_update_login =>X_LAST_UPDATE_LOGIN
600: );
601: insert into IGS_CA_DA_INST (
602: DT_ALIAS,
603: SEQUENCE_NUMBER,
604: CAL_TYPE,
605: CI_SEQUENCE_NUMBER,

Line 648: from IGS_CA_DA_INST

644: X_ABSOLUTE_VAL in DATE
645: ) AS
646: cursor c1 is select
647: ABSOLUTE_VAL
648: from IGS_CA_DA_INST
649: where ROWID = X_ROWID
650: for update nowait;
651: tlinfo c1%rowtype;
652:

Line 723: update IGS_CA_DA_INST set

719: x_last_update_date =>X_LAST_UPDATE_DATE,
720: x_last_updated_by =>X_LAST_UPDATED_BY,
721: x_last_update_login =>X_LAST_UPDATE_LOGIN
722: );
723: update IGS_CA_DA_INST set
724: ABSOLUTE_VAL = NEW_REFERENCES.ABSOLUTE_VAL,
725: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
726: LAST_UPDATED_BY = X_LAST_UPDATED_BY,
727: LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN

Line 748: cursor c1 is select rowid from IGS_CA_DA_INST

744: X_CI_SEQUENCE_NUMBER in NUMBER,
745: X_ABSOLUTE_VAL in DATE,
746: X_MODE in VARCHAR2
747: ) AS
748: cursor c1 is select rowid from IGS_CA_DA_INST
749: where DT_ALIAS = X_DT_ALIAS
750: and SEQUENCE_NUMBER = X_SEQUENCE_NUMBER
751: and CAL_TYPE = X_CAL_TYPE
752: and CI_SEQUENCE_NUMBER = X_CI_SEQUENCE_NUMBER

Line 787: delete from IGS_CA_DA_INST

783: After_DML (
784: p_action =>'DELETE',
785: x_rowid =>X_ROWID
786: );
787: delete from IGS_CA_DA_INST
788: where ROWID = X_ROWID;
789: if (sql%notfound) then
790: raise no_data_found;
791: end if;

Line 798: end IGS_CA_DA_INST_PKG;

794: x_rowid =>X_ROWID
795: );
796: end DELETE_ROW;
797:
798: end IGS_CA_DA_INST_PKG;