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.POR_AME_APPROVAL_LIST dependencies on AME_UTIL

Line 102: function serializeApproversTable(approversTableIn in ame_util.approversTable2,

98: -- 'Y' if there is approver taken action
99: --End of Comments
100: --------------------------------------------------------------------------------
101:
102: function serializeApproversTable(approversTableIn in ame_util.approversTable2,
103: reqHeaderId in NUMBER,
104: approverCount out nocopy number,
105: hasApprovalAction out nocopy varchar2)
106: return varchar2;

Line 160: tmpApprover ame_util.approverRecord2;

156: pFieldDelimiter OUT NOCOPY VARCHAR2
157: ) IS
158:
159: l_api_name varchar2(50):= 'change_first_approver';
160: tmpApprover ame_util.approverRecord2;
161: ameTransactionType po_document_types.ame_transaction_type%TYPE;
162:
163: approverList ame_util.approversTable2;
164: l_process_out VARCHAR2(10);

Line 163: approverList ame_util.approversTable2;

159: l_api_name varchar2(50):= 'change_first_approver';
160: tmpApprover ame_util.approverRecord2;
161: ameTransactionType po_document_types.ame_transaction_type%TYPE;
162:
163: approverList ame_util.approversTable2;
164: l_process_out VARCHAR2(10);
165: currentFirstApprover ame_util.approverRecord2;
166:
167: begin

Line 165: currentFirstApprover ame_util.approverRecord2;

161: ameTransactionType po_document_types.ame_transaction_type%TYPE;
162:
163: approverList ame_util.approversTable2;
164: l_process_out VARCHAR2(10);
165: currentFirstApprover ame_util.approverRecord2;
166:
167: begin
168:
169: if g_fnd_debug = 'Y' then

Line 210: if( approverList(i).authority = ame_util.authorityApprover

206:
207: -- Once we get the approvers list from AME, we iterate through the approvers list,
208: -- to find out the current first authority approver.
209: for i in 1 .. approverList.count loop
210: if( approverList(i).authority = ame_util.authorityApprover
211: and approverList(i).approval_status is null
212: and approverList(i).api_insertion = 'N'
213: and approverList(i).group_or_chain_id < 3 ) then
214: currentFirstApprover := approverList(i) ;

Line 232: if currentFirstApprover.orig_system = ame_util.posOrigSystem then

228: -- If the first approver record is of emp supervisor action type,
229: -- then we simply frame the new approver record from the input parameters.
230: -- FND users cannot be set as first authority approver. So no need to check for the value 'FND'
231:
232: if currentFirstApprover.orig_system = ame_util.posOrigSystem then
233:
234: if g_fnd_debug = 'Y' then
235: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
236: FND_LOG.string(FND_LOG.level_statement, g_module_prefix || l_api_name, 'First record is of type Position Hierarchy...' );

Line 239: tmpApprover.orig_system := ame_util.posOrigSystem;

235: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
236: FND_LOG.string(FND_LOG.level_statement, g_module_prefix || l_api_name, 'First record is of type Position Hierarchy...' );
237: END IF;
238: end if;
239: tmpApprover.orig_system := ame_util.posOrigSystem;
240: SELECT position_id into tmpApprover.orig_system_id FROM PER_ALL_ASSIGNMENTS_F pa
241: WHERE pa.person_id = pPersonId and pa.primary_flag = 'Y' and pa.assignment_type in ('E','C')
242: and pa.position_id is not null and pa.assignment_status_type_id not in (
243: select assignment_status_type_id from per_assignment_status_types where per_system_status = 'TERM_ASSIGN')

Line 272: tmpApprover.orig_system := ame_util.perOrigSystem;

268: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
269: FND_LOG.string(FND_LOG.level_statement, g_module_prefix || l_api_name, ' First record is of type Emp-Sup Hierarchy...' );
270: END IF;
271: end if;
272: tmpApprover.orig_system := ame_util.perOrigSystem;
273: tmpApprover.orig_system_id := pPersonId;
274: end if;
275:
276: -- set the mandatory default attributes for the first authority approver.

Line 277: tmpApprover.authority := ame_util.authorityApprover;

273: tmpApprover.orig_system_id := pPersonId;
274: end if;
275:
276: -- set the mandatory default attributes for the first authority approver.
277: tmpApprover.authority := ame_util.authorityApprover;
278: tmpApprover.api_insertion := ame_util.apiAuthorityInsertion;
279: tmpApprover.approval_status := ame_util.nullStatus;
280: tmpApprover.approver_category := ame_util.approvalApproverCategory ;
281: tmpApprover.item_class := currentFirstApprover.item_class ;

Line 278: tmpApprover.api_insertion := ame_util.apiAuthorityInsertion;

274: end if;
275:
276: -- set the mandatory default attributes for the first authority approver.
277: tmpApprover.authority := ame_util.authorityApprover;
278: tmpApprover.api_insertion := ame_util.apiAuthorityInsertion;
279: tmpApprover.approval_status := ame_util.nullStatus;
280: tmpApprover.approver_category := ame_util.approvalApproverCategory ;
281: tmpApprover.item_class := currentFirstApprover.item_class ;
282: tmpApprover.item_id := currentFirstApprover.item_id ;

Line 279: tmpApprover.approval_status := ame_util.nullStatus;

275:
276: -- set the mandatory default attributes for the first authority approver.
277: tmpApprover.authority := ame_util.authorityApprover;
278: tmpApprover.api_insertion := ame_util.apiAuthorityInsertion;
279: tmpApprover.approval_status := ame_util.nullStatus;
280: tmpApprover.approver_category := ame_util.approvalApproverCategory ;
281: tmpApprover.item_class := currentFirstApprover.item_class ;
282: tmpApprover.item_id := currentFirstApprover.item_id ;
283: tmpApprover.action_type_id := currentFirstApprover.action_type_id ;

Line 280: tmpApprover.approver_category := ame_util.approvalApproverCategory ;

276: -- set the mandatory default attributes for the first authority approver.
277: tmpApprover.authority := ame_util.authorityApprover;
278: tmpApprover.api_insertion := ame_util.apiAuthorityInsertion;
279: tmpApprover.approval_status := ame_util.nullStatus;
280: tmpApprover.approver_category := ame_util.approvalApproverCategory ;
281: tmpApprover.item_class := currentFirstApprover.item_class ;
282: tmpApprover.item_id := currentFirstApprover.item_id ;
283: tmpApprover.action_type_id := currentFirstApprover.action_type_id ;
284: tmpApprover.group_or_chain_id := currentFirstApprover.group_or_chain_id ;

Line 314: clearChainStatusYNIn => ame_util.booleanTrue

310: ame_api2.setFirstAuthorityApprover( applicationIdIn => applicationId,
311: transactionIdIn => pReqHeaderId,
312: approverIn => tmpApprover,
313: transactionTypeIn => ameTransactionType,
314: clearChainStatusYNIn => ame_util.booleanTrue
315: );
316: if g_fnd_debug = 'Y' then
317: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
318: FND_LOG.string(FND_LOG.level_statement, g_module_prefix || l_api_name, 'Done with ame_api2.setFirstAuthorityApprover()...' );

Line 399: tmpApprover ame_util.approverRecord2;

395: pFieldDelimiter OUT NOCOPY VARCHAR2
396: ) IS
397: l_api_name varchar2(50):= 'insert_approver';
398:
399: tmpApprover ame_util.approverRecord2;
400: insertOrder ame_util.insertionRecord2;
401: upperLimit number;
402: approverList ame_util.approversTable2;
403: hasAvailableOrder boolean := false;

Line 400: insertOrder ame_util.insertionRecord2;

396: ) IS
397: l_api_name varchar2(50):= 'insert_approver';
398:
399: tmpApprover ame_util.approverRecord2;
400: insertOrder ame_util.insertionRecord2;
401: upperLimit number;
402: approverList ame_util.approversTable2;
403: hasAvailableOrder boolean := false;
404: E_NO_AVAILABLE_INSERTION EXCEPTION;

Line 402: approverList ame_util.approversTable2;

398:
399: tmpApprover ame_util.approverRecord2;
400: insertOrder ame_util.insertionRecord2;
401: upperLimit number;
402: approverList ame_util.approversTable2;
403: hasAvailableOrder boolean := false;
404: E_NO_AVAILABLE_INSERTION EXCEPTION;
405: ameTransactionType po_document_types.ame_transaction_type%TYPE;
406: absolutePosition number;

Line 407: availableInsertionList ame_util.insertionsTable2;

403: hasAvailableOrder boolean := false;
404: E_NO_AVAILABLE_INSERTION EXCEPTION;
405: ameTransactionType po_document_types.ame_transaction_type%TYPE;
406: absolutePosition number;
407: availableInsertionList ame_util.insertionsTable2;
408: l_process_out VARCHAR2(10);
409: l_group_or_chain_id NUMBER := 0;
410: l_action_type_id NUMBER := 0;
411: l_counter NUMBER := 0;

Line 450: tmpApprover.orig_system := ame_util.perOrigSystem;

446:
447:
448: -- Frame the approverRecord2 from the input parameters.
449: -- Set the default mandatory attributes also.
450: tmpApprover.orig_system := ame_util.perOrigSystem;
451: tmpApprover.orig_system_id := pPersonId;
452: tmpApprover.authority := pAuthority;
453: tmpApprover.api_insertion := ame_util.apiInsertion;
454: tmpApprover.approver_category := pApproverCategory;

Line 453: tmpApprover.api_insertion := ame_util.apiInsertion;

449: -- Set the default mandatory attributes also.
450: tmpApprover.orig_system := ame_util.perOrigSystem;
451: tmpApprover.orig_system_id := pPersonId;
452: tmpApprover.authority := pAuthority;
453: tmpApprover.api_insertion := ame_util.apiInsertion;
454: tmpApprover.approver_category := pApproverCategory;
455: tmpApprover.approval_status := ame_util.nullStatus;
456: ame_api2.getAllApprovers7( applicationIdIn => applicationId,
457: transactionIdIn => pReqHeaderId,

Line 455: tmpApprover.approval_status := ame_util.nullStatus;

451: tmpApprover.orig_system_id := pPersonId;
452: tmpApprover.authority := pAuthority;
453: tmpApprover.api_insertion := ame_util.apiInsertion;
454: tmpApprover.approver_category := pApproverCategory;
455: tmpApprover.approval_status := ame_util.nullStatus;
456: ame_api2.getAllApprovers7( applicationIdIn => applicationId,
457: transactionIdIn => pReqHeaderId,
458: transactionTypeIn => ameTransactionType,
459: approvalProcessCompleteYNOut => l_process_out,

Line 466: IF (approverList(i).approval_status IN (ame_util.repeatedStatus,ame_util.suppressedStatus,

462:
463: /* Check if there is any supressed or repeated approver. As soon as we met any, set hasHiddenApprovers true and exit
464: Added extra statuses to check if there is any hidden approver in approver checkout flow */
465: For i In 1 .. approverList.count LOOP
466: IF (approverList(i).approval_status IN (ame_util.repeatedStatus,ame_util.suppressedStatus,
467: ame_util.notifiedByRepeatedStatus, ame_util.approvedByRepeatedStatus,
468: ame_util.rejectedByRepeatedStatus, ame_util.approvedStatus,
469: ame_util.rejectStatus )) THEN
470: hasHiddenApprovers := true;

Line 467: ame_util.notifiedByRepeatedStatus, ame_util.approvedByRepeatedStatus,

463: /* Check if there is any supressed or repeated approver. As soon as we met any, set hasHiddenApprovers true and exit
464: Added extra statuses to check if there is any hidden approver in approver checkout flow */
465: For i In 1 .. approverList.count LOOP
466: IF (approverList(i).approval_status IN (ame_util.repeatedStatus,ame_util.suppressedStatus,
467: ame_util.notifiedByRepeatedStatus, ame_util.approvedByRepeatedStatus,
468: ame_util.rejectedByRepeatedStatus, ame_util.approvedStatus,
469: ame_util.rejectStatus )) THEN
470: hasHiddenApprovers := true;
471: EXIT;

Line 468: ame_util.rejectedByRepeatedStatus, ame_util.approvedStatus,

464: Added extra statuses to check if there is any hidden approver in approver checkout flow */
465: For i In 1 .. approverList.count LOOP
466: IF (approverList(i).approval_status IN (ame_util.repeatedStatus,ame_util.suppressedStatus,
467: ame_util.notifiedByRepeatedStatus, ame_util.approvedByRepeatedStatus,
468: ame_util.rejectedByRepeatedStatus, ame_util.approvedStatus,
469: ame_util.rejectStatus )) THEN
470: hasHiddenApprovers := true;
471: EXIT;
472: END IF;

Line 469: ame_util.rejectStatus )) THEN

465: For i In 1 .. approverList.count LOOP
466: IF (approverList(i).approval_status IN (ame_util.repeatedStatus,ame_util.suppressedStatus,
467: ame_util.notifiedByRepeatedStatus, ame_util.approvedByRepeatedStatus,
468: ame_util.rejectedByRepeatedStatus, ame_util.approvedStatus,
469: ame_util.rejectStatus )) THEN
470: hasHiddenApprovers := true;
471: EXIT;
472: END IF;
473: END LOOP;

Line 491: OR approverList(i).approval_status NOT IN (ame_util.repeatedStatus,ame_util.suppressedStatus,

487: Status XXXByRepeatedStatus is used because 'repeated' status gets modified to XXXByRepeatedStatus
488: status when other approvers in group or PCOA gets notified or approve or reject .Also group can have pending as well
489: as approved approvers */
490: IF ( pApproverName = approverList(i).name AND ( approverList(i).approval_status IS NULL
491: OR approverList(i).approval_status NOT IN (ame_util.repeatedStatus,ame_util.suppressedStatus,
492: ame_util.notifiedByRepeatedStatus, ame_util.approvedByRepeatedStatus,
493: ame_util.rejectedByRepeatedStatus, ame_util.approvedStatus,
494: ame_util.rejectStatus))) THEN
495: l_approver_position := i;

Line 492: ame_util.notifiedByRepeatedStatus, ame_util.approvedByRepeatedStatus,

488: status when other approvers in group or PCOA gets notified or approve or reject .Also group can have pending as well
489: as approved approvers */
490: IF ( pApproverName = approverList(i).name AND ( approverList(i).approval_status IS NULL
491: OR approverList(i).approval_status NOT IN (ame_util.repeatedStatus,ame_util.suppressedStatus,
492: ame_util.notifiedByRepeatedStatus, ame_util.approvedByRepeatedStatus,
493: ame_util.rejectedByRepeatedStatus, ame_util.approvedStatus,
494: ame_util.rejectStatus))) THEN
495: l_approver_position := i;
496: /* Once we locate the approver terminate the loop */

Line 493: ame_util.rejectedByRepeatedStatus, ame_util.approvedStatus,

489: as approved approvers */
490: IF ( pApproverName = approverList(i).name AND ( approverList(i).approval_status IS NULL
491: OR approverList(i).approval_status NOT IN (ame_util.repeatedStatus,ame_util.suppressedStatus,
492: ame_util.notifiedByRepeatedStatus, ame_util.approvedByRepeatedStatus,
493: ame_util.rejectedByRepeatedStatus, ame_util.approvedStatus,
494: ame_util.rejectStatus))) THEN
495: l_approver_position := i;
496: /* Once we locate the approver terminate the loop */
497: EXIT;

Line 494: ame_util.rejectStatus))) THEN

490: IF ( pApproverName = approverList(i).name AND ( approverList(i).approval_status IS NULL
491: OR approverList(i).approval_status NOT IN (ame_util.repeatedStatus,ame_util.suppressedStatus,
492: ame_util.notifiedByRepeatedStatus, ame_util.approvedByRepeatedStatus,
493: ame_util.rejectedByRepeatedStatus, ame_util.approvedStatus,
494: ame_util.rejectStatus))) THEN
495: l_approver_position := i;
496: /* Once we locate the approver terminate the loop */
497: EXIT;
498: END IF;

Line 518: IF l_insertion_type <> ame_util.apiInsertion THEN

514: Checking it for 'after' case and not 'before' because insertion before adhoc is only possible if adhoc is inserted at
515: the left end of chain. And in that case action_type_id is enough to locate exact position of insertion
516: Requirement of these extra statuses have beed explained earlier. Not included condition check of 'approvedStatus'
517: for 'before' case, because we dont provide option to insert before approver who have approved */
518: IF l_insertion_type <> ame_util.apiInsertion THEN
519: if l_group_or_chain_id > 1 then
520: while( l_counter <= approverList.count AND approverList(l_counter).group_or_chain_id = l_group_or_chain_id
521: AND approverList(l_counter).approval_status IN (ame_util.repeatedStatus,ame_util.suppressedStatus,
522: ame_util.notifiedByRepeatedStatus, ame_util.approvedByRepeatedStatus, ame_util.rejectedByRepeatedStatus,

Line 521: AND approverList(l_counter).approval_status IN (ame_util.repeatedStatus,ame_util.suppressedStatus,

517: for 'before' case, because we dont provide option to insert before approver who have approved */
518: IF l_insertion_type <> ame_util.apiInsertion THEN
519: if l_group_or_chain_id > 1 then
520: while( l_counter <= approverList.count AND approverList(l_counter).group_or_chain_id = l_group_or_chain_id
521: AND approverList(l_counter).approval_status IN (ame_util.repeatedStatus,ame_util.suppressedStatus,
522: ame_util.notifiedByRepeatedStatus, ame_util.approvedByRepeatedStatus, ame_util.rejectedByRepeatedStatus,
523: ame_util.approvedStatus) ) LOOP
524: l_counter := l_counter + 1;
525: END LOOP;

Line 522: ame_util.notifiedByRepeatedStatus, ame_util.approvedByRepeatedStatus, ame_util.rejectedByRepeatedStatus,

518: IF l_insertion_type <> ame_util.apiInsertion THEN
519: if l_group_or_chain_id > 1 then
520: while( l_counter <= approverList.count AND approverList(l_counter).group_or_chain_id = l_group_or_chain_id
521: AND approverList(l_counter).approval_status IN (ame_util.repeatedStatus,ame_util.suppressedStatus,
522: ame_util.notifiedByRepeatedStatus, ame_util.approvedByRepeatedStatus, ame_util.rejectedByRepeatedStatus,
523: ame_util.approvedStatus) ) LOOP
524: l_counter := l_counter + 1;
525: END LOOP;
526: else

Line 523: ame_util.approvedStatus) ) LOOP

519: if l_group_or_chain_id > 1 then
520: while( l_counter <= approverList.count AND approverList(l_counter).group_or_chain_id = l_group_or_chain_id
521: AND approverList(l_counter).approval_status IN (ame_util.repeatedStatus,ame_util.suppressedStatus,
522: ame_util.notifiedByRepeatedStatus, ame_util.approvedByRepeatedStatus, ame_util.rejectedByRepeatedStatus,
523: ame_util.approvedStatus) ) LOOP
524: l_counter := l_counter + 1;
525: END LOOP;
526: else
527: while( l_counter <= approverList.count AND approverList(l_counter).action_type_id = l_action_type_id

Line 528: AND approverList(l_counter).approval_status IN (ame_util.repeatedStatus,ame_util.suppressedStatus,

524: l_counter := l_counter + 1;
525: END LOOP;
526: else
527: while( l_counter <= approverList.count AND approverList(l_counter).action_type_id = l_action_type_id
528: AND approverList(l_counter).approval_status IN (ame_util.repeatedStatus,ame_util.suppressedStatus,
529: ame_util.notifiedByRepeatedStatus, ame_util.approvedByRepeatedStatus, ame_util.rejectedByRepeatedStatus,
530: ame_util.approvedStatus) ) LOOP
531: l_counter := l_counter + 1;
532: END LOOP;

Line 529: ame_util.notifiedByRepeatedStatus, ame_util.approvedByRepeatedStatus, ame_util.rejectedByRepeatedStatus,

525: END LOOP;
526: else
527: while( l_counter <= approverList.count AND approverList(l_counter).action_type_id = l_action_type_id
528: AND approverList(l_counter).approval_status IN (ame_util.repeatedStatus,ame_util.suppressedStatus,
529: ame_util.notifiedByRepeatedStatus, ame_util.approvedByRepeatedStatus, ame_util.rejectedByRepeatedStatus,
530: ame_util.approvedStatus) ) LOOP
531: l_counter := l_counter + 1;
532: END LOOP;
533: end if;

Line 530: ame_util.approvedStatus) ) LOOP

526: else
527: while( l_counter <= approverList.count AND approverList(l_counter).action_type_id = l_action_type_id
528: AND approverList(l_counter).approval_status IN (ame_util.repeatedStatus,ame_util.suppressedStatus,
529: ame_util.notifiedByRepeatedStatus, ame_util.approvedByRepeatedStatus, ame_util.rejectedByRepeatedStatus,
530: ame_util.approvedStatus) ) LOOP
531: l_counter := l_counter + 1;
532: END LOOP;
533: end if;
534: END IF;

Line 540: AND approverList(l_counter).approval_status IN (ame_util.repeatedStatus,ame_util.suppressedStatus,

536: ELSE
537: l_counter := l_approver_position - 1;
538: if l_group_or_chain_id > 1 then
539: while( l_counter > 0 AND approverList(l_counter).group_or_chain_id = l_group_or_chain_id
540: AND approverList(l_counter).approval_status IN (ame_util.repeatedStatus,ame_util.suppressedStatus,
541: ame_util.notifiedByRepeatedStatus, ame_util.approvedByRepeatedStatus, ame_util.rejectedByRepeatedStatus)) LOOP
542: l_counter := l_counter - 1;
543: END LOOP;
544: else

Line 541: ame_util.notifiedByRepeatedStatus, ame_util.approvedByRepeatedStatus, ame_util.rejectedByRepeatedStatus)) LOOP

537: l_counter := l_approver_position - 1;
538: if l_group_or_chain_id > 1 then
539: while( l_counter > 0 AND approverList(l_counter).group_or_chain_id = l_group_or_chain_id
540: AND approverList(l_counter).approval_status IN (ame_util.repeatedStatus,ame_util.suppressedStatus,
541: ame_util.notifiedByRepeatedStatus, ame_util.approvedByRepeatedStatus, ame_util.rejectedByRepeatedStatus)) LOOP
542: l_counter := l_counter - 1;
543: END LOOP;
544: else
545: while( l_counter > 0 AND approverList(l_counter).action_type_id = l_action_type_id

Line 546: AND approverList(l_counter).approval_status IN (ame_util.repeatedStatus,ame_util.suppressedStatus,

542: l_counter := l_counter - 1;
543: END LOOP;
544: else
545: while( l_counter > 0 AND approverList(l_counter).action_type_id = l_action_type_id
546: AND approverList(l_counter).approval_status IN (ame_util.repeatedStatus,ame_util.suppressedStatus,
547: ame_util.notifiedByRepeatedStatus, ame_util.approvedByRepeatedStatus, ame_util.rejectedByRepeatedStatus )) LOOP
548: l_counter := l_counter - 1;
549: END LOOP;
550: end if;

Line 547: ame_util.notifiedByRepeatedStatus, ame_util.approvedByRepeatedStatus, ame_util.rejectedByRepeatedStatus )) LOOP

543: END LOOP;
544: else
545: while( l_counter > 0 AND approverList(l_counter).action_type_id = l_action_type_id
546: AND approverList(l_counter).approval_status IN (ame_util.repeatedStatus,ame_util.suppressedStatus,
547: ame_util.notifiedByRepeatedStatus, ame_util.approvedByRepeatedStatus, ame_util.rejectedByRepeatedStatus )) LOOP
548: l_counter := l_counter - 1;
549: END LOOP;
550: end if;
551: absolutePosition := l_counter + 1;

Line 587: (ame_util.absoluteOrder,ame_util.afterApprover, ame_util.beforeApprover) AND

583:
584: IF(approverList.count = 0) THEN
585: FOR i IN 1 .. availableInsertionList.COUNT LOOP
586: IF availableInsertionList(i).order_type IN
587: (ame_util.absoluteOrder,ame_util.afterApprover, ame_util.beforeApprover) AND
588: availableInsertionList(i).api_insertion = tmpApprover.api_insertion AND
589: availableInsertionList(i).authority = tmpApprover.authority THEN
590:
591: insertOrder := availableInsertionList(i);

Line 627: IF ((pInsertionType = 'A' and availableInsertionList(i).order_type IN (ame_util.afterApprover, ame_util.beforeApprover))

623: ELSE
624: FOR i IN 1 .. availableInsertionList.COUNT LOOP
625: /* We can insert after an approver if we have order_type in absoluteOrder,afterApprover or beforeApprover
626: And for insertion before an approver we should have order_type as beforeApprover */
627: IF ((pInsertionType = 'A' and availableInsertionList(i).order_type IN (ame_util.afterApprover, ame_util.beforeApprover))
628: OR (pInsertionType = 'B' and availableInsertionList(i).order_type = ame_util.beforeApprover)) AND
629: availableInsertionList(i).api_insertion = tmpApprover.api_insertion AND
630: availableInsertionList(i).authority = tmpApprover.authority THEN
631:

Line 628: OR (pInsertionType = 'B' and availableInsertionList(i).order_type = ame_util.beforeApprover)) AND

624: FOR i IN 1 .. availableInsertionList.COUNT LOOP
625: /* We can insert after an approver if we have order_type in absoluteOrder,afterApprover or beforeApprover
626: And for insertion before an approver we should have order_type as beforeApprover */
627: IF ((pInsertionType = 'A' and availableInsertionList(i).order_type IN (ame_util.afterApprover, ame_util.beforeApprover))
628: OR (pInsertionType = 'B' and availableInsertionList(i).order_type = ame_util.beforeApprover)) AND
629: availableInsertionList(i).api_insertion = tmpApprover.api_insertion AND
630: availableInsertionList(i).authority = tmpApprover.authority THEN
631:
632: insertOrder := availableInsertionList(i);

Line 770: tmpApprover ame_util.approverRecord2;

766: pFieldDelimiter OUT NOCOPY VARCHAR2
767: ) IS
768:
769: l_api_name varchar2(50):= 'delete_approver';
770: tmpApprover ame_util.approverRecord2;
771: ameTransactionType po_document_types.ame_transaction_type%TYPE;
772:
773: approverList ame_util.approversTable2;
774: l_process_out VARCHAR2(10);

Line 773: approverList ame_util.approversTable2;

769: l_api_name varchar2(50):= 'delete_approver';
770: tmpApprover ame_util.approverRecord2;
771: ameTransactionType po_document_types.ame_transaction_type%TYPE;
772:
773: approverList ame_util.approversTable2;
774: l_process_out VARCHAR2(10);
775: l_first_position_id NUMBER;
776:
777: begin

Line 856: approverList(i).approval_status = ame_util.nullStatus or

852: approverList(i).orig_system = tmpApprover.orig_system and
853: approverList(i).orig_system_id = tmpApprover.orig_system_id and
854: approverList(i).authority = tmpApprover.authority and
855: ( approverList(i).approval_status is null or
856: approverList(i).approval_status = ame_util.nullStatus or
857: approverList(i).approval_status <> ame_util.suppressedStatus) ) then
858:
859: if g_fnd_debug = 'Y' then
860: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN

Line 857: approverList(i).approval_status <> ame_util.suppressedStatus) ) then

853: approverList(i).orig_system_id = tmpApprover.orig_system_id and
854: approverList(i).authority = tmpApprover.authority and
855: ( approverList(i).approval_status is null or
856: approverList(i).approval_status = ame_util.nullStatus or
857: approverList(i).approval_status <> ame_util.suppressedStatus) ) then
858:
859: if g_fnd_debug = 'Y' then
860: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
861: FND_LOG.string(FND_LOG.level_statement, g_module_prefix || l_api_name, 'Found the approver to be deleted also in the list...');

Line 892: if (tmpApprover.orig_system=ame_util.posOrigSystem) THEN

888: FND_LOG.string(FND_LOG.level_statement, g_module_prefix || l_api_name, 'Done with ame_api3.suppressApprover()..');
889: END IF;
890: end if;
891:
892: if (tmpApprover.orig_system=ame_util.posOrigSystem) THEN
893:
894: SELECT FIRST_POSITION_ID
895: INTO l_first_position_id
896: FROM po_requisition_headers_all

Line 1001: --approverList ame_util.approversTable;

997: pApprovalAction OUT NOCOPY VARCHAR2
998: ) IS
999:
1000: l_api_name varchar2(50):= 'get_ame_approval_list';
1001: --approverList ame_util.approversTable;
1002: clearListForSavedCart varchar2(1) := 'N';
1003: authorizationStatus po_requisition_headers.authorization_status%TYPE;
1004: preparerId po_requisition_headers.preparer_id%TYPE;
1005: ameTransactionType po_document_types.ame_transaction_type%TYPE;

Line 1010: approverList ame_util.approversTable2;

1006:
1007: l_itemtype po_requisition_headers.wf_item_type%TYPE;
1008: l_itemkey po_requisition_headers.wf_item_key%TYPE;
1009:
1010: approverList ame_util.approversTable2;
1011: l_process_out VARCHAR2(10);
1012:
1013: BEGIN
1014:

Line 1333: approverList ame_util.approversTable2;

1329:
1330: l_api_name varchar2(50):= 'get_old_approval_list';
1331: hasApprovalAction varchar2(1);
1332: approverCount number;
1333: approverList ame_util.approversTable2;
1334: ameTransactionType po_document_types.ame_transaction_type%TYPE;
1335: authorizationStatus po_requisition_headers_all.authorization_status%TYPE;
1336: isRcoApproval boolean := false;
1337: changeRequestExist number := 0;

Line 1515: approvers ame_util.approversTable2;

1511: l_doc_string varchar2(200);
1512: l_preparer_user_name varchar2(100);
1513:
1514: approverCount integer;
1515: approvers ame_util.approversTable2;
1516: ameTransactionType po_document_types.ame_transaction_type%TYPE;
1517: l_process_out VARCHAR2(10);
1518:
1519: BEGIN

Line 1578: if(approvers(i).authority = ame_util.authorityApprover and

1574: approverCount := approvers.count;
1575:
1576: -- Once we get the list of approvers from AME, check for the approval_status in all the record.
1577: for i in 1 .. approverCount loop
1578: if(approvers(i).authority = ame_util.authorityApprover and
1579: (approvers(i).api_insertion = ame_util.oamGenerated or
1580: approvers(i).api_insertion = ame_util.apiAuthorityInsertion) and
1581: (approvers(i).approval_status is null or
1582: approvers(i).approval_status = ame_util.nullStatus)) then

Line 1579: (approvers(i).api_insertion = ame_util.oamGenerated or

1575:
1576: -- Once we get the list of approvers from AME, check for the approval_status in all the record.
1577: for i in 1 .. approverCount loop
1578: if(approvers(i).authority = ame_util.authorityApprover and
1579: (approvers(i).api_insertion = ame_util.oamGenerated or
1580: approvers(i).api_insertion = ame_util.apiAuthorityInsertion) and
1581: (approvers(i).approval_status is null or
1582: approvers(i).approval_status = ame_util.nullStatus)) then
1583: l_return_val := 'N';

Line 1580: approvers(i).api_insertion = ame_util.apiAuthorityInsertion) and

1576: -- Once we get the list of approvers from AME, check for the approval_status in all the record.
1577: for i in 1 .. approverCount loop
1578: if(approvers(i).authority = ame_util.authorityApprover and
1579: (approvers(i).api_insertion = ame_util.oamGenerated or
1580: approvers(i).api_insertion = ame_util.apiAuthorityInsertion) and
1581: (approvers(i).approval_status is null or
1582: approvers(i).approval_status = ame_util.nullStatus)) then
1583: l_return_val := 'N';
1584: exit;

Line 1582: approvers(i).approval_status = ame_util.nullStatus)) then

1578: if(approvers(i).authority = ame_util.authorityApprover and
1579: (approvers(i).api_insertion = ame_util.oamGenerated or
1580: approvers(i).api_insertion = ame_util.apiAuthorityInsertion) and
1581: (approvers(i).approval_status is null or
1582: approvers(i).approval_status = ame_util.nullStatus)) then
1583: l_return_val := 'N';
1584: exit;
1585: end if;
1586: end loop;

Line 1641: approvers ame_util.approversTable2;

1637: xPersonId OUT NOCOPY VARCHAR2) IS
1638:
1639: l_api_name varchar2(50):= 'get_first_authority_approver';
1640: approverCount number;
1641: approvers ame_util.approversTable2;
1642: ameTransactionType po_document_types.ame_transaction_type%TYPE;
1643: l_process_out VARCHAR2(10);
1644:
1645: BEGIN

Line 1688: if(approvers(i).authority = ame_util.authorityApprover and

1684: -- If the first record is of position hierarchy type, then find out the person_id from the position id and return that.
1685: -- Otherwise simply return the person_id from the orig_system_id value.
1686:
1687: for i in 1 .. approverCount loop
1688: if(approvers(i).authority = ame_util.authorityApprover and
1689: approvers(i).api_insertion = ame_util.oamGenerated and
1690: (approvers(i).approval_status is null or
1691: approvers(i).approval_status = ame_util.nullStatus)) then
1692:

Line 1689: approvers(i).api_insertion = ame_util.oamGenerated and

1685: -- Otherwise simply return the person_id from the orig_system_id value.
1686:
1687: for i in 1 .. approverCount loop
1688: if(approvers(i).authority = ame_util.authorityApprover and
1689: approvers(i).api_insertion = ame_util.oamGenerated and
1690: (approvers(i).approval_status is null or
1691: approvers(i).approval_status = ame_util.nullStatus)) then
1692:
1693: if approvers(i).orig_system = ame_util.posOrigSystem then

Line 1691: approvers(i).approval_status = ame_util.nullStatus)) then

1687: for i in 1 .. approverCount loop
1688: if(approvers(i).authority = ame_util.authorityApprover and
1689: approvers(i).api_insertion = ame_util.oamGenerated and
1690: (approvers(i).approval_status is null or
1691: approvers(i).approval_status = ame_util.nullStatus)) then
1692:
1693: if approvers(i).orig_system = ame_util.posOrigSystem then
1694:
1695: if g_fnd_debug = 'Y' then

Line 1693: if approvers(i).orig_system = ame_util.posOrigSystem then

1689: approvers(i).api_insertion = ame_util.oamGenerated and
1690: (approvers(i).approval_status is null or
1691: approvers(i).approval_status = ame_util.nullStatus)) then
1692:
1693: if approvers(i).orig_system = ame_util.posOrigSystem then
1694:
1695: if g_fnd_debug = 'Y' then
1696: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
1697: FND_LOG.string(FND_LOG.level_statement, g_module_prefix || l_api_name, 'First record is Position Hierarchy action type...');

Line 1791: attributeNameIn => ame_util.allowDeletingOamApprovers,

1787: end if;
1788: ame_api3.getAttributeValue(applicationIdIn => applicationId,
1789: transactionTypeIn => ameTransactionType,
1790: transactionIdIn => pReqHeaderId,
1791: attributeNameIn => ame_util.allowDeletingOamApprovers,
1792: itemIdIn => NULL,
1793: attributeValue1Out => attributeValue1,
1794: attributeValue2Out => attributeValue2,
1795: attributeValue3Out => attributeValue3);

Line 1972: function serializeApproversTable( approversTableIn in ame_util.approversTable2,

1968: -- approverCount Total Number of approvers in the list.
1969: -- hasApprovalAction 'Y' or 'N'
1970: --End of Comments
1971: --------------------------------------------------------------------------------
1972: function serializeApproversTable( approversTableIn in ame_util.approversTable2,
1973: reqHeaderId in NUMBER,
1974: approverCount out nocopy number,
1975: hasApprovalAction out nocopy varchar2
1976: )

Line 2043: if (approversTableIn(i).orig_system = ame_util.perOrigSystem) then

2039:
2040:
2041: -- if we have a Emp-Sup approver, make sure the approverId
2042: -- is NOT the same as preparer's Id
2043: if (approversTableIn(i).orig_system = ame_util.perOrigSystem) then
2044: if (approversTableIn(i).orig_system_id = l_preparer_id) THEN
2045: l_valid_approver := 'N';
2046: if g_fnd_debug = 'Y' then
2047: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN

Line 2055: elsif (approversTableIn(i).orig_system = ame_util.posOrigSystem) then

2051: end if;
2052:
2053: -- else if we have a position approver, make sure the position
2054: -- is NOT the same as preparer's position
2055: elsif (approversTableIn(i).orig_system = ame_util.posOrigSystem) then
2056:
2057: SELECT POSITION_ID
2058: INTO l_preparer_pos_id
2059: FROM PER_ALL_ASSIGNMENTS_F

Line 2089: approversTableIn(i).approval_status<>ame_util.notifiedStatus AND

2085: -- then do not consider the record.
2086: -- (we want to consider notified, suppressed and approved records)
2087:
2088: if( approversTableIn(i).approval_status is not null AND
2089: approversTableIn(i).approval_status<>ame_util.notifiedStatus AND
2090: approversTableIn(i).approval_status<>ame_util.suppressedStatus AND
2091: approversTableIn(i).approval_status<>ame_util.approvedStatus) then
2092:
2093: hasApprovalAction := 'Y';

Line 2090: approversTableIn(i).approval_status<>ame_util.suppressedStatus AND

2086: -- (we want to consider notified, suppressed and approved records)
2087:
2088: if( approversTableIn(i).approval_status is not null AND
2089: approversTableIn(i).approval_status<>ame_util.notifiedStatus AND
2090: approversTableIn(i).approval_status<>ame_util.suppressedStatus AND
2091: approversTableIn(i).approval_status<>ame_util.approvedStatus) then
2092:
2093: hasApprovalAction := 'Y';
2094: if g_fnd_debug = 'Y' then

Line 2091: approversTableIn(i).approval_status<>ame_util.approvedStatus) then

2087:
2088: if( approversTableIn(i).approval_status is not null AND
2089: approversTableIn(i).approval_status<>ame_util.notifiedStatus AND
2090: approversTableIn(i).approval_status<>ame_util.suppressedStatus AND
2091: approversTableIn(i).approval_status<>ame_util.approvedStatus) then
2092:
2093: hasApprovalAction := 'Y';
2094: if g_fnd_debug = 'Y' then
2095: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN

Line 2147: if ( l_orig_system = ame_util.posOrigSystem ) then

2143: end if;
2144: end;
2145:
2146: -- Find position | job name
2147: if ( l_orig_system = ame_util.posOrigSystem ) then
2148: l_job_or_position := approversTableIn(i).display_name;
2149: else
2150: l_job_or_position := null;
2151: end if;

Line 2263: approverList ame_util.approversTable2;

2259: pApprovalListCount OUT NOCOPY NUMBER) IS
2260:
2261: l_api_name varchar2(50):= 'getAllApprovers';
2262: hasApprovalAction varchar2(1);
2263: approverList ame_util.approversTable2;
2264: l_process_out VARCHAR2(10);
2265:
2266: begin
2267:

Line 2330: approverList ame_util.approversTable2;

2326: pPosition IN NUMBER)
2327: return number IS
2328:
2329: l_api_name varchar2(50):= 'getAbsolutePosition';
2330: approverList ame_util.approversTable2;
2331: absolutePosition number := pPosition;
2332: numOfNullStatus number := 0;
2333: l_process_out VARCHAR2(10);
2334:

Line 2684: approverList ame_util.approversTable2;

2680:
2681: l_itemtype po_requisition_headers.wf_item_type%TYPE;
2682: l_itemkey po_requisition_headers.wf_item_key%TYPE;
2683:
2684: approverList ame_util.approversTable2;
2685: l_process_out VARCHAR2(10);
2686:
2687: l_full_name per_all_people_f.full_name%TYPE;
2688: l_person_id per_all_people_f.person_id%TYPE;

Line 2833: ame_util2.detailedApprovalStatusFlagYN := ame_util.booleanTrue;

2829: end if;
2830:
2831: -- If we are going to use the flag approvalProcessCompleteYNOut,
2832: -- then we have to set the following flag.
2833: ame_util2.detailedApprovalStatusFlagYN := ame_util.booleanTrue;
2834:
2835: ame_api2.getAllApprovers7( applicationIdIn => applicationId,
2836: transactionIdIn => pReqHeaderId,
2837: transactionTypeIn => ameTransactionType,

Line 2896: ( ame_util.notifiedByRepeatedStatus,

2892:
2893: if( ( ( l_process_out = 'Y' OR l_process_out = 'N' ) AND
2894: ( approverList(i).approval_status is not null AND
2895: ( approverList(i).approval_status not in
2896: ( ame_util.notifiedByRepeatedStatus,
2897: ame_util.approvedByRepeatedStatus,
2898: ame_util.rejectedByRepeatedStatus,
2899: ame_util.repeatedStatus,
2900: ame_util.noResponseStatus

Line 2897: ame_util.approvedByRepeatedStatus,

2893: if( ( ( l_process_out = 'Y' OR l_process_out = 'N' ) AND
2894: ( approverList(i).approval_status is not null AND
2895: ( approverList(i).approval_status not in
2896: ( ame_util.notifiedByRepeatedStatus,
2897: ame_util.approvedByRepeatedStatus,
2898: ame_util.rejectedByRepeatedStatus,
2899: ame_util.repeatedStatus,
2900: ame_util.noResponseStatus
2901: )

Line 2898: ame_util.rejectedByRepeatedStatus,

2894: ( approverList(i).approval_status is not null AND
2895: ( approverList(i).approval_status not in
2896: ( ame_util.notifiedByRepeatedStatus,
2897: ame_util.approvedByRepeatedStatus,
2898: ame_util.rejectedByRepeatedStatus,
2899: ame_util.repeatedStatus,
2900: ame_util.noResponseStatus
2901: )
2902: )

Line 2899: ame_util.repeatedStatus,

2895: ( approverList(i).approval_status not in
2896: ( ame_util.notifiedByRepeatedStatus,
2897: ame_util.approvedByRepeatedStatus,
2898: ame_util.rejectedByRepeatedStatus,
2899: ame_util.repeatedStatus,
2900: ame_util.noResponseStatus
2901: )
2902: )
2903: )

Line 2900: ame_util.noResponseStatus

2896: ( ame_util.notifiedByRepeatedStatus,
2897: ame_util.approvedByRepeatedStatus,
2898: ame_util.rejectedByRepeatedStatus,
2899: ame_util.repeatedStatus,
2900: ame_util.noResponseStatus
2901: )
2902: )
2903: )
2904: ) OR

Line 2908: ( ame_util.notifiedByRepeatedStatus,

2904: ) OR
2905: ( ( l_process_out = 'W' OR l_process_out = 'P' )AND
2906: ( approverList(i).approval_status is null OR
2907: ( approverList(i).approval_status not in
2908: ( ame_util.notifiedByRepeatedStatus,
2909: ame_util.approvedByRepeatedStatus,
2910: ame_util.rejectedByRepeatedStatus,
2911: ame_util.repeatedStatus,
2912: ame_util.noResponseStatus

Line 2909: ame_util.approvedByRepeatedStatus,

2905: ( ( l_process_out = 'W' OR l_process_out = 'P' )AND
2906: ( approverList(i).approval_status is null OR
2907: ( approverList(i).approval_status not in
2908: ( ame_util.notifiedByRepeatedStatus,
2909: ame_util.approvedByRepeatedStatus,
2910: ame_util.rejectedByRepeatedStatus,
2911: ame_util.repeatedStatus,
2912: ame_util.noResponseStatus
2913: )

Line 2910: ame_util.rejectedByRepeatedStatus,

2906: ( approverList(i).approval_status is null OR
2907: ( approverList(i).approval_status not in
2908: ( ame_util.notifiedByRepeatedStatus,
2909: ame_util.approvedByRepeatedStatus,
2910: ame_util.rejectedByRepeatedStatus,
2911: ame_util.repeatedStatus,
2912: ame_util.noResponseStatus
2913: )
2914: )

Line 2911: ame_util.repeatedStatus,

2907: ( approverList(i).approval_status not in
2908: ( ame_util.notifiedByRepeatedStatus,
2909: ame_util.approvedByRepeatedStatus,
2910: ame_util.rejectedByRepeatedStatus,
2911: ame_util.repeatedStatus,
2912: ame_util.noResponseStatus
2913: )
2914: )
2915: )

Line 2912: ame_util.noResponseStatus

2908: ( ame_util.notifiedByRepeatedStatus,
2909: ame_util.approvedByRepeatedStatus,
2910: ame_util.rejectedByRepeatedStatus,
2911: ame_util.repeatedStatus,
2912: ame_util.noResponseStatus
2913: )
2914: )
2915: )
2916: )

Line 2923: if ( l_orig_system = ame_util.perOrigSystem) then

2919: l_orig_system := approverList(i).orig_system;
2920: l_orig_system_id := approverList(i).orig_system_id;
2921: l_job_or_position := NULL;
2922:
2923: if ( l_orig_system = ame_util.perOrigSystem) then
2924:
2925: -- Employee Supervisor Record.
2926: if g_fnd_debug = 'Y' then
2927: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN

Line 2934: elsif ( l_orig_system = ame_util.posOrigSystem) then

2930: end if;
2931: l_full_name := approverList(i).display_name;
2932: l_person_id := l_orig_system_id;
2933:
2934: elsif ( l_orig_system = ame_util.posOrigSystem) then
2935:
2936: -- Position Hierarchy Record. The logic is mentioned in the comments section.
2937: if g_fnd_debug = 'Y' then
2938: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN

Line 2983: elsif (l_orig_system = ame_util.fndUserOrigSystem) then

2979: --RAISE;
2980: l_valid_approver := 'N';
2981: END;
2982:
2983: elsif (l_orig_system = ame_util.fndUserOrigSystem) then
2984:
2985: -- FND User Record.
2986: if g_fnd_debug = 'Y' then
2987: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN

Line 3010: if ( l_orig_system = ame_util.posOrigSystem ) then

3006: END IF;
3007: end if;
3008:
3009: -- Find position | job name
3010: if ( l_orig_system = ame_util.posOrigSystem ) then
3011: l_job_or_position := approverList(i).display_name;
3012: else
3013: l_job_or_position := null;
3014: end if;

Line 3134: l_approversList ame_util.approversTable2;

3130: l_itemkey po_requisition_headers.wf_item_key%TYPE;
3131: l_ameTransactionType po_document_types.ame_transaction_type%TYPE;
3132: l_completeYNO varchar2(100);
3133:
3134: l_approversList ame_util.approversTable2;
3135: l_approver_index NUMBER;
3136: l_preparer_id number;
3137: l_approverId number;
3138: l_approverName VARCHAR2(240);

Line 3175: and l_approversList(i).approver_category = ame_util.approvalApproverCategory ) then

3171: x_progress := '004';
3172:
3173: for i in 1 .. l_approversList.count loop
3174: if ( l_approversList(i).approval_status= 'NOTIFIED'
3175: and l_approversList(i).approver_category = ame_util.approvalApproverCategory ) then
3176:
3177: get_person_info( l_approversList(i).orig_system,
3178: l_approversList(i).orig_system_id,
3179: l_approversList(i).display_name,

Line 3256: if ( p_origSystem = ame_util.perOrigSystem) then

3252: FND_LOG.string(FND_LOG.level_statement, g_module_prefix || l_api_name, ' p_logFlag = ' || p_logFlag);
3253: END IF;
3254: end if;
3255:
3256: if ( p_origSystem = ame_util.perOrigSystem) then
3257:
3258: -- Employee Supervisor Record.
3259: if p_logFlag = 'Y' then
3260: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN

Line 3268: elsif ( p_origSystem = ame_util.posOrigSystem) then

3264:
3265: x_fullName := p_displayName;
3266: x_personId := p_origSystemId;
3267:
3268: elsif ( p_origSystem = ame_util.posOrigSystem) then
3269:
3270: -- Position Hierarchy Record.
3271: if p_logFlag = 'Y' then
3272: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN

Line 3330: elsif (p_origSystem = ame_util.fndUserOrigSystem) then

3326: WHERE rownum = 1;
3327:
3328: end if;
3329:
3330: elsif (p_origSystem = ame_util.fndUserOrigSystem) then
3331:
3332: -- FND User Record.
3333: if p_logFlag = 'Y' then
3334: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN