[Home] [Help]
835: p_organization_id, p_location_id, lv_account_name,--Modified by Xiao from p_account_name for POT change, reg bug#12533434
836: ln_charge_account_id, ln_balancing_account_id,
837: p_reference_id, p_source_trx_type, p_tax_rate, p_assessable_value, p_batch_id,
838: p_currency_code, p_curr_conv_date, p_curr_conv_rate, ln_trx_credit, ln_trx_debit,
839: sysdate, FND_GLOBAL.user_id, sysdate, FND_GLOBAL.user_id, fnd_global.login_id,
840: p_trx_reference_context, p_trx_reference1, p_trx_reference2, p_trx_reference3, p_trx_reference4, p_trx_reference5
841: , p_inv_organization_id , lv_primary_regime_regno ,p_service_type_code /* added by ssawant for bug 5879769 */
842: ,p_invoice_no --Added by Qiong for Advanced receipts
843: ) RETURNING repository_id INTO p_repository_id;
1477: reference10, reference22, reference23, reference1,
1478: reference24, reference25, reference26, reference27
1479: ) VALUES (
1480: lv_status, ln_sob_id, lv_source_name, lv_gl_je_category,
1481: ld_accounting_date, p_currency_code, sysdate, FND_GLOBAL.user_id,
1482: 'A', ln_entered_cr, ln_entered_dr, ln_accounted_cr, ln_accounted_dr, p_transaction_date,
1483: p_code_combination_id, p_curr_conv_date, p_curr_conv_type, p_curr_conv_rate,
1484: lv_reference10, jai_constants.gl_je_source_name, p_calling_object, lv_reference1,
1485: -- commented lv_organization_code and passed refererence1 ssumaith bug#6664855
1505: ) VALUES ( JAI_CMN_JOURNAL_ENTRIES_S.nextval,
1506: p_regime_code, p_organization_id, ln_sob_id, p_tax_type, lv_period_name,
1507: p_code_combination_id, ln_accounted_dr, ln_accounted_cr, p_transaction_date,
1508: p_source, p_source_table_name, p_source_document_id, p_source_trx_type /* p_reference_name- Bug 13430127 */, p_reference_id,p_repository_id,/* added by ssawant for bug 5879769 */
1509: p_currency_code, p_curr_conv_rate, sysdate, FND_GLOBAL.user_id, sysdate, fnd_global.user_id, fnd_global.login_id
1510: );
1511: jai_cmn_utils_pkg.print_log('6395039.log', 'after insert inot JAI_CMN_JOURNAL_ENTRIES');
1512: /* Added by Ramananda for bug#4407165 */
1513:
1610: p_parent_reference_id,
1611: p_reversal_flag,
1612: p_batch_id,
1613: sysdate,
1614: fnd_global.user_id,
1615: sysdate,
1616: fnd_global.user_id,
1617: fnd_global.login_id
1618: ) RETURNING reference_id INTO p_reference_id;
1612: p_batch_id,
1613: sysdate,
1614: fnd_global.user_id,
1615: sysdate,
1616: fnd_global.user_id,
1617: fnd_global.login_id
1618: ) RETURNING reference_id INTO p_reference_id;
1619:
1620: p_process_flag := jai_constants.successful;
1613: sysdate,
1614: fnd_global.user_id,
1615: sysdate,
1616: fnd_global.user_id,
1617: fnd_global.login_id
1618: ) RETURNING reference_id INTO p_reference_id;
1619:
1620: p_process_flag := jai_constants.successful;
1621:
2075: SET recovered_amount = nvl(recovered_amount,0) + nvl(p_recovered_amount, 0),
2076: discounted_amount = nvl(discounted_amount,0) + nvl(p_discounted_amount,0),
2077: -- recoverable_amount = recoverable_amount - nvl(p_amount, 0),
2078: last_update_date = sysdate,
2079: last_updated_by = fnd_global.user_id
2080: WHERE reference_id = p_reference_id;
2081:
2082: lv_statement := '2';
2083: p_process_flag := jai_constants.successful;
2188: null, null, pn_settlement_id, pv_organization_type, --added pn_settlement_id for bug#9350172
2189: pn_organization_id, pn_location_id, pv_account_name, pn_charge_account_id, pn_balancing_account_id,
2190: pn_reference_id, pv_source_trx_type, pn_tax_rate, pn_assessable_value, pn_batch_id,
2191: jai_constants.func_curr, null, null, pn_credit_amount, pn_debit_amount,
2192: sysdate, FND_GLOBAL.user_id, sysdate, FND_GLOBAL.user_id, fnd_global.login_id,
2193: pv_trx_reference_context, pv_trx_reference1, pv_trx_reference2, pv_trx_reference3, pv_trx_reference4, pv_trx_reference5
2194: , pn_inv_organization_id, lv_primary_regime_regno, pv_invoice_no, pd_invoice_date
2195: ) RETURNING repository_id INTO pn_repository_id;
2196: