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 1708: select attribute_value_1 into tempValue from ame_test_trans_att_values

1704: itemClassIdIn in integer,
1705: itemIdIn in varchar2) return number as
1706: tempValue ame_util.attributeValueType;
1707: begin
1708: select attribute_value_1 into tempValue from ame_test_trans_att_values
1709: where application_id = engAmeApplicationId
1710: and transaction_id = engTransactionId
1711: and attribute_id = attributeIdIn
1712: and item_class_id = itemClassIdIn

Line 1720: from ame_test_trans_att_values

1716: when no_data_found then
1717: begin
1718: select attribute_value_1
1719: into tempValue
1720: from ame_test_trans_att_values
1721: where application_id = engAmeApplicationId
1722: and transaction_id = engTransactionId
1723: and attribute_id = attributeIdIn
1724: and item_class_id = getItemClassId(ame_util.headerItemClassName)

Line 4012: from ame_test_trans_att_values

4008: select
4009: attribute_value_1,
4010: attribute_value_2,
4011: attribute_value_3
4012: from ame_test_trans_att_values
4013: where
4014: application_id = engAmeApplicationId and
4015: transaction_id = engTransactionId and
4016: attribute_id = attributeIdIn

Line 4020: from ame_test_trans_att_values

4016: attribute_id = attributeIdIn
4017: order by item_id;
4018: cursor testTransNonCurrencyCursor(attributeIdIn in integer) is
4019: select attribute_value_1
4020: from ame_test_trans_att_values
4021: where
4022: application_id = engAmeApplicationId and
4023: transaction_id = engTransactionId and
4024: attribute_id = attributeIdIn

Line 4028: from ame_test_trans_att_values

4024: attribute_id = attributeIdIn
4025: order by item_id;
4026: cursor testTransVariantHeaderCursor(attributeIdIn in integer) is
4027: select attribute_value_1
4028: from ame_test_trans_att_values
4029: where
4030: application_id = engAmeApplicationId and
4031: transaction_id = engTransactionId and
4032: attribute_id = attributeIdIn and

Line 4482: from ame_test_trans_att_values

4478: select
4479: attribute_value_1,
4480: attribute_value_2,
4481: attribute_value_3
4482: from ame_test_trans_att_values
4483: where
4484: application_id = engAmeApplicationId and
4485: transaction_id = engTransactionId and
4486: attribute_id = attributeIdIn

Line 4490: from ame_test_trans_att_values

4486: attribute_id = attributeIdIn
4487: order by item_id;
4488: cursor testTransNonCurrencyCursor(attributeIdIn in integer) is
4489: select attribute_value_1
4490: from ame_test_trans_att_values
4491: where
4492: application_id = engAmeApplicationId and
4493: transaction_id = engTransactionId and
4494: attribute_id = attributeIdIn

Line 4498: from ame_test_trans_att_values

4494: attribute_id = attributeIdIn
4495: order by item_id;
4496: cursor testTransVariantHeaderCursor(attributeIdIn in integer) is
4497: select attribute_value_1
4498: from ame_test_trans_att_values
4499: where
4500: application_id = engAmeApplicationId and
4501: transaction_id = engTransactionId and
4502: attribute_id = attributeIdIn and

Line 5121: from ame_test_trans_att_values

5117: ame_item_class_usages.item_class_order_number,
5118: ame_item_class_usages.item_class_id;
5119: cursor testTransItemIdCursor(itemClassIdIn in integer) is
5120: select distinct item_id
5121: from ame_test_trans_att_values
5122: where
5123: application_id = engAmeApplicationId and
5124: transaction_id = engTransactionId and
5125: item_class_id = itemClassIdIn