APPS.CSE_IPV_FA_PKG dependencies on AP_INVOICE_DISTRIBUTIONS_ALL

Line 51: from ap_invoice_distributions_all

47:
48: IS
49: Cursor c_success_count( cp_conc_request_id NUMBER ) IS
50: select count(1) success_count
51: from ap_invoice_distributions_all
52: where request_id = cp_conc_request_id ;
53:
54: Cursor c_failed_count( cp_conc_request_id NUMBER ) IS
55: select count(1 ) failed_count

Line 66: ap_invoice_distributions_all aida,

62: aida.quantity_invoiced quantity_invoiced,
63: aida.base_invoice_price_variance base_invoice_price_variance,
64: cte.error_text error_text
65: from ap_invoices_all aia,
66: ap_invoice_distributions_all aida,
67: csi_txn_errors cte
68: where aida.invoice_id = aia.invoice_id
69: and cte.source_id = aida.invoice_distribution_id
70: and cte.source_group_ref_id = cp_conc_request_id ;

Line 481: l_txn_error_rec.source_type := 'AP_INVOICE_DISTRIBUTIONS_ALL';

477: x_processed_flag := 'N';
478: l_txn_error_rec := cse_util_pkg.init_txn_error_rec;
479: l_txn_error_rec.error_text := l_error_message;
480: l_txn_error_rec.source_group_ref_id := l_conc_request_id;
481: l_txn_error_rec.source_type := 'AP_INVOICE_DISTRIBUTIONS_ALL';
482: l_txn_error_rec.source_id := p_invoice_rec.invoice_dist_id;
483: l_txn_error_rec.processed_flag := 'N';
484: csi_transactions_pvt.create_txn_error(
485: p_api_version => 1.0,

Line 531: FROM ap_invoice_distributions_all aida,

527: aia.invoice_num,
528: nvl(aida.amount, 0) price_variance,
529: aila.inventory_item_id,
530: aila.org_id
531: FROM ap_invoice_distributions_all aida,
532: ap_invoice_lines_all aila,
533: ap_invoices_all aia
534: WHERE aida.line_type_lookup_code = 'IPV'
535: AND aida.posted_flag = 'Y'

Line 577: FROM ap_invoice_distributions_all aida,

573: aia.invoice_type_lookup_code invoice_type,
574: nvl(aida.amount,0) base_amount,
575: aida.accounting_date,
576: aida.dist_code_combination_id inv_dist_ccid
577: FROM ap_invoice_distributions_all aida,
578: ap_invoices_all aia
579: WHERE aida.invoice_id = p_invoice_id
580: AND aida.project_id = p_project_id
581: AND aida.task_id = p_task_id

Line 734: UPDATE ap_invoice_distributions_all

730:
731: END IF; -- pol.inventory_item_is is not null;
732:
733: IF l_processed_flag = 'Y' THEN
734: UPDATE ap_invoice_distributions_all
735: SET assets_addition_flag = 'Y',
736: request_id = l_conc_request_id
737: WHERE invoice_distribution_id = invoice_rec.invoice_distribution_id
738: AND assets_addition_flag <>'Y';

Line 741: debug('processed successfully. updating ap_invoice_distributions_all.assets_addition_flag = Y');

737: WHERE invoice_distribution_id = invoice_rec.invoice_distribution_id
738: AND assets_addition_flag <>'Y';
739:
740: debug('invoice_distribution_id : '||invoice_rec.invoice_distribution_id);
741: debug('processed successfully. updating ap_invoice_distributions_all.assets_addition_flag = Y');
742: END IF;
743:
744: EXCEPTION
745: WHEN fnd_api.g_exc_error THEN

Line 750: l_txn_error_rec.source_type := 'AP_INVOICE_DISTRIBUTIONS_ALL';

746: --null;
747: l_txn_error_rec := cse_util_pkg.init_txn_error_rec;
748: l_txn_error_rec.error_text := SQLERRM;
749: l_txn_error_rec.source_group_ref_id := l_conc_request_id;
750: l_txn_error_rec.source_type := 'AP_INVOICE_DISTRIBUTIONS_ALL';
751: l_txn_error_rec.source_id := invoice_rec.invoice_distribution_id;
752: l_txn_error_rec.processed_flag := 'N';
753: csi_transactions_pvt.create_txn_error(
754: p_api_version => 1.0,

Line 776: l_txn_error_rec.source_type := 'AP_INVOICE_DISTRIBUTIONS_ALL';

772: WHEN OTHERS THEN
773: l_txn_error_rec := cse_util_pkg.init_txn_error_rec;
774: l_txn_error_rec.error_text := SQLERRM;
775: l_txn_error_rec.source_group_ref_id := l_conc_request_id;
776: l_txn_error_rec.source_type := 'AP_INVOICE_DISTRIBUTIONS_ALL';
777: l_txn_error_rec.source_id := l_invoice_distribution_id;
778: l_txn_error_rec.processed_flag := 'N';
779: csi_transactions_pvt.create_txn_error(
780: p_api_version => 1.0,