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_EVENTS

Line 1119: PA_Events_AR ar

1115: mc.Projfunc_Inv_Rate_Date,
1116: mc.Projfunc_Inv_Exchange_Rate,
1117: mc.description
1118: from Pa_Mc_Events mc,
1119: PA_Events_AR ar
1120: where ar.Purge_Project_Id = p_project_id
1121: and mc.event_id = ar.event_id;
1122: */
1123:

Line 1152: -- Function : Archive and Purge data for table PA_EVENTS

1148: -- Start of comments
1149: -- API name : PA_Event
1150: -- Type : Private
1151: -- Pre-reqs : None
1152: -- Function : Archive and Purge data for table PA_EVENTS
1153: -- Parameters : See common list above
1154: -- End of comments
1155: procedure PA_Event
1156: ( p_purge_batch_id IN NUMBER,

Line 1194: pa_debug.debug( ' ->Before insert into PA_Events_AR') ;

1190: -- in the commit size.
1191:
1192: l_commit_size := pa_utils2.arpur_mrc_commit_size / 2 ;
1193:
1194: pa_debug.debug( ' ->Before insert into PA_Events_AR') ;
1195:
1196: /* Funding MRC Changes : Added the column zero_revenue_amount_flag */
1197:
1198: insert into PA_Events_AR

Line 1198: insert into PA_Events_AR

1194: pa_debug.debug( ' ->Before insert into PA_Events_AR') ;
1195:
1196: /* Funding MRC Changes : Added the column zero_revenue_amount_flag */
1197:
1198: insert into PA_Events_AR
1199: (
1200: PURGE_BATCH_ID,
1201: PURGE_RELEASE,
1202: PURGE_PROJECT_ID,

Line 1434: from pa_events

1430: deliverable_id,
1431: action_id,
1432: record_version_number,
1433: agreement_id
1434: from pa_events
1435: where (
1436: project_id = p_project_id
1437: and rownum <= l_commit_size
1438: ) ;

Line 1442: pa_debug.debug( ' ->After insert into PA_Events_AR') ;

1438: ) ;
1439:
1440: l_NoOfRecordsIns := SQL%ROWCOUNT;
1441:
1442: pa_debug.debug( ' ->After insert into PA_Events_AR') ;
1443:
1444:
1445: /*Code Changes for Bug No.2984871 start */
1446: if l_NoOfRecordsIns > 0 then

Line 1466: pa_debug.debug( ' ->Before delete from pa_events ') ;

1462: x_err_stack => x_err_stack,
1463: x_err_stage => x_err_stage
1464: ) ;
1465:
1466: pa_debug.debug( ' ->Before delete from pa_events ') ;
1467: /* commented and modified as below for performance reasons. Archive Purge 11.5
1468: delete from pa_events ev
1469: where (ev.rowid)
1470: in

Line 1468: delete from pa_events ev

1464: ) ;
1465:
1466: pa_debug.debug( ' ->Before delete from pa_events ') ;
1467: /* commented and modified as below for performance reasons. Archive Purge 11.5
1468: delete from pa_events ev
1469: where (ev.rowid)
1470: in
1471: ( select ev1.rowid
1472: from pa_events ev1,

Line 1472: from pa_events ev1,

1468: delete from pa_events ev
1469: where (ev.rowid)
1470: in
1471: ( select ev1.rowid
1472: from pa_events ev1,
1473: pa_events_ar ev2
1474: where nvl(ev2.task_id,-99) = nvl(ev1.task_id,-99)
1475: and ev2.event_num = ev1.event_num
1476: and ev2.project_id = ev1.project_id

Line 1473: pa_events_ar ev2

1469: where (ev.rowid)
1470: in
1471: ( select ev1.rowid
1472: from pa_events ev1,
1473: pa_events_ar ev2
1474: where nvl(ev2.task_id,-99) = nvl(ev1.task_id,-99)
1475: and ev2.event_num = ev1.event_num
1476: and ev2.project_id = ev1.project_id
1477: and ev2.purge_project_id = p_project_id

Line 1480: delete from pa_events ev

1476: and ev2.project_id = ev1.project_id
1477: and ev2.purge_project_id = p_project_id
1478: ) ;
1479: */
1480: delete from pa_events ev
1481: where (ev.project_id, ev.event_num) in
1482: ( select ev2.project_id, ev2.event_num
1483: from pa_events_ar ev2
1484: where nvl(ev2.task_id,-99) = nvl(ev.task_id,-99)

Line 1483: from pa_events_ar ev2

1479: */
1480: delete from pa_events ev
1481: where (ev.project_id, ev.event_num) in
1482: ( select ev2.project_id, ev2.event_num
1483: from pa_events_ar ev2
1484: where nvl(ev2.task_id,-99) = nvl(ev.task_id,-99)
1485: and ev2.purge_project_id = p_project_id
1486: )
1487: and ev.project_id = p_project_id; -- Perf Bug 2695202

Line 1494: pa_debug.debug( ' ->After delete from pa_events ') ;

1490: l_NoOfRecordsDel := SQL%ROWCOUNT ;
1491: l_MC_NoOfRecordsDel := PA_UTILS2.mrc_row_count;
1492: /*Code Changes for Bug No.2984871 end */
1493:
1494: pa_debug.debug( ' ->After delete from pa_events ') ;
1495:
1496:
1497: end if ;
1498: else

Line 1505: pa_debug.debug( ' ->Before delete from pa_events ') ;

1501:
1502: -- If the archive option is not selected then the delete will
1503: -- be based on the commit size.
1504:
1505: pa_debug.debug( ' ->Before delete from pa_events ') ;
1506: /* commented and modified as below for performance reasons. Archive Purge 11.5
1507: delete from pa_events ev
1508: where (ev.rowid)
1509: in

Line 1507: delete from pa_events ev

1503: -- be based on the commit size.
1504:
1505: pa_debug.debug( ' ->Before delete from pa_events ') ;
1506: /* commented and modified as below for performance reasons. Archive Purge 11.5
1507: delete from pa_events ev
1508: where (ev.rowid)
1509: in
1510: ( select ev1.rowid
1511: from pa_events ev1

Line 1511: from pa_events ev1

1507: delete from pa_events ev
1508: where (ev.rowid)
1509: in
1510: ( select ev1.rowid
1511: from pa_events ev1
1512: where ev1.project_id = p_project_id
1513: and rownum <= l_commit_size
1514: ) ;
1515: */

Line 1516: delete from pa_events ev

1512: where ev1.project_id = p_project_id
1513: and rownum <= l_commit_size
1514: ) ;
1515: */
1516: delete from pa_events ev
1517: where ev.project_id = p_project_id
1518: and rownum <= l_commit_size;
1519: /*Code Changes for Bug No.2984871 start */
1520: l_NoOfRecordsDel := SQL%ROWCOUNT ;

Line 1524: pa_debug.debug( ' ->After delete from pa_events ') ;

1520: l_NoOfRecordsDel := SQL%ROWCOUNT ;
1521: l_MC_NoOfRecordsDel := PA_UTILS2.mrc_row_count;
1522: /*Code Changes for Bug No.2984871 end */
1523:
1524: pa_debug.debug( ' ->After delete from pa_events ') ;
1525:
1526: end if ;
1527:
1528: /*Code Changes for Bug No.2984871 start */

Line 1547: p_table_name => 'PA_EVENTS',

1543: pa_debug.debug( ' ->Calling pa_purge.CommitProcess ') ;
1544: pa_purge.CommitProcess
1545: (p_purge_batch_id => p_purge_batch_id,
1546: p_project_id => p_project_id,
1547: p_table_name => 'PA_EVENTS',
1548: p_NoOfRecordsIns => l_NoOfRecordsIns,
1549: p_NoOfRecordsDel => l_NoOfRecordsDel,
1550: x_err_code => x_err_code,
1551: x_err_stack => x_err_stack,