[Home] [Help]
521: null, null, p_settlement_id, p_organization_type,
522: p_organization_id, p_location_id, p_account_name, ln_charge_account_id, ln_balancing_account_id,
523: p_reference_id, p_source_trx_type, p_tax_rate, p_assessable_value, p_batch_id,
524: p_currency_code, p_curr_conv_date, p_curr_conv_rate, ln_trx_credit, ln_trx_debit,
525: sysdate, FND_GLOBAL.user_id, sysdate, FND_GLOBAL.user_id, fnd_global.login_id,
526: p_attribute_context, p_attribute1, p_attribute2, p_attribute3, p_attribute4, p_attribute5
527: , p_inv_organization_id , lv_primary_regime_regno ,p_service_type_code /* added by ssawant for bug 5879769 */
528: ) RETURNING repository_id INTO p_repository_id;
529:
1034: reference10, reference22, reference23, reference1,
1035: reference24, reference25, reference26, reference27
1036: ) VALUES (
1037: lv_status, ln_sob_id, lv_source_name, lv_gl_je_category,
1038: ld_accounting_date, p_currency_code, sysdate, FND_GLOBAL.user_id,
1039: 'A', ln_entered_cr, ln_entered_dr, ln_accounted_cr, ln_accounted_dr, p_transaction_date,
1040: p_code_combination_id, p_curr_conv_date, p_curr_conv_type, p_curr_conv_rate,
1041: lv_reference10, jai_constants.gl_je_source_name, p_calling_object, lv_reference1,
1042: -- commented lv_organization_code and passed refererence1 ssumaith bug#6664855
1060: ) VALUES ( JAI_CMN_JOURNAL_ENTRIES_S.nextval,
1061: p_regime_code, p_organization_id, ln_sob_id, p_tax_type, lv_period_name,
1062: p_code_combination_id, ln_accounted_dr, ln_accounted_cr, p_transaction_date,
1063: p_source, p_source_table_name, p_source_document_id, p_reference_name, p_reference_id,p_repository_id,/* added by ssawant for bug 5879769 */
1064: p_currency_code, p_curr_conv_rate, sysdate, FND_GLOBAL.user_id, sysdate, fnd_global.user_id, fnd_global.login_id
1065: );
1066:
1067: jai_cmn_utils_pkg.print_log('6395039.log', 'after insert inot JAI_CMN_JOURNAL_ENTRIES');
1068: /* Added by Ramananda for bug#4407165 */
1165: p_parent_reference_id,
1166: p_reversal_flag,
1167: p_batch_id,
1168: sysdate,
1169: fnd_global.user_id,
1170: sysdate,
1171: fnd_global.user_id,
1172: fnd_global.login_id
1173: ) RETURNING reference_id INTO p_reference_id;
1167: p_batch_id,
1168: sysdate,
1169: fnd_global.user_id,
1170: sysdate,
1171: fnd_global.user_id,
1172: fnd_global.login_id
1173: ) RETURNING reference_id INTO p_reference_id;
1174:
1175: p_process_flag := jai_constants.successful;
1168: sysdate,
1169: fnd_global.user_id,
1170: sysdate,
1171: fnd_global.user_id,
1172: fnd_global.login_id
1173: ) RETURNING reference_id INTO p_reference_id;
1174:
1175: p_process_flag := jai_constants.successful;
1176:
1623: SET recovered_amount = nvl(recovered_amount,0) + nvl(p_recovered_amount, 0),
1624: discounted_amount = nvl(discounted_amount,0) + nvl(p_discounted_amount,0),
1625: -- recoverable_amount = recoverable_amount - nvl(p_amount, 0),
1626: last_update_date = sysdate,
1627: last_updated_by = fnd_global.user_id
1628: WHERE reference_id = p_reference_id;
1629:
1630: lv_statement := '2';
1631: p_process_flag := jai_constants.successful;
1731: null, null, null, pv_organization_type,
1732: pn_organization_id, pn_location_id, pv_account_name, pn_charge_account_id, pn_balancing_account_id,
1733: pn_reference_id, pv_source_trx_type, pn_tax_rate, pn_assessable_value, pn_batch_id,
1734: jai_constants.func_curr, null, null, pn_credit_amount, pn_debit_amount,
1735: sysdate, FND_GLOBAL.user_id, sysdate, FND_GLOBAL.user_id, fnd_global.login_id,
1736: pv_attribute_context, pv_attribute1, pv_attribute2, pv_attribute3, pv_attribute4, pv_attribute5
1737: , pn_inv_organization_id, lv_primary_regime_regno, pv_invoice_no, pd_invoice_date
1738: ) RETURNING repository_id INTO pn_repository_id;
1739: