[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
select user_action_type_name
into actionTypeName
from ame_action_types_vl
where action_type_id = actionTypeIdIn
and sysdate between start_date
and nvl(end_date - ame_util.oneSecond, sysdate);
select user_approval_group_name
into actionTypeName
from ame_approval_groups_vl
where approval_group_id = groupIdIn
and sysdate between start_date and nvl(end_date - ame_util.oneSecond, sysdate);
select meaning
into approvalCategoryDesc
from fnd_lookups fl
where fl.lookup_type = 'AME_APPROVER_CATEGORY'
and fl.enabled_flag = 'Y'
and fl.lookup_code = categoryIn
and trunc(sysdate) between start_date_active
and nvl(end_date_active, trunc(sysdate));
select meaning
into authorityDesc
from fnd_lookups fl
where fl.lookup_type = 'AME_SUBLIST_TYPES'
and fl.enabled_flag = 'Y'
and fl.lookup_code = authorityIn
and trunc(sysdate) between start_date_active
and nvl(end_date_active, trunc(sysdate));
function getApiInsertionDesc(apiInsertionIn in varchar2) return varchar2 as
apiInsertionDesc fnd_lookups.meaning%type;
return apiInsertionIn;
routineNameIn => 'getApiInsertionDesc',
exceptionNumberIn => sqlcode,
exceptionStringIn => sqlerrm);
return apiInsertionIn;
end getApiInsertionDesc;
select meaning
into origSystemDesc
from fnd_lookups fl
where fl.lookup_type = 'FND_WF_ORIG_SYSTEMS'
and fl.lookup_code = origSystemIn
and trunc(sysdate) between start_date_active
and nvl(end_date_active, trunc(sysdate));
select meaning
into ruleTypeDesc
from fnd_lookups fl
where fl.lookup_type = 'AME_RULE_TYPE'
and fl.enabled_flag = 'Y'
and fl.lookup_code = ruleTypeIn
and trunc(sysdate) between start_date_active
and nvl(end_date_active, trunc(sysdate));
select rule_type
into ruleTypeCode
from ame_rules
where rule_id = ruleIdIn
and effectiveDateIn between start_date
and nvl(end_date - ame_util.oneSecond, sysdate);
select approver_category
into categoryCode
from ame_rule_usages
where rule_id = ruleIdIn
and item_id = applicationIdIn
and effectiveDateIn between start_date
and nvl(end_date - ame_util.oneSecond, sysdate);
select condition_id
from ame_condition_usages
where rule_id = ruleIdIn
and effectiveDateIn between start_date
and nvl(end_date - ame_util.oneSecond, sysdate);
select user_item_class_name
into itemName
from ame_item_classes_vl
where item_class_id = itemClassIdIn and
sysdate between start_date and
nvl(end_date - ame_util.oneSecond, sysdate) ;
select user_item_class_name
into itemName
from ame_item_classes_vl
where trim(name) = trim(itemClassNameIn) and
sysdate between start_date and
nvl(end_date - ame_util.oneSecond, sysdate) ;
select action_id
from ame_action_usages
where rule_id = ruleIdIn
and effectiveDateIn between start_date
and nvl(end_date - ame_util.oneSecond, sysdate);
select description
into ruleDesc
from ame_rules_vl
where rule_id = ruleIdIn
and effectiveRuleDate between start_date
and nvl(end_date - ame_util.oneSecond, sysdate);
select count(1)
into atrCount
from ame_attributes,
ame_attribute_usages
where ame_attribute_usages.attribute_id = ame_attributes.attribute_id
and ame_attribute_usages.application_id = applicationIdIn
and ame_attributes.item_class_id = itemClassIdIn
and sysdate between ame_attribute_usages.start_date and
nvl(ame_attribute_usages.end_date - ame_util.oneSecond,sysdate)
and sysdate between ame_attributes.start_date and
nvl(ame_attributes.end_date - ame_util.oneSecond,sysdate);
select
ame_attributes.attribute_id,
ame_attributes.name,
ame_attributes.attribute_type,
ame_attributes.approver_type_id
from
ame_attributes,
ame_attribute_usages,
ame_item_classes
where
ame_attributes.attribute_id = ame_attribute_usages.attribute_id and
ame_attributes.item_class_id = ame_item_classes.item_class_id and
ame_item_classes.item_class_id = headerItemClassIdIn and
ame_attribute_usages.application_id = applicationIdIn and
nvl(ame_attributes.line_item, ame_util.booleanFalse) = ame_util.booleanFalse and
ame_attributes.attribute_id not in
(select attribute_id from ame_mandatory_attributes
where action_type_id = -1 and
sysdate between ame_mandatory_attributes.start_date and
nvl(ame_mandatory_attributes.end_date - ame_util.oneSecond, sysdate) ) and
sysdate between ame_attributes.start_date and
nvl(ame_attributes.end_date - ame_util.oneSecond, sysdate) and
sysdate between ame_attribute_usages.start_date and
nvl(ame_attribute_usages.end_date - ame_util.oneSecond, sysdate) and
sysdate between ame_item_classes.start_date and
nvl(ame_item_classes.end_date - ame_util.oneSecond, sysdate)
order by ame_attributes.name;
select atr.attribute_id
,atr.name
,atr.attribute_type
,atr.approver_type_id
from ame_attributes atr
,ame_attribute_usages atu
where atr.name in (ame_util.jobLevelStartingPointAttribute
,ame_util.nonDefStartingPointPosAttr
,ame_util.nonDefPosStructureAttr
,ame_util.supStartingPointAttribute
,ame_util.firstStartingPointAttribute
,ame_util.secondStartingPointAttribute
)
and atr.attribute_id = atu.attribute_id
and atu.application_id = applicationIdIn
and sysdate between atr.start_date and nvl(atr.end_date - (1/86400), sysdate)
and sysdate between atu.start_date and nvl(atu.end_date - (1/86400), sysdate);
ame_engine.updateTransactionState(isTestTransactionIn => false
,isLocalTransactionIn => true
,fetchConfigVarsIn => true
,fetchOldApproversIn => false
,fetchInsertionsIn => false
,fetchDeletionsIn => false
,fetchAttributeValuesIn => true
,fetchInactiveAttValuesIn => true
,processProductionActionsIn => false
,processProductionRulesIn => false
,updateCurrentApproverListIn => false
,updateOldApproverListIn => false
,processPrioritiesIn => false
,prepareItemDataIn => false
,prepareRuleIdsIn => false
,prepareRuleDescsIn => false
,transactionIdIn => transactionIdIn
,ameApplicationIdIn => applicationIdIn
,fndApplicationIdIn => null
,transactionTypeIdIn => null);
delete from ame_temp_trans_att_values
where application_id = applicationIdIn
and transaction_id = transactionIdIn;
insert into ame_temp_trans_att_values(application_id
,transaction_id
,row_timestamp
,attribute_id
,attribute_name
,attribute_type
,is_mandatory
,attribute_value_1
,attribute_value_2
,attribute_value_3
,item_id
,item_class_id)
values(applicationIdIn
,transactionIdIn
,sysdate
,attributeIds(i)
,attributeNames(i)
,attributeTypes(i)
,'Y'
,attributeValue1
,attributeValue2
,attributeValue3
,transactionIdIn
,1);
insert into ame_temp_trans_att_values(application_id
,transaction_id
,row_timestamp
,attribute_id
,attribute_name
,attribute_type
,is_mandatory
,attribute_value_1
,attribute_value_2
,attribute_value_3
,item_id
,item_class_id)
values(applicationIdIn
,transactionIdIn
,sysdate
,attributeIds(i)
,attributeNames(i)
,attributeTypes(i)
,'N'
,attributeValue1
,attributeValue2
,attributeValue3
,transactionIdIn
,1);
insert into ame_temp_trans_att_values(application_id
,transaction_id
,row_timestamp
,attribute_id
,attribute_name
,attribute_type
,is_mandatory
,attribute_value_1
,attribute_value_2
,attribute_value_3
,item_id
,item_class_id)
values(applicationIdIn
,transactionIdIn
,sysdate
,attributeIds2(k)
,attributeNames(k)
,attributeTypes(k)
,'N'
,attributeValue1
,attributeValue2
,attributeValue3
,itemIds(j)
,itemClassIdsList(i));
insert into ame_temp_trans_att_values(application_id
,transaction_id
,row_timestamp
,attribute_id
,attribute_name
,attribute_type
,is_mandatory
,attribute_value_1
,attribute_value_2
,attribute_value_3
,item_id
,item_class_id)
values(applicationIdIn
,transactionIdIn
,sysdate
,variantAttributeIds(k)
,variantAttributeNames(k)
,variantAttributeTypes(k)
,'N'
,attributeValue1
,attributeValue2
,attributeValue3
,itemIds(j)
,itemClassIdsList(i));
delete from ame_temp_trans_att_values
where application_id = applicationIdIn
and transaction_id = transactionIdIn;
ame_engine.updateTransactionState(isTestTransactionIn => isRealTransaction = 'N'
,isLocalTransactionIn => true
,fetchConfigVarsIn => true
,fetchOldApproversIn => false
,fetchInsertionsIn => false
,fetchDeletionsIn => false
,fetchAttributeValuesIn => true
,fetchInactiveAttValuesIn => false
,processProductionActionsIn => false
,processProductionRulesIn => true
,updateCurrentApproverListIn => false
,updateOldApproverListIn => false
,processPrioritiesIn => processPriorities = 'Y'
,prepareItemDataIn => false
,prepareRuleIdsIn => false
,prepareRuleDescsIn => false
,transactionIdIn => transactionIdIn
,ameApplicationIdIn => applicationIdIn
,fndApplicationIdIn => null
,transactionTypeIdIn => null);
,approverList(i).api_insertion
,approverList(i).authority
,approverList(i).approval_status
,approverList(i).action_type_id
,approverList(i).group_or_chain_id
,approverList(i).occurrence
,approverSource
,getItemClassName(approverList(i).item_class)
,approverList(i).item_id
,approverList(i).item_class_order_number
,approverList(i).item_order_number
,approverList(i).sub_list_order_number
,approverList(i).action_type_order_number
,approverList(i).group_or_chain_order_number
,approverList(i).member_order_number
,approverList(i).approver_order_number
,tempActionTypeName
,getOrigSystemDesc(approverList(i).orig_system)
,tempGroupName
,getAuthorityDesc(approverList(i).authority)
,getApiInsertionDesc(approverList(i).api_insertion)
,getApprovalStatusDesc(approverList(i).approval_status)
,getApprovalCategoryDesc(approverList(i).approver_category)
,getSourceDesc(approverList(i).source,effectiveRuleDate)
,productionsList);
ame_engine.updateTransactionState(isTestTransactionIn => isRealTransaction = 'N',
isLocalTransactionIn => true,
fetchConfigVarsIn => true,
fetchOldApproversIn => false,
fetchInsertionsIn => false,
fetchDeletionsIn => false,
fetchAttributeValuesIn => true,
fetchInactiveAttValuesIn => false,
processProductionActionsIn => false,
processProductionRulesIn => true,
updateCurrentApproverListIn => true,
updateOldApproverListIn => false,
processPrioritiesIn => processPriorities = 'Y',
prepareItemDataIn => false,
prepareRuleIdsIn => false,
prepareRuleDescsIn => false,
transactionIdIn => transactionIdIn,
ameApplicationIdIn => applicationIdIn,
fndApplicationIdIn => null,
transactionTypeIdIn => null);