APPS.WF_ITEM_IMPORT dependencies on DUAL

Line 71: from dual;

67: BEGIN_DATE, END_DATE, USER_KEY, HA_MIGRATION_FLAG)
68: select X_ITEM_TYPE, X_ITEM_KEY, X_ROOT_ACTIVITY, X_ROOT_ACTIVITY_VERSION,
69: X_OWNER_ROLE, X_PARENT_ITEM_TYPE, X_PARENT_ITEM_KEY, X_PARENT_CONTEXT,
70: X_BEGIN_DATE, X_END_DATE, X_USER_KEY, X_HA_MIGRATION_FLAG
71: from dual;
72: end;
73:
74: -- repopulates WF_ITEM_ATTRIBUTE_VALUES
75: procedure import_item_attr_row(

Line 90: from dual;

86: (ITEM_TYPE, ITEM_KEY, NAME, TEXT_VALUE, NUMBER_VALUE, DATE_VALUE,
87: EVENT_VALUE)
88: select X_ITEM_TYPE, X_ITEM_KEY, X_NAME, X_TEXT_VALUE, X_NUMBER_VALUE,
89: X_DATE_VALUE, X_EVENT_VALUE
90: from dual;
91: end;
92:
93: -- repopulates WF_ITEM_ATTRIBUTES
94: procedure import_item_attr_row(

Line 110: from dual;

106: insert into WF_ITEM_ATTRIBUTE_VALUES
107: (ITEM_TYPE, ITEM_KEY, NAME, TEXT_VALUE, NUMBER_VALUE, DATE_VALUE)
108: select X_ITEM_TYPE, X_ITEM_KEY, X_NAME, X_TEXT_VALUE, X_NUMBER_VALUE,
109: X_DATE_VALUE
110: from dual;
111: end;
112:
113: -- repopulates WF_ITEM_ACTIVITY_STATUSES
114: procedure import_ias_row(

Line 141: from dual;

137: select X_ITEM_TYPE, X_ITEM_KEY, X_PROCESS_ACTIVITY, X_ACTIVITY_STATUS,
138: X_ACTIVITY_RESULT_CODE, X_ASSIGNED_USER, X_NOTIFICATION_ID, X_BEGIN_DATE,
139: X_END_DATE, X_EXECUTION_TIME, X_ERROR_NAME, X_ERROR_MESSAGE,
140: X_ERROR_STACK, hextoraw(X_OUTBOUND_QUEUE_ID), X_DUE_DATE
141: from dual;
142: end;
143:
144: -- repopulates WF_ITEM_ACTIVITY_STATUSES_H
145: procedure import_iash_row(

Line 172: from dual;

168: select X_ITEM_TYPE, X_ITEM_KEY, X_PROCESS_ACTIVITY, X_ACTIVITY_STATUS,
169: X_ACTIVITY_RESULT_CODE, X_ASSIGNED_USER, X_NOTIFICATION_ID, X_BEGIN_DATE,
170: X_END_DATE, X_EXECUTION_TIME, X_ERROR_NAME, X_ERROR_MESSAGE,
171: X_ERROR_STACK, hextoraw(X_OUTBOUND_QUEUE_ID), X_DUE_DATE
172: from dual;
173: end;
174:
175: -- repopulates WF_NOTIFICATIONS
176: procedure import_ntf_row(

Line 212: from dual;

208: X_RECIPIENT_ROLE, X_STATUS, X_ACCESS_KEY, X_MAIL_STATUS, X_PRIORITY,
209: X_BEGIN_DATE, X_END_DATE, X_DUE_DATE, X_RESPONDER, X_USER_COMMENT,
210: X_CALLBACK, X_CONTEXT, X_ORIGINAL_RECIPIENT, X_FROM_USER, X_TO_USER,
211: X_SUBJECT, X_LANGUAGE, X_MORE_INFO_ROLE
212: from dual;
213: end;
214:
215:
216:

Line 230: from dual;

226: insert into WF_NOTIFICATION_ATTRIBUTES
227: (NOTIFICATION_ID, NAME, TEXT_VALUE, NUMBER_VALUE, DATE_VALUE)
228: select X_NOTIFICATION_ID, X_NAME, X_TEXT_VALUE, X_NUMBER_VALUE,
229: X_DATE_VALUE
230: from dual;
231: end;
232:
233: -- helper function to get around limitation of maps
234: procedure raw2hex(myraw in raw, myhex out nocopy varchar2) is