APPS.PA_PURGE_PJR_TXNS dependencies on PA_SCHEDULES_HISTORY

Line 1271: -- Function : Purge procedure for Purging records from tables PA_Schedules, pa_schedules_history and

1267: -- Start of comments
1268: -- API name : PA_SCHEDULES_PURGE
1269: -- Type : Public
1270: -- Pre-reqs : None
1271: -- Function : Purge procedure for Purging records from tables PA_Schedules, pa_schedules_history and
1272: -- pa_schedule_except_history tables.
1273:
1274: Procedure PA_SCHEDULES_PURGE ( p_purge_batch_id in NUMBER,
1275: p_project_id in NUMBER,

Line 1476: FROM pa_schedules_history WHERE schedule_id=l_schedule_id;

1472: Created_By,
1473: Last_Update_Date,
1474: Last_Update_By,
1475: Last_Update_Login
1476: FROM pa_schedules_history WHERE schedule_id=l_schedule_id;
1477:
1478: /*Increase the value of l_nos_schedule_his_inserted to indicate number of records inserted in schedule_history_ar
1479: table. The value will increase for each loop*/
1480:

Line 1489: x_err_stage := 'Deleting Records from pa_schedules_history table for id '||to_char(l_schedule_id) ;

1485: /*To keep the count of no os records deleted from pa_forecast_items and pa_forecast_item_details, manipulate the
1486: count of l_nos_of fi_deleted and l_nos_fis_deleted. */
1487:
1488: pa_debug.debug('Deleting Records from pa_schedule_history table ') ;
1489: x_err_stage := 'Deleting Records from pa_schedules_history table for id '||to_char(l_schedule_id) ;
1490:
1491: DELETE PA_SCHEDULES_HISTORY
1492: WHERE schedule_id =l_schedule_id;
1493:

Line 1491: DELETE PA_SCHEDULES_HISTORY

1487:
1488: pa_debug.debug('Deleting Records from pa_schedule_history table ') ;
1489: x_err_stage := 'Deleting Records from pa_schedules_history table for id '||to_char(l_schedule_id) ;
1490:
1491: DELETE PA_SCHEDULES_HISTORY
1492: WHERE schedule_id =l_schedule_id;
1493:
1494: l_nos_schedule_his_deleted :=l_nos_schedule_his_deleted + SQL%ROWCOUNT;
1495:

Line 1620: The procedure is called pa_schedules, pa_schedule_except_history and pa_schedules_history tables */

1616: END LOOP;
1617:
1618: /*After "deleting" or "deleting and inserting" a set of records the transaction is commited. This also creates a record in
1619: the Pa_Purge_Project_details, which will show the no. of records that are purged from each table.
1620: The procedure is called pa_schedules, pa_schedule_except_history and pa_schedules_history tables */
1621:
1622: pa_purge.CommitProcess(p_purge_batch_id,
1623: p_project_id,
1624: 'PA_SCHEDULES',

Line 1634: 'PA_SCHEDULES_HISTORY',

1630: ) ;
1631:
1632: pa_purge.CommitProcess(p_purge_batch_id,
1633: p_project_id,
1634: 'PA_SCHEDULES_HISTORY',
1635: l_nos_schedule_his_inserted,
1636: l_nos_schedule_his_deleted,
1637: x_err_code,
1638: x_err_stack,

Line 1941: The procedure is called pa_schedules, pa_schedule_except_history and pa_schedules_history tables */

1937: END LOOP;
1938:
1939: /*After "deleting" or "deleting and inserting" a set of records the transaction is commited. This also creates a record in
1940: the Pa_Purge_Project_details, which will show the no. of records that are purged from each table.
1941: The procedure is called pa_schedules, pa_schedule_except_history and pa_schedules_history tables */
1942:
1943: pa_purge.CommitProcess(p_purge_batch_id,
1944: p_project_id,
1945: 'PA_CANDIDATES',

Line 2112: The procedure is called pa_schedules, pa_schedule_except_history and pa_schedules_history tables */

2108: END LOOP;
2109:
2110: /*After "deleting" or "deleting and inserting" a set of records the transaction is commited. This also creates a record in
2111: the Pa_Purge_Project_details, which will show the no. of records that are purged from each table.
2112: The procedure is called pa_schedules, pa_schedule_except_history and pa_schedules_history tables */
2113:
2114: pa_purge.CommitProcess(p_purge_batch_id,
2115: p_project_id,
2116: 'PA_ASSIGNMENT_CONFLICT_HIST',