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_PA_BILLING_PKG dependencies on JAI_CMN_JOURNAL_ENTRIES

Line 12: Insert statement for JAI_CMN_JOURNAL_ENTRIES modified to insert into column JOURNAL_ENTRY_ID

8: Forward ported from R11i to R12
9: Package created for Projects Billing Implementation.
10: Initially the code is added to handle VAT and Excise taxes processing
11: 2 18-Ayg-2007 brathod, Bug# 6012570, File Version 120.1
12: Insert statement for JAI_CMN_JOURNAL_ENTRIES modified to insert into column JOURNAL_ENTRY_ID
13:
14: 3. 04-Sep-2007 Bgowrava for Bug#6012570, File Version 120.3
15: Assigned the gl source for project accounting to the newly seeded gl source
16: 'Projects India'.

Line 130: gl_entry.source := 'PROJECTS'; -- JAI_CMN_JOURNAL_ENTRIES.source%type,

126: gl_entry.reference_table := 'JAI_PA_DRAFT_INVOICES'; -- gl_interface.reference24%TYPE, -- 'jai_mtl_trxs',
127: gl_entry.reference_column := 'DRAFT_INVOICE_ID'; -- gl_interface.reference25%TYPE, -- p_transaction_temp_id,
128: gl_entry.reference_id := ; -- gl_interface.reference26%TYPE, -- 'transaction_temp_id',
129: gl_entry.organization_id := ; -- gl_interface.reference27%TYPE, -- to_char(p_params(i).organization_id)
130: gl_entry.source := 'PROJECTS'; -- JAI_CMN_JOURNAL_ENTRIES.source%type,
131: gl_entry.source_table_name := 'PA_DRAFT_INVOICES_ALL'; -- JAI_CMN_JOURNAL_ENTRIES.source_table_name%type,
132: gl_entry.source_document_id := ; -- JAI_CMN_JOURNAL_ENTRIES.source_trx_id%type
133:
134:

Line 131: gl_entry.source_table_name := 'PA_DRAFT_INVOICES_ALL'; -- JAI_CMN_JOURNAL_ENTRIES.source_table_name%type,

127: gl_entry.reference_column := 'DRAFT_INVOICE_ID'; -- gl_interface.reference25%TYPE, -- p_transaction_temp_id,
128: gl_entry.reference_id := ; -- gl_interface.reference26%TYPE, -- 'transaction_temp_id',
129: gl_entry.organization_id := ; -- gl_interface.reference27%TYPE, -- to_char(p_params(i).organization_id)
130: gl_entry.source := 'PROJECTS'; -- JAI_CMN_JOURNAL_ENTRIES.source%type,
131: gl_entry.source_table_name := 'PA_DRAFT_INVOICES_ALL'; -- JAI_CMN_JOURNAL_ENTRIES.source_table_name%type,
132: gl_entry.source_document_id := ; -- JAI_CMN_JOURNAL_ENTRIES.source_trx_id%type
133:
134:
135: Entry 2 for ExciseEducation Cess

Line 132: gl_entry.source_document_id := ; -- JAI_CMN_JOURNAL_ENTRIES.source_trx_id%type

128: gl_entry.reference_id := ; -- gl_interface.reference26%TYPE, -- 'transaction_temp_id',
129: gl_entry.organization_id := ; -- gl_interface.reference27%TYPE, -- to_char(p_params(i).organization_id)
130: gl_entry.source := 'PROJECTS'; -- JAI_CMN_JOURNAL_ENTRIES.source%type,
131: gl_entry.source_table_name := 'PA_DRAFT_INVOICES_ALL'; -- JAI_CMN_JOURNAL_ENTRIES.source_table_name%type,
132: gl_entry.source_document_id := ; -- JAI_CMN_JOURNAL_ENTRIES.source_trx_id%type
133:
134:
135: Entry 2 for ExciseEducation Cess
136: gl_entry.amount := zzz;

Line 206: INSERT INTO JAI_CMN_JOURNAL_ENTRIES(

202: pr_gl_entry.reference_table, -- reference26, 'transaction_temp_id',
203: pr_gl_entry.organization_id -- reference27 to_char(p_params(i).organization_id)
204: );
205:
206: INSERT INTO JAI_CMN_JOURNAL_ENTRIES(
207: journal_entry_id,
208: regime_code,
209: organization_id,
210: set_of_books_id,

Line 230: jai_cmn_journal_entries_s.nextval,

226: last_update_date,
227: last_updated_by,
228: last_update_login
229: ) VALUES (
230: jai_cmn_journal_entries_s.nextval,
231: pr_gl_entry.regime_code,
232: pr_gl_entry.organization_id,
233: pr_gl_entry.set_of_books_id,
234: pr_gl_entry.tax_type,

Line 313: INSERT INTO jai_cmn_journal_entries(

309: pr_gl_entry.organization_id -- reference27 to_char(p_params(i).organization_id)
310: );
311:
312:
313: INSERT INTO jai_cmn_journal_entries(
314: JOURNAL_ENTRY_ID,
315: regime_code,
316: organization_id,
317: set_of_books_id,

Line 337: JAI_CMN_JOURNAL_ENTRIES_S.NEXTVAL,

333: last_update_date,
334: last_updated_by,
335: last_update_login
336: ) VALUES (
337: JAI_CMN_JOURNAL_ENTRIES_S.NEXTVAL,
338: pr_gl_entry.regime_code,
339: pr_gl_entry.organization_id,
340: pr_gl_entry.set_of_books_id,
341: pr_gl_entry.tax_type,

Line 1184: r_gl_entry.source := jai_pa_billing_pkg.gv_source_projects; -- JAI_CMN_JOURNAL_ENTRIES.source%type,

1180: r_gl_entry.reference_table := 'PROJECT_ID:'||r_jai_pa_draft_invoices.project_id; -- gl_interface.reference24%TYPE, -- 'jai_mtl_trxs',
1181: r_gl_entry.reference_column := 'DRAFT_INVOICE_NUM'; -- gl_interface.reference25%TYPE, -- p_transaction_temp_id,
1182: r_gl_entry.reference_id := r_jai_pa_draft_invoices.draft_invoice_num; -- gl_interface.reference26%TYPE, -- 'transaction_temp_id',
1183: r_gl_entry.organization_id := r_jai_pa_draft_invoices.organization_id; -- gl_interface.reference27%TYPE, -- to_char(p_params(i).organization_id)
1184: r_gl_entry.source := jai_pa_billing_pkg.gv_source_projects; -- JAI_CMN_JOURNAL_ENTRIES.source%type,
1185: r_gl_entry.source_table_name := jai_pa_billing_pkg.gv_draft_invoice_table; -- JAI_CMN_JOURNAL_ENTRIES.source_table_name%type,
1186: r_gl_entry.source_document_id := r_jai_pa_draft_invoices.draft_invoice_id; -- JAI_CMN_JOURNAL_ENTRIES.source_trx_id%type
1187:
1188: if jai_pa_billing_pkg.gv_debug then

Line 1185: r_gl_entry.source_table_name := jai_pa_billing_pkg.gv_draft_invoice_table; -- JAI_CMN_JOURNAL_ENTRIES.source_table_name%type,

1181: r_gl_entry.reference_column := 'DRAFT_INVOICE_NUM'; -- gl_interface.reference25%TYPE, -- p_transaction_temp_id,
1182: r_gl_entry.reference_id := r_jai_pa_draft_invoices.draft_invoice_num; -- gl_interface.reference26%TYPE, -- 'transaction_temp_id',
1183: r_gl_entry.organization_id := r_jai_pa_draft_invoices.organization_id; -- gl_interface.reference27%TYPE, -- to_char(p_params(i).organization_id)
1184: r_gl_entry.source := jai_pa_billing_pkg.gv_source_projects; -- JAI_CMN_JOURNAL_ENTRIES.source%type,
1185: r_gl_entry.source_table_name := jai_pa_billing_pkg.gv_draft_invoice_table; -- JAI_CMN_JOURNAL_ENTRIES.source_table_name%type,
1186: r_gl_entry.source_document_id := r_jai_pa_draft_invoices.draft_invoice_id; -- JAI_CMN_JOURNAL_ENTRIES.source_trx_id%type
1187:
1188: if jai_pa_billing_pkg.gv_debug then
1189: jai_cmn_utils_pkg.print_log ( jai_pa_billing_pkg.file, '18 process_excise. Before insert_gl_entry- Excise');

Line 1186: r_gl_entry.source_document_id := r_jai_pa_draft_invoices.draft_invoice_id; -- JAI_CMN_JOURNAL_ENTRIES.source_trx_id%type

1182: r_gl_entry.reference_id := r_jai_pa_draft_invoices.draft_invoice_num; -- gl_interface.reference26%TYPE, -- 'transaction_temp_id',
1183: r_gl_entry.organization_id := r_jai_pa_draft_invoices.organization_id; -- gl_interface.reference27%TYPE, -- to_char(p_params(i).organization_id)
1184: r_gl_entry.source := jai_pa_billing_pkg.gv_source_projects; -- JAI_CMN_JOURNAL_ENTRIES.source%type,
1185: r_gl_entry.source_table_name := jai_pa_billing_pkg.gv_draft_invoice_table; -- JAI_CMN_JOURNAL_ENTRIES.source_table_name%type,
1186: r_gl_entry.source_document_id := r_jai_pa_draft_invoices.draft_invoice_id; -- JAI_CMN_JOURNAL_ENTRIES.source_trx_id%type
1187:
1188: if jai_pa_billing_pkg.gv_debug then
1189: jai_cmn_utils_pkg.print_log ( jai_pa_billing_pkg.file, '18 process_excise. Before insert_gl_entry- Excise');
1190: end if;