APPS.IBC_ATTRIBUTE_TYPES_PKG dependencies on IBC_ATTRIBUTE_TYPES_B

Line 4: -- Purpose: Table Handler for Ibc_Attribute_Types_b table.

1: PACKAGE BODY Ibc_Attribute_Types_Pkg AS
2: /* $Header: ibctattb.pls 120.4 2006/06/22 09:19:19 sharma ship $*/
3:
4: -- Purpose: Table Handler for Ibc_Attribute_Types_b table.
5:
6: -- MODIFICATION HISTORY
7: -- Person Date Comments
8: -- --------- ------ ------------------------------------------

Line 38: CURSOR c IS SELECT ROWID FROM ibc_attribute_types_b

34: ,p_last_update_login IN NUMBER --DEFAULT NULL
35: ,p_display_order IN NUMBER
36: ,p_flex_value_set_id IN NUMBER
37: ) IS
38: CURSOR c IS SELECT ROWID FROM ibc_attribute_types_b
39: WHERE attribute_type_code = p_attribute_type_code
40: AND content_type_code = p_content_type_code
41: ;
42: BEGIN

Line 43: INSERT INTO ibc_attribute_types_b (

39: WHERE attribute_type_code = p_attribute_type_code
40: AND content_type_code = p_content_type_code
41: ;
42: BEGIN
43: INSERT INTO ibc_attribute_types_b (
44: attribute_type_code
45: ,content_type_code
46: ,data_type_code
47: ,data_length

Line 147: FROM ibc_attribute_types_b

143: reference_code,
144: default_value,
145: updateable_flag,
146: object_version_number
147: FROM ibc_attribute_types_b
148: WHERE attribute_type_code = p_attribute_type_code
149: AND content_type_code = p_content_type_code
150: FOR UPDATE OF attribute_type_code NOWAIT;
151: recinfo c%ROWTYPE;

Line 228: UPDATE ibc_attribute_types_b SET

224: ,p_flex_value_set_id IN NUMBER
225: )
226: IS
227: BEGIN
228: UPDATE ibc_attribute_types_b SET
229: content_type_code = DECODE(p_content_type_code,FND_API.G_MISS_CHAR,NULL,NULL,content_type_code,p_content_type_code)
230: ,data_type_code = DECODE(p_data_type_code,FND_API.G_MISS_CHAR,NULL,NULL,data_type_code,p_data_type_code)
231: ,data_length = DECODE(p_data_length,FND_API.G_MISS_NUM,NULL,NULL,data_length,p_data_length)
232: ,min_instances = DECODE(p_min_instances,FND_API.G_MISS_NUM,NULL,NULL,min_instances,p_min_instances)

Line 285: DELETE FROM ibc_attribute_types_b

281: IF (SQL%NOTFOUND) THEN
282: RAISE NO_DATA_FOUND;
283: END IF;
284:
285: DELETE FROM ibc_attribute_types_b
286: WHERE attribute_type_code = p_attribute_type_code
287: AND content_type_code = p_content_type_code;
288:
289: IF (SQL%NOTFOUND) THEN

Line 310: DELETE FROM ibc_attribute_types_b

306: IF (SQL%NOTFOUND) THEN
307: RAISE NO_DATA_FOUND;
308: END IF;
309:
310: DELETE FROM ibc_attribute_types_b
311: WHERE attribute_type_code = attribute_type_code
312: AND content_type_code = p_content_type_code;
313:
314: IF (SQL%NOTFOUND) THEN

Line 325: FROM ibc_attribute_types_b b

321: BEGIN
322: DELETE FROM ibc_attribute_types_tl T
323: WHERE NOT EXISTS
324: (SELECT NULL
325: FROM ibc_attribute_types_b b
326: WHERE b.attribute_type_code = T.attribute_type_code
327: AND b.content_type_code = T.content_type_code
328: );
329:

Line 478: FROM ibc_attribute_types_b

474: l_last_update_date := nvl(TO_DATE(p_last_update_date, 'YYYY/MM/DD'),SYSDATE);
475:
476: -- get updatedby and update_date values if existing in db
477: SELECT LAST_UPDATED_BY, LAST_UPDATE_DATE INTO db_user_id, db_last_update_date
478: FROM ibc_attribute_types_b
479: WHERE attribute_type_code = p_attribute_type_code
480: AND content_type_code = p_content_type_code
481: AND object_version_number = DECODE(object_version_number,
482: fnd_api.g_miss_num,

Line 613: CURSOR C IS SELECT ROWID FROM IBC_ATTRIBUTE_TYPES_B

609: X_LAST_UPDATE_DATE IN DATE,
610: X_LAST_UPDATED_BY IN NUMBER,
611: X_LAST_UPDATE_LOGIN IN NUMBER
612: ) IS
613: CURSOR C IS SELECT ROWID FROM IBC_ATTRIBUTE_TYPES_B
614: WHERE CONTENT_TYPE_CODE = X_CONTENT_TYPE_CODE
615: AND ATTRIBUTE_TYPE_CODE = X_ATTRIBUTE_TYPE_CODE
616: ;
617: BEGIN

Line 618: INSERT INTO IBC_ATTRIBUTE_TYPES_B (

614: WHERE CONTENT_TYPE_CODE = X_CONTENT_TYPE_CODE
615: AND ATTRIBUTE_TYPE_CODE = X_ATTRIBUTE_TYPE_CODE
616: ;
617: BEGIN
618: INSERT INTO IBC_ATTRIBUTE_TYPES_B (
619: MIN_INSTANCES,
620: MAX_INSTANCES,
621: DEFAULT_VALUE,
622: UPDATEABLE_FLAG,

Line 732: FROM IBC_ATTRIBUTE_TYPES_B

728: DISPLAY_ORDER,
729: FLEX_VALUE_SET_ID,
730: DATA_TYPE_CODE,
731: DATA_LENGTH
732: FROM IBC_ATTRIBUTE_TYPES_B
733: WHERE CONTENT_TYPE_CODE = X_CONTENT_TYPE_CODE
734: AND ATTRIBUTE_TYPE_CODE = X_ATTRIBUTE_TYPE_CODE
735: FOR UPDATE OF CONTENT_TYPE_CODE NOWAIT;
736: recinfo c%ROWTYPE;

Line 818: UPDATE IBC_ATTRIBUTE_TYPES_B SET

814: X_LAST_UPDATED_BY IN NUMBER,
815: X_LAST_UPDATE_LOGIN IN NUMBER
816: ) IS
817: BEGIN
818: UPDATE IBC_ATTRIBUTE_TYPES_B SET
819: MIN_INSTANCES = X_MIN_INSTANCES,
820: MAX_INSTANCES = X_MAX_INSTANCES,
821: DEFAULT_VALUE = X_DEFAULT_VALUE,
822: UPDATEABLE_FLAG = X_UPDATEABLE_FLAG,

Line 869: DELETE FROM IBC_ATTRIBUTE_TYPES_B

865: IF (SQL%NOTFOUND) THEN
866: RAISE NO_DATA_FOUND;
867: END IF;
868:
869: DELETE FROM IBC_ATTRIBUTE_TYPES_B
870: WHERE CONTENT_TYPE_CODE = X_CONTENT_TYPE_CODE
871: AND ATTRIBUTE_TYPE_CODE = X_ATTRIBUTE_TYPE_CODE;
872:
873: IF (SQL%NOTFOUND) THEN