[Home] [Help]
PACKAGE: APPS.EDR_CONSTANTS_GRP
Source
1 PACKAGE EDR_CONSTANTS_GRP AS
2 /* $Header: EDRGCONS.pls 120.3.12000000.1 2007/01/18 05:53:23 appldev ship $
3
4 /* Global Constants */
5
6 -- status codes --
7
8 -- These are different statuses that are returned to the calling code
9 -- from ERES Framework to indicate the status of the ERES processing
10
11 -- All the code using these constants and the cookbook need to be changed
12 -- if any chages are made
13
14 g_error_status CONSTANT VARCHAR2(20) := 'ERROR';
15 g_pending_status CONSTANT VARCHAR2(20) := 'PENDING';
16 g_no_action_status CONSTANT VARCHAR2(20) := 'NOACTION';
17 g_complete_status CONSTANT VARCHAR2(20) := 'COMPLETE';
18 g_indetermined_status CONSTANT VARCHAR2(20) := 'INDETERMINED';
19
20 -- mandatory payload parameter names --
21
22 -- These are the names of the parameters that are REQUIRED to be present
23 -- in the payload at the time of raising an ERES event
24
25 g_deferred_param CONSTANT VARCHAR2(30) := 'DEFERRED';
26 g_postop_param CONSTANT VARCHAR2(30) := 'POST_OPERATION_API';
27 g_user_label_param CONSTANT VARCHAR2(30) := 'PSIG_USER_KEY_LABEL';
28 g_user_value_param CONSTANT VARCHAR2(30) := 'PSIG_USER_KEY_VALUE';
29 g_audit_param CONSTANT VARCHAR2(30) := 'PSIG_TRANSACTION_AUDIT_ID';
30 g_source_param CONSTANT VARCHAR2(30) := '#WF_SOURCE_APPLICATION_TYPE';
31 g_requester_param CONSTANT VARCHAR2(30) := '#WF_SIGN_REQUESTER';
32
33 -- additional payload parameter names --
34
35 -- These are additional parameters that are added to the payload implicitly at the
36 -- time of raising an event by the ERES code itself
37
38 g_wf_pageflow_itemtype_attr CONSTANT VARCHAR2(30) := '#WF_PAGEFLOW_ITEMTYPE';
39 g_wf_pageflow_itemkey_attr CONSTANT VARCHAR2(30) := '#WF_PAGEFLOW_ITEMKEY';
40 g_erecord_id_attr CONSTANT VARCHAR2(15) := '#ERECORD_ID';
41
42 -- These are additional mandatory parameters required to be present in the payload
43 -- if the event is a child event in the context of an inter event relationship
44
45 g_parent_event_name CONSTANT VARCHAR2(30) := 'PARENT_EVENT_NAME';
46 g_parent_event_key CONSTANT VARCHAR2(30) := 'PARENT_EVENT_KEY';
47 g_parent_erecord_id CONSTANT VARCHAR2(30) := 'PARENT_ERECORD_ID';
48
49 -- relationship record group column name --
50
51 g_child_event_name CONSTANT VARCHAR2(30) := 'CHILD_EVENT_NAME';
52 g_child_event_key CONSTANT VARCHAR2(30) := 'CHILD_EVENT_KEY';
53 g_child_erecord_id CONSTANT VARCHAR2(30) := 'CHILD_ERECORD_ID';
54
55 -- attachment entity name --
56 g_erecord_entity_name CONSTANT VARCHAR2(15) := 'ERECORD';
57
58 -- susbcription parameter values for establishing inter event relationships --
59 g_evaluate_normal CONSTANT VARCHAR2(30) := 'EVALUATE_NORMAL';
60 g_erecord_only CONSTANT VARCHAR2(30) := 'ERECORD_ONLY';
61 g_ignore_signature CONSTANT VARCHAR2(30) := 'IGNORE_SIGNATURE';
62
63 -- payload parameter count --
64 g_param_count CONSTANT PLS_INTEGER := 7;
65 g_inter_event_param_count CONSTANT PLS_INTEGER := 3;
66
67 -- payload parameters values --
68 g_forms_mode CONSTANT VARCHAR2(15) := 'FORMS';
69 g_db_mode CONSTANT VARCHAR2(15) := 'DB';
70 g_msca_mode CONSTANT VARCHAR2(15) := 'MSCA';
71 g_change_signer_adhoc CONSTANT VARCHAR2(15) := 'ADHOC';
72 g_oaf_mode CONSTANT VARCHAR2(15) := 'SSWA';
73 g_default_char_param_value CONSTANT VARCHAR2(15) := 'NONE';
74 g_default_num_param_value CONSTANT NUMBER := -1;
75
76
77 -- mode of inter event processing --
78 g_strict_mode CONSTANT VARCHAR2(20) := 'STRICT';
79
80 -- name of the standard ERES rule function --
81 g_rule_function CONSTANT VARCHAR2(240) := 'EDR_PSIG_RULE.PSIG_RULE';
82
83 -- transaction acknowledgement statuses --
84 g_success_ack_status CONSTANT VARCHAR2(30) := 'SUCCESS';
85 g_error_ack_status CONSTANT VARCHAR2(30) := 'ERROR';
86 g_no_ack_status CONSTANT VARCHAR2(30) := 'NOTACKNOWLEDGED';
87 g_migration_ack_status CONSTANT VARCHAR2(30) := 'NOTCOLLECTED';
88
89
90 -- mode of the redling --
91 g_redline_mode CONSTANT VARCHAR2(30) := 'REDLINE';
92 g_redline_with_appendix_mode CONSTANT VARCHAR2(30) := 'REDLINE_WITH_APPENDIX';
93
94 --Bug 4122622: Start
95 G_TEMP_PARAM_LIST FND_WF_EVENT.PARAM_TABLE;
96 --This would hold a constant empty parameter list variable.
97 G_EMPTY_PARAM_LIST CONSTANT FND_WF_EVENT.PARAM_TABLE := G_TEMP_PARAM_LIST;
98
99 --The child e-record IDs attribute value set on the event.
100 G_CHILD_ERECORD_IDS CONSTANT VARCHAR2(30) := 'CHILD_ERECORD_IDS';
101
102
103 G_DEFAULT_CHAR_ID_VALUE CONSTANT NUMBER := '-1';
104 --Bug 4122622: End
105
106 --Bug 4150616: Start
107 G_FORCE_ERECORD CONSTANT VARCHAR2(30) := 'FORCE_ERECORD';
108 G_FORCE_ERECORD_USED CONSTANT VARCHAR2(30) := 'FORCE_ERECORD_USED';
109 --Bug 4150616: End
110
111 --Bug 3207385: Start
112 G_ORIGINAL_EVENT_NAME CONSTANT VARCHAR2(30) := 'ORIGINAL_EVENT_NAME';
113 G_ORIGINAL_EVENT_KEY CONSTANT VARCHAR2(30) := 'ORIGINAL_EVENT_KEY';
114 G_ERECORD_ID CONSTANT VARCHAR2(30) := 'ERECORD_ID';
115 G_EVENT_STATUS CONSTANT VARCHAR2(30) := 'EVENT_STATUS';
116 G_NO_ERES_STATUS CONSTANT VARCHAR2(30) := 'NO_ERES';
117 G_CANCEL_STATUS CONSTANT VARCHAR2(30) := 'CANCEL';
118 G_FINAL_DOCUMENT_STATUS CONSTANT VARCHAR2(30) := 'FINAL_DOCUMENT_STATUS';
119 G_APPROVAL_COMPLETION_EVT CONSTANT VARCHAR2(40) := 'oracle.apps.edr.approvalcompletion';
120 --Bug 3207385: End
121
122 --Bug 4160412: Start
123 G_SIGNATURE_MODE CONSTANT VARCHAR2(30) := 'SIGNATURE_MODE';
124 G_SIGNATURE_MODE_VALUE CONSTANT VARCHAR2(30) := 'SIGNATURE_MODE_VALUE';
125 G_APPROVER_COUNT CONSTANT VARCHAR2(30) := 'APPROVER_COUNT';
126 G_APPROVER_LIST CONSTANT VARCHAR2(30) := 'APPROVER_LIST';
127 G_EINITIALS_DEFER_MODE CONSTANT VARCHAR2(30) := 'EINITIALS_DEFER_MODE';
128 G_DO_RESPS_EXIST CONSTANT VARCHAR2(30) := 'DO_RESPS_EXIST';
129 G_ERECORD_XML_HEADER CONSTANT VARCHAR2(60) := '<?xml version="1.0" encoding="utf-8"?><ERecord>';
130 G_ERECORD_XML_FOOTER CONSTANT VARCHAR2(30) := '</ERecord>';
131 --Bug 4160412: End
132
133 -- Bug 4450651 Start For Http Service Ticket
134 g_service_name CONSTANT VARCHAR2(30) := 'EDR_HTTP_SERVICE_TICKET';
135 g_fail_service_req_status CONSTANT VARCHAR2(20) := 'FAIL';
136 g_success_service_req_status CONSTANT VARCHAR2(30) := 'SUCCESS';
137 -- Bug 4450651 End
138
139 --Bug 4543216: Start
140 G_ERES_LITE CONSTANT VARCHAR2(30) := 'SHORT';
141 G_ERES_REGULAR CONSTANT VARCHAR2(30) := 'FULL';
142 --bUG 4543216: End
143
144 end EDR_CONSTANTS_GRP;