eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.EGO_ODI_PUB dependencies on EGO_VALIDATION_TABLE_INFO_V

Line 7576: ego_validation_table_info_v.flex_value_set_id,

7572: IS
7573:
7574: CURSOR Table_VS_List IS -- Get all the TableInfo entity type records from Flat table for given Session Id and ODI Session Id
7575: SELECT ego_pub_ws_flat_recs.sequence_id,
7576: ego_validation_table_info_v.flex_value_set_id,
7577: ego_validation_table_info_v.additional_where_clause
7578:
7579: FROM ego_pub_ws_flat_recs,
7580: ego_validation_table_info_v

Line 7577: ego_validation_table_info_v.additional_where_clause

7573:
7574: CURSOR Table_VS_List IS -- Get all the TableInfo entity type records from Flat table for given Session Id and ODI Session Id
7575: SELECT ego_pub_ws_flat_recs.sequence_id,
7576: ego_validation_table_info_v.flex_value_set_id,
7577: ego_validation_table_info_v.additional_where_clause
7578:
7579: FROM ego_pub_ws_flat_recs,
7580: ego_validation_table_info_v
7581:

Line 7580: ego_validation_table_info_v

7576: ego_validation_table_info_v.flex_value_set_id,
7577: ego_validation_table_info_v.additional_where_clause
7578:
7579: FROM ego_pub_ws_flat_recs,
7580: ego_validation_table_info_v
7581:
7582: WHERE ego_pub_ws_flat_recs.pk1_value = ego_validation_table_info_v.flex_value_set_id
7583: AND ego_pub_ws_flat_recs.session_id = p_Session_Id
7584: AND ego_pub_ws_flat_recs.odi_session_id = p_ODISession_Id

Line 7582: WHERE ego_pub_ws_flat_recs.pk1_value = ego_validation_table_info_v.flex_value_set_id

7578:
7579: FROM ego_pub_ws_flat_recs,
7580: ego_validation_table_info_v
7581:
7582: WHERE ego_pub_ws_flat_recs.pk1_value = ego_validation_table_info_v.flex_value_set_id
7583: AND ego_pub_ws_flat_recs.session_id = p_Session_Id
7584: AND ego_pub_ws_flat_recs.odi_session_id = p_ODISession_Id
7585: AND ego_pub_ws_flat_recs.entity_type = 'TableInfo';
7586:

Line 7611: ego_validation_table_info_v.flex_value_set_id,

7607: p_ODISession_Id,
7608: 'TableInfo',
7609: ego_pub_ws_flat_recs_s.nextval,
7610: ego_pub_ws_flat_recs.sequence_id,
7611: ego_validation_table_info_v.flex_value_set_id,
7612: XMLCONCAT( XMLELEMENT("AppName",ego_validation_table_info_v.table_application_name),
7613: XMLELEMENT("AppId",ego_validation_table_info_v.table_application_id),
7614: XMLELEMENT("TableName",ego_validation_table_info_v.application_table_name),
7615: XMLELEMENT("ValueColName",ego_validation_table_info_v.value_column_name),

Line 7612: XMLCONCAT( XMLELEMENT("AppName",ego_validation_table_info_v.table_application_name),

7608: 'TableInfo',
7609: ego_pub_ws_flat_recs_s.nextval,
7610: ego_pub_ws_flat_recs.sequence_id,
7611: ego_validation_table_info_v.flex_value_set_id,
7612: XMLCONCAT( XMLELEMENT("AppName",ego_validation_table_info_v.table_application_name),
7613: XMLELEMENT("AppId",ego_validation_table_info_v.table_application_id),
7614: XMLELEMENT("TableName",ego_validation_table_info_v.application_table_name),
7615: XMLELEMENT("ValueColName",ego_validation_table_info_v.value_column_name),
7616: XMLELEMENT("ValueColType",ego_validation_table_info_v.value_column_type),

Line 7613: XMLELEMENT("AppId",ego_validation_table_info_v.table_application_id),

7609: ego_pub_ws_flat_recs_s.nextval,
7610: ego_pub_ws_flat_recs.sequence_id,
7611: ego_validation_table_info_v.flex_value_set_id,
7612: XMLCONCAT( XMLELEMENT("AppName",ego_validation_table_info_v.table_application_name),
7613: XMLELEMENT("AppId",ego_validation_table_info_v.table_application_id),
7614: XMLELEMENT("TableName",ego_validation_table_info_v.application_table_name),
7615: XMLELEMENT("ValueColName",ego_validation_table_info_v.value_column_name),
7616: XMLELEMENT("ValueColType",ego_validation_table_info_v.value_column_type),
7617: XMLELEMENT("ValueColSize",ego_validation_table_info_v.value_column_size),

Line 7614: XMLELEMENT("TableName",ego_validation_table_info_v.application_table_name),

7610: ego_pub_ws_flat_recs.sequence_id,
7611: ego_validation_table_info_v.flex_value_set_id,
7612: XMLCONCAT( XMLELEMENT("AppName",ego_validation_table_info_v.table_application_name),
7613: XMLELEMENT("AppId",ego_validation_table_info_v.table_application_id),
7614: XMLELEMENT("TableName",ego_validation_table_info_v.application_table_name),
7615: XMLELEMENT("ValueColName",ego_validation_table_info_v.value_column_name),
7616: XMLELEMENT("ValueColType",ego_validation_table_info_v.value_column_type),
7617: XMLELEMENT("ValueColSize",ego_validation_table_info_v.value_column_size),
7618: XMLELEMENT("IDColName",ego_validation_table_info_v.id_column_name),

Line 7615: XMLELEMENT("ValueColName",ego_validation_table_info_v.value_column_name),

7611: ego_validation_table_info_v.flex_value_set_id,
7612: XMLCONCAT( XMLELEMENT("AppName",ego_validation_table_info_v.table_application_name),
7613: XMLELEMENT("AppId",ego_validation_table_info_v.table_application_id),
7614: XMLELEMENT("TableName",ego_validation_table_info_v.application_table_name),
7615: XMLELEMENT("ValueColName",ego_validation_table_info_v.value_column_name),
7616: XMLELEMENT("ValueColType",ego_validation_table_info_v.value_column_type),
7617: XMLELEMENT("ValueColSize",ego_validation_table_info_v.value_column_size),
7618: XMLELEMENT("IDColName",ego_validation_table_info_v.id_column_name),
7619: XMLELEMENT("IDColType",ego_validation_table_info_v.id_column_type),

Line 7616: XMLELEMENT("ValueColType",ego_validation_table_info_v.value_column_type),

7612: XMLCONCAT( XMLELEMENT("AppName",ego_validation_table_info_v.table_application_name),
7613: XMLELEMENT("AppId",ego_validation_table_info_v.table_application_id),
7614: XMLELEMENT("TableName",ego_validation_table_info_v.application_table_name),
7615: XMLELEMENT("ValueColName",ego_validation_table_info_v.value_column_name),
7616: XMLELEMENT("ValueColType",ego_validation_table_info_v.value_column_type),
7617: XMLELEMENT("ValueColSize",ego_validation_table_info_v.value_column_size),
7618: XMLELEMENT("IDColName",ego_validation_table_info_v.id_column_name),
7619: XMLELEMENT("IDColType",ego_validation_table_info_v.id_column_type),
7620: XMLELEMENT("IDColSize",ego_validation_table_info_v.id_column_size),

Line 7617: XMLELEMENT("ValueColSize",ego_validation_table_info_v.value_column_size),

7613: XMLELEMENT("AppId",ego_validation_table_info_v.table_application_id),
7614: XMLELEMENT("TableName",ego_validation_table_info_v.application_table_name),
7615: XMLELEMENT("ValueColName",ego_validation_table_info_v.value_column_name),
7616: XMLELEMENT("ValueColType",ego_validation_table_info_v.value_column_type),
7617: XMLELEMENT("ValueColSize",ego_validation_table_info_v.value_column_size),
7618: XMLELEMENT("IDColName",ego_validation_table_info_v.id_column_name),
7619: XMLELEMENT("IDColType",ego_validation_table_info_v.id_column_type),
7620: XMLELEMENT("IDColSize",ego_validation_table_info_v.id_column_size),
7621: XMLELEMENT("MeaningColName",ego_validation_table_info_v.meaning_column_name),

Line 7618: XMLELEMENT("IDColName",ego_validation_table_info_v.id_column_name),

7614: XMLELEMENT("TableName",ego_validation_table_info_v.application_table_name),
7615: XMLELEMENT("ValueColName",ego_validation_table_info_v.value_column_name),
7616: XMLELEMENT("ValueColType",ego_validation_table_info_v.value_column_type),
7617: XMLELEMENT("ValueColSize",ego_validation_table_info_v.value_column_size),
7618: XMLELEMENT("IDColName",ego_validation_table_info_v.id_column_name),
7619: XMLELEMENT("IDColType",ego_validation_table_info_v.id_column_type),
7620: XMLELEMENT("IDColSize",ego_validation_table_info_v.id_column_size),
7621: XMLELEMENT("MeaningColName",ego_validation_table_info_v.meaning_column_name),
7622: XMLELEMENT("MeaningColType",ego_validation_table_info_v.meaning_column_type),

Line 7619: XMLELEMENT("IDColType",ego_validation_table_info_v.id_column_type),

7615: XMLELEMENT("ValueColName",ego_validation_table_info_v.value_column_name),
7616: XMLELEMENT("ValueColType",ego_validation_table_info_v.value_column_type),
7617: XMLELEMENT("ValueColSize",ego_validation_table_info_v.value_column_size),
7618: XMLELEMENT("IDColName",ego_validation_table_info_v.id_column_name),
7619: XMLELEMENT("IDColType",ego_validation_table_info_v.id_column_type),
7620: XMLELEMENT("IDColSize",ego_validation_table_info_v.id_column_size),
7621: XMLELEMENT("MeaningColName",ego_validation_table_info_v.meaning_column_name),
7622: XMLELEMENT("MeaningColType",ego_validation_table_info_v.meaning_column_type),
7623: XMLELEMENT("MeaningColSize",ego_validation_table_info_v.meaning_column_size)

Line 7620: XMLELEMENT("IDColSize",ego_validation_table_info_v.id_column_size),

7616: XMLELEMENT("ValueColType",ego_validation_table_info_v.value_column_type),
7617: XMLELEMENT("ValueColSize",ego_validation_table_info_v.value_column_size),
7618: XMLELEMENT("IDColName",ego_validation_table_info_v.id_column_name),
7619: XMLELEMENT("IDColType",ego_validation_table_info_v.id_column_type),
7620: XMLELEMENT("IDColSize",ego_validation_table_info_v.id_column_size),
7621: XMLELEMENT("MeaningColName",ego_validation_table_info_v.meaning_column_name),
7622: XMLELEMENT("MeaningColType",ego_validation_table_info_v.meaning_column_type),
7623: XMLELEMENT("MeaningColSize",ego_validation_table_info_v.meaning_column_size)
7624: ).getClobVal(),

Line 7621: XMLELEMENT("MeaningColName",ego_validation_table_info_v.meaning_column_name),

7617: XMLELEMENT("ValueColSize",ego_validation_table_info_v.value_column_size),
7618: XMLELEMENT("IDColName",ego_validation_table_info_v.id_column_name),
7619: XMLELEMENT("IDColType",ego_validation_table_info_v.id_column_type),
7620: XMLELEMENT("IDColSize",ego_validation_table_info_v.id_column_size),
7621: XMLELEMENT("MeaningColName",ego_validation_table_info_v.meaning_column_name),
7622: XMLELEMENT("MeaningColType",ego_validation_table_info_v.meaning_column_type),
7623: XMLELEMENT("MeaningColSize",ego_validation_table_info_v.meaning_column_size)
7624: ).getClobVal(),
7625: SYSDATE

Line 7622: XMLELEMENT("MeaningColType",ego_validation_table_info_v.meaning_column_type),

7618: XMLELEMENT("IDColName",ego_validation_table_info_v.id_column_name),
7619: XMLELEMENT("IDColType",ego_validation_table_info_v.id_column_type),
7620: XMLELEMENT("IDColSize",ego_validation_table_info_v.id_column_size),
7621: XMLELEMENT("MeaningColName",ego_validation_table_info_v.meaning_column_name),
7622: XMLELEMENT("MeaningColType",ego_validation_table_info_v.meaning_column_type),
7623: XMLELEMENT("MeaningColSize",ego_validation_table_info_v.meaning_column_size)
7624: ).getClobVal(),
7625: SYSDATE
7626: FROM ego_pub_ws_flat_recs,

Line 7623: XMLELEMENT("MeaningColSize",ego_validation_table_info_v.meaning_column_size)

7619: XMLELEMENT("IDColType",ego_validation_table_info_v.id_column_type),
7620: XMLELEMENT("IDColSize",ego_validation_table_info_v.id_column_size),
7621: XMLELEMENT("MeaningColName",ego_validation_table_info_v.meaning_column_name),
7622: XMLELEMENT("MeaningColType",ego_validation_table_info_v.meaning_column_type),
7623: XMLELEMENT("MeaningColSize",ego_validation_table_info_v.meaning_column_size)
7624: ).getClobVal(),
7625: SYSDATE
7626: FROM ego_pub_ws_flat_recs,
7627: ego_validation_table_info_v

Line 7627: ego_validation_table_info_v

7623: XMLELEMENT("MeaningColSize",ego_validation_table_info_v.meaning_column_size)
7624: ).getClobVal(),
7625: SYSDATE
7626: FROM ego_pub_ws_flat_recs,
7627: ego_validation_table_info_v
7628: WHERE ego_pub_ws_flat_recs.pk1_value=ego_validation_table_info_v.flex_value_set_id
7629: AND (
7630: ego_pub_ws_flat_recs.session_id = p_Session_Id
7631: AND ego_pub_ws_flat_recs.odi_session_id = p_ODISession_Id

Line 7628: WHERE ego_pub_ws_flat_recs.pk1_value=ego_validation_table_info_v.flex_value_set_id

7624: ).getClobVal(),
7625: SYSDATE
7626: FROM ego_pub_ws_flat_recs,
7627: ego_validation_table_info_v
7628: WHERE ego_pub_ws_flat_recs.pk1_value=ego_validation_table_info_v.flex_value_set_id
7629: AND (
7630: ego_pub_ws_flat_recs.session_id = p_Session_Id
7631: AND ego_pub_ws_flat_recs.odi_session_id = p_ODISession_Id
7632: AND ego_pub_ws_flat_recs.entity_type = 'ValueSet'

Line 7655: ego_validation_table_info_v.flex_value_set_id,

7651: p_ODISession_Id,
7652: 'WhereClause',
7653: ego_pub_ws_flat_recs_s.nextval,
7654: ego_pub_ws_flat_recs.sequence_id,
7655: ego_validation_table_info_v.flex_value_set_id,
7656: To_Lob(ego_validation_table_info_v.additional_where_clause),
7657: SYSDATE
7658: FROM ego_pub_ws_flat_recs,
7659: ego_validation_table_info_v

Line 7656: To_Lob(ego_validation_table_info_v.additional_where_clause),

7652: 'WhereClause',
7653: ego_pub_ws_flat_recs_s.nextval,
7654: ego_pub_ws_flat_recs.sequence_id,
7655: ego_validation_table_info_v.flex_value_set_id,
7656: To_Lob(ego_validation_table_info_v.additional_where_clause),
7657: SYSDATE
7658: FROM ego_pub_ws_flat_recs,
7659: ego_validation_table_info_v
7660: WHERE ego_pub_ws_flat_recs.pk1_value=ego_validation_table_info_v.flex_value_set_id

Line 7659: ego_validation_table_info_v

7655: ego_validation_table_info_v.flex_value_set_id,
7656: To_Lob(ego_validation_table_info_v.additional_where_clause),
7657: SYSDATE
7658: FROM ego_pub_ws_flat_recs,
7659: ego_validation_table_info_v
7660: WHERE ego_pub_ws_flat_recs.pk1_value=ego_validation_table_info_v.flex_value_set_id
7661: AND (
7662: ego_pub_ws_flat_recs.session_id = p_Session_Id
7663: AND ego_pub_ws_flat_recs.odi_session_id = p_ODISession_Id

Line 7660: WHERE ego_pub_ws_flat_recs.pk1_value=ego_validation_table_info_v.flex_value_set_id

7656: To_Lob(ego_validation_table_info_v.additional_where_clause),
7657: SYSDATE
7658: FROM ego_pub_ws_flat_recs,
7659: ego_validation_table_info_v
7660: WHERE ego_pub_ws_flat_recs.pk1_value=ego_validation_table_info_v.flex_value_set_id
7661: AND (
7662: ego_pub_ws_flat_recs.session_id = p_Session_Id
7663: AND ego_pub_ws_flat_recs.odi_session_id = p_ODISession_Id
7664: AND ego_pub_ws_flat_recs.entity_type = 'TableInfo'

Line 7708: ego_validation_table_info_v.flex_value_set_id,

7704: IS
7705:
7706: CURSOR Table_VS_List IS -- Get all the 'TableInfo' entity type records from Flat table for given Session Id and ODI Session Id
7707: SELECT ego_pub_ws_flat_recs.sequence_id,
7708: ego_validation_table_info_v.flex_value_set_id,
7709: ego_validation_table_info_v.additional_where_clause
7710:
7711: FROM ego_pub_ws_flat_recs,
7712: ego_validation_table_info_v

Line 7709: ego_validation_table_info_v.additional_where_clause

7705:
7706: CURSOR Table_VS_List IS -- Get all the 'TableInfo' entity type records from Flat table for given Session Id and ODI Session Id
7707: SELECT ego_pub_ws_flat_recs.sequence_id,
7708: ego_validation_table_info_v.flex_value_set_id,
7709: ego_validation_table_info_v.additional_where_clause
7710:
7711: FROM ego_pub_ws_flat_recs,
7712: ego_validation_table_info_v
7713:

Line 7712: ego_validation_table_info_v

7708: ego_validation_table_info_v.flex_value_set_id,
7709: ego_validation_table_info_v.additional_where_clause
7710:
7711: FROM ego_pub_ws_flat_recs,
7712: ego_validation_table_info_v
7713:
7714: WHERE ego_pub_ws_flat_recs.pk1_value = ego_validation_table_info_v.flex_value_set_id
7715: AND ego_pub_ws_flat_recs.session_id = p_Session_Id
7716: AND ego_pub_ws_flat_recs.odi_session_id = p_ODISession_Id

Line 7714: WHERE ego_pub_ws_flat_recs.pk1_value = ego_validation_table_info_v.flex_value_set_id

7710:
7711: FROM ego_pub_ws_flat_recs,
7712: ego_validation_table_info_v
7713:
7714: WHERE ego_pub_ws_flat_recs.pk1_value = ego_validation_table_info_v.flex_value_set_id
7715: AND ego_pub_ws_flat_recs.session_id = p_Session_Id
7716: AND ego_pub_ws_flat_recs.odi_session_id = p_ODISession_Id
7717: AND ego_pub_ws_flat_recs.entity_type = 'TableInfo';
7718:

Line 7743: ego_validation_table_info_v.flex_value_set_id,

7739: p_ODISession_Id,
7740: 'TableInfo',
7741: ego_pub_ws_flat_recs_s.nextval,
7742: ego_pub_ws_flat_recs.sequence_id,
7743: ego_validation_table_info_v.flex_value_set_id,
7744: XMLCONCAT( XMLELEMENT("AppName",ego_validation_table_info_v.table_application_name),
7745: XMLELEMENT("AppId",ego_validation_table_info_v.table_application_id),
7746: XMLELEMENT("TableName",ego_validation_table_info_v.application_table_name),
7747: XMLELEMENT("ValueColName",ego_validation_table_info_v.value_column_name),

Line 7744: XMLCONCAT( XMLELEMENT("AppName",ego_validation_table_info_v.table_application_name),

7740: 'TableInfo',
7741: ego_pub_ws_flat_recs_s.nextval,
7742: ego_pub_ws_flat_recs.sequence_id,
7743: ego_validation_table_info_v.flex_value_set_id,
7744: XMLCONCAT( XMLELEMENT("AppName",ego_validation_table_info_v.table_application_name),
7745: XMLELEMENT("AppId",ego_validation_table_info_v.table_application_id),
7746: XMLELEMENT("TableName",ego_validation_table_info_v.application_table_name),
7747: XMLELEMENT("ValueColName",ego_validation_table_info_v.value_column_name),
7748: XMLELEMENT("ValueColType",ego_validation_table_info_v.value_column_type),

Line 7745: XMLELEMENT("AppId",ego_validation_table_info_v.table_application_id),

7741: ego_pub_ws_flat_recs_s.nextval,
7742: ego_pub_ws_flat_recs.sequence_id,
7743: ego_validation_table_info_v.flex_value_set_id,
7744: XMLCONCAT( XMLELEMENT("AppName",ego_validation_table_info_v.table_application_name),
7745: XMLELEMENT("AppId",ego_validation_table_info_v.table_application_id),
7746: XMLELEMENT("TableName",ego_validation_table_info_v.application_table_name),
7747: XMLELEMENT("ValueColName",ego_validation_table_info_v.value_column_name),
7748: XMLELEMENT("ValueColType",ego_validation_table_info_v.value_column_type),
7749: XMLELEMENT("ValueColSize",ego_validation_table_info_v.value_column_size),

Line 7746: XMLELEMENT("TableName",ego_validation_table_info_v.application_table_name),

7742: ego_pub_ws_flat_recs.sequence_id,
7743: ego_validation_table_info_v.flex_value_set_id,
7744: XMLCONCAT( XMLELEMENT("AppName",ego_validation_table_info_v.table_application_name),
7745: XMLELEMENT("AppId",ego_validation_table_info_v.table_application_id),
7746: XMLELEMENT("TableName",ego_validation_table_info_v.application_table_name),
7747: XMLELEMENT("ValueColName",ego_validation_table_info_v.value_column_name),
7748: XMLELEMENT("ValueColType",ego_validation_table_info_v.value_column_type),
7749: XMLELEMENT("ValueColSize",ego_validation_table_info_v.value_column_size),
7750: XMLELEMENT("IDColName",ego_validation_table_info_v.id_column_name),

Line 7747: XMLELEMENT("ValueColName",ego_validation_table_info_v.value_column_name),

7743: ego_validation_table_info_v.flex_value_set_id,
7744: XMLCONCAT( XMLELEMENT("AppName",ego_validation_table_info_v.table_application_name),
7745: XMLELEMENT("AppId",ego_validation_table_info_v.table_application_id),
7746: XMLELEMENT("TableName",ego_validation_table_info_v.application_table_name),
7747: XMLELEMENT("ValueColName",ego_validation_table_info_v.value_column_name),
7748: XMLELEMENT("ValueColType",ego_validation_table_info_v.value_column_type),
7749: XMLELEMENT("ValueColSize",ego_validation_table_info_v.value_column_size),
7750: XMLELEMENT("IDColName",ego_validation_table_info_v.id_column_name),
7751: XMLELEMENT("IDColType",ego_validation_table_info_v.id_column_type),

Line 7748: XMLELEMENT("ValueColType",ego_validation_table_info_v.value_column_type),

7744: XMLCONCAT( XMLELEMENT("AppName",ego_validation_table_info_v.table_application_name),
7745: XMLELEMENT("AppId",ego_validation_table_info_v.table_application_id),
7746: XMLELEMENT("TableName",ego_validation_table_info_v.application_table_name),
7747: XMLELEMENT("ValueColName",ego_validation_table_info_v.value_column_name),
7748: XMLELEMENT("ValueColType",ego_validation_table_info_v.value_column_type),
7749: XMLELEMENT("ValueColSize",ego_validation_table_info_v.value_column_size),
7750: XMLELEMENT("IDColName",ego_validation_table_info_v.id_column_name),
7751: XMLELEMENT("IDColType",ego_validation_table_info_v.id_column_type),
7752: XMLELEMENT("IDColSize",ego_validation_table_info_v.id_column_size),

Line 7749: XMLELEMENT("ValueColSize",ego_validation_table_info_v.value_column_size),

7745: XMLELEMENT("AppId",ego_validation_table_info_v.table_application_id),
7746: XMLELEMENT("TableName",ego_validation_table_info_v.application_table_name),
7747: XMLELEMENT("ValueColName",ego_validation_table_info_v.value_column_name),
7748: XMLELEMENT("ValueColType",ego_validation_table_info_v.value_column_type),
7749: XMLELEMENT("ValueColSize",ego_validation_table_info_v.value_column_size),
7750: XMLELEMENT("IDColName",ego_validation_table_info_v.id_column_name),
7751: XMLELEMENT("IDColType",ego_validation_table_info_v.id_column_type),
7752: XMLELEMENT("IDColSize",ego_validation_table_info_v.id_column_size),
7753: XMLELEMENT("MeaningColName",ego_validation_table_info_v.meaning_column_name),

Line 7750: XMLELEMENT("IDColName",ego_validation_table_info_v.id_column_name),

7746: XMLELEMENT("TableName",ego_validation_table_info_v.application_table_name),
7747: XMLELEMENT("ValueColName",ego_validation_table_info_v.value_column_name),
7748: XMLELEMENT("ValueColType",ego_validation_table_info_v.value_column_type),
7749: XMLELEMENT("ValueColSize",ego_validation_table_info_v.value_column_size),
7750: XMLELEMENT("IDColName",ego_validation_table_info_v.id_column_name),
7751: XMLELEMENT("IDColType",ego_validation_table_info_v.id_column_type),
7752: XMLELEMENT("IDColSize",ego_validation_table_info_v.id_column_size),
7753: XMLELEMENT("MeaningColName",ego_validation_table_info_v.meaning_column_name),
7754: XMLELEMENT("MeaningColType",ego_validation_table_info_v.meaning_column_type),

Line 7751: XMLELEMENT("IDColType",ego_validation_table_info_v.id_column_type),

7747: XMLELEMENT("ValueColName",ego_validation_table_info_v.value_column_name),
7748: XMLELEMENT("ValueColType",ego_validation_table_info_v.value_column_type),
7749: XMLELEMENT("ValueColSize",ego_validation_table_info_v.value_column_size),
7750: XMLELEMENT("IDColName",ego_validation_table_info_v.id_column_name),
7751: XMLELEMENT("IDColType",ego_validation_table_info_v.id_column_type),
7752: XMLELEMENT("IDColSize",ego_validation_table_info_v.id_column_size),
7753: XMLELEMENT("MeaningColName",ego_validation_table_info_v.meaning_column_name),
7754: XMLELEMENT("MeaningColType",ego_validation_table_info_v.meaning_column_type),
7755: XMLELEMENT("MeaningColSize",ego_validation_table_info_v.meaning_column_size)

Line 7752: XMLELEMENT("IDColSize",ego_validation_table_info_v.id_column_size),

7748: XMLELEMENT("ValueColType",ego_validation_table_info_v.value_column_type),
7749: XMLELEMENT("ValueColSize",ego_validation_table_info_v.value_column_size),
7750: XMLELEMENT("IDColName",ego_validation_table_info_v.id_column_name),
7751: XMLELEMENT("IDColType",ego_validation_table_info_v.id_column_type),
7752: XMLELEMENT("IDColSize",ego_validation_table_info_v.id_column_size),
7753: XMLELEMENT("MeaningColName",ego_validation_table_info_v.meaning_column_name),
7754: XMLELEMENT("MeaningColType",ego_validation_table_info_v.meaning_column_type),
7755: XMLELEMENT("MeaningColSize",ego_validation_table_info_v.meaning_column_size)
7756: ).getClobVal(),

Line 7753: XMLELEMENT("MeaningColName",ego_validation_table_info_v.meaning_column_name),

7749: XMLELEMENT("ValueColSize",ego_validation_table_info_v.value_column_size),
7750: XMLELEMENT("IDColName",ego_validation_table_info_v.id_column_name),
7751: XMLELEMENT("IDColType",ego_validation_table_info_v.id_column_type),
7752: XMLELEMENT("IDColSize",ego_validation_table_info_v.id_column_size),
7753: XMLELEMENT("MeaningColName",ego_validation_table_info_v.meaning_column_name),
7754: XMLELEMENT("MeaningColType",ego_validation_table_info_v.meaning_column_type),
7755: XMLELEMENT("MeaningColSize",ego_validation_table_info_v.meaning_column_size)
7756: ).getClobVal(),
7757: SYSDATE

Line 7754: XMLELEMENT("MeaningColType",ego_validation_table_info_v.meaning_column_type),

7750: XMLELEMENT("IDColName",ego_validation_table_info_v.id_column_name),
7751: XMLELEMENT("IDColType",ego_validation_table_info_v.id_column_type),
7752: XMLELEMENT("IDColSize",ego_validation_table_info_v.id_column_size),
7753: XMLELEMENT("MeaningColName",ego_validation_table_info_v.meaning_column_name),
7754: XMLELEMENT("MeaningColType",ego_validation_table_info_v.meaning_column_type),
7755: XMLELEMENT("MeaningColSize",ego_validation_table_info_v.meaning_column_size)
7756: ).getClobVal(),
7757: SYSDATE
7758: FROM ego_pub_ws_flat_recs,

Line 7755: XMLELEMENT("MeaningColSize",ego_validation_table_info_v.meaning_column_size)

7751: XMLELEMENT("IDColType",ego_validation_table_info_v.id_column_type),
7752: XMLELEMENT("IDColSize",ego_validation_table_info_v.id_column_size),
7753: XMLELEMENT("MeaningColName",ego_validation_table_info_v.meaning_column_name),
7754: XMLELEMENT("MeaningColType",ego_validation_table_info_v.meaning_column_type),
7755: XMLELEMENT("MeaningColSize",ego_validation_table_info_v.meaning_column_size)
7756: ).getClobVal(),
7757: SYSDATE
7758: FROM ego_pub_ws_flat_recs,
7759: ego_validation_table_info_v

Line 7759: ego_validation_table_info_v

7755: XMLELEMENT("MeaningColSize",ego_validation_table_info_v.meaning_column_size)
7756: ).getClobVal(),
7757: SYSDATE
7758: FROM ego_pub_ws_flat_recs,
7759: ego_validation_table_info_v
7760: WHERE ego_pub_ws_flat_recs.pk1_value=ego_validation_table_info_v.flex_value_set_id
7761: AND (
7762: ego_pub_ws_flat_recs.session_id = p_Session_Id
7763: AND ego_pub_ws_flat_recs.odi_session_id = p_ODISession_Id

Line 7760: WHERE ego_pub_ws_flat_recs.pk1_value=ego_validation_table_info_v.flex_value_set_id

7756: ).getClobVal(),
7757: SYSDATE
7758: FROM ego_pub_ws_flat_recs,
7759: ego_validation_table_info_v
7760: WHERE ego_pub_ws_flat_recs.pk1_value=ego_validation_table_info_v.flex_value_set_id
7761: AND (
7762: ego_pub_ws_flat_recs.session_id = p_Session_Id
7763: AND ego_pub_ws_flat_recs.odi_session_id = p_ODISession_Id
7764: AND ego_pub_ws_flat_recs.entity_type = 'Valueset'

Line 7787: ego_validation_table_info_v.flex_value_set_id,

7783: p_ODISession_Id,
7784: 'WhereClause',
7785: ego_pub_ws_flat_recs_s.nextval,
7786: ego_pub_ws_flat_recs.sequence_id,
7787: ego_validation_table_info_v.flex_value_set_id,
7788: To_Lob(ego_validation_table_info_v.additional_where_clause),
7789: SYSDATE
7790: FROM ego_pub_ws_flat_recs,
7791: ego_validation_table_info_v

Line 7788: To_Lob(ego_validation_table_info_v.additional_where_clause),

7784: 'WhereClause',
7785: ego_pub_ws_flat_recs_s.nextval,
7786: ego_pub_ws_flat_recs.sequence_id,
7787: ego_validation_table_info_v.flex_value_set_id,
7788: To_Lob(ego_validation_table_info_v.additional_where_clause),
7789: SYSDATE
7790: FROM ego_pub_ws_flat_recs,
7791: ego_validation_table_info_v
7792: WHERE ego_pub_ws_flat_recs.pk1_value=ego_validation_table_info_v.flex_value_set_id

Line 7791: ego_validation_table_info_v

7787: ego_validation_table_info_v.flex_value_set_id,
7788: To_Lob(ego_validation_table_info_v.additional_where_clause),
7789: SYSDATE
7790: FROM ego_pub_ws_flat_recs,
7791: ego_validation_table_info_v
7792: WHERE ego_pub_ws_flat_recs.pk1_value=ego_validation_table_info_v.flex_value_set_id
7793: AND (
7794: ego_pub_ws_flat_recs.session_id = p_Session_Id
7795: AND ego_pub_ws_flat_recs.odi_session_id = p_ODISession_Id

Line 7792: WHERE ego_pub_ws_flat_recs.pk1_value=ego_validation_table_info_v.flex_value_set_id

7788: To_Lob(ego_validation_table_info_v.additional_where_clause),
7789: SYSDATE
7790: FROM ego_pub_ws_flat_recs,
7791: ego_validation_table_info_v
7792: WHERE ego_pub_ws_flat_recs.pk1_value=ego_validation_table_info_v.flex_value_set_id
7793: AND (
7794: ego_pub_ws_flat_recs.session_id = p_Session_Id
7795: AND ego_pub_ws_flat_recs.odi_session_id = p_ODISession_Id
7796: AND ego_pub_ws_flat_recs.entity_type = 'TableInfo'