[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
PROCEDURE beforerowdelete;
x_last_update_date IN DATE ,
x_last_updated_by IN NUMBER ,
x_last_update_login IN NUMBER ,
x_payment_credit_type_id IN NUMBER ,
x_forfeiture_gl_ccid IN NUMBER ,
x_forfeiture_account_cd IN VARCHAR2,
x_appl_hierarchy_id IN NUMBER
) AS
/*
|| Created By : BDEVARAK
|| Created On : 26-APR-2001
|| Purpose : Initialises the Old and New references for the columns of the table.
|| Known limitations, enhancements or remarks :
|| Change History :
|| Who When What
|| (reverse chronological order - newest change first)
|| sapanigr 20-Sep-2005 Enh#4228665.Added field appl_hierarchy_id.
|| shtatiko 03-Dec-2002 Enh Bug 2584741, Added three new columns
|| payment_credit_type_id, forfeiture_gl_ccid
|| and forfeiture_account_cd
|| vvutukur 16-Sep-2002 Enh#2564643.Removed references to subaccount_id.Also removed
|| DEFAULTing the parameters using DEFAULT keyword to avoid gscc warnings.
*/
CURSOR cur_old_ref_values IS
SELECT *
FROM IGS_FI_CR_TYPES_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;
PROCEDURE BeforeRowInsertUpdate1(
p_inserting IN BOOLEAN,
p_updating IN BOOLEAN,
p_deleting IN BOOLEAN
) AS
--CHANGE HISTORY
--Who When What
--vvutukur 26-Aug-2003 Enh#3045007.Added Installment Payments credit class in order to restrict the creation
-- of credit types with overlapping dates.
--vvutukur 09-Dec-2002 Enh#2584741.Added cursor cur_enr_deposit and corresponding validation not to allow
-- the user to create two credit types with credit class 'Enrollment Deposit'.
-- Also modified cursors cur_online_pay,cur_nca_meaning to check dates overlapping.Check
-- introduced with the value specified by the user on the form instead of SYSDATE, for
-- online payment and negative charge adjustment credit classes.Replaced igs_lookups_view
-- with igs_lookup_values and selected active lookup codes only.
--vvutukur 16-Sep-2002 Enh#2564643.Removed references to subaccount_id from cursors cur_online_pay,
-- cur_nca and from places where the cursors are used.Also removed DEFAULT
-- in procedure parameters list to avoid gscc warnings.
--vvutukur 30-jan-2002 Modified cur_online_pay and added IF condition
-- before opening that cursor for bug 2183291 as part of SFCR003.
--vvutukur 25-Jan-2002 Added code to error out NOCOPY when a Credit Type
-- with credit class CHGADJ already exists
-- for the subaccount for bug 2195715 as part of SFCR003.
CURSOR cur_overlapping_u(cp_credit_type_id igs_fi_cr_types.credit_type_id%TYPE,
cp_credit_class igs_fi_cr_types.credit_class%TYPE
) IS
SELECT 'x'
FROM igs_fi_cr_types
WHERE credit_class = cp_credit_class
AND credit_type_id <> cp_credit_type_id
AND (new_references.effective_start_date >= effective_start_date AND new_references.effective_start_date <= NVL(effective_end_date,new_references.effective_start_date)
OR ((new_references.effective_end_date >= effective_start_date OR (new_references.effective_end_date IS NULL)) AND new_references.effective_start_date <= effective_start_date));
END BeforeRowInsertUpdate1;
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');
|| sapanigr 21-SEP-2005 Enhc 4228665 Deleted igs_fi_a_hierarchies_pkg.get_fk_igs_fi_cr_types_all
|| (reverse chronological order - newest change first)
*/
BEGIN
igs_fi_bal_ex_c_typs_pkg.get_fk_igs_fi_cr_types_all (
old_references.credit_type_id
);
SELECT rowid
FROM IGS_FI_CR_TYPES_ALL
WHERE credit_type_id = x_credit_type_id;
SELECT rowid
FROM igs_fi_cr_types_all
WHERE credit_type_id = x_credit_type_id ;
SELECT rowid
FROM igs_fi_cr_types
WHERE credit_type_name = x_credit_type_name
AND ((effective_start_date = x_effective_start_date) OR (effective_start_date IS NULL AND x_effective_start_date IS NULL))
AND ((l_rowid IS NULL) OR (rowid <> l_rowid));
x_last_update_date IN DATE ,
x_last_updated_by IN NUMBER ,
x_last_update_login IN NUMBER ,
x_payment_credit_type_id IN NUMBER ,
x_forfeiture_gl_ccid IN NUMBER ,
x_forfeiture_account_cd IN VARCHAR2,
x_appl_hierarchy_id IN NUMBER
) AS
/*
|| Created By : BDEVARAK
|| Created On : 26-APR-2001
|| Purpose : Initialises the columns, Checks Constraints, Calls the
|| Trigger Handlers for the table, before any DML operation.
|| Known limitations, enhancements or remarks :
|| Change History :
|| Who When What
|| (reverse chronological order - newest change first)
|| sapanigr 20-Sep-2005 Enh#4228665.Added field appl_hierarchy_id.
|| shtatiko 03-Dec-2002 Enh Bug 2584741, Added three new columns
|| payment_credit_type_id, forfeiture_gl_ccid
|| and forfeiture_account_cd
|| vvutukur 16-Sep-2002 Enh#2564643.Removed references to subaccount_id.ie., from parameters list
|| and from call to set_column_values.Also removed DEFAULTing values
|| in parameter list using DEFAULT keyword to avoid gscc warnings.
*/
BEGIN
set_column_values (
p_action,
x_rowid,
x_credit_type_id,
x_credit_type_name,
x_description,
x_credit_class,
x_dr_account_cd,
x_cr_account_cd,
x_dr_gl_ccid,
x_cr_gl_ccid,
x_effective_start_date,
x_effective_end_date,
x_refund_allowed,
x_payment_priority,
x_attribute_category,
x_attribute1,
x_attribute2,
x_attribute3,
x_attribute4,
x_attribute5,
x_attribute6,
x_attribute7,
x_attribute8,
x_attribute9,
x_attribute10,
x_attribute11,
x_attribute12,
x_attribute13,
x_attribute14,
x_attribute15,
x_attribute16,
x_attribute17,
x_attribute18,
x_attribute19,
x_attribute20,
x_title4_type_ind,
x_creation_date,
x_created_by,
x_last_update_date,
x_last_updated_by,
x_last_update_login,
x_payment_credit_type_id,
x_forfeiture_gl_ccid,
x_forfeiture_account_cd,
x_appl_hierarchy_id
);
IF (p_action = 'INSERT') THEN
-- Call all the procedures related to Before Insert.
BeforeRowInsertUpdate1(p_inserting => FALSE,
p_updating => FALSE,
p_deleting => FALSE);
ELSIF (p_action = 'UPDATE') THEN
-- Call all the procedures related to Before Update.
BeforeRowInsertUpdate1(p_inserting => FALSE,
p_updating => FALSE,
p_deleting => FALSE);
ELSIF (p_action = 'DELETE') THEN
-- Call all the procedures related to Before Delete.
check_child_existance;
beforerowdelete;
ELSIF (p_action = 'VALIDATE_INSERT') THEN
-- Call all the procedures related to Before Insert.
BeforeRowInsertUpdate1(p_inserting => FALSE,
p_updating => FALSE,
p_deleting => FALSE);
ELSIF (p_action = 'VALIDATE_UPDATE') THEN
BeforeRowInsertUpdate1(p_inserting => FALSE,
p_updating => FALSE,
p_deleting => FALSE);
ELSIF (p_action = 'VALIDATE_DELETE') THEN
check_child_existance;
PROCEDURE insert_row (
x_rowid IN OUT NOCOPY VARCHAR2,
x_credit_type_id IN OUT NOCOPY NUMBER,
x_credit_type_name IN VARCHAR2,
x_description IN VARCHAR2,
x_credit_class IN VARCHAR2,
x_dr_account_cd IN VARCHAR2,
x_cr_account_cd IN VARCHAR2,
x_dr_gl_ccid IN NUMBER,
x_cr_gl_ccid IN NUMBER,
x_effective_start_date IN DATE,
x_effective_end_date IN DATE,
x_refund_allowed IN VARCHAR2,
x_payment_priority IN NUMBER,
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_attribute11 IN VARCHAR2,
x_attribute12 IN VARCHAR2,
x_attribute13 IN VARCHAR2,
x_attribute14 IN VARCHAR2,
x_attribute15 IN VARCHAR2,
x_attribute16 IN VARCHAR2,
x_attribute17 IN VARCHAR2,
x_attribute18 IN VARCHAR2,
x_attribute19 IN VARCHAR2,
x_attribute20 IN VARCHAR2,
x_title4_type_ind IN VARCHAR2,
x_mode IN VARCHAR2,
x_payment_credit_type_id IN NUMBER,
x_forfeiture_gl_ccid IN NUMBER,
x_forfeiture_account_cd IN VARCHAR2,
x_appl_hierarchy_id IN NUMBER
) AS
/*
|| Created By : BDEVARAK
|| Created On : 26-APR-2001
|| Purpose : Handles the INSERT DML logic for the table.
|| Known limitations, enhancements or remarks :
|| Change History :
|| Who When What
|| (reverse chronological order - newest change first)
|| sapanigr 20-Sep-2005 Enh#4228665.Added field appl_hierarchy_id.
|| shtatiko 03-Dec-2002 Enh Bug 2584741, Added three new columns
|| payment_credit_type_id, forfeiture_gl_ccid
|| and forfeiture_account_cd
|| vvutukur 16-Sep-2002 Enh#2564643.Removed referenes to subaccount_id.ie., from parameters
|| list and from call to before_dml and from insert statement.Also removed
|| DEFAULT keyword in parameter list.
*/
CURSOR c IS
SELECT rowid
FROM igs_fi_cr_types_all
WHERE credit_type_id = x_credit_type_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;
SELECT igs_fi_cr_types_s.NEXTVAL
INTO x_credit_type_id
FROM dual;
p_action => 'INSERT',
x_rowid => x_rowid,
x_credit_type_id => x_credit_type_id,
x_credit_type_name => x_credit_type_name,
x_description => x_description,
x_credit_class => x_credit_class,
x_dr_account_cd => x_dr_account_cd,
x_cr_account_cd => x_cr_account_cd,
x_dr_gl_ccid => x_dr_gl_ccid,
x_cr_gl_ccid => x_cr_gl_ccid,
x_effective_start_date => x_effective_start_date,
x_effective_end_date => x_effective_end_date,
x_refund_allowed => x_refund_allowed,
x_payment_priority => x_payment_priority,
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_attribute11 => x_attribute11,
x_attribute12 => x_attribute12,
x_attribute13 => x_attribute13,
x_attribute14 => x_attribute14,
x_attribute15 => x_attribute15,
x_attribute16 => x_attribute16,
x_attribute17 => x_attribute17,
x_attribute18 => x_attribute18,
x_attribute19 => x_attribute19,
x_attribute20 => x_attribute20,
x_title4_type_ind => x_title4_type_ind,
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_payment_credit_type_id => x_payment_credit_type_id,
x_forfeiture_gl_ccid => x_forfeiture_gl_ccid,
x_forfeiture_account_cd => x_forfeiture_account_cd,
x_appl_hierarchy_id => x_appl_hierarchy_id
);
INSERT INTO igs_fi_cr_types_all (
credit_type_id,
credit_type_name,
description,
credit_class,
dr_account_cd,
cr_account_cd,
dr_gl_ccid,
cr_gl_ccid,
effective_start_date,
effective_end_date,
refund_allowed,
org_id,
payment_priority,
attribute_category,
attribute1,
attribute2,
attribute3,
attribute4,
attribute5,
attribute6,
attribute7,
attribute8,
attribute9,
attribute10,
attribute11,
attribute12,
attribute13,
attribute14,
attribute15,
attribute16,
attribute17,
attribute18,
attribute19,
attribute20,
title4_type_ind,
creation_date,
created_by,
last_update_date,
last_updated_by,
last_update_login,
payment_credit_type_id,
forfeiture_gl_ccid,
forfeiture_acCount_cd,
appl_hierarchy_id
) VALUES (
new_references.credit_type_id,
new_references.credit_type_name,
new_references.description,
new_references.credit_class,
new_references.dr_account_cd,
new_references.cr_account_cd,
new_references.dr_gl_ccid,
new_references.cr_gl_ccid,
new_references.effective_start_date,
new_references.effective_end_date,
new_references.refund_allowed,
new_references.org_id,
new_references.payment_priority,
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.attribute11,
new_references.attribute12,
new_references.attribute13,
new_references.attribute14,
new_references.attribute15,
new_references.attribute16,
new_references.attribute17,
new_references.attribute18,
new_references.attribute19,
new_references.attribute20,
new_references.title4_type_ind,
x_last_update_date,
x_last_updated_by,
x_last_update_date,
x_last_updated_by,
x_last_update_login,
new_references.payment_credit_type_id,
new_references.forfeiture_gl_ccid,
new_references.forfeiture_account_cd,
new_references.appl_hierarchy_id
);
END insert_row;
SELECT
credit_type_name,
description,
credit_class,
dr_account_cd,
cr_account_cd,
dr_gl_ccid,
cr_gl_ccid,
effective_start_date,
effective_end_date,
refund_allowed,
payment_priority,
attribute_category,
attribute1,
attribute2,
attribute3,
attribute4,
attribute5,
attribute6,
attribute7,
attribute8,
attribute9,
attribute10,
attribute11,
attribute12,
attribute13,
attribute14,
attribute15,
attribute16,
attribute17,
attribute18,
attribute19,
attribute20,
title4_type_ind,
payment_credit_type_id,
forfeiture_gl_ccid,
forfeiture_account_cd,
appl_hierarchy_id
FROM igs_fi_cr_types_all
WHERE rowid = x_rowid
FOR UPDATE NOWAIT;
fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
PROCEDURE update_row (
x_rowid IN VARCHAR2,
x_credit_type_id IN NUMBER,
x_credit_type_name IN VARCHAR2,
x_description IN VARCHAR2,
x_credit_class IN VARCHAR2,
x_dr_account_cd IN VARCHAR2,
x_cr_account_cd IN VARCHAR2,
x_dr_gl_ccid IN NUMBER,
x_cr_gl_ccid IN NUMBER,
x_effective_start_date IN DATE,
x_effective_end_date IN DATE,
x_refund_allowed IN VARCHAR2,
x_payment_priority IN NUMBER,
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_attribute11 IN VARCHAR2,
x_attribute12 IN VARCHAR2,
x_attribute13 IN VARCHAR2,
x_attribute14 IN VARCHAR2,
x_attribute15 IN VARCHAR2,
x_attribute16 IN VARCHAR2,
x_attribute17 IN VARCHAR2,
x_attribute18 IN VARCHAR2,
x_attribute19 IN VARCHAR2,
x_attribute20 IN VARCHAR2,
x_title4_type_ind IN VARCHAR2,
x_mode IN VARCHAR2,
x_payment_credit_type_id IN NUMBER,
x_forfeiture_gl_ccid IN NUMBER,
x_forfeiture_account_cd IN VARCHAR2,
x_appl_hierarchy_id IN NUMBER
) AS
/*
|| Created By : BDEVARAK
|| Created On : 26-APR-2001
|| Purpose : Handles the UPDATE DML logic for the table.
|| Known limitations, enhancements or remarks :
|| Change History :
|| Who When What
|| (reverse chronological order - newest change first)
|| sapanigr 20-Sep-2005 Enh#4228665.Added field appl_hierarchy_id.
|| shtatiko 03-Dec-2002 Enh Bug 2584741, Added three new columns
|| payment_credit_type_id, forfeiture_gl_ccid
|| and forfeiture_account_cd
|| vvutukur 16-Sep-2002 Enh#2564643.Removed references to subaccount_id.ie., from parameters list
|| and from call to before_dml and from update statement.Also removed
|| DEFAULT value for x_title4_type_ind,x_mode to avoid gscc warnings.
*/
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_credit_type_id => x_credit_type_id,
x_credit_type_name => x_credit_type_name,
x_description => x_description,
x_credit_class => x_credit_class,
x_dr_account_cd => x_dr_account_cd,
x_cr_account_cd => x_cr_account_cd,
x_dr_gl_ccid => x_dr_gl_ccid,
x_cr_gl_ccid => x_cr_gl_ccid,
x_effective_start_date => x_effective_start_date,
x_effective_end_date => x_effective_end_date,
x_refund_allowed => x_refund_allowed,
x_payment_priority => x_payment_priority,
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_attribute11 => x_attribute11,
x_attribute12 => x_attribute12,
x_attribute13 => x_attribute13,
x_attribute14 => x_attribute14,
x_attribute15 => x_attribute15,
x_attribute16 => x_attribute16,
x_attribute17 => x_attribute17,
x_attribute18 => x_attribute18,
x_attribute19 => x_attribute19,
x_attribute20 => x_attribute20,
x_title4_type_ind => x_title4_type_ind,
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_payment_credit_type_id => x_payment_credit_type_id,
x_forfeiture_gl_ccid => x_forfeiture_gl_ccid,
x_forfeiture_account_cd => x_forfeiture_account_cd,
x_appl_hierarchy_id => x_appl_hierarchy_id
);
UPDATE igs_fi_cr_types_all
SET
credit_type_name = new_references.credit_type_name,
description = new_references.description,
credit_class = new_references.credit_class,
dr_account_cd = new_references.dr_account_cd,
cr_account_cd = new_references.cr_account_cd,
dr_gl_ccid = new_references.dr_gl_ccid,
cr_gl_ccid = new_references.cr_gl_ccid,
effective_start_date = new_references.effective_start_date,
effective_end_date = new_references.effective_end_date,
refund_allowed = new_references.refund_allowed,
payment_priority = new_references.payment_priority,
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,
attribute11 = new_references.attribute11,
attribute12 = new_references.attribute12,
attribute13 = new_references.attribute13,
attribute14 = new_references.attribute14,
attribute15 = new_references.attribute15,
attribute16 = new_references.attribute16,
attribute17 = new_references.attribute17,
attribute18 = new_references.attribute18,
attribute19 = new_references.attribute19,
attribute20 = new_references.attribute20,
title4_type_ind = new_references.title4_type_ind,
last_update_date = x_last_update_date,
last_updated_by = x_last_updated_by,
last_update_login = x_last_update_login,
payment_credit_type_id = x_payment_credit_type_id,
forfeiture_gl_ccid = x_forfeiture_gl_ccid,
forfeiture_account_cd = x_forfeiture_account_cd,
appl_hierarchy_id = x_appl_hierarchy_id
WHERE rowid = x_rowid;
END update_row;
|| Purpose : Adds a row if there is no existing row, otherwise updates existing row in the table.
|| Known limitations, enhancements or remarks :
|| Change History :
|| Who When What
|| (reverse chronological order - newest change first)
|| sapanigr 20-Sep-2005 Enh#4228665.Added field appl_hierarchy_id.
|| shtatiko 03-Dec-2002 Enh Bug 2584741, Added three new columns
|| payment_credit_type_id, forfeiture_gl_ccid
|| and forfeiture_account_cd
|| vvutukur 16-Sep-2002 Enh#2564643.Removed references to subaccount_id.ie.,from parameters,
|| from calls to insert_row and update_row.Also removed DEFAULT value
|| for x_title4_type_ind,x_mode in parameter list to avoid gscc warnings.
*/
CURSOR c1 IS
SELECT rowid
FROM igs_fi_cr_types_all
WHERE credit_type_id = x_credit_type_id;
insert_row (
x_rowid,
x_credit_type_id,
x_credit_type_name,
x_description,
x_credit_class,
x_dr_account_cd,
x_cr_account_cd,
x_dr_gl_ccid,
x_cr_gl_ccid,
x_effective_start_date,
x_effective_end_date,
x_refund_allowed,
x_payment_priority,
x_attribute_category,
x_attribute1,
x_attribute2,
x_attribute3,
x_attribute4,
x_attribute5,
x_attribute6,
x_attribute7,
x_attribute8,
x_attribute9,
x_attribute10,
x_attribute11,
x_attribute12,
x_attribute13,
x_attribute14,
x_attribute15,
x_attribute16,
x_attribute17,
x_attribute18,
x_attribute19,
x_attribute20,
x_title4_type_ind,
x_mode ,
x_payment_credit_type_id,
x_forfeiture_gl_ccid,
x_forfeiture_account_cd,
x_appl_hierarchy_id
);
update_row (
x_rowid,
x_credit_type_id,
x_credit_type_name,
x_description,
x_credit_class,
x_dr_account_cd,
x_cr_account_cd,
x_dr_gl_ccid,
x_cr_gl_ccid,
x_effective_start_date,
x_effective_end_date,
x_refund_allowed,
x_payment_priority,
x_attribute_category,
x_attribute1,
x_attribute2,
x_attribute3,
x_attribute4,
x_attribute5,
x_attribute6,
x_attribute7,
x_attribute8,
x_attribute9,
x_attribute10,
x_attribute11,
x_attribute12,
x_attribute13,
x_attribute14,
x_attribute15,
x_attribute16,
x_attribute17,
x_attribute18,
x_attribute19,
x_attribute20,
x_title4_type_ind,
x_mode ,
x_payment_credit_type_id,
x_forfeiture_gl_ccid,
x_forfeiture_account_cd,
x_appl_hierarchy_id
);
PROCEDURE delete_row (
x_rowid IN VARCHAR2
) AS
/*
|| Created By : BDEVARAK
|| Created On : 26-APR-2001
|| Purpose : Handles the DELETE DML logic for the table.
|| Known 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_cr_types_all
WHERE rowid = x_rowid;
END delete_row;
PROCEDURE beforerowdelete AS
------------------------------------------------------------------
--Created by : Sanil Madathil, Oracle India
--Date created: 12-Jun-2002
--
--Purpose: Only planned Calendar Instances are allowed for deletion
--
--
--Known limitations/enhancements and/or remarks:
--
--Change History:
--Who When What
-------------------------------------------------------------------
BEGIN
-- while inserting records into credits table, an explicit lock was place on the IGS_FI_CR_TYPES table
-- As a result locking contention occured when simultaneous transactions on the credit table were
-- carried out. Hence the row share table lock on the IGS_FI_CR_TYPES table was removed from get_pk_for_validation.
-- Through the forms, deletion of the IGS_FI_CR_TYPES records are not happening. To ensure that none of the
-- other process which manipulates the records of the IGS_FI_CR_TYPES should not delete any of the records present
-- in the table, explicitly the logic has been coded to prevent the deletion of records.
-- done as part of bug 2404523
FND_MESSAGE.SET_NAME('IGS','IGS_FI_DEL_NOT_ALLWD');
END beforerowdelete;