The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT 'A' FROM IGS_AD_TRANSCRIPT_V TRANS WHERE EDUCATION_ID = cp_education_id
AND DATE_OF_ISSUE = cp_date_of_issue
AND (new_references.transcript_id IS NULL OR new_references.transcript_id <> trans.transcript_id);
SELECT DISTINCT 1
FROM igs_ad_acad_history_v hist
WHERE hist.education_id = cp_education_id
AND hist.status = 'I';
x_last_update_date IN DATE DEFAULT NULL,
x_last_updated_by IN NUMBER DEFAULT NULL,
x_last_update_login IN NUMBER DEFAULT NULL ,
x_override IN VARCHAR2 DEFAULT NULL,
x_override_id IN NUMBER DEFAULT NULL,
x_override_date IN DATE DEFAULT NULL,
X_DATE_OF_ISSUE IN DATE DEFAULT NULL,
-- Added for new field Ravishar / 14-sep-2004
x_CORE_CURRICULUM_VALUE IN VARCHAR2 DEFAULT NULL
) AS
/*************************************************************
Created By : Kamalakar N.
Date Created By : 15/May/2000
Purpose :
Know limitations, enhancements or remarks
Change History
Who When What
(reverse chronological order - newest change first)
vdixit.in 23-JULY-2001 Added new column transcript_type
to the tbh calls
rboddu 12-NOV-2001 Added new columns oevrride,
override_id and override_date.
End Bug No : 2097333
***************************************************************/
CURSOR cur_old_ref_values IS
SELECT *
FROM IGS_AD_TRANSCRIPT
WHERE rowid = x_rowid;
IF (cur_old_ref_values%NOTFOUND) AND (p_action NOT IN ('INSERT','VALIDATE_INSERT')) THEN
Close cur_old_ref_values;
Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
IF (p_action = 'UPDATE') THEN
new_references.creation_date := old_references.creation_date;
new_references.last_update_date := x_last_update_date;
new_references.last_updated_by := x_last_updated_by;
new_references.last_update_login := x_last_update_login;
Fnd_Message.Set_Name ('FND','FORM_RECORD_DELETED');
SELECT rowid
FROM igs_ad_transcript
WHERE transcript_id = x_transcript_id
FOR UPDATE NOWAIT;
SELECT rowid
FROM igs_ad_transcript
WHERE education_id = x_education_id ;
SELECT rowid
FROM igs_ad_transcript
WHERE conv_gs_id = x_code_id ;
SELECT rowid
FROM igs_ad_transcript
WHERE transcript_source = x_code_id ;
SELECT rowid
FROM igs_ad_transcript
WHERE entered_gs_id = x_code_id ;
x_last_update_date IN DATE DEFAULT NULL,
x_last_updated_by IN NUMBER DEFAULT NULL,
x_last_update_login IN NUMBER DEFAULT NULL,
x_override IN VARCHAR2 DEFAULT NULL,
x_override_id IN NUMBER DEFAULT NULL,
x_override_date IN DATE DEFAULT NULL,
X_DATE_OF_ISSUE IN DATE DEFAULT NULL,
-- Added for new field Ravishar / 14-sep-2004
x_CORE_CURRICULUM_VALUE IN VARCHAR2 DEFAULT NULL
) AS
/*************************************************************
Created By : Kamalakar N.
Date Created By : 15/May/2000
Purpose :
Know limitations, enhancements or remarks
Change History
Who When What
(reverse chronological order - newest change first)
vdixit.in 23-JULY-2001 Added new column transcript_type
to the tbh calls
rboddu 12-NOV-2001 Added the new columns override,
override_id and override_date
Bug No: 2097333
***************************************************************/
BEGIN
Set_Column_Values (
p_action,
x_rowid,
x_quintile_rank,
x_percentile_rank,
x_transcript_id,
x_education_id,
x_transcript_status,
x_transcript_source,
x_date_of_receipt,
x_entered_gpa,
x_entered_gs_id,
x_conv_gpa,
x_conv_gs_id,
x_term_type,
x_rank_in_class,
x_class_size,
x_approximate_rank,
x_weighted_rank,
x_decile_rank,
x_quartile_rank,
x_transcript_type,
x_creation_date,
x_created_by,
x_last_update_date,
x_last_updated_by,
x_last_update_login,
x_override,
x_override_id,
x_override_date,
x_date_of_issue,
-- Added for new field Ravishar / 14-sep-2004
x_core_curriculum_value
);
IF (p_action = 'INSERT') THEN
-- Call all the procedures related to Before Insert.
Null;
ELSIF (p_action = 'UPDATE') THEN
-- Call all the procedures related to Before Update.
Null;
ELSIF (p_action = 'DELETE') THEN
-- Call all the procedures related to Before Delete.
Null;
ELSIF (p_action = 'VALIDATE_INSERT') THEN
-- Call all the procedures related to Before Insert.
IF Get_PK_For_Validation (
new_references.transcript_id) THEN
Fnd_Message.Set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
ELSIF (p_action = 'VALIDATE_UPDATE') THEN
Check_Constraints;
ELSIF (p_action = 'VALIDATE_DELETE') THEN
Check_Child_Existance;
SELECT party_id person_id
FROM HZ_EDUCATION
WHERE education_id = p_education_id;
IF (p_action = 'INSERT') THEN
-- Call all the procedures related to After Insert.
IF IGS_AD_TRANSCRIPT_PKG.TRN_CRT_MODE = 'NI' THEN
OPEN c_person_id(new_references.education_id);
ELSIF (p_action = 'UPDATE') THEN
-- Call all the procedures related to After Update. desc
--Raise the buisness event
OPEN c_person_id(new_references.education_id);
ELSIF (p_action = 'DELETE') THEN
-- Call all the procedures related to After Delete.
Null;
procedure INSERT_ROW (
X_ROWID in out NOCOPY VARCHAR2,
x_QUINTILE_RANK IN NUMBER,
x_PERCENTILE_RANK IN NUMBER,
x_TRANSCRIPT_ID IN OUT NOCOPY NUMBER,
x_EDUCATION_ID IN NUMBER,
x_TRANSCRIPT_STATUS IN VARCHAR2,
x_TRANSCRIPT_SOURCE IN NUMBER,
x_DATE_OF_RECEIPT IN DATE,
x_ENTERED_GPA IN VARCHAR2,
x_ENTERED_GS_ID IN NUMBER,
x_CONV_GPA IN VARCHAR2,
x_CONV_GS_ID IN NUMBER,
x_TERM_TYPE IN VARCHAR2,
x_RANK_IN_CLASS IN NUMBER,
x_CLASS_SIZE IN NUMBER,
x_APPROXIMATE_RANK IN VARCHAR2,
x_WEIGHTED_RANK IN VARCHAR2,
x_DECILE_RANK IN NUMBER,
x_QUARTILE_RANK IN NUMBER,
x_TRANSCRIPT_TYPE IN VARCHAR2 DEFAULT NULL,
X_MODE in VARCHAR2 DEFAULT NULL,
x_OVERRIDE IN VARCHAR2 DEFAULT NULL,
x_OVERRIDE_ID IN NUMBER DEFAULT NULL,
x_OVERRIDE_DATE IN DATE DEFAULT NULL,
X_DATE_OF_ISSUE IN DATE DEFAULT NULL,
-- Added for new field Ravishar / 14-sep-2004
x_CORE_CURRICULUM_VALUE IN VARCHAR2 DEFAULT NULL
) AS
/*************************************************************
Created By : Kamalakar N.
Date Created By : 15/May/2000
Purpose :
Know limitations, enhancements or remarks
Change History
Who When What
(reverse chronological order - newest change first)
vdixit.in 23-JULY-2001 Added new column transcript_type
to the tbh calls
rboddu 12-NOV-2001 Added the new columns override,
override_id and override_date
Bug No : 2097333
***************************************************************/
cursor C is select ROWID from IGS_AD_TRANSCRIPT
where TRANSCRIPT_ID= X_TRANSCRIPT_ID
;
X_LAST_UPDATE_DATE DATE ;
X_LAST_UPDATED_BY NUMBER ;
X_LAST_UPDATE_LOGIN NUMBER ;
X_PROGRAM_UPDATE_DATE DATE;
X_LAST_UPDATE_DATE := SYSDATE;
X_LAST_UPDATED_BY := 1;
X_LAST_UPDATE_LOGIN := 0;
X_LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
if X_LAST_UPDATED_BY is NULL then
X_LAST_UPDATED_BY := -1;
X_LAST_UPDATE_LOGIN :=FND_GLOBAL.LOGIN_ID;
if X_LAST_UPDATE_LOGIN is NULL then
X_LAST_UPDATE_LOGIN := -1;
X_PROGRAM_UPDATE_DATE := NULL;
X_PROGRAM_UPDATE_DATE := SYSDATE;
p_action=>'INSERT',
x_rowid=>X_ROWID,
x_quintile_rank=>X_QUINTILE_RANK,
x_percentile_rank=>X_PERCENTILE_RANK,
x_transcript_id=>X_TRANSCRIPT_ID,
x_education_id=>X_EDUCATION_ID,
x_transcript_status=>X_TRANSCRIPT_STATUS,
x_transcript_source=>X_TRANSCRIPT_SOURCE,
x_date_of_receipt=>X_DATE_OF_RECEIPT,
x_entered_gpa=>X_ENTERED_GPA,
x_entered_gs_id=>X_ENTERED_GS_ID,
x_conv_gpa=>X_CONV_GPA,
x_conv_gs_id=>X_CONV_GS_ID,
x_term_type=>X_TERM_TYPE,
x_rank_in_class=>X_RANK_IN_CLASS,
x_class_size=>X_CLASS_SIZE,
x_approximate_rank=>X_APPROXIMATE_RANK,
x_weighted_rank=>X_WEIGHTED_RANK,
x_decile_rank=>X_DECILE_RANK,
x_quartile_rank=>X_QUARTILE_RANK,
x_transcript_type=>X_TRANSCRIPT_TYPE,
x_creation_date=>X_LAST_UPDATE_DATE,
x_created_by=>X_LAST_UPDATED_BY,
x_last_update_date=>X_LAST_UPDATE_DATE,
x_last_updated_by=>X_LAST_UPDATED_BY,
x_last_update_login=>X_LAST_UPDATE_LOGIN,
x_override=>X_OVERRIDE,
x_override_id=>X_OVERRIDE_ID,
x_override_date=>X_OVERRIDE_DATE,
x_date_of_issue => x_date_of_issue,
-- Added for new field Ravishar / 14-sep-2004
x_core_curriculum_value => X_CORE_CURRICULUM_VALUE
);
SELECT IGS_AD_TRANSCRIPT_S.NEXTVAL INTO L_TRANSCRIPT_ID FROM DUAL;
insert into IGS_AD_TRANSCRIPT (
QUINTILE_RANK
,PERCENTILE_RANK
,TRANSCRIPT_ID
,EDUCATION_ID
,TRANSCRIPT_STATUS
,TRANSCRIPT_SOURCE
,DATE_OF_RECEIPT
,ENTERED_GPA
,ENTERED_GS_ID
,CONV_GPA
,CONV_GS_ID
,TERM_TYPE
,RANK_IN_CLASS
,CLASS_SIZE
,APPROXIMATE_RANK
,WEIGHTED_RANK
,DECILE_RANK
,QUARTILE_RANK
,TRANSCRIPT_TYPE
,OVERRIDE
,OVERRIDE_ID
,OVERRIDE_DATE
,DATE_OF_ISSUE
,CREATION_DATE
,CREATED_BY
,LAST_UPDATE_DATE
,LAST_UPDATED_BY
,LAST_UPDATE_LOGIN
,REQUEST_ID
,PROGRAM_ID
,PROGRAM_APPLICATION_ID
,PROGRAM_UPDATE_DATE,
-- Added for new field Ravishar / 14-sep-2004
core_curriculum_value
) values (
NEW_REFERENCES.QUINTILE_RANK
,NEW_REFERENCES.PERCENTILE_RANK
,L_TRANSCRIPT_ID --IGS_AD_TRANSCRIPT_S.NEXTVAL
,NEW_REFERENCES.EDUCATION_ID
,NEW_REFERENCES.TRANSCRIPT_STATUS
,NEW_REFERENCES.TRANSCRIPT_SOURCE
,NEW_REFERENCES.DATE_OF_RECEIPT
,NEW_REFERENCES.ENTERED_GPA
,NEW_REFERENCES.ENTERED_GS_ID
,NEW_REFERENCES.CONV_GPA
,NEW_REFERENCES.CONV_GS_ID
,NEW_REFERENCES.TERM_TYPE
,NEW_REFERENCES.RANK_IN_CLASS
,NEW_REFERENCES.CLASS_SIZE
,NEW_REFERENCES.APPROXIMATE_RANK
,NEW_REFERENCES.WEIGHTED_RANK
,NEW_REFERENCES.DECILE_RANK
,NEW_REFERENCES.QUARTILE_RANK
,NEW_REFERENCES.TRANSCRIPT_TYPE
,NEW_REFERENCES.OVERRIDE
,NEW_REFERENCES.OVERRIDE_ID
,NEW_REFERENCES.OVERRIDE_DATE
,NEW_REFERENCES.DATE_OF_ISSUE
,X_LAST_UPDATE_DATE
,X_LAST_UPDATED_BY
,X_LAST_UPDATE_DATE
,X_LAST_UPDATED_BY
,X_LAST_UPDATE_LOGIN
,X_REQUEST_ID
,X_PROGRAM_ID
,X_PROGRAM_APPLICATION_ID
,X_PROGRAM_UPDATE_DATE
-- Added for new field Ravishar / 14-sep-2004
,NEW_REFERENCES.CORE_CURRICULUM_VALUE
)RETURNING TRANSCRIPT_ID INTO X_TRANSCRIPT_ID;
p_action => 'INSERT' ,
x_rowid => X_ROWID );
end INSERT_ROW;
cursor c1 is select
QUINTILE_RANK
, PERCENTILE_RANK
, EDUCATION_ID
, TRANSCRIPT_STATUS
, TRANSCRIPT_SOURCE
, DATE_OF_RECEIPT
, ENTERED_GPA
, ENTERED_GS_ID
, CONV_GPA
, CONV_GS_ID
, TERM_TYPE
, RANK_IN_CLASS
, CLASS_SIZE
, APPROXIMATE_RANK
, WEIGHTED_RANK
, DECILE_RANK
, QUARTILE_RANK
, TRANSCRIPT_TYPE
, OVERRIDE
, OVERRIDE_ID
, OVERRIDE_DATE
, DATE_OF_ISSUE
-- Added for new field Ravishar / 14-sep-2004
, CORE_CURRICULUM_VALUE
from IGS_AD_TRANSCRIPT
where ROWID = X_ROWID
for update nowait;
fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
Procedure UPDATE_ROW (
X_ROWID in VARCHAR2,
x_QUINTILE_RANK IN NUMBER,
x_PERCENTILE_RANK IN NUMBER,
x_TRANSCRIPT_ID IN NUMBER,
x_EDUCATION_ID IN NUMBER,
x_TRANSCRIPT_STATUS IN VARCHAR2,
x_TRANSCRIPT_SOURCE IN NUMBER,
x_DATE_OF_RECEIPT IN DATE,
x_ENTERED_GPA IN VARCHAR2,
x_ENTERED_GS_ID IN NUMBER,
x_CONV_GPA IN VARCHAR2,
x_CONV_GS_ID IN NUMBER,
x_TERM_TYPE IN VARCHAR2,
x_RANK_IN_CLASS IN NUMBER,
x_CLASS_SIZE IN NUMBER,
x_APPROXIMATE_RANK IN VARCHAR2,
x_WEIGHTED_RANK IN VARCHAR2,
x_DECILE_RANK IN NUMBER,
x_QUARTILE_RANK IN NUMBER,
x_TRANSCRIPT_TYPE IN VARCHAR2 DEFAULT NULL,
X_MODE in VARCHAR2 DEFAULT NULL,
x_OVERRIDE IN VARCHAR2 DEFAULT NULL,
x_OVERRIDE_ID IN NUMBER DEFAULT NULL,
x_OVERRIDE_DATE IN DATE DEFAULT NULL,
X_DATE_OF_ISSUE IN DATE DEFAULT NULL,
-- Added for new field Ravishar / 14-sep-2004
x_CORE_CURRICULUM_VALUE IN VARCHAR2 DEFAULT NULL
) AS
/*************************************************************
Created By : Kamalakar N.
Date Created By : 15/May/2000
Purpose :
Know limitations, enhancements or remarks
Change History
Who When What
(reverse chronological order - newest change first)
vdixit.in 23-JULY-2001 Added new column transcript_type
to the tbh calls
rboddu 12-NOV-2001 Added the new columns override,
override_id and override_date
Bug No : 2097333
***************************************************************/
X_LAST_UPDATE_DATE DATE ;
X_LAST_UPDATED_BY NUMBER ;
X_LAST_UPDATE_LOGIN NUMBER ;
X_PROGRAM_UPDATE_DATE DATE;
X_LAST_UPDATE_DATE := SYSDATE;
X_LAST_UPDATED_BY := 1;
X_LAST_UPDATE_LOGIN := 0;
X_LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
if X_LAST_UPDATED_BY is NULL then
X_LAST_UPDATED_BY := -1;
X_LAST_UPDATE_LOGIN :=FND_GLOBAL.LOGIN_ID;
if X_LAST_UPDATE_LOGIN is NULL then
X_LAST_UPDATE_LOGIN := -1;
p_action=>'UPDATE',
x_rowid=>X_ROWID,
x_quintile_rank=>X_QUINTILE_RANK,
x_percentile_rank=>X_PERCENTILE_RANK,
x_transcript_id=>X_TRANSCRIPT_ID,
x_education_id=>X_EDUCATION_ID,
x_transcript_status=>X_TRANSCRIPT_STATUS,
x_transcript_source=>X_TRANSCRIPT_SOURCE,
x_date_of_receipt=>X_DATE_OF_RECEIPT,
x_entered_gpa=>X_ENTERED_GPA,
x_entered_gs_id=>X_ENTERED_GS_ID,
x_conv_gpa=>X_CONV_GPA,
x_conv_gs_id=>X_CONV_GS_ID,
x_term_type=>X_TERM_TYPE,
x_rank_in_class=>X_RANK_IN_CLASS,
x_class_size=>X_CLASS_SIZE,
x_approximate_rank=>X_APPROXIMATE_RANK,
x_weighted_rank=>X_WEIGHTED_RANK,
x_decile_rank=>X_DECILE_RANK,
x_quartile_rank=>X_QUARTILE_RANK,
x_transcript_type=>X_TRANSCRIPT_TYPE,
x_creation_date=>X_LAST_UPDATE_DATE,
x_created_by=>X_LAST_UPDATED_BY,
x_last_update_date=>X_LAST_UPDATE_DATE,
x_last_updated_by=>X_LAST_UPDATED_BY,
x_last_update_login=>X_LAST_UPDATE_LOGIN,
x_override=>X_OVERRIDE,
x_override_id=>X_OVERRIDE_ID,
x_override_date=>X_OVERRIDE_DATE,
x_date_of_issue => x_date_of_issue,
-- Added for new field Ravishar / 14-sep-2004
x_core_curriculum_value => X_CORE_CURRICULUM_VALUE
);
X_PROGRAM_UPDATE_DATE := OLD_REFERENCES.PROGRAM_UPDATE_DATE;
X_PROGRAM_UPDATE_DATE := SYSDATE;
update IGS_AD_TRANSCRIPT set
QUINTILE_RANK = NEW_REFERENCES.QUINTILE_RANK,
PERCENTILE_RANK = NEW_REFERENCES.PERCENTILE_RANK,
EDUCATION_ID = NEW_REFERENCES.EDUCATION_ID,
TRANSCRIPT_STATUS = NEW_REFERENCES.TRANSCRIPT_STATUS,
TRANSCRIPT_SOURCE = NEW_REFERENCES.TRANSCRIPT_SOURCE,
DATE_OF_RECEIPT = NEW_REFERENCES.DATE_OF_RECEIPT,
ENTERED_GPA = NEW_REFERENCES.ENTERED_GPA,
ENTERED_GS_ID = NEW_REFERENCES.ENTERED_GS_ID,
CONV_GPA = NEW_REFERENCES.CONV_GPA,
CONV_GS_ID = NEW_REFERENCES.CONV_GS_ID,
TERM_TYPE = NEW_REFERENCES.TERM_TYPE,
RANK_IN_CLASS = NEW_REFERENCES.RANK_IN_CLASS,
CLASS_SIZE = NEW_REFERENCES.CLASS_SIZE,
APPROXIMATE_RANK = NEW_REFERENCES.APPROXIMATE_RANK,
WEIGHTED_RANK = NEW_REFERENCES.WEIGHTED_RANK,
DECILE_RANK = NEW_REFERENCES.DECILE_RANK,
QUARTILE_RANK = NEW_REFERENCES.QUARTILE_RANK,
TRANSCRIPT_TYPE = NEW_REFERENCES.TRANSCRIPT_TYPE,
OVERRIDE = NEW_REFERENCES.OVERRIDE,
OVERRIDE_ID = NEW_REFERENCES.OVERRIDE_ID,
OVERRIDE_DATE = NEW_REFERENCES.OVERRIDE_DATE,
DATE_OF_ISSUE = NEW_REFERENCES.DATE_OF_ISSUE,
LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
LAST_UPDATED_BY = X_LAST_UPDATED_BY,
LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN
, REQUEST_ID = X_REQUEST_ID,
PROGRAM_ID = X_PROGRAM_ID,
PROGRAM_APPLICATION_ID = PROGRAM_APPLICATION_ID,
PROGRAM_UPDATE_DATE = X_PROGRAM_UPDATE_DATE,
-- Added for new field Ravishar / 14-sep-2004
CORE_CURRICULUM_VALUE = X_CORE_CURRICULUM_VALUE
where ROWID = X_ROWID;
p_action => 'UPDATE' ,
x_rowid => X_ROWID
);
end UPDATE_ROW;
cursor c1 is select ROWID from IGS_AD_TRANSCRIPT
where TRANSCRIPT_ID= X_TRANSCRIPT_ID
;
INSERT_ROW (
X_ROWID,
X_QUINTILE_RANK,
X_PERCENTILE_RANK,
X_TRANSCRIPT_ID,
X_EDUCATION_ID,
X_TRANSCRIPT_STATUS,
X_TRANSCRIPT_SOURCE,
X_DATE_OF_RECEIPT,
X_ENTERED_GPA,
X_ENTERED_GS_ID,
X_CONV_GPA,
X_CONV_GS_ID,
X_TERM_TYPE,
X_RANK_IN_CLASS,
X_CLASS_SIZE,
X_APPROXIMATE_RANK,
X_WEIGHTED_RANK,
X_DECILE_RANK,
X_QUARTILE_RANK,
X_TRANSCRIPT_TYPE,
L_MODE,
X_OVERRIDE,
X_OVERRIDE_ID,
X_OVERRIDE_DATE,
X_DATE_OF_ISSUE,
-- Added for new field Ravishar / 14-sep-2004
X_CORE_CURRICULUM_VALUE
);
UPDATE_ROW (
X_ROWID,
X_QUINTILE_RANK,
X_PERCENTILE_RANK,
X_TRANSCRIPT_ID,
X_EDUCATION_ID,
X_TRANSCRIPT_STATUS,
X_TRANSCRIPT_SOURCE,
X_DATE_OF_RECEIPT,
X_ENTERED_GPA,
X_ENTERED_GS_ID,
X_CONV_GPA,
X_CONV_GS_ID,
X_TERM_TYPE,
X_RANK_IN_CLASS,
X_CLASS_SIZE,
X_APPROXIMATE_RANK,
X_WEIGHTED_RANK,
X_DECILE_RANK,
X_QUARTILE_RANK,
X_TRANSCRIPT_TYPE,
L_MODE,
X_OVERRIDE,
X_OVERRIDE_ID,
X_OVERRIDE_DATE,
X_DATE_OF_ISSUE,
-- Added for new field Ravishar / 14-sep-2004
X_CORE_CURRICULUM_VALUE
);
procedure DELETE_ROW (
X_ROWID in VARCHAR2,
x_mode IN VARCHAR2
) AS
/*************************************************************
Created By : Kamalakar N.
Date Created By : 15/May/2000
Purpose :
Know limitations, enhancements or remarks
Change History
Who When What
(reverse chronological order - newest change first)
***************************************************************/
begin
Before_DML (
p_action => 'DELETE',
x_rowid => X_ROWID
);
delete from IGS_AD_TRANSCRIPT
where ROWID = X_ROWID;
p_action => 'DELETE',
x_rowid => X_ROWID
);
end DELETE_ROW;