APPS.IBC_CONTENT_TYPES_PKG dependencies on IBC_CONTENT_TYPES_B

Line 34: CURSOR C IS SELECT ROWID FROM IBC_CONTENT_TYPES_B

30: ,p_last_update_login IN NUMBER --DEFAULT NULL
31: ,p_encrypt_flag IN VARCHAR2 --DEFAULT NULL
32: ,p_OWNER_FND_USER_ID IN NUMBER
33: ) IS
34: CURSOR C IS SELECT ROWID FROM IBC_CONTENT_TYPES_B
35: WHERE CONTENT_TYPE_CODE = p_CONTENT_TYPE_CODE
36: ;
37: BEGIN
38: INSERT INTO IBC_CONTENT_TYPES_B (

Line 38: INSERT INTO IBC_CONTENT_TYPES_B (

34: CURSOR C IS SELECT ROWID FROM IBC_CONTENT_TYPES_B
35: WHERE CONTENT_TYPE_CODE = p_CONTENT_TYPE_CODE
36: ;
37: BEGIN
38: INSERT INTO IBC_CONTENT_TYPES_B (
39: CONTENT_TYPE_CODE,
40: CONTENT_TYPE_STATUS,
41: APPLICATION_ID,
42: REQUEST_ID,

Line 121: FROM IBC_CONTENT_TYPES_B

117: CONTENT_TYPE_STATUS,
118: APPLICATION_ID,
119: REQUEST_ID,
120: OBJECT_VERSION_NUMBER
121: FROM IBC_CONTENT_TYPES_B
122: WHERE CONTENT_TYPE_CODE = p_CONTENT_TYPE_CODE
123: FOR UPDATE OF CONTENT_TYPE_CODE NOWAIT;
124: recinfo c%ROWTYPE;
125:

Line 189: UPDATE IBC_CONTENT_TYPES_B SET

185: ,p_OWNER_FND_USER_ID IN NUMBER
186:
187: ) IS
188: BEGIN
189: UPDATE IBC_CONTENT_TYPES_B SET
190: content_type_status = DECODE(p_content_type_status,FND_API.G_MISS_CHAR,NULL,NULL,content_type_status,p_content_type_status)
191: ,application_id = DECODE(p_application_id,FND_API.G_MISS_NUM,NULL,NULL,application_id,p_application_id)
192: ,request_id = DECODE(p_request_id,FND_API.G_MISS_NUM,NULL,NULL,request_id,p_request_id)
193: ,object_version_number = NVL(object_version_number,0) + 1

Line 237: DELETE FROM IBC_CONTENT_TYPES_B

233: IF (SQL%NOTFOUND) THEN
234: RAISE NO_DATA_FOUND;
235: END IF;
236:
237: DELETE FROM IBC_CONTENT_TYPES_B
238: WHERE CONTENT_TYPE_CODE = p_CONTENT_TYPE_CODE;
239:
240: IF (SQL%NOTFOUND) THEN
241: RAISE NO_DATA_FOUND;

Line 251: FROM IBC_CONTENT_TYPES_B B

247: BEGIN
248: DELETE FROM IBC_CONTENT_TYPES_TL T
249: WHERE NOT EXISTS
250: (SELECT NULL
251: FROM IBC_CONTENT_TYPES_B B
252: WHERE B.CONTENT_TYPE_CODE = T.CONTENT_TYPE_CODE
253: );
254:
255: UPDATE IBC_CONTENT_TYPES_TL T SET (

Line 377: FROM IBC_CONTENT_TYPES_B

373: l_last_update_date := nvl(TO_DATE(p_last_update_date, 'YYYY/MM/DD'),SYSDATE);
374:
375: -- get updatedby and update_date values if existing in db
376: SELECT LAST_UPDATED_BY, LAST_UPDATE_DATE INTO db_user_id, db_last_update_date
377: FROM IBC_CONTENT_TYPES_B
378: WHERE CONTENT_TYPE_CODE = p_CONTENT_TYPE_CODE;
379:
380: IF (FND_LOAD_UTIL.UPLOAD_TEST(l_user_id, l_last_update_date,
381: db_user_id, db_last_update_date, p_upload_mode )) THEN

Line 492: CURSOR C IS SELECT ROWID FROM IBC_CONTENT_TYPES_B

488: X_LAST_UPDATED_BY IN NUMBER,
489: X_LAST_UPDATE_LOGIN IN NUMBER,
490: X_ENCRYPT_FLAG IN VARCHAR2 --DEFAULT NULL
491: ) IS
492: CURSOR C IS SELECT ROWID FROM IBC_CONTENT_TYPES_B
493: WHERE CONTENT_TYPE_CODE = X_CONTENT_TYPE_CODE
494: ;
495: BEGIN
496: INSERT INTO IBC_CONTENT_TYPES_B (

Line 496: INSERT INTO IBC_CONTENT_TYPES_B (

492: CURSOR C IS SELECT ROWID FROM IBC_CONTENT_TYPES_B
493: WHERE CONTENT_TYPE_CODE = X_CONTENT_TYPE_CODE
494: ;
495: BEGIN
496: INSERT INTO IBC_CONTENT_TYPES_B (
497: APPLICATION_ID,
498: OWNER_FND_USER_ID,
499: CONTENT_TYPE_CODE,
500: CONTENT_TYPE_STATUS,

Line 589: from IBC_CONTENT_TYPES_B

585: REQUEST_ID,
586: OWNER_FND_USER_ID,
587: OBJECT_VERSION_NUMBER,
588: SECURITY_GROUP_ID
589: from IBC_CONTENT_TYPES_B
590: where CONTENT_TYPE_CODE = X_CONTENT_TYPE_CODE
591: for update of CONTENT_TYPE_CODE nowait;
592: recinfo c%rowtype;
593:

Line 666: UPDATE IBC_CONTENT_TYPES_B SET

662: X_LAST_UPDATE_LOGIN IN NUMBER,
663: X_ENCRYPT_FLAG IN VARCHAR2 --DEFAULT NULL
664: ) IS
665: BEGIN
666: UPDATE IBC_CONTENT_TYPES_B SET
667: APPLICATION_ID = X_APPLICATION_ID,
668: OWNER_FND_USER_ID = X_OWNER_FND_USER_ID,
669: CONTENT_TYPE_STATUS = X_CONTENT_TYPE_STATUS,
670: REQUEST_ID = X_REQUEST_ID,

Line 709: DELETE FROM IBC_CONTENT_TYPES_B

705: IF (SQL%NOTFOUND) THEN
706: RAISE NO_DATA_FOUND;
707: END IF;
708:
709: DELETE FROM IBC_CONTENT_TYPES_B
710: WHERE CONTENT_TYPE_CODE = X_CONTENT_TYPE_CODE;
711:
712: IF (SQL%NOTFOUND) THEN
713: RAISE NO_DATA_FOUND;

Line 823: UPDATE ibc_content_types_b

819: ,p_old_content_type_code IN VARCHAR2)
820: IS
821: BEGIN
822:
823: UPDATE ibc_content_types_b
824: SET content_type_code=p_new_content_type_code
825: WHERE content_type_code = p_old_content_type_code;
826:
827: UPDATE ibc_content_types_tl