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 1338: pa_debug.debug( ' ->Before insert into PA_Txn_Accum_AR') ;

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

Line 1340: INSERT INTO PA_Txn_Accum_AR

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

Line 1466: FROM pa_txn_accum ta

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

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

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

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

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

Line 1487: DELETE FROM pa_txn_accum ta

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

Line 1490: FROM pa_txn_accum ta1,

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

Line 1491: pa_txn_accum_ar ta2

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

Line 1496: DELETE FROM pa_txn_accum ta

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

Line 1499: FROM pa_txn_accum_ar ta2

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

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

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

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

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

Line 1517: DELETE FROM pa_txn_accum ta

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

Line 1520: FROM pa_txn_accum ta

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

Line 1525: DELETE FROM pa_txn_accum ta

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

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

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

Line 1551: p_table_name => 'PA_TXN_ACCUM',

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,
1553: p_NoOfRecordsDel => l_NoOfRecordsDel,
1554: x_err_code => x_err_code,
1555: x_err_stack => x_err_stack,

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

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

Line 1626: -- Modified insert statement to use project_id from pa_txn_accum to select rows from

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

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

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

Line 1628: -- project_id is a not null column in pa_txn_accum.

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

Line 1630: INSERT INTO PA_Txn_Accum_Details_AR

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

Line 1676: FROM pa_txn_accum_details tad,

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

Line 1677: pa_txn_accum pta

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

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

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

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

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

Line 1699: DELETE FROM pa_txn_accum_details tad

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

Line 1702: FROM pa_txn_accum_details tad1,

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

Line 1703: pa_txn_accum_details_ar tad2

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

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

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

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

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

Line 1722: DELETE FROM pa_txn_accum_details tad

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

Line 1725: FROM pa_txn_accum_details tad1, pa_txn_accum pta

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

Line 1731: DELETE FROM pa_txn_accum_details tad

1727: AND pta.project_id = p_project_id
1728: AND rownum <= l_commit_size
1729: ) ;
1730: */
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: */
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,