DBA Data[Home] [Help]

APPS.GHR_MLC_PKG dependencies on GHR_MRE_PKG

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

326: 'Sql Err is '|| sqlerrm(sqlcode);
327: raise mlc_error;
328: end;
329:
330: l_org_name :=GHR_MRE_PKG.GET_ORGANIZATION_NAME(per.ORGANIZATION_ID);
331:
332: get_pos_grp1_ddf(l_position_id,
333: l_effective_date,
334: l_pos_grp1_rec);

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

1540: 'Sql Err is '|| sqlerrm(sqlcode);
1541: raise mtc_error;
1542: end;
1543:
1544: l_org_name :=GHR_MRE_PKG.GET_ORGANIZATION_NAME(p_ORGANIZATION_ID);
1545:
1546: get_pos_grp1_ddf(l_position_id,
1547: l_effective_date,
1548: l_pos_grp1_rec);

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

2640: g_proc := 'ghr_sf52.UPDATE_position_info';
2641: l_position_data_rec.position_id := l_position_id;
2642: l_position_data_rec.effective_DATE := l_effective_DATE;
2643: l_position_data_rec.organization_id := un_per.organization_id;
2644: ----ghr_mre_pkg.UPDATE_position_info (l_position_data_rec);
2645: **************************/
2646: exception when others then
2647: l_mtcerrbuf := 'Error in ghr_sf52_pos_UPDATE.UPDATE_position_info' ||
2648: ' Sql Err is '|| sqlerrm(sqlcode);

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

3532: p_effective_date => p_effective_date,
3533: p_first_noa_code => nvl(ghr_msl_pkg.g_first_noa_code,'895'),
3534: p_pay_plan => p_pay_plan
3535: ) then
3536: ghr_mre_pkg.pr('1noa failed',to_char(p_person_id));
3537: RETURN FALSE;
3538: ELSE
3539: ghr_mre_pkg.pr('Eligible');
3540: RETURN TRUE;

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

3535: ) then
3536: ghr_mre_pkg.pr('1noa failed',to_char(p_person_id));
3537: RETURN FALSE;
3538: ELSE
3539: ghr_mre_pkg.pr('Eligible');
3540: RETURN TRUE;
3541: END IF;
3542: END IF;
3543:

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

3708: p_effective_date => p_effective_date,
3709: p_first_noa_code => '894',
3710: p_pay_plan => p_pay_plan
3711: ) then
3712: ghr_mre_pkg.pr('1noa failed',to_char(p_person_id));
3713: RETURN FALSE;
3714: ELSE
3715: ghr_mre_pkg.pr('Eligible');
3716: RETURN TRUE;

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

3711: ) then
3712: ghr_mre_pkg.pr('1noa failed',to_char(p_person_id));
3713: RETURN FALSE;
3714: ELSE
3715: ghr_mre_pkg.pr('Eligible');
3716: RETURN TRUE;
3717: END IF;
3718: END IF;
3719:

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

4374: else
4375: l_comb_rem := p_remark_code1;
4376: end if;
4377:
4378: l_poi_desc := GHR_MRE_PKG.GET_POI_NAME (p_personnel_office_id);
4379:
4380: BEGIN
4381: l_cust_in_rec.person_id := p_person_id;
4382: l_cust_in_rec.position_id := p_position_id;

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

4696: else
4697: l_comb_rem := p_remark_code1;
4698: end if;
4699:
4700: l_poi_desc := GHR_MRE_PKG.GET_POI_NAME (p_personnel_office_id);
4701:
4702: BEGIN
4703: l_cust_in_rec.person_id := p_person_id;
4704: l_cust_in_rec.position_id := p_position_id;