[Home] [Help]
1924: maxInsertionOrderNumber number;
1925: begin
1926: select max(insertion_order)
1927: into maxInsertionOrderNumber
1928: from ame_temp_insertions
1929: where transaction_id = engTransactionId
1930: and application_id = engAmeApplicationId;
1931: if maxinsertionOrderNumber is null
1932: then
4990: insertion_order,
4991: effective_date,
4992: reason,
4993: approval_status
4994: from ame_temp_insertions
4995: where
4996: application_id = applicationIdIn and
4997: transaction_id = transactionIdIn
4998: order by insertion_order;
5928: origSystemOut out nocopy varchar2,
5929: origSystemIdOut out nocopy integer,
5930: displayNameOut out nocopy varchar2,
5931: sourceOut out nocopy varchar2) as
5932: parameter ame_temp_insertions.parameter%type;
5933: begin
5934: parameter := ame_util.firstAuthorityParameter ||
5935: ame_util.fieldDelimiter ||
5936: itemClassIn ||
5971: origSystemOut out nocopy varchar2,
5972: origSystemIdOut out nocopy integer,
5973: displayNameOut out nocopy varchar2,
5974: sourceOut out nocopy varchar2) as
5975: parameter ame_temp_insertions.parameter%type;
5976: begin
5977: parameter := nameIn ||
5978: ame_util.fieldDelimiter ||
5979: itemClassIn ||
6521: ruleIdList ame_util.idList;
6522: sourceDescription ame_util.stringType;
6523: tempBoolean boolean;
6524: tempInsertionDoesNotExist boolean;
6525: tempParameter ame_temp_insertions.parameter%type;
6526: begin
6527:
6528: engStApproversCount := engStApprovers.count;
6529:
8723: /* Copy the input approver to the target index. */
8724: ame_util.copyApproverRecord2(approverRecord2In => approverIn,
8725: approverRecord2Out => engStApprovers(indexIn));
8726: /*
8727: If the status is not available in ame_temp_insertions get it from
8728: ame_temp_old_approver_lists
8729: */
8730: if engStApprovers(indexIn).approval_status is null then
8731: engStApprovers(indexIn).approval_status := getHandlerApprovalStatus(approverIn => engStApprovers(indexIn));
9578: tempAnchorIndex integer;
9579: tempBoolean boolean;
9580: tempIndex integer;
9581: tempIndex2 integer;
9582: tempItemClass ame_temp_insertions.item_class%type;
9583: tempItemId ame_temp_insertions.item_id%type;
9584: tempOrderType ame_temp_insertions.order_type%type;
9585: begin
9586: /*
9579: tempBoolean boolean;
9580: tempIndex integer;
9581: tempIndex2 integer;
9582: tempItemClass ame_temp_insertions.item_class%type;
9583: tempItemId ame_temp_insertions.item_id%type;
9584: tempOrderType ame_temp_insertions.order_type%type;
9585: begin
9586: /*
9587: This procedure generally must populate the following ame_util.approverRecord2 fields,
9580: tempIndex integer;
9581: tempIndex2 integer;
9582: tempItemClass ame_temp_insertions.item_class%type;
9583: tempItemId ame_temp_insertions.item_id%type;
9584: tempOrderType ame_temp_insertions.order_type%type;
9585: begin
9586: /*
9587: This procedure generally must populate the following ame_util.approverRecord2 fields,
9588: for each inserted approver:
11466: begin
11467: for i in 1..engInsApproverIndex.count loop
11468: if engInsApproverIndex(i) = currentApproverIndexIn then
11469: engInsertedApproverList(i).approval_status := approvalStatusIn;
11470: update ame_temp_insertions
11471: set approval_status = approvalStatusIn
11472: where application_id = engAmeApplicationId
11473: and transaction_id = engTransactionId
11474: and insertion_order = engInsertionOrderList(i)
12084: repeatedIndexes ame_util.idList;
12085: repeatedAppIndexes ame_util.idList;
12086: superiorApprover ame_util.approverRecord2;
12087: tempInsertionOrder integer;
12088: tempParameter ame_temp_insertions.parameter%type;
12089: tempCOAGroupActionTypeId integer;
12090: tempPreGroupActionTypeId integer;
12091: tempPostGroupActionTypeId integer;
12092: votingRegime ame_util.charType;
12691: ame_util.fieldDelimiter ||
12692: approver.group_or_chain_id ||
12693: ame_util.fieldDelimiter ||
12694: approver.occurrence;
12695: insert into ame_temp_insertions(
12696: transaction_id,
12697: application_id,
12698: insertion_order,
12699: order_type,
12777: ame_util.fieldDelimiter ||
12778: approver.group_or_chain_id ||
12779: ame_util.fieldDelimiter ||
12780: approver.occurrence;
12781: insert into ame_temp_insertions(
12782: transaction_id,
12783: application_id,
12784: insertion_order,
12785: order_type,
12854: ame_util.fieldDelimiter ||
12855: approver.group_or_chain_id ||
12856: ame_util.fieldDelimiter ||
12857: approver.occurrence;
12858: insert into ame_temp_insertions(
12859: transaction_id,
12860: application_id,
12861: insertion_order,
12862: order_type,
12900: ame_util.fieldDelimiter ||
12901: forwardee.group_or_chain_id ||
12902: ame_util.fieldDelimiter ||
12903: forwardee.occurrence;
12904: insert into ame_temp_insertions(
12905: transaction_id,
12906: application_id,
12907: insertion_order,
12908: order_type,
12956: ame_util.fieldDelimiter ||
12957: approver.group_or_chain_id ||
12958: ame_util.fieldDelimiter ||
12959: approver.occurrence;
12960: insert into ame_temp_insertions(
12961: transaction_id,
12962: application_id,
12963: insertion_order,
12964: order_type,
13034: ame_util.fieldDelimiter ||
13035: insertedApprover.group_or_chain_id ||
13036: ame_util.fieldDelimiter ||
13037: insertedApprover.occurrence;
13038: insert into ame_temp_insertions(
13039: transaction_id,
13040: application_id,
13041: insertion_order,
13042: order_type,
13105: ame_util.fieldDelimiter ||
13106: approver.group_or_chain_id ||
13107: ame_util.fieldDelimiter ||
13108: prevApproverOccurrence;
13109: insert into ame_temp_insertions(
13110: transaction_id,
13111: application_id,
13112: insertion_order,
13113: order_type,
13270: tempIndex := engStInsertionIndexes.next(indexIn);
13271: while engStInsertionIndexes.exists(tempIndex) loop
13272: approverInsertionOrder := engStInsertionIndexes(tempIndex);
13273: if approverInsertionOrder > deletionInsertionOrder then
13274: update ame_temp_insertions
13275: set parameter = parameter - 1
13276: where insertion_order = approverInsertionOrder
13277: and application_id = engAmeApplicationId
13278: and transaction_id = engTransactionId