APPS.PA_COST_PLUS_STRUCTURE_PKG dependencies on PA_COST_BASE_COST_CODES

Line 36: -- check pa_cost_base_cost_codes table

32: begin
33:
34: status := 0;
35:
36: -- check pa_cost_base_cost_codes table
37: -- check pa_cost_base_exp_types table
38:
39: SELECT 1 INTO dummy FROM sys.dual WHERE NOT EXISTS
40: (SELECT 1 FROM pa_cost_base_cost_codes cbicc,

Line 40: (SELECT 1 FROM pa_cost_base_cost_codes cbicc,

36: -- check pa_cost_base_cost_codes table
37: -- check pa_cost_base_exp_types table
38:
39: SELECT 1 INTO dummy FROM sys.dual WHERE NOT EXISTS
40: (SELECT 1 FROM pa_cost_base_cost_codes cbicc,
41: pa_cost_base_exp_types cbet
42: WHERE cbicc.cost_plus_structure = cp_structure
43: OR cbet.cost_plus_structure = cp_structure);
44:

Line 115: FROM pa_cost_base_cost_codes

111: status := 0;
112:
113: SELECT 1 INTO dummy FROM sys.dual WHERE NOT EXISTS
114: (SELECT 1
115: FROM pa_cost_base_cost_codes
116: WHERE cost_plus_structure = cp_structure);
117:
118: exception
119:

Line 260: UPDATE pa_cost_base_cost_codes

256: begin
257:
258: status := 0;
259:
260: UPDATE pa_cost_base_cost_codes
261: SET precedence = 1
262: WHERE cost_plus_structure = cp_structure;
263:
264: COMMIT;

Line 278: DELETE pa_cost_base_cost_codes

274: procedure cascade_delete(cp_structure IN varchar2)
275: is
276: begin
277:
278: DELETE pa_cost_base_cost_codes
279: WHERE cost_plus_structure = cp_structure;
280:
281: DELETE pa_cost_base_exp_types
282: WHERE cost_plus_structure = cp_structure;

Line 294: UPDATE pa_cost_base_cost_codes

290:
291: is
292: begin
293:
294: UPDATE pa_cost_base_cost_codes
295: SET cost_plus_structure = new_cp_structure
296: WHERE cost_plus_structure = old_cp_structure;
297:
298: UPDATE pa_cost_base_exp_types