22: ,P_OBJECT_VERSION_NUMBER in NUMBER
23: ,P_EFFECTIVE_DATE in DATE
24: )is
25: begin
26: hr_utility.set_location('Entering: PQH_ATTRIBUTE_RANGES_BK2.UPDATE_ATTRIBUTE_RANGE_A', 10);
27: hr_utility.set_location(' Leaving: PQH_ATTRIBUTE_RANGES_BK2.UPDATE_ATTRIBUTE_RANGE_A', 20);
28: end UPDATE_ATTRIBUTE_RANGE_A;
29: procedure UPDATE_ATTRIBUTE_RANGE_B
30: (P_ATTRIBUTE_RANGE_ID in NUMBER
23: ,P_EFFECTIVE_DATE in DATE
24: )is
25: begin
26: hr_utility.set_location('Entering: PQH_ATTRIBUTE_RANGES_BK2.UPDATE_ATTRIBUTE_RANGE_A', 10);
27: hr_utility.set_location(' Leaving: PQH_ATTRIBUTE_RANGES_BK2.UPDATE_ATTRIBUTE_RANGE_A', 20);
28: end UPDATE_ATTRIBUTE_RANGE_A;
29: procedure UPDATE_ATTRIBUTE_RANGE_B
30: (P_ATTRIBUTE_RANGE_ID in NUMBER
31: ,P_APPROVER_FLAG in VARCHAR2
46: ,P_OBJECT_VERSION_NUMBER in NUMBER
47: ,P_EFFECTIVE_DATE in DATE
48: )is
49: begin
50: hr_utility.set_location('Entering: PQH_ATTRIBUTE_RANGES_BK2.UPDATE_ATTRIBUTE_RANGE_B', 10);
51: hr_utility.set_location(' Leaving: PQH_ATTRIBUTE_RANGES_BK2.UPDATE_ATTRIBUTE_RANGE_B', 20);
52: end UPDATE_ATTRIBUTE_RANGE_B;
53: end PQH_ATTRIBUTE_RANGES_BK2;
47: ,P_EFFECTIVE_DATE in DATE
48: )is
49: begin
50: hr_utility.set_location('Entering: PQH_ATTRIBUTE_RANGES_BK2.UPDATE_ATTRIBUTE_RANGE_B', 10);
51: hr_utility.set_location(' Leaving: PQH_ATTRIBUTE_RANGES_BK2.UPDATE_ATTRIBUTE_RANGE_B', 20);
52: end UPDATE_ATTRIBUTE_RANGE_B;
53: end PQH_ATTRIBUTE_RANGES_BK2;