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.

[Home] [Help]

APPS.PA_PURGE_PJR_TXNS dependencies on PA_CANDIDATE_REVIEWS

Line 139: /* Call API to archive/purge data from pa_candidates and pa_candidate_reviews */

135: x_err_stage =>x_err_stage,
136: x_err_code =>x_err_code);
137:
138:
139: /* Call API to archive/purge data from pa_candidates and pa_candidate_reviews */
140:
141: pa_debug.debug(' About to purge candidate and candidate reviews data ') ;
142: x_err_stage := 'About to purge candidate and candidate reviws for project '||to_char(p_project_id) ;
143:

Line 265: /* Call API to archive/purge data from pa_candidates and pa_candidate_reviews */

261: x_err_stage =>x_err_stage,
262: x_err_code =>x_err_code);
263:
264:
265: /* Call API to archive/purge data from pa_candidates and pa_candidate_reviews */
266:
267: pa_debug.debug(' About to purge candidate and candidate reviews data ') ;
268: x_err_stage := 'About to purge candidate and candidate reviws for project '||to_char(p_project_id) ;
269:

Line 1676: -- Function : Main purge procedure for Purging records from PA_CANDIDATES and PA_CANDIDATE_REVIEWS table

1672: -- Start of comments
1673: -- API name : PA_CANDIDATES_PURGE
1674: -- Type : Public
1675: -- Pre-reqs : None
1676: -- Function : Main purge procedure for Purging records from PA_CANDIDATES and PA_CANDIDATE_REVIEWS table
1677:
1678:
1679: Procedure PA_CANDIDATES_PURGE ( p_purge_batch_id in NUMBER,
1680: p_project_id in NUMBER,

Line 1836: pa_debug.debug('Inserting Records into pa_candidate_reviews_AR table ') ;

1832: The value will increase for each loop*/
1833:
1834: l_nos_candidate_inserted := l_nos_candidate_inserted + SQL%ROWCOUNT;
1835:
1836: pa_debug.debug('Inserting Records into pa_candidate_reviews_AR table ') ;
1837: x_err_stage := 'Inserting Records into pa_candidate_reviews_AR table for candidate id '||to_char(l_candidate_id) ;
1838:
1839: INSERT INTO PA_CANDIDATES_REV_AR
1840: (PURGE_BATCH_ID,

Line 1837: x_err_stage := 'Inserting Records into pa_candidate_reviews_AR table for candidate id '||to_char(l_candidate_id) ;

1833:
1834: l_nos_candidate_inserted := l_nos_candidate_inserted + SQL%ROWCOUNT;
1835:
1836: pa_debug.debug('Inserting Records into pa_candidate_reviews_AR table ') ;
1837: x_err_stage := 'Inserting Records into pa_candidate_reviews_AR table for candidate id '||to_char(l_candidate_id) ;
1838:
1839: INSERT INTO PA_CANDIDATES_REV_AR
1840: (PURGE_BATCH_ID,
1841: PURGE_RELEASE,

Line 1905: FROM PA_CANDIDATE_REVIEWS WHERE candidate_id = l_candidate_id;

1901: Created_By,
1902: Last_Update_Date,
1903: Last_Updated_By,
1904: Last_Update_Login
1905: FROM PA_CANDIDATE_REVIEWS WHERE candidate_id = l_candidate_id;
1906:
1907: /*Increase the value of l_nos_candidate_rev_inserted to indicate number of records inserted in candidate_reviews_ar
1908: table. The value will increase for each loop*/
1909:

Line 1914: /*To keep the count of no os records deleted from pa_candidates and pa_candidate_reviews, manipulate the

1910: l_nos_candidate_rev_inserted := l_nos_candidate_rev_inserted + SQL%ROWCOUNT;
1911:
1912: END IF;
1913:
1914: /*To keep the count of no os records deleted from pa_candidates and pa_candidate_reviews, manipulate the
1915: count of l_nos_candidate_deleted and l_nos_candidate_rev_deleted. */
1916:
1917: pa_debug.debug('Deleting Records from pa_candidate_reviews table ') ;
1918: x_err_stage := 'Deleting Records from pa_candidate_reviews table for id '||to_char(l_candidate_id) ;

Line 1917: pa_debug.debug('Deleting Records from pa_candidate_reviews table ') ;

1913:
1914: /*To keep the count of no os records deleted from pa_candidates and pa_candidate_reviews, manipulate the
1915: count of l_nos_candidate_deleted and l_nos_candidate_rev_deleted. */
1916:
1917: pa_debug.debug('Deleting Records from pa_candidate_reviews table ') ;
1918: x_err_stage := 'Deleting Records from pa_candidate_reviews table for id '||to_char(l_candidate_id) ;
1919:
1920: DELETE PA_CANDIDATE_REVIEWS
1921: WHERE candidate_id =l_candidate_id;

Line 1918: x_err_stage := 'Deleting Records from pa_candidate_reviews table for id '||to_char(l_candidate_id) ;

1914: /*To keep the count of no os records deleted from pa_candidates and pa_candidate_reviews, manipulate the
1915: count of l_nos_candidate_deleted and l_nos_candidate_rev_deleted. */
1916:
1917: pa_debug.debug('Deleting Records from pa_candidate_reviews table ') ;
1918: x_err_stage := 'Deleting Records from pa_candidate_reviews table for id '||to_char(l_candidate_id) ;
1919:
1920: DELETE PA_CANDIDATE_REVIEWS
1921: WHERE candidate_id =l_candidate_id;
1922:

Line 1920: DELETE PA_CANDIDATE_REVIEWS

1916:
1917: pa_debug.debug('Deleting Records from pa_candidate_reviews table ') ;
1918: x_err_stage := 'Deleting Records from pa_candidate_reviews table for id '||to_char(l_candidate_id) ;
1919:
1920: DELETE PA_CANDIDATE_REVIEWS
1921: WHERE candidate_id =l_candidate_id;
1922:
1923: l_nos_candidate_rev_deleted :=l_nos_candidate_rev_deleted + SQL%ROWCOUNT;
1924:

Line 1955: 'PA_CANDIDATE_REVIEWS',

1951: ) ;
1952:
1953: pa_purge.CommitProcess(p_purge_batch_id,
1954: p_project_id,
1955: 'PA_CANDIDATE_REVIEWS',
1956: l_nos_candidate_rev_inserted,
1957: l_nos_candidate_rev_deleted,
1958: x_err_code,
1959: x_err_stack,