APPS.PA_PURGE_COSTING dependencies on PA_EXPENDITURE_HISTORY

Line 2020: -- Function : This procedure purges all the records from pa_expenditure_history

2016: -- Start of comments
2017: -- API name : PA_ExpenditureHistory
2018: -- Type : Public
2019: -- Pre-reqs : None
2020: -- Function : This procedure purges all the records from pa_expenditure_history
2021: --
2022: -- Parameters : Refer to the comments of the previous procedure
2023: --
2024: -- End of comments

Line 2134: from pa_expenditure_history xh

2130: xh.Last_Update_Login,
2131: p_purge_batch_id,
2132: p_purge_release,
2133: p_project_id
2134: from pa_expenditure_history xh
2135: where xh.project_id = p_project_id
2136: and xh.expenditure_item_date <= p_txn_to_date
2137: and rownum < l_commit_size ;
2138: else

Line 2216: from pa_expenditure_history xh

2212: xh.Last_Update_Login,
2213: p_purge_batch_id,
2214: p_purge_release,
2215: p_project_id
2216: from pa_expenditure_history xh
2217: where xh.project_id = p_project_id
2218: and rownum < l_commit_size ;
2219: end if;
2220:

Line 2228: delete from pa_expenditure_history xh

2224: -- We have a seperate delete statement if the archive option is
2225: -- selected because if archive option is selected the the records
2226: -- being purged will be those records which are already archived.
2227: -- table and
2228: delete from pa_expenditure_history xh
2229: where (xh.expenditure_id, xh.denorm_id ) in
2230: ( select xhar.expenditure_id, xhar.denorm_id
2231: from PA_EXP_HISTORY_AR xhar
2232: where xhar.purge_project_id = p_project_id

Line 2244: delete from pa_expenditure_history xh

2240:
2241: -- If the archive option is not selected then the delete will
2242: -- be based on the commit size.
2243: if p_txn_to_date is NOT NULL then
2244: delete from pa_expenditure_history xh
2245: where xh.project_id = p_project_id
2246: and xh.expenditure_item_date <= p_txn_to_date
2247: and rownum < l_commit_size ;
2248: else

Line 2249: delete from pa_expenditure_history xh

2245: where xh.project_id = p_project_id
2246: and xh.expenditure_item_date <= p_txn_to_date
2247: and rownum < l_commit_size ;
2248: else
2249: delete from pa_expenditure_history xh
2250: where xh.project_id = p_project_id
2251: and rownum < l_commit_size ;
2252: end if;
2253:

Line 2271: 'PA_EXPENDITURE_HISTORY',

2267: -- that are purged from each table.
2268:
2269: pa_purge.CommitProcess(p_purge_batch_id,
2270: p_project_id,
2271: 'PA_EXPENDITURE_HISTORY',
2272: l_NoOfRecordsIns,
2273: l_NoOfRecordsDel,
2274: x_err_code,
2275: x_err_stack,