The following lines contain the word 'select', 'insert', 'update' or 'delete':
x_last_update_date IN DATE,
x_last_updated_by IN NUMBER,
x_last_update_login IN NUMBER,
x_reversal_gl_date IN DATE,
x_tax_year_code IN VARCHAR2,
x_waiver_name IN VARCHAR2
) AS
/*************************************************************
Created By :
Date Created By :
Purpose :
Know limitations, enhancements or remarks
Change History
Who When What
skharida 26-Jun-2006 Bug# 5208136 - Removed the obsoleted columns from the table IGS_FI_INV_INT_ALL
pathipat 30-Jun-2003 Bug: 3026125 - Waiver flag inserted as NULL for Ancillary Charges
Added NVL clause for waiver_flag value
shtatiko 11-MAR2003 Bug# 2734441, Added TRUNC call before assigning the value of
x_invoice_creation_date.
smadathi 06-Nov-2002 Enh. Bug 2584986. Added new column reversal_gl_date
vvutukur 17-Sep-2002 Enh#2564643.Removed references to column subaccount_id.Also removed
DEFAULT clause from procedure parameters to avoid gscc warnings.
masehgal 10-JAN-2002 Enh # 2170429
Obsoletion of SPONSOR_CD
smadathi 05-oct-2001 Balance Flag reference removed .
Enhancement Bug No. 2030448
(reverse chronological order - newest change first)
***************************************************************/
CURSOR cur_old_ref_values IS
SELECT *
FROM IGS_FI_INV_INT_ALL
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;
SELECT rowid
FROM igs_fi_inv_int_all
WHERE invoice_id = x_invoice_id
FOR UPDATE NOWAIT;
Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
Fnd_Message.Set_Name ('FND','FORM_RECORD_DELETED');
Fnd_Message.Set_Name ('FND','FORM_RECORD_DELETED');
fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
Fnd_Message.Set_Name ('FND','FORM_RECORD_DELETED');
PROCEDURE beforeRowInsertUpdateDelete( p_inserting IN BOOLEAN DEFAULT FALSE,
p_updating IN BOOLEAN DEFAULT FALSE,
p_deleting IN BOOLEAN DEFAULT FALSE
) AS
/*
|| Created By : vvutukur
|| Created On : 19-NOV-2003
|| Purpose : To carryout the actions before insert/update/delete a record in igs_fi_inv_int_all table.
|| Created as part of bugfix#3249288.
|| Known limitations, enhancements or remarks :
|| Change History :
|| Who When What
|| (reverse chronological order - newest change first)
*/
--Cursor to fetch the value of Optional Payment Indicator value from Fee Type Setup.
CURSOR c_igs_fi_fee_type(cp_v_fee_type igs_fi_fee_type.fee_type%TYPE) IS
SELECT ft.optional_payment_ind
FROM igs_fi_fee_type ft
WHERE ft.fee_type = cp_v_fee_type;
IF (p_inserting) THEN
-- Based on the optional payment indicator value set in the fee type
-- set up form, the value of the OPTIONAL_FEE_FLAG column in the charges table
-- will be set as either 'O' or 'N'. For all charges created with a Non-optional
-- fee type, the value of OPTIONAL_FEE_FLAG column in the charges table will be
-- assigned as 'N'.For all charges created with an optional
-- fee type, the value of OPTIONAL_FEE_FLAG column in the charges table will be
-- assigned as 'O'.
OPEN c_igs_fi_fee_type(new_references.fee_type);
END beforeRowInsertUpdateDelete;
SELECT rowid
FROM igs_fi_bill_trnsctns
WHERE ((bill_id = x_bill_id));
x_last_update_date IN DATE,
x_last_updated_by IN NUMBER,
x_last_update_login IN NUMBER,
x_reversal_gl_date IN DATE,
x_tax_year_code IN VARCHAR2,
x_waiver_name IN VARCHAR2
) AS
/*************************************************************
Created By :
Date Created By :
Purpose :
Know limitations, enhancements or remarks
Change History
Who When What
vvutukur 19-Nov-2003 Bug#3249288.Added call to newly created procedure beforeRowInsertUpdateDelete.
smadathi 05-oct-2002 Enh. Bug 2584986. Added new column reversal_gl_date
vvutukur 17-Sep-2002 Enh#2564643.Removed references to column subaccount_id.Also removed
DEFAULT clause from parameter list to avoid gscc warnings.
maseghal 10-JAN-2002 Enh # 2170429
Obsoletion of SPONSOR_CD
smadathi 05-oct-2001 Balance Flag reference removed .
Enhancement Bug No. 2030448
(reverse chronological order - newest change first)
***************************************************************/
BEGIN
Set_Column_Values (
p_action,
x_rowid,
x_invoice_id,
x_person_id,
x_fee_type,
x_fee_cat,
x_fee_cal_type,
x_fee_ci_sequence_number,
x_course_cd,
x_attendance_mode,
x_attendance_type,
x_invoice_amount_due,
x_invoice_creation_date,
x_invoice_desc,
x_transaction_type,
x_currency_cd,
x_status,
x_attribute_category,
x_attribute1,
x_attribute2,
x_attribute3,
x_attribute4,
x_attribute5,
x_attribute6,
x_attribute7,
x_attribute8,
x_attribute9,
x_attribute10,
x_org_id,
x_invoice_amount,
x_bill_id,
x_bill_number,
x_bill_date,
x_waiver_flag,
x_waiver_reason,
x_effective_date,
x_invoice_number,
x_exchange_rate,
x_bill_payment_due_date,
x_optional_fee_flag,
x_creation_date,
x_created_by,
x_last_update_date,
x_last_updated_by,
x_last_update_login,
x_reversal_gl_date,
x_tax_year_code,
x_waiver_name
);
IF (p_action = 'INSERT') THEN
-- Call all the procedures related to Before Insert.
Null;
beforeRowInsertUpdateDelete(p_inserting => TRUE);
ELSIF (p_action = 'UPDATE') THEN
-- Call all the procedures related to Before Update.
Check_Constraints;
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.invoice_id) THEN
Fnd_Message.Set_name('IGS','IGS_GE_MULTI_ORG_DUP_REC');
ELSIF (p_action = 'VALIDATE_UPDATE') THEN
Check_Constraints;
ELSIF (p_action = 'VALIDATE_DELETE') THEN
Null;
IF (p_action = 'INSERT') THEN
-- Call all the procedures related to After Insert.
Null;
ELSIF (p_action = 'UPDATE') THEN
-- Call all the procedures related to After Update.
Null;
ELSIF (p_action = 'DELETE') THEN
-- Call all the procedures related to After Delete.
Null;
procedure INSERT_ROW (
X_ROWID in out NOCOPY VARCHAR2,
x_INVOICE_ID IN OUT NOCOPY NUMBER,
x_PERSON_ID IN NUMBER,
x_FEE_TYPE IN VARCHAR2,
x_FEE_CAT IN VARCHAR2,
x_FEE_CAL_TYPE IN VARCHAR2,
x_FEE_CI_SEQUENCE_NUMBER IN NUMBER,
x_COURSE_CD IN VARCHAR2,
x_ATTENDANCE_MODE IN VARCHAR2,
x_ATTENDANCE_TYPE IN VARCHAR2,
x_INVOICE_AMOUNT_DUE IN NUMBER,
x_INVOICE_CREATION_DATE IN DATE,
x_INVOICE_DESC IN VARCHAR2,
x_TRANSACTION_TYPE IN VARCHAR2,
x_CURRENCY_CD IN VARCHAR2,
x_STATUS IN VARCHAR2,
x_ATTRIBUTE_CATEGORY IN VARCHAR2,
x_ATTRIBUTE1 IN VARCHAR2,
x_ATTRIBUTE2 IN VARCHAR2,
x_ATTRIBUTE3 IN VARCHAR2,
x_ATTRIBUTE4 IN VARCHAR2,
x_ATTRIBUTE5 IN VARCHAR2,
x_ATTRIBUTE6 IN VARCHAR2,
x_ATTRIBUTE7 IN VARCHAR2,
x_ATTRIBUTE8 IN VARCHAR2,
x_ATTRIBUTE9 IN VARCHAR2,
x_ATTRIBUTE10 IN VARCHAR2,
x_INVOICE_AMOUNT IN NUMBER,
x_BILL_ID IN NUMBER,
x_BILL_NUMBER IN VARCHAR2,
x_BILL_DATE IN DATE,
x_WAIVER_FLAG IN VARCHAR2,
x_WAIVER_REASON IN VARCHAR2,
x_EFFECTIVE_DATE IN DATE,
x_INVOICE_NUMBER IN VARCHAR2,
x_EXCHANGE_RATE IN NUMBER,
x_BILL_PAYMENT_DUE_DATE IN DATE,
x_ORG_ID IN NUMBER,
x_OPTIONAL_FEE_FLAG IN VARCHAR2,
X_MODE IN VARCHAR2,
X_REVERSAL_GL_DATE IN DATE,
x_tax_year_code IN VARCHAR2,
x_waiver_name IN VARCHAR2
) AS
/*************************************************************
Created By :
Date Created By :
Purpose :
Know limitations, enhancements or remarks
Change History
Who When What
skharida 26-Jun-2006 Bug# 5208136 - Removed the obsoleted columns from the table IGS_FI_INV_INT_ALL
smadathi 06-Nov-2002 Enh. Bug 2584986. Added new column
REVERSAL_GL_DATE
vvutukur 17-Sep-2002 Enh#2564643.Removed references to subaccount_id.Also removed DEFAULT
clause from package body to avoid gscc warnings.
masehgal 10-JAN-2002 Enh # 2170429
Obsoletion of SPONSOR_CD
smadathi 05-oct-2001 Balance Flag reference removed .
Enhancement Bug No. 2030448
(reverse chronological order - newest change first)
***************************************************************/
cursor C is select ROWID from IGS_FI_INV_INT_ALL
where INVOICE_ID= X_INVOICE_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;
SELECT
IGS_FI_INV_INT_S.nextval
INTO
x_invoice_id
FROM
dual;
p_action=>'INSERT',
x_rowid=>X_ROWID,
x_invoice_id=>X_INVOICE_ID,
x_person_id=>X_PERSON_ID,
x_fee_type=>X_FEE_TYPE,
x_fee_cat=>X_FEE_CAT,
x_fee_cal_type=>X_FEE_CAL_TYPE,
x_fee_ci_sequence_number=>X_FEE_CI_SEQUENCE_NUMBER,
x_course_cd=>X_COURSE_CD,
x_attendance_mode=>X_ATTENDANCE_MODE,
x_attendance_type=>X_ATTENDANCE_TYPE,
x_invoice_amount_due=>X_INVOICE_AMOUNT_DUE,
x_invoice_creation_date=>X_INVOICE_CREATION_DATE,
x_invoice_desc=>X_INVOICE_DESC,
x_transaction_type=>X_TRANSACTION_TYPE,
x_currency_cd=>X_CURRENCY_CD,
x_status=>X_STATUS,
x_attribute_category=>X_ATTRIBUTE_CATEGORY,
x_attribute1=>X_ATTRIBUTE1,
x_attribute2=>X_ATTRIBUTE2,
x_attribute3=>X_ATTRIBUTE3,
x_attribute4=>X_ATTRIBUTE4,
x_attribute5=>X_ATTRIBUTE5,
x_attribute6=>X_ATTRIBUTE6,
x_attribute7=>X_ATTRIBUTE7,
x_attribute8=>X_ATTRIBUTE8,
x_attribute9=>X_ATTRIBUTE9,
x_attribute10=>X_ATTRIBUTE10,
x_org_id=>igs_ge_gen_003.get_org_id,
x_invoice_amount => X_INVOICE_AMOUNT,
x_bill_id => X_BILL_ID,
x_bill_number => X_BILL_NUMBER ,
x_bill_date => X_BILL_DATE,
x_waiver_flag => X_WAIVER_FLAG,
x_waiver_reason => X_WAIVER_REASON,
x_effective_date => X_EFFECTIVE_DATE,
x_invoice_number => X_INVOICE_NUMBER ,
x_exchange_rate => X_EXCHANGE_RATE,
x_bill_payment_due_date => X_BILL_PAYMENT_DUE_DATE,
x_optional_fee_flag => X_OPTIONAL_FEE_FLAG,
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_reversal_gl_date => x_reversal_gl_date,
x_tax_year_code => x_tax_year_code,
x_waiver_name => x_waiver_name
);
insert into IGS_FI_INV_INT_ALL (
INVOICE_ID
,PERSON_ID
,FEE_TYPE
,FEE_CAT
,FEE_CAL_TYPE
,FEE_CI_SEQUENCE_NUMBER
,COURSE_CD
,ATTENDANCE_MODE
,ATTENDANCE_TYPE
,INVOICE_AMOUNT_DUE
,INVOICE_CREATION_DATE
,INVOICE_DESC
,TRANSACTION_TYPE
,CURRENCY_CD
,STATUS
,ATTRIBUTE_CATEGORY
,ATTRIBUTE1
,ATTRIBUTE2
,ATTRIBUTE3
,ATTRIBUTE4
,ATTRIBUTE5
,ATTRIBUTE6
,ATTRIBUTE7
,ATTRIBUTE8
,ATTRIBUTE9
,ATTRIBUTE10
,ORG_ID
,INVOICE_AMOUNT
,BILL_ID
,BILL_NUMBER
,BILL_DATE
,WAIVER_FLAG
,WAIVER_REASON
,EFFECTIVE_DATE
,INVOICE_NUMBER
,EXCHANGE_RATE
,BILL_PAYMENT_DUE_DATE
,OPTIONAL_FEE_FLAG
,REQUEST_ID
,PROGRAM_APPLICATION_ID
,PROGRAM_ID
,PROGRAM_UPDATE_DATE
,CREATION_DATE
,CREATED_BY
,LAST_UPDATE_DATE
,LAST_UPDATED_BY
,LAST_UPDATE_LOGIN
,REVERSAL_GL_DATE
,TAX_YEAR_CODE
,WAIVER_NAME
) values (
NEW_REFERENCES.INVOICE_ID
,NEW_REFERENCES.PERSON_ID
,NEW_REFERENCES.FEE_TYPE
,NEW_REFERENCES.FEE_CAT
,NEW_REFERENCES.FEE_CAL_TYPE
,NEW_REFERENCES.FEE_CI_SEQUENCE_NUMBER
,NEW_REFERENCES.COURSE_CD
,NEW_REFERENCES.ATTENDANCE_MODE
,NEW_REFERENCES.ATTENDANCE_TYPE
,NEW_REFERENCES.INVOICE_AMOUNT_DUE
,NEW_REFERENCES.INVOICE_CREATION_DATE
,NEW_REFERENCES.INVOICE_DESC
,NEW_REFERENCES.TRANSACTION_TYPE
,NEW_REFERENCES.CURRENCY_CD
,NEW_REFERENCES.STATUS
,NEW_REFERENCES.ATTRIBUTE_CATEGORY
,NEW_REFERENCES.ATTRIBUTE1
,NEW_REFERENCES.ATTRIBUTE2
,NEW_REFERENCES.ATTRIBUTE3
,NEW_REFERENCES.ATTRIBUTE4
,NEW_REFERENCES.ATTRIBUTE5
,NEW_REFERENCES.ATTRIBUTE6
,NEW_REFERENCES.ATTRIBUTE7
,NEW_REFERENCES.ATTRIBUTE8
,NEW_REFERENCES.ATTRIBUTE9
,NEW_REFERENCES.ATTRIBUTE10
,NEW_REFERENCES.ORG_ID
,NEW_REFERENCES.INVOICE_AMOUNT
,NEW_REFERENCES.BILL_ID
,NEW_REFERENCES.BILL_NUMBER
,NEW_REFERENCES.BILL_DATE
,NEW_REFERENCES.WAIVER_FLAG
,NEW_REFERENCES.WAIVER_REASON
,NEW_REFERENCES.EFFECTIVE_DATE
,NEW_REFERENCES.INVOICE_NUMBER
,NEW_REFERENCES.EXCHANGE_RATE
,NEW_REFERENCES.BILL_PAYMENT_DUE_DATE
,NEW_REFERENCES.OPTIONAL_FEE_FLAG
,X_REQUEST_ID
,X_PROGRAM_APPLICATION_ID
,X_PROGRAM_ID
,X_PROGRAM_UPDATE_DATE
,X_LAST_UPDATE_DATE
,X_LAST_UPDATED_BY
,X_LAST_UPDATE_DATE
,X_LAST_UPDATED_BY
,X_LAST_UPDATE_LOGIN
,new_references.reversal_gl_date
,new_references.tax_year_code
,new_references.waiver_name
);
p_action => 'INSERT' ,
x_rowid => X_ROWID );
end INSERT_ROW;
SELECT
person_id,
fee_type,
fee_cat,
fee_cal_type,
fee_ci_sequence_number,
course_cd,
attendance_mode,
attendance_type,
invoice_amount_due,
invoice_creation_date,
invoice_desc,
transaction_type,
currency_cd,
status,
attribute_category,
attribute1,
attribute2,
attribute3,
attribute4,
attribute5,
attribute6,
attribute7,
attribute8,
attribute9,
attribute10,
invoice_amount,
bill_id,
bill_number,
bill_date,
waiver_flag,
waiver_reason,
effective_date,
invoice_number,
exchange_rate,
bill_payment_due_date,
optional_fee_flag,
reversal_gl_date,
tax_year_code,
waiver_name
FROM igs_fi_inv_int_all
WHERE rowid = x_rowid
FOR UPDATE NOWAIT;
fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
Procedure UPDATE_ROW (
X_ROWID in VARCHAR2,
x_INVOICE_ID IN NUMBER,
x_PERSON_ID IN NUMBER,
x_FEE_TYPE IN VARCHAR2,
x_FEE_CAT IN VARCHAR2,
x_FEE_CAL_TYPE IN VARCHAR2,
x_FEE_CI_SEQUENCE_NUMBER IN NUMBER,
x_COURSE_CD IN VARCHAR2,
x_ATTENDANCE_MODE IN VARCHAR2,
x_ATTENDANCE_TYPE IN VARCHAR2,
x_INVOICE_AMOUNT_DUE IN NUMBER,
x_INVOICE_CREATION_DATE IN DATE,
x_INVOICE_DESC IN VARCHAR2,
x_TRANSACTION_TYPE IN VARCHAR2,
x_CURRENCY_CD IN VARCHAR2,
x_STATUS IN VARCHAR2,
x_ATTRIBUTE_CATEGORY IN VARCHAR2,
x_ATTRIBUTE1 IN VARCHAR2,
x_ATTRIBUTE2 IN VARCHAR2,
x_ATTRIBUTE3 IN VARCHAR2,
x_ATTRIBUTE4 IN VARCHAR2,
x_ATTRIBUTE5 IN VARCHAR2,
x_ATTRIBUTE6 IN VARCHAR2,
x_ATTRIBUTE7 IN VARCHAR2,
x_ATTRIBUTE8 IN VARCHAR2,
x_ATTRIBUTE9 IN VARCHAR2,
x_ATTRIBUTE10 IN VARCHAR2,
x_INVOICE_AMOUNT IN NUMBER,
x_BILL_ID IN NUMBER,
x_BILL_NUMBER IN VARCHAR2,
x_BILL_DATE IN DATE,
x_WAIVER_FLAG IN VARCHAR2,
x_WAIVER_REASON IN VARCHAR2,
x_EFFECTIVE_DATE IN DATE,
x_INVOICE_NUMBER IN VARCHAR2,
x_EXCHANGE_RATE IN NUMBER,
x_BILL_PAYMENT_DUE_DATE IN DATE,
x_OPTIONAL_FEE_FLAG IN VARCHAR2,
X_MODE IN VARCHAR2,
x_reversal_gl_date IN DATE,
x_tax_year_code IN VARCHAR2,
x_waiver_name IN VARCHAR2
) AS
/*************************************************************
Created By :
Date Created By :
Purpose :
Know limitations, enhancements or remarks
Change History
Who When What
skharida 26-Jun-2006 Bug# 5208136 - Removed the obsoleted columns from the table IGS_FI_INV_INT_ALL
smadathi 06-Nov-2002 Enh. Bug 2584986. Added new column REVERSAL_GL_DATE
vvutukur 17-Sep-2002 Enh#2564643.Removed references to column subaccount_id.Also removed
DEFAULT clause from procedure parameters to avoid gscc warnings.
masehgal 10-JAN-2002 Enh # 2170429
Obsoletion of SPONSOR_CD
smadathi 05-oct-2001 Balance Flag reference removed .
Enhancement Bug No. 2030448
(reverse chronological order - newest change first)
***************************************************************/
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:=OLD_REFERENCES.PROGRAM_UPDATE_DATE;
X_PROGRAM_UPDATE_DATE:=SYSDATE;
p_action =>'UPDATE',
x_rowid =>X_ROWID,
x_invoice_id =>X_INVOICE_ID,
x_person_id =>X_PERSON_ID,
x_fee_type =>X_FEE_TYPE,
x_fee_cat =>X_FEE_CAT,
x_fee_cal_type=>X_FEE_CAL_TYPE,
x_fee_ci_sequence_number=>X_FEE_CI_SEQUENCE_NUMBER,
x_course_cd =>X_COURSE_CD,
x_attendance_mode=>X_ATTENDANCE_MODE,
x_attendance_type=>X_ATTENDANCE_TYPE,
x_invoice_amount_due=>X_INVOICE_AMOUNT_DUE,
x_invoice_creation_date=>X_INVOICE_CREATION_DATE,
x_invoice_desc=>X_INVOICE_DESC,
x_transaction_type=>X_TRANSACTION_TYPE,
x_currency_cd=>X_CURRENCY_CD,
x_status=>X_STATUS,
x_attribute_category=>X_ATTRIBUTE_CATEGORY,
x_attribute1=>X_ATTRIBUTE1,
x_attribute2=>X_ATTRIBUTE2,
x_attribute3=>X_ATTRIBUTE3,
x_attribute4=>X_ATTRIBUTE4,
x_attribute5=>X_ATTRIBUTE5,
x_attribute6=>X_ATTRIBUTE6,
x_attribute7=>X_ATTRIBUTE7,
x_attribute8=>X_ATTRIBUTE8,
x_attribute9=>X_ATTRIBUTE9,
x_attribute10=>X_ATTRIBUTE10,
x_invoice_amount => X_INVOICE_AMOUNT,
x_bill_id => X_BILL_ID,
x_bill_number => X_BILL_NUMBER ,
x_bill_date => X_BILL_DATE,
x_waiver_flag => X_WAIVER_FLAG,
x_waiver_reason => X_WAIVER_REASON,
x_effective_date => X_EFFECTIVE_DATE,
x_invoice_number => X_INVOICE_NUMBER ,
x_exchange_rate => X_EXCHANGE_RATE,
x_bill_payment_due_date => X_BILL_PAYMENT_DUE_DATE,
x_optional_fee_flag => X_OPTIONAL_FEE_FLAG,
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_reversal_gl_date => x_reversal_gl_date,
x_tax_year_code => x_tax_year_code,
x_waiver_name => x_waiver_name
);
update IGS_FI_INV_INT_ALL set
PERSON_ID = NEW_REFERENCES.PERSON_ID,
FEE_TYPE = NEW_REFERENCES.FEE_TYPE,
FEE_CAT = NEW_REFERENCES.FEE_CAT,
FEE_CAL_TYPE = NEW_REFERENCES.FEE_CAL_TYPE,
FEE_CI_SEQUENCE_NUMBER = NEW_REFERENCES.FEE_CI_SEQUENCE_NUMBER,
COURSE_CD = NEW_REFERENCES.COURSE_CD,
ATTENDANCE_MODE = NEW_REFERENCES.ATTENDANCE_MODE,
ATTENDANCE_TYPE = NEW_REFERENCES.ATTENDANCE_TYPE,
INVOICE_AMOUNT_DUE = NEW_REFERENCES.INVOICE_AMOUNT_DUE,
INVOICE_CREATION_DATE = NEW_REFERENCES.INVOICE_CREATION_DATE,
INVOICE_DESC = NEW_REFERENCES.INVOICE_DESC,
TRANSACTION_TYPE = NEW_REFERENCES.TRANSACTION_TYPE,
CURRENCY_CD = NEW_REFERENCES.CURRENCY_CD,
STATUS = NEW_REFERENCES.STATUS,
ATTRIBUTE_CATEGORY = NEW_REFERENCES.ATTRIBUTE_CATEGORY,
ATTRIBUTE1 = NEW_REFERENCES.ATTRIBUTE1,
ATTRIBUTE2 = NEW_REFERENCES.ATTRIBUTE2,
ATTRIBUTE3 = NEW_REFERENCES.ATTRIBUTE3,
ATTRIBUTE4 = NEW_REFERENCES.ATTRIBUTE4,
ATTRIBUTE5 = NEW_REFERENCES.ATTRIBUTE5,
ATTRIBUTE6 = NEW_REFERENCES.ATTRIBUTE6,
ATTRIBUTE7 = NEW_REFERENCES.ATTRIBUTE7,
ATTRIBUTE8 = NEW_REFERENCES.ATTRIBUTE8,
ATTRIBUTE9 = NEW_REFERENCES.ATTRIBUTE9,
ATTRIBUTE10 = NEW_REFERENCES.ATTRIBUTE10,
INVOICE_AMOUNT = NEW_REFERENCES.INVOICE_AMOUNT,
BILL_ID = NEW_REFERENCES.BILL_ID ,
BILL_NUMBER = NEW_REFERENCES.BILL_NUMBER ,
BILL_DATE = NEW_REFERENCES.BILL_DATE ,
WAIVER_FLAG = NEW_REFERENCES.WAIVER_FLAG ,
WAIVER_REASON = NEW_REFERENCES.WAIVER_REASON ,
EFFECTIVE_DATE = NEW_REFERENCES.EFFECTIVE_DATE ,
INVOICE_NUMBER = NEW_REFERENCES.INVOICE_NUMBER ,
EXCHANGE_RATE = NEW_REFERENCES.EXCHANGE_RATE ,
BILL_PAYMENT_DUE_DATE = NEW_REFERENCES.BILL_PAYMENT_DUE_DATE ,
OPTIONAL_FEE_FLAG = NEW_REFERENCES.OPTIONAL_FEE_FLAG,
REQUEST_ID = NEW_REFERENCES.REQUEST_ID ,
PROGRAM_APPLICATION_ID = NEW_REFERENCES.PROGRAM_APPLICATION_ID ,
PROGRAM_ID = NEW_REFERENCES.PROGRAM_ID ,
PROGRAM_UPDATE_DATE = NEW_REFERENCES.PROGRAM_UPDATE_DATE ,
LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
LAST_UPDATED_BY = X_LAST_UPDATED_BY,
LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN,
reversal_gl_date = new_references.reversal_gl_date,
tax_year_code = new_references.tax_year_code,
waiver_name = new_references.waiver_name
where ROWID = X_ROWID;
p_action => 'UPDATE' ,
x_rowid => X_ROWID
);
end UPDATE_ROW;
cursor c1 is select ROWID from IGS_FI_INV_INT_ALL
where INVOICE_ID= X_INVOICE_ID
;
INSERT_ROW (
X_ROWID,
X_INVOICE_ID,
X_PERSON_ID,
X_FEE_TYPE,
X_FEE_CAT,
X_FEE_CAL_TYPE,
X_FEE_CI_SEQUENCE_NUMBER,
X_COURSE_CD,
X_ATTENDANCE_MODE,
X_ATTENDANCE_TYPE,
X_INVOICE_AMOUNT_DUE,
X_INVOICE_CREATION_DATE,
X_INVOICE_DESC,
X_TRANSACTION_TYPE,
X_CURRENCY_CD,
X_STATUS,
X_ATTRIBUTE_CATEGORY,
X_ATTRIBUTE1,
X_ATTRIBUTE2,
X_ATTRIBUTE3,
X_ATTRIBUTE4,
X_ATTRIBUTE5,
X_ATTRIBUTE6,
X_ATTRIBUTE7,
X_ATTRIBUTE8,
X_ATTRIBUTE9,
X_ATTRIBUTE10,
X_INVOICE_AMOUNT ,
X_BILL_ID ,
X_BILL_NUMBER ,
X_BILL_DATE ,
X_WAIVER_FLAG ,
X_WAIVER_REASON ,
X_EFFECTIVE_DATE ,
X_INVOICE_NUMBER ,
X_EXCHANGE_RATE ,
X_BILL_PAYMENT_DUE_DATE,
X_ORG_ID,
x_OPTIONAL_FEE_FLAG,
X_MODE ,
X_REVERSAL_GL_DATE,
x_tax_year_code,
x_waiver_name
);
UPDATE_ROW (
X_ROWID,
X_INVOICE_ID,
X_PERSON_ID,
X_FEE_TYPE,
X_FEE_CAT,
X_FEE_CAL_TYPE,
X_FEE_CI_SEQUENCE_NUMBER,
X_COURSE_CD,
X_ATTENDANCE_MODE,
X_ATTENDANCE_TYPE,
X_INVOICE_AMOUNT_DUE,
X_INVOICE_CREATION_DATE,
X_INVOICE_DESC,
X_TRANSACTION_TYPE,
X_CURRENCY_CD,
X_STATUS,
X_ATTRIBUTE_CATEGORY,
X_ATTRIBUTE1,
X_ATTRIBUTE2,
X_ATTRIBUTE3,
X_ATTRIBUTE4,
X_ATTRIBUTE5,
X_ATTRIBUTE6,
X_ATTRIBUTE7,
X_ATTRIBUTE8,
X_ATTRIBUTE9,
X_ATTRIBUTE10,
X_INVOICE_AMOUNT ,
X_BILL_ID ,
X_BILL_NUMBER ,
X_BILL_DATE ,
X_WAIVER_FLAG ,
X_WAIVER_REASON ,
X_EFFECTIVE_DATE ,
X_INVOICE_NUMBER ,
X_EXCHANGE_RATE ,
X_BILL_PAYMENT_DUE_DATE,
x_OPTIONAL_FEE_FLAG,
X_MODE,
X_REVERSAL_GL_DATE,
x_tax_year_code,
x_waiver_name
);
procedure DELETE_ROW (
X_ROWID in VARCHAR2
) AS
/*************************************************************
Created By :
Date Created By :
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_FI_INV_INT_ALL
where ROWID = X_ROWID;
p_action => 'DELETE',
x_rowid => X_ROWID
);
end DELETE_ROW;