APPS.GHR_CORR_CANC_SF52 dependencies on PER_PERSON_ANALYSES

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

1571: 'PAY_ELEMENT_ENTRIES_F', -1,
1572: pa_history_id) asc;
1573:
1574: --start of bug #5900178
1575: -- Added this below cursor for the bug#5900178 to validate whether per_person_analyses
1576: --record is available for updation or not if it is available it will be continue otherwise
1577: --- it wont continue for cascading
1578: cursor chk_perana_exists(p_person_analysis_id in per_person_analyses.person_analysis_id%type)
1579: is

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

1574: --start of bug #5900178
1575: -- Added this below cursor for the bug#5900178 to validate whether per_person_analyses
1576: --record is available for updation or not if it is available it will be continue otherwise
1577: --- it wont continue for cascading
1578: cursor chk_perana_exists(p_person_analysis_id in per_person_analyses.person_analysis_id%type)
1579: is
1580: SELECT 1
1581: FROM PER_PERSON_ANALYSES
1582: WHERE person_analysis_id = p_person_analysis_id;

Line 1581: FROM PER_PERSON_ANALYSES

1577: --- it wont continue for cascading
1578: cursor chk_perana_exists(p_person_analysis_id in per_person_analyses.person_analysis_id%type)
1579: is
1580: SELECT 1
1581: FROM PER_PERSON_ANALYSES
1582: WHERE person_analysis_id = p_person_analysis_id;
1583:
1584: m_perana varchar2(1);
1585: l_rec_exists boolean;

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

2237: NULL;
2238: ELSE
2239: --5900178
2240: l_rec_exists := TRUE;
2241: IF l_hist_rec.table_name = 'PER_PERSON_ANALYSES' THEN
2242: hr_utility.set_location('In per_person_analyses record checking',997);
2243: OPEN chk_perana_exists(p_person_analysis_id => l_hist_rec.information1);
2244: FETCH chk_perana_exists into m_perana;
2245: IF chk_perana_exists%NOTFOUND THEN

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

2238: ELSE
2239: --5900178
2240: l_rec_exists := TRUE;
2241: IF l_hist_rec.table_name = 'PER_PERSON_ANALYSES' THEN
2242: hr_utility.set_location('In per_person_analyses record checking',997);
2243: OPEN chk_perana_exists(p_person_analysis_id => l_hist_rec.information1);
2244: FETCH chk_perana_exists into m_perana;
2245: IF chk_perana_exists%NOTFOUND THEN
2246: hr_utility.set_location('In per_person_analyses record checking--notfound',996);

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

2242: hr_utility.set_location('In per_person_analyses record checking',997);
2243: OPEN chk_perana_exists(p_person_analysis_id => l_hist_rec.information1);
2244: FETCH chk_perana_exists into m_perana;
2245: IF chk_perana_exists%NOTFOUND THEN
2246: hr_utility.set_location('In per_person_analyses record checking--notfound',996);
2247: l_rec_exists := FALSE;
2248: END IF;
2249: CLOSE chk_perana_exists;
2250: END IF;

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

4646: -- ---------------------------------------------------------------------------
4647: -- {Start Of Comments}
4648: --
4649: -- Description:
4650: -- This procedure deletes a row from per_person_analyses table.
4651: --
4652: -- Pre-Requisities:
4653: -- None.
4654: --

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

4655: -- In Parameters:
4656: -- p_person_analysis_id -> person_analysis_id to be deleted.
4657: --
4658: -- Post Success:
4659: -- per_person_analyses row will have been deleted.
4660: --
4661: -- Post Failure:
4662: -- message will have been displayed to user explaining why the delete could not be completed.
4663: --

Line 4679: FROM PER_PERSON_ANALYSES

4675: l_proc varchar2(72) := 'delete_person_analyses_row';
4676: l_ovn number;
4677: cursor c_get_ovn (cp_person_analysis_id in number) is
4678: SELECT object_version_number
4679: FROM PER_PERSON_ANALYSES
4680: WHERE person_analysis_id = cp_person_analysis_id ;
4681:
4682: Begin
4683: hr_utility.set_location( 'Entering : ' || l_proc, 10);