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 143: gl_entry.source := 'PROJECTS'; -- JAI_CMN_JOURNAL_ENTRIES.source%type,

139: gl_entry.reference_table := 'JAI_PA_DRAFT_INVOICES'; -- gl_interface.reference24%TYPE, -- 'jai_mtl_trxs',
140: gl_entry.reference_column := 'DRAFT_INVOICE_ID'; -- gl_interface.reference25%TYPE, -- p_transaction_temp_id,
141: gl_entry.reference_id := ; -- gl_interface.reference26%TYPE, -- 'transaction_temp_id',
142: gl_entry.organization_id := ; -- gl_interface.reference27%TYPE, -- to_char(p_params(i).organization_id)
143: gl_entry.source := 'PROJECTS'; -- JAI_CMN_JOURNAL_ENTRIES.source%type,
144: gl_entry.source_table_name := 'PA_DRAFT_INVOICES_ALL'; -- JAI_CMN_JOURNAL_ENTRIES.source_table_name%type,
145: gl_entry.source_document_id := ; -- JAI_CMN_JOURNAL_ENTRIES.source_trx_id%type
146:
147:

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

140: gl_entry.reference_column := 'DRAFT_INVOICE_ID'; -- gl_interface.reference25%TYPE, -- p_transaction_temp_id,
141: gl_entry.reference_id := ; -- gl_interface.reference26%TYPE, -- 'transaction_temp_id',
142: gl_entry.organization_id := ; -- gl_interface.reference27%TYPE, -- to_char(p_params(i).organization_id)
143: gl_entry.source := 'PROJECTS'; -- JAI_CMN_JOURNAL_ENTRIES.source%type,
144: gl_entry.source_table_name := 'PA_DRAFT_INVOICES_ALL'; -- JAI_CMN_JOURNAL_ENTRIES.source_table_name%type,
145: gl_entry.source_document_id := ; -- JAI_CMN_JOURNAL_ENTRIES.source_trx_id%type
146:
147:
148: Entry 2 for ExciseEducation Cess

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

141: gl_entry.reference_id := ; -- gl_interface.reference26%TYPE, -- 'transaction_temp_id',
142: gl_entry.organization_id := ; -- gl_interface.reference27%TYPE, -- to_char(p_params(i).organization_id)
143: gl_entry.source := 'PROJECTS'; -- JAI_CMN_JOURNAL_ENTRIES.source%type,
144: gl_entry.source_table_name := 'PA_DRAFT_INVOICES_ALL'; -- JAI_CMN_JOURNAL_ENTRIES.source_table_name%type,
145: gl_entry.source_document_id := ; -- JAI_CMN_JOURNAL_ENTRIES.source_trx_id%type
146:
147:
148: Entry 2 for ExciseEducation Cess
149: gl_entry.amount := zzz;

Line 219: INSERT INTO JAI_CMN_JOURNAL_ENTRIES(

215: pr_gl_entry.reference_table, -- reference26, 'transaction_temp_id',
216: pr_gl_entry.organization_id -- reference27 to_char(p_params(i).organization_id)
217: );
218:
219: INSERT INTO JAI_CMN_JOURNAL_ENTRIES(
220: journal_entry_id,
221: regime_code,
222: organization_id,
223: set_of_books_id,

Line 243: jai_cmn_journal_entries_s.nextval,

239: last_update_date,
240: last_updated_by,
241: last_update_login
242: ) VALUES (
243: jai_cmn_journal_entries_s.nextval,
244: pr_gl_entry.regime_code,
245: pr_gl_entry.organization_id,
246: pr_gl_entry.set_of_books_id,
247: pr_gl_entry.tax_type,

Line 326: INSERT INTO jai_cmn_journal_entries(

322: pr_gl_entry.organization_id -- reference27 to_char(p_params(i).organization_id)
323: );
324:
325:
326: INSERT INTO jai_cmn_journal_entries(
327: JOURNAL_ENTRY_ID,
328: regime_code,
329: organization_id,
330: set_of_books_id,

Line 350: JAI_CMN_JOURNAL_ENTRIES_S.NEXTVAL,

346: last_update_date,
347: last_updated_by,
348: last_update_login
349: ) VALUES (
350: JAI_CMN_JOURNAL_ENTRIES_S.NEXTVAL,
351: pr_gl_entry.regime_code,
352: pr_gl_entry.organization_id,
353: pr_gl_entry.set_of_books_id,
354: pr_gl_entry.tax_type,

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

1216: r_gl_entry.reference_table := 'PROJECT_ID:'||r_jai_pa_draft_invoices.project_id; -- gl_interface.reference24%TYPE, -- 'jai_mtl_trxs',
1217: r_gl_entry.reference_column := 'DRAFT_INVOICE_NUM'; -- gl_interface.reference25%TYPE, -- p_transaction_temp_id,
1218: r_gl_entry.reference_id := r_jai_pa_draft_invoices.draft_invoice_num; -- gl_interface.reference26%TYPE, -- 'transaction_temp_id',
1219: r_gl_entry.organization_id := r_jai_pa_draft_invoices.organization_id; -- gl_interface.reference27%TYPE, -- to_char(p_params(i).organization_id)
1220: r_gl_entry.source := jai_pa_billing_pkg.gv_source_projects; -- JAI_CMN_JOURNAL_ENTRIES.source%type,
1221: r_gl_entry.source_table_name := jai_pa_billing_pkg.gv_draft_invoice_table; -- JAI_CMN_JOURNAL_ENTRIES.source_table_name%type,
1222: r_gl_entry.source_document_id := r_jai_pa_draft_invoices.draft_invoice_id; -- JAI_CMN_JOURNAL_ENTRIES.source_trx_id%type
1223:
1224: if jai_pa_billing_pkg.gv_debug then

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

1217: r_gl_entry.reference_column := 'DRAFT_INVOICE_NUM'; -- gl_interface.reference25%TYPE, -- p_transaction_temp_id,
1218: r_gl_entry.reference_id := r_jai_pa_draft_invoices.draft_invoice_num; -- gl_interface.reference26%TYPE, -- 'transaction_temp_id',
1219: r_gl_entry.organization_id := r_jai_pa_draft_invoices.organization_id; -- gl_interface.reference27%TYPE, -- to_char(p_params(i).organization_id)
1220: r_gl_entry.source := jai_pa_billing_pkg.gv_source_projects; -- JAI_CMN_JOURNAL_ENTRIES.source%type,
1221: r_gl_entry.source_table_name := jai_pa_billing_pkg.gv_draft_invoice_table; -- JAI_CMN_JOURNAL_ENTRIES.source_table_name%type,
1222: r_gl_entry.source_document_id := r_jai_pa_draft_invoices.draft_invoice_id; -- JAI_CMN_JOURNAL_ENTRIES.source_trx_id%type
1223:
1224: if jai_pa_billing_pkg.gv_debug then
1225: jai_cmn_utils_pkg.print_log ( jai_pa_billing_pkg.file, '18 process_excise. Before insert_gl_entry- Excise');

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

1218: r_gl_entry.reference_id := r_jai_pa_draft_invoices.draft_invoice_num; -- gl_interface.reference26%TYPE, -- 'transaction_temp_id',
1219: r_gl_entry.organization_id := r_jai_pa_draft_invoices.organization_id; -- gl_interface.reference27%TYPE, -- to_char(p_params(i).organization_id)
1220: r_gl_entry.source := jai_pa_billing_pkg.gv_source_projects; -- JAI_CMN_JOURNAL_ENTRIES.source%type,
1221: r_gl_entry.source_table_name := jai_pa_billing_pkg.gv_draft_invoice_table; -- JAI_CMN_JOURNAL_ENTRIES.source_table_name%type,
1222: r_gl_entry.source_document_id := r_jai_pa_draft_invoices.draft_invoice_id; -- JAI_CMN_JOURNAL_ENTRIES.source_trx_id%type
1223:
1224: if jai_pa_billing_pkg.gv_debug then
1225: jai_cmn_utils_pkg.print_log ( jai_pa_billing_pkg.file, '18 process_excise. Before insert_gl_entry- Excise');
1226: end if;