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 1445: hr_general.g_data_migrator_mode := 'N';

1441: end if;
1442:
1443: update_last_change_date(l_assignment_id, l_change_date);
1444: --
1445: hr_general.g_data_migrator_mode := 'N';
1446: --
1447: per_pyp_upd.upd
1448: (p_pay_proposal_id => p_pay_proposal_id
1449: ,p_comments => p_comments

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

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

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

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

Line 2868: l_date_to := hr_general.end_of_time;

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