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.7 2010/05/13 10:15:55 lamalviy ship $
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 458: -- pa_integration.refresh_pa_cache().

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

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

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

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

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

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

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

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

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

Line 883: l_prvdr_pa_date := pa_integration.get_raw_cdl_pa_date

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

Line 961: END pa_integration;

957: RAISE ;
958: END; -- get_period_information
959:
960:
961: END pa_integration;