APPS.MTL_BILLING_HEADER_RULES_PKG dependencies on MTL_BILLING_RULE_HEADERS_B

Line 21: INSERT INTO mtl_billing_rule_headers_b

17: ) AS
18:
19: BEGIN
20:
21: INSERT INTO mtl_billing_rule_headers_b
22: ( billing_rule_header_id,
23: service_agreement_id,
24: creation_date ,
25: created_by ,

Line 95: CURSOR cur_sources IS SELECT 1 FROM mtl_billing_rule_headers_b

91: x_last_update_login IN NUMBER
92: ) AS
93:
94:
95: CURSOR cur_sources IS SELECT 1 FROM mtl_billing_rule_headers_b
96: WHERE billing_rule_header_id = x_billing_rule_header_id;
97: l_dummy NUMBER;
98:
99:

Line 105: update mtl_billing_rule_headers_b set

101:
102: OPEN cur_sources;
103: FETCH cur_sources INTO l_dummy;
104:
105: update mtl_billing_rule_headers_b set
106: service_agreement_id = x_service_agreement_id,
107: creation_date = x_creation_date,
108: created_by = x_created_by,
109: last_update_date = x_last_update_date,

Line 150: delete from mtl_billing_rule_headers_b

146: if (sql%notfound) then
147: raise no_data_found;
148: end if;
149:
150: delete from mtl_billing_rule_headers_b
151: where billing_rule_header_id = x_billing_rule_header_id;
152:
153: if (sql%notfound) then
154: raise no_data_found;

Line 181: from mtl_billing_rule_headers_b

177: created_by ,
178: last_update_date ,
179: last_updated_by ,
180: last_update_login
181: from mtl_billing_rule_headers_b
182: where billing_rule_header_id = x_billing_rule_header_id
183: for update of billing_rule_header_id nowait;
184: recinfo c%rowtype;
185:

Line 236: from mtl_billing_rule_headers_b B

232:
233: delete from mtl_billing_rule_headers_tl T
234: where not exists
235: (select NULL
236: from mtl_billing_rule_headers_b B
237: where B.billing_rule_header_id = T.billing_rule_header_id
238: );
239:
240: update mtl_billing_rule_headers_tl T