APPS.PA_COST_PLUS_STRUCTURE_PKG dependencies on PA_COST_PLUS_STRUCTURES

Line 16: (SELECT 1 FROM pa_cost_plus_structures

12:
13: status := 0;
14:
15: SELECT 1 INTO dummy FROM sys.dual WHERE NOT EXISTS
16: (SELECT 1 FROM pa_cost_plus_structures
17: WHERE cost_plus_structure = cp_structure);
18:
19: exception
20: when OTHERS then

Line 138: FROM pa_cost_plus_structures

134: status := 0;
135:
136: SELECT 1 INTO dummy FROM sys.dual WHERE NOT EXISTS
137: (SELECT 1
138: FROM pa_cost_plus_structures
139: WHERE default_for_override_sch_flag = 'Y');
140:
141: exception
142:

Line 163: -- check pa_cost_plus_structures table

159: begin
160:
161: status := 0;
162:
163: -- check pa_cost_plus_structures table
164: -- there are six cases
165: -- A
166: -- |--------------------|
167: -- B C D E F

Line 176: (SELECT 1 FROM pa_cost_plus_structures cps

172: -- any point of time.
173: -- Case B and F are acceptable.
174:
175: SELECT 1 INTO dummy FROM sys.dual WHERE NOT EXISTS
176: (SELECT 1 FROM pa_cost_plus_structures cps
177: WHERE cps.default_for_override_sch_flag = 'Y'
178: AND ( -- case A
179: ( (TRUNC(cps.start_date_active)
180: BETWEEN

Line 240: UPDATE pa_cost_plus_structures SET default_for_override_sch_flag = 'N'

236: begin
237:
238: status := 0;
239:
240: UPDATE pa_cost_plus_structures SET default_for_override_sch_flag = 'N'
241: WHERE cost_plus_structure = cp_structure;
242:
243: COMMIT;
244: