APPS.WF_ITEM_IMPORT dependencies on WF_ITEM_ACTIVITY_STATUSES

Line 26: -- wf_item_activity_statuses

22: from wf_ha_ntf_v v
23: where v.Item_type = X_Item_type
24: and v.Item_key = X_Item_key);
25:
26: -- wf_item_activity_statuses
27: delete from wf_item_activity_statuses
28: where Item_type = X_Item_type
29: and Item_key = X_Item_key;
30:

Line 27: delete from wf_item_activity_statuses

23: where v.Item_type = X_Item_type
24: and v.Item_key = X_Item_key);
25:
26: -- wf_item_activity_statuses
27: delete from wf_item_activity_statuses
28: where Item_type = X_Item_type
29: and Item_key = X_Item_key;
30:
31: -- wf_item_activity_statuses_h

Line 31: -- wf_item_activity_statuses_h

27: delete from wf_item_activity_statuses
28: where Item_type = X_Item_type
29: and Item_key = X_Item_key;
30:
31: -- wf_item_activity_statuses_h
32: delete from wf_item_activity_statuses_h
33: where Item_type = X_Item_type
34: and Item_key = X_Item_key;
35:

Line 32: delete from wf_item_activity_statuses_h

28: where Item_type = X_Item_type
29: and Item_key = X_Item_key;
30:
31: -- wf_item_activity_statuses_h
32: delete from wf_item_activity_statuses_h
33: where Item_type = X_Item_type
34: and Item_key = X_Item_key;
35:
36: -- wf_item_attributes

Line 113: -- repopulates WF_ITEM_ACTIVITY_STATUSES

109: X_DATE_VALUE
110: from dual;
111: end;
112:
113: -- repopulates WF_ITEM_ACTIVITY_STATUSES
114: procedure import_ias_row(
115: X_ITEM_TYPE VARCHAR2,
116: X_ITEM_KEY VARCHAR2,
117: X_PROCESS_ACTIVITY NUMBER,

Line 132: insert into WF_ITEM_ACTIVITY_STATUSES

128: X_OUTBOUND_QUEUE_ID VARCHAR2,
129: X_DUE_DATE DATE) is
130:
131: begin
132: insert into WF_ITEM_ACTIVITY_STATUSES
133: (ITEM_TYPE, ITEM_KEY, PROCESS_ACTIVITY, ACTIVITY_STATUS,
134: ACTIVITY_RESULT_CODE, ASSIGNED_USER, NOTIFICATION_ID, BEGIN_DATE,
135: END_DATE, EXECUTION_TIME, ERROR_NAME, ERROR_MESSAGE,
136: ERROR_STACK, OUTBOUND_QUEUE_ID, DUE_DATE)

Line 144: -- repopulates WF_ITEM_ACTIVITY_STATUSES_H

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(
146: X_ITEM_TYPE VARCHAR2,
147: X_ITEM_KEY VARCHAR2,
148: X_PROCESS_ACTIVITY NUMBER,

Line 163: insert into WF_ITEM_ACTIVITY_STATUSES_H

159: X_OUTBOUND_QUEUE_ID VARCHAR2,
160: X_DUE_DATE DATE) is
161:
162: begin
163: insert into WF_ITEM_ACTIVITY_STATUSES_H
164: (ITEM_TYPE, ITEM_KEY, PROCESS_ACTIVITY, ACTIVITY_STATUS,
165: ACTIVITY_RESULT_CODE, ASSIGNED_USER, NOTIFICATION_ID, BEGIN_DATE,
166: END_DATE, EXECUTION_TIME, ERROR_NAME, ERROR_MESSAGE,
167: ERROR_STACK, OUTBOUND_QUEUE_ID, DUE_DATE)