eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PA_PURGE_SUMMARY dependencies on PA_PURGE

Line 1: package body pa_purge_summary as

1: package body pa_purge_summary as
2: /* $Header: PAXSUPRB.pls 120.1 2005/08/19 17:21:00 mwasowic noship $ */
3:
4: l_commit_size NUMBER ;
5: g_def_proj_accum_id NUMBER;

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

219:
220: ELSE
221: -- After "deleting" or "deleting and inserting" a set of records
222: -- the transaction is commited. This also creates a record in the
223: -- Pa_Purge_Project_details which will show the no. of records
224: -- that are purged from each table.
225:
226: pa_debug.debug( ' ->Calling pa_purge.CommitProcess ') ;
227:

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

222: -- the transaction is commited. This also creates a record in the
223: -- Pa_Purge_Project_details which will show the no. of records
224: -- that are purged from each table.
225:
226: pa_debug.debug( ' ->Calling pa_purge.CommitProcess ') ;
227:
228: pa_purge.CommitProcess
229: (p_purge_batch_id => p_purge_batch_id,
230: p_project_id => p_project_id,

Line 228: pa_purge.CommitProcess

224: -- that are purged from each table.
225:
226: pa_debug.debug( ' ->Calling pa_purge.CommitProcess ') ;
227:
228: pa_purge.CommitProcess
229: (p_purge_batch_id => p_purge_batch_id,
230: p_project_id => p_project_id,
231: p_table_name => 'PA_PROJECT_ACCUM_HEADERS',
232: p_NoOfRecordsIns => l_NoOfRecordsIns,

Line 250: pa_debug.debug('Error Procedure Name := PA_PURGE_SUMMARY.PA_PROJACCUMHEADERS' );

246: WHEN PA_PROJECT_UTILS2.PA_Arch_Pur_Subroutine_Error THEN
247: RAISE PA_PROJECT_UTILS2.PA_Arch_Pur_Subroutine_Error ;
248:
249: WHEN OTHERS THEN
250: pa_debug.debug('Error Procedure Name := PA_PURGE_SUMMARY.PA_PROJACCUMHEADERS' );
251: pa_debug.debug('Error stage is '||x_err_stage );
252: pa_debug.debug('Error stack is '||x_err_stack );
253: pa_debug.debug(SQLERRM);
254: PA_PROJECT_UTILS2.g_sqlerrm := SQLERRM ;

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

458:
459: ELSE
460: -- After "deleting" or "deleting and inserting" a set of records
461: -- the transaction is commited. This also creates a record in the
462: -- Pa_Purge_Project_details which will show the no. of records
463: -- that are purged from each table.
464:
465: pa_debug.debug( ' ->Calling pa_purge.CommitProcess ') ;
466: pa_purge.CommitProcess

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

461: -- the transaction is commited. This also creates a record in the
462: -- Pa_Purge_Project_details which will show the no. of records
463: -- that are purged from each table.
464:
465: pa_debug.debug( ' ->Calling pa_purge.CommitProcess ') ;
466: pa_purge.CommitProcess
467: (p_purge_batch_id => p_purge_batch_id,
468: p_project_id => p_project_id,
469: p_table_name => 'PA_PROJECT_ACCUM_COMMITMENTS',

Line 466: pa_purge.CommitProcess

462: -- Pa_Purge_Project_details which will show the no. of records
463: -- that are purged from each table.
464:
465: pa_debug.debug( ' ->Calling pa_purge.CommitProcess ') ;
466: pa_purge.CommitProcess
467: (p_purge_batch_id => p_purge_batch_id,
468: p_project_id => p_project_id,
469: p_table_name => 'PA_PROJECT_ACCUM_COMMITMENTS',
470: p_NoOfRecordsIns => l_NoOfRecordsIns,

Line 486: pa_debug.debug('Error Procedure Name := PA_PURGE_SUMMARY.PA_ProjAccumCommitments' );

482: WHEN PA_PROJECT_UTILS2.PA_Arch_Pur_Subroutine_Error THEN
483: RAISE PA_PROJECT_UTILS2.PA_Arch_Pur_Subroutine_Error ;
484:
485: WHEN OTHERS THEN
486: pa_debug.debug('Error Procedure Name := PA_PURGE_SUMMARY.PA_ProjAccumCommitments' );
487: pa_debug.debug('Error stage is '||x_err_stage );
488: pa_debug.debug('Error stack is '||x_err_stack );
489: pa_debug.debug(SQLERRM);
490: PA_PROJECT_UTILS2.g_sqlerrm := SQLERRM ;

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

765:
766: ELSE
767: -- After "deleting" or "deleting and inserting" a set of records
768: -- the transaction is commited. This also creates a record in the
769: -- Pa_Purge_Project_details which will show the no. of records
770: -- that are purged from each table.
771:
772: pa_debug.debug( ' ->Calling pa_purge.CommitProcess ') ;
773: pa_purge.CommitProcess

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

768: -- the transaction is commited. This also creates a record in the
769: -- Pa_Purge_Project_details which will show the no. of records
770: -- that are purged from each table.
771:
772: pa_debug.debug( ' ->Calling pa_purge.CommitProcess ') ;
773: pa_purge.CommitProcess
774: (p_purge_batch_id => p_purge_batch_id,
775: p_project_id => p_project_id,
776: p_table_name => 'PA_PROJECT_ACCUM_BUDGETS',

Line 773: pa_purge.CommitProcess

769: -- Pa_Purge_Project_details which will show the no. of records
770: -- that are purged from each table.
771:
772: pa_debug.debug( ' ->Calling pa_purge.CommitProcess ') ;
773: pa_purge.CommitProcess
774: (p_purge_batch_id => p_purge_batch_id,
775: p_project_id => p_project_id,
776: p_table_name => 'PA_PROJECT_ACCUM_BUDGETS',
777: p_NoOfRecordsIns => l_NoOfRecordsIns,

Line 793: pa_debug.debug('Error Procedure Name := PA_PURGE_SUMMARY.PA_ProjAccumBudgets');

789: WHEN PA_PROJECT_UTILS2.PA_Arch_Pur_Subroutine_Error then
790: RAISE PA_PROJECT_UTILS2.PA_Arch_Pur_Subroutine_Error ;
791:
792: WHEN OTHERS THEN
793: pa_debug.debug('Error Procedure Name := PA_PURGE_SUMMARY.PA_ProjAccumBudgets');
794: pa_debug.debug('Error stage is '||x_err_stage );
795: pa_debug.debug('Error stack is '||x_err_stack );
796: pa_debug.debug(SQLERRM);
797: PA_PROJECT_UTILS2.g_sqlerrm := SQLERRM ;

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

1048:
1049: ELSE
1050: -- After "deleting" or "deleting and inserting" a set of records
1051: -- the transaction is commited. This also creates a record in the
1052: -- Pa_Purge_Project_details which will show the no. of records
1053: -- that are purged from each table.
1054:
1055: pa_debug.debug( ' ->Calling pa_purge.CommitProcess ') ;
1056: pa_purge.CommitProcess

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

1051: -- the transaction is commited. This also creates a record in the
1052: -- Pa_Purge_Project_details which will show the no. of records
1053: -- that are purged from each table.
1054:
1055: pa_debug.debug( ' ->Calling pa_purge.CommitProcess ') ;
1056: pa_purge.CommitProcess
1057: (p_purge_batch_id => p_purge_batch_id,
1058: p_project_id => p_project_id,
1059: p_table_name => 'PA_PROJECT_ACCUM_ACTUALS',

Line 1056: pa_purge.CommitProcess

1052: -- Pa_Purge_Project_details which will show the no. of records
1053: -- that are purged from each table.
1054:
1055: pa_debug.debug( ' ->Calling pa_purge.CommitProcess ') ;
1056: pa_purge.CommitProcess
1057: (p_purge_batch_id => p_purge_batch_id,
1058: p_project_id => p_project_id,
1059: p_table_name => 'PA_PROJECT_ACCUM_ACTUALS',
1060: p_NoOfRecordsIns => l_NoOfRecordsIns,

Line 1076: pa_debug.debug('Error Procedure Name := PA_PURGE_SUMMARY.PA_ProjAccumActuals');

1072: WHEN PA_PROJECT_UTILS2.PA_Arch_Pur_Subroutine_Error THEN
1073: RAISE PA_PROJECT_UTILS2.PA_Arch_Pur_Subroutine_Error ;
1074:
1075: WHEN OTHERS THEN
1076: pa_debug.debug('Error Procedure Name := PA_PURGE_SUMMARY.PA_ProjAccumActuals');
1077: pa_debug.debug('Error stage is '||x_err_stage );
1078: pa_debug.debug('Error stack is '||x_err_stack );
1079: pa_debug.debug(SQLERRM);
1080: PA_PROJECT_UTILS2.g_sqlerrm := SQLERRM ;

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

1254:
1255: ELSE
1256: -- After "deleting" or "deleting and inserting" a set of records
1257: -- the transaction is commited. This also creates a record in the
1258: -- Pa_Purge_Project_details which will show the no. of records
1259: -- that are purged from each table.
1260:
1261: pa_debug.debug( ' ->Calling pa_purge.CommitProcess ') ;
1262: pa_purge.CommitProcess

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

1257: -- the transaction is commited. This also creates a record in the
1258: -- Pa_Purge_Project_details which will show the no. of records
1259: -- that are purged from each table.
1260:
1261: pa_debug.debug( ' ->Calling pa_purge.CommitProcess ') ;
1262: pa_purge.CommitProcess
1263: (p_purge_batch_id => p_purge_batch_id,
1264: p_project_id => p_project_id,
1265: p_table_name => 'PA_RESOURCE_ACCUM_DETAILS',

Line 1262: pa_purge.CommitProcess

1258: -- Pa_Purge_Project_details which will show the no. of records
1259: -- that are purged from each table.
1260:
1261: pa_debug.debug( ' ->Calling pa_purge.CommitProcess ') ;
1262: pa_purge.CommitProcess
1263: (p_purge_batch_id => p_purge_batch_id,
1264: p_project_id => p_project_id,
1265: p_table_name => 'PA_RESOURCE_ACCUM_DETAILS',
1266: p_NoOfRecordsIns => l_NoOfRecordsIns,

Line 1282: pa_debug.debug('Error Procedure Name := PA_PURGE_SUMMARY.PA_ResAccumDetails');

1278: WHEN PA_PROJECT_UTILS2.PA_Arch_Pur_Subroutine_Error THEN
1279: RAISE PA_PROJECT_UTILS2.PA_Arch_Pur_Subroutine_Error ;
1280:
1281: WHEN OTHERS THEN
1282: pa_debug.debug('Error Procedure Name := PA_PURGE_SUMMARY.PA_ResAccumDetails');
1283: pa_debug.debug('Error stage is '||x_err_stage );
1284: pa_debug.debug('Error stack is '||x_err_stack );
1285: pa_debug.debug(SQLERRM);
1286: PA_PROJECT_UTILS2.g_sqlerrm := SQLERRM ;

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

1540:
1541: ELSE
1542: -- After "deleting" or "deleting and inserting" a set of records
1543: -- the transaction is commited. This also creates a record in the
1544: -- Pa_Purge_Project_details which will show the no. of records
1545: -- that are purged from each table.
1546:
1547: pa_debug.debug( ' ->Calling pa_purge.CommitProcess ') ;
1548: pa_purge.CommitProcess

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

1543: -- the transaction is commited. This also creates a record in the
1544: -- Pa_Purge_Project_details which will show the no. of records
1545: -- that are purged from each table.
1546:
1547: pa_debug.debug( ' ->Calling pa_purge.CommitProcess ') ;
1548: pa_purge.CommitProcess
1549: (p_purge_batch_id => p_purge_batch_id,
1550: p_project_id => p_project_id,
1551: p_table_name => 'PA_TXN_ACCUM',

Line 1548: pa_purge.CommitProcess

1544: -- Pa_Purge_Project_details which will show the no. of records
1545: -- that are purged from each table.
1546:
1547: pa_debug.debug( ' ->Calling pa_purge.CommitProcess ') ;
1548: pa_purge.CommitProcess
1549: (p_purge_batch_id => p_purge_batch_id,
1550: p_project_id => p_project_id,
1551: p_table_name => 'PA_TXN_ACCUM',
1552: p_NoOfRecordsIns => l_NoOfRecordsIns,

Line 1568: pa_debug.debug('Error Procedure Name := PA_PURGE_SUMMARY.PA_TxnAccum');

1564: WHEN PA_PROJECT_UTILS2.PA_Arch_Pur_Subroutine_Error THEN
1565: RAISE PA_PROJECT_UTILS2.PA_Arch_Pur_Subroutine_Error ;
1566:
1567: WHEN OTHERS THEN
1568: pa_debug.debug('Error Procedure Name := PA_PURGE_SUMMARY.PA_TxnAccum');
1569: pa_debug.debug('Error stage is '||x_err_stage );
1570: pa_debug.debug('Error stack is '||x_err_stack );
1571: pa_debug.debug(SQLERRM);
1572: PA_PROJECT_UTILS2.g_sqlerrm := SQLERRM ;

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

1752:
1753: ELSE
1754: -- After "deleting" or "deleting and inserting" a set of records
1755: -- the transaction is commited. This also creates a record in the
1756: -- Pa_Purge_Project_details which will show the no. of records
1757: -- that are purged from each table.
1758:
1759: pa_debug.debug( ' ->Calling pa_purge.CommitProcess ') ;
1760: pa_purge.CommitProcess

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

1755: -- the transaction is commited. This also creates a record in the
1756: -- Pa_Purge_Project_details which will show the no. of records
1757: -- that are purged from each table.
1758:
1759: pa_debug.debug( ' ->Calling pa_purge.CommitProcess ') ;
1760: pa_purge.CommitProcess
1761: (p_purge_batch_id => p_purge_batch_id,
1762: p_project_id => p_project_id,
1763: p_table_name => 'PA_TXN_ACCUM_DETAILS',

Line 1760: pa_purge.CommitProcess

1756: -- Pa_Purge_Project_details which will show the no. of records
1757: -- that are purged from each table.
1758:
1759: pa_debug.debug( ' ->Calling pa_purge.CommitProcess ') ;
1760: pa_purge.CommitProcess
1761: (p_purge_batch_id => p_purge_batch_id,
1762: p_project_id => p_project_id,
1763: p_table_name => 'PA_TXN_ACCUM_DETAILS',
1764: p_NoOfRecordsIns => l_NoOfRecordsIns,

Line 1780: pa_debug.debug('Error Procedure Name := PA_PURGE_SUMMARY.PA_TxnAccumDetails');

1776: WHEN PA_PROJECT_UTILS2.PA_Arch_Pur_Subroutine_Error THEN
1777: RAISE PA_PROJECT_UTILS2.PA_Arch_Pur_Subroutine_Error ;
1778:
1779: WHEN OTHERS THEN
1780: pa_debug.debug('Error Procedure Name := PA_PURGE_SUMMARY.PA_TxnAccumDetails');
1781: pa_debug.debug('Error stage is '||x_err_stage );
1782: pa_debug.debug('Error stack is '||x_err_stack );
1783: pa_debug.debug(SQLERRM);
1784: PA_PROJECT_UTILS2.g_sqlerrm := SQLERRM ;

Line 1857: pa_purge_summary.PA_ProjAccumCommitments

1853:
1854: -- Call the procedures to archive/purge data for each summary table
1855: --
1856: pa_debug.debug('*-> About to purge PA_Project_Accum_Commitments ') ;
1857: pa_purge_summary.PA_ProjAccumCommitments
1858: (p_purge_batch_id => p_purge_batch_id,
1859: p_project_id => p_project_id,
1860: p_txn_to_date => p_txn_to_date,
1861: p_purge_release => p_purge_release,

Line 1870: pa_purge_summary.PA_ProjAccumActuals

1866: x_err_stage => x_err_stage
1867: ) ;
1868:
1869: pa_debug.debug('*-> About to purge PA_Project_Accum_Actuals') ;
1870: pa_purge_summary.PA_ProjAccumActuals
1871: (p_purge_batch_id => p_purge_batch_id,
1872: p_project_id => p_project_id,
1873: p_txn_to_date => p_txn_to_date,
1874: p_purge_release => p_purge_release,

Line 1883: pa_purge_summary.PA_ProjAccumBudgets

1879: x_err_stage => x_err_stage
1880: ) ;
1881:
1882: pa_debug.debug('*-> About to purge PA_Project_Accum_Budgets ') ;
1883: pa_purge_summary.PA_ProjAccumBudgets
1884: (p_purge_batch_id => p_purge_batch_id,
1885: p_project_id => p_project_id,
1886: p_txn_to_date => p_txn_to_date,
1887: p_purge_release => p_purge_release,

Line 1896: pa_purge_summary.PA_ResAccumDetails

1892: x_err_stage => x_err_stage
1893: ) ;
1894:
1895: pa_debug.debug('*-> About to purge PA_Resource_Accum_Details ') ;
1896: pa_purge_summary.PA_ResAccumDetails
1897: (p_purge_batch_id => p_purge_batch_id,
1898: p_project_id => p_project_id,
1899: p_txn_to_date => p_txn_to_date,
1900: p_purge_release => p_purge_release,

Line 1909: pa_purge_summary.PA_ProjAccumHeaders

1905: x_err_stage => x_err_stage
1906: ) ;
1907:
1908: pa_debug.debug('*-> About to purge PA_Project_Accum_Headers ') ;
1909: pa_purge_summary.PA_ProjAccumHeaders
1910: (p_purge_batch_id => p_purge_batch_id,
1911: p_project_id => p_project_id,
1912: p_txn_to_date => p_txn_to_date,
1913: p_purge_release => p_purge_release,

Line 1922: pa_purge_summary.PA_TxnAccumDetails

1918: x_err_stage => x_err_stage
1919: ) ;
1920:
1921: pa_debug.debug('*-> About to purge PA_Txn_Accum_Details') ;
1922: pa_purge_summary.PA_TxnAccumDetails
1923: (p_purge_batch_id => p_purge_batch_id,
1924: p_project_id => p_project_id,
1925: p_txn_to_date => p_txn_to_date,
1926: p_purge_release => p_purge_release,

Line 1935: pa_purge_summary.PA_TxnAccum

1931: x_err_stage => x_err_stage
1932: ) ;
1933:
1934: pa_debug.debug('*-> About to purge PA_Txn_Accum') ;
1935: pa_purge_summary.PA_TxnAccum
1936: (p_purge_batch_id => p_purge_batch_id,
1937: p_project_id => p_project_id,
1938: p_txn_to_date => p_txn_to_date,
1939: p_purge_release => p_purge_release,

Line 1955: pa_debug.debug('Error Procedure Name := PA_PURGE_SUMMARY.pa_summary_main_purge' );

1951: WHEN PA_PROJECT_UTILS2.PA_Arch_Pur_Subroutine_Error THEN
1952: RAISE PA_PROJECT_UTILS2.PA_Arch_Pur_Subroutine_Error ;
1953:
1954: WHEN OTHERS THEN
1955: pa_debug.debug('Error Procedure Name := PA_PURGE_SUMMARY.pa_summary_main_purge' );
1956: pa_debug.debug('Error stage is '||x_err_stage );
1957: pa_debug.debug('Error stack is '||x_err_stack );
1958: pa_debug.debug(SQLERRM);
1959: PA_PROJECT_UTILS2.g_sqlerrm := SQLERRM ;

Line 1965: END pa_purge_summary;

1961: RAISE PA_PROJECT_UTILS2.PA_Arch_Pur_Subroutine_Error ;
1962:
1963: END pa_summary_main_purge ;
1964:
1965: END pa_purge_summary;