1: PACKAGE BODY pay_functional_usages_pkg AS
2: -- $Header: pypfuapi.pkb 115.2 2002/12/11 15:13:43 exjones noship $
3: --
4: PROCEDURE lock_row(
5: p_row_id IN VARCHAR2,
26: CLOSE csr_functional_usage;
27: Hr_Utility.Set_Message(801,'HR_6153_ALL_PROCEDURE_FAIL');
28: Hr_Utility.Set_Message_Token(
29: 'PROCEDURE',
30: 'PAY_FUNCTIONAL_USAGES_PKG.LOCK_ROW'
31: );
32: END IF;
33: CLOSE csr_functional_usage;
34: --
94: CLOSE csr_usage_rowid;
95: Hr_Utility.Set_Message(801,'HR_6153_ALL_PROCEDURE_FAIL');
96: Hr_Utility.Set_Message_Token(
97: 'PROCEDURE',
98: 'PAY_FUNCTIONAL_USAGES_PKG.INSERT_ROW'
99: );
100: END IF;
101: CLOSE csr_usage_rowid;
102: --
122: IF SQL%NOTFOUND THEN
123: Hr_Utility.Set_Message(801,'HR_6153_ALL_PROCEDURE_FAIL');
124: Hr_Utility.Set_Message_Token(
125: 'PROCEDURE',
126: 'PAY_FUNCTIONAL_USAGES_PKG.UPDATE_ROW'
127: );
128: END IF;
129: END update_row;
130: --
140: IF SQL%NOTFOUND THEN
141: Hr_Utility.Set_Message(801,'HR_6153_ALL_PROCEDURE_FAIL');
142: Hr_Utility.Set_Message_Token(
143: 'PROCEDURE',
144: 'PAY_FUNCTIONAL_USAGES_PKG.DELETE_ROW'
145: );
146: END IF;
147: END delete_row;
148: --
145: );
146: END IF;
147: END delete_row;
148: --
149: END pay_functional_usages_pkg;