APPS.CAC_SR_PERIOD_DTL_TYPES_PKG dependencies on CAC_SR_PERIOD_DTL_TYPES_B

Line 15: cursor C is select ROWID from CAC_SR_PERIOD_DTL_TYPES_B

11: X_LAST_UPDATE_DATE in DATE,
12: X_LAST_UPDATED_BY in NUMBER,
13: X_LAST_UPDATE_LOGIN in NUMBER
14: ) is
15: cursor C is select ROWID from CAC_SR_PERIOD_DTL_TYPES_B
16: where PERIOD_DTL_TYPE_ID = X_PERIOD_DTL_TYPE_ID
17: ;
18: begin
19: insert into CAC_SR_PERIOD_DTL_TYPES_B (

Line 19: insert into CAC_SR_PERIOD_DTL_TYPES_B (

15: cursor C is select ROWID from CAC_SR_PERIOD_DTL_TYPES_B
16: where PERIOD_DTL_TYPE_ID = X_PERIOD_DTL_TYPE_ID
17: ;
18: begin
19: insert into CAC_SR_PERIOD_DTL_TYPES_B (
20: PERIOD_DTL_TYPE_ID,
21: DISPLAY_COLOR,
22: CREATION_DATE,
23: CREATED_BY,

Line 85: from CAC_SR_PERIOD_DTL_TYPES_B

81: X_PERIOD_DTL_TYPE_DESC in VARCHAR2
82: ) is
83: cursor c is select
84: DISPLAY_COLOR
85: from CAC_SR_PERIOD_DTL_TYPES_B
86: where PERIOD_DTL_TYPE_ID = X_PERIOD_DTL_TYPE_ID
87: for update of PERIOD_DTL_TYPE_ID nowait;
88: recinfo c%rowtype;
89:

Line 141: update CAC_SR_PERIOD_DTL_TYPES_B set

137: X_LAST_UPDATED_BY in NUMBER,
138: X_LAST_UPDATE_LOGIN in NUMBER
139: ) is
140: begin
141: update CAC_SR_PERIOD_DTL_TYPES_B set
142: DISPLAY_COLOR = X_DISPLAY_COLOR,
143: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
144: LAST_UPDATED_BY = X_LAST_UPDATED_BY,
145: LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN

Line 178: delete from CAC_SR_PERIOD_DTL_TYPES_B

174: if (sql%notfound) then
175: raise no_data_found;
176: end if;
177:
178: delete from CAC_SR_PERIOD_DTL_TYPES_B
179: where PERIOD_DTL_TYPE_ID = X_PERIOD_DTL_TYPE_ID;
180:
181: if (sql%notfound) then
182: raise no_data_found;

Line 192: from CAC_SR_PERIOD_DTL_TYPES_B B

188: begin
189: delete from CAC_SR_PERIOD_DTL_TYPES_TL T
190: where not exists
191: (select NULL
192: from CAC_SR_PERIOD_DTL_TYPES_B B
193: where B.PERIOD_DTL_TYPE_ID = T.PERIOD_DTL_TYPE_ID
194: );
195:
196: update CAC_SR_PERIOD_DTL_TYPES_TL T set (

Line 305: FROM cac_sr_period_dtl_types_b

301:
302:
303: SELECT period_dtl_type_id
304: INTO l_period_dtl_type_id
305: FROM cac_sr_period_dtl_types_b
306: WHERE period_dtl_type_id = x_period_dtl_type_id;
307:
308:
309: UPDATE cac_sr_period_dtl_types_b

Line 309: UPDATE cac_sr_period_dtl_types_b

305: FROM cac_sr_period_dtl_types_b
306: WHERE period_dtl_type_id = x_period_dtl_type_id;
307:
308:
309: UPDATE cac_sr_period_dtl_types_b
310: SET display_color = x_display_color,
311: last_updated_by = l_user_id,
312: last_update_date = sysdate,
313: last_update_login = 0

Line 338: DELETE FROM CAC_SR_PERIOD_DTL_TYPES_B WHERE PERIOD_DTL_TYPE_ID = x_period_dtl_type_id;

334: EXCEPTION
335: WHEN no_data_found THEN
336:
337: DELETE FROM CAC_SR_PERIOD_DTL_TYPES_TL WHERE PERIOD_DTL_TYPE_ID = x_period_dtl_type_id;
338: DELETE FROM CAC_SR_PERIOD_DTL_TYPES_B WHERE PERIOD_DTL_TYPE_ID = x_period_dtl_type_id;
339:
340: CAC_SR_PERIOD_DTL_TYPES_PKG.INSERT_ROW
341: (
342: x_rowid => l_rowid ,