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_PJR_TXNS dependencies on PA_SCHEDULES

Line 123: /* Call schedules API to archive/purge data from pa_schedules, pa_schedule_history and pa_schedule_except_history */

119: x_err_stack =>x_err_stack,
120: x_err_stage =>x_err_stage,
121: x_err_code =>x_err_code);
122:
123: /* Call schedules API to archive/purge data from pa_schedules, pa_schedule_history and pa_schedule_except_history */
124:
125: pa_debug.debug(' About to purge schedules, schedule history and schedule exceptions data ') ;
126: x_err_stage := 'About to purge schedules data for project '||to_char(p_project_id) ;
127:

Line 129: pa_purge_pjr_txns.pa_schedules_purge( p_purge_batch_id =>p_purge_batch_id,

125: pa_debug.debug(' About to purge schedules, schedule history and schedule exceptions data ') ;
126: x_err_stage := 'About to purge schedules data for project '||to_char(p_project_id) ;
127:
128:
129: pa_purge_pjr_txns.pa_schedules_purge( p_purge_batch_id =>p_purge_batch_id,
130: p_project_id =>p_project_id,
131: p_purge_release =>p_purge_release,
132: p_assignment_id_tab =>l_requirement_id_tab,
133: p_archive_flag =>p_archive_flag,

Line 249: /* Call schedules API to archive/purge data from pa_schedules, pa_schedule_history and pa_schedule_except_history */

245: x_err_stack =>x_err_stack,
246: x_err_stage =>x_err_stage,
247: x_err_code =>x_err_code);
248:
249: /* Call schedules API to archive/purge data from pa_schedules, pa_schedule_history and pa_schedule_except_history */
250:
251: pa_debug.debug(' About to purge schedules, schedule history and schedule exceptions data ') ;
252: x_err_stage := 'About to purge sschedules data for project '||to_char(p_project_id) ;
253:

Line 255: pa_purge_pjr_txns.pa_schedules_purge( p_purge_batch_id =>p_purge_batch_id,

251: pa_debug.debug(' About to purge schedules, schedule history and schedule exceptions data ') ;
252: x_err_stage := 'About to purge sschedules data for project '||to_char(p_project_id) ;
253:
254:
255: pa_purge_pjr_txns.pa_schedules_purge( p_purge_batch_id =>p_purge_batch_id,
256: p_project_id =>p_project_id,
257: p_purge_release =>p_purge_release,
258: p_assignment_id_tab =>l_requirement_id_tab,
259: p_archive_flag =>p_archive_flag,

Line 444: /* Call schedules API to archive/purge data from pa_schedules, pa_schedule_history and pa_schedule_except_history */

440: x_err_stack =>x_err_stack,
441: x_err_stage =>x_err_stage,
442: x_err_code =>x_err_code);
443:
444: /* Call schedules API to archive/purge data from pa_schedules, pa_schedule_history and pa_schedule_except_history */
445:
446: pa_debug.debug(' About to purge schedules, schedule history and schedule exceptions data ') ;
447: x_err_stage := 'About to purge sschedules data for project '||to_char(p_project_id) ;
448:

Line 450: pa_purge_pjr_txns.pa_schedules_purge( p_purge_batch_id =>p_purge_batch_id,

446: pa_debug.debug(' About to purge schedules, schedule history and schedule exceptions data ') ;
447: x_err_stage := 'About to purge sschedules data for project '||to_char(p_project_id) ;
448:
449:
450: pa_purge_pjr_txns.pa_schedules_purge( p_purge_batch_id =>p_purge_batch_id,
451: p_project_id =>p_project_id,
452: p_purge_release =>p_purge_release,
453: p_assignment_id_tab =>l_assignment_id_tab,
454: p_archive_flag =>p_archive_flag,

Line 573: /* Call schedules API to archive/purge data from pa_schedules, pa_schedule_history and pa_schedule_except_history */

569: x_err_stack =>x_err_stack,
570: x_err_stage =>x_err_stage,
571: x_err_code =>x_err_code);
572:
573: /* Call schedules API to archive/purge data from pa_schedules, pa_schedule_history and pa_schedule_except_history */
574:
575: pa_debug.debug(' About to purge schedules, schedule history and schedule exceptions data ') ;
576: x_err_stage := 'About to purge sschedules data for project '||to_char(p_project_id) ;
577:

Line 579: pa_purge_pjr_txns.pa_schedules_purge( p_purge_batch_id =>p_purge_batch_id,

575: pa_debug.debug(' About to purge schedules, schedule history and schedule exceptions data ') ;
576: x_err_stage := 'About to purge sschedules data for project '||to_char(p_project_id) ;
577:
578:
579: pa_purge_pjr_txns.pa_schedules_purge( p_purge_batch_id =>p_purge_batch_id,
580: p_project_id =>p_project_id,
581: p_purge_release =>p_purge_release,
582: p_assignment_id_tab =>l_assignment_id_tab,
583: p_archive_flag =>p_archive_flag,

Line 1268: -- API name : PA_SCHEDULES_PURGE

1264: end pa_forecast_items_purge;
1265:
1266:
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.

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 1274: Procedure PA_SCHEDULES_PURGE ( p_purge_batch_id in NUMBER,

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,
1276: p_purge_release in VARCHAR2,
1277: p_assignment_id_tab in PA_PLSQL_DATATYPES.IdTabTyp,
1278: p_archive_flag in VARCHAR2,

Line 1283: l_schedule_id pa_schedules.schedule_id%TYPE;

1279: x_err_stack in OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
1280: x_err_stage in OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
1281: x_err_code in OUT NOCOPY NUMBER ) IS --File.Sql.39 bug 4440895
1282:
1283: l_schedule_id pa_schedules.schedule_id%TYPE;
1284: l_schedule_exception_id pa_schedule_except_history.schedule_exception_id%TYPE;
1285: I PLS_INTEGER;
1286: l_assignment_id pa_forecast_items.assignment_id%TYPE;
1287: l_nos_schedule_inserted NUMBER ;

Line 1296: SELECT schedule_id from pa_schedules

1292: l_nos_schedule_exp_deleted NUMBER ;
1293:
1294:
1295: CURSOR Cur_schedules(x_assignment_id In NUMBER) IS
1296: SELECT schedule_id from pa_schedules
1297: WHERE assignment_id =x_assignment_id;
1298:
1299: Cursor Cur_Schedule_except (a_assignment_id In NUMBER) IS
1300: SELECT schedule_exception_id from pa_schedule_except_history

Line 1343: pa_debug.debug('Inserting Records into pa_schedules_AR table ') ;

1339: /* If archive flag is YES, archiving of data needs to be done. Insert data into correspodning AR tables */
1340:
1341: IF p_archive_flag='Y' THEN
1342:
1343: pa_debug.debug('Inserting Records into pa_schedules_AR table ') ;
1344: x_err_stage := 'Inserting Records into pa_schedules_AR table for schedule id '||to_char(l_schedule_id) ;
1345:
1346: INSERT INTO PA_SCHEDULES_AR
1347: (PURGE_BATCH_ID,

Line 1344: x_err_stage := 'Inserting Records into pa_schedules_AR table for schedule id '||to_char(l_schedule_id) ;

1340:
1341: IF p_archive_flag='Y' THEN
1342:
1343: pa_debug.debug('Inserting Records into pa_schedules_AR table ') ;
1344: x_err_stage := 'Inserting Records into pa_schedules_AR table for schedule id '||to_char(l_schedule_id) ;
1345:
1346: INSERT INTO PA_SCHEDULES_AR
1347: (PURGE_BATCH_ID,
1348: PURGE_RELEASE,

Line 1346: INSERT INTO PA_SCHEDULES_AR

1342:
1343: pa_debug.debug('Inserting Records into pa_schedules_AR table ') ;
1344: x_err_stage := 'Inserting Records into pa_schedules_AR table for schedule id '||to_char(l_schedule_id) ;
1345:
1346: INSERT INTO PA_SCHEDULES_AR
1347: (PURGE_BATCH_ID,
1348: PURGE_RELEASE,
1349: PURGE_PROJECT_ID,
1350: SCHEDULE_ID,

Line 1406: FROM pa_schedules WHERE schedule_id=l_schedule_id;

1402: Last_Update_By,
1403: Last_Update_Login,
1404: Forecast_Txn_Version_Number,
1405: Forecast_Txn_Generated_Flag
1406: FROM pa_schedules WHERE schedule_id=l_schedule_id;
1407:
1408: /*Increase the value of l_nos_schedule_inserted to indicate number of records inserted in schedule_ar table.
1409: The value will increase for each loop*/
1410:

Line 1414: x_err_stage := 'Inserting Records into pa_schedules_except_history_AR table for schedule id '||to_char(l_schedule_id) ;

1410:
1411: l_nos_schedule_inserted := l_nos_schedule_inserted + SQL%ROWCOUNT;
1412:
1413: pa_debug.debug('Inserting Records into pa_schedule_except_history_AR table ') ;
1414: x_err_stage := 'Inserting Records into pa_schedules_except_history_AR table for schedule id '||to_char(l_schedule_id) ;
1415:
1416: INSERT INTO PA_SCHEDULES_HSTRY_AR
1417: (PURGE_BATCH_ID,
1418: PURGE_RELEASE,

Line 1416: INSERT INTO PA_SCHEDULES_HSTRY_AR

1412:
1413: pa_debug.debug('Inserting Records into pa_schedule_except_history_AR table ') ;
1414: x_err_stage := 'Inserting Records into pa_schedules_except_history_AR table for schedule id '||to_char(l_schedule_id) ;
1415:
1416: INSERT INTO PA_SCHEDULES_HSTRY_AR
1417: (PURGE_BATCH_ID,
1418: PURGE_RELEASE,
1419: PURGE_PROJECT_ID,
1420: SCHEDULE_ID,

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 1496: pa_debug.debug('Deleting Records from pa_schedules table ') ;

1492: WHERE schedule_id =l_schedule_id;
1493:
1494: l_nos_schedule_his_deleted :=l_nos_schedule_his_deleted + SQL%ROWCOUNT;
1495:
1496: pa_debug.debug('Deleting Records from pa_schedules table ') ;
1497: x_err_stage := 'Deleting Records from pa_schedules table for id '||to_char(l_schedule_id) ;
1498:
1499:
1500: DELETE PA_SCHEDULES

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

1493:
1494: l_nos_schedule_his_deleted :=l_nos_schedule_his_deleted + SQL%ROWCOUNT;
1495:
1496: pa_debug.debug('Deleting Records from pa_schedules table ') ;
1497: x_err_stage := 'Deleting Records from pa_schedules table for id '||to_char(l_schedule_id) ;
1498:
1499:
1500: DELETE PA_SCHEDULES
1501: WHERE schedule_id=l_schedule_id;

Line 1500: DELETE PA_SCHEDULES

1496: pa_debug.debug('Deleting Records from pa_schedules table ') ;
1497: x_err_stage := 'Deleting Records from pa_schedules table for id '||to_char(l_schedule_id) ;
1498:
1499:
1500: DELETE PA_SCHEDULES
1501: WHERE schedule_id=l_schedule_id;
1502:
1503: l_nos_schedule_deleted :=l_nos_schedule_deleted + SQL%ROWCOUNT;
1504:

Line 1523: pa_debug.debug('inserting records into pa_schedules_except_history_ar table ') ;

1519: /* If archive flag is YES, archiving of data needs to be done. Insert data into correspodning AR tables */
1520:
1521: IF p_archive_flag='Y' THEN
1522:
1523: pa_debug.debug('inserting records into pa_schedules_except_history_ar table ') ;
1524: x_err_stage := 'Inserting Records into pa_schedules_except_history_AR table for schedule id '||to_char(l_schedule_id) ;
1525:
1526: INSERT INTO PA_SCH_EXCPT_HSTRY_AR
1527: (PURGE_BATCH_ID,

Line 1524: x_err_stage := 'Inserting Records into pa_schedules_except_history_AR table for schedule id '||to_char(l_schedule_id) ;

1520:
1521: IF p_archive_flag='Y' THEN
1522:
1523: pa_debug.debug('inserting records into pa_schedules_except_history_ar table ') ;
1524: x_err_stage := 'Inserting Records into pa_schedules_except_history_AR table for schedule id '||to_char(l_schedule_id) ;
1525:
1526: INSERT INTO PA_SCH_EXCPT_HSTRY_AR
1527: (PURGE_BATCH_ID,
1528: PURGE_RELEASE,

Line 1603: /*To keep the count of no os records deleted from pa_schedules_except_history , manipulate the

1599: l_nos_schedule_exp_inserted := l_nos_schedule_exp_inserted + SQL%ROWCOUNT;
1600:
1601: END IF;
1602:
1603: /*To keep the count of no os records deleted from pa_schedules_except_history , manipulate the
1604: count of l_nos_schedule_exp_deleted . */
1605:
1606: pa_debug.debug('Deleting Records from pa_scheduleexcept_history table ') ;
1607: x_err_stage := 'Deleting Records from pa_schedules_except_history table for id '||to_char(l_schedule_exception_id) ;

Line 1607: x_err_stage := 'Deleting Records from pa_schedules_except_history table for id '||to_char(l_schedule_exception_id) ;

1603: /*To keep the count of no os records deleted from pa_schedules_except_history , manipulate the
1604: count of l_nos_schedule_exp_deleted . */
1605:
1606: pa_debug.debug('Deleting Records from pa_scheduleexcept_history table ') ;
1607: x_err_stage := 'Deleting Records from pa_schedules_except_history table for id '||to_char(l_schedule_exception_id) ;
1608:
1609: DELETE PA_SCHEDULE_EXCEPT_HISTORY
1610: WHERE schedule_exception_id =l_schedule_exception_id;
1611:

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 1624: 'PA_SCHEDULES',

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',
1625: l_nos_schedule_inserted,
1626: l_nos_schedule_deleted,
1627: x_err_code,
1628: x_err_stack,

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 1660: pa_debug.debug('Error Procedure Name := PA_PURGE_PJR_TXNS.PA_SCHEDULES_PURGE' );

1656: WHEN PA_PROJECT_UTILS2.PA_Arch_Pur_Subroutine_Error then
1657: RAISE PA_PROJECT_UTILS2.PA_Arch_Pur_Subroutine_Error ;
1658:
1659: WHEN OTHERS THEN
1660: pa_debug.debug('Error Procedure Name := PA_PURGE_PJR_TXNS.PA_SCHEDULES_PURGE' );
1661: pa_debug.debug('Error stage is '||x_err_stage );
1662: pa_debug.debug('Error stack is '||x_err_stack );
1663: pa_debug.debug(SQLERRM);
1664: PA_PROJECT_UTILS2.g_sqlerrm := SQLERRM ;

Line 1669: end Pa_schedules_purge;

1665:
1666: RAISE PA_PROJECT_UTILS2.PA_Arch_Pur_Subroutine_Error ;
1667:
1668:
1669: end Pa_schedules_purge;
1670:
1671:
1672: -- Start of comments
1673: -- API name : PA_CANDIDATES_PURGE

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',