APPS.MTL_BILLING_SOURCE_PKG dependencies on MTL_BILLING_SOURCES_B

Line 19: INSERT INTO mtl_billing_sources_b

15: ) AS
16:
17: BEGIN
18:
19: INSERT INTO mtl_billing_sources_b
20: ( billing_source_id ,
21: procedure_code ,
22: billing_source_code ,
23: creation_date ,

Line 90: CURSOR cur_sources IS SELECT 1 FROM mtl_billing_sources_b

86: x_last_update_login IN NUMBER
87: ) AS
88:
89:
90: CURSOR cur_sources IS SELECT 1 FROM mtl_billing_sources_b
91: WHERE billing_Source_id = x_billing_source_id;
92: l_dummy NUMBER;
93:
94:

Line 100: update mtl_billing_sources_b set

96:
97: OPEN cur_sources;
98: FETCH cur_sources INTO l_dummy;
99:
100: update mtl_billing_sources_b set
101: procedure_code = x_procedure_code,
102: billing_source_code = x_billing_source_code ,
103: last_update_date = x_last_update_date,
104: last_updated_by = x_last_updated_by,

Line 144: delete from mtl_billing_sources_b

140: if (sql%notfound) then
141: raise no_data_found;
142: end if;
143:
144: delete from mtl_billing_sources_b
145: where billing_source_id = x_billing_source_id;
146:
147: if (sql%notfound) THEN
148: raise no_data_found;

Line 174: from mtl_billing_sources_b

170: created_by ,
171: last_update_date ,
172: last_updated_by ,
173: last_update_login
174: from mtl_billing_sources_b
175: where billing_source_id = x_billing_source_id
176: for update of billing_source_id nowait;
177: recinfo c%rowtype;
178:

Line 232: from mtl_billing_sources_b B

228:
229: delete from mtl_billing_sources_tl T
230: where not exists
231: (select NULL
232: from mtl_billing_sources_b B
233: where B.billing_source_id = T.billing_source_id
234: );
235:
236: update mtl_billing_sources_tl T