DBA Data[Home] [Help]

APPS.PA_PURGE_ICIP dependencies on PA_PURGE

Line 1: package body pa_purge_icip as

1: package body pa_purge_icip as
2: /*$Header: PAICIPPB.pls 120.6 2006/02/17 15:23:06 rmarcel noship $*/
3:
4:
5: l_commit_size NUMBER ;

Line 584: -- Pa_Purge_Project_details which will show the no. of records

580:
581: else
582: -- After "deleting" or "deleting and inserting" a set of records
583: -- the transaction is commited. This also creates a record in the
584: -- Pa_Purge_Project_details which will show the no. of records
585: -- that are purged from each table.
586:
587: pa_debug.debug( ' ->Calling pa_purge.CommitProcess ') ;
588: pa_purge.CommitProcess

Line 587: pa_debug.debug( ' ->Calling pa_purge.CommitProcess ') ;

583: -- the transaction is commited. This also creates a record in the
584: -- Pa_Purge_Project_details which will show the no. of records
585: -- that are purged from each table.
586:
587: pa_debug.debug( ' ->Calling pa_purge.CommitProcess ') ;
588: pa_purge.CommitProcess
589: (p_purge_batch_id => p_purge_batch_id,
590: p_project_id => p_project_id,
591: p_table_name => 'PA_DRAFT_INVOICE_DETAILS_ALL',

Line 588: pa_purge.CommitProcess

584: -- Pa_Purge_Project_details which will show the no. of records
585: -- that are purged from each table.
586:
587: pa_debug.debug( ' ->Calling pa_purge.CommitProcess ') ;
588: pa_purge.CommitProcess
589: (p_purge_batch_id => p_purge_batch_id,
590: p_project_id => p_project_id,
591: p_table_name => 'PA_DRAFT_INVOICE_DETAILS_ALL',
592: p_NoOfRecordsIns => l_NoOfRecordsIns,

Line 614: pa_debug.debug('Error Procedure Name := PA_PURGE_ICIP.PA_DraftInvDetails' );

610: WHEN PA_PROJECT_UTILS2.PA_Arch_Pur_Subroutine_Error then
611: RAISE PA_PROJECT_UTILS2.PA_Arch_Pur_Subroutine_Error ;
612:
613: WHEN OTHERS THEN
614: pa_debug.debug('Error Procedure Name := PA_PURGE_ICIP.PA_DraftInvDetails' );
615: pa_debug.debug('Error stage is '||x_err_stage );
616: pa_debug.debug('Error stack is '||x_err_stack );
617: pa_debug.debug(SQLERRM);
618:

Line 714: pa_debug.debug('Error Procedure Name := PA_PURGE_ICIP.PA_MC_DraftInvoiceDetails' );

710: WHEN PA_PROJECT_UTILS2.PA_Arch_Pur_Subroutine_Error then
711: RAISE PA_PROJECT_UTILS2.PA_Arch_Pur_Subroutine_Error ;
712:
713: WHEN OTHERS THEN
714: pa_debug.debug('Error Procedure Name := PA_PURGE_ICIP.PA_MC_DraftInvoiceDetails' );
715: pa_debug.debug('Error stage is '||x_err_stage );
716: pa_debug.debug('Error stack is '||x_err_stack );
717: pa_debug.debug(SQLERRM);
718: PA_PROJECT_UTILS2.g_sqlerrm := SQLERRM ;

Line 728: END pa_purge_icip;

724: RAISE PA_PROJECT_UTILS2.PA_Arch_Pur_Subroutine_Error ;
725:
726: end PA_MC_DraftInvoiceDetails;
727:
728: END pa_purge_icip;