69: l_entity_sql VARCHAR2(2000);
70: l_sqlCursor integer;
71: l_dummy number;
72: l_attribute_tbl ATTRIBUTE_TBL_TYPE;
73: l_entity_Table fnd_document_entities.table_name%TYPE;
74: l_pk1_Column fnd_document_entities.pk1_column%TYPE;
75: l_pk2_Column fnd_document_entities.pk2_column%TYPE;
76: l_pk3_Column fnd_document_entities.pk3_column%TYPE;
77: l_pk4_Column fnd_document_entities.pk4_column%TYPE;
70: l_sqlCursor integer;
71: l_dummy number;
72: l_attribute_tbl ATTRIBUTE_TBL_TYPE;
73: l_entity_Table fnd_document_entities.table_name%TYPE;
74: l_pk1_Column fnd_document_entities.pk1_column%TYPE;
75: l_pk2_Column fnd_document_entities.pk2_column%TYPE;
76: l_pk3_Column fnd_document_entities.pk3_column%TYPE;
77: l_pk4_Column fnd_document_entities.pk4_column%TYPE;
78: l_pk5_Column fnd_document_entities.pk5_column%TYPE;
71: l_dummy number;
72: l_attribute_tbl ATTRIBUTE_TBL_TYPE;
73: l_entity_Table fnd_document_entities.table_name%TYPE;
74: l_pk1_Column fnd_document_entities.pk1_column%TYPE;
75: l_pk2_Column fnd_document_entities.pk2_column%TYPE;
76: l_pk3_Column fnd_document_entities.pk3_column%TYPE;
77: l_pk4_Column fnd_document_entities.pk4_column%TYPE;
78: l_pk5_Column fnd_document_entities.pk5_column%TYPE;
79: --
72: l_attribute_tbl ATTRIBUTE_TBL_TYPE;
73: l_entity_Table fnd_document_entities.table_name%TYPE;
74: l_pk1_Column fnd_document_entities.pk1_column%TYPE;
75: l_pk2_Column fnd_document_entities.pk2_column%TYPE;
76: l_pk3_Column fnd_document_entities.pk3_column%TYPE;
77: l_pk4_Column fnd_document_entities.pk4_column%TYPE;
78: l_pk5_Column fnd_document_entities.pk5_column%TYPE;
79: --
80: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
73: l_entity_Table fnd_document_entities.table_name%TYPE;
74: l_pk1_Column fnd_document_entities.pk1_column%TYPE;
75: l_pk2_Column fnd_document_entities.pk2_column%TYPE;
76: l_pk3_Column fnd_document_entities.pk3_column%TYPE;
77: l_pk4_Column fnd_document_entities.pk4_column%TYPE;
78: l_pk5_Column fnd_document_entities.pk5_column%TYPE;
79: --
80: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
81: --
74: l_pk1_Column fnd_document_entities.pk1_column%TYPE;
75: l_pk2_Column fnd_document_entities.pk2_column%TYPE;
76: l_pk3_Column fnd_document_entities.pk3_column%TYPE;
77: l_pk4_Column fnd_document_entities.pk4_column%TYPE;
78: l_pk5_Column fnd_document_entities.pk5_column%TYPE;
79: --
80: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
81: --
82: BEGIN
87: SELECT table_name, pk1_column, pk2_column
88: , pk3_column, pk4_column, pk5_column
89: INTO l_entity_table, l_pk1_column, l_pk2_column
90: , l_pk3_column, l_pk4_column, l_pk5_column
91: FROM FND_DOCUMENT_ENTITIES
92: WHERE data_object_code = p_entity_name;
93:
94: --------------------------------------------------------------
95: -- CONSTRUCT THE SQL STATEMENT