APPS.PAY_FUNCTIONAL_AREAS_PKG dependencies on PAY_FUNCTIONAL_AREAS_PKG

Line 1: PACKAGE BODY pay_functional_areas_pkg AS

1: PACKAGE BODY pay_functional_areas_pkg AS
2: -- $Header: pypfaapi.pkb 115.3 2002/12/11 15:13:18 exjones noship $
3: --
4: ----------------------------------------------------------------------------------
5: PROCEDURE lock_row(

Line 28: 'PAY_FUNCTIONAL_AREAS_PKG.LOCK_ROW'

24: CLOSE csr_functional_area;
25: Hr_Utility.Set_Message(801,'HR_6153_ALL_PROCEDURE_FAIL');
26: Hr_Utility.Set_Message_Token(
27: 'PROCEDURE',
28: 'PAY_FUNCTIONAL_AREAS_PKG.LOCK_ROW'
29: );
30: END IF;
31: CLOSE csr_functional_area;
32: --

Line 87: 'PAY_FUNCTIONAL_AREAS_PKG.INSERT_ROW'

83: CLOSE csr_area_rowid;
84: Hr_Utility.Set_Message(801,'HR_6153_ALL_PROCEDURE_FAIL');
85: Hr_Utility.Set_Message_Token(
86: 'PROCEDURE',
87: 'PAY_FUNCTIONAL_AREAS_PKG.INSERT_ROW'
88: );
89: END IF;
90: CLOSE csr_area_rowid;
91: --

Line 112: 'PAY_FUNCTIONAL_AREAS_PKG.UPDATE_ROW'

108: IF SQL%NOTFOUND THEN
109: Hr_Utility.Set_Message(801,'HR_6153_ALL_PROCEDURE_FAIL');
110: Hr_Utility.Set_Message_Token(
111: 'PROCEDURE',
112: 'PAY_FUNCTIONAL_AREAS_PKG.UPDATE_ROW'
113: );
114: END IF;
115: END update_row;
116: ----------------------------------------------------------------------------------

Line 130: 'PAY_FUNCTIONAL_AREAS_PKG.DELETE_ROW'

126: IF SQL%NOTFOUND THEN
127: Hr_Utility.Set_Message(801,'HR_6153_ALL_PROCEDURE_FAIL');
128: Hr_Utility.Set_Message_Token(
129: 'PROCEDURE',
130: 'PAY_FUNCTIONAL_AREAS_PKG.DELETE_ROW'
131: );
132: END IF;
133: END delete_row;
134: -----------------------------------------------------------------------------------

Line 160: hr_utility.set_location('PAY_FUNCTIONAL_AREAS_PKG.NAME_IS_NOT_UNIQUE',1);

156: or p_area_id is null);
157: --
158: begin
159: --
160: hr_utility.set_location('PAY_FUNCTIONAL_AREAS_PKG.NAME_IS_NOT_UNIQUE',1);
161: --
162: open csr_duplicate;
163: fetch csr_duplicate into l_dummy_number;
164: v_name_duplicated := csr_duplicate%found;

Line 172: END pay_functional_areas_pkg;

168: --
169: end name_is_not_unique;
170: --
171:
172: END pay_functional_areas_pkg;