APPS.ICX_CAT_UTIL_PVT dependencies on PO_SESSION_GT

Line 142: FROM po_session_gt

138: CURSOR poSessionGTCsr (p_key NUMBER) IS
139: SELECT key, index_num1, index_num2,
140: index_char1, index_char2,
141: char1, char2, char3
142: FROM po_session_gt
143: WHERE key = p_key;
144:
145: l_api_name CONSTANT VARCHAR2(30) := 'logPOSessionGTData';
146: l_err_loc PLS_INTEGER;

Line 193: 'For p_key:' || p_key || ', PO_SESSION_GT rowcount:' || l_key_tbl.COUNT );

189: l_err_loc := 500;
190: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
191: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
192: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
193: 'For p_key:' || p_key || ', PO_SESSION_GT rowcount:' || l_key_tbl.COUNT );
194: END IF;
195:
196: l_err_loc := 600;
197: FOR i IN 1..l_key_tbl.COUNT LOOP

Line 201: 'PO_SESSION_GT Row # ' || i ||

197: FOR i IN 1..l_key_tbl.COUNT LOOP
198: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
199: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
200: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
201: 'PO_SESSION_GT Row # ' || i ||
202: '; l_key_tbl: ' || l_key_tbl(i) ||
203: ', l_index_num1_tbl: ' || l_index_num1_tbl(i) ||
204: ', l_index_num2_tbl: ' || l_index_num2_tbl(i) ||
205: ', l_index_char1_tbl: ' || l_index_char1_tbl(i) ||