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_AD_ADM_UT_STT_LD_PKG dependencies on IGS_AD_ADM_UT_STT_LD

Line 1: package body IGS_AD_ADM_UT_STT_LD_PKG as

1: package body IGS_AD_ADM_UT_STT_LD_PKG as
2: /* $Header: IGSAI03B.pls 115.7 2003/10/30 13:18:43 rghosh ship $ */
3: l_rowid VARCHAR2(25);
4: old_references IGS_AD_ADM_UT_STT_LD%RowType;
5: new_references IGS_AD_ADM_UT_STT_LD%RowType;

Line 4: old_references IGS_AD_ADM_UT_STT_LD%RowType;

1: package body IGS_AD_ADM_UT_STT_LD_PKG as
2: /* $Header: IGSAI03B.pls 115.7 2003/10/30 13:18:43 rghosh ship $ */
3: l_rowid VARCHAR2(25);
4: old_references IGS_AD_ADM_UT_STT_LD%RowType;
5: new_references IGS_AD_ADM_UT_STT_LD%RowType;
6:
7: PROCEDURE Set_Column_Values (
8: p_action IN VARCHAR2,

Line 5: new_references IGS_AD_ADM_UT_STT_LD%RowType;

1: package body IGS_AD_ADM_UT_STT_LD_PKG as
2: /* $Header: IGSAI03B.pls 115.7 2003/10/30 13:18:43 rghosh ship $ */
3: l_rowid VARCHAR2(25);
4: old_references IGS_AD_ADM_UT_STT_LD%RowType;
5: new_references IGS_AD_ADM_UT_STT_LD%RowType;
6:
7: PROCEDURE Set_Column_Values (
8: p_action IN VARCHAR2,
9: x_rowid IN VARCHAR2 DEFAULT NULL,

Line 24: FROM IGS_AD_ADM_UT_STT_LD

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

Line 65: -- BEFORE INSERT OR UPDATE OR DELETE ON IGS_AD_ADM_UT_STT_LD

61: END Set_Column_Values;
62:
63: -- Trigger description :-
64: -- "OSS_TST".TRG_AUSL_BR_IUD
65: -- BEFORE INSERT OR UPDATE OR DELETE ON IGS_AD_ADM_UT_STT_LD
66: -- REFERENCING
67: -- NEW AS NEW
68: -- OLD AS OLD
69: -- FOR EACH ROW

Line 77: v_cal_type IGS_AD_ADM_UT_STT_LD.cal_type%TYPE;

73: p_updating IN BOOLEAN DEFAULT FALSE,
74: p_deleting IN BOOLEAN DEFAULT FALSE
75: ) IS
76: v_message_name VARCHAR2(30);
77: v_cal_type IGS_AD_ADM_UT_STT_LD.cal_type%TYPE;
78: v_ci_sequence_number IGS_AD_ADM_UT_STT_LD.ci_sequence_number%TYPE;
79: BEGIN
80: IF p_inserting OR p_updating THEN
81: v_cal_type := new_references.cal_type;

Line 78: v_ci_sequence_number IGS_AD_ADM_UT_STT_LD.ci_sequence_number%TYPE;

74: p_deleting IN BOOLEAN DEFAULT FALSE
75: ) IS
76: v_message_name VARCHAR2(30);
77: v_cal_type IGS_AD_ADM_UT_STT_LD.cal_type%TYPE;
78: v_ci_sequence_number IGS_AD_ADM_UT_STT_LD.ci_sequence_number%TYPE;
79: BEGIN
80: IF p_inserting OR p_updating THEN
81: v_cal_type := new_references.cal_type;
82: v_ci_sequence_number := new_references.ci_sequence_number;

Line 217: FROM IGS_AD_ADM_UT_STT_LD

213: x_teach_cal_type IN VARCHAR2) RETURN BOOLEAN AS
214:
215: CURSOR cur_rowid IS
216: SELECT rowid
217: FROM IGS_AD_ADM_UT_STT_LD
218: WHERE administrative_unit_status = x_administrative_unit_status
219: AND cal_type = x_cal_type
220: AND ci_sequence_number = x_ci_sequence_number
221: AND teach_cal_type = x_teach_cal_type

Line 248: FROM IGS_AD_ADM_UT_STT_LD

244: ) IS
245:
246: CURSOR cur_rowid IS
247: SELECT rowid
248: FROM IGS_AD_ADM_UT_STT_LD
249: WHERE cal_type = x_cal_type
250: AND ci_sequence_number = x_ci_sequence_number
251: AND teach_cal_type = x_teach_cal_type ;
252:

Line 365: cursor C is select ROWID from IGS_AD_ADM_UT_STT_LD

361: X_TEACH_CAL_TYPE in VARCHAR2,
362: X_LOAD_INCURRED_IND in VARCHAR2,
363: X_MODE in VARCHAR2 default 'R'
364: ) is
365: cursor C is select ROWID from IGS_AD_ADM_UT_STT_LD
366: where ADMINISTRATIVE_UNIT_STATUS = X_ADMINISTRATIVE_UNIT_STATUS
367: and CAL_TYPE = X_CAL_TYPE
368: and CI_SEQUENCE_NUMBER = X_CI_SEQUENCE_NUMBER
369: and TEACH_CAL_TYPE = X_TEACH_CAL_TYPE;

Line 407: insert into IGS_AD_ADM_UT_STT_LD (

403: x_last_update_date => X_LAST_UPDATE_DATE,
404: x_last_updated_by => X_LAST_UPDATED_BY,
405: x_last_update_login => X_LAST_UPDATE_LOGIN
406: );
407: insert into IGS_AD_ADM_UT_STT_LD (
408: ADMINISTRATIVE_UNIT_STATUS,
409: CAL_TYPE,
410: CI_SEQUENCE_NUMBER,
411: TEACH_CAL_TYPE,

Line 454: from IGS_AD_ADM_UT_STT_LD

450: X_LOAD_INCURRED_IND in VARCHAR2
451: ) is
452: cursor c1 is select
453: LOAD_INCURRED_IND
454: from IGS_AD_ADM_UT_STT_LD
455: where ROWID = X_ROWID
456: for update nowait;
457: tlinfo c1%rowtype;
458:

Line 527: update IGS_AD_ADM_UT_STT_LD set

523: x_last_updated_by => X_LAST_UPDATED_BY,
524: x_last_update_login => X_LAST_UPDATE_LOGIN
525: );
526:
527: update IGS_AD_ADM_UT_STT_LD set
528: LOAD_INCURRED_IND = NEW_REFERENCES.LOAD_INCURRED_IND,
529: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
530: LAST_UPDATED_BY = X_LAST_UPDATED_BY,
531: LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN

Line 552: cursor c1 is select rowid from IGS_AD_ADM_UT_STT_LD

548: X_TEACH_CAL_TYPE in VARCHAR2,
549: X_LOAD_INCURRED_IND in VARCHAR2,
550: X_MODE in VARCHAR2 default 'R'
551: ) is
552: cursor c1 is select rowid from IGS_AD_ADM_UT_STT_LD
553: where ADMINISTRATIVE_UNIT_STATUS = X_ADMINISTRATIVE_UNIT_STATUS
554: and CAL_TYPE = X_CAL_TYPE
555: and CI_SEQUENCE_NUMBER = X_CI_SEQUENCE_NUMBER
556: and TEACH_CAL_TYPE = X_TEACH_CAL_TYPE ;

Line 592: delete from IGS_AD_ADM_UT_STT_LD

588: Before_DML (
589: p_action => 'DELETE',
590: x_rowid => X_ROWID
591: );
592: delete from IGS_AD_ADM_UT_STT_LD
593: where ROWID = X_ROWID;
594: if (sql%notfound) then
595: raise no_data_found;
596: end if;

Line 603: end IGS_AD_ADM_UT_STT_LD_PKG;

599: x_rowid => X_ROWID
600: );
601: end DELETE_ROW;
602:
603: end IGS_AD_ADM_UT_STT_LD_PKG;