The following lines contain the word 'select', 'insert', 'update' or 'delete':
PROCEDURE insert_sec_hold
( p_InvoiceId NUMBER
, p_LastUpdatedBy NUMBER
) IS
v_org_id number(15,0);
select org_id
into v_org_id
from ap_invoices
where invoice_id = p_InvoiceId;
INSERT INTO AP_HOLDS
( INVOICE_ID
, HOLD_LOOKUP_CODE
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, HELD_BY
, HOLD_DATE
, HOLD_REASON
, CREATION_DATE
, CREATED_BY
, HOLD_ID /* added for bug # 5905278 R12 Uptake of SIA */
, ORG_ID /* added for bug # 5905278 R12 Uptake of SIA */
)
SELECT
p_InvoiceId
, 'AWAIT_SEC_APP'
, sysdate
, p_LastUpdatedBy
, p_LastUpdatedBy
, sysdate
, p_return_message
, sysdate
, p_LastUpdatedBy
, AP_HOLDS_S.nextval /* added for bug # 5905278 R12 Uptake of SIA */
, v_org_id /* added for bug # 5905278 R12 Uptake of SIA */
FROM sys.dual
WHERE NOT EXISTS ( SELECT 1
FROM ap_holds_all
WHERE invoice_id = p_InvoiceId
AND hold_lookup_code in ( 'AWAIT_SEC_APP',
'AWAIT_PAY_APP')
AND release_lookup_code is NULL
);
, p_LastUpdatedBy NUMBER
) IS
--
BEGIN
UPDATE AP_HOLDS
SET RELEASE_LOOKUP_CODE = 'MOD_RELEASE'
, RELEASE_REASON = 'Invoice Modified'
, LAST_UPDATE_DATE = sysdate
, LAST_UPDATED_BY = p_LastUpdatedBy
WHERE invoice_id = p_InvoiceId
AND hold_lookup_code IN
('AWAIT_SEC_APP', 'AWAIT_PAY_APP')
AND release_lookup_code is null;
l_UpdatedByTable(l_TableRow) := p_upd_by;
Select 1
From AP_INVOICE_DISTRIBUTIONS_ALL
Where Invoice_id = p_inv_id
AND NVL(match_status_flag,'N') <> 'A';
Select hold_lookup_code
From AP_HOLDS
Where invoice_id = p_inv_id
And hold_lookup_code = p_hold
And release_lookup_code is null;
Select sum(nvl(amount,0))
From AP_INVOICE_DISTRIBUTIONS_ALL
Where Invoice_id = p_inv_id;
Select hold_lookup_code
From AP_HOLDS
Where invoice_id = p_inv_id
And hold_lookup_code = 'AWAIT_PAY_APP';
Select COUNT(1)
From AP_INVOICE_DISTRIBUTIONS_ALL
Where Invoice_id = p_inv_id
and reversal_flag = 'Y';
Select COUNT(1)
From AP_HOLDS
Where invoice_id = p_inv_id
And hold_lookup_code <> 'AWAIT_SEC_APP'
And Release_Lookup_code is Null;
insert_sec_hold(p_inv_id,p_upd_by);
insert_sec_hold(p_inv_id,p_upd_by);
insert_sec_hold(p_inv_id,p_upd_by);
Select hold_lookup_code
From AP_HOLDS
Where invoice_id = p_inv_id
And hold_lookup_code = 'AWAIT_PAY_APP';
Select hold_lookup_code
From AP_HOLDS
Where invoice_id = p_inv_id
And hold_lookup_code = 'AWAIT_SEC_APP'
AND release_lookup_code = 'SEC_APP';
insert_sec_hold(p_inv_id,p_upd_by);
insert_sec_hold(p_inv_id,p_upd_by);
, l_UpdatedByTable(l_Var)
);
, l_UpdatedByTable(l_Var)
);