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_PUB_WS_FLAT_RECS

Line 4477: from EGO_PUB_WS_FLAT_RECS

4473: ref3_value, /*ORGANIZATION_ID*/
4474: ref4_value, /*REVISION_ID*/
4475: ref5_value, /*STRUCTURE_TYPE*/
4476: ref6_value /*STRUCTURE_NAME*/
4477: from EGO_PUB_WS_FLAT_RECS
4478: where session_id = p_session_id
4479: and odi_session_id = p_odi_session_id
4480: and entity_type = 'ICCSH_COMP';
4481:

Line 5184: --from the data stored by the service scenario execution in table EGO_PUB_WS_FLAT_RECS.

5180:
5181:
5182:
5183: --Generates an XML payload containg the results of executing a given web service
5184: --from the data stored by the service scenario execution in table EGO_PUB_WS_FLAT_RECS.
5185: --The resulting XML payload is stored in column XMLCONTENT
5186: --of table EGO_PUB_WS_OUTPUT
5187: PROCEDURE Generate_XML(p_session_id IN NUMBER,
5188: p_odi_session_id IN NUMBER,

Line 5220: l_entity_type_tag EGO_PUB_WS_FLAT_RECS.ENTITY_TYPE%TYPE; -- Perf Bug : 9129863

5216: l_chunk_detail CLOB; --Chunking
5217: l_err_xml CLOB; --Error Handling
5218:
5219: --YJAIN
5220: l_entity_type_tag EGO_PUB_WS_FLAT_RECS.ENTITY_TYPE%TYPE; -- Perf Bug : 9129863
5221: l_xml_header CLOB;
5222:
5223: -- Code changes to optimize transform_xml API.
5224: xsldoc VARCHAR2(2000);

Line 5246: FROM EGO_PUB_WS_FLAT_RECS

5242: PARENT_SEQUENCE_ID,
5243: LEVEL LEVEL_NUMBER,
5244: ENTITY_TYPE,
5245: Value
5246: FROM EGO_PUB_WS_FLAT_RECS
5247: WHERE session_id = cp_session_id
5248: START WITH session_id = cp_session_id AND Nvl(PARENT_SEQUENCE_ID,-1)=-1
5249: CONNECT BY PRIOR SEQUENCE_ID = PARENT_SEQUENCE_ID AND session_id = cp_session_id;
5250:

Line 5270: FROM ego_pub_ws_flat_recs

5266: CURSOR c_ws_top_entity (cp_session_id NUMBER)
5267: IS
5268: SELECT sequence_id, parent_sequence_id, entity_type,
5269: LEVEL level_number
5270: FROM ego_pub_ws_flat_recs
5271: WHERE session_id = cp_session_id
5272: START WITH session_id = cp_session_id
5273: AND NVL (parent_sequence_id, -1) = -1
5274: AND sequence_id IN (SELECT sequence_id

Line 5275: FROM ego_pub_ws_flat_recs

5271: WHERE session_id = cp_session_id
5272: START WITH session_id = cp_session_id
5273: AND NVL (parent_sequence_id, -1) = -1
5274: AND sequence_id IN (SELECT sequence_id
5275: FROM ego_pub_ws_flat_recs
5276: WHERE session_id = cp_session_id AND NVL (parent_sequence_id, -1) = -1)
5277: CONNECT BY PRIOR sequence_id = parent_sequence_id AND session_id = cp_session_id
5278: UNION ALL
5279: SELECT -99999, NULL, 'ITEM',1

Line 5287: FROM ego_pub_ws_flat_recs

5283: /*Cursor to get top level entity value and sequence*/
5284: CURSOR c_ws_entity_val (cp_session_id NUMBER,cp_sequence_id NUMBER,cp_parent_sequence_id NUMBER)
5285: IS
5286: SELECT Value
5287: FROM ego_pub_ws_flat_recs
5288: WHERE session_id = cp_session_id
5289: AND sequence_id = cp_sequence_id
5290: AND NVL (parent_sequence_id, -1) = NVL(cp_parent_sequence_id, -1);
5291:

Line 5303: FROM EGO_PUB_WS_FLAT_RECS

5299: PARENT_SEQUENCE_ID,
5300: LEVEL LEVEL_NUMBER,
5301: ENTITY_TYPE,
5302: Value
5303: FROM EGO_PUB_WS_FLAT_RECS
5304: WHERE session_id = cp_session_id
5305: START WITH session_id = cp_session_id AND Nvl(PARENT_SEQUENCE_ID,-1)=-1 AND SEQUENCE_ID=cp_sequence_id
5306: CONNECT BY PRIOR SEQUENCE_ID = PARENT_SEQUENCE_ID AND session_id = cp_session_id;
5307:

Line 5353: FROM ego_pub_ws_flat_recs, mtl_parameters

5349: CURSOR c_master_recs_first(cp_session_id NUMBER)
5350: IS
5351: SELECT SEQUENCE_ID,
5352: decode(organization_id,master_organization_id,0,1) as master_or_child
5353: FROM ego_pub_ws_flat_recs, mtl_parameters
5354: WHERE session_id = cp_session_id
5355: AND entity_type = 'ITEM'
5356: AND NVL (parent_sequence_id, -1) = -1
5357: AND pk2_value = organization_id

Line 5364: FROM ego_pub_ws_flat_recs

5360: --cursor to retrieve all other non Item records (top entity records)
5361: CURSOR c_all_other_recs(cp_session_id NUMBER)
5362: IS
5363: SELECT SEQUENCE_ID
5364: FROM ego_pub_ws_flat_recs
5365: WHERE session_id = cp_session_id
5366: AND entity_type <> 'ITEM'
5367: AND NVL (parent_sequence_id, -1) = -1;
5368:

Line 7464: FROM EGO_PUB_WS_FLAT_RECS

7460:
7461: CURSOR cur_icc_list
7462: IS
7463: SELECT sequence_id,parent_sequence_id,pk1_value icc_id ,pk2_value icc_ver
7464: FROM EGO_PUB_WS_FLAT_RECS
7465: WHERE session_id= p_session_id
7466: AND odi_session_id=p_odi_session_id
7467: AND entity_type ='ICCVersion';
7468:

Line 7515: INTO EGO_PUB_WS_FLAT_RECS

7511: l_icc_start_active_date,l_icc_create_date,l_vs_version_number,l_return_status);
7512:
7513:
7514: INSERT
7515: INTO EGO_PUB_WS_FLAT_RECS
7516: (
7517: SESSION_ID ,
7518: ODI_SESSION_ID ,
7519: ENTITY_TYPE ,

Line 7534: EGO_PUB_WS_FLAT_RECS_S.NEXTVAL ,

7530: )
7531: (SELECT p_session_id ,
7532: p_odi_session_id ,
7533: 'TransactionAttribute' ,
7534: EGO_PUB_WS_FLAT_RECS_S.NEXTVAL ,
7535: j.sequence_id ,
7536: 1 ,
7537: l_icc_ta_metadata_tbl(i).attrid ,
7538: j.icc_id ,

Line 7575: SELECT ego_pub_ws_flat_recs.sequence_id,

7571: p_ODISession_Id IN NUMBER)
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,

Line 7579: FROM ego_pub_ws_flat_recs,

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:
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

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 7583: AND ego_pub_ws_flat_recs.session_id = p_Session_Id

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:
7587: TempLong LONG; -- Temporary variable

Line 7584: AND ego_pub_ws_flat_recs.odi_session_id = p_ODISession_Id

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:
7587: TempLong LONG; -- Temporary variable
7588:

Line 7585: AND ego_pub_ws_flat_recs.entity_type = 'TableInfo';

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:
7587: TempLong LONG; -- Temporary variable
7588:
7589: BEGIN

Line 7595: INTO ego_pub_ws_flat_recs

7591: /* Insert Table Information into Flat except Where Clause because
7592: WhereClause Column is of Type 'LONG' and it is working with XML DB Functions*/
7593: /* Entity Type of the record will be 'TableInfo' which will be child of 'ValueSet' element*/
7594: INSERT
7595: INTO ego_pub_ws_flat_recs
7596: (
7597: session_id ,
7598: odi_session_id ,
7599: entity_type ,

Line 7609: ego_pub_ws_flat_recs_s.nextval,

7605: )
7606: SELECT p_Session_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),

Line 7610: ego_pub_ws_flat_recs.sequence_id,

7606: SELECT p_Session_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),

Line 7626: FROM ego_pub_ws_flat_recs,

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
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

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 7630: ego_pub_ws_flat_recs.session_id = p_Session_Id

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'
7633: AND ego_pub_ws_flat_recs.pk2_value IS NULL
7634: AND ego_pub_ws_flat_recs.ref1_value = 'F'

Line 7631: AND ego_pub_ws_flat_recs.odi_session_id = p_ODISession_Id

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'
7633: AND ego_pub_ws_flat_recs.pk2_value IS NULL
7634: AND ego_pub_ws_flat_recs.ref1_value = 'F'
7635: );

Line 7632: AND ego_pub_ws_flat_recs.entity_type = 'ValueSet'

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'
7633: AND ego_pub_ws_flat_recs.pk2_value IS NULL
7634: AND ego_pub_ws_flat_recs.ref1_value = 'F'
7635: );
7636:

Line 7633: AND ego_pub_ws_flat_recs.pk2_value IS NULL

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'
7633: AND ego_pub_ws_flat_recs.pk2_value IS NULL
7634: AND ego_pub_ws_flat_recs.ref1_value = 'F'
7635: );
7636:
7637: /*Insert WhereClause in to Flat table.This record will be Child of 'TableInfo' element*/

Line 7634: AND ego_pub_ws_flat_recs.ref1_value = 'F'

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'
7633: AND ego_pub_ws_flat_recs.pk2_value IS NULL
7634: AND ego_pub_ws_flat_recs.ref1_value = 'F'
7635: );
7636:
7637: /*Insert WhereClause in to Flat table.This record will be Child of 'TableInfo' element*/
7638: /*INSERT

Line 7639: INTO ego_pub_ws_flat_recs

7635: );
7636:
7637: /*Insert WhereClause in to Flat table.This record will be Child of 'TableInfo' element*/
7638: /*INSERT
7639: INTO ego_pub_ws_flat_recs
7640: (
7641: session_id ,
7642: odi_session_id ,
7643: entity_type ,

Line 7653: ego_pub_ws_flat_recs_s.nextval,

7649: )
7650: SELECT p_Session_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

Line 7654: ego_pub_ws_flat_recs.sequence_id,

7650: SELECT p_Session_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,

Line 7658: FROM ego_pub_ws_flat_recs,

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
7661: AND (
7662: ego_pub_ws_flat_recs.session_id = p_Session_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 7662: ego_pub_ws_flat_recs.session_id = p_Session_Id

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'
7665: );*/
7666:

Line 7663: AND ego_pub_ws_flat_recs.odi_session_id = p_ODISession_Id

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'
7665: );*/
7666:
7667: FOR rec IN Table_VS_List -- For each 'TableInfo' entity type record in Flat table

Line 7664: AND ego_pub_ws_flat_recs.entity_type = 'TableInfo'

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'
7665: );*/
7666:
7667: FOR rec IN Table_VS_List -- For each 'TableInfo' entity type record in Flat table
7668: LOOP

Line 7673: INTO ego_pub_ws_flat_recs

7669:
7670: TempLong := ''; --Enclose WhereClause with CDATA to avoid XMLParsing errors if WhereClause contains <,> char.s
7671:
7672: INSERT
7673: INTO ego_pub_ws_flat_recs
7674: (
7675: session_id ,
7676: odi_session_id ,
7677: entity_type ,

Line 7689: ego_pub_ws_flat_recs_s.nextval, -- Sequence Id for record

7685: (
7686: p_Session_Id ,
7687: p_ODISession_Id ,
7688: 'WhereClause' ,
7689: ego_pub_ws_flat_recs_s.nextval, -- Sequence Id for record
7690: rec.sequence_id , -- Parent record Sequence Id
7691: rec.flex_value_set_id , -- VlaueSet Id
7692: TempLong , -- enclosed WhereClause value
7693: SYSDATE

Line 7707: SELECT ego_pub_ws_flat_recs.sequence_id,

7703: p_ODISession_Id IN NUMBER)
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,

Line 7711: FROM ego_pub_ws_flat_recs,

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:
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

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 7715: AND ego_pub_ws_flat_recs.session_id = p_Session_Id

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:
7719: TempLong LONG; -- Temporary variable

Line 7716: AND ego_pub_ws_flat_recs.odi_session_id = p_ODISession_Id

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:
7719: TempLong LONG; -- Temporary variable
7720:

Line 7717: AND ego_pub_ws_flat_recs.entity_type = 'TableInfo';

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:
7719: TempLong LONG; -- Temporary variable
7720:
7721: BEGIN

Line 7727: INTO ego_pub_ws_flat_recs

7723: /* Insert Table Information into Flat except Where Clause because
7724: WhereClause Column is of Type 'LONG' and it is working with XML DB Functions*/
7725: /* Entity Type of the record will be 'TableInfo' which will be child of 'ValueSet' element*/
7726: INSERT
7727: INTO ego_pub_ws_flat_recs
7728: (
7729: session_id ,
7730: odi_session_id ,
7731: entity_type ,

Line 7741: ego_pub_ws_flat_recs_s.nextval,

7737: )
7738: SELECT p_Session_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),

Line 7742: ego_pub_ws_flat_recs.sequence_id,

7738: SELECT p_Session_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),

Line 7758: FROM ego_pub_ws_flat_recs,

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
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

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 7762: ego_pub_ws_flat_recs.session_id = p_Session_Id

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'
7765: AND ego_pub_ws_flat_recs.ref1_value = 'UDA'
7766: AND ego_pub_ws_flat_recs.ref2_value = 'F'

Line 7763: AND ego_pub_ws_flat_recs.odi_session_id = p_ODISession_Id

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'
7765: AND ego_pub_ws_flat_recs.ref1_value = 'UDA'
7766: AND ego_pub_ws_flat_recs.ref2_value = 'F'
7767: );

Line 7764: AND ego_pub_ws_flat_recs.entity_type = 'Valueset'

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'
7765: AND ego_pub_ws_flat_recs.ref1_value = 'UDA'
7766: AND ego_pub_ws_flat_recs.ref2_value = 'F'
7767: );
7768:

Line 7765: AND ego_pub_ws_flat_recs.ref1_value = 'UDA'

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'
7765: AND ego_pub_ws_flat_recs.ref1_value = 'UDA'
7766: AND ego_pub_ws_flat_recs.ref2_value = 'F'
7767: );
7768:
7769: /*Insert WhereClause in to Flat table.This record will be Child of 'TableInfo' element*/

Line 7766: AND ego_pub_ws_flat_recs.ref2_value = 'F'

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'
7765: AND ego_pub_ws_flat_recs.ref1_value = 'UDA'
7766: AND ego_pub_ws_flat_recs.ref2_value = 'F'
7767: );
7768:
7769: /*Insert WhereClause in to Flat table.This record will be Child of 'TableInfo' element*/
7770: /*INSERT

Line 7771: INTO ego_pub_ws_flat_recs

7767: );
7768:
7769: /*Insert WhereClause in to Flat table.This record will be Child of 'TableInfo' element*/
7770: /*INSERT
7771: INTO ego_pub_ws_flat_recs
7772: (
7773: session_id ,
7774: odi_session_id ,
7775: entity_type ,

Line 7785: ego_pub_ws_flat_recs_s.nextval,

7781: )
7782: SELECT p_Session_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

Line 7786: ego_pub_ws_flat_recs.sequence_id,

7782: SELECT p_Session_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,

Line 7790: FROM ego_pub_ws_flat_recs,

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
7793: AND (
7794: ego_pub_ws_flat_recs.session_id = p_Session_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'

Line 7794: ego_pub_ws_flat_recs.session_id = p_Session_Id

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'
7797: );*/
7798:

Line 7795: AND ego_pub_ws_flat_recs.odi_session_id = p_ODISession_Id

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'
7797: );*/
7798:
7799: FOR rec IN Table_VS_List -- For each 'TableInfo' entity type record in Flat table

Line 7796: AND ego_pub_ws_flat_recs.entity_type = 'TableInfo'

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'
7797: );*/
7798:
7799: FOR rec IN Table_VS_List -- For each 'TableInfo' entity type record in Flat table
7800: LOOP

Line 7805: INTO ego_pub_ws_flat_recs

7801:
7802: TempLong := ''; --Enclose WhereClause with CDATA to avoid XMLParsing errors if WhereClause contains <,> char.s
7803:
7804: INSERT
7805: INTO ego_pub_ws_flat_recs
7806: (
7807: session_id ,
7808: odi_session_id ,
7809: entity_type ,

Line 7821: ego_pub_ws_flat_recs_s.nextval, -- Sequence Id for record

7817: (
7818: p_Session_Id ,
7819: p_ODISession_Id ,
7820: 'WhereClause' ,
7821: ego_pub_ws_flat_recs_s.nextval, -- Sequence Id for record
7822: rec.sequence_id , -- Parent record Sequence Id
7823: rec.flex_value_set_id , -- VlaueSet Id
7824: TempLong , -- enclosed WhereClause value
7825: SYSDATE