1 PACKAGE CN_MODULES_PKG AUTHID CURRENT_USER AS
2 -- $Header: cnsymods.pls 120.4 2005/09/22 07:57:49 vensrini noship $
3
4
5 --+
6 -- Procedure Name
7 -- sync_module
8 -- Purpose
9 -- Generate a module for a Commissions function.
10 -- History
11 --+
12
13 PROCEDURE sync_module (
14 x_module_id NUMBER,
15 x_module_status IN OUT NOCOPY VARCHAR2);
16
17
18 --+
19 -- Procedure Name
20 -- unsync_module
21 -- Purpose
22 -- Mark a module as UNSYNC.
23 -- History
24 --+
25 PROCEDURE unsync_module (
26 x_module_id NUMBER,
27 x_module_status IN OUT NOCOPY VARCHAR2,
28 x_org_id IN NUMBER);
29
30 procedure INSERT_ROW (
31 X_ROWID in out nocopy VARCHAR2,
32 X_MODULE_ID in NUMBER,
33 X_MODULE_TYPE in VARCHAR2,
34 X_REPOSITORY_ID in NUMBER,
35 X_DESCRIPTION in VARCHAR2,
36 X_PARENT_MODULE_ID in NUMBER,
37 X_SOURCE_REPOSITORY_ID in NUMBER,
38 X_MODULE_STATUS in VARCHAR2,
39 X_EVENT_ID in NUMBER,
40 X_LAST_MODIFICATION in DATE,
41 X_LAST_SYNCHRONIZATION in DATE,
42 X_OUTPUT_FILENAME in VARCHAR2,
43 X_COLLECT_FLAG in VARCHAR2,
44 X_NAME in VARCHAR2,
45 X_CREATION_DATE in DATE,
46 X_CREATED_BY in NUMBER,
47 X_LAST_UPDATE_DATE in DATE,
48 X_LAST_UPDATED_BY in NUMBER,
49 X_LAST_UPDATE_LOGIN in NUMBER,
50 X_ORG_ID in NUMBER -- Modified For R12 MOAC
51 );
52
53 procedure LOCK_ROW (
54 X_MODULE_ID in NUMBER,
55 X_MODULE_TYPE in VARCHAR2,
56 X_REPOSITORY_ID in NUMBER,
57 X_DESCRIPTION in VARCHAR2,
58 X_PARENT_MODULE_ID in NUMBER,
59 X_SOURCE_REPOSITORY_ID in NUMBER,
60 X_MODULE_STATUS in VARCHAR2,
61 X_EVENT_ID in NUMBER,
62 X_LAST_MODIFICATION in DATE,
63 X_LAST_SYNCHRONIZATION in DATE,
64 X_OUTPUT_FILENAME in VARCHAR2,
65 X_COLLECT_FLAG in VARCHAR2,
66 X_NAME in VARCHAR2,
67 X_ORG_ID IN NUMBER -- Modified For R12 MOAC
68 );
69
70 procedure UPDATE_ROW (
71 X_MODULE_ID in NUMBER := FND_API.G_MISS_NUM,
72 X_MODULE_TYPE in VARCHAR2 := FND_API.G_MISS_CHAR,
73 X_REPOSITORY_ID in NUMBER := FND_API.G_MISS_NUM,
74 X_DESCRIPTION in VARCHAR2 := FND_API.G_MISS_CHAR,
75 X_PARENT_MODULE_ID in NUMBER := FND_API.G_MISS_NUM,
76 X_SOURCE_REPOSITORY_ID in NUMBER := FND_API.G_MISS_NUM,
77 X_MODULE_STATUS in VARCHAR2 := FND_API.G_MISS_CHAR,
78 X_EVENT_ID in NUMBER := FND_API.G_MISS_NUM,
79 X_LAST_MODIFICATION in DATE := FND_API.G_MISS_DATE,
80 X_LAST_SYNCHRONIZATION in DATE := FND_API.G_MISS_DATE,
81 X_OUTPUT_FILENAME in VARCHAR2 := FND_API.G_MISS_CHAR,
82 X_COLLECT_FLAG in VARCHAR2 := FND_API.G_MISS_CHAR,
83 X_NAME in VARCHAR2 := FND_API.G_MISS_CHAR,
84 X_LAST_UPDATE_DATE in DATE := FND_API.G_MISS_DATE,
85 X_LAST_UPDATED_BY in NUMBER := FND_API.G_MISS_NUM,
86 X_LAST_UPDATE_LOGIN in NUMBER := FND_API.G_MISS_NUM,
87 X_ORG_ID IN NUMBER := FND_API.G_MISS_NUM -- Modified For R12 MOAC
88 );
89
90 procedure DELETE_ROW (
91 X_MODULE_ID in NUMBER,
92 X_ORG_ID IN NUMBER -- Modified For R12 MOAC
93 );
94
95 procedure ADD_LANGUAGE;
96
97
98 -- --------------------------------------------------------------------+
99 -- Procedure : LOAD_ROW
100 -- Description : Called by FNDLOAD to upload seed datas, this procedure
101 -- only handle seed datas. ORG_ID = -3113
102 -- --------------------------------------------------------------------+
103 PROCEDURE LOAD_ROW
104 (x_module_id IN NUMBER,
105 x_name IN VARCHAR2,
106 x_description IN VARCHAR2,
107 x_module_type IN VARCHAR2,
108 x_module_status IN VARCHAR2,
109 x_event_id IN NUMBER,
110 x_repository_id IN NUMBER,
111 x_parent_module_id IN NUMBER,
112 x_source_repository_id IN NUMBER,
113 x_last_modification IN DATE,
114 x_last_synchronization IN DATE,
115 x_output_filename IN VARCHAR2,
116 x_collect_flag IN VARCHAR2,
117 x_org_id IN NUMBER,
118 x_owner IN VARCHAR2);
119
120 -- --------------------------------------------------------------------+
121 -- Procedure : TRANSLATE_ROW
122 -- Description : Called by FNDLOAD to translate seed datas, this procedure
123 -- only handle seed datas. ORG_ID = -3113
124 -- --------------------------------------------------------------------+
125 PROCEDURE TRANSLATE_ROW
126 ( x_module_id IN NUMBER,
127 x_name IN VARCHAR2,
128 x_owner IN VARCHAR2);
129
130 END cn_modules_pkg;