1 package wms_sort_criteria_form_pkg AS
2 /* $Header: WMSFPCRS.pls 120.1 2005/06/20 05:30:59 appldev ship $ */
3
4 procedure insert_sort_criteria
5 (
6 p_api_version IN NUMBER
7 ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
8 ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
9 ,x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
10 ,x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
11 ,x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
12 ,p_rowid IN OUT NOCOPY /* file.sql.39 change */ VARCHAR2
13 ,p_rule_id IN NUMBER
14 ,p_sequence_number IN NUMBER
15 ,p_parameter_id IN NUMBER
16 ,p_order_code IN NUMBER
17 ,p_attribute_category IN VARCHAR2
18 ,p_attribute1 IN VARCHAR2
19 ,p_attribute2 IN VARCHAR2
20 ,p_attribute3 IN VARCHAR2
21 ,p_attribute4 IN VARCHAR2
22 ,p_attribute5 IN VARCHAR2
23 ,p_attribute6 IN VARCHAR2
24 ,p_attribute7 IN VARCHAR2
25 ,p_attribute8 IN VARCHAR2
26 ,p_attribute9 IN VARCHAR2
27 ,p_attribute10 IN VARCHAR2
28 ,p_attribute11 IN VARCHAR2
29 ,p_attribute12 IN VARCHAR2
30 ,p_attribute13 IN VARCHAR2
31 ,p_attribute14 IN VARCHAR2
32 ,p_attribute15 IN VARCHAR2
33 );
34
35 procedure lock_sort_criteria (
36 p_api_version IN NUMBER
37 ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
38 ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
39 ,x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
40 ,x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
41 ,x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
42 ,p_rowid IN VARCHAR2
43 ,p_rule_id IN NUMBER
44 ,p_sequence_number IN NUMBER
45 ,p_parameter_id IN NUMBER
46 ,p_order_code IN NUMBER
47 ,p_attribute_category IN VARCHAR2
48 ,p_attribute1 IN VARCHAR2
49 ,p_attribute2 IN VARCHAR2
50 ,p_attribute3 IN VARCHAR2
51 ,p_attribute4 IN VARCHAR2
52 ,p_attribute5 IN VARCHAR2
53 ,p_attribute6 IN VARCHAR2
54 ,p_attribute7 IN VARCHAR2
55 ,p_attribute8 IN VARCHAR2
56 ,p_attribute9 IN VARCHAR2
57 ,p_attribute10 IN VARCHAR2
58 ,p_attribute11 IN VARCHAR2
59 ,p_attribute12 IN VARCHAR2
60 ,p_attribute13 IN VARCHAR2
61 ,p_attribute14 IN VARCHAR2
62 ,p_attribute15 IN VARCHAR2
63 );
64
65 procedure update_sort_criteria (
66 p_api_version IN NUMBER
67 ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
68 ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
69 ,x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
70 ,x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
71 ,x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
72 ,p_rowid IN VARCHAR2
73 ,p_rule_id IN NUMBER
74 ,p_sequence_number IN NUMBER
75 ,p_parameter_id IN NUMBER
76 ,p_order_code IN NUMBER
77 ,p_attribute_category IN VARCHAR2
78 ,p_attribute1 IN VARCHAR2
79 ,p_attribute2 IN VARCHAR2
80 ,p_attribute3 IN VARCHAR2
81 ,p_attribute4 IN VARCHAR2
82 ,p_attribute5 IN VARCHAR2
83 ,p_attribute6 IN VARCHAR2
84 ,p_attribute7 IN VARCHAR2
85 ,p_attribute8 IN VARCHAR2
86 ,p_attribute9 IN VARCHAR2
87 ,p_attribute10 IN VARCHAR2
88 ,p_attribute11 IN VARCHAR2
89 ,p_attribute12 IN VARCHAR2
90 ,p_attribute13 IN VARCHAR2
91 ,p_attribute14 IN VARCHAR2
92 ,p_attribute15 IN VARCHAR2
93 ) ;
94
95 procedure delete_sort_criteria (
96 p_api_version in NUMBER,
97 p_init_msg_list in varchar2 := fnd_api.g_false,
98 p_validation_level in number := fnd_api.g_valid_level_full,
99 x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
100 x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,
101 x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
102 p_rowid IN VARCHAR2,
103 p_rule_id IN NUMBER,
104 p_sequence_number IN NUMBER
105 );
106
107 -- this private procedure should be used only by the wms_rule_form_pkg.delete_rule
108 -- no validation is done whatsoever
109 procedure delete_sort_criterias (
110 p_rule_id IN NUMBER
111 );
112
113 end WMS_SORT_CRITERIA_FORM_PKG;