[Home] [Help]
231: Issue: For Advance Receipt Reversal, GL INTERFACE SHOULD USE RECEIPT REVERSAL GL DATE AS ACCOUNTING DATE
232: Fixed: Add CURSOR cur_get_rcpt_reversal_gl_date to get receipt reversal gl date.
233:
234: 34. 12-Jan-2012 Qinglei for Bug#13557031
235: Issue: When Advance Receipt Confirmation and Reversal, wrong transacton date inserted into ra_interface_lines_all.
236: Fixed: When Receipt confirm, use receipt date insert into ar interface table; when receipt reversal, use reversal date
237: insert into ar interface table.
238: Rounded the amount inserted into ar interface table.
239: 35. 12-Jan-2012 Qiong for bug#13540741 ST repository review shouldn't use transaction date for query
5193: ln_ccid_tax_type NUMBER;
5194: rec_cur_get_batch_source CUR_GET_BATCH_SOURCE%ROWTYPE;
5195: lv_set_of_books_id HR_OPERATING_UNITS.SET_OF_BOOKS_ID%TYPE;
5196: ln_amount NUMBER;
5197: ln_user_id ra_interface_lines_all.CREATED_BY%TYPE;
5198: ln_login_id ra_interface_lines_all.LAST_UPDATE_LOGIN%TYPE;
5199: lv_process_message VARCHAR2(4000);
5200:
5201: rec_cur_get_cr_details JAI_AR_CASH_RECEIPTS_ALL%ROWTYPE;
5194: rec_cur_get_batch_source CUR_GET_BATCH_SOURCE%ROWTYPE;
5195: lv_set_of_books_id HR_OPERATING_UNITS.SET_OF_BOOKS_ID%TYPE;
5196: ln_amount NUMBER;
5197: ln_user_id ra_interface_lines_all.CREATED_BY%TYPE;
5198: ln_login_id ra_interface_lines_all.LAST_UPDATE_LOGIN%TYPE;
5199: lv_process_message VARCHAR2(4000);
5200:
5201: rec_cur_get_cr_details JAI_AR_CASH_RECEIPTS_ALL%ROWTYPE;
5202: rec_cur_get_rcpt_taxes cur_get_rcpt_taxes%ROWTYPE;
5199: lv_process_message VARCHAR2(4000);
5200:
5201: rec_cur_get_cr_details JAI_AR_CASH_RECEIPTS_ALL%ROWTYPE;
5202: rec_cur_get_rcpt_taxes cur_get_rcpt_taxes%ROWTYPE;
5203: rec_ra_interface_lines ra_interface_lines_all%ROWTYPE;
5204: rec_ra_interface_dist ra_interface_distributions_all%ROWTYPE;
5205: ln_rcpt_amount NUMBER;
5206: ln_rcpt_tax_amount NUMBER;
5207: ln_rcpt_tran_tax_amount NUMBER;
5575: END generate_documents;
5576:
5577: --========================================================================
5578: -- PROCEDURE : generate_docuements PUBLIC
5579: -- PARAMETERS: p_rila rowtype of ra_interface_lines_all
5580: -- : p_rida rowtype of ra_interface_distributions_all
5581: -- : pn_regime_id
5582: -- : pn_organization_id
5583: -- : pn_location_id
5589: -- EXCEPTIONS:
5590: --
5591: --========================================================================
5592: PROCEDURE generate_cm_dm
5593: ( p_rila IN ra_interface_lines_all%ROWTYPE
5594: ,p_rida IN ra_interface_distributions_all%ROWTYPE
5595: ,pn_regime_id IN NUMBER
5596: ,pn_organization_id IN NUMBER
5597: ,pn_location_id IN NUMBER
5613: p_process_flag := lv_process_flag;
5614: p_process_message := lv_process_message;
5615:
5616: /*################################################################################################################
5617: || INSERT INTO RA_INTERFACE_LINES_ALL TABLE
5618: ################################################################################################################*/
5619: INSERT INTO ra_interface_lines_all
5620: (
5621: interface_line_id,
5615:
5616: /*################################################################################################################
5617: || INSERT INTO RA_INTERFACE_LINES_ALL TABLE
5618: ################################################################################################################*/
5619: INSERT INTO ra_interface_lines_all
5620: (
5621: interface_line_id,
5622: amount,
5623: description,