The following lines contain the word 'select', 'insert', 'update' or 'delete':
13-Sep-2006 ssmukher 115.2 Added the new procedure delete_actionid.
/*****************************************************************************
Name : check_balance_status
Purpose : Function should be used to identify whether the balances relevant
to partcular attribute are valid for use of BRA.
Arguments : 1. Start Date
2. Business Group Id
3. Atttribute Name
Return : 'Y' for valid status and 'N' for invalid status of balance
Notes : It will used by Canadian Reports to find
if all the balances related to a report are valid or not
*****************************************************************************/
FUNCTION check_balance_status(
p_start_date in date,
p_business_group_id in hr_organization_units.organization_id%type,
p_attribute_name in varchar2)
RETURN VARCHAR2
IS
lv_package_stage VARCHAR2(50) := 'pay_ca_payroll_utils.check_balance_status';
PROCEDURE delete_actionid(p_payroll_action_id IN NUMBER) IS
CURSOR c_get_report_type(p_payactid NUMBER) IS
SELECT
ppa.report_type
FROM
pay_payroll_actions ppa
WHERE
ppa.payroll_action_id = p_payactid;
SELECT
pfd.file_detail_id
FROM pay_file_details pfd
WHERE pfd.source_id = p_payactid;
SELECT
pfd.file_detail_id
FROM pay_file_details pfd
WHERE pfd.source_id in (
SELECT assignment_action_id
FROM pay_assignment_actions
WHERE payroll_action_id = p_payactid);
DELETE
FROM pay_file_details
WHERE file_detail_id = l_file_detid;
delete from pay_file_details
where file_detail_id = aalist(i);
/* Calling the core procedure to delete the Payroll actions
and Assignment actions */
pay_archive.remove_report_actions(p_payroll_action_id);
END delete_actionid;