44: ,P_EFFECTIVE_DATE in DATE
45: ,P_DATETRACK_MODE in VARCHAR2
46: )is
47: begin
48: hr_utility.set_location('Entering: BEN_SVC_AREA_PSTL_ZIP_RNG_BK2.UPDATE_SVC_AREA_PSTL_ZIP_RNG_A', 10);
49: hr_utility.set_location(' Leaving: BEN_SVC_AREA_PSTL_ZIP_RNG_BK2.UPDATE_SVC_AREA_PSTL_ZIP_RNG_A', 20);
50: end UPDATE_SVC_AREA_PSTL_ZIP_RNG_A;
51: procedure UPDATE_SVC_AREA_PSTL_ZIP_RNG_B
52: (P_SVC_AREA_PSTL_ZIP_RNG_ID in NUMBER
45: ,P_DATETRACK_MODE in VARCHAR2
46: )is
47: begin
48: hr_utility.set_location('Entering: BEN_SVC_AREA_PSTL_ZIP_RNG_BK2.UPDATE_SVC_AREA_PSTL_ZIP_RNG_A', 10);
49: hr_utility.set_location(' Leaving: BEN_SVC_AREA_PSTL_ZIP_RNG_BK2.UPDATE_SVC_AREA_PSTL_ZIP_RNG_A', 20);
50: end UPDATE_SVC_AREA_PSTL_ZIP_RNG_A;
51: procedure UPDATE_SVC_AREA_PSTL_ZIP_RNG_B
52: (P_SVC_AREA_PSTL_ZIP_RNG_ID in NUMBER
53: ,P_SVC_AREA_ID in NUMBER
88: ,P_EFFECTIVE_DATE in DATE
89: ,P_DATETRACK_MODE in VARCHAR2
90: )is
91: begin
92: hr_utility.set_location('Entering: BEN_SVC_AREA_PSTL_ZIP_RNG_BK2.UPDATE_SVC_AREA_PSTL_ZIP_RNG_B', 10);
93: hr_utility.set_location(' Leaving: BEN_SVC_AREA_PSTL_ZIP_RNG_BK2.UPDATE_SVC_AREA_PSTL_ZIP_RNG_B', 20);
94: end UPDATE_SVC_AREA_PSTL_ZIP_RNG_B;
95: end BEN_SVC_AREA_PSTL_ZIP_RNG_BK2;
89: ,P_DATETRACK_MODE in VARCHAR2
90: )is
91: begin
92: hr_utility.set_location('Entering: BEN_SVC_AREA_PSTL_ZIP_RNG_BK2.UPDATE_SVC_AREA_PSTL_ZIP_RNG_B', 10);
93: hr_utility.set_location(' Leaving: BEN_SVC_AREA_PSTL_ZIP_RNG_BK2.UPDATE_SVC_AREA_PSTL_ZIP_RNG_B', 20);
94: end UPDATE_SVC_AREA_PSTL_ZIP_RNG_B;
95: end BEN_SVC_AREA_PSTL_ZIP_RNG_BK2;