APPS.CAC_SR_PERIOD_CATS_PKG dependencies on CAC_SR_PERIOD_CATS_B

Line 17: cursor C is select ROWID from CAC_SR_PERIOD_CATS_B

13: X_LAST_UPDATE_DATE in DATE,
14: X_LAST_UPDATED_BY in NUMBER,
15: X_LAST_UPDATE_LOGIN in NUMBER
16: ) is
17: cursor C is select ROWID from CAC_SR_PERIOD_CATS_B
18: where PERIOD_CATEGORY_ID = X_PERIOD_CATEGORY_ID
19: ;
20: begin
21: insert into CAC_SR_PERIOD_CATS_B (

Line 21: insert into CAC_SR_PERIOD_CATS_B (

17: cursor C is select ROWID from CAC_SR_PERIOD_CATS_B
18: where PERIOD_CATEGORY_ID = X_PERIOD_CATEGORY_ID
19: ;
20: begin
21: insert into CAC_SR_PERIOD_CATS_B (
22: PERIOD_CATEGORY_ID,
23: FREE_BUSY_TYPE,
24: DISPLAY_COLOR,
25: SHOW_PERIOD_DETAILS,

Line 95: from CAC_SR_PERIOD_CATS_B

91: cursor c is select
92: FREE_BUSY_TYPE,
93: DISPLAY_COLOR,
94: SHOW_PERIOD_DETAILS
95: from CAC_SR_PERIOD_CATS_B
96: where PERIOD_CATEGORY_ID = X_PERIOD_CATEGORY_ID
97: for update of PERIOD_CATEGORY_ID nowait;
98: recinfo c%rowtype;
99:

Line 155: update CAC_SR_PERIOD_CATS_B set

151: X_LAST_UPDATED_BY in NUMBER,
152: X_LAST_UPDATE_LOGIN in NUMBER
153: ) is
154: begin
155: update CAC_SR_PERIOD_CATS_B set
156: FREE_BUSY_TYPE = X_FREE_BUSY_TYPE,
157: DISPLAY_COLOR = X_DISPLAY_COLOR,
158: SHOW_PERIOD_DETAILS = X_SHOW_PERIOD_DETAILS,
159: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,

Line 194: delete from CAC_SR_PERIOD_CATS_B

190: if (sql%notfound) then
191: raise no_data_found;
192: end if;
193:
194: delete from CAC_SR_PERIOD_CATS_B
195: where PERIOD_CATEGORY_ID = X_PERIOD_CATEGORY_ID;
196:
197: if (sql%notfound) then
198: raise no_data_found;

Line 208: from CAC_SR_PERIOD_CATS_B B

204: begin
205: delete from CAC_SR_PERIOD_CATS_TL T
206: where not exists
207: (select NULL
208: from CAC_SR_PERIOD_CATS_B B
209: where B.PERIOD_CATEGORY_ID = T.PERIOD_CATEGORY_ID
210: );
211:
212: update CAC_SR_PERIOD_CATS_TL T set (

Line 323: FROM cac_sr_period_cats_b

319:
320:
321: SELECT period_category_id
322: INTO l_period_category_id
323: FROM cac_sr_period_cats_b
324: WHERE period_category_id = x_period_category_id;
325:
326:
327: UPDATE cac_sr_period_cats_b

Line 327: UPDATE cac_sr_period_cats_b

323: FROM cac_sr_period_cats_b
324: WHERE period_category_id = x_period_category_id;
325:
326:
327: UPDATE cac_sr_period_cats_b
328: SET free_busy_type = x_free_busy_type,
329: display_color = x_display_color,
330: show_period_details = x_show_period_details,
331: last_updated_by = l_user_id,