APPS.CSR_COSTS_PKG dependencies on CSR_COSTS_ALL_B

Line 15: - base table CSR_COSTS_ALL_B, and

11:
12: Purpose
13: -------
14: Insert, update, delete or lock tables belonging to view CSR_COSTS_VL:
15: - base table CSR_COSTS_ALL_B, and
16: - translation table CSR_COSTS_ALL_TL.
17: Restore data integrity to a corrupted base/translation pair.
18:
19: History

Line 68: select csr_costs_all_b_s1.nextval

64:
65: begin
66:
67: if p_cost_id is null then
68: select csr_costs_all_b_s1.nextval
69: into p_cost_id
70: from dual;
71: end if;
72:

Line 93: insert into csr_costs_all_b

89: if p_last_update_date is null then
90: p_last_update_date := sysdate;
91: end if;
92:
93: insert into csr_costs_all_b
94: (
95: cost_id
96: , name
97: , value

Line 301: update csr_costs_all_b

297: if p_last_update_date is null then
298: p_last_update_date := sysdate;
299: end if;
300:
301: update csr_costs_all_b
302: set name = p_name
303: , value = p_value
304: , last_update_date = p_last_update_date
305: , last_updated_by = p_last_updated_by

Line 359: delete from csr_costs_all_b

355: then
356: raise NO_DATA_FOUND;
357: end if;
358:
359: delete from csr_costs_all_b
360: where cost_id = p_cost_id;
361:
362: if sql%notfound
363: then

Line 374: from csr_costs_all_b b

370: begin
371: delete from csr_costs_all_tl t
372: where not exists
373: ( select ''
374: from csr_costs_all_b b
375: where b.cost_id = t.cost_id );
376:
377: update csr_costs_all_tl t
378: set description =