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_TXN_ACCUM_DETAILS

Line 1623: pa_debug.debug( ' ->Before insert into PA_Txn_Accum_Details_AR') ;

1619:
1620: l_commit_size := p_commit_size / 2 ;
1621:
1622:
1623: pa_debug.debug( ' ->Before insert into PA_Txn_Accum_Details_AR') ;
1624:
1625: -- Modified insert statement to use project_id from pa_txn_accum to select rows from
1626: -- pa_txn_accum_details as project_id may be null for some detail lines
1627: -- project_id is a not null column in pa_txn_accum.

Line 1626: -- pa_txn_accum_details as project_id may be null for some detail lines

1622:
1623: pa_debug.debug( ' ->Before insert into PA_Txn_Accum_Details_AR') ;
1624:
1625: -- Modified insert statement to use project_id from pa_txn_accum to select rows from
1626: -- pa_txn_accum_details as project_id may be null for some detail lines
1627: -- project_id is a not null column in pa_txn_accum.
1628:
1629: INSERT INTO PA_Txn_Accum_Details_AR
1630: (

Line 1629: INSERT INTO PA_Txn_Accum_Details_AR

1625: -- Modified insert statement to use project_id from pa_txn_accum to select rows from
1626: -- pa_txn_accum_details as project_id may be null for some detail lines
1627: -- project_id is a not null column in pa_txn_accum.
1628:
1629: INSERT INTO PA_Txn_Accum_Details_AR
1630: (
1631: PURGE_BATCH_ID,
1632: PURGE_RELEASE,
1633: PURGE_PROJECT_ID,

Line 1675: FROM pa_txn_accum_details tad,

1671: tad.REQUEST_ID,
1672: tad.PROGRAM_APPLICATION_ID,
1673: tad.PROGRAM_ID,
1674: tad.PROGRAM_UPDATE_DATE
1675: FROM pa_txn_accum_details tad,
1676: pa_txn_accum pta
1677: WHERE tad.txn_accum_id = pta.txn_accum_id
1678: AND pta.project_id = p_project_id
1679: AND rownum < l_commit_size;

Line 1686: pa_debug.debug( ' ->After insert into PA_Txn_Accum_Details_AR') ;

1682: /*Code Changes for Bug No.2984871 start */
1683: l_NoOfRecordsIns := SQL%ROWCOUNT ;
1684: /*Code Changes for Bug No.2984871 end */
1685:
1686: pa_debug.debug( ' ->After insert into PA_Txn_Accum_Details_AR') ;
1687:
1688: IF l_NoOfRecordsIns > 0 THEN
1689: -- The algorithm for deleting records from original table
1690: -- depends on whether records are being archived or not.

Line 1696: pa_debug.debug( ' ->Before delete from pa_txn_accum_details ') ;

1692: -- joins the original and the archived table on the basis of a
1693: -- unique key and uses rowid of records in original table to hit
1694: -- the records to be deleted
1695:
1696: pa_debug.debug( ' ->Before delete from pa_txn_accum_details ') ;
1697:
1698: DELETE FROM pa_txn_accum_details tad
1699: WHERE (tad.rowid) IN
1700: ( SELECT tad2.original_rowid

Line 1698: DELETE FROM pa_txn_accum_details tad

1694: -- the records to be deleted
1695:
1696: pa_debug.debug( ' ->Before delete from pa_txn_accum_details ') ;
1697:
1698: DELETE FROM pa_txn_accum_details tad
1699: WHERE (tad.rowid) IN
1700: ( SELECT tad2.original_rowid
1701: FROM pa_txn_accum_details tad1,
1702: pa_txn_accum_details_ar tad2

Line 1701: FROM pa_txn_accum_details tad1,

1697:
1698: DELETE FROM pa_txn_accum_details tad
1699: WHERE (tad.rowid) IN
1700: ( SELECT tad2.original_rowid
1701: FROM pa_txn_accum_details tad1,
1702: pa_txn_accum_details_ar tad2
1703: WHERE tad1.rowid = tad2.original_rowid
1704: -- AND tad1.project_id=tad2.project_id
1705: AND tad2.purge_project_id = p_project_id

Line 1702: pa_txn_accum_details_ar tad2

1698: DELETE FROM pa_txn_accum_details tad
1699: WHERE (tad.rowid) IN
1700: ( SELECT tad2.original_rowid
1701: FROM pa_txn_accum_details tad1,
1702: pa_txn_accum_details_ar tad2
1703: WHERE tad1.rowid = tad2.original_rowid
1704: -- AND tad1.project_id=tad2.project_id
1705: AND tad2.purge_project_id = p_project_id
1706: ) ;

Line 1710: pa_debug.debug( ' ->After delete from pa_txn_accum_details ') ;

1706: ) ;
1707: /*Code Changes for Bug No.2984871 start */
1708: l_NoOfRecordsDel := SQL%ROWCOUNT ;
1709: /*Code Changes for Bug No.2984871 end */
1710: pa_debug.debug( ' ->After delete from pa_txn_accum_details ') ;
1711: END IF ;
1712: ELSE
1713:
1714: l_commit_size := p_commit_size ;

Line 1719: pa_debug.debug( ' ->Before delete from pa_txn_accum_details ') ;

1715:
1716: -- If the archive option is not selected then the delete will
1717: -- be based on the commit size.
1718:
1719: pa_debug.debug( ' ->Before delete from pa_txn_accum_details ') ;
1720: /* commented and modified as below for performance reasons. Archive Purge 11.5
1721: DELETE FROM pa_txn_accum_details tad
1722: WHERE (tad.rowid) IN
1723: ( SELECT tad1.rowid

Line 1721: DELETE FROM pa_txn_accum_details tad

1717: -- be based on the commit size.
1718:
1719: pa_debug.debug( ' ->Before delete from pa_txn_accum_details ') ;
1720: /* commented and modified as below for performance reasons. Archive Purge 11.5
1721: DELETE FROM pa_txn_accum_details tad
1722: WHERE (tad.rowid) IN
1723: ( SELECT tad1.rowid
1724: FROM pa_txn_accum_details tad1, pa_txn_accum pta
1725: WHERE tad1.txn_accum_id = pta.txn_accum_id

Line 1724: FROM pa_txn_accum_details tad1, pa_txn_accum pta

1720: /* commented and modified as below for performance reasons. Archive Purge 11.5
1721: DELETE FROM pa_txn_accum_details tad
1722: WHERE (tad.rowid) IN
1723: ( SELECT tad1.rowid
1724: FROM pa_txn_accum_details tad1, pa_txn_accum pta
1725: WHERE tad1.txn_accum_id = pta.txn_accum_id
1726: AND pta.project_id = p_project_id
1727: AND rownum <= l_commit_size
1728: ) ;

Line 1731: DELETE FROM pa_txn_accum_details tad

1727: AND rownum <= l_commit_size
1728: ) ;
1729: */
1730: --Fix for bug#7701114
1731: DELETE FROM pa_txn_accum_details tad
1732: WHERE (tad.txn_accum_id) IN
1733: ( SELECT pta.txn_accum_id
1734: FROM pa_txn_accum pta
1735: WHERE pta.project_id = p_project_id)

Line 1742: pa_debug.debug( ' ->After delete from pa_txn_accum_details ') ;

1738:
1739: /*Code Changes for Bug No.2984871 start */
1740: l_NoOfRecordsDel := SQL%ROWCOUNT ;
1741: /*Code Changes for Bug No.2984871 end */
1742: pa_debug.debug( ' ->After delete from pa_txn_accum_details ') ;
1743: END IF ;
1744:
1745: /*Code Changes for Bug No.2984871 start */
1746: IF l_NoOfRecordsDel = 0 THEN

Line 1763: p_table_name => 'PA_TXN_ACCUM_DETAILS',

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,
1765: p_NoOfRecordsDel => l_NoOfRecordsDel,
1766: x_err_code => x_err_code,
1767: x_err_stack => x_err_stack,

Line 1921: pa_debug.debug('*-> About to purge PA_Txn_Accum_Details') ;

1917: x_err_stack => x_err_stack,
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,