DBA Data[Home] [Help]

APPS.AME_API6 dependencies on AME_APPROVER_TYPE_PKG

Line 108: approversOut(tempIndex).display_name := ame_approver_type_pkg.getApproverDisplayName4(nameIn => approver.name);

104: for approver in approversCursor(applicationIdIn => ameApplicationId
105: ,transactionIdIn => transactionIdIn) loop
106: tempIndex := tempIndex + 1;
107: approversOut(tempIndex).name := approver.name;
108: approversOut(tempIndex).display_name := ame_approver_type_pkg.getApproverDisplayName4(nameIn => approver.name);
109: approversOut(tempIndex).item_class := approver.item_class;
110: approversOut(tempIndex).item_id := approver.item_id;
111: approversOut(tempIndex).approver_category := approver.category;
112: approversOut(tempIndex).authority := approver.authority;

Line 121: ame_approver_type_pkg.getApproverOrigSystemAndId

117: approversOut(tempIndex).approver_order_number := approver.order_number;
118: approversOut(tempIndex).api_insertion := approver.api_insertion;
119: approversOut(tempIndex).member_order_number := approver.member_order_number;
120: begin
121: ame_approver_type_pkg.getApproverOrigSystemAndId
122: (nameIn => approver.name
123: ,origSystemOut => approversOut(tempIndex).orig_system
124: ,origSystemIdOut => approversOut(tempIndex).orig_system_id);
125: /*

Line 226: ame_approver_type_pkg.getOrigSystemIdAndDisplayName(nameIn =>approver.name,

222: approver.action_type_id :=actionTypeIdIn ;
223: approver.group_or_chain_id := groupOrChainIdIn;
224: approver.occurrence := occurrenceIn;
225: begin
226: ame_approver_type_pkg.getOrigSystemIdAndDisplayName(nameIn =>approver.name,
227: origSystemOut => approver.orig_system,
228: origSystemIdOut => approver.orig_system_id,
229: displayNameOut => approver.display_name);
230: exception

Line 280: ,ame_approver_type_pkg.getapproverdisplayname4 (ol.name) display_name

276: l_valid varchar2(50);
277: l_display_name varchar2(200);
278: cursor approversCursor is
279: SELECT ol.name
280: ,ame_approver_type_pkg.getapproverdisplayname4 (ol.name) display_name
281: ,ol.approval_status
282: ,ol.approver_category
283: ,ol.authority
284: ,ol.action_type_id

Line 341: AND lookup3.lookup_code (+) = ame_approver_type_pkg.getapproverorigsystem3 (ol.name)

337: AND fnd_application_id = applicationIdIn
338: AND transaction_type_id = transactionTypeIn
339: )
340: AND lookup3.lookup_type (+) = 'FND_WF_ORIG_SYSTEMS'
341: AND lookup3.lookup_code (+) = ame_approver_type_pkg.getapproverorigsystem3 (ol.name)
342: AND h.row_timestamp =
343: (
344: SELECT max (b.row_timestamp)
345: FROM ame_trans_approval_history b

Line 360: ,ame_approver_type_pkg.getapproverdisplayname4 (ol.name) display_name

356: AND b.date_cleared IS NULL
357: )
358: UNION
359: SELECT ol.name
360: ,ame_approver_type_pkg.getapproverdisplayname4 (ol.name) display_name
361: ,ol.approval_status
362: ,ol.approver_category
363: ,ol.authority
364: ,ol.action_type_id

Line 405: AND lookup3.lookup_code (+) = ame_approver_type_pkg.getapproverorigsystem3 (ol.name)

401: AND lookup2.lookup_type = 'AME_APPROVER_CATEGORY'
402: AND ol.approver_category = lookup2.lookup_code
403: AND apg.approval_group_id (+) = ol.group_or_chain_id
404: AND lookup3.lookup_type (+) = 'FND_WF_ORIG_SYSTEMS'
405: AND lookup3.lookup_code (+) = ame_approver_type_pkg.getapproverorigsystem3 (ol.name)
406: AND (
407: ol.approval_status IS NULL
408: OR ol.approval_status = 'APPROVE AND FORWARD'
409: OR ol.approval_status = 'APPROVE'

Line 440: ame_approver_type_pkg.getApproverOrigSystemAndId

436: approversOut(tempIndex).action_type_id := approver.action_type_id;
437: approversOut(tempIndex).group_or_chain_id := approver.group_or_chain_id;
438:
439: begin
440: ame_approver_type_pkg.getApproverOrigSystemAndId
441: (nameIn => approver.name
442: ,origSystemOut => approversOut(tempIndex).orig_system
443: ,origSystemIdOut => approversOut(tempIndex).orig_system_id);
444: /*