1 PACKAGE CN_SYIN_Rulesets_PKG AUTHID CURRENT_USER as
2 -- $Header: cnsyinis.pls 120.6 2005/12/27 04:00:28 hanaraya ship $
3
4
5 -- =====================================================================================
6 -- Procedure Name : populate_fields
7 -- Purpose
8 --
9 -- History
10 -- 01/26/94 Tony Lower Created
11 -- =====================================================================================
12 PROCEDURE Populate_fields (X_column_id number,
13 X_column_name IN OUT NOCOPY varchar2);
14
15
16 -- =====================================================================================
17 -- Procedure Name : insert_row
18 -- Purpose
19 --
20 -- History
21 -- 01/26/94 Tony Lower Created
22 -- Feb-25-99 Harlen Chen Use new insert_row for MLS
23 -- =====================================================================================
24
25 procedure INSERT_ROW
26 (
27 X_ROWID in out NOCOPY VARCHAR2,
28 X_RULESET_ID in NUMBER := FND_API.G_MISS_NUM,
29 X_RULESET_STATUS in VARCHAR2 := FND_API.G_MISS_CHAR,
30 X_DESTINATION_COLUMN_ID in NUMBER := FND_API.G_MISS_NUM,
31 X_REPOSITORY_ID in NUMBER := FND_API.G_MISS_NUM,
32 X_NAME in VARCHAR2 := FND_API.G_MISS_CHAR,
33 x_module_type IN VARCHAR2 := fnd_api.g_miss_char,
34 x_start_date IN DATE := fnd_api.g_miss_date,
35 x_end_date IN DATE := fnd_api.g_miss_date,
36 X_CREATION_DATE in DATE := FND_API.G_MISS_DATE,
37 X_CREATED_BY in NUMBER := FND_API.G_MISS_NUM,
38 X_LAST_UPDATE_DATE in DATE := FND_API.G_MISS_DATE,
39 X_LAST_UPDATED_BY in NUMBER := FND_API.G_MISS_NUM,
40 X_LAST_UPDATE_LOGIN in NUMBER := FND_API.G_MISS_NUM,
41 X_ORG_ID in NUMBER := FND_API.G_MISS_NUM);
42
43
44
45 procedure UPDATE_ROW
46 (
47 X_RULESET_ID in NUMBER,
48 X_OBJECT_VERSION_NUMBER IN NUMBER,
49 X_RULESET_STATUS in VARCHAR2,
50 X_DESTINATION_COLUMN_ID in NUMBER,
51 X_REPOSITORY_ID in NUMBER,
52 x_start_date IN DATE,
53 x_end_date IN DATE,
54 X_NAME in VARCHAR2,
55 x_module_type IN VARCHAR2,
56 X_LAST_UPDATE_DATE in DATE,
57 X_LAST_UPDATED_BY in NUMBER,
58 X_LAST_UPDATE_LOGIN in NUMBER,
59 X_ORG_ID in NUMBER
60 );
61 procedure DELETE_ROW (
62 X_RULESET_ID in NUMBER,
63 X_ORG_ID IN NUMBER
64 );
65
66 procedure ADD_LANGUAGE;
67 --
68 -- Procedure : LOAD_ROW
69 -- Description : Called by FNDLOAD to upload seed datas, this procedure
70 -- only handle seed datas. ORG_ID = -3113
71 --
72 PROCEDURE LOAD_ROW
73 ( x_ruleset_id IN NUMBER,
74 x_destination_column_id IN NUMBER,
75 x_repository_id IN NUMBER,
76 x_name IN VARCHAR2,
77 x_ruleset_status in VARCHAR2,
78 x_start_date IN DATE,
79 x_end_date IN DATE,
80 x_owner IN VARCHAR2,
81 x_org_id IN NUMBER);
82
83 --
84 -- Procedure : TRANSLATE_ROW
85 -- Description : Called by FNDLOAD to translate seed datas, this procedure
86 -- only handle seed datas. ORG_ID = -3113
87 --
88 PROCEDURE TRANSLATE_ROW
89 ( x_ruleset_id IN NUMBER,
90 x_name IN VARCHAR2,
91 x_owner IN VARCHAR2,
92 x_org_id IN NUMBER);
93
94
95 END CN_SYIN_Rulesets_PKG;