DBA Data[Home] [Help]

APPS.JAI_PA_BILLING_PKG dependencies on JAI_CMN_JOURNAL_ENTRIES_S

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 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 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;