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 GL_INTERFACE

Line 34: GL Interface Entry.

30: and GL Entry
31: Fix:
32: + Added paramerter pr_pa_draft_invoices_all to process_vat to fetch GL date of Draft Invoice
33: + Used the GL Date of PA Draft Invoice to generate Excise Invoice Date, VAT Invoice Date and
34: GL Interface Entry.
35: ------------------------------------------------------------------------------------------------------------------------------*/
36: --
37: -- Forward declaration of private procedures
38: --

Line 125: gl_entry.debit_ccid := excise_debit_accnt; -- gl_interface.code_combination_id%TYPE,

121:
122: /* Sample GL_ENTRY
123: gl_entry.debit_amount := null;
124: gl_entry.credit_amount := xxx;
125: gl_entry.debit_ccid := excise_debit_accnt; -- gl_interface.code_combination_id%TYPE,
126: gl_entry.credit_ccid := ; --gl_interface.code_combination_id%TYPE,
127: gl_entry.regime_code := 'EXCISE'; -- varchar2(30),
128: gl_entry.tax_type := null; -- varchar2(30),
129: gl_entry.je_source := 'Project Accounting'; -- gl_je_headers.je_source%type,

Line 126: gl_entry.credit_ccid := ; --gl_interface.code_combination_id%TYPE,

122: /* Sample GL_ENTRY
123: gl_entry.debit_amount := null;
124: gl_entry.credit_amount := xxx;
125: gl_entry.debit_ccid := excise_debit_accnt; -- gl_interface.code_combination_id%TYPE,
126: gl_entry.credit_ccid := ; --gl_interface.code_combination_id%TYPE,
127: gl_entry.regime_code := 'EXCISE'; -- varchar2(30),
128: gl_entry.tax_type := null; -- varchar2(30),
129: gl_entry.je_source := 'Project Accounting'; -- gl_je_headers.je_source%type,
130: gl_entry.je_category := 'Register Data Entry'; -- gl_je_headers.je_category%type,

Line 136: gl_entry.organization_code := ; -- gl_interface.reference1%TYPE, -- p_params(i).organization_code,

132: gl_entry.currency_code := jai_constants.func_curr; -- gl_currencies.currency_code%type,
133: gl_entry.currency_conv_rate := null; -- number,
134: gl_entry.currency_conv_date := null; -- date,
135: gl_entry.accounting_date := sysdate; -- date,
136: gl_entry.organization_code := ; -- gl_interface.reference1%TYPE, -- p_params(i).organization_code,
137: gl_entry.description := 'India Localization Entry for Projects Draft Invoice'; -- gl_interface.reference10%TYPE, -- 'India Localization Entry for Interorg-XFER ',
138: gl_entry.called_from := <'jai_pa_billing_pkg.excise>; -- gl_interface.reference23%TYPE, -- 'jai_mtl_trx_pkg.do_cenvat_Acctg',
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,

Line 137: gl_entry.description := 'India Localization Entry for Projects Draft Invoice'; -- gl_interface.reference10%TYPE, -- 'India Localization Entry for Interorg-XFER ',

133: gl_entry.currency_conv_rate := null; -- number,
134: gl_entry.currency_conv_date := null; -- date,
135: gl_entry.accounting_date := sysdate; -- date,
136: gl_entry.organization_code := ; -- gl_interface.reference1%TYPE, -- p_params(i).organization_code,
137: gl_entry.description := 'India Localization Entry for Projects Draft Invoice'; -- gl_interface.reference10%TYPE, -- 'India Localization Entry for Interorg-XFER ',
138: gl_entry.called_from := <'jai_pa_billing_pkg.excise>; -- gl_interface.reference23%TYPE, -- 'jai_mtl_trx_pkg.do_cenvat_Acctg',
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',

Line 138: gl_entry.called_from := <'jai_pa_billing_pkg.excise>; -- gl_interface.reference23%TYPE, -- 'jai_mtl_trx_pkg.do_cenvat_Acctg',

134: gl_entry.currency_conv_date := null; -- date,
135: gl_entry.accounting_date := sysdate; -- date,
136: gl_entry.organization_code := ; -- gl_interface.reference1%TYPE, -- p_params(i).organization_code,
137: gl_entry.description := 'India Localization Entry for Projects Draft Invoice'; -- gl_interface.reference10%TYPE, -- 'India Localization Entry for Interorg-XFER ',
138: gl_entry.called_from := <'jai_pa_billing_pkg.excise>; -- gl_interface.reference23%TYPE, -- 'jai_mtl_trx_pkg.do_cenvat_Acctg',
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)

Line 139: gl_entry.reference_table := 'JAI_PA_DRAFT_INVOICES'; -- gl_interface.reference24%TYPE, -- 'jai_mtl_trxs',

135: gl_entry.accounting_date := sysdate; -- date,
136: gl_entry.organization_code := ; -- gl_interface.reference1%TYPE, -- p_params(i).organization_code,
137: gl_entry.description := 'India Localization Entry for Projects Draft Invoice'; -- gl_interface.reference10%TYPE, -- 'India Localization Entry for Interorg-XFER ',
138: gl_entry.called_from := <'jai_pa_billing_pkg.excise>; -- gl_interface.reference23%TYPE, -- 'jai_mtl_trx_pkg.do_cenvat_Acctg',
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,

Line 140: gl_entry.reference_column := 'DRAFT_INVOICE_ID'; -- gl_interface.reference25%TYPE, -- p_transaction_temp_id,

136: gl_entry.organization_code := ; -- gl_interface.reference1%TYPE, -- p_params(i).organization_code,
137: gl_entry.description := 'India Localization Entry for Projects Draft Invoice'; -- gl_interface.reference10%TYPE, -- 'India Localization Entry for Interorg-XFER ',
138: gl_entry.called_from := <'jai_pa_billing_pkg.excise>; -- gl_interface.reference23%TYPE, -- 'jai_mtl_trx_pkg.do_cenvat_Acctg',
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,

Line 141: gl_entry.reference_id := ; -- gl_interface.reference26%TYPE, -- 'transaction_temp_id',

137: gl_entry.description := 'India Localization Entry for Projects Draft Invoice'; -- gl_interface.reference10%TYPE, -- 'India Localization Entry for Interorg-XFER ',
138: gl_entry.called_from := <'jai_pa_billing_pkg.excise>; -- gl_interface.reference23%TYPE, -- 'jai_mtl_trx_pkg.do_cenvat_Acctg',
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

Line 142: gl_entry.organization_id := ; -- gl_interface.reference27%TYPE, -- to_char(p_params(i).organization_id)

138: gl_entry.called_from := <'jai_pa_billing_pkg.excise>; -- gl_interface.reference23%TYPE, -- 'jai_mtl_trx_pkg.do_cenvat_Acctg',
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:

Line 150: gl_entry.credit_ccid := ; --gl_interface.code_combination_id%TYPE,

146:
147:
148: Entry 2 for ExciseEducation Cess
149: gl_entry.amount := zzz;
150: gl_entry.credit_ccid := ; --gl_interface.code_combination_id%TYPE,
151: gl_entry.debit_ccid := excise_edu_cess_debit_accnt; -- gl_interface.code_combination_id%TYPE,
152: gl_entry.regime_code := 'EXCISE_EDUCATION_CESS'; -- varchar2(30),
153: */
154:

Line 151: gl_entry.debit_ccid := excise_edu_cess_debit_accnt; -- gl_interface.code_combination_id%TYPE,

147:
148: Entry 2 for ExciseEducation Cess
149: gl_entry.amount := zzz;
150: gl_entry.credit_ccid := ; --gl_interface.code_combination_id%TYPE,
151: gl_entry.debit_ccid := excise_edu_cess_debit_accnt; -- gl_interface.code_combination_id%TYPE,
152: gl_entry.regime_code := 'EXCISE_EDUCATION_CESS'; -- varchar2(30),
153: */
154:
155:

Line 167: insert into gl_interface(

163: if jai_pa_billing_pkg.gv_debug then
164: jai_cmn_utils_pkg.print_log ( jai_pa_billing_pkg.file, '1 insert_gl_entry- Credit Entry');
165: end if;
166:
167: insert into gl_interface(
168: status,
169: set_of_books_id,
170: user_je_source_name,
171: user_je_category_name,

Line 273: insert into gl_interface(

269: if jai_pa_billing_pkg.gv_debug then
270: jai_cmn_utils_pkg.print_log ( jai_pa_billing_pkg.file, '2 insert_gl_entry- debit entry');
271: end if;
272:
273: insert into gl_interface(
274: status,
275: set_of_books_id,
276: user_je_source_name,
277: user_je_category_name,

Line 1196: r_gl_entry.debit_ccid := ln_debit_ccid; -- gl_interface.code_combination_id%TYPE,

1192:
1193: /* Process Accounting */
1194: r_gl_entry.debit_amount := ln_excise_total;
1195: r_gl_entry.credit_amount := ln_excise_total;
1196: r_gl_entry.debit_ccid := ln_debit_ccid; -- gl_interface.code_combination_id%TYPE,
1197: r_gl_entry.credit_ccid := ln_credit_ccid; --gl_interface.code_combination_id%TYPE,
1198: r_gl_entry.regime_code := 'EXCISE'; -- varchar2(30),
1199: r_gl_entry.tax_type := null; -- varchar2(30),
1200: /* -- Bug 6012570

Line 1197: r_gl_entry.credit_ccid := ln_credit_ccid; --gl_interface.code_combination_id%TYPE,

1193: /* Process Accounting */
1194: r_gl_entry.debit_amount := ln_excise_total;
1195: r_gl_entry.credit_amount := ln_excise_total;
1196: r_gl_entry.debit_ccid := ln_debit_ccid; -- gl_interface.code_combination_id%TYPE,
1197: r_gl_entry.credit_ccid := ln_credit_ccid; --gl_interface.code_combination_id%TYPE,
1198: r_gl_entry.regime_code := 'EXCISE'; -- varchar2(30),
1199: r_gl_entry.tax_type := null; -- varchar2(30),
1200: /* -- Bug 6012570
1201: Journal entry source must be a seeded value and hence changing hardcoded Project Accounting string to a Seeded source Receivales India

Line 1212: r_gl_entry.accounting_date := ld_gl_date; -- date, /Bug 12611009 - Pass GL Date of PA Draft Invoice to GL_INTERFACE/

1208: r_gl_entry.set_of_books_id := get_sob_id(pr_pa_draft_invoices_all.org_id); -- gl_sets_of_books.set_of_books_id%type,
1209: r_gl_entry.currency_code := jai_constants.func_curr; -- gl_currencies.currency_code%type,
1210: r_gl_entry.currency_conv_rate := null; -- number,
1211: r_gl_entry.currency_conv_date := null; -- date,
1212: r_gl_entry.accounting_date := ld_gl_date; -- date, /*Bug 12611009 - Pass GL Date of PA Draft Invoice to GL_INTERFACE*/
1213: r_gl_entry.organization_code := jai_general_pkg.get_organization_code(r_jai_pa_draft_invoices.organization_id); -- gl_interface.reference1%TYPE, -- p_params(i).organization_code,
1214: r_gl_entry.description := 'India Localization Entry for Project-'||r_jai_pa_draft_invoices.project_id; -- gl_interface.reference10%TYPE, -- 'India Localization Entry for Interorg-XFER ',
1215: r_gl_entry.called_from := 'jai_pa_billing_pkg.process_excise'; -- gl_interface.reference23%TYPE, -- 'jai_mtl_trx_pkg.do_cenvat_Acctg',
1216: r_gl_entry.reference_table := 'PROJECT_ID:'||r_jai_pa_draft_invoices.project_id; -- gl_interface.reference24%TYPE, -- 'jai_mtl_trxs',

Line 1213: r_gl_entry.organization_code := jai_general_pkg.get_organization_code(r_jai_pa_draft_invoices.organization_id); -- gl_interface.reference1%TYPE, -- p_params(i).organization_code,

1209: r_gl_entry.currency_code := jai_constants.func_curr; -- gl_currencies.currency_code%type,
1210: r_gl_entry.currency_conv_rate := null; -- number,
1211: r_gl_entry.currency_conv_date := null; -- date,
1212: r_gl_entry.accounting_date := ld_gl_date; -- date, /*Bug 12611009 - Pass GL Date of PA Draft Invoice to GL_INTERFACE*/
1213: r_gl_entry.organization_code := jai_general_pkg.get_organization_code(r_jai_pa_draft_invoices.organization_id); -- gl_interface.reference1%TYPE, -- p_params(i).organization_code,
1214: r_gl_entry.description := 'India Localization Entry for Project-'||r_jai_pa_draft_invoices.project_id; -- gl_interface.reference10%TYPE, -- 'India Localization Entry for Interorg-XFER ',
1215: r_gl_entry.called_from := 'jai_pa_billing_pkg.process_excise'; -- gl_interface.reference23%TYPE, -- 'jai_mtl_trx_pkg.do_cenvat_Acctg',
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,

Line 1214: r_gl_entry.description := 'India Localization Entry for Project-'||r_jai_pa_draft_invoices.project_id; -- gl_interface.reference10%TYPE, -- 'India Localization Entry for Interorg-XFER ',

1210: r_gl_entry.currency_conv_rate := null; -- number,
1211: r_gl_entry.currency_conv_date := null; -- date,
1212: r_gl_entry.accounting_date := ld_gl_date; -- date, /*Bug 12611009 - Pass GL Date of PA Draft Invoice to GL_INTERFACE*/
1213: r_gl_entry.organization_code := jai_general_pkg.get_organization_code(r_jai_pa_draft_invoices.organization_id); -- gl_interface.reference1%TYPE, -- p_params(i).organization_code,
1214: r_gl_entry.description := 'India Localization Entry for Project-'||r_jai_pa_draft_invoices.project_id; -- gl_interface.reference10%TYPE, -- 'India Localization Entry for Interorg-XFER ',
1215: r_gl_entry.called_from := 'jai_pa_billing_pkg.process_excise'; -- gl_interface.reference23%TYPE, -- 'jai_mtl_trx_pkg.do_cenvat_Acctg',
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',

Line 1215: r_gl_entry.called_from := 'jai_pa_billing_pkg.process_excise'; -- gl_interface.reference23%TYPE, -- 'jai_mtl_trx_pkg.do_cenvat_Acctg',

1211: r_gl_entry.currency_conv_date := null; -- date,
1212: r_gl_entry.accounting_date := ld_gl_date; -- date, /*Bug 12611009 - Pass GL Date of PA Draft Invoice to GL_INTERFACE*/
1213: r_gl_entry.organization_code := jai_general_pkg.get_organization_code(r_jai_pa_draft_invoices.organization_id); -- gl_interface.reference1%TYPE, -- p_params(i).organization_code,
1214: r_gl_entry.description := 'India Localization Entry for Project-'||r_jai_pa_draft_invoices.project_id; -- gl_interface.reference10%TYPE, -- 'India Localization Entry for Interorg-XFER ',
1215: r_gl_entry.called_from := 'jai_pa_billing_pkg.process_excise'; -- gl_interface.reference23%TYPE, -- 'jai_mtl_trx_pkg.do_cenvat_Acctg',
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)

Line 1216: r_gl_entry.reference_table := 'PROJECT_ID:'||r_jai_pa_draft_invoices.project_id; -- gl_interface.reference24%TYPE, -- 'jai_mtl_trxs',

1212: r_gl_entry.accounting_date := ld_gl_date; -- date, /*Bug 12611009 - Pass GL Date of PA Draft Invoice to GL_INTERFACE*/
1213: r_gl_entry.organization_code := jai_general_pkg.get_organization_code(r_jai_pa_draft_invoices.organization_id); -- gl_interface.reference1%TYPE, -- p_params(i).organization_code,
1214: r_gl_entry.description := 'India Localization Entry for Project-'||r_jai_pa_draft_invoices.project_id; -- gl_interface.reference10%TYPE, -- 'India Localization Entry for Interorg-XFER ',
1215: r_gl_entry.called_from := 'jai_pa_billing_pkg.process_excise'; -- gl_interface.reference23%TYPE, -- 'jai_mtl_trx_pkg.do_cenvat_Acctg',
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,

Line 1217: r_gl_entry.reference_column := 'DRAFT_INVOICE_NUM'; -- gl_interface.reference25%TYPE, -- p_transaction_temp_id,

1213: r_gl_entry.organization_code := jai_general_pkg.get_organization_code(r_jai_pa_draft_invoices.organization_id); -- gl_interface.reference1%TYPE, -- p_params(i).organization_code,
1214: r_gl_entry.description := 'India Localization Entry for Project-'||r_jai_pa_draft_invoices.project_id; -- gl_interface.reference10%TYPE, -- 'India Localization Entry for Interorg-XFER ',
1215: r_gl_entry.called_from := 'jai_pa_billing_pkg.process_excise'; -- gl_interface.reference23%TYPE, -- 'jai_mtl_trx_pkg.do_cenvat_Acctg',
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,

Line 1218: r_gl_entry.reference_id := r_jai_pa_draft_invoices.draft_invoice_num; -- gl_interface.reference26%TYPE, -- 'transaction_temp_id',

1214: r_gl_entry.description := 'India Localization Entry for Project-'||r_jai_pa_draft_invoices.project_id; -- gl_interface.reference10%TYPE, -- 'India Localization Entry for Interorg-XFER ',
1215: r_gl_entry.called_from := 'jai_pa_billing_pkg.process_excise'; -- gl_interface.reference23%TYPE, -- 'jai_mtl_trx_pkg.do_cenvat_Acctg',
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

Line 1219: r_gl_entry.organization_id := r_jai_pa_draft_invoices.organization_id; -- gl_interface.reference27%TYPE, -- to_char(p_params(i).organization_id)

1215: r_gl_entry.called_from := 'jai_pa_billing_pkg.process_excise'; -- gl_interface.reference23%TYPE, -- 'jai_mtl_trx_pkg.do_cenvat_Acctg',
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:

Line 1273: r_gl_entry.credit_ccid := ln_credit_ccid; --gl_interface.code_combination_id%TYPE,

1269:
1270: if nvl(ln_excise_cess_amt,0) <> 0 then
1271: r_gl_entry.debit_amount := ln_excise_cess_amt;
1272: r_gl_entry.credit_amount := ln_excise_cess_amt;
1273: r_gl_entry.credit_ccid := ln_credit_ccid; --gl_interface.code_combination_id%TYPE,
1274: r_gl_entry.debit_ccid := ln_debit_ccid; -- gl_interface.code_combination_id%TYPE,
1275: r_gl_entry.regime_code := 'EXCISE_EDUCATION_CESS'; -- varchar2(30),
1276:
1277: if jai_pa_billing_pkg.gv_debug then

Line 1274: r_gl_entry.debit_ccid := ln_debit_ccid; -- gl_interface.code_combination_id%TYPE,

1270: if nvl(ln_excise_cess_amt,0) <> 0 then
1271: r_gl_entry.debit_amount := ln_excise_cess_amt;
1272: r_gl_entry.credit_amount := ln_excise_cess_amt;
1273: r_gl_entry.credit_ccid := ln_credit_ccid; --gl_interface.code_combination_id%TYPE,
1274: r_gl_entry.debit_ccid := ln_debit_ccid; -- gl_interface.code_combination_id%TYPE,
1275: r_gl_entry.regime_code := 'EXCISE_EDUCATION_CESS'; -- varchar2(30),
1276:
1277: if jai_pa_billing_pkg.gv_debug then
1278: jai_cmn_utils_pkg.print_log ( jai_pa_billing_pkg.file, '19 process_excise. Before insert_gl_entry- Excise Edu Cess');

Line 1328: r_gl_entry.credit_ccid := ln_credit_ccid; --gl_interface.code_combination_id%TYPE,

1324:
1325: if nvl(ln_sh_excise_cess_amt,0) <> 0 then
1326: r_gl_entry.debit_amount := ln_sh_excise_cess_amt;
1327: r_gl_entry.credit_amount := ln_sh_excise_cess_amt;
1328: r_gl_entry.credit_ccid := ln_credit_ccid; --gl_interface.code_combination_id%TYPE,
1329: r_gl_entry.debit_ccid := ln_debit_ccid; -- gl_interface.code_combination_id%TYPE,
1330: r_gl_entry.regime_code := jai_constants.tax_type_sh_exc_edu_cess; -- varchar2(30),
1331:
1332: if jai_pa_billing_pkg.gv_debug then

Line 1329: r_gl_entry.debit_ccid := ln_debit_ccid; -- gl_interface.code_combination_id%TYPE,

1325: if nvl(ln_sh_excise_cess_amt,0) <> 0 then
1326: r_gl_entry.debit_amount := ln_sh_excise_cess_amt;
1327: r_gl_entry.credit_amount := ln_sh_excise_cess_amt;
1328: r_gl_entry.credit_ccid := ln_credit_ccid; --gl_interface.code_combination_id%TYPE,
1329: r_gl_entry.debit_ccid := ln_debit_ccid; -- gl_interface.code_combination_id%TYPE,
1330: r_gl_entry.regime_code := jai_constants.tax_type_sh_exc_edu_cess; -- varchar2(30),
1331:
1332: if jai_pa_billing_pkg.gv_debug then
1333: jai_cmn_utils_pkg.print_log ( jai_pa_billing_pkg.file, '19.1 process_excise. Before insert_gl_entry- SH Excise Edu Cess');