APPS.EGO_PUB_WS_UTIL dependencies on EGO_PUB_WS_ENTITIES

Line 1752: FROM EGO_PUB_WS_ENTITIES

1748: PK3_VALUE,
1749: PK4_VALUE,
1750: PK5_VALUE,
1751: USER_ENTERED
1752: FROM EGO_PUB_WS_ENTITIES
1753: WHERE SESSION_ID = l_session_id;
1754:
1755: -- Get PKs, SYSTEM_CODE from EGO_PUB_WS_INPUT_IDENTIFIERS
1756: CURSOR c_input_identifier(l_session_id NUMBER, l_system_code VARCHAR2)

Line 1809: -- and copy records in EGO_PUB_WS_ENTITIES into it while setting columns status equal to SUCCESS and

1805: WHERE SESSION_ID = p_session_id
1806: AND PARAMETER_NAME = 'TRIGGER_IMPORT';
1807:
1808: -- use global temporary table (reuse the one currently of batch publication framework)
1809: -- and copy records in EGO_PUB_WS_ENTITIES into it while setting columns status equal to SUCCESS and
1810: -- SYSTEM_CODE equal to current target system for all records.
1811:
1812: FOR sys IN c_system_codes(p_session_id)
1813: LOOP

Line 2388: l_entity_type_tag EGO_PUB_WS_ENTITIES.ENTITY_TYPE%TYPE;

2384: l_chunk_detail CLOB; --Chunking
2385: l_err_xml CLOB; --Error Handling
2386: l_warn_xml CLOB; --Error Handling
2387:
2388: l_entity_type_tag EGO_PUB_WS_ENTITIES.ENTITY_TYPE%TYPE;
2389: l_xml_header CLOB;
2390:
2391: -- Code changes to optimize transform_xml API.
2392: xsldoc VARCHAR2(2000);

Line 2476: FROM EGO_PUB_WS_ENTITIES

2472:
2473: BEGIN
2474: SELECT COUNT(1)
2475: INTO l_no_of_entities
2476: FROM EGO_PUB_WS_ENTITIES
2477: WHERE ENTITY_TYPE = l_entity_type
2478: AND SESSION_ID = l_session_id;
2479: EXCEPTION
2480: WHEN NO_DATA_FOUND THEN