DBA Data[Home] [Help]

APPS.HR_MX_EXTRA_ASG_RULES dependencies on HR_MX_ASSIGNMENT_API

Line 57: hr_mx_assignment_api.g_old_location := l_location_id;

53: OPEN csr_get_gre_location;
54: FETCH csr_get_gre_location INTO l_location_id, l_scl_gre;
55: CLOSE csr_get_gre_location;
56:
57: hr_mx_assignment_api.g_old_location := l_location_id;
58: hr_mx_assignment_api.g_old_gre := l_scl_gre;
59:
60: IF g_debug THEN
61: hr_utility.set_location('Leaving: '||l_proc, 20);

Line 58: hr_mx_assignment_api.g_old_gre := l_scl_gre;

54: FETCH csr_get_gre_location INTO l_location_id, l_scl_gre;
55: CLOSE csr_get_gre_location;
56:
57: hr_mx_assignment_api.g_old_location := l_location_id;
58: hr_mx_assignment_api.g_old_gre := l_scl_gre;
59:
60: IF g_debug THEN
61: hr_utility.set_location('Leaving: '||l_proc, 20);
62: END IF;

Line 132: l_location_old := hr_mx_assignment_api.g_old_location;

128: --------------------------------------------------------------------------
129: -- Get the OLD gre and location from the global variables that have been
130: -- set in the BP hook
131: --------------------------------------------------------------------------
132: l_location_old := hr_mx_assignment_api.g_old_location;
133: l_scl_gre := hr_mx_assignment_api.g_old_gre;
134:
135: --------------------------------------------------------------------------
136: -- Reset the global variables for Old Location and GRE to NULL.

Line 133: l_scl_gre := hr_mx_assignment_api.g_old_gre;

129: -- Get the OLD gre and location from the global variables that have been
130: -- set in the BP hook
131: --------------------------------------------------------------------------
132: l_location_old := hr_mx_assignment_api.g_old_location;
133: l_scl_gre := hr_mx_assignment_api.g_old_gre;
134:
135: --------------------------------------------------------------------------
136: -- Reset the global variables for Old Location and GRE to NULL.
137: --------------------------------------------------------------------------

Line 138: hr_mx_assignment_api.g_old_location := NULL;

134:
135: --------------------------------------------------------------------------
136: -- Reset the global variables for Old Location and GRE to NULL.
137: --------------------------------------------------------------------------
138: hr_mx_assignment_api.g_old_location := NULL;
139: hr_mx_assignment_api.g_old_gre := NULL;
140:
141: OPEN csr_fetch_bg;
142: FETCH csr_fetch_bg INTO l_bg_id;

Line 139: hr_mx_assignment_api.g_old_gre := NULL;

135: --------------------------------------------------------------------------
136: -- Reset the global variables for Old Location and GRE to NULL.
137: --------------------------------------------------------------------------
138: hr_mx_assignment_api.g_old_location := NULL;
139: hr_mx_assignment_api.g_old_gre := NULL;
140:
141: OPEN csr_fetch_bg;
142: FETCH csr_fetch_bg INTO l_bg_id;
143: CLOSE csr_fetch_bg;

Line 208: IF hr_mx_assignment_api.g_leaving_reason IS NULL THEN

204: --------------------------------------------------------------------------
205: -- If YES, then check the leaving reason Global Variable. If it's null,
206: -- raise an error. Else, insert an Assignment EIT record using the API.
207: --------------------------------------------------------------------------
208: IF hr_mx_assignment_api.g_leaving_reason IS NULL THEN
209:
210: -- hr_utility.set_message(800,'HR_MX_MISSING_LEAVING_REASON');
211: -- hr_utility.raise_error;
212: null;

Line 232: p_aei_information3 => hr_mx_assignment_api.g_leaving_reason,

228: p_information_type => 'MX_SS_EMP_TRANS_REASON',
229: p_aei_information_category => 'MX_SS_EMP_TRANS_REASON',
230: p_aei_information1 => fnd_date.date_to_canonical(trunc(p_effective_date) - 1),
231: p_aei_information2 => l_gre_old,
232: p_aei_information3 => hr_mx_assignment_api.g_leaving_reason,
233: p_assignment_extra_info_id => l_dummy3,
234: p_object_version_number => l_dummy4
235: );
236:

Line 241: hr_mx_assignment_api.g_leaving_reason := null;

237: IF g_debug THEN
238: hr_utility.set_location(l_proc, 60);
239: END IF;
240:
241: hr_mx_assignment_api.g_leaving_reason := null;
242:
243: END IF;
244:
245: END IF;

Line 321: l_location_old := hr_mx_assignment_api.g_old_location;

317: get_gre_loc(p_effective_date,
318: p_assignment_id
319: );
320:
321: l_location_old := hr_mx_assignment_api.g_old_location;
322: l_scl_gre := hr_mx_assignment_api.g_old_gre;
323:
324: --------------------------------------------------------------------------
325: -- Reset the global variables for Old Location and GRE to NULL.

Line 322: l_scl_gre := hr_mx_assignment_api.g_old_gre;

318: p_assignment_id
319: );
320:
321: l_location_old := hr_mx_assignment_api.g_old_location;
322: l_scl_gre := hr_mx_assignment_api.g_old_gre;
323:
324: --------------------------------------------------------------------------
325: -- Reset the global variables for Old Location and GRE to NULL.
326: --------------------------------------------------------------------------

Line 327: hr_mx_assignment_api.g_old_location := NULL;

323:
324: --------------------------------------------------------------------------
325: -- Reset the global variables for Old Location and GRE to NULL.
326: --------------------------------------------------------------------------
327: hr_mx_assignment_api.g_old_location := NULL;
328: hr_mx_assignment_api.g_old_gre := NULL;
329:
330: OPEN csr_fetch_bg;
331: FETCH csr_fetch_bg INTO l_bg_id;

Line 328: hr_mx_assignment_api.g_old_gre := NULL;

324: --------------------------------------------------------------------------
325: -- Reset the global variables for Old Location and GRE to NULL.
326: --------------------------------------------------------------------------
327: hr_mx_assignment_api.g_old_location := NULL;
328: hr_mx_assignment_api.g_old_gre := NULL;
329:
330: OPEN csr_fetch_bg;
331: FETCH csr_fetch_bg INTO l_bg_id;
332: CLOSE csr_fetch_bg;

Line 389: IF hr_mx_assignment_api.g_leaving_reason IS NULL THEN

385: --------------------------------------------------------------------------
386: -- If YES, then check the leaving reason Global Variable. If it's null,
387: -- raise an error. Else, insert an Assignment EIT record using the API.
388: --------------------------------------------------------------------------
389: IF hr_mx_assignment_api.g_leaving_reason IS NULL THEN
390:
391: IF g_debug THEN
392: hr_utility.set_location(l_proc, 40);
393: END IF;

Line 413: p_aei_information3 => hr_mx_assignment_api.g_leaving_reason,

409: p_information_type => 'MX_SS_EMP_TRANS_REASON',
410: p_aei_information_category => 'MX_SS_EMP_TRANS_REASON',
411: p_aei_information1 => fnd_date.date_to_canonical(trunc(p_effective_date) - 1),
412: p_aei_information2 => l_gre_old,
413: p_aei_information3 => hr_mx_assignment_api.g_leaving_reason,
414: p_assignment_extra_info_id => l_dummy3,
415: p_object_version_number => l_dummy4
416: );
417:

Line 418: hr_mx_assignment_api.g_leaving_reason := null;

414: p_assignment_extra_info_id => l_dummy3,
415: p_object_version_number => l_dummy4
416: );
417:
418: hr_mx_assignment_api.g_leaving_reason := null;
419:
420: IF g_debug THEN
421: hr_utility.set_location(l_proc, 60);
422: END IF;

Line 497: l_location_old := hr_mx_assignment_api.g_old_location;

493: get_gre_loc(p_final_process_date,
494: p_assignment_id
495: );
496:
497: l_location_old := hr_mx_assignment_api.g_old_location;
498: l_scl_gre := hr_mx_assignment_api.g_old_gre;
499:
500: --------------------------------------------------------------------------
501: -- Reset the global variables for Old Location and GRE to NULL.

Line 498: l_scl_gre := hr_mx_assignment_api.g_old_gre;

494: p_assignment_id
495: );
496:
497: l_location_old := hr_mx_assignment_api.g_old_location;
498: l_scl_gre := hr_mx_assignment_api.g_old_gre;
499:
500: --------------------------------------------------------------------------
501: -- Reset the global variables for Old Location and GRE to NULL.
502: --------------------------------------------------------------------------

Line 503: hr_mx_assignment_api.g_old_location := NULL;

499:
500: --------------------------------------------------------------------------
501: -- Reset the global variables for Old Location and GRE to NULL.
502: --------------------------------------------------------------------------
503: hr_mx_assignment_api.g_old_location := NULL;
504: hr_mx_assignment_api.g_old_gre := NULL;
505:
506: --------------------------------------------------------------------------
507: -- Fetch the BG for the assignment and set the corresponding system profile.

Line 504: hr_mx_assignment_api.g_old_gre := NULL;

500: --------------------------------------------------------------------------
501: -- Reset the global variables for Old Location and GRE to NULL.
502: --------------------------------------------------------------------------
503: hr_mx_assignment_api.g_old_location := NULL;
504: hr_mx_assignment_api.g_old_gre := NULL;
505:
506: --------------------------------------------------------------------------
507: -- Fetch the BG for the assignment and set the corresponding system profile.
508: --------------------------------------------------------------------------

Line 540: IF hr_mx_assignment_api.g_leaving_reason IS NULL THEN

536: --------------------------------------------------------------------------
537: -- Check the leaving reason Global Variable. If it's null,
538: -- raise an error. Else, insert an Assignment EIT record using the API.
539: --------------------------------------------------------------------------
540: IF hr_mx_assignment_api.g_leaving_reason IS NULL THEN
541:
542: IF g_debug THEN
543: hr_utility.set_location(l_proc, 40);
544: END IF;

Line 562: p_aei_information3 => hr_mx_assignment_api.g_leaving_reason,

558: p_information_type => 'MX_SS_EMP_TRANS_REASON',
559: p_aei_information_category => 'MX_SS_EMP_TRANS_REASON',
560: p_aei_information1 => fnd_date.date_to_canonical(trunc(p_final_process_date)),
561: p_aei_information2 => l_gre_old,
562: p_aei_information3 => hr_mx_assignment_api.g_leaving_reason,
563: p_assignment_extra_info_id => l_dummy3,
564: p_object_version_number => l_dummy4
565: );
566:

Line 567: hr_mx_assignment_api.g_leaving_reason := null;

563: p_assignment_extra_info_id => l_dummy3,
564: p_object_version_number => l_dummy4
565: );
566:
567: hr_mx_assignment_api.g_leaving_reason := null;
568:
569: IF g_debug THEN
570: hr_utility.set_location(l_proc, 60);
571: END IF;

Line 629: IF hr_mx_assignment_api.g_leaving_reason IS NULL THEN

625: --------------------------------------------------------------------------
626: -- Check the leaving reason Global Variable. If it's null, raise an error.
627: -- Else, save it in the Period of Service DDF using the API.
628: --------------------------------------------------------------------------
629: IF hr_mx_assignment_api.g_leaving_reason IS NULL THEN
630:
631: IF g_debug THEN
632: hr_utility.set_location(l_proc, 20);
633: END IF;

Line 664: hr_mx_assignment_api.g_leaving_reason

660: ,p_final_process_date => trunc(p_final_process_date)
661: ,p_period_of_service_id => p_period_of_service_id
662: ,p_pds_information_category => 'MX'
663: ,p_pds_information1 =>
664: hr_mx_assignment_api.g_leaving_reason
665: ,p_object_version_number => l_dummy
666: );
667:
668: hr_mx_assignment_api.g_leaving_reason := null;

Line 668: hr_mx_assignment_api.g_leaving_reason := null;

664: hr_mx_assignment_api.g_leaving_reason
665: ,p_object_version_number => l_dummy
666: );
667:
668: hr_mx_assignment_api.g_leaving_reason := null;
669:
670: IF g_debug THEN
671: hr_utility.set_location(l_proc, 40);
672: END IF;