APPS.EDR_PSIG_RULE dependencies on EDR_UTILITIES

Line 20: (p_approver_list IN EDR_UTILITIES.approvers_Table,

16: ------------------------------------------------------------------------------
17: --Bug 4577122: Start
18:
19: procedure validate_voting_regime
20: (p_approver_list IN EDR_UTILITIES.approvers_Table,
21: x_valid_regime OUT NOCOPY VARCHAR2,
22: x_voting_regime OUT NOCOPY VARCHAR2)
23: as
24: G_UNVIABLE_NUMBER constant number := -1984;

Line 147: P_approverlist in EDR_UTILITIES.approvers_Table,

143: p_ame_transaction_type in varchar2,
144: p_audit_group in varchar2,
145: p_eventP in out NOCOPY wf_event_t,
146: p_subscription_guid in raw,
147: P_approverlist in EDR_UTILITIES.approvers_Table,
148: P_ERR_CODE out NOCOPY varchar2,
149: P_ERR_MSG out NOCOPY varchar2
150:
151: ) return varchar2 IS PRAGMA AUTONOMOUS_TRANSACTION;

Line 1497: approverList EDR_UTILITIES.approvers_Table;

1493: l_application_id NUMBER;
1494: l_application_code varchar2(32);
1495:
1496: -- using EDR approvers table
1497: approverList EDR_UTILITIES.approvers_Table;
1498:
1499: upperLimit integer;
1500: i integer;
1501: l_esign_required varchar2(1);

Line 1534: l_ruleids edr_utilities.id_List;

1530: l_requester varchar2(240);
1531: l_transaction_name varchar2(240);
1532:
1533: --Using EDR idList and stringList types
1534: l_ruleids edr_utilities.id_List;
1535: l_rulenames edr_utilities.string_List;
1536:
1537: l_application_name varchar2(240);
1538:

Line 1535: l_rulenames edr_utilities.string_List;

1531: l_transaction_name varchar2(240);
1532:
1533: --Using EDR idList and stringList types
1534: l_ruleids edr_utilities.id_List;
1535: l_rulenames edr_utilities.string_List;
1536:
1537: l_application_name varchar2(240);
1538:
1539: l_rulevalues EDR_STANDARD.ameruleinputvalues;

Line 1634: L_CUSTOM_APPROVER_LIST EDR_UTILITIES.APPROVERS_TABLE;

1630: L_APPROVER_COUNT VARCHAR2(128);
1631: L_APPROVER_LIST VARCHAR2(4000);
1632: L_ARE_APPROVERS_VALID VARCHAR2(1);
1633: L_INVALID_APPROVERS VARCHAR2(4000);
1634: L_CUSTOM_APPROVER_LIST EDR_UTILITIES.APPROVERS_TABLE;
1635: L_APPROVER_COUNT_VALUE NUMBER;
1636: L_LIST_COUNT NUMBER;
1637: L_TEMP_COUNT NUMBER;
1638: L_LITE_MODE BOOLEAN;

Line 2107: EDR_UTILITIES.GET_APPROVERS(P_APPLICATION_ID => l_application_id,

2103: if (l_inter_event_mode = 'Y' and l_relationship = EDR_CONSTANTS_GRP.g_erecord_only) then
2104: l_trans_value_only := 'Y';
2105: wf_log_pkg.string(1, 'EDR_PSIG_RULE.psig_rule','no need to find out approvers form ame as interevent relationship forces erecord_only');
2106: else
2107: EDR_UTILITIES.GET_APPROVERS(P_APPLICATION_ID => l_application_id,
2108: P_TRANSACTION_ID => p_event.getEventKey(),
2109: P_TRANSACTION_TYPE => NVL(l_ame_transaction_type,p_event.getEventName()),
2110: X_approvers => approverList,
2111: X_rule_Ids => l_ruleids,

Line 2587: edr_utilities.replace_user_data_token(l_xml_document);

2583: --Bug 3437422: Start
2584: --call an api that would find out of the xml contains the user_data
2585: --placeholder and replace it with the actual contents of the user_data
2586: --node.
2587: edr_utilities.replace_user_data_token(l_xml_document);
2588: --Bug 3437422: End
2589: --To make eRecord generation storing autonomous
2590: --Moved all of the following code in this IF clause
2591: --to STROE_ERECORD Local Procedure

Line 2742: EDR_UTILITIES.GET_APPROVER_LIST(P_APPROVING_USERS => L_APPROVER_LIST,

2738: );
2739: end if;
2740: --Diagnostics End
2741:
2742: EDR_UTILITIES.GET_APPROVER_LIST(P_APPROVING_USERS => L_APPROVER_LIST,
2743: X_APPROVER_LIST => L_CUSTOM_APPROVER_LIST,
2744: X_ARE_APPROVERS_VALID => L_ARE_APPROVERS_VALID,
2745: X_INVALID_APPROVERS => L_INVALID_APPROVERS);
2746:

Line 2747: l_repeating_approvers := EDR_UTILITIES.ARE_APPROVERS_REPEATING(P_APPROVER_LIST => L_CUSTOM_APPROVER_LIST);

2743: X_APPROVER_LIST => L_CUSTOM_APPROVER_LIST,
2744: X_ARE_APPROVERS_VALID => L_ARE_APPROVERS_VALID,
2745: X_INVALID_APPROVERS => L_INVALID_APPROVERS);
2746:
2747: l_repeating_approvers := EDR_UTILITIES.ARE_APPROVERS_REPEATING(P_APPROVER_LIST => L_CUSTOM_APPROVER_LIST);
2748:
2749: --If there are repeating approvers then raise an exception
2750: if l_repeating_approvers then
2751: raise REPEATING_APPROVERS_ERR;