[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
select PSIG_STATUS into p_status
from edr_psig_documents
where EVENT_NAME=p_event
and EVENT_KEY=p_event_key
and PSIG_TIMESTAMP =
(select MAX(PSIG_TIMESTAMP)
from edr_psig_documents
where EVENT_NAME=p_event
and EVENT_KEY=p_event_key
and rownum < 2);
select b.guid,A.status,b.status
from
wf_events a, wf_event_subscriptions b
where a.GUID = b.EVENT_FILTER_GUID
and a.name = p_event
and b.RULE_FUNCTION='EDR_PSIG_RULE.PSIG_RULE'
and b.STATUS = 'ENABLED'
--Bug No 4912782- Start
and b.source_type = 'LOCAL'
and b.system_guid = hextoraw(wf_core.translate('WF_SYSTEM_GUID')) ;
select count(*) INTO l_no_enabled_eres_sub
from
wf_events a, wf_event_subscriptions b
where a.GUID = b.EVENT_FILTER_GUID
and a.name = p_event
and b.RULE_FUNCTION='EDR_PSIG_RULE.PSIG_RULE'
and b.STATUS = 'ENABLED'
--Bug No 4912782- Start
and b.source_type = 'LOCAL'
and b.system_guid = hextoraw(wf_core.translate('WF_SYSTEM_GUID')) ;
/* Select APPLICATION_ID of the Event. This is required by AME. Assumption made here
is OWNER_TAG will always be set to application Short Name*/
SELECT application_id,APPLICATION_SHORT_NAME into l_application_id,l_application_code
FROM FND_APPLICATION
WHERE APPLICATION_SHORT_NAME in (SELECT OWNER_TAG from WF_EVENTS
WHERE NAME=evt.getEventName( ));
select application_name into l_application_name
from ame_Calling_Apps
where
FND_APPLICATION_ID=l_application_id and
TRANSACTION_TYPE_ID=NVL(l_ame_transaction_type,evt.getEventName( ))
--Bug 4652277: Start
--and end_Date is null;
select b.guid,A.status,b.status
from
wf_events a, wf_event_subscriptions b
where a.GUID = b.EVENT_FILTER_GUID
and a.name = p_event
and b.RULE_FUNCTION='EDR_PSIG_RULE.PSIG_RULE'
and b.STATUS = 'ENABLED'
--Bug No 4912782- Start
and b.source_type = 'LOCAL'
and b.system_guid = hextoraw(wf_core.translate('WF_SYSTEM_GUID')) ;
select count(*) into l_no_enabled_eres_sub
from
wf_events a, wf_event_subscriptions b
where a.GUID = b.EVENT_FILTER_GUID
and a.name = p_event
and b.RULE_FUNCTION='EDR_PSIG_RULE.PSIG_RULE'
and b.STATUS = 'ENABLED'
--Bug No 4912782- Start
and b.source_type = 'LOCAL'
and b.system_guid = hextoraw(wf_core.translate('WF_SYSTEM_GUID')) ;
/* Select APPLICATION_ID of the Event. This is required by AME. Assumption made here
is OWNER_TAG will always be set to application Short Name*/
SELECT application_id,APPLICATION_SHORT_NAME into l_application_id,l_application_code
FROM FND_APPLICATION
WHERE APPLICATION_SHORT_NAME in (SELECT OWNER_TAG from WF_EVENTS
WHERE NAME=evt.getEventName( ));
select application_name into l_application_name
from ame_Calling_Apps
where
FND_APPLICATION_ID=l_application_id and
TRANSACTION_TYPE_ID=NVL(l_ame_transaction_type,evt.getEventName( ))
--Bug 4652277: Start
--and end_Date is null;
l_sql:='select document_id from edr_psig_documents where ' || l_where_clause || ' )' ;
select EDR_TRANS_QUERY_TEMP_S.nextval into l_query_id from dual;
insert into EDR_TRANS_QUERY_TEMP(QUERY_ID,
DOCUMENT_ID,
CREATION_DATE,
CREATED_BY,
LAST_UPDATE_DATE,
LAST_UPDATED_BY,
LAST_UPDATE_LOGIN
)
VALUES
(l_query_id,
l_document_id,
sysdate,
fnd_global.user_id,
sysdate,
fnd_global.user_id,
fnd_global.login_id
);
SELECT INPUT_NAME, DEFAULT_VALUE from EDR_AMETRAN_INPUT_VAR
where AME_TRANS_ID = the_trans_id;
SELECT INPUT_NAME, INPUT_VALUE
from EDR_AMERULE_INPUT_VAR
where AME_TRANS_NAME in
( select distinct application_name from ame_calling_apps where transaction_type_id = the_trans_id)
AND RULE_ID=ameruleid;
Select distinct transaction_type_id FROM ame_calling_apps
WHERE application_name = ameapplication
--Bug 4652277: Start
--AND end_date is null;
SELECT INPUT_NAME, DEFAULT_VALUE from EDR_AMETRAN_INPUT_VAR
where AME_TRANS_ID = the_trans_id;
SELECT INPUT_NAME, INPUT_VALUE from EDR_AMERULE_INPUT_VAR where AME_TRANS_ID = the_trans_id
AND RULE_ID=ameruleid;
SELECT status into l_trigger_status
FROM user_triggers
WHERE trigger_name=P_TABLE_NAME||'_AU';
sql_stmt := 'SELECT :1 FROM :2 WHERE :3 = :4';
EXECUTE IMMEDIATE 'select ' ||P_COLUMN||' from '||P_TABLE_NAME ||' where '||P_PKNAME||'='||P_PKVALUE ||' '
INTO p_current_value;
EXECUTE IMMEDIATE 'select '||P_COLUMN||' from '||L_TABLE_NAME||' where '||P_PKNAME||'='||P_PKVALUE ||' and '||
'AUDIT_SESSION_ID=USERENV('||''''||'SESSIONID'||''''||') and '||
'AUDIT_TIMESTAMP in (SELECT max(AUDIT_TIMESTAMP) from '||L_TABLE_NAME||' where '||P_PKNAME||'='||P_PKVALUE ||' and '||
'AUDIT_SESSION_ID=USERENV('||''''||'SESSIONID'||''''||')) and '||
'AUDIT_TRANSACTION_TYPE='||''''||'U'||'''' INTO p_old_value;
select WRR.ACTION, WRR.ACTION_ARGUMENT, WRR.RULE_COMMENT
from WF_ROUTING_RULES WRR
where WRR.ROLE =L_ORIGINAL_RECIPIENT
and sysdate between nvl(WRR.BEGIN_DATE, sysdate-1) and
nvl(WRR.END_DATE, sysdate+1)
and nvl(WRR.MESSAGE_TYPE, nvl(P_MESSAGE_TYPE,0)) = nvl(P_MESSAGE_TYPE,0)
and nvl(WRR.MESSAGE_NAME, nvl(P_MESSAGE_NAME,0)) = nvl(P_MESSAGE_NAME,0)
order by WRR.MESSAGE_TYPE, WRR.MESSAGE_NAME;
SELECT FORM_LEFT_PROMPT, FORM_ABOVE_PROMPT
FROM FND_DESCR_FLEX_COL_USAGE_VL
WHERE APPLICATION_ID = P_APPLICATION_ID
and DESCRIPTIVE_FLEXFIELD_NAME = P_DESC_FLEX_DEF_NAME
and DESCRIPTIVE_FLEX_CONTEXT_CODE = P_DESC_FLEX_CONTEXT
and APPLICATION_COLUMN_NAME = P_COLUMN_NAME;
SELECT col_vl.APPLICATION_COLUMN_NAME,
col_vl.FORM_LEFT_PROMPT,
col_vl.FORM_ABOVE_PROMPT
FROM FND_DESCR_FLEX_COL_USAGE_VL col_vl,fnd_descr_flex_contexts ctx
WHERE col_vl.APPLICATION_ID = P_APPLICATION_ID
and col_vl.DESCRIPTIVE_FLEXFIELD_NAME = P_DESC_FLEX_DEF_NAME
and col_vl.APPLICATION_ID = ctx.APPLICATION_ID
and col_vl.DESCRIPTIVE_FLEXFIELD_NAME = ctx.DESCRIPTIVE_FLEXFIELD_NAME
and col_vl.DESCRIPTIVE_FLEX_CONTEXT_CODE <> NVL(P_DESC_FLEX_CONTEXT,' ')
and col_vl.DESCRIPTIVE_FLEX_CONTEXT_CODE = ctx.DESCRIPTIVE_FLEX_CONTEXT_CODE
and ctx.GLOBAL_FLAG = 'Y'
UNION ALL
SELECT APPLICATION_COLUMN_NAME,
FORM_LEFT_PROMPT,
FORM_ABOVE_PROMPT
FROM FND_DESCR_FLEX_COL_USAGE_VL
WHERE APPLICATION_ID = P_APPLICATION_ID
and DESCRIPTIVE_FLEXFIELD_NAME = P_DESC_FLEX_DEF_NAME
and DESCRIPTIVE_FLEX_CONTEXT_CODE = NVL(P_DESC_FLEX_CONTEXT,' ');
select count(*) INTO l_attrrcount from (
SELECT col_vl.APPLICATION_COLUMN_NAME
FROM FND_DESCR_FLEX_COL_USAGE_VL col_vl,fnd_descr_flex_contexts ctx
WHERE col_vl.APPLICATION_ID = P_APPLICATION_ID
and col_vl.DESCRIPTIVE_FLEXFIELD_NAME = P_DESC_FLEX_DEF_NAME
and col_vl.APPLICATION_ID = ctx.APPLICATION_ID
and col_vl.DESCRIPTIVE_FLEXFIELD_NAME = ctx.DESCRIPTIVE_FLEXFIELD_NAME
and col_vl.DESCRIPTIVE_FLEX_CONTEXT_CODE <> NVL(P_DESC_FLEX_CONTEXT,' ')
and col_vl.DESCRIPTIVE_FLEX_CONTEXT_CODE = ctx.DESCRIPTIVE_FLEX_CONTEXT_CODE
and ctx.GLOBAL_FLAG = 'Y'
UNION ALL
SELECT APPLICATION_COLUMN_NAME
FROM FND_DESCR_FLEX_COL_USAGE_VL
WHERE APPLICATION_ID = P_APPLICATION_ID
and DESCRIPTIVE_FLEXFIELD_NAME = P_DESC_FLEX_DEF_NAME
and DESCRIPTIVE_FLEX_CONTEXT_CODE = NVL(P_DESC_FLEX_CONTEXT,' '));
SELECT MEANING
FROM FND_LOOKUPS
WHERE LOOKUP_TYPE = P_LOOKUP_TYPE
AND LOOKUP_CODE = P_LOOKUP_CODE;
SELECT MEANING
FROM FND_LOOKUPS
WHERE LOOKUP_TYPE = P_LOOKUP_TYPE
AND LOOKUP_CODE = L_LOOKUP_CODE;