APPS.EGO_EXT_FWK_PUB dependencies on EGO_VARCHAR_TBL_TYPE

Line 1094: RETURN EGO_VARCHAR_TBL_TYPE

1090:
1091: FUNCTION Get_PKs_From_Attr_Group_Id (
1092: p_attr_group_id IN NUMBER
1093: )
1094: RETURN EGO_VARCHAR_TBL_TYPE
1095: IS
1096:
1097: l_application_id NUMBER;
1098: l_attr_group_type VARCHAR2(40);

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

1104: INTO l_application_id, l_attr_group_type, l_attr_group_name
1105: FROM EGO_FND_DSC_FLX_CTX_EXT
1106: WHERE ATTR_GROUP_ID = p_attr_group_id;
1107:
1108: RETURN EGO_VARCHAR_TBL_TYPE(TO_CHAR(l_application_id), l_attr_group_type, l_attr_group_name);
1109:
1110: EXCEPTION
1111: WHEN NO_DATA_FOUND THEN
1112: RETURN NULL;

Line 1760: l_database_columns EGO_VARCHAR_TBL_TYPE;

1756: ,p_data_type IN VARCHAR2
1757: ,x_database_column OUT NOCOPY VARCHAR2
1758: ) IS
1759:
1760: l_database_columns EGO_VARCHAR_TBL_TYPE;
1761:
1762: BEGIN
1763:
1764: EGO_EXT_FWK_PUB.Get_Available_AttrDBCols (

Line 1788: l_database_columns EGO_VARCHAR_TBL_TYPE;

1784: ,p_data_type IN VARCHAR2
1785: ,x_database_column OUT NOCOPY VARCHAR2
1786: ) IS
1787:
1788: l_database_columns EGO_VARCHAR_TBL_TYPE;
1789:
1790: BEGIN
1791:
1792: EGO_EXT_FWK_PUB.Get_Available_AttrDBCols (

Line 1815: ,x_database_columns OUT NOCOPY EGO_VARCHAR_TBL_TYPE

1811: ,p_application_id IN NUMBER
1812: ,p_attr_group_type IN VARCHAR2
1813: ,p_attr_group_name IN VARCHAR2
1814: ,p_data_type IN VARCHAR2
1815: ,x_database_columns OUT NOCOPY EGO_VARCHAR_TBL_TYPE
1816: ) IS
1817:
1818: l_ext_table_name VARCHAR2(30);
1819: l_ext_table_id NUMBER;

Line 1932: ,x_database_columns OUT NOCOPY EGO_VARCHAR_TBL_TYPE

1928: PROCEDURE Get_Available_AttrDBCols (
1929: p_api_version IN NUMBER
1930: ,p_attr_group_id IN NUMBER
1931: ,p_data_type IN VARCHAR2
1932: ,x_database_columns OUT NOCOPY EGO_VARCHAR_TBL_TYPE
1933: ) IS
1934:
1935: l_attr_group_pks EGO_VARCHAR_TBL_TYPE;
1936:

Line 1935: l_attr_group_pks EGO_VARCHAR_TBL_TYPE;

1931: ,p_data_type IN VARCHAR2
1932: ,x_database_columns OUT NOCOPY EGO_VARCHAR_TBL_TYPE
1933: ) IS
1934:
1935: l_attr_group_pks EGO_VARCHAR_TBL_TYPE;
1936:
1937: BEGIN
1938:
1939: l_attr_group_pks := Get_PKs_From_Attr_Group_Id(p_attr_group_id);

Line 2855: l_attr_group_pks EGO_VARCHAR_TBL_TYPE;

2851: ,x_msg_count OUT NOCOPY NUMBER
2852: ,x_msg_data OUT NOCOPY VARCHAR2
2853: ) IS
2854:
2855: l_attr_group_pks EGO_VARCHAR_TBL_TYPE;
2856:
2857: BEGIN
2858:
2859: l_attr_group_pks := Get_PKs_From_Attr_Group_Id(p_source_attr_group_id);

Line 2912: l_attr_group_pks EGO_VARCHAR_TBL_TYPE;

2908: ,x_msg_data OUT NOCOPY VARCHAR2
2909: ) IS
2910:
2911: l_api_name CONSTANT VARCHAR2(30) := 'Update_Attribute_Group';
2912: l_attr_group_pks EGO_VARCHAR_TBL_TYPE;
2913:
2914: BEGIN
2915:
2916: -- Standard start of API savepoint

Line 3143: l_attr_group_pks EGO_VARCHAR_TBL_TYPE;

3139: ,x_msg_data OUT NOCOPY VARCHAR2
3140: ) IS
3141:
3142: l_api_name CONSTANT VARCHAR2(30) := 'Delete_Attribute_Group';
3143: l_attr_group_pks EGO_VARCHAR_TBL_TYPE;
3144:
3145: BEGIN
3146:
3147: -- Standard start of API savepoint