1 PACKAGE per_kr_grades_pkg AUTHID CURRENT_USER AS
2 /* $Header: pekrsg01.pkh 115.1 2002/12/03 09:31:57 viagarwa noship $ */
3 -------------------------------------------------------------------------------------
4 PROCEDURE insert_row
5 (p_row_id IN OUT NOCOPY VARCHAR2
6 ,p_grade_id IN OUT NOCOPY NUMBER
7 ,p_business_group_id NUMBER
8 ,p_grade_name VARCHAR2
9 ,p_sequence NUMBER
10 ,p_enabled_flag VARCHAR2
11 ,p_start_date_active DATE
12 ,p_end_date_active DATE
13 ,p_object_version_number NUMBER
14 ,p_last_update_date DATE
15 ,p_last_updated_by NUMBER
16 ,p_last_update_login NUMBER
17 ,p_created_by NUMBER
18 ,p_creation_date DATE
19 );
20 -------------------------------------------------------------------------------------
21 PROCEDURE lock_row
22 (p_row_id VARCHAR2
23 ,p_grade_id NUMBER
24 ,p_business_group_id NUMBER
25 ,p_grade_name VARCHAR2
26 ,p_sequence NUMBER
27 ,p_enabled_flag VARCHAR2
28 ,p_start_date_active DATE
29 ,p_end_date_active DATE
30 ,p_object_version_number NUMBER
31 ,p_last_update_date DATE
32 ,p_last_updated_by NUMBER
33 ,p_last_update_login NUMBER
34 ,p_created_by NUMBER
35 ,p_creation_date DATE
36 );
37 -------------------------------------------------------------------------------------
38 PROCEDURE update_row
39 (p_row_id VARCHAR2
40 ,p_grade_id NUMBER
41 ,p_business_group_id NUMBER
42 ,p_grade_name VARCHAR2
43 ,p_sequence NUMBER
44 ,p_enabled_flag VARCHAR2
45 ,p_start_date_active DATE
46 ,p_end_date_active DATE
47 ,p_object_version_number NUMBER
48 ,p_last_update_date DATE
49 ,p_last_updated_by NUMBER
50 ,p_last_update_login NUMBER
51 ,p_created_by NUMBER
52 ,p_creation_date DATE
53 );
54 -------------------------------------------------------------------------------------
55 PROCEDURE delete_row
56 (p_row_id VARCHAR2
57 );
58 END per_kr_grades_pkg;
[Home] [Help]