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_PLSQL_DATATYPES

Line 22: l_requirement_id_tab PA_PLSQL_DATATYPES.IdTabTyp;

18:
19:
20:
21:
22: l_requirement_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
23: I PLS_INTEGER;
24: l_last_fetch VARCHAR2(1):='N';
25: l_this_fetch NUMBER:=0;
26: l_totally_fetched NUMBER:=0;

Line 355: l_assignment_id_tab PA_PLSQL_DATATYPES.IdTabTyp;

351: x_err_stack in OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
352: x_err_stage in OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
353: x_err_code in OUT NOCOPY NUMBER ) AS --File.Sql.39 bug 4440895
354:
355: l_assignment_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
356: I PLS_INTEGER;
357: l_last_fetch VARCHAR2(1):='N';
358: l_this_fetch NUMBER:=0;
359: l_totally_fetched NUMBER:=0;

Line 674: p_assignment_id_tab in PA_PLSQL_DATATYPES.IdTabTyp,

670:
671: Procedure PA_FORECAST_ITEMS_PURGE ( p_purge_batch_id in NUMBER,
672: p_project_id in NUMBER,
673: p_purge_release in VARCHAR2,
674: p_assignment_id_tab in PA_PLSQL_DATATYPES.IdTabTyp,
675: p_archive_flag in VARCHAR2,
676: x_err_stack in OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
677: x_err_stage in OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
678: x_err_code in OUT NOCOPY NUMBER ) IS --File.Sql.39 bug 4440895

Line 1277: p_assignment_id_tab in PA_PLSQL_DATATYPES.IdTabTyp,

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

Line 1682: p_assignment_id_tab in PA_PLSQL_DATATYPES.IdTabTyp,

1678:
1679: Procedure PA_CANDIDATES_PURGE ( p_purge_batch_id in NUMBER,
1680: p_project_id in NUMBER,
1681: p_purge_release in VARCHAR2,
1682: p_assignment_id_tab in PA_PLSQL_DATATYPES.IdTabTyp,
1683: p_archive_flag in VARCHAR2,
1684: x_err_stack in OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
1685: x_err_stage in OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
1686: x_err_code in OUT NOCOPY NUMBER) IS --File.Sql.39 bug 4440895

Line 1991: p_assignment_id_tab in PA_PLSQL_DATATYPES.IdTabTyp,

1987:
1988: Procedure PA_ASSIGNMENT_CONFLICTS_PURGE ( p_purge_batch_id in NUMBER,
1989: p_project_id in NUMBER,
1990: p_purge_release in VARCHAR2,
1991: p_assignment_id_tab in PA_PLSQL_DATATYPES.IdTabTyp,
1992: p_archive_flag in VARCHAR2,
1993: x_err_stack in OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
1994: x_err_stage in OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
1995: x_err_code in OUT NOCOPY NUMBER ) IS --File.Sql.39 bug 4440895

Line 2012: l_project_id_tab Pa_Plsql_Datatypes.IdTabTyp;

2008: pa_assignment_conflict_hist hist
2009: WHERE asgn.assignment_id = hist.conflict_assignment_id
2010: AND hist.assignment_id = x_assignment_id;
2011:
2012: l_project_id_tab Pa_Plsql_Datatypes.IdTabTyp;
2013: l_count NUMBER;
2014: l_overcommitment_flag VARCHAR2(1) := 'N';
2015:
2016: ----------------------------------------------------------------------------------

Line 2192: p_assignment_id_tab in PA_PLSQL_DATATYPES.IdTabTyp,

2188:
2189: Procedure PA_PROJECT_ASSIGNMENT_PURGE ( p_purge_batch_id in NUMBER,
2190: p_project_id in NUMBER,
2191: p_purge_release in VARCHAR2,
2192: p_assignment_id_tab in PA_PLSQL_DATATYPES.IdTabTyp,
2193: p_archive_flag in VARCHAR2,
2194: x_err_stack in OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
2195: x_err_stage in OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
2196: x_err_code in OUT NOCOPY NUMBER ) IS --File.Sql.39 bug 4440895

Line 2763: p_assignment_id_tab in PA_PLSQL_DATATYPES.IdTabTyp,

2759:
2760: Procedure PA_PROJECT_PARTIES_PURGE ( p_purge_batch_id in NUMBER,
2761: p_project_id in NUMBER,
2762: p_purge_release in VARCHAR2,
2763: p_assignment_id_tab in PA_PLSQL_DATATYPES.IdTabTyp,
2764: p_archive_flag in VARCHAR2,
2765: x_err_stack in OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
2766: x_err_stage in OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
2767: x_err_code in OUT NOCOPY NUMBER ) IS --File.Sql.39 bug 4440895

Line 2904: p_assignment_id_tab in PA_PLSQL_DATATYPES.IdTabTyp,

2900:
2901: Procedure PA_ADVERTISEMENTS_PURGE ( p_purge_batch_id in NUMBER,
2902: p_project_id in NUMBER,
2903: p_purge_release in VARCHAR2,
2904: p_assignment_id_tab in PA_PLSQL_DATATYPES.IdTabTyp,
2905: p_archive_flag in VARCHAR2,
2906: x_err_stack in OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
2907: x_err_stage in OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
2908: x_err_code in OUT NOCOPY NUMBER ) IS --File.Sql.39 bug 4440895

Line 3395: p_entity_key_tab IN Pa_Plsql_Datatypes.IdTabTyp,

3391:
3392: PROCEDURE PA_WF_PURGE ( p_purge_batch_id IN NUMBER,
3393: p_project_id IN NUMBER,
3394: p_purge_release IN VARCHAR2,
3395: p_entity_key_tab IN Pa_Plsql_Datatypes.IdTabTyp,
3396: p_wf_type_code IN VARCHAR2,
3397: p_item_type IN VARCHAR2,
3398: p_archive_flag IN VARCHAR2,
3399: x_err_stack IN OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895

Line 3747: p_object_id_tab IN Pa_Plsql_Datatypes.IdTabTyp,

3743:
3744: PROCEDURE PA_WF_MASS_PURGE ( p_purge_batch_id IN NUMBER,
3745: p_project_id IN NUMBER,
3746: p_purge_release IN VARCHAR2,
3747: p_object_id_tab IN Pa_Plsql_Datatypes.IdTabTyp,
3748: p_item_type IN VARCHAR2,
3749: p_archive_flag IN VARCHAR2,
3750: x_err_stack IN OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
3751: x_err_stage IN OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895

Line 4007: p_object_id_tab IN Pa_Plsql_Datatypes.IdTabTyp,

4003:
4004: PROCEDURE PA_WF_MASS_ASGN_PURGE ( p_purge_batch_id IN NUMBER,
4005: p_project_id IN NUMBER,
4006: p_purge_release IN VARCHAR2,
4007: p_object_id_tab IN Pa_Plsql_Datatypes.IdTabTyp,
4008: p_wf_type_code IN VARCHAR2,
4009: p_archive_flag IN VARCHAR2,
4010: x_err_stack IN OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
4011: x_err_stage IN OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895