DBA Data[Home] [Help]

APPS.POA_CM_EVALUATION_ICX dependencies on JS

Line 170: js.scriptOpen;

166: icx_util.copyright;
167:
168: PrintCSS;
169:
170: js.scriptOpen;
171:
172: icx_util.LOVscript;
173:
174: ----- Begin Javascript -----

Line 200: var c_js_where_clause = "";

196:
197: function call_LOV(c_attribute_code)
198: {
199: var f = document.POA_CM_EVALUATION_R;
200: var c_js_where_clause = "";
201:
202: if (c_attribute_code == "POA_CM_PERIOD_NAME")
203: {
204: if (f.POA_CM_PERIOD_TYPE.value != "")

Line 205: c_js_where_clause = " PERIOD_TYPE = ''" + f.POA_CM_PERIOD_TYPE.value.replace(/''/g,"''''") + "''";

201:
202: if (c_attribute_code == "POA_CM_PERIOD_NAME")
203: {
204: if (f.POA_CM_PERIOD_TYPE.value != "")
205: c_js_where_clause = " PERIOD_TYPE = ''" + f.POA_CM_PERIOD_TYPE.value.replace(/''/g,"''''") + "''";
206: else
207: c_js_where_clause = " USER_PERIOD_TYPE = ''" + f.POA_CM_USER_PERIOD_TYPE.value.replace(/''/g,"''''") + "''";
208: }
209: else if (c_attribute_code == "POA_CM_SUPPLIER_SITE")

Line 207: c_js_where_clause = " USER_PERIOD_TYPE = ''" + f.POA_CM_USER_PERIOD_TYPE.value.replace(/''/g,"''''") + "''";

203: {
204: if (f.POA_CM_PERIOD_TYPE.value != "")
205: c_js_where_clause = " PERIOD_TYPE = ''" + f.POA_CM_PERIOD_TYPE.value.replace(/''/g,"''''") + "''";
206: else
207: c_js_where_clause = " USER_PERIOD_TYPE = ''" + f.POA_CM_USER_PERIOD_TYPE.value.replace(/''/g,"''''") + "''";
208: }
209: else if (c_attribute_code == "POA_CM_SUPPLIER_SITE")
210: {
211: if (f.POA_CM_SUPPLIER_ID.value !="")

Line 212: c_js_where_clause = " VENDOR_ID = " + f.POA_CM_SUPPLIER_ID.value.replace(/''/g,"''''") +

208: }
209: else if (c_attribute_code == "POA_CM_SUPPLIER_SITE")
210: {
211: if (f.POA_CM_SUPPLIER_ID.value !="")
212: c_js_where_clause = " VENDOR_ID = " + f.POA_CM_SUPPLIER_ID.value.replace(/''/g,"''''") +
213: " AND ORG_ID = " + f.POA_CM_ORG_ID.value.replace(/''/g,"''''");
214: else
215: c_js_where_clause = " VENDOR_NAME = ''" + f.POA_CM_SUPPLIER.value.replace(/''/g,"''''") +
216: "'' AND ORG_ID = " + f.POA_CM_ORG_ID.value.replace(/''/g,"''''");

Line 215: c_js_where_clause = " VENDOR_NAME = ''" + f.POA_CM_SUPPLIER.value.replace(/''/g,"''''") +

211: if (f.POA_CM_SUPPLIER_ID.value !="")
212: c_js_where_clause = " VENDOR_ID = " + f.POA_CM_SUPPLIER_ID.value.replace(/''/g,"''''") +
213: " AND ORG_ID = " + f.POA_CM_ORG_ID.value.replace(/''/g,"''''");
214: else
215: c_js_where_clause = " VENDOR_NAME = ''" + f.POA_CM_SUPPLIER.value.replace(/''/g,"''''") +
216: "'' AND ORG_ID = " + f.POA_CM_ORG_ID.value.replace(/''/g,"''''");
217: }
218: else if (c_attribute_code == "POA_CM_OPERATING_UNIT")
219: {

Line 223: c_js_where_clause = " ORG_ID in (select ORG_ID from POA_CM_SITE_LOV_V where " +

219: {
220: if (f.POA_CM_SUPPLIER_SITE.value != "")
221: if (f.POA_CM_SUPPLIER_SITE_ID.value != "")
222: if (f.POA_CM_SUPPLIER_ID.value != "")
223: c_js_where_clause = " ORG_ID in (select ORG_ID from POA_CM_SITE_LOV_V where " +
224: " VENDOR_ID = " + f.POA_CM_SUPPLIER_ID.value.replace(/''/g,"''''") + " AND " +
225: " VENDOR_SITE_ID = " + f.POA_CM_SUPPLIER_SITE_ID.value.replace(/''/g,"''''") + ")";
226: else
227: c_js_where_clause = " ORG_ID in (select ORG_ID from POA_CM_SITE_LOV_V where " +

Line 227: c_js_where_clause = " ORG_ID in (select ORG_ID from POA_CM_SITE_LOV_V where " +

223: c_js_where_clause = " ORG_ID in (select ORG_ID from POA_CM_SITE_LOV_V where " +
224: " VENDOR_ID = " + f.POA_CM_SUPPLIER_ID.value.replace(/''/g,"''''") + " AND " +
225: " VENDOR_SITE_ID = " + f.POA_CM_SUPPLIER_SITE_ID.value.replace(/''/g,"''''") + ")";
226: else
227: c_js_where_clause = " ORG_ID in (select ORG_ID from POA_CM_SITE_LOV_V where " +
228: " VENDOR_NAME = ''" + f.POA_CM_SUPPLIER.value.replace(/''/g,"''''") + "'' AND " +
229: " VENDOR_SITE_ID = " + f.POA_CM_SUPPLIER_SITE_ID.value.replace(/''/g,"''''") + ")";
230: else
231: if (f.POA_CM_SUPPLIER_ID.value != "")

Line 232: c_js_where_clause = " ORG_ID in (select ORG_ID from POA_CM_SITE_LOV_V where " +

228: " VENDOR_NAME = ''" + f.POA_CM_SUPPLIER.value.replace(/''/g,"''''") + "'' AND " +
229: " VENDOR_SITE_ID = " + f.POA_CM_SUPPLIER_SITE_ID.value.replace(/''/g,"''''") + ")";
230: else
231: if (f.POA_CM_SUPPLIER_ID.value != "")
232: c_js_where_clause = " ORG_ID in (select ORG_ID from POA_CM_SITE_LOV_V where " +
233: " VENDOR_ID = " + f.POA_CM_SUPPLIER_ID.value.replace(/''/g,"''''") + " AND " +
234: " VENDOR_SITE_CODE = ''" + f.POA_CM_SUPPLIER_SITE.value.replace(/''/g,"''''") + "'')";
235: else
236: c_js_where_clause = " ORG_ID in (select ORG_ID from POA_CM_SITE_LOV_V where " +

Line 236: c_js_where_clause = " ORG_ID in (select ORG_ID from POA_CM_SITE_LOV_V where " +

232: c_js_where_clause = " ORG_ID in (select ORG_ID from POA_CM_SITE_LOV_V where " +
233: " VENDOR_ID = " + f.POA_CM_SUPPLIER_ID.value.replace(/''/g,"''''") + " AND " +
234: " VENDOR_SITE_CODE = ''" + f.POA_CM_SUPPLIER_SITE.value.replace(/''/g,"''''") + "'')";
235: else
236: c_js_where_clause = " ORG_ID in (select ORG_ID from POA_CM_SITE_LOV_V where " +
237: " VENDOR_NAME = ''" + f.POA_CM_SUPPLIER.value.replace(/''/g,"''''") + "'' AND " +
238: " VENDOR_SITE_CODE = ''" + f.POA_CM_SUPPLIER_SITE.value.replace(/''/g,"''''") + "'')";
239:
240: }

Line 245: c_js_where_clause = " ORGANIZATION_ID in (select INVENTORY_ORGANIZATION_ID from FINANCIALS_SYSTEM_PARAMETERS)" +

241: else if (c_attribute_code == "POA_CM_ITEM")
242: {
243: if (f.POA_CM_COMMODITY.value != "")
244: if (f.POA_CM_CATEGORY_ID.value != "")
245: c_js_where_clause = " ORGANIZATION_ID in (select INVENTORY_ORGANIZATION_ID from FINANCIALS_SYSTEM_PARAMETERS)" +
246: " AND CATEGORY_ID = " + f.POA_CM_CATEGORY_ID.value.replace(/''/g,"''''");
247: else
248: c_js_where_clause = " ORGANIZATION_ID in (select INVENTORY_ORGANIZATION_ID from FINANCIALS_SYSTEM_PARAMETERS)" +
249: " AND COMMODITY = ''" + f.POA_CM_COMMODITY.value.replace(/''/g,"''''") + "''";

Line 248: c_js_where_clause = " ORGANIZATION_ID in (select INVENTORY_ORGANIZATION_ID from FINANCIALS_SYSTEM_PARAMETERS)" +

244: if (f.POA_CM_CATEGORY_ID.value != "")
245: c_js_where_clause = " ORGANIZATION_ID in (select INVENTORY_ORGANIZATION_ID from FINANCIALS_SYSTEM_PARAMETERS)" +
246: " AND CATEGORY_ID = " + f.POA_CM_CATEGORY_ID.value.replace(/''/g,"''''");
247: else
248: c_js_where_clause = " ORGANIZATION_ID in (select INVENTORY_ORGANIZATION_ID from FINANCIALS_SYSTEM_PARAMETERS)" +
249: " AND COMMODITY = ''" + f.POA_CM_COMMODITY.value.replace(/''/g,"''''") + "''";
250: else
251: c_js_where_clause = " ORGANIZATION_ID in (select INVENTORY_ORGANIZATION_ID from FINANCIALS_SYSTEM_PARAMETERS)";
252: }

Line 251: c_js_where_clause = " ORGANIZATION_ID in (select INVENTORY_ORGANIZATION_ID from FINANCIALS_SYSTEM_PARAMETERS)";

247: else
248: c_js_where_clause = " ORGANIZATION_ID in (select INVENTORY_ORGANIZATION_ID from FINANCIALS_SYSTEM_PARAMETERS)" +
249: " AND COMMODITY = ''" + f.POA_CM_COMMODITY.value.replace(/''/g,"''''") + "''";
250: else
251: c_js_where_clause = " ORGANIZATION_ID in (select INVENTORY_ORGANIZATION_ID from FINANCIALS_SYSTEM_PARAMETERS)";
252: }
253:
254: c_js_where_clause = escape(c_js_where_clause, 1);
255:

Line 254: c_js_where_clause = escape(c_js_where_clause, 1);

250: else
251: c_js_where_clause = " ORGANIZATION_ID in (select INVENTORY_ORGANIZATION_ID from FINANCIALS_SYSTEM_PARAMETERS)";
252: }
253:
254: c_js_where_clause = escape(c_js_where_clause, 1);
255:
256: LOV("201", c_attribute_code, "201", "POA_CM_EVALUATION_R", "POA_CM_EVALUATION_R", "", "", c_js_where_clause);
257:
258: reset_hidden(c_attribute_code);

Line 256: LOV("201", c_attribute_code, "201", "POA_CM_EVALUATION_R", "POA_CM_EVALUATION_R", "", "", c_js_where_clause);

252: }
253:
254: c_js_where_clause = escape(c_js_where_clause, 1);
255:
256: LOV("201", c_attribute_code, "201", "POA_CM_EVALUATION_R", "POA_CM_EVALUATION_R", "", "", c_js_where_clause);
257:
258: reset_hidden(c_attribute_code);
259: }
260:

Line 360: js.scriptClose;

356: ');
357:
358: ----- End Javascript -----
359:
360: js.scriptClose;
361:
362: htp.p('');
363:
364: htp.headClose;