PACKAGE: APPS.WF_ITEM_IMPORT

Source

1 package wf_item_import AUTHID CURRENT_USER as
2 /* $Header: WFHAIMPS.pls 120.2 2005/10/18 12:44:22 mfisher ship $ */
3 
4 -- Removes all trace of rows related to X_Item_type/X_Item_key from
5 -- Runtime tables
6 
7 procedure erase(X_Item_type VARCHAR2, X_Item_key VARCHAR2);
8 
9 -- repopulates WF_ITEMS
10 procedure import_item_row(
11  X_ITEM_TYPE VARCHAR2,
12  X_ITEM_KEY  VARCHAR2,
13  X_ROOT_ACTIVITY VARCHAR2,
14  X_ROOT_ACTIVITY_VERSION NUMBER,
15  X_OWNER_ROLE VARCHAR2,
16  X_PARENT_ITEM_TYPE VARCHAR2,
17  X_PARENT_ITEM_KEY VARCHAR2,
18  X_PARENT_CONTEXT VARCHAR2,
19  X_BEGIN_DATE DATE,
20  X_END_DATE DATE,
21  X_USER_KEY VARCHAR2,
22  X_HA_MIGRATION_FLAG VARCHAR2);
23 
24 -- repopulates WF_ITEM_ATTRIBUTES
25 procedure import_item_attr_row(
26  X_ITEM_TYPE VARCHAR2,
27  X_ITEM_KEY  VARCHAR2,
28  X_NAME      VARCHAR2,
29  X_TEXT_VALUE VARCHAR2,
30  X_NUMBER_VALUE NUMBER,
31  X_DATE_VALUE   DATE,
32  X_EVENT_VALUE  WF_EVENT_T);
33 
34 -- repopulates WF_ITEM_ATTRIBUTES
35 procedure import_item_attr_row(
36  X_ITEM_TYPE VARCHAR2,
37  X_ITEM_KEY  VARCHAR2,
38  X_NAME      VARCHAR2,
39  X_TEXT_VALUE VARCHAR2,
40  X_NUMBER_VALUE NUMBER,
41  X_DATE_VALUE   DATE,
42  X_EVENT_VALUE  Number);  -- overload hack until we support events
43 
44 -- repopulates WF_ITEM_ACTIVITY_STATUSES
45 procedure import_ias_row(
46  X_ITEM_TYPE             VARCHAR2,
47  X_ITEM_KEY              VARCHAR2,
48  X_PROCESS_ACTIVITY      NUMBER,
49  X_ACTIVITY_STATUS       VARCHAR2,
50  X_ACTIVITY_RESULT_CODE  VARCHAR2,
51  X_ASSIGNED_USER         VARCHAR2,
52  X_NOTIFICATION_ID       NUMBER,
53  X_BEGIN_DATE            DATE,
54  X_END_DATE              DATE,
55  X_EXECUTION_TIME        NUMBER,
56  X_ERROR_NAME            VARCHAR2,
57  X_ERROR_MESSAGE         VARCHAR2,
58  X_ERROR_STACK           VARCHAR2,
59  X_OUTBOUND_QUEUE_ID     VARCHAR2,
60  X_DUE_DATE              DATE);
61 
62 -- repopulates WF_ITEM_ACTIVITY_STATUSES_H
63 procedure import_iash_row(
64  X_ITEM_TYPE            VARCHAR2,
65  X_ITEM_KEY             VARCHAR2,
66  X_PROCESS_ACTIVITY     NUMBER,
67  X_ACTIVITY_STATUS      VARCHAR2,
68  X_ACTIVITY_RESULT_CODE VARCHAR2,
69  X_ASSIGNED_USER        VARCHAR2,
70  X_NOTIFICATION_ID      NUMBER,
71  X_BEGIN_DATE           DATE,
72  X_END_DATE             DATE,
73  X_EXECUTION_TIME       NUMBER,
74  X_ERROR_NAME           VARCHAR2,
75  X_ERROR_MESSAGE        VARCHAR2,
76  X_ERROR_STACK          VARCHAR2,
77  X_OUTBOUND_QUEUE_ID    VARCHAR2,
78  X_DUE_DATE             DATE);
79 
80 -- repopulates WF_NOTIFICATIONS
81 procedure import_ntf_row(
82  X_NOTIFICATION_ID NUMBER,
83  X_GROUP_ID        NUMBER,
84  X_MESSAGE_TYPE    VARCHAR2,
85  X_MESSAGE_NAME    VARCHAR2,
86  X_RECIPIENT_ROLE  VARCHAR2,
87  X_STATUS          VARCHAR2,
88  X_ACCESS_KEY      VARCHAR2,
89  X_MAIL_STATUS     VARCHAR2,
90  X_PRIORITY        NUMBER,
91  X_BEGIN_DATE      DATE,
92  X_END_DATE        DATE,
93  X_DUE_DATE        DATE,
94  X_RESPONDER       VARCHAR2,
95  X_USER_COMMENT    VARCHAR2,
96  X_CALLBACK        VARCHAR2,
97  X_CONTEXT         VARCHAR2,
98  X_ORIGINAL_RECIPIENT VARCHAR2,
99  X_FROM_USER       VARCHAR2,
100  X_TO_USER         VARCHAR2,
101  X_SUBJECT         VARCHAR2,
102  X_LANGUAGE        VARCHAR2,
103  X_MORE_INFO_ROLE  VARCHAR2);
104 
105 -- repopulates WF_NOTIFICATION_ATTRIBUTES
106 procedure import_ntf_attr_row(
107  X_NOTIFICATION_ID NUMBER,
108  X_NAME            VARCHAR2,
109  X_TEXT_VALUE      VARCHAR2,
110  X_NUMBER_VALUE    NUMBER,
111  X_DATE_VALUE      DATE);
112 
113 
114 -- helper function to get around limitation of maps
115 procedure raw2hex(myraw in raw, myhex out nocopy varchar2);
116 
117 end;