183: pr_gl_entry.je_category,
184: nvl(pr_gl_entry.accounting_date, trunc(sysdate)) ,
185: pr_gl_entry.currency_code,
186: sysdate,
187: fnd_global.user_id,
188: 'A',
189: pr_gl_entry.credit_amount,
190: null,
191: sysdate,
244: pr_gl_entry.reference_id,
245: pr_gl_entry.currency_code,
246: pr_gl_entry.currency_conv_rate,
247: sysdate,
248: fnd_global.user_id,
249: sysdate,
250: fnd_global.user_id,
251: fnd_global.login_id
252: );
246: pr_gl_entry.currency_conv_rate,
247: sysdate,
248: fnd_global.user_id,
249: sysdate,
250: fnd_global.user_id,
251: fnd_global.login_id
252: );
253: end if;
254:
247: sysdate,
248: fnd_global.user_id,
249: sysdate,
250: fnd_global.user_id,
251: fnd_global.login_id
252: );
253: end if;
254:
255: if pr_gl_entry.debit_ccid is not null and nvl(pr_gl_entry.debit_amount,0) <> 0 then
289: pr_gl_entry.je_category,
290: nvl(pr_gl_entry.accounting_date, trunc(sysdate)) ,
291: pr_gl_entry.currency_code,
292: sysdate,
293: fnd_global.user_id,
294: 'A',
295: null,
296: pr_gl_entry.debit_amount,
297: sysdate,
351: pr_gl_entry.reference_id,
352: pr_gl_entry.currency_code,
353: pr_gl_entry.currency_conv_rate,
354: sysdate,
355: fnd_global.user_id,
356: sysdate,
357: fnd_global.user_id,
358: fnd_global.login_id
359: );
353: pr_gl_entry.currency_conv_rate,
354: sysdate,
355: fnd_global.user_id,
356: sysdate,
357: fnd_global.user_id,
358: fnd_global.login_id
359: );
360: end if;
361:
354: sysdate,
355: fnd_global.user_id,
356: sysdate,
357: fnd_global.user_id,
358: fnd_global.login_id
359: );
360: end if;
361:
362: if jai_pa_billing_pkg.gv_debug then
653: SET vat_invoice_no = lv_vat_invoice_no,
654: vat_invoice_date = ld_vat_invoice_date,
655: process_vat_flag = 'Y',
656: last_update_date = sysdate,
657: last_updated_by = fnd_global.user_id,
658: last_update_login = fnd_global.login_id
659: WHERE draft_invoice_id = r_draft_invoice_dtls.draft_invoice_id;
660:
661: <
654: vat_invoice_date = ld_vat_invoice_date,
655: process_vat_flag = 'Y',
656: last_update_date = sysdate,
657: last_updated_by = fnd_global.user_id,
658: last_update_login = fnd_global.login_id
659: WHERE draft_invoice_id = r_draft_invoice_dtls.draft_invoice_id;
660:
661: <
662: if jai_pa_billing_pkg.gv_debug then
1323: excise_cess_amt = ln_excise_cess_amt,
1324: excise_sh_cess_amt = ln_sh_excise_cess_amt, /*budget07 */
1325: process_excise_flag = 'Y',
1326: last_update_date = sysdate,
1327: last_updated_by = fnd_global.user_id,
1328: last_update_login = fnd_global.login_id
1329: WHERE draft_invoice_id = r_jai_pa_draft_invoices.draft_invoice_id;
1330:
1331: if jai_pa_billing_pkg.gv_debug then
1324: excise_sh_cess_amt = ln_sh_excise_cess_amt, /*budget07 */
1325: process_excise_flag = 'Y',
1326: last_update_date = sysdate,
1327: last_updated_by = fnd_global.user_id,
1328: last_update_login = fnd_global.login_id
1329: WHERE draft_invoice_id = r_jai_pa_draft_invoices.draft_invoice_id;
1330:
1331: if jai_pa_billing_pkg.gv_debug then
1332: jai_cmn_utils_pkg.print_log ( jai_pa_billing_pkg.file, '20 process_excise. After UPDATE jai_pa_draft_invoices');
1530: ln_precision fnd_currencies.precision%type;
1531: is_upd_pay_sch_success boolean;
1532: lv_account_name jai_rgm_regns.attribute_code%type;
1533: ln_tax_variance_inv_cur number;
1534: ln_user_id fnd_user.user_id%type := fnd_global.user_id;
1535: ln_login_id fnd_logins.login_id%type := fnd_global.login_id;
1536: ln_request_id number;
1537: ln_program_application_id number;
1538: ln_program_id number;
1531: is_upd_pay_sch_success boolean;
1532: lv_account_name jai_rgm_regns.attribute_code%type;
1533: ln_tax_variance_inv_cur number;
1534: ln_user_id fnd_user.user_id%type := fnd_global.user_id;
1535: ln_login_id fnd_logins.login_id%type := fnd_global.login_id;
1536: ln_request_id number;
1537: ln_program_application_id number;
1538: ln_program_id number;
1539: