DBA Data[Home] [Help]

APPS.EGO_USER_ATTRS_DATA_PVT dependencies on EGO_EXTFWK_S

Line 7493: SELECT EGO_EXTFWK_S.NEXTVAL INTO l_new_extension_id FROM DUAL;

7489: -- If we haven't set it yet, get a sequence-generated extension --
7490: -- ID to use for insertion into both the base and TL tables --
7491: ------------------------------------------------------------------
7492: IF (l_new_extension_id IS NULL) THEN
7493: SELECT EGO_EXTFWK_S.NEXTVAL INTO l_new_extension_id FROM DUAL;
7494: END IF;
7495:
7496: --Start 4105841
7497: Get_Changed_Attributes(

Line 14901: l_dynamic_sql := ' SELECT EXTENSION_ID, EGO_EXTFWK_S.NEXTVAL '||

14897: --bug 8655864 start
14898: Debug_msg(l_api_name || ' l_where_dtlevel_sql: ' || l_where_dtlevel_sql);
14899: IF (p_attr_group_list IS NOT NULL) THEN
14900:
14901: l_dynamic_sql := ' SELECT EXTENSION_ID, EGO_EXTFWK_S.NEXTVAL '||
14902: ' FROM '||NVL(l_vl_name, l_b_table_name)||
14903: ' WHERE '||l_where_pk_sql||l_where_dtlevel_sql||
14904: ' ATTR_GROUP_ID IN ('||p_attr_group_list||')';
14905:

Line 14907: l_dynamic_sql := ' SELECT EXTENSION_ID, EGO_EXTFWK_S.NEXTVAL '||

14903: ' WHERE '||l_where_pk_sql||l_where_dtlevel_sql||
14904: ' ATTR_GROUP_ID IN ('||p_attr_group_list||')';
14905:
14906: ELSE
14907: l_dynamic_sql := ' SELECT EXTENSION_ID, EGO_EXTFWK_S.NEXTVAL '||
14908: ' FROM '||NVL(l_vl_name, l_b_table_name)||
14909: ' WHERE '||l_where_pk_sql||l_where_dtlevel_sql;
14910:
14911: -------------------------------------------------------------