APPS.PA_INTEGRATION dependencies on PA_INTEGRATION

Line 1: PACKAGE BODY pa_integration AS

1: PACKAGE BODY pa_integration AS
2: --$Header: PAXPINTB.pls 120.6 2006/08/22 23:36:56 skannoji noship $
3:
4: l_invoice_id NUMBER;
5: l_invoice_status Varchar2(30);

Line 190: pa_check_status := pa_integration.check_ap_invoices(p_invoice_id,p_status_type);

186: ELSE
187: l_invoice_id := p_invoice_id;
188: l_status_type := p_status_type;
189:
190: pa_check_status := pa_integration.check_ap_invoices(p_invoice_id,p_status_type);
191:
192: IF pa_check_status = 'N' THEN
193: l_invoice_status := 'N';
194: ELSIF pa_check_status = 'PA_INV_CANCELLED' THEN

Line 456: -- pa_integration.refresh_pa_cache().

452: -- function will ensure that PA_DATE populated for Raw CDLs will be always
453: -- Greater than Payables Accounting date for Raw CDLs.
454: --------------------------------------------------------------------------
455: --This function was modified to use caching. The actual DB access happens in
456: -- pa_integration.refresh_pa_cache().
457: --This is to get the pa_date for the provider part. The receiver part is done
458: -- by get_raw_cdl_recvr_pa_date().
459: --------------------------------------------------------------------------
460: FUNCTION get_raw_cdl_pa_date ( p_expenditure_item_date IN DATE,

Line 514: pa_integration.refresh_pa_cache( p_org_id , p_expenditure_item_date, p_accounting_date, 'P' );

510: * the provider Cache is NOT reusable.
511: * Access the DB and refresh cache and return pa_date.
512: */
513:
514: pa_integration.refresh_pa_cache( p_org_id , p_expenditure_item_date, p_accounting_date, 'P' );
515: RETURN ( g_prvdr_pa_date ) ;
516: EXCEPTION
517: WHEN OTHERS THEN
518: RAISE ;

Line 645: pa_integration.refresh_pa_cache ( p_org_id , p_expenditure_item_date , p_accounting_date, 'R' );

641: *hence hit the DB and populate/refresh receiver cache.
642: *then return g_recvr_pa_date.
643: */
644:
645: pa_integration.refresh_pa_cache ( p_org_id , p_expenditure_item_date , p_accounting_date, 'R' );
646: RETURN ( g_recvr_pa_date ) ;
647: EXCEPTION
648: WHEN OTHERS THEN
649: RAISE ;

Line 777: pa_debug.init_err_stack('pa_integration.get_period_information');

773: l_prof_new_gldate_derivation VARCHAR2(1) := 'N';
774: l_use_same_pa_gl_period_prvdr VARCHAR2(1) := 'N';
775: l_use_same_pa_gl_period_recvr VARCHAR2(1) := 'N';
776: BEGIN
777: pa_debug.init_err_stack('pa_integration.get_period_information');
778:
779: fnd_profile.get('PA_DEBUG_MODE',l_debug_mode);
780: l_debug_mode := NVL(l_debug_mode, 'N');
781:

Line 804: l_prvdr_gl_period_name := pa_integration.get_gl_period_name( p_gl_date => p_prvdr_gl_date

800: l_stage := 200;
801: /*
802: * Get Gl periods based on ei date.
803: */
804: l_prvdr_gl_period_name := pa_integration.get_gl_period_name( p_gl_date => p_prvdr_gl_date
805: ,p_set_of_books_id => p_prvdr_sob_id
806: );
807:
808: -- Bug 2248543 Added provider and receiver org_id check

Line 881: l_prvdr_pa_date := pa_integration.get_raw_cdl_pa_date

877: l_stage := 500;
878: /*
879: * Get Pa periods based on ei date.
880: */
881: l_prvdr_pa_date := pa_integration.get_raw_cdl_pa_date
882: ( p_expenditure_item_date => p_expenditure_item_date
883: ,p_accounting_date => p_prvdr_gl_date
884: ,p_org_id => p_prvdr_org_id
885: );

Line 959: END pa_integration;

955: RAISE ;
956: END; -- get_period_information
957:
958:
959: END pa_integration;