APPS.PO_UDA_DATA_UTIL dependencies on FND_OBJECTS

Line 471: FROM FND_OBJECTS

467:
468: d_progress := 20;
469: SELECT OBJECT_ID
470: INTO v_object_id
471: FROM FND_OBJECTS
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

Line 568: FROM FND_OBJECTS

564:
565: d_progress := 20;
566: SELECT OBJECT_ID
567: INTO v_object_id
568: FROM FND_OBJECTS
569: WHERE OBJ_NAME = g_object_dff_tl(v_entity_type).l_object_name;
570:
571: IF PO_LOG.d_stmt THEN
572: PO_LOG.stmt(d_module, d_progress, 'v_object_id', v_object_id);

Line 906: l_from_object FND_OBJECTS%ROWTYPE;

902:
903: l_from_object_cr g_object_dff_cr;
904: l_to_object_cr g_object_dff_cr;
905:
906: l_from_object FND_OBJECTS%ROWTYPE;
907: l_to_object FND_OBJECTS%ROWTYPE;
908: l_to_data_level_id NUMBER;
909: l_from_data_level_id NUMBER;
910:

Line 907: l_to_object FND_OBJECTS%ROWTYPE;

903: l_from_object_cr g_object_dff_cr;
904: l_to_object_cr g_object_dff_cr;
905:
906: l_from_object FND_OBJECTS%ROWTYPE;
907: l_to_object FND_OBJECTS%ROWTYPE;
908: l_to_data_level_id NUMBER;
909: l_from_data_level_id NUMBER;
910:
911:

Line 988: FROM FND_OBJECTS

984: l_to_object_cr := g_object_dff_tl(to_attr_group_Type);
985:
986: SELECT *
987: INTO l_from_object
988: FROM FND_OBJECTS
989: WHERE OBJ_NAME = l_from_object_cr.l_object_name;
990:
991: SELECT *
992: INTO l_to_object

Line 993: FROM FND_OBJECTS

989: WHERE OBJ_NAME = l_from_object_cr.l_object_name;
990:
991: SELECT *
992: INTO l_to_object
993: FROM FND_OBJECTS
994: WHERE OBJ_NAME = l_to_object_cr.l_object_name;
995:
996: d_progress := 010;
997:

Line 1628: l_object FND_OBJECTS%ROWTYPE;

1624: d_progress NUMBER;
1625:
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;

Line 1665: FROM FND_OBJECTS

1661: l_object_dff_cr := g_object_dff_tl(l_attr_group_Type);
1662:
1663: SELECT *
1664: INTO l_object
1665: FROM FND_OBJECTS
1666: WHERE OBJ_NAME = l_object_dff_cr.l_object_name;
1667:
1668: SELECT data_level_id
1669: INTO l_main_data_level_id

Line 1858: l_object FND_OBJECTS%ROWTYPE;

1854: d_progress NUMBER;
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);

Line 1901: FROM FND_OBJECTS

1897: l_object_dff_cr := g_object_dff_tl(l_attr_group_Type);
1898:
1899: SELECT *
1900: INTO l_object
1901: FROM FND_OBJECTS
1902: WHERE OBJ_NAME = l_object_dff_cr.l_object_name;
1903:
1904: SELECT *
1905: INTO l_main_data_level

Line 2670: from fnd_objects

2666: ||' where attribute_group_id = '|| l_attr_grp_id ;
2667: -- construct the primary key part
2668: select pk1_column_name, pk2_column_name, pk3_column_name, pk4_column_name, pk5_column_name
2669: into l_pk1_col_name, l_pk2_col_name, l_pk3_col_name, l_pk4_col_name, l_pk5_col_name
2670: from fnd_objects
2671: where obj_name = l_db_object_name
2672: and rownum < 2;
2673:
2674: if l_pk1_col_name is not null then