I am trying to enhance an existing visa lov by using country lov , Country is lov is passing the country code vlaue in form value Country1, and when I am trying to create a bind variable in sql and VO like this: SELECT
flv.meaning AS visatypevalue,
flv.description AS visatypedesc,
flv.attribute1 AS issuingcountrycode1
FROM
fnd_lookup_values flv
WHERE
flv.lookup_type = 'ELC_GLB_VISA_TYPES'
AND flv.language = 'US'
AND flv.enabled_flag = 'Y'
AND TRUNC(SYSDATE) BETWEEN NVL(flv.start_date_active, TRUNC(SYSDATE))
AND NVL(flv.end_date_active, TRUNC(SYSDATE))
AND INSTR(
'|' || flv.attribute1 || '|',
'|' || :Country1 || '|'
) > 0
And also creating a bind variable (Country1)but still.
Second approach I am following is, I am using dyanamic where clause:
// if ("visatype".equals(lovInputSourceId))
// { String country = pageContext.getParameter("Country1");
pageContext.writeDiagnostics(this, "[TaleoCO] Country = " + country, 1);
if (country != null) {
pageContext.writeDiagnostics(this, "[ERROR] EmployeeAM fetch start", 1);
OAApplicationModule rootAM = pageContext.getApplicationModule(webBean);
pageContext.writeDiagnostics(this, "[ERROR] EmployeeAM fetch completed", 1);
OAApplicationModule lovAM = (OAApplicationModule)rootAM.findApplicationModule("EmployeeLovAM1");
pageContext.writeDiagnostics(this, "[ERROR] EmployeeLovAM fetch failed" + lovAM, 1);
if (lovAM != null)
{ OAViewObject vo = (OAViewObject)lovAM.findViewObject("VisatypeLovVO1");
if (vo != null) {
String whereClause = "INSTR('|' || attribute1 || '|','|" + country + "|') > 0";
pageContext.writeDiagnostics(this, "\[TaleoCO\] WHERE = " + whereClause, 1);
vo.setWhereClause(whereClause);
pageContext.writeDiagnostics(this, "\[TaleoCO\] Query = " + vo.getQuery(), 1);
vo.executeQuery(); } else {
pageContext.writeDiagnostics(this, "\[ERROR\] VO NOT FOUND", 1);
} else { pageContext.writeDiagnostics(this, "[ERROR] LOV AM NOT FOUND", 1);
} } }
But in this approach lovam value is coming null:
Means EmployeeLovAM is not passing employeeAM.
Can suggest on this?