1 package IEX_DUNNING_PLANS_PKG as
2 /* $Header: iextdpls.pls 120.0 2005/07/09 21:53:15 ctlee noship $ */
3 procedure INSERT_ROW (
4 X_ROWID in out nocopy VARCHAR2,
5 x_dunning_plan_id in NUMBER,
6 x_name in VARCHAR2,
7 x_description in VARCHAR2,
8 x_start_date in date,
9 x_end_date in date,
10 x_ENABLED_FLAG in VARCHAR2,
11 x_aging_bucket_id in number,
12 x_score_id in number,
13 x_dunning_level in VARCHAR2,
14 x_object_version_number in number,
15 x_CREATION_DATE in DATE,
16 x_CREATED_BY in NUMBER,
17 x_LAST_UPDATE_DATE in DATE,
18 x_LAST_UPDATED_BY in NUMBER,
19 x_LAST_UPDATE_LOGIN in NUMBER,
20 x_PROGRAM_APPLICATION_ID in NUMBER,
21 x_PROGRAM_ID in NUMBER,
22 x_PROGRAM_UPDATE_DATE in DATE
23 );
24
25 procedure LOCK_ROW (
26 x_dunning_plan_id in NUMBER,
27 x_name in VARCHAR2,
28 x_description in VARCHAR2,
29 x_start_date in date,
30 x_end_date in date,
31 x_ENABLED_FLAG in VARCHAR2,
32 x_aging_bucket_id in number,
33 x_score_id in number,
34 x_dunning_level in VARCHAR2,
35 x_object_version_number in number,
36 -- x_CREATION_DATE in DATE,
37 -- x_CREATED_BY in NUMBER,
38 -- x_LAST_UPDATE_DATE in DATE,
39 -- x_LAST_UPDATED_BY in NUMBER,
40 -- x_LAST_UPDATE_LOGIN in NUMBER,
41 x_PROGRAM_APPLICATION_ID in NUMBER,
42 x_PROGRAM_ID in NUMBER,
43 x_PROGRAM_UPDATE_DATE in DATE
44 );
45
46 procedure UPDATE_ROW (
47 x_dunning_plan_id in NUMBER,
48 x_name in VARCHAR2,
49 x_description in VARCHAR2,
50 x_start_date in date,
51 x_end_date in date,
52 x_ENABLED_FLAG in VARCHAR2,
53 x_aging_bucket_id in number,
54 x_score_id in number,
55 x_dunning_level in VARCHAR2,
56 x_object_version_number in number,
57 -- x_CREATION_DATE in DATE,
58 -- x_CREATED_BY in NUMBER,
59 x_LAST_UPDATE_DATE in DATE,
60 x_LAST_UPDATED_BY in NUMBER,
61 x_LAST_UPDATE_LOGIN in NUMBER,
62 x_PROGRAM_APPLICATION_ID in NUMBER,
63 x_PROGRAM_ID in NUMBER,
64 x_PROGRAM_UPDATE_DATE in DATE
65 );
66
67 procedure DELETE_ROW (
68 x_dunning_plan_id in NUMBER
69 );
70
71 procedure ADD_LANGUAGE;
72
73 procedure TRANSLATE_ROW (
74 x_dunning_plan_id in NUMBER,
75 x_name in VARCHAR2,
76 x_description in VARCHAR2
77 ) ;
78
79 procedure LOAD_ROW (
80 x_dunning_plan_id in NUMBER,
81 x_name in VARCHAR2,
82 x_description in VARCHAR2,
83 x_start_date in date,
84 x_end_date in date,
85 x_ENABLED_FLAG in VARCHAR2,
86 x_aging_bucket_id in number,
87 x_score_id in number,
88 x_dunning_level in VARCHAR2,
89 x_object_version_number in number,
90 x_PROGRAM_APPLICATION_ID in NUMBER,
91 x_PROGRAM_ID in NUMBER,
92 x_PROGRAM_UPDATE_DATE in DATE
93 );
94
95 end IEX_DUNNING_PLANS_PKG;