APPS.EGO_EXT_FWK_PUB dependencies on EGO_VARCHAR_TBL_TYPE

Line 1134: RETURN EGO_VARCHAR_TBL_TYPE

1130:
1131: FUNCTION Get_PKs_From_Attr_Group_Id (
1132: p_attr_group_id IN NUMBER
1133: )
1134: RETURN EGO_VARCHAR_TBL_TYPE
1135: IS
1136:
1137: l_application_id NUMBER;
1138: l_attr_group_type VARCHAR2(40);

Line 1148: RETURN EGO_VARCHAR_TBL_TYPE(TO_CHAR(l_application_id), l_attr_group_type, l_attr_group_name);

1144: INTO l_application_id, l_attr_group_type, l_attr_group_name
1145: FROM EGO_FND_DSC_FLX_CTX_EXT
1146: WHERE ATTR_GROUP_ID = p_attr_group_id;
1147:
1148: RETURN EGO_VARCHAR_TBL_TYPE(TO_CHAR(l_application_id), l_attr_group_type, l_attr_group_name);
1149:
1150: EXCEPTION
1151: WHEN NO_DATA_FOUND THEN
1152: RETURN NULL;

Line 1842: l_database_columns EGO_VARCHAR_TBL_TYPE;

1838: ,p_data_type IN VARCHAR2
1839: ,x_database_column OUT NOCOPY VARCHAR2
1840: ) IS
1841:
1842: l_database_columns EGO_VARCHAR_TBL_TYPE;
1843:
1844: BEGIN
1845:
1846: EGO_EXT_FWK_PUB.Get_Available_AttrDBCols (

Line 1870: l_database_columns EGO_VARCHAR_TBL_TYPE;

1866: ,p_data_type IN VARCHAR2
1867: ,x_database_column OUT NOCOPY VARCHAR2
1868: ) IS
1869:
1870: l_database_columns EGO_VARCHAR_TBL_TYPE;
1871:
1872: BEGIN
1873:
1874: EGO_EXT_FWK_PUB.Get_Available_AttrDBCols (

Line 1897: ,x_database_columns OUT NOCOPY EGO_VARCHAR_TBL_TYPE

1893: ,p_application_id IN NUMBER
1894: ,p_attr_group_type IN VARCHAR2
1895: ,p_attr_group_name IN VARCHAR2
1896: ,p_data_type IN VARCHAR2
1897: ,x_database_columns OUT NOCOPY EGO_VARCHAR_TBL_TYPE
1898: ) IS
1899:
1900: l_ext_table_name VARCHAR2(30);
1901: l_ext_table_id NUMBER;

Line 2014: ,x_database_columns OUT NOCOPY EGO_VARCHAR_TBL_TYPE

2010: PROCEDURE Get_Available_AttrDBCols (
2011: p_api_version IN NUMBER
2012: ,p_attr_group_id IN NUMBER
2013: ,p_data_type IN VARCHAR2
2014: ,x_database_columns OUT NOCOPY EGO_VARCHAR_TBL_TYPE
2015: ) IS
2016:
2017: l_attr_group_pks EGO_VARCHAR_TBL_TYPE;
2018:

Line 2017: l_attr_group_pks EGO_VARCHAR_TBL_TYPE;

2013: ,p_data_type IN VARCHAR2
2014: ,x_database_columns OUT NOCOPY EGO_VARCHAR_TBL_TYPE
2015: ) IS
2016:
2017: l_attr_group_pks EGO_VARCHAR_TBL_TYPE;
2018:
2019: BEGIN
2020:
2021: l_attr_group_pks := Get_PKs_From_Attr_Group_Id(p_attr_group_id);

Line 2941: l_attr_group_pks EGO_VARCHAR_TBL_TYPE;

2937: ,x_msg_count OUT NOCOPY NUMBER
2938: ,x_msg_data OUT NOCOPY VARCHAR2
2939: ) IS
2940:
2941: l_attr_group_pks EGO_VARCHAR_TBL_TYPE;
2942:
2943: BEGIN
2944:
2945: l_attr_group_pks := Get_PKs_From_Attr_Group_Id(p_source_attr_group_id);

Line 2998: l_attr_group_pks EGO_VARCHAR_TBL_TYPE;

2994: ,x_msg_data OUT NOCOPY VARCHAR2
2995: ) IS
2996:
2997: l_api_name CONSTANT VARCHAR2(30) := 'Update_Attribute_Group';
2998: l_attr_group_pks EGO_VARCHAR_TBL_TYPE;
2999:
3000: BEGIN
3001:
3002: -- Standard start of API savepoint

Line 3229: l_attr_group_pks EGO_VARCHAR_TBL_TYPE;

3225: ,x_msg_data OUT NOCOPY VARCHAR2
3226: ) IS
3227:
3228: l_api_name CONSTANT VARCHAR2(30) := 'Delete_Attribute_Group';
3229: l_attr_group_pks EGO_VARCHAR_TBL_TYPE;
3230:
3231: BEGIN
3232:
3233: -- Standard start of API savepoint