[Home] [Help]
52: <> pay_pwr_shd.g_old_rec.rate_id) then
53: --
54: -- raise error as PK has changed
55: --
56: pay_pwr_shd.constraint_error('PAY_WCI_RATES_PK');
57: --
58: elsif not l_api_updating then
59: --
60: -- check if PK is null
62: if p_rate_id is not null then
63: --
64: -- raise error as PK is not null
65: --
66: pay_pwr_shd.constraint_error('PAY_WCI_RATES_PK');
67: --
68: end if;
69: --
70: end if;
76: -- ----------------------------------------------------------------------------
77: --|----------------------------
78: -- ----------------------------------------------------------------------------
79: -- Description : This function is used to validate a new Rate Code (just code in
80: -- the table pay_wci_rates.
81: -- Validation : A rate code must be unique within an Account Number.
82: -- On Failure : Raise message 'The Rate Code you have entered already exists
83: -- within the current Account Number. Enter a different Rate
84: -- Code.
92: ,p_account_id number
93: ,p_business_group_id number)
94: IS
95: SELECT code
96: FROM pay_wci_rates
97: WHERE code = p_rate_code
98: AND account_id = p_account_id
99: AND business_group_id = p_business_group_id;
100: --
211: --
212: cursor csr_leg_code is
213: select a.legislation_code
214: from per_business_groups a,
215: pay_wci_rates b
216: where b.rate_id = p_rate_id
217: and a.business_group_id = b.business_group_id;
218: --
219: -- Declare local variables