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
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
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
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
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
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
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
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)
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;
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
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,
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
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,
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
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
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,