DBA Data[Home] [Help]

APPS.PO_UDA_DATA_UTIL dependencies on EGO_DATA_LEVEL_B

Line 221: FROM EGO_DATA_LEVEL_B

217:
218: d_progress := 30;
219: SELECT DATA_LEVEL_NAME
220: INTO l_data_level
221: FROM EGO_DATA_LEVEL_B
222: WHERE ATTR_GROUP_TYPE = l_attr_group_type
223: AND DATA_LEVEL_NAME NOT LIKE '%ARCHIVE';
224:
225: d_progress := 40;

Line 476: FROM EGO_DATA_LEVEL_B

472: WHERE OBJ_NAME = g_object_dff_tl(v_entity_type).l_object_name;
473:
474: SELECT DATA_LEVEL_NAME
475: INTO v_data_level
476: FROM EGO_DATA_LEVEL_B
477: WHERE DATA_LEVEL_NAME NOT LIKE '%ARCHIVE'
478: AND ATTR_GROUP_TYPE = v_entity_type;
479:
480: IF PO_LOG.d_stmt THEN

Line 1630: l_archive_data_level EGO_DATA_LEVEL_B%ROWTYPE;

1626: l_attr_group_Type VARCHAR2(300);
1627: l_object_dff_cr g_object_dff_cr;
1628: l_object FND_OBJECTS%ROWTYPE;
1629: l_main_data_level_id NUMBER;
1630: l_archive_data_level EGO_DATA_LEVEL_B%ROWTYPE;
1631: l_to_data_level_id NUMBER;
1632: l_new_dtlevel_col_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
1633: l_old_dtlevel_col_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
1634: l_return_status VARCHAR2(1);

Line 1670: FROM EGO_DATA_LEVEL_B

1666: WHERE OBJ_NAME = l_object_dff_cr.l_object_name;
1667:
1668: SELECT data_level_id
1669: INTO l_main_data_level_id
1670: FROM EGO_DATA_LEVEL_B
1671: WHERE ATTR_GROUP_TYPE = l_attr_group_Type
1672: AND DATA_LEVEL_NAME NOT LIKE '%ARCHIVE';
1673:
1674: SELECT *

Line 1676: FROM EGO_DATA_LEVEL_B

1672: AND DATA_LEVEL_NAME NOT LIKE '%ARCHIVE';
1673:
1674: SELECT *
1675: INTO l_archive_data_level
1676: FROM EGO_DATA_LEVEL_B
1677: WHERE ATTR_GROUP_TYPE = l_attr_group_Type
1678: AND DATA_LEVEL_NAME LIKE '%ARCHIVE';
1679:
1680: IF PO_LOG.d_stmt THEN

Line 1859: l_main_data_level EGO_DATA_LEVEL_B%ROWTYPE;

1855:
1856: l_attr_group_Type VARCHAR2(300);
1857: l_object_dff_cr g_object_dff_cr;
1858: l_object FND_OBJECTS%ROWTYPE;
1859: l_main_data_level EGO_DATA_LEVEL_B%ROWTYPE;
1860: l_to_data_level_id NUMBER;
1861: l_dtlevel_col_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
1862: l_return_status VARCHAR2(1);
1863: l_errorcode NUMBER;

Line 1906: FROM EGO_DATA_LEVEL_B

1902: WHERE OBJ_NAME = l_object_dff_cr.l_object_name;
1903:
1904: SELECT *
1905: INTO l_main_data_level
1906: FROM EGO_DATA_LEVEL_B
1907: WHERE ATTR_GROUP_TYPE = l_attr_group_Type
1908: AND DATA_LEVEL_NAME NOT LIKE '%ARCHIVE';
1909:
1910: IF PO_LOG.d_stmt THEN