DBA Data[Home] [Help]

APPS.HR_MAINTAIN_PROPOSAL_API dependencies on HR_GENERAL

Line 845: if l_date_to is null or l_date_to = hr_general.end_of_time then

841: l_next_sal_review_date := trunc(p_next_sal_review_date);
842:
843: l_date_to := p_date_to;
844:
845: if l_date_to is null or l_date_to = hr_general.end_of_time then
846:
847: OPEN next_change_date(l_change_date);
848: fetch next_change_date into l_next_change_date;
849: close next_change_date;

Line 852: l_date_to:= hr_general.end_of_time;

848: fetch next_change_date into l_next_change_date;
849: close next_change_date;
850:
851: if l_next_change_date is null then
852: l_date_to:= hr_general.end_of_time;
853: else
854: l_date_to := l_next_change_date-1;
855: end if;
856:

Line 922: hr_general.g_data_migrator_mode := 'Y';

918: -- End Date Previous Salary Proposal with p_change_date-1
919: --
920: --added by vkodedal to fix 6001309
921: --
922: hr_general.g_data_migrator_mode := 'Y';
923: --
924:
925: /* Salary proposals to be end dated depending upon the
926: status of the calling proposal. Bug#7386307 by schowdhu

Line 942: hr_general.g_data_migrator_mode := 'N';

938:
939: --added by schowdhu to fix 7205132
940: update_last_change_date(p_assignment_id, p_change_date);
941:
942: hr_general.g_data_migrator_mode := 'N';
943: ----------vkodedal 7-mar-07
944: --
945: -- Update the last_change_date for the next proposal
946: --

Line 1358: if l_date_to is null or l_date_to = hr_general.end_of_time then

1354: fetch get_assignment_id into l_assignment_id;
1355: CLOSE get_assignment_id;
1356: -- changed if condition schowdhu - 04-Dec-2008
1357:
1358: if l_date_to is null or l_date_to = hr_general.end_of_time then
1359:
1360: OPEN next_change_date(l_change_date);
1361: fetch next_change_date into l_next_change_date;
1362: close next_change_date;

Line 1365: l_date_to:= hr_general.end_of_time;

1361: fetch next_change_date into l_next_change_date;
1362: close next_change_date;
1363:
1364: if l_next_change_date is null then
1365: l_date_to:= hr_general.end_of_time;
1366: else
1367: l_date_to := l_next_change_date-1;
1368: end if;
1369:

Line 1433: hr_general.g_data_migrator_mode := 'Y';

1429: /* logic added to end date salary proposals accordingly while
1430: updating a proposal Bug#7386307 by schowdhu
1431: */
1432:
1433: hr_general.g_data_migrator_mode := 'Y';
1434: --
1435: if (p_approved = 'N') then
1436: end_date_proposed_proposal(l_assignment_id, l_change_date-1);
1437: else

Line 1446: hr_general.g_data_migrator_mode := 'N';

1442: --start of comments for bug 12839611
1443: --update_last_change_date(l_assignment_id, l_change_date);
1444: --end of comments for bug 12839611
1445: --
1446: hr_general.g_data_migrator_mode := 'N';
1447: --
1448: per_pyp_upd.upd
1449: (p_pay_proposal_id => p_pay_proposal_id
1450: ,p_comments => p_comments

Line 2131: hr_general.g_data_migrator_mode := 'Y';

2127: end if;
2128: --
2129: -- Extend date_to of previous Salary Proposal
2130: --added by vkodedal to fix 6001309
2131: hr_general.g_data_migrator_mode := 'Y';
2132: --
2133: extend_salary_proposal_to_date(p_pay_proposal_id);
2134: --
2135:

Line 2139: hr_general.g_data_migrator_mode := 'N';

2135:
2136: -- added by schowdhu to fix 7205132
2137: update_last_change_date(l_assignment_id, l_last_change_date);
2138:
2139: hr_general.g_data_migrator_mode := 'N';
2140: --
2141: --
2142:
2143: -- then delete the proposal

Line 2870: l_date_to := hr_general.end_of_time;

2866: ,p_object_version_number => p_object_version_number);
2867: hr_utility.set_location(l_proc, 20);
2868:
2869: if (l_api_updating and l_date_to = hr_api.g_date) then
2870: l_date_to := hr_general.end_of_time;
2871: end if;
2872:
2873: --
2874: -- set the record