DBA Data[Home] [Help]

APPS.IBC_CTYPE_PVT dependencies on JTF_VARCHAR2_TABLE_300

Line 1454: ,x_name OUT NOCOPY JTF_VARCHAR2_TABLE_300 -- 5

1450: ,P_Init_Msg_List IN VARCHAR2 --:= FND_API.G_FALSE
1451: ,p_content_type_code IN VARCHAR2 --1
1452: ,p_attribute_type_code IN VARCHAR2 --2
1453: ,x_code OUT NOCOPY JTF_VARCHAR2_TABLE_100 --4
1454: ,x_name OUT NOCOPY JTF_VARCHAR2_TABLE_300 -- 5
1455: ,x_description OUT NOCOPY JTF_VARCHAR2_TABLE_2000 --3
1456: ,X_Return_Status OUT NOCOPY VARCHAR2 --6
1457: ,X_Msg_Count OUT NOCOPY NUMBER -- 7
1458: ,X_Msg_Data OUT NOCOPY VARCHAR2 -- 8

Line 1585: ,x_ATTRIBUTE_TYPE_name OUT NOCOPY JTF_VARCHAR2_TABLE_300 -- 6

1581: ,x_content_type_name OUT NOCOPY VARCHAR2 -- 2
1582: ,x_content_type_description OUT NOCOPY VARCHAR2 -- 3
1583: ,x_content_type_status OUT NOCOPY VARCHAR2 -- 4
1584: ,X_ATTRIBUTE_TYPE_CODE OUT NOCOPY JTF_VARCHAR2_TABLE_100 -- 5
1585: ,x_ATTRIBUTE_TYPE_name OUT NOCOPY JTF_VARCHAR2_TABLE_300 -- 6
1586: ,x_DESCRIPTION OUT NOCOPY JTF_VARCHAR2_TABLE_2000 -- 7
1587: ,x_CONTENT_TYPE_CODE OUT NOCOPY JTF_VARCHAR2_TABLE_100 -- 8
1588: ,x_DATA_TYPE_CODE OUT NOCOPY JTF_VARCHAR2_TABLE_100 -- 9
1589: ,x_DATA_LENGTH OUT NOCOPY JTF_NUMBER_TABLE -- 10

Line 1594: ,x_DEFAULT_VALUE OUT NOCOPY JTF_VARCHAR2_TABLE_300 -- 15

1590: ,x_MIN_INSTANCES OUT NOCOPY JTF_NUMBER_TABLE -- 11
1591: ,x_MAX_INSTANCES OUT NOCOPY JTF_NUMBER_TABLE -- 12
1592: ,x_Flex_value_set_id OUT NOCOPY JTF_NUMBER_TABLE -- 13
1593: ,x_REFERENCE_CODE OUT NOCOPY JTF_VARCHAR2_TABLE_100 -- 14
1594: ,x_DEFAULT_VALUE OUT NOCOPY JTF_VARCHAR2_TABLE_300 -- 15
1595: ,x_UPDATEABLE_FLAG OUT NOCOPY JTF_VARCHAR2_TABLE_100 -- 16 Varchar2(1)
1596: ,x_CREATED_BY OUT NOCOPY JTF_NUMBER_TABLE -- 17
1597: ,x_CREATION_DATE OUT NOCOPY JTF_DATE_TABLE -- 18
1598: ,x_LAST_UPDATED_BY OUT NOCOPY JTF_NUMBER_TABLE --19

Line 1866: l_code JTF_VARCHAR2_TABLE_300 := JTF_VARCHAR2_TABLE_300();

1862: lx_mapping_code VARCHAR2(32000);
1863: l_vset_type VARCHAR2(1);
1864: l_api_name VARCHAR2(30) := 'IS_VALID_FLEX_VALUE';
1865:
1866: l_code JTF_VARCHAR2_TABLE_300 := JTF_VARCHAR2_TABLE_300();
1867: l_name JTF_VARCHAR2_TABLE_300 := JTF_VARCHAR2_TABLE_300();
1868: l_description JTF_VARCHAR2_TABLE_3000 := JTF_VARCHAR2_TABLE_3000();
1869: l_temp CHAR(1);
1870:

Line 1867: l_name JTF_VARCHAR2_TABLE_300 := JTF_VARCHAR2_TABLE_300();

1863: l_vset_type VARCHAR2(1);
1864: l_api_name VARCHAR2(30) := 'IS_VALID_FLEX_VALUE';
1865:
1866: l_code JTF_VARCHAR2_TABLE_300 := JTF_VARCHAR2_TABLE_300();
1867: l_name JTF_VARCHAR2_TABLE_300 := JTF_VARCHAR2_TABLE_300();
1868: l_description JTF_VARCHAR2_TABLE_3000 := JTF_VARCHAR2_TABLE_3000();
1869: l_temp CHAR(1);
1870:
1871: l_meaning VARCHAR2(240);

Line 1868: l_description JTF_VARCHAR2_TABLE_3000 := JTF_VARCHAR2_TABLE_3000();

1864: l_api_name VARCHAR2(30) := 'IS_VALID_FLEX_VALUE';
1865:
1866: l_code JTF_VARCHAR2_TABLE_300 := JTF_VARCHAR2_TABLE_300();
1867: l_name JTF_VARCHAR2_TABLE_300 := JTF_VARCHAR2_TABLE_300();
1868: l_description JTF_VARCHAR2_TABLE_3000 := JTF_VARCHAR2_TABLE_3000();
1869: l_temp CHAR(1);
1870:
1871: l_meaning VARCHAR2(240);
1872: l_id VARCHAR2(240);

Line 1876: FROM TABLE(CAST(l_code AS JTF_VARCHAR2_TABLE_300)) A

1872: l_id VARCHAR2(240);
1873:
1874: CURSOR C_Flex_Value_Code IS
1875: SELECT '1'
1876: FROM TABLE(CAST(l_code AS JTF_VARCHAR2_TABLE_300)) A
1877: WHERE A.COLUMN_VALUE = p_flex_value_code;
1878:
1879: CURSOR C_flex_validation_tab IS
1880: SELECT id_column_name,meaning_column_name