APPS.PA_PURGE_BILLING dependencies on PA_DRAFT_REV_ITEMS_AR

Line 1626: pa_debug.debug( ' ->Before insert into PA_DRAFT_REV_ITEMS_AR') ;

1622: -- in the commit size.
1623:
1624: l_commit_size := pa_utils2.arpur_mrc_commit_size / 2 ;
1625:
1626: pa_debug.debug( ' ->Before insert into PA_DRAFT_REV_ITEMS_AR') ;
1627: insert into PA_DRAFT_REV_ITEMS_AR (
1628: PURGE_BATCH_ID,
1629: PURGE_RELEASE,
1630: PURGE_PROJECT_ID,

Line 1627: insert into PA_DRAFT_REV_ITEMS_AR (

1623:
1624: l_commit_size := pa_utils2.arpur_mrc_commit_size / 2 ;
1625:
1626: pa_debug.debug( ' ->Before insert into PA_DRAFT_REV_ITEMS_AR') ;
1627: insert into PA_DRAFT_REV_ITEMS_AR (
1628: PURGE_BATCH_ID,
1629: PURGE_RELEASE,
1630: PURGE_PROJECT_ID,
1631: PROJECT_ID,

Line 1690: pa_debug.debug( ' ->After insert into PA_DRAFT_REV_ITEMS_AR') ;

1686: ) ;
1687:
1688: l_NoOfRecordsIns := SQL%ROWCOUNT ;
1689:
1690: pa_debug.debug( ' ->After insert into PA_DRAFT_REV_ITEMS_AR') ;
1691:
1692: /*Code Changes for Bug No.2984871 start */
1693: if l_NoOfRecordsIns > 0 then
1694: /*Code Changes for Bug No.2984871 end */

Line 1708: PA_DRAFT_REV_ITEMS_AR dri2

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
1712: and dri2.purge_project_id = p_project_id

Line 1719: from PA_DRAFT_REV_ITEMS_AR dri2

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
1721: and dri2.purge_project_id = p_project_id
1722: ) ;
1723: */

Line 1727: from PA_DRAFT_REV_ITEMS_AR dri2

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
1729: ) ;
1730: /*Code Changes for Bug No.2984871 start */
1731: l_NoOfRecordsDel := SQL%ROWCOUNT ;