DBA Data[Home] [Help]

APPS.GHR_LACS_REMARKS dependencies on GHR_MASS_ACTIONS_PKG

Line 191: ghr_mass_actions_pkg.get_remark_id_desc

187: l_remark_desc_out ghr_remarks.description%TYPE;
188:
189: BEGIN
190: l_location := 'Apply_894_Rules:Create_Remark(' || p_remark_code || ')';
191: ghr_mass_actions_pkg.get_remark_id_desc
192: (p_remark_code => p_remark_code,
193: p_effective_date => g_requests_rec.effective_date,
194: p_remark_id => l_remark_id,
195: p_remark_desc => l_remark_desc);

Line 243: ghr_mass_actions_pkg.replace_insertion_values

239:
240: -- HARD CODING for this remark only. replacing 2 hyphens with the percent
241: END IF;
242: --Pradeep commented l_remark_desc and added l_remark_desc_out for the Bug#3974979.
243: ghr_mass_actions_pkg.replace_insertion_values
244: (p_desc => l_remark_desc,
245: p_information1 => l_remark_information1,
246: p_information2 => l_remark_information2,
247: p_information3 => l_remark_information3,

Line 434: ghr_mass_actions_pkg.replace_insertion_values

430: NVL(fcl.end_date_active, g_requests_rec.effective_date);
431: IF l_la_code1 in ('ZLM','UNM') THEN
432: -- Bug#4256022 Passed the variable l_la_desc1_out and assigned
433: -- the value back to l_la_desc1 to avoid NOCOPY related problems.
434: ghr_mass_actions_pkg.replace_insertion_values
435: (p_desc => l_la_desc1,
436: p_information1 => l_insrt_value1,
437: p_desc_out => l_la_desc1_out);
438: l_la_desc1 := l_la_desc1_out;

Line 457: ghr_mass_actions_pkg.replace_insertion_values

453: END IF;
454: IF l_la_code2 in ('ZLM','UNM') THEN
455: -- Bug#4256022 Passed the variable l_la_desc2_out and
456: -- assigned the value back to l_la_desc2 to avoid NOCOPY related problems..
457: ghr_mass_actions_pkg.replace_insertion_values
458: (p_desc => l_la_desc2,
459: p_information1 => l_insrt_value2,
460: p_desc_out => l_la_desc2_out);
461: l_la_desc2 := l_la_desc2_out;

Line 743: ghr_mass_actions_pkg.replace_insertion_values

739: l_la_desc2 := ghr_pa_requests_pkg.get_lookup_description(800,'GHR_US_LEGAL_AUTHORITY',l_la_code2);
740:
741: IF (l_la_code1 = 'ZLM') THEN
742: l_insrt_value := 'P.L. 108-411, Sec. 301 dated 10-30-04.';
743: ghr_mass_actions_pkg.replace_insertion_values
744: (p_desc => l_la_desc1,
745: p_information1 => l_insrt_value,
746: p_desc_out => l_la_desc1_out);
747: l_la_desc1 := l_la_desc1_out;

Line 752: ghr_mass_actions_pkg.replace_insertion_values

748: END IF;
749:
750: IF (l_la_code2 = 'ZLM') THEN
751: l_insrt_value := 'P.L. 108-411, Sec. 301 dated 10-30-04.';
752: ghr_mass_actions_pkg.replace_insertion_values
753: (p_desc => l_la_desc2,
754: p_information1 => l_insrt_value,
755: p_desc_out => l_la_desc2_out);
756: l_la_desc2 := l_la_desc2_out;