APPS.GHR_MLC_PKG dependencies on GHR_MRE_PKG

Line 323: l_org_name :=GHR_MRE_PKG.GET_ORGANIZATION_NAME(per.ORGANIZATION_ID);

319: 'Sql Err is '|| sqlerrm(sqlcode);
320: raise mlc_error;
321: end;
322:
323: l_org_name :=GHR_MRE_PKG.GET_ORGANIZATION_NAME(per.ORGANIZATION_ID);
324:
325: get_pos_grp1_ddf(l_position_id,
326: l_effective_date,
327: l_pos_grp1_rec);

Line 1516: l_org_name :=GHR_MRE_PKG.GET_ORGANIZATION_NAME(p_ORGANIZATION_ID);

1512: 'Sql Err is '|| sqlerrm(sqlcode);
1513: raise mtc_error;
1514: end;
1515:
1516: l_org_name :=GHR_MRE_PKG.GET_ORGANIZATION_NAME(p_ORGANIZATION_ID);
1517:
1518: get_pos_grp1_ddf(l_position_id,
1519: l_effective_date,
1520: l_pos_grp1_rec);

Line 2602: ----ghr_mre_pkg.UPDATE_position_info (l_position_data_rec);

2598: g_proc := 'ghr_sf52.UPDATE_position_info';
2599: l_position_data_rec.position_id := l_position_id;
2600: l_position_data_rec.effective_DATE := l_effective_DATE;
2601: l_position_data_rec.organization_id := un_per.organization_id;
2602: ----ghr_mre_pkg.UPDATE_position_info (l_position_data_rec);
2603: **************************/
2604: exception when others then
2605: l_mtcerrbuf := 'Error in ghr_sf52_pos_UPDATE.UPDATE_position_info' ||
2606: ' Sql Err is '|| sqlerrm(sqlcode);

Line 3490: ghr_mre_pkg.pr('1noa failed',to_char(p_person_id));

3486: p_effective_date => p_effective_date,
3487: p_first_noa_code => nvl(ghr_msl_pkg.g_first_noa_code,'895'),
3488: p_pay_plan => p_pay_plan
3489: ) then
3490: ghr_mre_pkg.pr('1noa failed',to_char(p_person_id));
3491: RETURN FALSE;
3492: ELSE
3493: ghr_mre_pkg.pr('Eligible');
3494: RETURN TRUE;

Line 3493: ghr_mre_pkg.pr('Eligible');

3489: ) then
3490: ghr_mre_pkg.pr('1noa failed',to_char(p_person_id));
3491: RETURN FALSE;
3492: ELSE
3493: ghr_mre_pkg.pr('Eligible');
3494: RETURN TRUE;
3495: END IF;
3496: END IF;
3497:

Line 3666: ghr_mre_pkg.pr('1noa failed',to_char(p_person_id));

3662: p_effective_date => p_effective_date,
3663: p_first_noa_code => '894',
3664: p_pay_plan => p_pay_plan
3665: ) then
3666: ghr_mre_pkg.pr('1noa failed',to_char(p_person_id));
3667: RETURN FALSE;
3668: ELSE
3669: ghr_mre_pkg.pr('Eligible');
3670: RETURN TRUE;

Line 3669: ghr_mre_pkg.pr('Eligible');

3665: ) then
3666: ghr_mre_pkg.pr('1noa failed',to_char(p_person_id));
3667: RETURN FALSE;
3668: ELSE
3669: ghr_mre_pkg.pr('Eligible');
3670: RETURN TRUE;
3671: END IF;
3672: END IF;
3673:

Line 4330: l_poi_desc := GHR_MRE_PKG.GET_POI_NAME (p_personnel_office_id);

4326: else
4327: l_comb_rem := p_remark_code1;
4328: end if;
4329:
4330: l_poi_desc := GHR_MRE_PKG.GET_POI_NAME (p_personnel_office_id);
4331:
4332: BEGIN
4333: l_cust_in_rec.person_id := p_person_id;
4334: l_cust_in_rec.position_id := p_position_id;

Line 4646: l_poi_desc := GHR_MRE_PKG.GET_POI_NAME (p_personnel_office_id);

4642: else
4643: l_comb_rem := p_remark_code1;
4644: end if;
4645:
4646: l_poi_desc := GHR_MRE_PKG.GET_POI_NAME (p_personnel_office_id);
4647:
4648: BEGIN
4649: l_cust_in_rec.person_id := p_person_id;
4650: l_cust_in_rec.position_id := p_position_id;