The following lines contain the word 'select', 'insert', 'update' or 'delete':
| application tables. The output is inserted into the |
| IGS_FI_Posting_INT. IF Oracle AR is installed then the data gets |
| transfered to the same. |
| |
| HISTORY |
| Who When What |
| abshriva 12-May-2006 Enh#5217319 Precision Issue. Modified |
| transfer_credit_act_txns, |
| transfer_appl_txns, transfer_chgs_txns|
| and transfer_ad_appl_fee_txns |
| abshriva 5-May-2006 Bug5178077 Modification made in |
| posting_interface |
| svuppala 30-MAY-2005 Enh 3442712 - Done the TBH |
| modifications by adding new columns |
| Unit_Type_Id, Unit_Level in |
| igs_fi_invln_int_all |
| |
| vvutukur 09-Oct-03 Bug#3160036. Modified procedure |
| transfer_ad_appl_fee_txns. |
| pathipat 14-Jun-2003 Enh 2831587 - CC Fund Transfer build |
| Modified transfer_ad_appl_fee_txns() |
| pathipat 23-Apr-2003 Enh 2831569 - Commercial Receivables |
| Stubbed transfer_posting. |
| Removed proc get_customer_details. |
| Modified posting_interface(). |
| shtatiko 09-DEC-2002 Modified cursor in transfer_credit_act_txns|
| procedure. ( Bug# 2584741, Deposits) |
| SYKRISHN 05-NOV/2002 Change posting_interface procedure as |
| as per GL Interface TD. 2584986 |
| vchappid 16-Jul-2002 Bug#2464172, procedure in body are |
| made in sync with the Package Spec |
| agairola 04 May 2002 Added the function get_log_line |
| Modified the log file for the Transfer|
| posting transactions to AR process |
| Also removed the references for the |
| g_err_party and added the global var |
| g_party for the party id |
| agairola 21 Apr 2002 Changed the variable g_interface_attr |
| to data type igs_fi_control.interface |
| line attribute.Added bug no. to header|
| for bugs 2326595, 2309929, 2310806 |
| agairola 17-APR 2002 Added a new function get_int_val. |
| Modified the coding logic for the |
| INTERFACE_LINE_ATTRIBUTE11. Modified |
| the log file display of the Posting |
| Process. |
| for bugs 2326595, 2309929, 2310806 |
| agairola 12-Apr-2002 Made the width of the CCID displayed |
| to 233. Incase of error displayed
| party id.Modified the get_customer_details
| procedure to return customer account
| number. Added the function get_party_num
| for bugs 2326595, 2309929, 2310806 |
| agairola 11-Apr-2002 Used the comments for the description field
| while populating the data in the
| RA_INTERFACE_LINES_ALL table in case
| the description is null
| for bugs 2326595, 2309929, 2310806 |
| agairola 10-Apr-2002 Modified the code for displaying the |
| Accounting Flex fields. Removed the |
| redundant code and added the procedure|
| s for updation of the log file. |
| for bugs 2326595, 2309929, 2310806 |
|
| sarakshi 28-Feb-2002 bug:2238362,For message logging modified
| person_ref to party_ref lookup |
| jbegum 25 Feb 02 As part of Enh bug # 2238226 |
| Modified the local procedure |
| get_customer_details to derive |
| customer account details for the local|
| institution . |
| In the procedure transfer_posting |
| added code to copy value of the field |
| orig_appl_fee_ref to comments field of|
| RA_INTERFACE_LINES_ALL when |
| source_transaction_type is APPLFEE |
| Also added column orig_appl_fee_ref to|
| the IGS_FI_POSTING_INT_PKG.insert_row,|
| IGS_FI_POSTING_INT_PKG.update_row |
| agairola 22-Feb-2002 Added the modifications related to |
| Customer Account and also calling the |
| customer account creation procedure |
|
| agairola 11-Apr-2002 Used the value of comments for description in case it is null
| agairola 10-Apr-2002 Code fixes done as part of bug 2309929
| Added the procedures for updating the log file
| Code fixes done as part of bug 2310806
| Added the brackets for the Batch Name in Cursor cur_postings
| Added the code for locking the records
| jbegum 25 Feb 02 As part of Enh bug #2238226
| Modified the local procedure get_customer_details
| to derive customer account details for the local institution
| In the procedure transfer_posting added code to copy value of the field
| orig_appl_fee_ref to comments field of RA_INTERFACE_LINES_ALL when
| source_transaction_type is APPLFEE.Also added column orig_appl_fee_ref to
| the IGS_FI_POSTING_INT_PKG.insert_row ,IGS_FI_POSTING_INT_PKG.update_row
| jbegum 20 Feb 02 As part of Enh bug #2228910
Removed the source_transaction_id column from the IGS_FI_INVLN_INT_PKG.update_row
jbegum 16 Feb 02 As part of Enh bug #2222272
Set org id of transactions created
in the Receivables Invoice Interface tables
to the org id value obtained from control table
Sykrishn 18-FEB-2002 Changes as per build SFCR023 - 2227831
*=======================================================================*/
-- Declare all Global variables and global constants
g_cash CONSTANT VARCHAR2(20) := 'CASH';
SELECT meaning
FROM igs_lookup_values
WHERE lookup_code = x_code
AND lookup_type = x_type ;
SELECT party_number
FROM hz_parties
WHERE party_id = cp_party_id;
PROCEDURE update_log_norec(p_flag IN BOOLEAN,
p_trx_type IN VARCHAR2) AS
/******************************************************************
Created By : agairola
Date Created By : 10-Apr-2002
Purpose : Local function for updating the log file incase
no records are found
Known limitations,
enhancements,
remarks :
Change History
Who When What
******************************************************************/
BEGIN
IF ((p_flag IS NULL) OR
(p_trx_type IS NULL)) THEN
RETURN;
END update_log_norec;
PROCEDURE update_log_file(p_txn_date IN igs_fi_posting_int.transaction_date%TYPE,
p_amount IN igs_fi_posting_int.amount%TYPE,
p_txn_id IN igs_fi_posting_int.source_transaction_id%TYPE,
p_dr_acc_code IN igs_fi_posting_int.dr_account_cd%TYPE,
p_cr_acc_code IN igs_fi_posting_int.cr_account_cd%TYPE,
p_src_txn_type IN igs_fi_posting_int.source_transaction_type%TYPE) AS
/******************************************************************
Created By : agairola
Date Created By : 10-Apr-2002
Purpose : Local function for updating the log file with actual data
Known limitations,
enhancements,
remarks :
Change History
Who When What
SYKRISHN 01-NOV-2002 Modifications for Gl Interface Build
agairola 17-Apr-2002 Modified the Log file display to be in Single Line instead of Tabular
for bugs 2326595, 2309929, 2310806
******************************************************************/
l_v_txn_num VARCHAR2(240);
END update_log_file;
|| abshriva 12-May-2006 Enh#5217319 Precision Issue. Amount values being inserted into igs_fi_posting_int
|| is now rounded off to currency precision
|| shtatiko 09-Dec-2002 Modified to cursor to include conditions for dr_account_cd and cr_account_cd.
|| ( BUG# 2584741 )
|| Sykrishn 01-NOV/2002 Gl Interface TD modifications...
|| The below history is nt valid as the local procedure is revamped completely (including the proc name)
|| agairola 21 Apr 2002 Initialised the lrec_posting_int
|| for bugs 2326595, 2309929, 2310806
|| agairola 10-Apr-2002 Added the code for the printing of message in case of
|| no records being found and also for the common procedure
|| for logging messages for bugs 2326595, 2309929, 2310806
|| jbegum 25 Feb 02 As part of Enh bug # 2238226
|| Added column orig_appl_fee_ref to the
|| IGS_FI_POSTING_INT_PKG.insert_row
|| (reverse chronological order - newest change first)
*/
-- Get all the credit activity records, where GL_DATE lies b/w the passed date ranges that are yet to be posted.
-- Cursor is modified to include the check of credit and debit account codes
-- by shtatiko as part of Enh Bug# 2584741.
CURSOR cur_credit_activities(cp_d_gl_date_start IN igs_fi_posting_int_all.accounting_date%TYPE,
cp_d_gl_date_end IN igs_fi_posting_int_all.accounting_date%TYPE ) IS
SELECT crac.rowid row_id, crac.*
FROM igs_fi_cr_activities crac
WHERE crac.gl_date IS NOT NULL
AND TRUNC(crac.gl_date) BETWEEN TRUNC(cp_d_gl_date_start) AND TRUNC(cp_d_gl_date_end)
AND crac.posting_id IS NULL
AND crac.posting_control_id IS NULL
AND crac.dr_account_cd IS NOT NULL
AND crac.cr_account_cd IS NOT NULL
ORDER BY gl_date
FOR UPDATE OF gl_posted_date NOWAIT;
SELECT currency_cd
FROM igs_fi_credits
WHERE credit_id = cp_credit_id;
igs_fi_posting_int_pkg.insert_row (
x_rowid => l_v_posting_rowid,
x_posting_control_id => g_n_posting_control_id,
x_posting_id => l_n_posting_id,
x_batch_name => NULL,
x_accounting_date => cr_act_rec.gl_date,
x_transaction_date => cr_act_rec.transaction_date,
x_currency_cd => l_v_currency_cd,
x_dr_account_cd => l_v_dr_account_cd,
x_cr_account_cd => l_v_cr_account_cd,
x_dr_gl_code_ccid => NULL,
x_cr_gl_code_ccid => NULL,
x_amount => igs_fi_gen_gl.get_formatted_amount(l_n_amount),
x_source_transaction_id => cr_act_rec.credit_activity_id,
x_source_transaction_type => g_credit,
x_status => g_todo,
x_orig_appl_fee_ref => NULL,
x_mode => 'R'
);
update_log_file
(p_txn_date => cr_act_rec.transaction_date,
p_amount => l_n_amount,
p_txn_id => cr_act_rec.credit_activity_id,
p_dr_acc_code => l_v_dr_account_cd,
p_cr_acc_code => l_v_cr_account_cd,
p_src_txn_type => g_credit);
igs_fi_cr_activities_pkg.update_row(
x_rowid => cr_act_rec.row_id,
x_credit_activity_id => cr_act_rec.credit_activity_id,
x_credit_id => cr_act_rec.credit_id,
x_status => cr_act_rec.status,
x_transaction_date => cr_act_rec.transaction_date,
x_amount => cr_act_rec.amount,
x_dr_account_cd => cr_act_rec.dr_account_cd,
x_cr_account_cd => cr_act_rec.cr_account_cd,
x_dr_gl_ccid => cr_act_rec.dr_gl_ccid,
x_cr_gl_ccid => cr_act_rec.cr_gl_ccid,
x_bill_id => cr_act_rec.bill_id,
x_bill_number => cr_act_rec.bill_number,
x_bill_date => cr_act_rec.bill_date,
x_posting_id => l_n_posting_id,
x_posting_control_id => g_n_posting_control_id,
x_gl_date => cr_act_rec.gl_date,
x_gl_posted_date => p_d_gl_posted_date,
x_mode => 'R'
);
|| abshriva 12-May-2006 Enh#5217319 Precision Issue. Amount values being inserted into igs_fi_posting_int
|| is now rounded off to currency precision
|| Sykrishn 01-NOV/2002 Gl Interface TD modifications...
|| The below history is nt valid as the local procedure is revamped completely
|| agairola 21 Apr 2002 Initialised the lrec_posting_int
|| for bugs 2326595, 2309929, 2310806
|| agairola 10-Apr-2002 Added the code for the printing of message in case of
|| no records being found and also for the common procedure
|| for logging messages for bugs 2326595, 2309929, 2310806
|| jbegum 25 Feb 02 As part of Enh bug # 2238226
|| Added column orig_appl_fee_ref to the
|| IGS_FI_POSTING_INT_PKG.insert_row
|| (reverse chronological order - newest change first)
*/
-- Get all the credit activity records, where GL_DATE lies b/w the passedg date ranges that have not been posted.
CURSOR cur_appl (cp_d_gl_date_start IN igs_fi_posting_int_all.accounting_date%TYPE,
cp_d_gl_date_end IN igs_fi_posting_int_all.accounting_date%TYPE ) IS
SELECT appl.rowid row_id, appl.*
FROM igs_fi_applications appl
WHERE appl.gl_date IS NOT NULL
AND TRUNC(appl.gl_date) BETWEEN TRUNC(cp_d_gl_date_start) AND TRUNC(cp_d_gl_date_end)
AND appl.posting_id IS NULL
AND appl.posting_control_id IS NULL
ORDER BY gl_date
FOR UPDATE OF gl_posted_date NOWAIT;
SELECT currency_cd
FROM igs_fi_credits
WHERE credit_id = cp_credit_id;
igs_fi_posting_int_pkg.insert_row (
x_rowid => l_v_posting_rowid,
x_posting_control_id => g_n_posting_control_id,
x_posting_id => l_n_posting_id,
x_batch_name => NULL,
x_accounting_date => app_rec.gl_date,
x_transaction_date => app_rec.apply_date,
x_currency_cd => l_v_currency_cd,
x_dr_account_cd => l_v_dr_account_cd,
x_cr_account_cd => l_v_cr_account_cd,
x_dr_gl_code_ccid => NULL,
x_cr_gl_code_ccid => NULL,
x_amount => igs_fi_gen_gl.get_formatted_amount(l_n_amount),
x_source_transaction_id => app_rec.application_id,
x_source_transaction_type => g_application,
x_status => g_todo,
x_orig_appl_fee_ref => NULL,
x_mode => 'R'
);
update_log_file
(p_txn_date => app_rec.apply_date,
p_amount => l_n_amount,
p_txn_id => app_rec.application_id,
p_dr_acc_code => l_v_dr_account_cd,
p_cr_acc_code => l_v_cr_account_cd,
p_src_txn_type => g_application);
igs_fi_applications_pkg.update_row(
x_rowid => app_rec.row_id,
x_application_id => app_rec.application_id,
x_application_type => app_rec.application_type,
x_invoice_id => app_rec.invoice_id,
x_credit_id => app_rec.credit_id,
x_credit_activity_id => app_rec.credit_activity_id,
x_amount_applied => app_rec.amount_applied,
x_apply_date => app_rec.apply_date,
x_link_application_id => app_rec.link_application_id,
x_dr_account_cd => app_rec.dr_account_cd,
x_cr_account_cd => app_rec.cr_account_cd,
x_dr_gl_code_ccid => app_rec.dr_gl_code_ccid,
x_cr_gl_code_ccid => app_rec.cr_gl_code_ccid,
x_applied_invoice_lines_id => app_rec.applied_invoice_lines_id,
x_appl_hierarchy_id => app_rec.appl_hierarchy_id,
x_posting_id => l_n_posting_id,
x_posting_control_id => g_n_posting_control_id,
x_gl_date => app_rec.gl_date,
x_gl_posted_date => p_d_gl_posted_date,
x_mode => 'R'
);
|| abshriva 12-May-2006 Enh#5217319 Precision Issue. Amount values being inserted into igs_fi_posting_int
|| and igs_fi_invln_int is now rounded off to currency precision
|| svuppala 30-MAY-2005 Enh 3442712 - Done the TBH modifications by adding
|| new columns Unit_Type_Id, Unit_Level in igs_fi_invln_int_all
|| Sykrishn 01-NOV/2002 Gl Interface TD modifications...
|| The below history is nt valid as the local procedure is revamped completely
|| agairola 21 Apr 2002 Initialised the lrec_posting_int
|| for bugs 2326595, 2309929, 2310806
|| agairola 10-Apr-2002 Added the code for the printing of message in case of
|| no records being found and also for the common procedure
|| for logging messages for bugs 2326595, 2309929, 2310806
|| jbegum 25 Feb 02 As part of Enh bug # 2238226
|| Added column orig_appl_fee_ref to the
|| IGS_FI_POSTING_INT_PKG.insert_row
|| (reverse chronological order - newest change first)
*/
-- Get all the invoice lines records, where GL_DATE lies b/w the passedg date ranges that have not been posted.
CURSOR cur_inv (cp_d_gl_date_start IN igs_fi_posting_int_all.accounting_date%TYPE,
cp_d_gl_date_end IN igs_fi_posting_int_all.accounting_date%TYPE ) IS
SELECT invln.rowid row_id, inv.invoice_creation_date, inv.currency_cd, invln.*
FROM igs_fi_invln_int_all invln,
igs_fi_inv_int_all inv
WHERE invln.gl_date IS NOT NULL
AND TRUNC(invln.gl_date) BETWEEN TRUNC(cp_d_gl_date_start) AND TRUNC(cp_d_gl_date_end)
AND invln.posting_id IS NULL
AND invln.posting_control_id IS NULL
AND inv.invoice_id = invln.invoice_id
AND NVL(invln.error_account,'N') = 'N'
ORDER BY gl_date
FOR UPDATE OF gl_posted_date NOWAIT;
igs_fi_posting_int_pkg.insert_row (
x_rowid => l_v_posting_rowid,
x_posting_control_id => g_n_posting_control_id,
x_posting_id => l_n_posting_id,
x_batch_name => NULL,
x_accounting_date => inv_rec.gl_date,
x_transaction_date => inv_rec.invoice_creation_date,
x_currency_cd => inv_rec.currency_cd,
x_dr_account_cd => l_v_dr_account_cd,
x_cr_account_cd => l_v_cr_account_cd,
x_dr_gl_code_ccid => NULL,
x_cr_gl_code_ccid => NULL,
x_amount => igs_fi_gen_gl.get_formatted_amount(l_n_amount),
x_source_transaction_id => inv_rec.invoice_lines_id,
x_source_transaction_type => g_charge,
x_status => g_todo,
x_orig_appl_fee_ref => NULL,
x_mode => 'R'
);
update_log_file
(p_txn_date => inv_rec.invoice_creation_date,
p_amount => l_n_amount,
p_txn_id => inv_rec.invoice_lines_id,
p_dr_acc_code => l_v_dr_account_cd,
p_cr_acc_code => l_v_cr_account_cd,
p_src_txn_type => g_charge);
igs_fi_invln_int_pkg.update_row(
x_rowid => inv_rec.row_id,
x_invoice_lines_id => inv_rec.invoice_lines_id,
x_invoice_id => inv_rec.invoice_id,
x_line_number => inv_rec.line_number,
x_s_chg_method_type => inv_rec.s_chg_method_type,
x_description => inv_rec.description,
x_chg_elements => inv_rec.chg_elements,
x_amount => igs_fi_gen_gl.get_formatted_amount(inv_rec.amount),
x_unit_attempt_status => inv_rec.unit_attempt_status,
x_eftsu => inv_rec.eftsu,
x_credit_points => inv_rec.credit_points,
x_attribute_category => inv_rec.attribute_category,
x_attribute1 => inv_rec.attribute1,
x_attribute2 => inv_rec.attribute2,
x_attribute3 => inv_rec.attribute3,
x_attribute4 => inv_rec.attribute4,
x_attribute5 => inv_rec.attribute5,
x_attribute6 => inv_rec.attribute6,
x_attribute7 => inv_rec.attribute7,
x_attribute8 => inv_rec.attribute8,
x_attribute9 => inv_rec.attribute9,
x_attribute10 => inv_rec.attribute10,
x_rec_account_cd => inv_rec.rec_account_cd,
x_rev_account_cd => inv_rec.rev_account_cd,
x_rec_gl_ccid => inv_rec.rec_gl_ccid,
x_rev_gl_ccid => inv_rec.rev_gl_ccid,
x_org_unit_cd => inv_rec.org_unit_cd,
x_posting_id => l_n_posting_id,
x_attribute11 => inv_rec.attribute11,
x_attribute12 => inv_rec.attribute12,
x_attribute13 => inv_rec.attribute13,
x_attribute14 => inv_rec.attribute14,
x_attribute15 => inv_rec.attribute15,
x_attribute16 => inv_rec.attribute16,
x_attribute17 => inv_rec.attribute17,
x_attribute18 => inv_rec.attribute18,
x_attribute19 => inv_rec.attribute19,
x_attribute20 => inv_rec.attribute20,
x_error_account => inv_rec.error_account,
x_error_string => inv_rec.error_string,
x_location_cd => inv_rec.location_cd,
x_uoo_id => inv_rec.uoo_id,
x_posting_control_id => g_n_posting_control_id,
x_gl_date => inv_rec.gl_date,
x_gl_posted_date => p_d_gl_posted_date,
x_mode => 'R',
x_unit_type_id => inv_rec.unit_type_id,
x_unit_level => inv_rec.unit_level
);
|| abshriva 12-May-2006 Enh#5217319 Precision Issue. Amount values being inserted into igs_fi_posting_int
|| is now rounded off to currency precision
|| vvutukur 09-Oct-2003 Bug#3160036.Replaced call to igs_ad_app_req.update_row with
|| call to igs_ad_gen_015.update_igs_ad_app_req.
|| pathipat 14-Jun-2003 Enh 2831587 Credit Card Fund Transfer build
|| Modified call to igs_ad_app_req_pkg.update_row()
|| Sykrishn 01-NOV/2002 Created this procedure - as part of Gl Interface TD modifications (NEW)
|| (reverse chronological order - newest change first)
*/
-- Get all the non-posted admission application fee records, where GL_DATE lies b/w the passedg date ranges that have not been posted.
-- Only posting control id needs to be checked in this case
CURSOR cur_adm_fee (cp_d_gl_date_start IN igs_fi_posting_int_all.accounting_date%TYPE,
cp_d_gl_date_end IN igs_fi_posting_int_all.accounting_date%TYPE ) IS
SELECT adm.rowid row_id,adm.*
FROM igs_ad_app_req adm
WHERE adm.gl_date IS NOT NULL
AND TRUNC(adm.gl_date) BETWEEN TRUNC(cp_d_gl_date_start) AND TRUNC(cp_d_gl_date_end)
AND adm.posting_control_id IS NULL
ORDER BY gl_date
FOR UPDATE OF gl_posted_date NOWAIT;
SELECT application_id
FROM igs_ad_appl
WHERE person_id = cp_person_id
AND admission_appl_number = cp_admission_appl_number;
igs_fi_posting_int_pkg.insert_row (
x_rowid => l_v_posting_rowid,
x_posting_control_id => g_n_posting_control_id,
x_posting_id => l_n_posting_id,
x_batch_name => NULL,
x_accounting_date => ad_app_rec.gl_date,
x_transaction_date => ad_app_rec.fee_date,
x_currency_cd => l_v_currency_cd,
x_dr_account_cd => ad_app_rec.cash_account_cd,
x_cr_account_cd => ad_app_rec.rev_account_cd,
x_dr_gl_code_ccid => NULL,
x_cr_gl_code_ccid => NULL,
x_amount => igs_fi_gen_gl.get_formatted_amount(ad_app_rec.fee_amount),
x_source_transaction_id => NULL,
x_source_transaction_type => g_applfee,
x_status => g_todo,
x_orig_appl_fee_ref => l_v_orig_appl_fee_ref,
x_mode => 'R'
);
update_log_file
(p_txn_date => ad_app_rec.fee_date,
p_amount => ad_app_rec.fee_amount,
p_txn_id => l_n_application_id,
p_dr_acc_code => ad_app_rec.cash_account_cd,
p_cr_acc_code => ad_app_rec.rev_account_cd,
p_src_txn_type => g_applfee);
igs_ad_gen_015.update_igs_ad_app_req(
p_rowid => ad_app_rec.row_id,
p_app_req_id => ad_app_rec.app_req_id,
p_person_id => ad_app_rec.person_id,
p_admission_appl_number => ad_app_rec.admission_appl_number,
p_applicant_fee_type => ad_app_rec.applicant_fee_type,
p_applicant_fee_status => ad_app_rec.applicant_fee_status,
p_fee_date => ad_app_rec.fee_date,
p_fee_payment_method => ad_app_rec.fee_payment_method,
p_fee_amount => ad_app_rec.fee_amount,
p_reference_num => ad_app_rec.reference_num,
p_credit_card_code => ad_app_rec.credit_card_code,
p_credit_card_holder_name => ad_app_rec.credit_card_holder_name,
p_credit_card_number => ad_app_rec.credit_card_number,
p_credit_card_expiration_date => ad_app_rec.credit_card_expiration_date,
p_rev_gl_ccid => ad_app_rec.rev_gl_ccid,
p_cash_gl_ccid => ad_app_rec.cash_gl_ccid,
p_rev_account_cd => ad_app_rec.rev_account_cd,
p_cash_account_cd => ad_app_rec.cash_account_cd,
p_posting_control_id => g_n_posting_control_id,
p_gl_date => ad_app_rec.gl_date,
p_gl_posted_date => p_d_gl_posted_date,
p_credit_card_tangible_cd => ad_app_rec.credit_card_tangible_cd,
p_credit_card_payee_cd => ad_app_rec.credit_card_payee_cd,
p_credit_card_status_code => ad_app_rec.credit_card_status_code,
p_mode => 'R'
);
|| Purpose : To Derive the comments for insert
|| Known limitations, enhancements or remarks :
|| Change History :
|| Who When What
|| agairola 21 Apr 2002 Added the new out NOCOPY parameter transaction number for the
|| transaction number derivation for bugs 2326595, 2309929,
|| 2310806
|| sykrishn 18-FEB-2002 As per build of SFCR023 - 2227831
||
|| (reverse chronological order - newest change first)
*/
--Cursor to fetch the invoice number for the passed invoice_id
CURSOR cur_charge (cp_transaction_id IN igs_fi_posting_int_all.source_transaction_id%TYPE) IS
SELECT inv.invoice_number
FROM igs_fi_inv_int inv, igs_fi_invln_int invln
WHERE invln.invoice_lines_id = cp_transaction_id
AND inv.invoice_id = invln.invoice_id;
SELECT crd.credit_number
FROM igs_fi_credits crd,
igs_fi_cr_activities cra
WHERE cra.credit_activity_id = cp_transaction_id
AND crd.credit_id = cra.credit_id;
SELECT crd.credit_number,
inv.invoice_number
FROM igs_fi_applications app,
igs_fi_credits crd,
igs_fi_inv_int inv
WHERE application_id = cp_transaction_id
AND app.credit_id = crd.credit_id
AND app.invoice_id = inv.invoice_id;
|| cur_postings as cur_postings has a FOR UPDATE NOWAIT clause
|| for bugs 2326595, 2309929, 2310806
|| agairola 10_Apr-2002 Modified the cursor cur_postings to include brackets for
|| Batch name. Also, added the FOR UPDATE NOWAIT, exception and
|| appropriate exception handling for the locking. Removed the
|| commit from inside the begin end block for inserting records
|| in the RA_INTERFACE_LINES_ALL table.
|| for bugs 2326595, 2309929, 2310806
|| jbegum 25 Feb 02 As part of Enh bug #2238226
|| Added code to copy value of the field orig_appl_fee_ref to
|| comments field of RA_INTERFACE_LINES_ALL when
|| source_transaction_type is APPLFEE
|| Added column orig_appl_fee_ref to the
|| IGS_FI_POSTING_INT_PKG.update_row
|| sykrishn 19 Feb 02 As part of Enh bug #2227831
|| Changes related to get_customer_details
|| jbegum 16 Feb 02 As part of Enh bug #2222272
|| Set org id of transactions created
|| in the Receivables Invoice Interface tables
|| to the org id value obtained from control table
|| (reverse chronological order - newest change first)
*/
BEGIN
-- This process has been obsoleted as part of Commercial Receivables TD
fnd_message.set_name('IGS', 'IGS_GE_OBSOLETE_JOB');
SELECT igs_fi_posting_control_s.nextval
FROM dual;