1 package mtl_billing_header_rules_pkg AUTHID CURRENT_USER AS
2 /* $Header: INVBHDRS.pls 120.1 2010/05/25 10:52:59 damahaja noship $ */
3
4 procedure INSERT_ROW(
5 x_billing_rule_header_id IN NUMBER ,
6 x_name IN VARCHAR2 ,
7 x_description IN VARCHAR2 ,
8 x_service_agreement IN VARCHAR2 ,
9 x_service_agreement_id IN NUMBER ,
10 x_start_date IN DATE ,
11 x_end_date IN DATE ,
12 x_creation_date IN DATE ,
13 x_created_by IN NUMBER,
14 x_last_update_date IN DATE,
15 x_last_updated_by IN NUMBER ,
16 x_last_update_login IN NUMBER
17 );
18
19 procedure LOCK_ROW(
20 x_billing_rule_header_id IN NUMBER ,
21 x_name IN VARCHAR2 ,
22 x_description IN VARCHAR2 ,
23 x_service_agreement IN VARCHAR2 ,
24 x_service_agreement_id IN NUMBER ,
25 x_start_date IN DATE ,
26 x_end_date IN DATE ,
27 x_creation_date IN DATE ,
28 x_created_by IN NUMBER,
29 x_last_update_date IN DATE,
30 x_last_updated_by IN NUMBER ,
31 x_last_update_login IN NUMBER
32 );
33
34 procedure UPDATE_ROW(
35 x_billing_rule_header_id IN NUMBER ,
36 x_name IN VARCHAR2 ,
37 x_description IN VARCHAR2 ,
38 x_service_agreement IN VARCHAR2 ,
39 x_service_agreement_id IN NUMBER ,
40 x_start_date IN DATE ,
41 x_end_date IN DATE ,
42 x_creation_date IN DATE ,
43 x_created_by IN NUMBER,
44 x_last_update_date IN DATE,
45 x_last_updated_by IN NUMBER ,
46 x_last_update_login IN NUMBER
47 );
48
49
50
51 procedure DELETE_ROW (
52 x_billing_rule_header_id in NUMBER);
53
54 /* Added following procedure for bug 9447716 */
55 procedure ADD_LANGUAGE;
56
57
58 end mtl_billing_header_rules_pkg;