[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
fnd_msg_pub.delete_msg(l_msg_index);
fnd_msg_pub.delete_msg(l_msg_index);
l_params.delete();
* PROCEDURE update_status_error
* ----------------------------------------------------
* Update status to error.
* ---------------------------------------------------*/
PROCEDURE update_status_error (
itemtype IN varchar2,
itemkey IN varchar2,
actid IN number,
funcmode IN varchar2,
resultout IN OUT NOCOPY varchar2)
IS
l_trx_id number;
fun_trx_pvt.update_trx_status
(p_api_version => 1.0,
x_return_status => l_status,
x_msg_count => l_msg_count,
x_msg_data => l_msg_data,
p_trx_id => l_trx_id,
p_update_status_to => 'ERROR');
wf_core.context('FUN_RECIPIENT_WF', 'UPDATE_STATUS_ERROR',
itemtype, itemkey, TO_CHAR(actid), funcmode);
END update_status_error;
* PROCEDURE update_status_received
* ----------------------------------------------------
* Update status to received.
* ---------------------------------------------------*/
PROCEDURE update_status_received (
itemtype IN varchar2,
itemkey IN varchar2,
actid IN number,
funcmode IN varchar2,
resultout IN OUT NOCOPY varchar2)
IS
l_trx_id number;
fun_trx_pvt.update_trx_status
(p_api_version => 1.0,
x_return_status => l_status,
x_msg_count => l_msg_count,
x_msg_data => l_msg_data,
p_trx_id => l_trx_id,
p_update_status_to => 'RECEIVED');
wf_core.context('FUN_RECIPIENT_WF', 'UPDATE_STATUS_RECEIVED',
itemtype, itemkey, TO_CHAR(actid), funcmode);
END update_status_received;
* PROCEDURE update_status_complete
* ----------------------------------------------------
* Update status to complete.
* ---------------------------------------------------*/
PROCEDURE update_status_complete (
itemtype IN varchar2,
itemkey IN varchar2,
actid IN number,
funcmode IN varchar2,
resultout IN OUT NOCOPY varchar2)
IS
l_trx_id number;
fun_trx_pvt.update_trx_status
(p_api_version => 1.0,
x_return_status => l_status,
x_msg_count => l_msg_count,
x_msg_data => l_msg_data,
p_trx_id => l_trx_id,
p_update_status_to => 'COMPLETE');
wf_core.context('FUN_WF_COMMON', 'UPDATE_STATUS_COMPLETE',
itemtype, itemkey, TO_CHAR(actid), funcmode);
END update_status_complete;
SELECT trx_id
FROM fun_trx_headers
WHERE batch_id = p_batch_id;
select USERENV('LANG')
INTO l_user_env_lang
FROM DUAL;
SELECT 'Y'
FROM wf_local_roles
WHERE name = p_role_name;
SELECT hzp.party_name
FROM hz_parties hzp,
fun_trx_headers trx
WHERE hzp.party_id = DECODE(p_contact_type,'I',trx.initiator_id,
trx.recipient_id)
AND trx.trx_id = p_transaction_id;
ame_api2.updateApprovalStatus(
applicationIdIn => 435,
transactionTypeIn => l_transaction_type,
transactionIdIn => p_transaction_id,
approverIn => l_invalid_usr_rec);
SELECT 'X'
FROM fnd_user usr,
WF_USER_ROLE_ASSIGNMENTS role
WHERE usr.user_id = p_user_id
AND usr.user_name = role.user_name
AND role.role_name = 'FUN_ADHOC_RECI_'||p_transaction_id;
SELECT 'X'
FROM hz_parties p,
fnd_user fu,
fun_trx_headers ftrx,
hz_relationships hzr,
hz_org_contacts hc,
hz_org_contact_roles hcr
WHERE p.party_type = 'PERSON'
AND p.party_id = hzr.subject_id
AND hzr.object_id = ftrx.recipient_id
AND hzr.relationship_code = 'CONTACT_OF'
AND hzr.relationship_type = 'CONTACT'
AND hzr.directional_flag = 'F'
AND hzr.subject_table_name = 'HZ_PARTIES'
AND hzr.object_table_name = 'HZ_PARTIES'
AND hzr.subject_type = 'PERSON'
AND hc.party_relationship_id = hzr.relationship_id
AND hcr.org_contact_id = hc.org_contact_id
AND hcr.role_type = 'INTERCOMPANY_CONTACT_FOR'
AND fu.person_party_id = p.party_id
AND sysdate BETWEEN
nvl(hzr.start_date, sysdate -1)
AND nvl(hzr.end_date, sysdate + 1)
AND ftrx.trx_id = p_transaction_id;
SELECT 'X'
FROM fun_trx_headers trx,
hz_relationships rel,
fnd_user wf,
hz_org_contacts c,
hz_org_contact_roles cr
WHERE wf.user_name = p_role_name
AND wf.person_party_id = rel.subject_id
AND trx.trx_id = p_transaction_id
AND rel.object_id = DECODE(p_org_type, 'R',trx.recipient_id,
'I',trx.initiator_id)
AND rel.relationship_code = 'CONTACT_OF'
AND rel.relationship_type = 'CONTACT'
AND rel.directional_flag = 'F'
AND rel.subject_table_name = 'HZ_PARTIES'
AND rel.object_table_name = 'HZ_PARTIES'
AND rel.subject_type = 'PERSON'
AND SYSDATE BETWEEN NVL(rel.start_date, SYSDATE -1)
AND NVL(rel.end_date, SYSDATE + 1)
AND c.party_relationship_id = rel.relationship_id
AND cr.org_contact_id = c.org_contact_id
AND cr.role_type = 'INTERCOMPANY_CONTACT_FOR';
SELECT trx_id,
recipient_id,
to_le_id
FROM fun_trx_headers
WHERE batch_id = p_batch_id;
SELECT b.initiator_id,
b.from_le_id,
Nvl(t.allow_invoicing_flag, 'N')
INTO l_initiator_id,
l_ini_le_id,
l_trx_invoice_flag
FROM fun_trx_batches b,
fun_trx_types_vl t
WHERE b.batch_id = p_batch_id
AND b.trx_type_id = t.trx_type_id;
UPDATE fun_trx_headers
SET invoice_flag = 'Y'
WHERE batch_id = p_batch_id;
UPDATE fun_trx_headers
SET invoice_flag = 'Y'
WHERE trx_id = l_trx_rec.trx_id;
UPDATE fun_trx_headers
SET invoice_flag = 'N'
WHERE trx_id = l_trx_rec.trx_id;
UPDATE fun_trx_headers
SET invoice_flag = 'Y'
WHERE batch_id = p_batch_id;
select distinct item_type,item_key
from WF_ITEM_ACTIVITY_STATUSES
where item_type in ('FUNRMAIN','FUNIMAIN','FUNRTVAL','FUNMSYST')
and item_key like to_char(p_batch_id)||'%'
and activity_status in( 'ACTIVE');
select distinct item_type,item_key
from WF_ITEM_ACTIVITY_STATUSES
where item_type in ('FUNRMAIN','FUNIMAIN','FUNRTVAL','FUNMSYST')
and item_key like to_char(p_batch_id)||'_'||to_char(p_trx_id)||'%'
and activity_status in( 'ACTIVE');
select distinct item_type,item_key
from WF_ITEM_ACTIVITY_STATUSES
where item_type = p_item_type
and item_key like to_char(p_batch_id)||'_'||to_char(p_trx_id)||'%'
and activity_status in('ACTIVE');