17: ) AS
18:
19: BEGIN
20:
21: INSERT INTO mtl_billing_rule_lines
22: ( billing_rule_line_id,
23: billing_rule_header_id ,
24: client_code ,
25: client_number ,
74: IF x_billing_rule_line_id IS NULL
75: THEN
76:
77:
78: INSERT INTO mtl_billing_rule_lines
79: ( billing_rule_line_id,
80: billing_rule_header_id ,
81: client_code ,
82: client_number ,
108: RETURN;
109:
110: ELSE
111:
112: update mtl_billing_rule_lines set
113: billing_rule_header_id = x_billing_rule_header_id,
114: client_code = x_client_code,
115: client_number = x_client_number,
116: service_agreement_line_id = x_service_agreement_line_id,
132: x_billing_rule_line_id in NUMBER
133: ) is
134: BEGIN
135:
136: delete from mtl_billing_rule_lines
137: where billing_rule_line_id = x_billing_rule_line_id;
138:
139: if (sql%notfound) then
140: raise no_data_found;
172: created_by ,
173: last_update_date ,
174: last_updated_by ,
175: last_update_login
176: from mtl_billing_rule_lines
177: where billing_rule_line_id = x_billing_rule_line_id
178: for update of billing_rule_line_id nowait;
179:
180: recinfo c%rowtype;