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

Line 1337: pa_debug.debug( ' ->Before insert into PA_Txn_Accum_AR') ;

1333:
1334: l_commit_size := p_commit_size / 2 ;
1335:
1336:
1337: pa_debug.debug( ' ->Before insert into PA_Txn_Accum_AR') ;
1338:
1339: INSERT INTO PA_Txn_Accum_AR
1340: (
1341: PURGE_BATCH_ID,

Line 1339: INSERT INTO PA_Txn_Accum_AR

1335:
1336:
1337: pa_debug.debug( ' ->Before insert into PA_Txn_Accum_AR') ;
1338:
1339: INSERT INTO PA_Txn_Accum_AR
1340: (
1341: PURGE_BATCH_ID,
1342: PURGE_RELEASE,
1343: PURGE_PROJECT_ID,

Line 1465: FROM pa_txn_accum ta

1461: PROGRAM_APPLICATION_ID,
1462: PROGRAM_ID,
1463: PROGRAM_UPDATE_DATE,
1464: ADW_NOTIFY_FLAG
1465: FROM pa_txn_accum ta
1466: WHERE ta.project_id = p_project_id
1467: AND rownum < l_commit_size;
1468: /*Code Changes for Bug No.2984871 start */
1469: l_NoOfRecordsIns := SQL%ROWCOUNT ;

Line 1472: pa_debug.debug( ' ->After insert into PA_Txn_Accum_AR') ;

1468: /*Code Changes for Bug No.2984871 start */
1469: l_NoOfRecordsIns := SQL%ROWCOUNT ;
1470: /*Code Changes for Bug No.2984871 end */
1471:
1472: pa_debug.debug( ' ->After insert into PA_Txn_Accum_AR') ;
1473:
1474: /*Code Changes for Bug No.2984871 start */
1475: IF l_NoOfRecordsIns > 0 THEN
1476: /*Code Changes for Bug No.2984871 end */

Line 1484: pa_debug.debug( ' ->Before delete from pa_txn_accum ') ;

1480: -- joins the original and the archived table on the basis of a
1481: -- unique key and uses rowid of records in original table to hit
1482: -- the records to be deleted
1483:
1484: pa_debug.debug( ' ->Before delete from pa_txn_accum ') ;
1485: /* commented and modified as below for performance reasons. Archive Purge 11.5
1486: DELETE FROM pa_txn_accum ta
1487: WHERE (ta.rowid) IN
1488: ( SELECT ta1.rowid

Line 1486: DELETE FROM pa_txn_accum ta

1482: -- the records to be deleted
1483:
1484: pa_debug.debug( ' ->Before delete from pa_txn_accum ') ;
1485: /* commented and modified as below for performance reasons. Archive Purge 11.5
1486: DELETE FROM pa_txn_accum ta
1487: WHERE (ta.rowid) IN
1488: ( SELECT ta1.rowid
1489: FROM pa_txn_accum ta1,
1490: pa_txn_accum_ar ta2

Line 1489: FROM pa_txn_accum ta1,

1485: /* commented and modified as below for performance reasons. Archive Purge 11.5
1486: DELETE FROM pa_txn_accum ta
1487: WHERE (ta.rowid) IN
1488: ( SELECT ta1.rowid
1489: FROM pa_txn_accum ta1,
1490: pa_txn_accum_ar ta2
1491: WHERE ta1.txn_accum_id = ta2.txn_accum_id
1492: AND ta2.purge_project_id = p_project_id
1493: ) ;

Line 1490: pa_txn_accum_ar ta2

1486: DELETE FROM pa_txn_accum ta
1487: WHERE (ta.rowid) IN
1488: ( SELECT ta1.rowid
1489: FROM pa_txn_accum ta1,
1490: pa_txn_accum_ar ta2
1491: WHERE ta1.txn_accum_id = ta2.txn_accum_id
1492: AND ta2.purge_project_id = p_project_id
1493: ) ;
1494: */

Line 1495: DELETE FROM pa_txn_accum ta

1491: WHERE ta1.txn_accum_id = ta2.txn_accum_id
1492: AND ta2.purge_project_id = p_project_id
1493: ) ;
1494: */
1495: DELETE FROM pa_txn_accum ta
1496: WHERE (ta.txn_accum_id) IN
1497: ( SELECT ta2.txn_accum_id
1498: FROM pa_txn_accum_ar ta2
1499: WHERE ta2.purge_project_id = p_project_id

Line 1498: FROM pa_txn_accum_ar ta2

1494: */
1495: DELETE FROM pa_txn_accum ta
1496: WHERE (ta.txn_accum_id) IN
1497: ( SELECT ta2.txn_accum_id
1498: FROM pa_txn_accum_ar ta2
1499: WHERE ta2.purge_project_id = p_project_id
1500: ) ;
1501: /*Code Changes for Bug No.2984871 start */
1502: l_NoOfRecordsDel := SQL%ROWCOUNT ;

Line 1505: pa_debug.debug( ' ->After delete from pa_txn_accum ') ;

1501: /*Code Changes for Bug No.2984871 start */
1502: l_NoOfRecordsDel := SQL%ROWCOUNT ;
1503: /*Code Changes for Bug No.2984871 end */
1504:
1505: pa_debug.debug( ' ->After delete from pa_txn_accum ') ;
1506: END IF ;
1507: ELSE
1508:
1509: l_commit_size := p_commit_size ;

Line 1514: pa_debug.debug( ' ->Before delete from pa_txn_accum ') ;

1510:
1511: -- If the archive option is not selected then the delete will
1512: -- be based on the commit size.
1513:
1514: pa_debug.debug( ' ->Before delete from pa_txn_accum ') ;
1515: /* commented and modified as below for performance reasons. Archive Purge 11.5
1516: DELETE FROM pa_txn_accum ta
1517: WHERE (ta.rowid) IN
1518: ( SELECT ta.rowid

Line 1516: DELETE FROM pa_txn_accum ta

1512: -- be based on the commit size.
1513:
1514: pa_debug.debug( ' ->Before delete from pa_txn_accum ') ;
1515: /* commented and modified as below for performance reasons. Archive Purge 11.5
1516: DELETE FROM pa_txn_accum ta
1517: WHERE (ta.rowid) IN
1518: ( SELECT ta.rowid
1519: FROM pa_txn_accum ta
1520: WHERE ta.project_id = p_project_id

Line 1519: FROM pa_txn_accum ta

1515: /* commented and modified as below for performance reasons. Archive Purge 11.5
1516: DELETE FROM pa_txn_accum ta
1517: WHERE (ta.rowid) IN
1518: ( SELECT ta.rowid
1519: FROM pa_txn_accum ta
1520: WHERE ta.project_id = p_project_id
1521: AND rownum <= l_commit_size
1522: ) ;
1523: */

Line 1524: DELETE FROM pa_txn_accum ta

1520: WHERE ta.project_id = p_project_id
1521: AND rownum <= l_commit_size
1522: ) ;
1523: */
1524: DELETE FROM pa_txn_accum ta
1525: WHERE ta.project_id = p_project_id
1526: AND rownum <= l_commit_size;
1527:
1528: /*Code Changes for Bug No.2984871 start */

Line 1531: pa_debug.debug( ' ->After delete from pa_txn_accum ') ;

1527:
1528: /*Code Changes for Bug No.2984871 start */
1529: l_NoOfRecordsDel := SQL%ROWCOUNT ;
1530: /*Code Changes for Bug No.2984871 end */
1531: pa_debug.debug( ' ->After delete from pa_txn_accum ') ;
1532: END IF ;
1533:
1534: IF l_NoOfRecordsDel = 0 THEN
1535: -- Once the SqlCount becomes 0, which means that there are

Line 1550: p_table_name => 'PA_TXN_ACCUM',

1546: pa_debug.debug( ' ->Calling pa_purge.CommitProcess ') ;
1547: pa_purge.CommitProcess
1548: (p_purge_batch_id => p_purge_batch_id,
1549: p_project_id => p_project_id,
1550: p_table_name => 'PA_TXN_ACCUM',
1551: p_NoOfRecordsIns => l_NoOfRecordsIns,
1552: p_NoOfRecordsDel => l_NoOfRecordsDel,
1553: x_err_code => x_err_code,
1554: x_err_stack => x_err_stack,

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 1625: -- Modified insert statement to use project_id from pa_txn_accum to select rows from

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.
1628:
1629: INSERT INTO PA_Txn_Accum_Details_AR

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 1627: -- project_id is a not null column in pa_txn_accum.

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: (
1631: PURGE_BATCH_ID,

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 1676: pa_txn_accum pta

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;
1680:

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 1734: FROM pa_txn_accum pta

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)
1736: AND rownum <= l_commit_size;
1737:
1738:

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,

Line 1934: pa_debug.debug('*-> About to purge PA_Txn_Accum') ;

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