APPS.PA_PURGE_SUMMARY dependencies on PA_TXN_ACCUM_DETAILS_AR

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