[Home] [Help]
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_accounting_method IN VARCHAR2 ,
x_set_of_books_id IN NUMBER ,
x_refund_dr_gl_ccid IN NUMBER ,
x_refund_cr_gl_ccid IN NUMBER ,
x_refund_dr_account_cd IN VARCHAR2 ,
x_refund_cr_account_cd IN VARCHAR2 ,
x_refund_dt_alias IN VARCHAR2 ,
x_fee_calc_mthd_code IN VARCHAR2 ,
x_planned_credits_ind IN VARCHAR2 ,
x_rec_gl_ccid IN NUMBER ,
x_cash_gl_ccid IN NUMBER ,
x_unapp_gl_ccid IN NUMBER ,
x_rec_account_cd IN VARCHAR2 ,
x_rev_account_cd IN VARCHAR2 ,
x_cash_account_cd IN VARCHAR2 ,
x_unapp_account_cd IN VARCHAR2,
x_conv_process_run_ind IN NUMBER,
x_currency_cd IN VARCHAR2 ,
x_rfnd_destination IN VARCHAR2,
x_ap_org_id IN NUMBER,
x_dflt_supplier_site_name IN VARCHAR2,
x_manage_accounts IN VARCHAR2,
x_acct_conv_flag IN VARCHAR2,
x_post_waiver_gl_flag IN VARCHAR2,
x_waiver_notify_finaid_flag 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)
svuppala 14-JUL-2005 Enh 3392095 - Tution Waivers build
Modified by adding two new columns post_waiver_gl_flag, waiver_notify_finaid_flag
uudayapr 07-dec-2003 Enh#3167098 Modified the procedures BY removing the reference to prg_chg_dt_alias
and adding res_dt_alias.
shtatiko 27-MAY-2003 Enh# 2831582, Removed references to columns lockbox_context, lockbox_number_attribute
and ar_int_org_id.
vvutukur 16-May-2003 Enh#2831572.Financial Accounting Build. Added column acct_conv_flag.
pathipat 14-Apr-2003 Enh. 2831569 - Commercial Receivables Interface
Removed references to columns interface_line_context, interface_line_attribute, term_id,
batch_source_id, cust_trx_type_id. Added column manage_accounts
smadathi 18-Feb-2002 Enh. Bug 2747329.Added new columns rfnd_destination, ap_org_id, dflt_supplier_site_name
smadathi 01-Nov-2002 Enh Bug 2584986. Added new column currency_cd
pathipat 02-OCT-2002 Added column x_conv_process_run_ind, part of Enh Bug: 2562745
smvk 24-Sep-2002 Added the columns rec_gl_ccid, cash_gl_ccid, unapp_gl_ccid,
rec_account_cd, rev_account_cd, cash_account_cd and
unapp_account_cd. As a part of Bug # 2564643.
vchappid 01-Apr-2002 Bug# 2293676, Added column planned_credits_ind
smvk 13-Mar-2002 Added four columns refund_cr_gl_ccid, refund_dr_gl_ccid
refund_dr_account_cd, refund_cr_account_cd, refund_dt_alias and
removed last_account_trans, last_payment_trans and
last_pay_term_trans w.r.t. Bug # 2144600
vvutukur 13-02-2002 Added a new column, ar_int_org_id for bug 2222272
msrinivi 17 Jul, 2001 Added a new column, set_of_books_id
***************************************************************/
CURSOR cur_old_ref_values IS
SELECT *
FROM IGS_FI_CONTROL_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 fnd_currencies
WHERE currency_code = new_references.currency_cd;
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');
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');
fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
SELECT row_id
FROM igs_fi_control
WHERE rec_installed = x_rec_installed
FOR UPDATE NOWAIT;
x_last_update_date IN DATE ,
x_last_updated_by IN NUMBER ,
x_last_update_login IN NUMBER ,
x_accounting_method IN VARCHAR2 ,
x_set_of_books_id IN NUMBER ,
x_refund_dr_gl_ccid IN NUMBER ,
x_refund_cr_gl_ccid IN NUMBER ,
x_refund_dr_account_cd IN VARCHAR2 ,
x_refund_cr_account_cd IN VARCHAR2 ,
x_refund_dt_alias IN VARCHAR2 ,
x_fee_calc_mthd_code IN VARCHAR2 ,
x_planned_credits_ind IN VARCHAR2 ,
x_rec_gl_ccid IN NUMBER ,
x_cash_gl_ccid IN NUMBER ,
x_unapp_gl_ccid IN NUMBER ,
x_rec_account_cd IN VARCHAR2 ,
x_rev_account_cd IN VARCHAR2 ,
x_cash_account_cd IN VARCHAR2 ,
x_unapp_account_cd IN VARCHAR2,
x_conv_process_run_ind IN NUMBER,
x_currency_cd IN VARCHAR2 ,
x_rfnd_destination IN VARCHAR2,
x_ap_org_id IN NUMBER,
x_dflt_supplier_site_name IN VARCHAR2,
x_manage_accounts IN VARCHAR2,
x_acct_conv_flag IN VARCHAR2,
x_post_waiver_gl_flag IN VARCHAR2,
x_waiver_notify_finaid_flag 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)
svuppala 14-JUL-2005 Enh 3392095 - Tution Waivers build
Modified by adding two new columns post_waiver_gl_flag, waiver_notify_finaid_flag
uudayapr 07-dec-2003 Enh#3167098 Modified the procedures BY removing the reference to prg_chg_dt_alias
and adding res_dt_alias.
shtatiko 27-MAY-2003 Enh# 2831582, Removed references to columns lockbox_context, lockbox_number_attribute
and ar_int_org_id.
vvutukur 16-May-2003 Enh#2831572.Financial Accounting Build. Added column acct_conv_flag.
pathipat 14-Apr-2003 Enh. 2831569 - Commercial Receivables Interface
Removed references to columns interface_line_context, interface_line_attribute, term_id,
batch_source_id, cust_trx_type_id. Added column manage_accounts
smadathi 18-Feb-2002 Enh. Bug 2747329.Added new columns rfnd_destination, ap_org_id, dflt_supplier_site_name
smadathi 01-Nov-2002 Enh Bug 2584986. Added new column currency_cd
pathipat 02-OCT-2002 Added column x_conv_process_run_ind, part of Enh Bug: 2562745
smvk 24-Sep-2002 Added the columns rec_gl_ccid, cash_gl_ccid, unapp_gl_ccid,
rec_account_cd, rev_account_cd, cash_account_cd and
unapp_account_cd. As a part of Bug # 2564643.
vchappid 01-Apr-2002 Bug# 2293676, Added column planned_credits_ind
smvk 13-Mar-2002 Added four columns refund_cr_gl_ccid, refund_dr_gl_ccid
refund_dr_account_cd, refund_cr_account_cd, refund_dt_alias and
removed last_account_trans, last_payment_trans and
last_pay_term_trans w.r.t. Bug # 2144600
vvutukur 13-02-2002 Added a new column, ar_int_org_id for bug 2222272
msrinivi 17 Jul,2001 Added 1 new column, set_of_books_id
***************************************************************/
BEGIN
set_column_values (
p_action,
x_rowid,
x_rec_installed,
x_creation_date,
x_created_by,
x_last_update_date,
x_last_updated_by,
x_last_update_login,
x_accounting_method,
x_set_of_books_id,
x_refund_dr_gl_ccid,
x_refund_cr_gl_ccid,
x_refund_dr_account_cd,
x_refund_cr_account_cd,
x_refund_dt_alias,
x_fee_calc_mthd_code ,
x_planned_credits_ind,
x_rec_gl_ccid,
x_cash_gl_ccid,
x_unapp_gl_ccid ,
x_rec_account_cd,
x_rev_account_cd,
x_cash_account_cd,
x_unapp_account_cd,
x_conv_process_run_ind,
x_currency_cd,
x_rfnd_destination,
x_ap_org_id,
x_dflt_supplier_site_name,
x_manage_accounts,
x_acct_conv_flag,
x_post_waiver_gl_flag,
x_waiver_notify_finaid_flag
);
IF (p_action = 'INSERT') THEN
-- Call all the procedures related to Before Insert.
IF get_pk_for_validation(
new_references.rec_installed) THEN
fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
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.rec_installed) 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
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_rec_installed IN VARCHAR2,
x_mode IN VARCHAR2 ,
x_accounting_method IN VARCHAR2,
x_set_of_books_id IN NUMBER ,
x_refund_dr_gl_ccid IN NUMBER ,
x_refund_cr_gl_ccid IN NUMBER ,
x_refund_dr_account_cd IN VARCHAR2 ,
x_refund_cr_account_cd IN VARCHAR2 ,
x_refund_dt_alias IN VARCHAR2 ,
x_fee_calc_mthd_code IN VARCHAR2 ,
x_planned_credits_ind IN VARCHAR2 ,
x_rec_gl_ccid IN NUMBER ,
x_cash_gl_ccid IN NUMBER ,
x_unapp_gl_ccid IN NUMBER ,
x_rec_account_cd IN VARCHAR2 ,
x_rev_account_cd IN VARCHAR2 ,
x_cash_account_cd IN VARCHAR2 ,
x_unapp_account_cd IN VARCHAR2,
x_conv_process_run_ind IN NUMBER,
x_currency_cd IN VARCHAR2,
x_rfnd_destination IN VARCHAR2,
x_ap_org_id IN NUMBER,
x_dflt_supplier_site_name IN VARCHAR2,
x_manage_accounts IN VARCHAR2,
x_acct_conv_flag IN VARCHAR2,
x_post_waiver_gl_flag IN VARCHAR2,
x_waiver_notify_finaid_flag 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)
svuppala 14-JUL-2005 Enh 3392095 - Tution Waivers build
Modified by adding two new columns post_waiver_gl_flag, waiver_notify_finaid_flag
uudayapr 07-dec-2003 Enh#3167098 Modified the procedures BY removing the reference to prg_chg_dt_alias
and adding res_dt_alias.
shtatiko 27-MAY-2003 Enh# 2831582, Removed references to columns lockbox_context, lockbox_number_attribute
and ar_int_org_id.
vvutukur 16-May-2003 Enh#2831572.Financial Accounting Build. Added column acct_conv_flag.
pathipat 14-Apr-2003 Enh. 2831569 - Commercial Receivables Interface
Removed references to columns interface_line_context, interface_line_attribute, term_id,
batch_source_id, cust_trx_type_id. Added column manage_accounts
smadathi 18-Feb-2002 Enh. Bug 2747329.Added new columns rfnd_destination, ap_org_id, dflt_supplier_site_name
smadathi 01-Nov-2002 Enh Bug 2584986. Added new column currency_cd
pathipat 02-OCT-2002 Added column x_conv_process_run_ind, part of Enh Bug: 2562745
smvk 24-Sep-2002 Added the columns rec_gl_ccid, cash_gl_ccid, unapp_gl_ccid,
rec_account_cd, rev_account_cd, cash_account_cd and
unapp_account_cd. As a part of Bug # 2564643.
vchappid 01-Apr-2002 Bug# 2293676, Added column planned_credits_ind
smvk 13-Mar-2002 Added four columns refund_cr_gl_ccid, refund_dr_gl_ccid
refund_dr_account_cd, refund_cr_account_cd, refund_dt_alias and
removed last_account_trans, last_payment_trans and
last_pay_term_trans w.r.t. Bug # 2144600
vvutukur 13-02-2002 Added a new column, ar_int_org_id for bug 2222272
msrinivi 17 Jul,2001 Added a new column, set_of_books_id
***************************************************************/
CURSOR c IS
SELECT ROWID
FROM igs_fi_control
WHERE rec_installed= x_rec_installed;
x_last_update_date DATE ;
x_last_updated_by NUMBER ;
x_last_update_login NUMBER ;
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 =>'INSERT',
x_rowid => x_rowid,
x_rec_installed => x_rec_installed,
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_accounting_method => x_accounting_method,
x_set_of_books_id => x_set_of_books_id,
x_refund_dr_gl_ccid => x_refund_dr_gl_ccid,
x_refund_cr_gl_ccid => x_refund_cr_gl_ccid,
x_refund_dr_account_cd => x_refund_dr_account_cd,
x_refund_cr_account_cd => x_refund_cr_account_cd,
x_refund_dt_alias => x_refund_dt_alias,
x_fee_calc_mthd_code => x_fee_calc_mthd_code ,
x_planned_credits_ind => x_planned_credits_ind ,
x_rec_gl_ccid => x_rec_gl_ccid,
x_cash_gl_ccid => x_cash_gl_ccid,
x_unapp_gl_ccid => x_unapp_gl_ccid ,
x_rec_account_cd => x_rec_account_cd,
x_rev_account_cd => x_rev_account_cd,
x_cash_account_cd => x_cash_account_cd,
x_unapp_account_cd => x_unapp_account_cd,
x_conv_process_run_ind => x_conv_process_run_ind,
x_currency_cd => x_currency_cd,
x_rfnd_destination => x_rfnd_destination,
x_ap_org_id => x_ap_org_id,
x_dflt_supplier_site_name => x_dflt_supplier_site_name,
x_manage_accounts => x_manage_accounts,
x_acct_conv_flag => x_acct_conv_flag,
x_post_waiver_gl_flag => x_post_waiver_gl_flag,
x_waiver_notify_finaid_flag => x_waiver_notify_finaid_flag
);
INSERT INTO igs_fi_control_all (
rec_installed,
creation_date,
created_by,
last_update_date,
last_updated_by,
last_update_login,
accounting_method,
set_of_books_id,
org_id,
refund_dr_gl_ccid,
refund_cr_gl_ccid,
refund_dr_account_cd,
refund_cr_account_cd,
refund_dt_alias,
fee_calc_mthd_code,
planned_credits_ind,
rec_gl_ccid,
cash_gl_ccid,
unapp_gl_ccid,
rec_account_cd,
rev_account_cd,
cash_account_cd,
unapp_account_cd,
conv_process_run_ind,
currency_cd,
rfnd_destination,
ap_org_id,
dflt_supplier_site_name,
manage_accounts,
acct_conv_flag,
post_waiver_gl_flag,
waiver_notify_finaid_flag
)
VALUES (
new_references.rec_installed,
x_last_update_date,
x_last_updated_by,
x_last_update_date,
x_last_updated_by,
x_last_update_login,
x_accounting_method,
new_references.set_of_books_id,
new_references.org_id,
new_references.refund_dr_gl_ccid,
new_references.refund_cr_gl_ccid,
new_references.refund_dr_account_cd,
new_references.refund_cr_account_cd,
new_references.refund_dt_alias,
new_references.fee_calc_mthd_code,
new_references.planned_credits_ind,
new_references.rec_gl_ccid,
new_references.cash_gl_ccid,
new_references.unapp_gl_ccid,
new_references.rec_account_cd,
new_references.rev_account_cd,
new_references.cash_account_cd,
new_references.unapp_account_cd,
new_references.conv_process_run_ind,
new_references.currency_cd,
new_references.rfnd_destination,
new_references.ap_org_id,
new_references.dflt_supplier_site_name,
new_references.manage_accounts,
new_references.acct_conv_flag,
new_references.post_waiver_gl_flag,
new_references.waiver_notify_finaid_flag
);
p_action => 'INSERT' ,
x_rowid => X_ROWID );
END insert_row;
SELECT accounting_method,
set_of_books_id,
refund_dr_gl_ccid ,
refund_cr_gl_ccid,
refund_dr_account_cd ,
refund_cr_account_cd,
refund_dt_alias ,
fee_calc_mthd_code,
planned_credits_ind,
rec_gl_ccid,
cash_gl_ccid,
unapp_gl_ccid,
rec_account_cd,
rev_account_cd,
cash_account_cd,
unapp_account_cd,
conv_process_run_ind,
currency_cd,
rfnd_destination,
ap_org_id,
dflt_supplier_site_name,
manage_accounts,
acct_conv_flag,
post_waiver_gl_flag,
waiver_notify_finaid_flag
FROM igs_fi_control_all
WHERE rowid = x_rowid
FOR UPDATE NOWAIT;
fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
PROCEDURE update_row (
x_rowid IN VARCHAR2,
x_rec_installed IN VARCHAR2,
x_mode IN VARCHAR2 ,
x_accounting_method IN VARCHAR2,
x_set_of_books_id IN NUMBER ,
x_refund_dr_gl_ccid IN NUMBER ,
x_refund_cr_gl_ccid IN NUMBER ,
x_refund_dr_account_cd IN VARCHAR2 ,
x_refund_cr_account_cd IN VARCHAR2 ,
x_refund_dt_alias IN VARCHAR2 ,
x_fee_calc_mthd_code IN VARCHAR2 ,
x_planned_credits_ind IN VARCHAR2 ,
x_rec_gl_ccid IN NUMBER ,
x_cash_gl_ccid IN NUMBER ,
x_unapp_gl_ccid IN NUMBER ,
x_rec_account_cd IN VARCHAR2 ,
x_rev_account_cd IN VARCHAR2 ,
x_cash_account_cd IN VARCHAR2 ,
x_unapp_account_cd IN VARCHAR2,
x_conv_process_run_ind IN NUMBER,
x_currency_cd IN VARCHAR2,
x_rfnd_destination IN VARCHAR2,
x_ap_org_id IN NUMBER,
x_dflt_supplier_site_name IN VARCHAR2,
x_manage_accounts IN VARCHAR2,
x_acct_conv_flag IN VARCHAR2,
x_post_waiver_gl_flag IN VARCHAR2,
x_waiver_notify_finaid_flag 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)
svuppala 14-JUL-2005 Enh 3392095 - Tution Waivers build
Modified by adding two new columns post_waiver_gl_flag, waiver_notify_finaid_flag
uudayapr 07-dec-2003 Enh#3167098 Modified the procedures BY removing the reference to prg_chg_dt_alias
and adding res_dt_alias.
shtatiko 27-MAY-2003 Enh# 2831582, Removed references to columns lockbox_context, lockbox_number_attribute
and ar_int_org_id.
vvutukur 16-May-2003 Enh#2831572.Financial Accounting Build. Added column acct_conv_flag.
pathipat 14-Apr-2003 Enh. 2831569 - Commercial Receivables Interface
Removed references to columns interface_line_context, interface_line_attribute, term_id,
batch_source_id, cust_trx_type_id. Added column manage_accounts
smadathi 18-Feb-2002 Enh. Bug 2747329.Added new columns rfnd_destination, ap_org_id, dflt_supplier_site_name
smadathi 01-Nov-2002 Enh Bug 2584986. Added new column currency_cd
pathipat 02-OCT-2002 Added column x_conv_process_run_ind, part of Enh Bug: 2562745
smvk 24-Sep-2002 Added the columns rec_gl_ccid, cash_gl_ccid, unapp_gl_ccid,
rec_account_cd, rev_account_cd, cash_account_cd and
unapp_account_cd. As a part of Bug # 2564643.
vchappid 01-Apr-2002 Bug# 2293676, Added column planned_credits_ind
smvk 13-Mar-2002 Added four columns refund_cr_gl_ccid, refund_dr_gl_ccid
refund_dr_account_cd, refund_cr_account_cd, refund_dt_alias and
removed last_account_trans, last_payment_trans and
last_pay_term_trans w.r.t. Bug # 2144600
vvutukur 13-02-2002 Added a new column, ar_int_org_id for bug 2222272
msrinivi 17 Jul,2001 Added 1 new column, set_of_books_id
***************************************************************/
x_last_update_date DATE ;
x_last_updated_by NUMBER ;
x_last_update_login NUMBER ;
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_rec_installed => x_rec_installed,
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_accounting_method => x_accounting_method,
x_set_of_books_id => x_set_of_books_id,
x_refund_dr_gl_ccid => x_refund_dr_gl_ccid,
x_refund_cr_gl_ccid => x_refund_cr_gl_ccid,
x_refund_dr_account_cd => x_refund_dr_account_cd,
x_refund_cr_account_cd => x_refund_cr_account_cd,
x_refund_dt_alias => x_refund_dt_alias,
x_fee_calc_mthd_code => x_fee_calc_mthd_code ,
x_planned_credits_ind => x_planned_credits_ind,
x_rec_gl_ccid => x_rec_gl_ccid,
x_cash_gl_ccid => x_cash_gl_ccid,
x_unapp_gl_ccid => x_unapp_gl_ccid ,
x_rec_account_cd => x_rec_account_cd,
x_rev_account_cd => x_rev_account_cd,
x_cash_account_cd => x_cash_account_cd,
x_unapp_account_cd => x_unapp_account_cd,
x_conv_process_run_ind => x_conv_process_run_ind ,
x_currency_cd => x_currency_cd,
x_rfnd_destination => x_rfnd_destination,
x_ap_org_id => x_ap_org_id,
x_dflt_supplier_site_name => x_dflt_supplier_site_name,
x_manage_accounts => x_manage_accounts,
x_acct_conv_flag => x_acct_conv_flag,
x_post_waiver_gl_flag => x_post_waiver_gl_flag,
x_waiver_notify_finaid_flag => x_waiver_notify_finaid_flag
);
UPDATE igs_fi_control_all
SET
rec_installed = new_references.rec_installed,
last_update_date = new_references.last_update_date,
last_updated_by = new_references.last_updated_by,
last_update_login = new_references.last_update_login,
accounting_method = new_references.accounting_method,
set_of_books_id = new_references.set_of_books_id ,
refund_dr_gl_ccid = new_references.refund_dr_gl_ccid,
refund_cr_gl_ccid = new_references.refund_cr_gl_ccid,
refund_dr_account_cd = new_references.refund_dr_account_cd,
refund_cr_account_cd = new_references.refund_cr_account_cd,
refund_dt_alias = new_references.refund_dt_alias,
fee_calc_mthd_code = new_references.fee_calc_mthd_code,
planned_credits_ind = new_references.planned_credits_ind,
rec_gl_ccid = new_references.rec_gl_ccid,
cash_gl_ccid = new_references.cash_gl_ccid,
unapp_gl_ccid = new_references.unapp_gl_ccid,
rec_account_cd = new_references.rec_account_cd,
rev_account_cd = new_references.rev_account_cd,
cash_account_cd = new_references.cash_account_cd,
unapp_account_cd = new_references.unapp_account_cd,
conv_process_run_ind = new_references.conv_process_run_ind ,
currency_cd = new_references.currency_cd,
rfnd_destination = new_references.rfnd_destination,
ap_org_id = new_references.ap_org_id,
dflt_supplier_site_name = new_references.dflt_supplier_site_name,
manage_accounts = new_references.manage_accounts,
acct_conv_flag = new_references.acct_conv_flag,
post_waiver_gl_flag = new_references.post_waiver_gl_flag,
waiver_notify_finaid_flag = new_references.waiver_notify_finaid_flag
WHERE rowid = x_rowid;
p_action => 'UPDATE' ,
x_rowid => X_ROWID
);
END update_row;
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_CONTROL_ALL
WHERE rowid = x_rowid;
p_action => 'DELETE',
x_rowid => x_rowid
);
END delete_row;
SELECT rowid
FROM IGS_FI_CONTROL_ALL
WHERE ((REFUND_DT_ALIAS = x_dt_alias));