[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
select ame_test_trans_s.nextval into tempId from dual;
select item_id
from ame_test_trans_att_values
where
application_id = applicationIdIn and
transaction_id = transactionIdIn and
item_class_id = itemClassIdIn and
item_id is not null
order by item_id;
procedure deleteTestItems(applicationIdIn in integer,
transactionIdIn in varchar2,
itemClassIdIn in integer,
deleteIn in ame_util.stringList) as
upperLimit integer;
upperLimit := deleteIn.count;
delete from ame_test_trans_att_values
where
application_id = applicationIdIn and
transaction_id = transactionIdIn and
itemClassIdIn = itemClassIdIn and
item_id = deleteIn(i);
routineNameIn => 'deleteTestItems',
exceptionNumberIn => sqlcode,
exceptionStringIn => sqlerrm);
end deleteTestItems;
select
attribute_id,
attribute_name,
attribute_type,
is_mandatory,
attribute_value_1,
attribute_value_2,
attribute_value_3
from ame_test_trans_att_values
where
application_id = applicationIdIn and
transaction_id = transactionIdIn and
((itemIdIn is null and item_id is null) or
itemIdIn = item_id)
order by attribute_name;
select
attribute_id,
attribute_name,
attribute_type,
is_mandatory,
attribute_value_1,
attribute_value_2,
attribute_value_3
from ame_test_trans_att_values
where
application_id = applicationIdIn and
transaction_id = transactionIdIn and
item_class_id = itemClassIdIn and
((itemIdIn is null and item_id is null) or
itemIdIn = item_id)
order by attribute_name;
ame_engine.updateTransactionState(isTestTransactionIn => isTestTransaction,
isLocalTransactionIn => true,
fetchConfigVarsIn => true,
fetchOldApproversIn => false,
fetchInsertionsIn => false,
fetchDeletionsIn => false,
fetchAttributeValuesIn => true,
fetchInactiveAttValuesIn => false,
processProductionActionsIn => false,
processProductionRulesIn => true,
updateCurrentApproverListIn => false,
updateOldApproverListIn => false,
processPrioritiesIn => processPriorities,
prepareItemDataIn => false,
prepareRuleIdsIn => false,
prepareRuleDescsIn => false,
transactionIdIn => transactionIdIn,
ameApplicationIdIn => applicationIdIn,
fndApplicationIdIn => null,
transactionTypeIdIn => null);
select
ame_attributes.attribute_id,
ame_attributes.name,
ame_attributes.approver_type_id
from ame_test_trans_att_values,
ame_attributes
where
ame_attributes.attribute_id = ame_test_trans_att_values.attribute_id and
ame_attributes.item_class_id = itemClassIdIn and
ame_test_trans_att_values.item_id = itemIdIn and
ame_test_trans_att_values.application_id = applicationIdIn and
ame_test_trans_att_values.transaction_id = transactionIdIn and
ame_attributes.approver_type_id is not null and
sysdate between ame_attributes.start_date and
nvl(ame_attributes.end_date - ame_util.oneSecond, sysdate)
order by ame_attributes.name;
ame_engine.updateTransactionState(isTestTransactionIn => isTestTransaction,
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);
select distinct item_id
from ame_test_trans_att_values
where
application_id = applicationIdIn and
transaction_id = transactionIdIn and
item_class_id = itemClassIdIn and
item_id is not null
order by item_id;
ame_engine.updateTransactionState(isTestTransactionIn => isTestTransaction,
isLocalTransactionIn => true,
fetchConfigVarsIn => true,
fetchOldApproversIn => false,
fetchInsertionsIn => false,
fetchDeletionsIn => false,
fetchAttributeValuesIn => true,
fetchInactiveAttValuesIn => false,
processProductionActionsIn => false,
processProductionRulesIn => true,
updateCurrentApproverListIn => false,
updateOldApproverListIn => false,
processPrioritiesIn => false,
prepareItemDataIn => false,
prepareRuleIdsIn => false,
prepareRuleDescsIn => false,
transactionIdIn => transactionIdIn,
ameApplicationIdIn => applicationIdIn,
fndApplicationIdIn => null,
transactionTypeIdIn => null);
insert into ame_test_trans_att_values(
application_id,
transaction_id,
row_timestamp,
attribute_id,
attribute_name,
attribute_type,
is_mandatory,
line_item_id,
item_id,
item_class_id,
attribute_value_1,
attribute_value_2,
attribute_value_3) values(
applicationIdIn,
transactionIdIn,
sysdate,
attributeIds(i),
attributeNames(i),
attributeTypes(i),
isMandatory,
null,
nvl(itemIdIn, transactionIdIn),
itemClassId,
null,
null,
null);
delete from ame_test_trans_att_values
where
application_id = applicationIdIn and
transaction_id = transactionIdIn and
item_class_id = itemClassIdIn and
((itemIdIn is null and item_id is null) or
itemIdIn = item_id);
insert into ame_test_trans_att_values(
application_id,
transaction_id,
row_timestamp,
attribute_id,
attribute_name,
attribute_type,
is_mandatory,
line_item_id,
attribute_value_1,
attribute_value_2,
attribute_value_3,
item_class_id,
item_id)
values(
applicationIdIn,
transactionIdIn,
sysdate,
attributeIdsIn(i),
attributeNames(i),
attributeTypes(i),
isMandatory(i),
null,
attributeValues1In(i),
attributeValues2In(i),
attributeValues3In(i),
itemClassIdIn,
itemIdIn);
delete from ame_test_trans_att_values
where
application_id = applicationIdIn and
transaction_id = transactionIdIn and
attribute_id = attributeIdIn and
item_class_id = itemClassIdIn and
itemIdIn = item_id;
insert into ame_test_trans_att_values(
application_id,
transaction_id,
row_timestamp,
attribute_id,
attribute_name,
attribute_type,
is_mandatory,
line_item_id,
item_id,
item_class_id,
attribute_value_1,
attribute_value_2,
attribute_value_3)
values(
applicationIdIn,
transactionIdIn,
sysdate,
attributeIdIn,
attributeName,
attributeType,
isMandatory,
null,
itemIdIn,
itemClassIdIn,
attributeValue1In,
attributeValue2In,
attributeValue3In);