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.GHR_CORR_CANC_SF52 dependencies on PER_PERSON_ANALYSES

Line 964: cursor chk_perana_exists(p_person_analysis_id in per_person_analyses.person_analysis_id%type)

960: for update of person_id;
961:
962:
963: --Bug # 12652865 cursor for checking whether person analysis record exists
964: cursor chk_perana_exists(p_person_analysis_id in per_person_analyses.person_analysis_id%type)
965: is
966: SELECT 1
967: FROM PER_PERSON_ANALYSES
968: WHERE person_analysis_id = p_person_analysis_id;

Line 967: FROM PER_PERSON_ANALYSES

963: --Bug # 12652865 cursor for checking whether person analysis record exists
964: cursor chk_perana_exists(p_person_analysis_id in per_person_analyses.person_analysis_id%type)
965: is
966: SELECT 1
967: FROM PER_PERSON_ANALYSES
968: WHERE person_analysis_id = p_person_analysis_id;
969: l_rec_exists boolean;
970: m_perana varchar2(1);
971:

Line 1220: --- available in the base table PER_PERSON_ANALYSES

1216: hr_utility.set_location(l_proc || 'l_hist.table_name: ' || l_hist.table_name, 1210);
1217: hr_utility.set_location(l_proc || 'l_hist.person_id: ' || l_hist.person_id, 1220);
1218:
1219: --Bug # 12652865 as no need to cascade if already person analyses record is not
1220: --- available in the base table PER_PERSON_ANALYSES
1221:
1222: l_rec_exists := TRUE;
1223: IF l_hist.table_name = 'PER_PERSON_ANALYSES' THEN
1224: OPEN chk_perana_exists(p_person_analysis_id => l_hist.information1);

Line 1223: IF l_hist.table_name = 'PER_PERSON_ANALYSES' THEN

1219: --Bug # 12652865 as no need to cascade if already person analyses record is not
1220: --- available in the base table PER_PERSON_ANALYSES
1221:
1222: l_rec_exists := TRUE;
1223: IF l_hist.table_name = 'PER_PERSON_ANALYSES' THEN
1224: OPEN chk_perana_exists(p_person_analysis_id => l_hist.information1);
1225: FETCH chk_perana_exists into m_perana;
1226: IF chk_perana_exists%NOTFOUND THEN
1227: l_rec_exists := FALSE;

Line 1748: -- Added this below cursor for the bug#5900178 to validate whether per_person_analyses

1744: 'PAY_ELEMENT_ENTRIES_F', -1,
1745: pa_history_id) asc;
1746:
1747: --start of bug #5900178
1748: -- Added this below cursor for the bug#5900178 to validate whether per_person_analyses
1749: --record is available for updation or not if it is available it will be continue otherwise
1750: --- it wont continue for cascading
1751: cursor chk_perana_exists(p_person_analysis_id in per_person_analyses.person_analysis_id%type)
1752: is

Line 1751: cursor chk_perana_exists(p_person_analysis_id in per_person_analyses.person_analysis_id%type)

1747: --start of bug #5900178
1748: -- Added this below cursor for the bug#5900178 to validate whether per_person_analyses
1749: --record is available for updation or not if it is available it will be continue otherwise
1750: --- it wont continue for cascading
1751: cursor chk_perana_exists(p_person_analysis_id in per_person_analyses.person_analysis_id%type)
1752: is
1753: SELECT 1
1754: FROM PER_PERSON_ANALYSES
1755: WHERE person_analysis_id = p_person_analysis_id;

Line 1754: FROM PER_PERSON_ANALYSES

1750: --- it wont continue for cascading
1751: cursor chk_perana_exists(p_person_analysis_id in per_person_analyses.person_analysis_id%type)
1752: is
1753: SELECT 1
1754: FROM PER_PERSON_ANALYSES
1755: WHERE person_analysis_id = p_person_analysis_id;
1756:
1757: m_perana varchar2(1);
1758: l_rec_exists boolean;

Line 2463: IF l_hist_rec.table_name = 'PER_PERSON_ANALYSES' THEN

2459: NULL;
2460: ELSE
2461: --5900178
2462: l_rec_exists := TRUE;
2463: IF l_hist_rec.table_name = 'PER_PERSON_ANALYSES' THEN
2464: hr_utility.set_location('In per_person_analyses record checking',997);
2465: OPEN chk_perana_exists(p_person_analysis_id => l_hist_rec.information1);
2466: FETCH chk_perana_exists into m_perana;
2467: IF chk_perana_exists%NOTFOUND THEN

Line 2464: hr_utility.set_location('In per_person_analyses record checking',997);

2460: ELSE
2461: --5900178
2462: l_rec_exists := TRUE;
2463: IF l_hist_rec.table_name = 'PER_PERSON_ANALYSES' THEN
2464: hr_utility.set_location('In per_person_analyses record checking',997);
2465: OPEN chk_perana_exists(p_person_analysis_id => l_hist_rec.information1);
2466: FETCH chk_perana_exists into m_perana;
2467: IF chk_perana_exists%NOTFOUND THEN
2468: hr_utility.set_location('In per_person_analyses record checking--notfound',996);

Line 2468: hr_utility.set_location('In per_person_analyses record checking--notfound',996);

2464: hr_utility.set_location('In per_person_analyses record checking',997);
2465: OPEN chk_perana_exists(p_person_analysis_id => l_hist_rec.information1);
2466: FETCH chk_perana_exists into m_perana;
2467: IF chk_perana_exists%NOTFOUND THEN
2468: hr_utility.set_location('In per_person_analyses record checking--notfound',996);
2469: l_rec_exists := FALSE;
2470: END IF;
2471: CLOSE chk_perana_exists;
2472: END IF;

Line 4992: -- This procedure deletes a row from per_person_analyses table.

4988: -- ---------------------------------------------------------------------------
4989: -- {Start Of Comments}
4990: --
4991: -- Description:
4992: -- This procedure deletes a row from per_person_analyses table.
4993: --
4994: -- Pre-Requisities:
4995: -- None.
4996: --

Line 5001: -- per_person_analyses row will have been deleted.

4997: -- In Parameters:
4998: -- p_person_analysis_id -> person_analysis_id to be deleted.
4999: --
5000: -- Post Success:
5001: -- per_person_analyses row will have been deleted.
5002: --
5003: -- Post Failure:
5004: -- message will have been displayed to user explaining why the delete could not be completed.
5005: --

Line 5021: FROM PER_PERSON_ANALYSES

5017: l_proc varchar2(72) := 'delete_person_analyses_row';
5018: l_ovn number;
5019: cursor c_get_ovn (cp_person_analysis_id in number) is
5020: SELECT object_version_number
5021: FROM PER_PERSON_ANALYSES
5022: WHERE person_analysis_id = cp_person_analysis_id ;
5023:
5024: Begin
5025: hr_utility.set_location( 'Entering : ' || l_proc, 10);