APPS.AME_ENGINE dependencies on AME_TEST_TRANS_ATT_VALUES

Line 26: If so, the engine fetches the transaction's attribute values from ame_test_trans_att_values.

22: */
23: engIsLocalTransaction boolean := true;
24: /*
25: engIsTestTransaction indicates whether the current transaction is a test transaction.
26: If so, the engine fetches the transaction's attribute values from ame_test_trans_att_values.
27: engIsTestTransaction is initialized to true so ame_util.runtimeException will see
28: a value of true in the absence of a call to updateTransactionState, before the
29: call to ame_util.runtimeException. That is, unless a call to updateTransactionState
30: sets this variable's value, we assume the transaction is a test transaction, to

Line 1668: select attribute_value_1 into tempValue from ame_test_trans_att_values

1664: itemClassIdIn in integer,
1665: itemIdIn in varchar2) return number as
1666: tempValue ame_util.attributeValueType;
1667: begin
1668: select attribute_value_1 into tempValue from ame_test_trans_att_values
1669: where application_id = engAmeApplicationId
1670: and transaction_id = engTransactionId
1671: and attribute_id = attributeIdIn
1672: and item_class_id = itemClassIdIn

Line 1680: from ame_test_trans_att_values

1676: when no_data_found then
1677: begin
1678: select attribute_value_1
1679: into tempValue
1680: from ame_test_trans_att_values
1681: where application_id = engAmeApplicationId
1682: and transaction_id = engTransactionId
1683: and attribute_id = attributeIdIn
1684: and item_class_id = getItemClassId(ame_util.headerItemClassName)

Line 3972: from ame_test_trans_att_values

3968: select
3969: attribute_value_1,
3970: attribute_value_2,
3971: attribute_value_3
3972: from ame_test_trans_att_values
3973: where
3974: application_id = engAmeApplicationId and
3975: transaction_id = engTransactionId and
3976: attribute_id = attributeIdIn

Line 3980: from ame_test_trans_att_values

3976: attribute_id = attributeIdIn
3977: order by item_id;
3978: cursor testTransNonCurrencyCursor(attributeIdIn in integer) is
3979: select attribute_value_1
3980: from ame_test_trans_att_values
3981: where
3982: application_id = engAmeApplicationId and
3983: transaction_id = engTransactionId and
3984: attribute_id = attributeIdIn

Line 3988: from ame_test_trans_att_values

3984: attribute_id = attributeIdIn
3985: order by item_id;
3986: cursor testTransVariantHeaderCursor(attributeIdIn in integer) is
3987: select attribute_value_1
3988: from ame_test_trans_att_values
3989: where
3990: application_id = engAmeApplicationId and
3991: transaction_id = engTransactionId and
3992: attribute_id = attributeIdIn and

Line 4442: from ame_test_trans_att_values

4438: select
4439: attribute_value_1,
4440: attribute_value_2,
4441: attribute_value_3
4442: from ame_test_trans_att_values
4443: where
4444: application_id = engAmeApplicationId and
4445: transaction_id = engTransactionId and
4446: attribute_id = attributeIdIn

Line 4450: from ame_test_trans_att_values

4446: attribute_id = attributeIdIn
4447: order by item_id;
4448: cursor testTransNonCurrencyCursor(attributeIdIn in integer) is
4449: select attribute_value_1
4450: from ame_test_trans_att_values
4451: where
4452: application_id = engAmeApplicationId and
4453: transaction_id = engTransactionId and
4454: attribute_id = attributeIdIn

Line 4458: from ame_test_trans_att_values

4454: attribute_id = attributeIdIn
4455: order by item_id;
4456: cursor testTransVariantHeaderCursor(attributeIdIn in integer) is
4457: select attribute_value_1
4458: from ame_test_trans_att_values
4459: where
4460: application_id = engAmeApplicationId and
4461: transaction_id = engTransactionId and
4462: attribute_id = attributeIdIn and

Line 5081: from ame_test_trans_att_values

5077: ame_item_class_usages.item_class_order_number,
5078: ame_item_class_usages.item_class_id;
5079: cursor testTransItemIdCursor(itemClassIdIn in integer) is
5080: select distinct item_id
5081: from ame_test_trans_att_values
5082: where
5083: application_id = engAmeApplicationId and
5084: transaction_id = engTransactionId and
5085: item_class_id = itemClassIdIn