1 PACKAGE cn_syin_rules_pkg AUTHID CURRENT_USER AS
2 -- $Header: cnsyinfs.pls 120.6 2005/12/27 04:02:05 hanaraya ship $
3
4
5 --
6 -- Procedure Name
7 -- populate_fields
8 -- History
9 -- 01/26/94 Tony Lower Created
10 -- 08-30-95 Amy Erickson Updated
11 --
12 --
13 -- Procedure Name
14 -- populate_fields
15 -- History
16 -- 01/26/94 Tony Lower Created
17 -- 08-30-95 Amy Erickson Updated
18 --
19 PROCEDURE Populate_Fields (x_revenue_class_id IN OUT NOCOPY number,
20 x_revenue_class_name IN OUT NOCOPY varchar2,
21 x_org_id IN NUMBER );
22
23
24 --
25 -- Procedure Name
26 -- unsync_ruleset
27 -- History
28 -- 02-17-99 Renu Chintalapati Created
29 --
30 PROCEDURE unsync_ruleset (x_ruleset_id number,
31 x_org_id number ) ;
32
33 --
34 -- Procedure Name
35 -- Insert_Row
36 -- History
37 -- 08-08-95 Amy Erickson Created
38 -- FEB-25-99 Harlen Chen updated for MLS changes
39
40 PROCEDURE Insert_Row (x_rule_id number,
41 x_name varchar2,
42 x_ruleset_id number,
43 x_revenue_class_id number,
44 x_expense_ccid NUMBER,
45 x_liability_ccid NUMBER,
46 x_parent_rule_id number,
47 x_sequence_number number,
48 x_org_id number );
49
50 procedure insert_row_into_cn_rules_only
51 (
52 X_ROWID in out nocopy VARCHAR2,
53 X_RULE_ID in NUMBER := FND_API.G_MISS_NUM,
54 X_RULESET_ID in NUMBER := FND_API.G_MISS_NUM,
55 X_PACKAGE_ID in NUMBER := FND_API.G_MISS_NUM,
56 X_REVENUE_CLASS_ID in NUMBER := FND_API.G_MISS_NUM,
57 x_expense_ccid IN NUMBER := fnd_api.g_miss_num,
58 x_liability_ccid IN NUMBER := fnd_api.g_miss_num,
59 X_NAME in VARCHAR2 := FND_API.G_MISS_CHAR,
60 X_CREATION_DATE in DATE := FND_API.G_MISS_DATE,
61 X_CREATED_BY in NUMBER := FND_API.G_MISS_NUM,
62 X_LAST_UPDATE_DATE in DATE := FND_API.G_MISS_DATE,
63 X_LAST_UPDATED_BY in NUMBER := FND_API.G_MISS_NUM,
64 X_LAST_UPDATE_LOGIN in NUMBER := FND_API.G_MISS_NUM,
65 X_ORG_ID in NUMBER := FND_API.G_MISS_NUM);
66
67 --
68 -- Procedure Name
69 -- Update_Row
70 -- History
71 -- 06-15-94 Tony Lower Created
72 -- Feb-25-99 Harlen Chen Updated: new tbl handler for MLS changes
73 --
74 --PROCEDURE Update_Row (x_rule_id number,
75 -- x_name varchar2,
76 -- x_revenue_class_id number) ;
77 procedure UPDATE_ROW
78 (
79 X_RULE_ID in NUMBER,
80 X_RULESET_ID in NUMBER,
81 X_PACKAGE_ID in NUMBER,
82 X_REVENUE_CLASS_ID in NUMBER,
83 x_expense_ccid IN NUMBER,
84 x_liability_ccid IN NUMBER,
85 X_NAME in VARCHAR2,
86 X_LAST_UPDATE_DATE in DATE,
87 X_LAST_UPDATED_BY in NUMBER,
88 X_LAST_UPDATE_LOGIN in NUMBER,
89 X_ORG_ID IN NUMBER,
90 X_OBJECT_VERSION_NO IN OUT NOCOPY NUMBER
91 );
92 --
93 -- Procedure Name
94 -- Delete_Row
95 -- History
96 -- 06-15-94 Tony Lower Created
97 --
98 procedure DELETE_ROW (X_RULE_ID in NUMBER,
99 X_RULESET_ID in NUMBER,
100 X_ORG_ID in number );
101
102
103
104 -- 30-JUL-98 Ram Kalyanasundaram Created
105 --------------------------------------------------------------------------+
106 -- Procedure Name: download --+
107 -- Purpose --+
108 -- This procedure is used to download the required data to the inter- --+
109 -- face table for export to a different data base --+
110 --------------------------------------------------------------------------+
111 PROCEDURE download(errbuf OUT NOCOPY VARCHAR2,
112 retcode OUT NOCOPY NUMBER);
113
114 -- 30-JUL-98 Ram Kalyanasundaram Created
115 --------------------------------------------------------------------------+
116 -- Procedure Name: upload --+
117 -- Purpose --+
118 -- This procedure is used to upload the required data from the inter- --+
119 -- face table to the appropriate tables in the database --+
120 --------------------------------------------------------------------------+
121 PROCEDURE upload(errbuf OUT NOCOPY VARCHAR2,
122 retcode OUT NOCOPY NUMBER);
123
124
125
126 procedure ADD_LANGUAGE;
127 -- --------------------------------------------------------------------+
128 -- Procedure : LOAD_ROW
129 -- Description : Called by FNDLOAD to upload seed datas, this procedure
130 -- only handle seed datas. ORG_ID = -3113
131 -- --------------------------------------------------------------------+
132 PROCEDURE LOAD_ROW
133 ( x_rule_id IN NUMBER,
134 x_ruleset_id IN NUMBER,
135 x_package_id IN NUMBER,
136 x_revenue_class_id IN NUMBER,
137 x_name IN VARCHAR2,
138 x_owner IN VARCHAR2,
139 x_org_id in number);
140
141 -- --------------------------------------------------------------------+
142 -- Procedure : TRANSLATE_ROW
143 -- Description : Called by FNDLOAD to translate seed datas, this procedure
144 -- only handle seed datas. ORG_ID = -3113
145 -- --------------------------------------------------------------------+
146 PROCEDURE TRANSLATE_ROW
147 ( x_rule_id IN NUMBER,
148 x_ruleset_id IN NUMBER,
149 x_name IN VARCHAR2,
150 x_owner IN VARCHAR2,
151 x_org_id in number );
152
153 END cn_syin_rules_pkg;