APPS.IBC_CTYPE_PVT dependencies on IBC_ATTRIBUTE_TYPES_B

Line 115: FROM IBC_ATTRIBUTE_TYPES_B

111: CURSOR C_Attribute_Type(p_content_type_code IN VARCHAR2
112: ,p_attribute_type_code IN VARCHAR2)
113: IS
114: SELECT '1'
115: FROM IBC_ATTRIBUTE_TYPES_B
116: WHERE content_type_code = p_content_type_code
117: AND attribute_type_code = p_attribute_type_code;
118:
119: l_temp CHAR(1);

Line 271: -- Insert The Corresponding Attributes in ibc_attribute_types_b table

267: p_LAST_UPDATED_BY =>l_content_type_rec.LAST_UPDATED_BY,
268: p_LAST_UPDATE_LOGIN =>l_content_type_rec.LAST_UPDATE_LOGIN);
269:
270:
271: -- Insert The Corresponding Attributes in ibc_attribute_types_b table
272: IF l_attribute_type_tbl.COUNT <> 0 THEN
273: FOR i IN l_attribute_type_tbl.FIRST..l_attribute_type_tbl.LAST LOOP
274:
275: IF l_attribute_type_tbl.EXISTS(i) AND NOT IsATypeRecordEmpty(l_Attribute_Type_Tbl(i))

Line 457: FROM IBC_ATTRIBUTE_TYPES_B

453: CURSOR C_Attribute_Type(p_content_type_code IN VARCHAR2
454: ,p_attribute_type_code IN VARCHAR2)
455: IS
456: SELECT '1'
457: FROM IBC_ATTRIBUTE_TYPES_B
458: WHERE content_type_code = p_content_type_code
459: AND attribute_type_code = p_attribute_type_code;
460:
461: l_temp CHAR(1);

Line 697: FROM IBC_ATTRIBUTE_TYPES_B

693: CURSOR C_Attribute_Type(p_content_type_code IN VARCHAR2
694: ,p_attribute_type_code IN VARCHAR2)
695: IS
696: SELECT '1'
697: FROM IBC_ATTRIBUTE_TYPES_B
698: WHERE content_type_code = p_content_type_code
699: AND attribute_type_code = p_attribute_type_code;
700:
701: l_temp CHAR(1);

Line 821: -- Insert Or Update The Corresponding Attributes in ibc_attribute_types_b table

817:
818: END IF;
819:
820:
821: -- Insert Or Update The Corresponding Attributes in ibc_attribute_types_b table
822:
823: IF l_attribute_type_tbl.COUNT <> 0 THEN
824:
825: FOR i IN l_attribute_type_tbl.FIRST..l_attribute_type_tbl.LAST LOOP

Line 970: FROM IBC_ATTRIBUTE_TYPES_B

966:
967: CURSOR C_Attribute_Type
968: IS
969: SELECT attribute_Type_code
970: FROM IBC_ATTRIBUTE_TYPES_B
971: WHERE Reference_code = p_content_type_code;
972:
973: l_return_status VARCHAR2(1) := Fnd_Api.G_RET_STS_SUCCESS;
974:

Line 1164: FROM IBC_ATTRIBUTE_TYPES_B

1160: CURSOR C_Attribute_Type(p_content_type_code IN VARCHAR2
1161: ,p_attribute_type_code IN VARCHAR2)
1162: IS
1163: SELECT '1'
1164: FROM IBC_ATTRIBUTE_TYPES_B
1165: WHERE content_type_code = p_content_type_code
1166: AND attribute_type_code = p_attribute_type_code;
1167:
1168: l_temp CHAR(1);

Line 1463: FROM IBC_ATTRIBUTE_TYPES_B A, fnd_flex_value_sets F

1459: ) IS
1460:
1461: CURSOR C_Attribs IS
1462: SELECT A.flex_value_set_id,validation_type
1463: FROM IBC_ATTRIBUTE_TYPES_B A, fnd_flex_value_sets F
1464: WHERE a.flex_value_set_id = F.flex_value_set_id
1465: AND A.attribute_type_code = p_attribute_type_code
1466: AND A.content_type_code = p_content_type_code;
1467:

Line 1643: FROM IBC_ATTRIBUTE_TYPES_B B,IBC_ATTRIBUTE_TYPES_TL T

1639: ,B.LAST_UPDATED_BY
1640: ,B.LAST_UPDATE_DATE
1641: ,B.LAST_UPDATE_LOGIN
1642: ,B.OBJECT_VERSION_NUMBER
1643: FROM IBC_ATTRIBUTE_TYPES_B B,IBC_ATTRIBUTE_TYPES_TL T
1644: WHERE B.CONTENT_TYPE_CODE = p_Content_type_code
1645: AND B.content_type_code = T.CONTENT_TYPE_CODE
1646: AND B.ATTRIBUTE_TYPE_CODE = T.ATTRIBUTE_TYPE_CODE
1647: AND LANGUAGE = l_language