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.

APPS.PA_PURGE_PJR_TXNS dependencies on PA_CANDIDATES

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 144: pa_purge_pjr_txns.pa_candidates_purge( p_purge_batch_id =>p_purge_batch_id,

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:
144: pa_purge_pjr_txns.pa_candidates_purge( p_purge_batch_id =>p_purge_batch_id,
145: p_project_id =>p_project_id,
146: p_purge_release =>p_purge_release,
147: p_assignment_id_tab =>l_requirement_id_tab,
148: p_archive_flag =>p_archive_flag,

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 270: pa_purge_pjr_txns.pa_candidates_purge( p_purge_batch_id =>p_purge_batch_id,

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:
270: pa_purge_pjr_txns.pa_candidates_purge( p_purge_batch_id =>p_purge_batch_id,
271: p_project_id =>p_project_id,
272: p_purge_release =>p_purge_release,
273: p_assignment_id_tab =>l_requirement_id_tab,
274: p_archive_flag =>p_archive_flag,

Line 1673: -- API name : PA_CANDIDATES_PURGE

1669: end Pa_schedules_purge;
1670:
1671:
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:

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 1679: Procedure PA_CANDIDATES_PURGE ( p_purge_batch_id in NUMBER,

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,
1681: p_purge_release in VARCHAR2,
1682: p_assignment_id_tab in PA_PLSQL_DATATYPES.IdTabTyp,
1683: p_archive_flag in VARCHAR2,

Line 1689: l_candidate_id pa_candidates.candidate_id%TYPE;

1685: x_err_stage in OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
1686: x_err_code in OUT NOCOPY NUMBER) IS --File.Sql.39 bug 4440895
1687:
1688:
1689: l_candidate_id pa_candidates.candidate_id%TYPE;
1690: I PLS_INTEGER;
1691: l_assignment_id pa_forecast_items.assignment_id%TYPE;
1692: l_nos_candidate_inserted NUMBER ;
1693: l_nos_candidate_rev_inserted NUMBER ;

Line 1698: SELECT candidate_id from pa_candidates

1694: l_nos_candidate_deleted NUMBER ;
1695: l_nos_candidate_rev_deleted NUMBER ;
1696:
1697: CURSOR Cur_candidates (x_assignment_id In NUMBER) IS
1698: SELECT candidate_id from pa_candidates
1699: WHERE assignment_id =x_assignment_id;
1700:
1701: l_old_err_stack VARCHAR2(2000); -- Added for bug 4227589
1702:

Line 1758: pa_debug.debug('Inserting Records into pa_candidates_AR table ') ;

1754: /* If archive flag is YES, archiving of data needs to be done. Insert data into correspodning AR tables */
1755:
1756: IF p_archive_flag='Y' THEN
1757:
1758: pa_debug.debug('Inserting Records into pa_candidates_AR table ') ;
1759: x_err_stage := 'Inserting Records into pa_candidates_AR table for candidate id '||to_char(l_candidate_id) ;
1760:
1761: INSERT INTO PA_CANDIDATES_AR
1762: ( PURGE_BATCH_ID,

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

1755:
1756: IF p_archive_flag='Y' THEN
1757:
1758: pa_debug.debug('Inserting Records into pa_candidates_AR table ') ;
1759: x_err_stage := 'Inserting Records into pa_candidates_AR table for candidate id '||to_char(l_candidate_id) ;
1760:
1761: INSERT INTO PA_CANDIDATES_AR
1762: ( PURGE_BATCH_ID,
1763: PURGE_RELEASE,

Line 1761: INSERT INTO PA_CANDIDATES_AR

1757:
1758: pa_debug.debug('Inserting Records into pa_candidates_AR table ') ;
1759: x_err_stage := 'Inserting Records into pa_candidates_AR table for candidate id '||to_char(l_candidate_id) ;
1760:
1761: INSERT INTO PA_CANDIDATES_AR
1762: ( PURGE_BATCH_ID,
1763: PURGE_RELEASE,
1764: PURGE_PROJECT_ID,
1765: CANDIDATE_ID,

Line 1829: FROM PA_CANDIDATES WHERE candidate_id=l_candidate_id;

1825: Created_By,
1826: Last_Update_Date,
1827: Last_Updated_By,
1828: Last_Update_Login
1829: FROM PA_CANDIDATES WHERE candidate_id=l_candidate_id;
1830:
1831: /*Increase the value of l_nos_candidate_inserted to indicate number of records inserted in candidates_ar table.
1832: The value will increase for each loop*/
1833:

Line 1839: INSERT INTO PA_CANDIDATES_REV_AR

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,
1842: PURGE_PROJECT_ID,
1843: CANDIDATE_REVIEW_ID,

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 1925: pa_debug.debug('Deleting Records from pa_candidates table ') ;

1921: WHERE candidate_id =l_candidate_id;
1922:
1923: l_nos_candidate_rev_deleted :=l_nos_candidate_rev_deleted + SQL%ROWCOUNT;
1924:
1925: pa_debug.debug('Deleting Records from pa_candidates table ') ;
1926: x_err_stage := 'Deleting Records from pa_candidates table for id '||to_char(l_candidate_id) ;
1927:
1928: DELETE PA_CANDIDATES
1929: WHERE candidate_id =l_candidate_id;

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

1922:
1923: l_nos_candidate_rev_deleted :=l_nos_candidate_rev_deleted + SQL%ROWCOUNT;
1924:
1925: pa_debug.debug('Deleting Records from pa_candidates table ') ;
1926: x_err_stage := 'Deleting Records from pa_candidates table for id '||to_char(l_candidate_id) ;
1927:
1928: DELETE PA_CANDIDATES
1929: WHERE candidate_id =l_candidate_id;
1930:

Line 1928: DELETE PA_CANDIDATES

1924:
1925: pa_debug.debug('Deleting Records from pa_candidates table ') ;
1926: x_err_stage := 'Deleting Records from pa_candidates table for id '||to_char(l_candidate_id) ;
1927:
1928: DELETE PA_CANDIDATES
1929: WHERE candidate_id =l_candidate_id;
1930:
1931: l_nos_candidate_deleted :=l_nos_candidate_deleted + SQL%ROWCOUNT;
1932:

Line 1945: 'PA_CANDIDATES',

1941: The procedure is called pa_schedules, pa_schedule_except_history and pa_schedules_history tables */
1942:
1943: pa_purge.CommitProcess(p_purge_batch_id,
1944: p_project_id,
1945: 'PA_CANDIDATES',
1946: l_nos_candidate_inserted,
1947: l_nos_candidate_deleted,
1948: x_err_code,
1949: x_err_stack,

Line 1970: pa_debug.debug('Error Procedure Name := PA_PURGE_PJR_TXNS.PA_CANDIDATES_PURGE');

1966: WHEN PA_PROJECT_UTILS2.PA_Arch_Pur_Subroutine_Error then
1967: RAISE PA_PROJECT_UTILS2.PA_Arch_Pur_Subroutine_Error ;
1968:
1969: WHEN OTHERS THEN
1970: pa_debug.debug('Error Procedure Name := PA_PURGE_PJR_TXNS.PA_CANDIDATES_PURGE');
1971: pa_debug.debug('Error stage is '||x_err_stage );
1972: pa_debug.debug('Error stack is '||x_err_stack );
1973: pa_debug.debug(SQLERRM);
1974: PA_PROJECT_UTILS2.g_sqlerrm := SQLERRM ;

Line 1978: End pa_candidates_purge;

1974: PA_PROJECT_UTILS2.g_sqlerrm := SQLERRM ;
1975:
1976: RAISE PA_PROJECT_UTILS2.PA_Arch_Pur_Subroutine_Error ;
1977:
1978: End pa_candidates_purge;
1979:
1980:
1981: -- Start of comments
1982: -- API name : PA_ASSIGNMENT_CONFLICTS_PURGE