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_BILLING dependencies on PA_DRAFT_REVENUE_ITEMS

Line 1587: -- Function : Archive and Purge data for table PA_Draft_Revenue_Items

1583: -- Start of comments
1584: -- API name : PA_DraftRevItems
1585: -- Type : Private
1586: -- Pre-reqs : None
1587: -- Function : Archive and Purge data for table PA_Draft_Revenue_Items
1588: -- Parameters : See common list above
1589: -- End of comments
1590: procedure PA_DraftRevItems
1591: ( p_purge_batch_id IN NUMBER,

Line 1682: from pa_draft_revenue_items dri

1678: PROJECT_CURRENCY_CODE,
1679: PROJECT_REVENUE_AMOUNT,
1680: FUNDING_CURRENCY_CODE,
1681: FUNDING_REVENUE_AMOUNT
1682: from pa_draft_revenue_items dri
1683: where (
1684: dri.project_id = p_project_id
1685: and rownum <= l_commit_size
1686: ) ;

Line 1701: pa_debug.debug( ' ->Before delete from pa_draft_revenue_items ') ;

1697: -- selected because if archive option is selected the the records
1698: -- being purged will be those records which are already archived.
1699: -- table and
1700:
1701: pa_debug.debug( ' ->Before delete from pa_draft_revenue_items ') ;
1702: /* commented and modified as below for performance reasons. Archive Purge 11.5
1703: delete from pa_draft_revenue_items dri
1704: where (dri.rowid)
1705: in

Line 1703: delete from pa_draft_revenue_items dri

1699: -- table and
1700:
1701: pa_debug.debug( ' ->Before delete from pa_draft_revenue_items ') ;
1702: /* commented and modified as below for performance reasons. Archive Purge 11.5
1703: delete from pa_draft_revenue_items dri
1704: where (dri.rowid)
1705: in
1706: ( select dri1.rowid
1707: from pa_draft_revenue_items dri1,

Line 1707: from pa_draft_revenue_items dri1,

1703: delete from pa_draft_revenue_items dri
1704: where (dri.rowid)
1705: in
1706: ( select dri1.rowid
1707: from pa_draft_revenue_items dri1,
1708: PA_DRAFT_REV_ITEMS_AR dri2
1709: where dri2.draft_revenue_num = dri1.draft_revenue_num
1710: and dri2.line_num = dri1.line_num
1711: and dri2.project_id = dri1.project_id

Line 1716: /* delete from pa_draft_revenue_items dri

1712: and dri2.purge_project_id = p_project_id
1713: ) ;
1714: */
1715: /* Commented the delete statement and added the modified code below not to correlate queries */
1716: /* delete from pa_draft_revenue_items dri
1717: where (dri.project_id, dri.draft_revenue_num) in
1718: ( select dri2.project_id, dri2.draft_revenue_num
1719: from PA_DRAFT_REV_ITEMS_AR dri2
1720: where dri2.line_num = dri.line_num

Line 1724: delete from pa_draft_revenue_items dri

1720: where dri2.line_num = dri.line_num
1721: and dri2.purge_project_id = p_project_id
1722: ) ;
1723: */
1724: delete from pa_draft_revenue_items dri
1725: where (dri.project_id, dri.draft_revenue_num, dri.line_num) in
1726: ( select dri2.project_id, dri2.draft_revenue_num, dri2.line_num
1727: from PA_DRAFT_REV_ITEMS_AR dri2
1728: where dri2.purge_project_id = p_project_id

Line 1734: pa_debug.debug( ' ->After delete from pa_draft_revenue_items ') ;

1730: /*Code Changes for Bug No.2984871 start */
1731: l_NoOfRecordsDel := SQL%ROWCOUNT ;
1732: /*Code Changes for Bug No.2984871 end */
1733:
1734: pa_debug.debug( ' ->After delete from pa_draft_revenue_items ') ;
1735:
1736: end if ;
1737: else
1738:

Line 1744: pa_debug.debug( ' ->Before delete from pa_draft_revenue_items ') ;

1740:
1741: -- If the archive option is not selected then the delete will
1742: -- be based on the commit size.
1743:
1744: pa_debug.debug( ' ->Before delete from pa_draft_revenue_items ') ;
1745: /* commented and modified as below for performance reasons. Archive Purge 11.5
1746: delete from pa_draft_revenue_items dri
1747: where (dri.rowid)
1748: in

Line 1746: delete from pa_draft_revenue_items dri

1742: -- be based on the commit size.
1743:
1744: pa_debug.debug( ' ->Before delete from pa_draft_revenue_items ') ;
1745: /* commented and modified as below for performance reasons. Archive Purge 11.5
1746: delete from pa_draft_revenue_items dri
1747: where (dri.rowid)
1748: in
1749: ( select dri1.rowid
1750: from pa_draft_revenue_items dri1

Line 1750: from pa_draft_revenue_items dri1

1746: delete from pa_draft_revenue_items dri
1747: where (dri.rowid)
1748: in
1749: ( select dri1.rowid
1750: from pa_draft_revenue_items dri1
1751: where dri1.project_id = p_project_id
1752: and rownum <= l_commit_size
1753: ) ;
1754: */

Line 1755: delete from pa_draft_revenue_items dri

1751: where dri1.project_id = p_project_id
1752: and rownum <= l_commit_size
1753: ) ;
1754: */
1755: delete from pa_draft_revenue_items dri
1756: where dri.project_id = p_project_id
1757: and rownum <= l_commit_size;
1758: /*Code Changes for Bug No.2984871 start */
1759: l_NoOfRecordsDel := SQL%ROWCOUNT ;

Line 1762: pa_debug.debug( ' ->After delete from pa_draft_revenue_items ') ;

1758: /*Code Changes for Bug No.2984871 start */
1759: l_NoOfRecordsDel := SQL%ROWCOUNT ;
1760: /*Code Changes for Bug No.2984871 end */
1761:
1762: pa_debug.debug( ' ->After delete from pa_draft_revenue_items ') ;
1763: end if ;
1764:
1765: /*Code Changes for Bug No.2984871 start */
1766: if l_NoOfRecordsDel= 0 then

Line 1783: p_table_name => 'PA_DRAFT_REVENUE_ITEMS',

1779: pa_debug.debug( ' ->Calling pa_purge.CommitProcess ') ;
1780: pa_purge.CommitProcess
1781: (p_purge_batch_id => p_purge_batch_id,
1782: p_project_id => p_project_id,
1783: p_table_name => 'PA_DRAFT_REVENUE_ITEMS',
1784: p_NoOfRecordsIns => l_NoOfRecordsIns,
1785: p_NoOfRecordsDel => l_NoOfRecordsDel,
1786: x_err_code => x_err_code,
1787: x_err_stack => x_err_stack,