APPS.PA_PURGE_UNASGN_FI dependencies on PA_PLSQL_DATATYPES

Line 25: l_forecast_item_id_tab PA_PLSQL_DATATYPES.IdTabTyp;

21: p_txn_to_date in VARCHAR2,
22: p_archive_flag in varchar2) IS
23:
24:
25: l_forecast_item_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
26: l_project_id_tab PA_PLSQL_DATATYPES.IdTabTyp; --Added for bug 5870223
27: I PLS_INTEGER;
28: l_last_fetch VARCHAR2(1):='N';
29: l_this_fetch NUMBER:=0;

Line 26: l_project_id_tab PA_PLSQL_DATATYPES.IdTabTyp; --Added for bug 5870223

22: p_archive_flag in varchar2) IS
23:
24:
25: l_forecast_item_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
26: l_project_id_tab PA_PLSQL_DATATYPES.IdTabTyp; --Added for bug 5870223
27: I PLS_INTEGER;
28: l_last_fetch VARCHAR2(1):='N';
29: l_this_fetch NUMBER:=0;
30: l_totally_fetched NUMBER:=0;

Line 160: Procedure Delete_FI (p_forecast_item_id_tab in PA_PLSQL_DATATYPES.IdTabTyp,

156: -- records need to be archived
157: -- p_forecast_item_id_id_tab -> forecast items tab
158: -- End of comments
159:
160: Procedure Delete_FI (p_forecast_item_id_tab in PA_PLSQL_DATATYPES.IdTabTyp,
161: p_project_id_tab in PA_PLSQL_DATATYPES.IdTabTyp, --Added for bug 5870223
162: p_archive_flag in VARCHAR2,
163: p_purge_batch_id in NUMBER,
164: x_err_stack in OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895

Line 161: p_project_id_tab in PA_PLSQL_DATATYPES.IdTabTyp, --Added for bug 5870223

157: -- p_forecast_item_id_id_tab -> forecast items tab
158: -- End of comments
159:
160: Procedure Delete_FI (p_forecast_item_id_tab in PA_PLSQL_DATATYPES.IdTabTyp,
161: p_project_id_tab in PA_PLSQL_DATATYPES.IdTabTyp, --Added for bug 5870223
162: p_archive_flag in VARCHAR2,
163: p_purge_batch_id in NUMBER,
164: x_err_stack in OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
165: x_err_stage in OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895

Line 185: l_forecast_item_id_tab PA_PLSQL_DATATYPES.IdTabTyp;

181: l_first_index NUMBER;
182: l_last_index NUMBER;
183: l_call_commit VARCHAR2(1) := 'N';
184:
185: l_forecast_item_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
186: J PLS_INTEGER := 0;
187:
188: --End for bug 5870223
189: