APPS.CSC_PROF_BLOCKS_PKG dependencies on CSC_PROF_BLOCKS_B

Line 76: INSERT INTO CSC_PROF_BLOCKS_B(

72: Fetch new_seq_csr into px_block_id;
73: Close new_seq_csr;
74: End If;
75: -- to_date(NULL) added to include timestamp during creation
76: INSERT INTO CSC_PROF_BLOCKS_B(
77: BLOCK_ID,
78: CREATED_BY,
79: CREATION_DATE,
80: LAST_UPDATED_BY,

Line 194: UPDATE CSC_PROF_BLOCKS_B

190: checking on the private api which are not really required for validation and no
191: impact even if the api is called from not through priviate api -jamose
192:
193: */
194: UPDATE CSC_PROF_BLOCKS_B
195: SET
196: LAST_UPDATED_BY = p_LAST_UPDATED_BY,
197: LAST_UPDATE_DATE = p_LAST_UPDATE_DATE,
198: LAST_UPDATE_LOGIN = p_LAST_UPDATE_LOGIN,

Line 240: from CSC_PROF_BLOCKS_B

236: P_BLOCK_ID in NUMBER,
237: P_OBJECT_VERSION_NUMBER in NUMBER
238: ) is
239: cursor c is select 'X'
240: from CSC_PROF_BLOCKS_B
241: where BLOCK_ID = P_BLOCK_ID
242: and object_version_number = P_object_version_number
243: for update of BLOCK_ID nowait;
244: recinfo c%rowtype;

Line 277: delete from CSC_PROF_BLOCKS_B

273: if (sql%notfound) then
274: raise no_data_found;
275: end if;
276:
277: delete from CSC_PROF_BLOCKS_B
278: where BLOCK_ID = P_BLOCK_ID
279: and OBJECT_VERSION_NUMBER = p_OBJECT_VERSION_NUMBER;
280:
281: if (sql%notfound) then

Line 292: from CSC_PROF_BLOCKS_B B

288: begin
289: delete from CSC_PROF_BLOCKS_TL T
290: where not exists
291: (select NULL
292: from CSC_PROF_BLOCKS_B B
293: where B.BLOCK_ID = T.BLOCK_ID
294: );
295:
296: update CSC_PROF_BLOCKS_TL T set (