DBA Data[Home] [Help]

APPS.IGS_AD_IMP_026 dependencies on IGS_OR_GEN_012_PKG

Line 174: IGS_OR_GEN_012_PKG.GET_WHERE_CLAUSE_API ('IGSEN027', l_where_clause);

170: CLOSE valid_pas_id;
171: END IF;
172:
173: IF visa_rec.agent_org_unit_cd IS NOT NULL THEN
174: IGS_OR_GEN_012_PKG.GET_WHERE_CLAUSE_API ('IGSEN027', l_where_clause);
175: IF l_where_clause IS NOT NULL THEN
176: l_select_clause := l_select_clause||' AND '||l_where_clause;
177: --skpandey, 3-FEB-2006, Bug: 4937960: Added logic and additional parameter in using CLAUSE as a part of Literal fix
178: OPEN org_unit_cur FOR l_select_clause USING visa_rec.agent_org_unit_cd, l_func_name;