1 package mtl_billing_lines_pkg AUTHID CURRENT_USER AS
2 /* $Header: INVBLINS.pls 120.1 2010/05/25 10:56:56 damahaja noship $ */
3
4 procedure INSERT_ROW(
5 x_billing_rule_line_id IN NUMBER ,
6 x_billing_rule_header_id IN NUMBER ,
7 x_client_code IN VARCHAR2 ,
8 x_client_number IN VARCHAR2 ,
9 x_service_agreement_line_id IN NUMBER ,
10 x_inventory_item_id IN NUMBER ,
11 x_billing_source_id IN NUMBER ,
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_line_id IN NUMBER ,
21 x_billing_rule_header_id IN NUMBER ,
22 x_client_code IN VARCHAR2 ,
23 x_client_number IN VARCHAR2 ,
24 x_service_agreement_line_id IN NUMBER ,
25 x_inventory_item_id IN NUMBER ,
26 x_billing_source_id IN NUMBER ,
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_line_id IN NUMBER ,
36 x_billing_rule_header_id IN NUMBER ,
37 x_client_code IN VARCHAR2 ,
38 x_client_number IN VARCHAR2 ,
39 x_service_agreement_line_id IN NUMBER ,
40 x_inventory_item_id IN NUMBER ,
41 x_billing_source_id IN NUMBER ,
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 procedure DELETE_ROW (
50 x_billing_rule_line_id IN NUMBER);
51
52
53 end mtl_billing_lines_pkg;
[Home] [Help]