The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT status, payrun_id,org_id,object_version_number
FROM cn_payruns
WHERE payrun_id = p_payrun_id;
SELECT payment_worksheet_id,object_version_number
FROM cn_payment_worksheets
WHERE payrun_id = p_payrun_id
AND quota_id IS NULL
AND worksheet_status = 'UNPAID'
--R12
AND org_id = p_org_id;
x_loading_status := 'CN_DELETED';
cn_payment_worksheet_pvt.update_Worksheet
(p_api_version => p_api_version,
p_init_msg_list => p_init_msg_list,
p_commit => fnd_api.g_false,
p_validation_level => p_validation_level,
x_return_status => x_return_status,
x_msg_count => x_msg_count,
x_msg_data => x_msg_data,
p_worksheet_id => worksheets.payment_worksheet_id,
p_operation => 'REFRESH',
x_status => x_status,
x_loading_status => x_loading_status,
--R12
x_ovn => worksheets.object_version_number );
SELECT name,
org_id,
pay_period_id,
pay_date
FROM cn_payruns
WHERE payrun_id = p_payrun_id ;
SELECT p.assignment_id assignment_id,
p.assignment_number assignment_number,
rre.source_business_grp_id source_business_grp_id,
rs.status status
FROM jtf_rs_salesreps rs,
jtf_rs_resource_extns rre,
per_assignments_f p,
cn_payruns ps
WHERE rs.salesrep_id = p_salesrep_id
AND rs.org_id = p_org_id
AND rs.resource_id = rre.resource_id
AND rre.category = 'EMPLOYEE'
AND rre.source_id = p.person_id
AND ps.payrun_id = p_payrun_id
AND ps.pay_date BETWEEN p.effective_start_date AND Nvl(p.effective_end_date,ps.pay_date) AND p.assignment_type = 'E';
SELECT tab.name table_name , col.name column_name,
piv.display_sequence line_number,
piv.input_value_id element_input_id ,
piv.uom uom, piv.name element_input_name
FROM cn_pay_element_inputs pei,
cn_quota_pay_elements qpe,
cn_payruns p,
cn_objects tab,
cn_objects col,
pay_element_types_f pet,
pay_input_values_f piv
WHERE qpe.pay_element_type_id = p_element_type_id
AND qpe.quota_id = decode(p_incentive_type_code,
'PMTPLN_REC' , -1001,
p_quota_id)
AND qpe.status = p_status
AND p.payrun_id = p_payrun_id
AND p.pay_date BETWEEN qpe.start_date AND qpe.end_date
AND pet.input_currency_code = p_currency_code
AND qpe.pay_element_type_id = pet.element_type_id
AND qpe.start_date >= pet.effective_start_date
AND qpe.end_date <= pet.effective_end_date
AND qpe.quota_pay_element_id = pei.quota_pay_element_id
AND trunc(pet.effective_start_date) = trunc(piv.effective_start_date)
AND trunc(pet.effective_end_date) = trunc(piv.effective_end_date)
AND pei.element_input_id = piv.input_value_id
AND tab.object_id = pei.tab_object_id
AND col.object_id = pei.col_object_id
AND col.table_id = pei.tab_object_id
AND p.org_id = tab.org_id
-- AND p.org_id = col.org_id
UNION
SELECT null table_name ,
null column_name,
piv.display_sequence line_number,
piv.input_value_id element_input_id,
piv.uom uom, piv.name element_input_name
FROM
pay_input_values_f piv,
pay_element_types_f pet,
cn_quota_pay_elements qpe,
cn_payruns p
WHERE qpe.pay_element_type_id = p_element_type_id
AND qpe.quota_id = decode(p_incentive_type_code,
'PMTPLN_REC' , -1001,
p_quota_id)
AND qpe.status = p_status
AND p.payrun_id = p_payrun_id
AND p.pay_date BETWEEN qpe.start_date AND qpe.end_Date
AND pet.input_currency_code = p_currency_code
AND qpe.pay_element_type_id = pet.element_type_id
AND qpe.start_date >= pet.effective_start_date
AND qpe.end_date <= pet.effective_end_date
AND trunc(pet.effective_start_date) = trunc(piv.effective_start_date)
AND trunc(pet.effective_end_date) = trunc(piv.effective_end_date)
AND pet.element_type_id = piv.element_type_id
AND not exists ( select 1 from cn_pay_element_inputs cpei
WHERE cpei.quota_pay_element_id = qpe.quota_pay_element_id
AND qpe.pay_element_type_id = piv.element_type_id
AND cpei.element_input_id = piv.input_value_id )
ORDER by line_number, element_input_name ;
Select element_name
from pay_element_types_f
where element_type_id = p_element_type_id ;
l_select VARCHAR2(32000) ;
SELECT glsob.set_of_books_id set_of_books_id,
glsob.currency_code currency_code
FROM gl_sets_of_books glsob,
cn_repositories cnr,
cn_payruns cnp
WHERE cnr.set_of_books_id = glsob.set_of_books_id
AND cnr.org_id = cnp.org_id
AND cnp.payrun_id = p_payrun_id;
l_select := l_select || tab_columns.table_name
||'.'||tab_columns.column_name -- nvl(p_amount,0)
|| ' C_'||l_count|| ',';
l_select := l_select || tab_columns.table_name
||'.'||tab_columns.column_name
|| ' C_'||l_count|| ',';
l_select := l_select || 'NULL'
|| ' C_'||l_count|| ',';
l_select := substr(l_select, 1, length(l_select)-1);
if l_select is null then
l_select := l_select || ' NULL ' ;
l_select := l_select || ',' || ' NULL ' ;
l_select := ' SELECT ' || l_select
|| ' FROM ' || l_from
|| ' WHERE ' || l_where;
open main_cursor for l_select using p_payrun_id, p_salesrep_id, p_quota_id, p_incentive_type_code ;
SELECT sum(nvl(pt.payment_amount,0)) payment_amount,
pt.credited_salesrep_id,
pt.pay_element_type_id,
pt.quota_id,
pt.incentive_type_code
FROM cn_payment_transactions pt
WHERE pt.payrun_id = p_payrun_id
AND nvl(waive_flag,'N') = 'N'
AND nvl(hold_flag, 'N') = 'N'
GROUP BY pt.quota_id,
pt.credited_salesrep_id,
pt.pay_element_type_id,
pt.incentive_type_code;
select distinct w.quota_id,q.name
from cn_payment_worksheets w,
cn_quotas q,cn_salesreps cns
where payrun_id=p_payrun
and w.quota_id is not null
and w.quota_id=q.quota_id
and w.salesrep_id=cns.salesrep_id
and w.org_id = cns.org_id
and cns.type='EMPLOYEE';
select COUNT(*) from
cn_quota_pay_elements
where quota_id = p_quotaId
and p_pay_date
between
START_DATE and END_DATE;
select COUNT(*) from
cn_pay_element_inputs_all cp,
cn_quota_pay_elements_all cq
WHERE
cp.quota_pay_element_id = cq.quota_pay_element_id
AND cq.quota_id =p_quota_id;
SELECT COUNT(1)
FROM cn_payruns
WHERE name = p_name
AND org_id=p_org_id;
SELECT COUNT(1)
FROM cn_pay_groups
WHERE pay_group_id = p_pay_group_id;
SELECT COUNT(1)
FROM cn_pay_groups cnpg,
cn_period_statuses cnps
WHERE cnpg.pay_group_id = p_pay_group_id
AND cnpg.period_set_name = cnps.period_set_name
AND cnpg.period_type = cnps.period_type
AND cnps.period_id = p_pay_period_id
AND cnpg.org_id = cnps.org_id;
SELECT COUNT(1)
FROM cn_payruns
WHERE pay_group_id = p_pay_group_id
AND status <> 'PAID';
SELECT pay_period_id
FROM cn_payruns
WHERE pay_group_id = p_pay_group_id
ORDER BY payrun_id desc ;
SELECT start_date, end_date
FROM cn_period_statuses
WHERE period_id = p_period_id
AND org_id=p_org_id;
G_LAST_UPDATE_DATE DATE := sysdate;
G_LAST_UPDATED_BY NUMBER := fnd_global.user_id;
G_LAST_UPDATE_LOGIN NUMBER := fnd_global.login_id;
SELECT cns.salesrep_id, pvs.vendor_id supplier_id,
pvc.vendor_site_id supplier_site_id,
currency_code
FROM cn_salesreps cns,
cn_payment_worksheets cnpw,
po_vendor_sites pvs,
po_vendor_contacts pvc
WHERE cnpw.payrun_id = p_payrun_id
AND cnpw.org_id=cns.org_id
AND cnpw.salesrep_id = cns.salesrep_id
AND cnpw.quota_id IS NULL
AND cns.source_id = pvc.vendor_contact_id
AND pvc.vendor_site_id = pvs.vendor_site_id
AND cns.type = 'SUPPLIER_CONTACT';
SELECT cns.salesrep_id,cns.currency_code,cns.source_id
FROM cn_salesreps cns,
cn_payment_worksheets cnpw
WHERE cnpw.payrun_id = p_payrun_id
AND cnpw.org_id=cns.org_id
AND cnpw.salesrep_id = cns.salesrep_id
AND cnpw.quota_id IS NULL
AND cns.type = 'SUPPLIER_CONTACT'
AND cns.source_id IS NOT NULL;
SELECT pvs.vendor_id supplier_id,
pvc.vendor_site_id supplier_site_id
FROM
po_vendor_sites pvs,
po_vendor_contacts pvc
WHERE
pvc.vendor_site_id = pvs.vendor_site_id
AND pvc.vendor_contact_id = p_source_id;
SELECT payment_transaction_id,
ROUND(payment_amount,2) payment_amount,
liability_ccid,
expense_ccid
FROM cn_payment_transactions
WHERE payrun_id = p_payrun_id
AND credited_salesrep_id = p_salesrep_id
AND nvl(hold_flag,'N') = 'N';
SELECT pay_date,org_id
FROM cn_payruns
WHERE payrun_id = p_payrun_id;
SELECT currency_code
FROM gl_sets_of_books glsob,
cn_repositories cnr,
cn_payruns cnp
WHERE cnr.set_of_books_id = glsob.set_of_books_id
AND cnr.org_id = cnp.org_id
AND cnp.payrun_id= p_payrun_id;
INSERT INTO ap_invoices_interface
(invoice_id,
org_id,
invoice_num,
invoice_date,
vendor_id,
vendor_site_id,
invoice_amount,
invoice_currency_code,
payment_currency_code,
source,
accts_pay_code_combination_id,
invoice_type_lookup_code,
CREATION_DATE,
CREATED_BY,
LAST_UPDATE_DATE,
LAST_UPDATED_BY,
LAST_UPDATE_LOGIN)
VALUES
(ap_invoices_interface_s.NEXTVAL,
l_org_id,
invoice.payment_transaction_id,
l_pay_date,
l_supplier_id,
l_supplier_site_id,
invoice.payment_amount,
l_functional_currency,
Nvl(salesreps.currency_code, l_functional_currency),
'ORACLE_SALES_COMPENSATION',
invoice.liability_ccid,
l_lookup_type,
G_CREATION_DATE,
G_CREATED_BY,
G_LAST_UPDATE_DATE,
G_LAST_UPDATED_BY,
G_LAST_UPDATE_LOGIN);
INSERT INTO ap_invoice_lines_interface
(invoice_id,
invoice_line_id,
line_number,
amount,
dist_code_combination_id,
line_type_lookup_code,
org_id,
CREATION_DATE,
CREATED_BY,
LAST_UPDATE_DATE,
LAST_UPDATED_BY,
LAST_UPDATE_LOGIN)
VALUES
(ap_invoices_interface_s.CURRVAL,
ap_invoice_lines_interface_s.NEXTVAL,
1,
invoice.payment_amount,
invoice.expense_ccid,
'ITEM',
l_org_id,
G_CREATION_DATE,
G_CREATED_BY,
G_LAST_UPDATE_DATE,
G_LAST_UPDATED_BY,
G_LAST_UPDATE_LOGIN);
SELECT cns.salesrep_id
FROM cn_salesreps cns,
cn_payruns cnr
WHERE
cns.type = 'SUPPLIER_CONTACT'
AND cns.salesrep_id = p_salesrep_id
AND cns.org_id =cnr.org_id
AND cnr.payrun_id=p_payrun_id;
SELECT payment_transaction_id
FROM cn_payment_transactions
WHERE payrun_id = p_payrun_id
AND credited_salesrep_id = p_salesrep_id
AND nvl(paid_flag, 'N') = 'N' -- is null -- Bug 2822874
AND payee_salesrep_id = p_salesrep_id
AND payment_transaction_id = NVL(p_pmt_tran_id, payment_transaction_id) -- Bug 3866089 (the same as 11.5.8 bug 3841926, 11.5.10 3866116) by jjhuang on 11/1/04
AND hold_flag = 'N' ;
SELECT Nvl(payables_flag, 'N')
INTO l_payables_flag
FROM cn_repositories cr,cn_payruns cp
where cp.payrun_id = p_payrun_id
and cp.org_id=cr.org_id;
SELECT user_name
INTO l_user
FROM fnd_user
WHERE user_id = fnd_global.user_id;
G_LAST_UPDATE_DATE DATE := sysdate;
G_LAST_UPDATED_BY NUMBER := fnd_global.user_id;
G_LAST_UPDATE_LOGIN NUMBER := fnd_global.login_id;
x_loading_status := 'CN_INSERTED';
cn_payruns_pkg.insert_record(
x_payrun_id => p_payrun_rec.payrun_id
,x_name => rtrim(ltrim(p_payrun_rec.name))
,x_pay_period_id => p_payrun_rec.pay_period_id
,x_incentive_type_code=> p_payrun_rec.incentive_type_code
,x_pay_group_id => p_payrun_rec.pay_group_id
,x_pay_date => p_payrun_rec.pay_date
,x_accounting_period_id=>p_payrun_rec.accounting_period_id
,x_batch_id =>p_payrun_rec.batch_id
,x_status =>Nvl(p_payrun_rec.status,'UNPAID')
,x_Created_By =>g_created_by
,x_Creation_Date =>g_creation_date
,x_object_version_number =>1,
x_org_id =>p_payrun_rec.org_id,
x_payrun_mode =>l_profile_value
) ;
x_loading_status := 'CN_INSERTED';
PROCEDURE Update_Payrun
( p_api_version IN NUMBER,
p_init_msg_list IN VARCHAR2,
p_commit IN VARCHAR2,
p_validation_level IN NUMBER,
x_return_status OUT NOCOPY VARCHAR2,
x_msg_count OUT NOCOPY NUMBER,
x_msg_data OUT NOCOPY VARCHAR2,
p_payrun_id IN cn_payruns.payrun_id%TYPE,
p_x_obj_ver_number IN OUT NOCOPY cn_payruns.object_version_number%TYPE,
p_action IN VARCHAR2,
x_status OUT NOCOPY VARCHAR2,
x_loading_status OUT NOCOPY VARCHAR2
)
IS
l_api_name CONSTANT VARCHAR2(30) := 'Update_Payrun';
G_LAST_UPDATE_DATE DATE := sysdate;
G_LAST_UPDATED_BY NUMBER := fnd_global.user_id;
G_LAST_UPDATE_LOGIN NUMBER := fnd_global.login_id;
SELECT status, payrun_id,name,object_version_number,
cn_api.get_lkup_meaning(cn_payruns.status,'PAYRUN_STATUS') statusmeaning
FROM cn_payruns
WHERE payrun_id = p_payrun_id;
SELECT payment_worksheet_id
FROM cn_payment_worksheets
WHERE payrun_id = p_payrun_id AND worksheet_status = 'UNPAID'
AND quota_id IS NULL;
SAVEPOINT Update_Payrun;
x_loading_status := 'CN_UPDATED';
ROLLBACK TO Update_Payrun;
ROLLBACK TO Update_Payrun;
ROLLBACK TO Update_Payrun;
END update_payrun;
PROCEDURE Delete_Payrun
( p_api_version IN NUMBER,
p_init_msg_list IN VARCHAR2,
p_commit IN VARCHAR2,
p_validation_level IN NUMBER,
x_return_status OUT NOCOPY VARCHAR2,
x_msg_count OUT NOCOPY NUMBER,
x_msg_data OUT NOCOPY VARCHAR2,
p_payrun_id IN cn_payruns.payrun_id%TYPE,
p_validation_only IN VARCHAR2,
x_status OUT NOCOPY VARCHAR2,
x_loading_status OUT NOCOPY VARCHAR2
) IS
l_api_name CONSTANT VARCHAR2(30)
:= 'Delete_Payrun';
SELECT status, payrun_id,name,org_id
FROM cn_payruns
WHERE payrun_id = p_payrun_id;
select distinct request_id
from fnd_concurrent_requests
where oracle_id = 900 and request_date >= (sysdate -1)
and status_code not in ('C', 'E','D') and argument_text = l_pay_run_name;
SELECT payment_worksheet_id,object_version_number
FROM cn_payment_worksheets
WHERE payrun_id = p_payrun_id
AND quota_id is null;
G_LAST_UPDATE_DATE DATE := sysdate;
G_LAST_UPDATED_BY NUMBER := fnd_global.user_id;
G_LAST_UPDATE_LOGIN NUMBER := fnd_global.login_id;
SAVEPOINT Delete_Payrun;
x_loading_status := 'CN_DELETED';
cn_payment_worksheet_pvt.delete_worksheet(
p_api_version => p_api_version,
p_init_msg_list => p_init_msg_list,
p_commit => fnd_api.g_false,
p_validation_level => p_validation_level,
x_return_status => x_return_status,
x_msg_count => x_msg_count,
x_msg_data => x_msg_data,
p_worksheet_id => worksheets.payment_worksheet_id,
p_validation_only => p_validation_only, --R12
x_status => x_status,
x_loading_status => x_loading_status,
p_ovn =>worksheets.object_version_number);
cn_payruns_pkg.delete_record
(x_payrun_id => p_payrun_id) ;
x_loading_status := 'CN_DELETED';
ROLLBACK TO Delete_Payrun;
ROLLBACK TO Delete_Payrun;
ROLLBACK TO Delete_Payrun;
END Delete_Payrun;
SELECT payment_worksheet_id, salesrep_id
FROM cn_payment_worksheets
WHERE payrun_id = p_payrun_id AND worksheet_status = 'UNPAID'
AND quota_id IS NULL ;
SELECT payment_worksheet_id, salesrep_id
FROM cn_payment_worksheets
WHERE payrun_id = p_payrun_id AND worksheet_status <> 'APPROVED'
AND quota_id IS NULL;
SELECT pay_period_id, pay_date, accounting_period_id, org_id
,name, cn_api.get_lkup_meaning(cn_payruns.status,'PAYRUN_STATUS') statusmeaning
FROM cn_payruns
WHERE payrun_id = p_payrun_id;
SELECT distinct salesrep_id
FROM cn_payment_worksheets
WHERE payrun_id = p_payrun_id
--R12
AND org_id = p_org_id;
SELECT salesrep_id, quota_id, credit_type_id,
pmt_amount_calc, pmt_amount_adj, pmt_amount_adj_rec,
pmt_amount_adj_nrec, pmt_amount_recovery
FROM cn_payment_worksheets
WHERE payrun_id = p_payrun_id
AND salesrep_id = p_salesrep_id
AND quota_id is not null;
SELECT srp_period_id
FROM cn_srp_periods
WHERE salesrep_id = p_salesrep_id
AND credit_type_id = l_credit_type_id
AND period_id = p_period_id
AND (quota_id = p_quota_id
OR
(p_quota_id IS NULL AND quota_id IS NULL))
--R12
AND org_id = p_org_id
AND ROWNUM < 2 ; -- Bug 2819874
SELECT payables_flag, payroll_flag, payables_ccid_level
FROM cn_repositories
--R12
WHERE org_id = p_org_id;
SELECT nvl(sum(nvl(payment_amount,0) - nvl(amount,0)),0) control_payment
FROM cn_payment_transactions
WHERE payrun_id = p_payrun_id
AND credited_salesrep_id = p_salesrep_id
AND credit_type_id = l_credit_type_id
AND (quota_id = p_quota_id
OR
(p_quota_id IS NULL AND quota_id IS NULL))
AND incentive_type_code <> 'PMTPLN_REC'
AND nvl(hold_flag, 'N') = 'N';
SELECT nvl(sum(nvl(amount,0)),0) hold_payment
FROM cn_payment_transactions
WHERE payrun_id = p_payrun_id
AND credited_salesrep_id = p_salesrep_id
AND credit_type_id = l_credit_type_id
AND (quota_id = p_quota_id
OR
(p_quota_id IS NULL AND quota_id IS NULL))
AND incentive_type_code <> 'PMTPLN_REC'
AND nvl(hold_flag, 'N') = 'Y';
SELECT nvl(sum(nvl(amount,0)),0) man_pay_adj, recoverable_flag
FROM cn_payment_transactions
WHERE payrun_id = p_payrun_id
AND credited_salesrep_id = p_salesrep_id
AND credit_type_id = l_credit_type_id
AND quota_id = p_quota_id
AND incentive_type_code = 'MANUAL_PAY_ADJ'
GROUP BY recoverable_flag;
SELECT nvl(pmt_amount_calc,0),
nvl(pmt_amount_adj_rec,0),
nvl(pmt_amount_adj_nrec,0),
-nvl(pmt_amount_recovery,0)
FROM cn_payment_worksheets
WHERE payrun_id = p_payrun_id
AND salesrep_id = p_salesrep_id
AND credit_type_id = l_credit_type_id
AND (quota_id = p_quota_id
OR
(p_quota_id IS NULL AND quota_id IS NULL));
SELECT -nvl(sum(nvl(payment_amount,0)),0)
FROM cn_payment_transactions
WHERE payrun_id = p_payrun_id
AND credited_salesrep_id = p_salesrep_id
AND credit_type_id = l_credit_type_id
AND incentive_type_code = 'PMTPLN_REC'
AND nvl(hold_flag, 'N') = 'N'
AND waive_flag = 'Y'
AND (quota_id = p_quota_id
OR
(p_quota_id IS NULL AND quota_id IS NULL))
--R12
AND org_id = p_org_id;
SELECT sprd.srp_period_id
FROM cn_srp_periods sprd
WHERE
sprd.salesrep_id = c_salesrep_id
AND sprd.period_id = c_period_id
AND sprd.quota_id = -1000
AND sprd.credit_type_id = -1000
--R12
AND org_id = p_org_id;
SELECT DISTINCT sprd.role_id
FROM cn_srp_periods sprd
WHERE
sprd.salesrep_id = c_salesrep_id
AND sprd.period_id = c_period_id
AND sprd.credit_type_id = -1000
--R12
AND org_id = p_org_id;
G_LAST_UPDATE_DATE DATE := sysdate;
G_LAST_UPDATED_BY NUMBER := fnd_global.user_id;
G_LAST_UPDATE_LOGIN NUMBER := fnd_global.login_id;
x_loading_status := 'CN_UPDATED';
UPDATE cn_payment_transactions
SET payrun_id = '',
LAST_UPDATE_DATE = Sysdate,
LAST_UPDATED_BY = G_LAST_UPDATED_BY,
LAST_UPDATE_LOGIN = G_LAST_UPDATE_LOGIN
WHERE payrun_id = p_payrun_id
AND hold_flag = 'Y'
--R12
AND org_id = l_payrun_rec.org_id;
UPDATE cn_payment_transactions
SET paid_flag = 'Y',
LAST_UPDATE_DATE = Sysdate,
LAST_UPDATED_BY = G_LAST_UPDATED_BY,
LAST_UPDATE_LOGIN = G_LAST_UPDATE_LOGIN
WHERE payrun_id = p_payrun_id
--R12
AND org_id = l_payrun_rec.org_id;
l_batch_rec.last_updated_by := fnd_global.user_id;
l_batch_rec.last_update_date := sysdate;
l_batch_rec.last_update_login:= fnd_global.login_id;
(x_operation => 'INSERT',
x_rowid => l_rowid,
x_posting_batch_rec => l_batch_rec,
x_program_type => null,
p_org_id => l_payrun_rec.org_id);
cn_srp_periods_pvt.Update_Delta_Srp_Pds_No_Sync
(p_api_version => 1.0,
x_return_status => x_return_status,
x_msg_count => x_msg_count,
x_msg_data => x_msg_data,
p_del_srp_prd_rec => l_srp_prd_rec,
x_loading_status => l_loading_status);
cn_srp_periods_pvt.Update_Delta_Srp_Pds_No_Sync
(p_api_version => 1.0,
x_return_status => x_return_status,
x_msg_count => x_msg_count,
x_msg_data => x_msg_data,
p_del_srp_prd_rec => l_srp_prd_rec,
x_loading_status => l_loading_status);
cn_pmt_trans_pkg.insert_record(l_pmt_trx_rec);
x_loading_status := 'CN_UPDATED';
PROCEDURE delete_payrun_conc
( errbuf OUT NOCOPY VARCHAR2,
retcode OUT NOCOPY NUMBER ,
p_name cn_payruns.name%TYPE,
--R12
p_org_name hr_operating_units.name%TYPE) IS
l_proc_audit_id NUMBER;
select cp.payrun_id , cp.org_id,cp.OBJECT_VERSION_NUMBER
from cn_payruns cp,
--R12
hr_operating_units hou
where cp.name = p_name
and cp.org_id = hou.organization_id
and hou.name = p_org_name;
cn_message_pkg.debug('Delete Payrun');
CN_Payrun_PVT.delete_payrun
(p_api_version => 1.0,
p_init_msg_list => fnd_api.g_true,
p_commit => fnd_api.g_false,
p_validation_level => fnd_api.g_valid_level_full,
x_return_status => l_return_status,
x_msg_count => l_msg_count,
x_msg_data => l_msg_data,
p_payrun_id => l_payrun_id,
p_validation_only => 'N',
x_status => l_status,
x_loading_status => l_loading_status );
cn_message_pkg.debug('Error for delete payrun : '||errbuf);
END delete_payrun_conc;