eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AME_TEST_PKG dependencies on AME_TEST_TRANS_ATT_VALUES

Line 26: from ame_test_trans_att_values

22: cursor itemIdCursor(applicationIdIn in integer,
23: transactionIdIn in varchar2,
24: itemClassIdIn in integer) is
25: select item_id
26: from ame_test_trans_att_values
27: where
28: application_id = applicationIdIn and
29: transaction_id = transactionIdIn and
30: item_class_id = itemClassIdIn and

Line 60: delete from ame_test_trans_att_values

56: upperLimit integer;
57: begin
58: upperLimit := deleteIn.count;
59: forall i in 1 .. upperLimit
60: delete from ame_test_trans_att_values
61: where
62: application_id = applicationIdIn and
63: transaction_id = transactionIdIn and
64: itemClassIdIn = itemClassIdIn and

Line 97: from ame_test_trans_att_values

93: is_mandatory,
94: attribute_value_1,
95: attribute_value_2,
96: attribute_value_3
97: from ame_test_trans_att_values
98: where
99: application_id = applicationIdIn and
100: transaction_id = transactionIdIn and
101: ((itemIdIn is null and item_id is null) or

Line 167: from ame_test_trans_att_values

163: is_mandatory,
164: attribute_value_1,
165: attribute_value_2,
166: attribute_value_3
167: from ame_test_trans_att_values
168: where
169: application_id = applicationIdIn and
170: transaction_id = transactionIdIn and
171: item_class_id = itemClassIdIn and

Line 306: from ame_test_trans_att_values,

302: select
303: ame_attributes.attribute_id,
304: ame_attributes.name,
305: ame_attributes.approver_type_id
306: from ame_test_trans_att_values,
307: ame_attributes
308: where
309: ame_attributes.attribute_id = ame_test_trans_att_values.attribute_id and
310: ame_attributes.item_class_id = itemClassIdIn and

Line 309: ame_attributes.attribute_id = ame_test_trans_att_values.attribute_id and

305: ame_attributes.approver_type_id
306: from ame_test_trans_att_values,
307: ame_attributes
308: where
309: ame_attributes.attribute_id = ame_test_trans_att_values.attribute_id and
310: ame_attributes.item_class_id = itemClassIdIn and
311: ame_test_trans_att_values.item_id = itemIdIn and
312: ame_test_trans_att_values.application_id = applicationIdIn and
313: ame_test_trans_att_values.transaction_id = transactionIdIn and

Line 311: ame_test_trans_att_values.item_id = itemIdIn and

307: ame_attributes
308: where
309: ame_attributes.attribute_id = ame_test_trans_att_values.attribute_id and
310: ame_attributes.item_class_id = itemClassIdIn and
311: ame_test_trans_att_values.item_id = itemIdIn and
312: ame_test_trans_att_values.application_id = applicationIdIn and
313: ame_test_trans_att_values.transaction_id = transactionIdIn and
314: ame_attributes.approver_type_id is not null and
315: sysdate between ame_attributes.start_date and

Line 312: ame_test_trans_att_values.application_id = applicationIdIn and

308: where
309: ame_attributes.attribute_id = ame_test_trans_att_values.attribute_id and
310: ame_attributes.item_class_id = itemClassIdIn and
311: ame_test_trans_att_values.item_id = itemIdIn and
312: ame_test_trans_att_values.application_id = applicationIdIn and
313: ame_test_trans_att_values.transaction_id = transactionIdIn and
314: ame_attributes.approver_type_id is not null and
315: sysdate between ame_attributes.start_date and
316: nvl(ame_attributes.end_date - ame_util.oneSecond, sysdate)

Line 313: ame_test_trans_att_values.transaction_id = transactionIdIn and

309: ame_attributes.attribute_id = ame_test_trans_att_values.attribute_id and
310: ame_attributes.item_class_id = itemClassIdIn and
311: ame_test_trans_att_values.item_id = itemIdIn and
312: ame_test_trans_att_values.application_id = applicationIdIn and
313: ame_test_trans_att_values.transaction_id = transactionIdIn and
314: ame_attributes.approver_type_id is not null and
315: sysdate between ame_attributes.start_date and
316: nvl(ame_attributes.end_date - ame_util.oneSecond, sysdate)
317: order by ame_attributes.name;

Line 466: from ame_test_trans_att_values

462: cursor itemIdCursor(applicationIdIn in integer,
463: transactionIdIn in varchar2,
464: itemClassIdIn in integer) is
465: select distinct item_id
466: from ame_test_trans_att_values
467: where
468: application_id = applicationIdIn and
469: transaction_id = transactionIdIn and
470: item_class_id = itemClassIdIn and

Line 578: insert into ame_test_trans_att_values(

574: isMandatory := ame_util.booleanTrue;
575: else
576: isMandatory := ame_util.booleanFalse;
577: end if;
578: insert into ame_test_trans_att_values(
579: application_id,
580: transaction_id,
581: row_timestamp,
582: attribute_id,

Line 641: delete from ame_test_trans_att_values

637: attributeTypes ame_util.stringList;
638: isMandatory ame_util.stringList;
639: upperLimit integer;
640: begin
641: delete from ame_test_trans_att_values
642: where
643: application_id = applicationIdIn and
644: transaction_id = transactionIdIn and
645: item_class_id = itemClassIdIn and

Line 660: insert into ame_test_trans_att_values(

656: isMandatory(i) := ame_util.booleanFalse;
657: end if;
658: end loop;
659: forall i in 1 .. upperLimit
660: insert into ame_test_trans_att_values(
661: application_id,
662: transaction_id,
663: row_timestamp,
664: attribute_id,

Line 708: isMandatory ame_test_trans_att_values.is_mandatory%type;

704: attributeValue2In in varchar2 default null,
705: attributeValue3In in varchar2 default null) as
706: attributeName ame_attributes.name%type;
707: attributeType ame_attributes.attribute_Type%type;
708: isMandatory ame_test_trans_att_values.is_mandatory%type;
709: begin
710: delete from ame_test_trans_att_values
711: where
712: application_id = applicationIdIn and

Line 710: delete from ame_test_trans_att_values

706: attributeName ame_attributes.name%type;
707: attributeType ame_attributes.attribute_Type%type;
708: isMandatory ame_test_trans_att_values.is_mandatory%type;
709: begin
710: delete from ame_test_trans_att_values
711: where
712: application_id = applicationIdIn and
713: transaction_id = transactionIdIn and
714: attribute_id = attributeIdIn and

Line 725: insert into ame_test_trans_att_values(

721: isMandatory := ame_util.booleanFalse;
722: end if;
723: attributeName := ame_attribute_pkg.getName(attributeIdIn => attributeIdIn);
724: attributeType := ame_attribute_pkg.getType(attributeIdIn => attributeIdIn);
725: insert into ame_test_trans_att_values(
726: application_id,
727: transaction_id,
728: row_timestamp,
729: attribute_id,