eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.JAI_CMN_RGM_RECORDING_PKG dependencies on GL_INTERFACE

Line 23: - POST_ACCOUNTING : Inserts an Entry into GL_INTERFACE and Localization Subledger for the inputs passed to the call

19:
20: - GET_PERIOD_NAME : Returns the period_name for which the entry is being made. This also returns the accounting_date as
21: first_date of next open period, if the period corresponding to input accounting date is closed
22:
23: - POST_ACCOUNTING : Inserts an Entry into GL_INTERFACE and Localization Subledger for the inputs passed to the call
24:
25: - INSERT_REFERENCE : Called from AP and AR Processing to insert data related to related Invoices
26:
27: - UPDATE_REFERENCE : Called from AP and AR Processing to update revocovered and discounted amounts for the invoice

Line 72: .user_je_category_name that is populated into GL_INTERFACE as jai_constants.je_category_rg_entry ('Register India')

68:
69: 4 19/03/2005 Vijay Shankar for Bug#4250236(4245089). FileVersion: 115.3
70: .added two new procedure insert_vat_repository_entry and do_vat_accounting, a function get_rgm_attribute_value
71: as part of VAT Impl.
72: .user_je_category_name that is populated into GL_INTERFACE as jai_constants.je_category_rg_entry ('Register India')
73:
74: * This is a Dependant Bug for future Versions of the Object *
75:
76: 5. 08-Jun-2005 File Version 116.2 Object is Modified to refer to New DB Entity names in place of Old DB Entity Names

Line 192: Reason being - organziation id was inserted in the reference1 column of gl_interface table.

188: 16. 07/12/2007 ssumaith - bug# 6664855 - file version - 120.3.12000000.5.
189: Issue :-
190: When service tax distribution is done between two inventory organizations,
191: it was causing the unbalances gl entries.
192: Reason being - organziation id was inserted in the reference1 column of gl_interface table.
193: The organization id was entered as source orgn id for source org entries and destination orgn id
194: for des orgn entries as a result, there was only debits or credits for one orgn because referenc1 column
195: is also in the used in the grouping logic.
196:

Line 867: lv_reference10 GL_INTERFACE.reference10%type;

863:
864: /* Added by Ramananda for bug#4407165 */
865: lv_object_name CONSTANT VARCHAR2(61) := 'jai_cmn_rgm_recording_pkg.post_accounting';
866:
867: lv_reference10 GL_INTERFACE.reference10%type;
868: lv_reference23 GL_INTERFACE.reference23%type;
869: lv_reference24 GL_INTERFACE.reference24%type;
870: lv_reference25 GL_INTERFACE.reference25%type;
871: lv_reference26 GL_INTERFACE.reference26%type;

Line 868: lv_reference23 GL_INTERFACE.reference23%type;

864: /* Added by Ramananda for bug#4407165 */
865: lv_object_name CONSTANT VARCHAR2(61) := 'jai_cmn_rgm_recording_pkg.post_accounting';
866:
867: lv_reference10 GL_INTERFACE.reference10%type;
868: lv_reference23 GL_INTERFACE.reference23%type;
869: lv_reference24 GL_INTERFACE.reference24%type;
870: lv_reference25 GL_INTERFACE.reference25%type;
871: lv_reference26 GL_INTERFACE.reference26%type;
872:

Line 869: lv_reference24 GL_INTERFACE.reference24%type;

865: lv_object_name CONSTANT VARCHAR2(61) := 'jai_cmn_rgm_recording_pkg.post_accounting';
866:
867: lv_reference10 GL_INTERFACE.reference10%type;
868: lv_reference23 GL_INTERFACE.reference23%type;
869: lv_reference24 GL_INTERFACE.reference24%type;
870: lv_reference25 GL_INTERFACE.reference25%type;
871: lv_reference26 GL_INTERFACE.reference26%type;
872:
873: ld_accounting_date DATE;

Line 870: lv_reference25 GL_INTERFACE.reference25%type;

866:
867: lv_reference10 GL_INTERFACE.reference10%type;
868: lv_reference23 GL_INTERFACE.reference23%type;
869: lv_reference24 GL_INTERFACE.reference24%type;
870: lv_reference25 GL_INTERFACE.reference25%type;
871: lv_reference26 GL_INTERFACE.reference26%type;
872:
873: ld_accounting_date DATE;
874: lv_message VARCHAR2(100);

Line 871: lv_reference26 GL_INTERFACE.reference26%type;

867: lv_reference10 GL_INTERFACE.reference10%type;
868: lv_reference23 GL_INTERFACE.reference23%type;
869: lv_reference24 GL_INTERFACE.reference24%type;
870: lv_reference25 GL_INTERFACE.reference25%type;
871: lv_reference26 GL_INTERFACE.reference26%type;
872:
873: ld_accounting_date DATE;
874: lv_message VARCHAR2(100);
875:

Line 889: lv_status gl_interface.status%TYPE ; --rchandan for bug#4428980

885: lv_regime_code JAI_RGM_DEFINITIONS.regime_code%TYPE;
886: lv_reference_name VARCHAR2(30);
887: ln_reference_id NUMBER(15);
888: lv_gl_je_category varchar2(30); --File.Sql.35 Cbabu jai_constants.je_category_rg_entry%type;
889: lv_status gl_interface.status%TYPE ; --rchandan for bug#4428980
890: lv_source_name VARCHAR2(30); -- modified by csahoo for bug#6155839
891: /*Begin-Added the following by kunkumar for forward porting 5051541 to R12*/
892:
893:

Line 926: lv_reference1 gl_interface.reference1%TYPE ;

922:
923:
924: lv_source jai_rgm_trx_records.source%TYPE ;
925: lv_src_party_id jai_rgm_dis_src_hdrs.party_id%TYPE ;
926: lv_reference1 gl_interface.reference1%TYPE ;
927: ln_loop_cnt NUMBER;
928:
929: -- end, ssumaith for Bug 6664855
930:

Line 1028: jai_cmn_utils_pkg.print_log('6395039.log', 'before insert inot gl_interface');

1024:
1025: /* following added by Vijay Shankar for Bug#4250236(4245089). VAT Impl. */
1026: lv_gl_je_category := jai_constants.je_category_rg_entry;
1027: lv_status := 'NEW';--rchandan for bug#4428980
1028: jai_cmn_utils_pkg.print_log('6395039.log', 'before insert inot gl_interface');
1029: INSERT INTO gl_interface (
1030: status, set_of_books_id, user_je_source_name, user_je_category_name,
1031: accounting_date, currency_code, date_created, created_by,
1032: actual_flag, entered_cr, entered_dr, accounted_cr, accounted_dr, transaction_date,

Line 1029: INSERT INTO gl_interface (

1025: /* following added by Vijay Shankar for Bug#4250236(4245089). VAT Impl. */
1026: lv_gl_je_category := jai_constants.je_category_rg_entry;
1027: lv_status := 'NEW';--rchandan for bug#4428980
1028: jai_cmn_utils_pkg.print_log('6395039.log', 'before insert inot gl_interface');
1029: INSERT INTO gl_interface (
1030: status, set_of_books_id, user_je_source_name, user_je_category_name,
1031: accounting_date, currency_code, date_created, created_by,
1032: actual_flag, entered_cr, entered_dr, accounted_cr, accounted_dr, transaction_date,
1033: code_combination_id, currency_conversion_date, user_currency_conversion_type, currency_conversion_rate,

Line 1046: jai_cmn_utils_pkg.print_log('6395039.log', 'after insert inot gl_interface');

1042: -- commented lv_organization_code and passed refererence1 ssumaith bug#6664855
1043: --Bug 5051541 kunkumar
1044: p_source_table_name, p_source_document_id, p_repository_name, p_organization_id
1045: );
1046: jai_cmn_utils_pkg.print_log('6395039.log', 'after insert inot gl_interface');
1047: IF p_reference_id IS NOT NULL OR p_reference_name IS NOT NULL THEN
1048: lv_reference_name := p_reference_name;
1049: ln_reference_id := p_reference_id;
1050: ELSE