APPS.PA_PURGE_COSTING dependencies on PA_EI_DENORM

Line 1460: -- Function : This procedure purges all the records from pa_ei_denorm

1456: -- Start of comments
1457: -- API name : PA_EiDenorm
1458: -- Type : Public
1459: -- Pre-reqs : None
1460: -- Function : This procedure purges all the records from pa_ei_denorm
1461: --
1462: -- Parameters : Refer to the comments of the previous procedure
1463: --
1464: -- End of comments

Line 1492: -- Pa_Ei_Denorm. This is a new table created for Online Time and

1488:
1489: --
1490: -- This procedure is called by the main costing purge procedure
1491: -- pa_purge_costing.pa_costing_main_purge. It purges the data from
1492: -- Pa_Ei_Denorm. This is a new table created for Online Time and
1493: -- Expense(OTE) entry. Once OTE patch is installed user should
1494: -- uncomment these code to allow the purging of data from Pa_Ei_Denorm
1495: -- which is also a transaction table.
1496:

Line 1494: -- uncomment these code to allow the purging of data from Pa_Ei_Denorm

1490: -- This procedure is called by the main costing purge procedure
1491: -- pa_purge_costing.pa_costing_main_purge. It purges the data from
1492: -- Pa_Ei_Denorm. This is a new table created for Online Time and
1493: -- Expense(OTE) entry. Once OTE patch is installed user should
1494: -- uncomment these code to allow the purging of data from Pa_Ei_Denorm
1495: -- which is also a transaction table.
1496:
1497: l_old_err_stack := x_err_stack;
1498:

Line 1499: x_err_stack := x_err_stack || ' ->Before insert into Pa_Ei_Denorm_AR' ;

1495: -- which is also a transaction table.
1496:
1497: l_old_err_stack := x_err_stack;
1498:
1499: x_err_stack := x_err_stack || ' ->Before insert into Pa_Ei_Denorm_AR' ;
1500:
1501: LOOP
1502: if p_archive_flag = 'Y' then
1503: -- If archive option is selected then the records are

Line 1511: insert into Pa_Ei_Denorm_AR

1507: -- in the commit size.
1508:
1509: l_commit_size := p_commit_size / 2 ;
1510:
1511: insert into Pa_Ei_Denorm_AR
1512: (
1513: Expenditure_Id,
1514: Denorm_Id,
1515: Person_Id,

Line 1918: from pa_ei_denorm eid

1914: eid.BILLABLE_FLAG_7,
1915: p_purge_batch_id,
1916: p_purge_release,
1917: p_project_id
1918: from pa_ei_denorm eid
1919: where eid.project_id = p_project_id
1920: and (p_txn_to_date is null
1921: or ( trunc(eid.expenditure_item_date_1) <= trunc(p_txn_to_date )
1922: and trunc(eid.expenditure_item_date_2) <= trunc(p_txn_to_date )

Line 1939: delete from pa_ei_denorm eid

1935: -- selected because if archive option is selected the the records
1936: -- being purged will be those records which are already archived.
1937: -- table and
1938:
1939: delete from pa_ei_denorm eid
1940: where (eid.denorm_id, eid.expenditure_id) in
1941: ( select eid2.denorm_id, eid.expenditure_id
1942: from pa_ei_denorm_ar eid2
1943: where eid2.purge_project_id = p_project_id ) ;

Line 1942: from pa_ei_denorm_ar eid2

1938:
1939: delete from pa_ei_denorm eid
1940: where (eid.denorm_id, eid.expenditure_id) in
1941: ( select eid2.denorm_id, eid.expenditure_id
1942: from pa_ei_denorm_ar eid2
1943: where eid2.purge_project_id = p_project_id ) ;
1944:
1945: l_NoOfRecordsDel := SQL%ROWCOUNT ;
1946: end if;

Line 1954: delete from pa_ei_denorm eid

1950:
1951: -- If the archive option is not selected then the delete will
1952: -- be based on the commit size.
1953:
1954: delete from pa_ei_denorm eid
1955: where eid.project_id = p_project_id
1956: and (p_txn_to_date is null
1957: or ( trunc(eid.expenditure_item_date_1) <= trunc(p_txn_to_date )
1958: and trunc(eid.expenditure_item_date_2) <= trunc(p_txn_to_date )

Line 1985: 'PA_EI_DENORM',

1981: -- that are purged from each table.
1982:
1983: pa_purge.CommitProcess(p_purge_batch_id,
1984: p_project_id,
1985: 'PA_EI_DENORM',
1986: l_NoOfRecordsIns,
1987: l_NoOfRecordsDel,
1988: x_err_code,
1989: x_err_stack,