DBA Data[Home] [Help]

APPS.PA_PURGE_PJR_TXNS dependencies on PA_PLSQL_DATATYPES

Line 97: p_assignment_id_tab in PA_PLSQL_DATATYPES.IdTabTyp,

93:
94: Procedure PA_FORECAST_ITEMS_PURGE ( p_purge_batch_id in NUMBER,
95: p_project_id in NUMBER,
96: p_purge_release in VARCHAR2,
97: p_assignment_id_tab in PA_PLSQL_DATATYPES.IdTabTyp,
98: p_archive_flag in VARCHAR2,
99: x_err_stack in OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
100: x_err_stage in OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
101: x_err_code in OUT NOCOPY NUMBER ); --File.Sql.39 bug 4440895

Line 126: p_assignment_id_tab in PA_PLSQL_DATATYPES.IdTabTyp,

122:
123: Procedure PA_SCHEDULES_PURGE ( p_purge_batch_id in NUMBER,
124: p_project_id in NUMBER,
125: p_purge_release in VARCHAR2,
126: p_assignment_id_tab in PA_PLSQL_DATATYPES.IdTabTyp,
127: p_archive_flag in VARCHAR2,
128: x_err_stack in OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
129: x_err_stage in OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
130: x_err_code in OUT NOCOPY NUMBER ); --File.Sql.39 bug 4440895

Line 143: p_assignment_id_tab in PA_PLSQL_DATATYPES.IdTabTyp,

139:
140: Procedure PA_CANDIDATES_PURGE ( p_purge_batch_id in NUMBER,
141: p_project_id in NUMBER,
142: p_purge_release in VARCHAR2,
143: p_assignment_id_tab in PA_PLSQL_DATATYPES.IdTabTyp,
144: p_archive_flag in VARCHAR2,
145: x_err_stack in OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
146: x_err_stage in OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
147: x_err_code in OUT NOCOPY NUMBER ); --File.Sql.39 bug 4440895

Line 159: p_assignment_id_tab in PA_PLSQL_DATATYPES.IdTabTyp,

155:
156: Procedure PA_ASSIGNMENT_CONFLICTS_PURGE ( p_purge_batch_id in NUMBER,
157: p_project_id in NUMBER,
158: p_purge_release in VARCHAR2,
159: p_assignment_id_tab in PA_PLSQL_DATATYPES.IdTabTyp,
160: p_archive_flag in VARCHAR2,
161: x_err_stack in OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
162: x_err_stage in OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
163: x_err_code in OUT NOCOPY NUMBER ); --File.Sql.39 bug 4440895

Line 177: p_assignment_id_tab in PA_PLSQL_DATATYPES.IdTabTyp,

173:
174: Procedure PA_PROJECT_ASSIGNMENT_PURGE ( p_purge_batch_id in NUMBER,
175: p_project_id in NUMBER,
176: p_purge_release in VARCHAR2,
177: p_assignment_id_tab in PA_PLSQL_DATATYPES.IdTabTyp,
178: p_archive_flag in VARCHAR2,
179: x_err_stack in OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
180: x_err_stage in OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
181: x_err_code in OUT NOCOPY NUMBER ); --File.Sql.39 bug 4440895

Line 194: p_assignment_id_tab in PA_PLSQL_DATATYPES.IdTabTyp,

190:
191: Procedure PA_PROJECT_PARTIES_PURGE ( p_purge_batch_id in NUMBER,
192: p_project_id in NUMBER,
193: p_purge_release in VARCHAR2,
194: p_assignment_id_tab in PA_PLSQL_DATATYPES.IdTabTyp,
195: p_archive_flag in VARCHAR2,
196: x_err_stack in OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
197: x_err_stage in OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
198: x_err_code in OUT NOCOPY NUMBER ); --File.Sql.39 bug 4440895

Line 214: p_assignment_id_tab in PA_PLSQL_DATATYPES.IdTabTyp,

210:
211: Procedure PA_ADVERTISEMENTS_PURGE ( p_purge_batch_id in NUMBER,
212: p_project_id in NUMBER,
213: p_purge_release in VARCHAR2,
214: p_assignment_id_tab in PA_PLSQL_DATATYPES.IdTabTyp,
215: p_archive_flag in VARCHAR2,
216: x_err_stack in OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
217: x_err_stage in OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
218: x_err_code in OUT NOCOPY NUMBER ); --File.Sql.39 bug 4440895

Line 234: p_entity_key_tab IN PA_PLSQL_DATATYPES.IdTabTyp,

230:
231: PROCEDURE PA_WF_PURGE ( p_purge_batch_id IN NUMBER,
232: p_project_id IN NUMBER,
233: p_purge_release IN VARCHAR2,
234: p_entity_key_tab IN PA_PLSQL_DATATYPES.IdTabTyp,
235: p_wf_type_code in VARCHAR2,
236: p_item_type IN VARCHAR2,
237: p_archive_flag IN VARCHAR2,
238: x_err_stack IN OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895

Line 251: p_object_id_tab IN Pa_Plsql_Datatypes.IdTabTyp,

247:
248: PROCEDURE PA_WF_MASS_PURGE ( p_purge_batch_id IN NUMBER,
249: p_project_id IN NUMBER,
250: p_purge_release IN VARCHAR2,
251: p_object_id_tab IN Pa_Plsql_Datatypes.IdTabTyp,
252: p_item_type IN VARCHAR2,
253: p_archive_flag IN VARCHAR2,
254: x_err_stack IN OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
255: x_err_stage IN OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895

Line 267: p_object_id_tab IN Pa_Plsql_Datatypes.IdTabTyp,

263:
264: PROCEDURE PA_WF_MASS_ASGN_PURGE ( p_purge_batch_id IN NUMBER,
265: p_project_id IN NUMBER,
266: p_purge_release IN VARCHAR2,
267: p_object_id_tab IN Pa_Plsql_Datatypes.IdTabTyp,
268: p_wf_type_code IN VARCHAR2,
269: p_archive_flag IN VARCHAR2,
270: x_err_stack IN OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
271: x_err_stage IN OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895