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_ST_DFT_LOAD_APPO_PKG dependencies on IGS_ST_DFT_LOAD_APPO

Line 1: package body IGS_ST_DFT_LOAD_APPO_PKG as

1: package body IGS_ST_DFT_LOAD_APPO_PKG as
2: /* $Header: IGSVI02B.pls 115.3 2002/11/29 04:31:06 nsidana ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references IGS_ST_DFT_LOAD_APPO%RowType;

Line 5: old_references IGS_ST_DFT_LOAD_APPO%RowType;

1: package body IGS_ST_DFT_LOAD_APPO_PKG as
2: /* $Header: IGSVI02B.pls 115.3 2002/11/29 04:31:06 nsidana ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references IGS_ST_DFT_LOAD_APPO%RowType;
6: new_references IGS_ST_DFT_LOAD_APPO%RowType;
7:
8: PROCEDURE Set_Column_Values (
9: p_action IN VARCHAR2,

Line 6: new_references IGS_ST_DFT_LOAD_APPO%RowType;

2: /* $Header: IGSVI02B.pls 115.3 2002/11/29 04:31:06 nsidana ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references IGS_ST_DFT_LOAD_APPO%RowType;
6: new_references IGS_ST_DFT_LOAD_APPO%RowType;
7:
8: PROCEDURE Set_Column_Values (
9: p_action IN VARCHAR2,
10: x_rowid IN VARCHAR2 DEFAULT NULL,

Line 25: FROM IGS_ST_DFT_LOAD_APPO

21: ) as
22:
23: CURSOR cur_old_ref_values IS
24: SELECT *
25: FROM IGS_ST_DFT_LOAD_APPO
26: WHERE rowid = x_rowid;
27:
28: BEGIN
29:

Line 70: v_cal_type IGS_ST_DFT_LOAD_APPO.cal_type%TYPE;

66: p_updating IN BOOLEAN DEFAULT FALSE,
67: p_deleting IN BOOLEAN DEFAULT FALSE
68: ) as
69: v_message_name varchar2(30);
70: v_cal_type IGS_ST_DFT_LOAD_APPO.cal_type%TYPE;
71: v_ci_sequence_number IGS_ST_DFT_LOAD_APPO.ci_sequence_number%TYPE;
72: BEGIN
73: IF p_inserting OR p_updating THEN
74: v_cal_type := new_references.cal_type;

Line 71: v_ci_sequence_number IGS_ST_DFT_LOAD_APPO.ci_sequence_number%TYPE;

67: p_deleting IN BOOLEAN DEFAULT FALSE
68: ) as
69: v_message_name varchar2(30);
70: v_cal_type IGS_ST_DFT_LOAD_APPO.cal_type%TYPE;
71: v_ci_sequence_number IGS_ST_DFT_LOAD_APPO.ci_sequence_number%TYPE;
72: BEGIN
73: IF p_inserting OR p_updating THEN
74: v_cal_type := new_references.cal_type;
75: v_ci_sequence_number := new_references.ci_sequence_number;

Line 205: IGS_AD_ADM_UT_STT_LD_PKG.GET_FK_IGS_ST_DFT_LOAD_APPO (

201:
202: PROCEDURE Check_Child_Existance as
203: BEGIN
204:
205: IGS_AD_ADM_UT_STT_LD_PKG.GET_FK_IGS_ST_DFT_LOAD_APPO (
206: old_references.cal_type,
207: old_references.ci_sequence_number,
208: old_references.teach_cal_type
209: );

Line 211: IGS_ST_GVTSEMLOAD_OV_PKG.GET_FK_IGS_ST_DFT_LOAD_APPO (

207: old_references.ci_sequence_number,
208: old_references.teach_cal_type
209: );
210:
211: IGS_ST_GVTSEMLOAD_OV_PKG.GET_FK_IGS_ST_DFT_LOAD_APPO (
212: old_references.cal_type,
213: old_references.ci_sequence_number,
214: old_references.teach_cal_type
215: );

Line 217: IGS_ST_UNT_LOAD_APPO_PKG.GET_FK_IGS_ST_DFT_LOAD_APPO (

213: old_references.ci_sequence_number,
214: old_references.teach_cal_type
215: );
216:
217: IGS_ST_UNT_LOAD_APPO_PKG.GET_FK_IGS_ST_DFT_LOAD_APPO (
218: old_references.cal_type,
219: old_references.ci_sequence_number,
220: old_references.teach_cal_type
221: );

Line 234: FROM IGS_ST_DFT_LOAD_APPO

230: as
231:
232: CURSOR cur_rowid IS
233: SELECT rowid
234: FROM IGS_ST_DFT_LOAD_APPO
235: WHERE cal_type = x_cal_type
236: AND ci_sequence_number = x_ci_sequence_number
237: AND teach_cal_type = x_teach_cal_type
238: FOR UPDATE NOWAIT;

Line 262: FROM IGS_ST_DFT_LOAD_APPO

258: ) as
259:
260: CURSOR cur_rowid IS
261: SELECT rowid
262: FROM IGS_ST_DFT_LOAD_APPO
263: WHERE teach_cal_type = x_cal_type ;
264:
265: lv_rowid cur_rowid%RowType;
266:

Line 289: FROM IGS_ST_DFT_LOAD_APPO

285: ) as
286:
287: CURSOR cur_rowid IS
288: SELECT rowid
289: FROM IGS_ST_DFT_LOAD_APPO
290: WHERE cal_type = x_cal_type
291: AND ci_sequence_number = x_sequence_number ;
292:
293: lv_rowid cur_rowid%RowType;

Line 407: cursor C is select ROWID from IGS_ST_DFT_LOAD_APPO

403: X_PERCENTAGE in NUMBER,
404: X_SECOND_PERCENTAGE in NUMBER,
405: X_MODE in VARCHAR2 default 'R'
406: ) as
407: cursor C is select ROWID from IGS_ST_DFT_LOAD_APPO
408: where CAL_TYPE = X_CAL_TYPE
409: and CI_SEQUENCE_NUMBER = X_CI_SEQUENCE_NUMBER
410: and TEACH_CAL_TYPE = X_TEACH_CAL_TYPE;
411: X_LAST_UPDATE_DATE DATE;

Line 450: insert into IGS_ST_DFT_LOAD_APPO (

446: x_last_updated_by=>X_LAST_UPDATED_BY ,
447: x_last_update_login=> X_LAST_UPDATE_LOGIN
448: );
449:
450: insert into IGS_ST_DFT_LOAD_APPO (
451: CAL_TYPE,
452: CI_SEQUENCE_NUMBER,
453: TEACH_CAL_TYPE,
454: PERCENTAGE,

Line 500: from IGS_ST_DFT_LOAD_APPO

496: ) as
497: cursor c1 is select
498: PERCENTAGE,
499: SECOND_PERCENTAGE
500: from IGS_ST_DFT_LOAD_APPO
501: where ROWID = X_ROWID for update nowait;
502: tlinfo c1%rowtype;
503:
504: begin

Line 578: update IGS_ST_DFT_LOAD_APPO set

574: x_last_update_login=> X_LAST_UPDATE_LOGIN
575: );
576:
577:
578: update IGS_ST_DFT_LOAD_APPO set
579: PERCENTAGE = NEW_REFERENCES.PERCENTAGE,
580: SECOND_PERCENTAGE = NEW_REFERENCES.SECOND_PERCENTAGE,
581: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
582: LAST_UPDATED_BY = X_LAST_UPDATED_BY,

Line 607: cursor c1 is select rowid from IGS_ST_DFT_LOAD_APPO

603: X_PERCENTAGE in NUMBER,
604: X_SECOND_PERCENTAGE in NUMBER,
605: X_MODE in VARCHAR2 default 'R'
606: ) as
607: cursor c1 is select rowid from IGS_ST_DFT_LOAD_APPO
608: where CAL_TYPE = X_CAL_TYPE
609: and CI_SEQUENCE_NUMBER = X_CI_SEQUENCE_NUMBER
610: and TEACH_CAL_TYPE = X_TEACH_CAL_TYPE
611: ;

Line 649: delete from IGS_ST_DFT_LOAD_APPO

645: p_action=>'DELETE',
646: x_rowid=> X_ROWID
647: );
648:
649: delete from IGS_ST_DFT_LOAD_APPO
650: where ROWID = X_ROWID;
651: if (sql%notfound) then
652: raise no_data_found;
653: end if;

Line 664: end IGS_ST_DFT_LOAD_APPO_PKG;

660:
661:
662: end DELETE_ROW;
663:
664: end IGS_ST_DFT_LOAD_APPO_PKG;