APPS.EGO_PUB_WS_ICC dependencies on EGO_PUB_WS_INPUT_IDENTIFIERS

Line 2112: -- Get PKs, SYSTEM_CODE from EGO_PUB_WS_INPUT_IDENTIFIERS

2108: WHERE SESSION_ID = l_session_id
2109: AND ( ( NVL(ENTITY_TYPE,'XYZ') <> G_ENTITY_TYPE_ICC )
2110: OR (ENTITY_TYPE=G_ENTITY_TYPE_ICC AND REF10_VALUE=G_CHAR_YES) );
2111:
2112: -- Get PKs, SYSTEM_CODE from EGO_PUB_WS_INPUT_IDENTIFIERS
2113: CURSOR c_input_identifier(l_session_id NUMBER, l_system_code VARCHAR2)
2114: IS
2115: SELECT SESSION_ID,
2116: INPUT_ID,

Line 2125: FROM EGO_PUB_WS_INPUT_IDENTIFIERS

2121: PK2_VALUE,
2122: PK3_VALUE,
2123: PK4_VALUE,
2124: PK5_VALUE
2125: FROM EGO_PUB_WS_INPUT_IDENTIFIERS
2126: WHERE SESSION_ID = l_session_id
2127: AND SYSTEM_CODE = l_system_code;
2128:
2129: -- Get ERROR_CODE, ERROR_MESSAGE from EGO_PUB_WS_ERRORS

Line 2379: -- For each record in EGO_PUB_WS_ERRORS , join with EGO_PUB_WS_INPUT_IDENTIFIERS

2375: --debug(L_PROC_NAME||' end of if on invalid sys - 2 ');
2376: END LOOP; /* end of loop on systems*/
2377: --debug(L_PROC_NAME||' end of Loop on c_system_codes ');
2378:
2379: -- For each record in EGO_PUB_WS_ERRORS , join with EGO_PUB_WS_INPUT_IDENTIFIERS
2380: -- using INPUT_ID, SESSION_ID, and SYSTEM_CODE
2381: -- to retrieve PKs from EGO_PUB_WS_INPUT_IDENTIFIERS, and ERR_CODE and ERR_MESSAGE from EGO_PUB_WS_ERRORS
2382: -- and update records in global temporary table accordingly using PKs.
2383:

Line 2381: -- to retrieve PKs from EGO_PUB_WS_INPUT_IDENTIFIERS, and ERR_CODE and ERR_MESSAGE from EGO_PUB_WS_ERRORS

2377: --debug(L_PROC_NAME||' end of Loop on c_system_codes ');
2378:
2379: -- For each record in EGO_PUB_WS_ERRORS , join with EGO_PUB_WS_INPUT_IDENTIFIERS
2380: -- using INPUT_ID, SESSION_ID, and SYSTEM_CODE
2381: -- to retrieve PKs from EGO_PUB_WS_INPUT_IDENTIFIERS, and ERR_CODE and ERR_MESSAGE from EGO_PUB_WS_ERRORS
2382: -- and update records in global temporary table accordingly using PKs.
2383:
2384: IF (l_trigger_import = 'Y' OR l_trigger_import = 'TRUE') THEN
2385: --debug(L_PROC_NAME||' entered second l_trigger_import = Y/TRUE ');