APPS.AS_INT_TYP_COD_MIGRATION dependencies on JTF_PERZ_QUERY_PARAM

Line 160: from JTF_PERZ_QUERY_PARAM P, JTF_PERZ_QUERY Q

156: ) IS
157:
158: CURSOR C_Get_Query_Ids(c_application_id NUMBER) IS
159: select distinct Q.query_id, Q.query_name
160: from JTF_PERZ_QUERY_PARAM P, JTF_PERZ_QUERY Q
161: where Q.Query_Id = P.Query_Id
162: and Q.Application_Id = c_application_id
163: and P.Parameter_Type = 'condition'
164: and (P.Parameter_Name = 'productCategory' OR -- As in Group Summary Report or Advanced Search

Line 247: from JTF_PERZ_QUERY_PARAM P

243: l_debug BOOLEAN := false;
244:
245: CURSOR C_Get_Query_Params(c_query_id NUMBER) IS
246: select P.query_param_id, P.parameter_name, P.parameter_type, P.parameter_value, P.parameter_condition, P.parameter_sequence, P.created_by, P.last_update_date, P.last_updated_by, P.last_update_login, P.security_group_id
247: from JTF_PERZ_QUERY_PARAM P
248: where P.query_id = c_query_id
249: and P.Parameter_Type = 'condition'
250: and (P.Parameter_Name = 'productCategory' OR -- As in Group Summary Report or Advanced Search
251: P.Parameter_Name = 'prodCat' OR -- As in Summary Report or detail Report or other reports

Line 338: -- Set product category id in the JTF_PERZ_QUERY_PARAM table

334: IF (l_debug) and (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) Then
335: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'as.plsql.conc.asxmintb','product category id=' || l_product_cat_id || ', category set id='||l_product_cat_set_id);
336: END IF;
337:
338: -- Set product category id in the JTF_PERZ_QUERY_PARAM table
339: Update JTF_PERZ_QUERY_PARAM P
340: set parameter_name = 'rep.ROW' || l_cnt || '.ProdCategory',
341: parameter_value = l_product_cat_id
342: where

Line 339: Update JTF_PERZ_QUERY_PARAM P

335: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'as.plsql.conc.asxmintb','product category id=' || l_product_cat_id || ', category set id='||l_product_cat_set_id);
336: END IF;
337:
338: -- Set product category id in the JTF_PERZ_QUERY_PARAM table
339: Update JTF_PERZ_QUERY_PARAM P
340: set parameter_name = 'rep.ROW' || l_cnt || '.ProdCategory',
341: parameter_value = l_product_cat_id
342: where
343: P.query_param_id = scr.query_param_id;

Line 434: -- Set product category id in the JTF_PERZ_QUERY_PARAM table

430: IF (l_debug) and (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) Then
431: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'as.plsql.conc.asxmintb','product category id=' || l_product_cat_id || ', category set id='||l_product_cat_set_id);
432: END IF;
433:
434: -- Set product category id in the JTF_PERZ_QUERY_PARAM table
435: Update JTF_PERZ_QUERY_PARAM P
436: set parameter_name = 'rep.ROW' || l_cnt2 || '.ProdCategory',
437: parameter_value = l_product_cat_id
438: where

Line 435: Update JTF_PERZ_QUERY_PARAM P

431: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'as.plsql.conc.asxmintb','product category id=' || l_product_cat_id || ', category set id='||l_product_cat_set_id);
432: END IF;
433:
434: -- Set product category id in the JTF_PERZ_QUERY_PARAM table
435: Update JTF_PERZ_QUERY_PARAM P
436: set parameter_name = 'rep.ROW' || l_cnt2 || '.ProdCategory',
437: parameter_value = l_product_cat_id
438: where
439: P.query_param_id = scr.query_param_id;

Line 445: Update JTF_PERZ_QUERY_PARAM P

441: l_index := instr(scr.parameter_name, '.Invt');
442: l_cnt2 := substr(scr.parameter_name, 4, (l_index - 4));
443:
444: -- Set name as rep.ROW0.invItem
445: Update JTF_PERZ_QUERY_PARAM P
446: set parameter_name = 'rep.ROW' || l_cnt2 || '.invItem'
447: where
448: P.query_param_id = scr.query_param_id;
449: elsif (instr(scr.parameter_name, 'invItemID') > 0) then

Line 454: Update JTF_PERZ_QUERY_PARAM P

450: l_index := length('invItemID');
451: l_cnt2 := substr(scr.parameter_name, l_index+1);
452:
453: -- Set name as rep.ROW0.invItemID
454: Update JTF_PERZ_QUERY_PARAM P
455: set parameter_name = 'rep.ROW' || l_cnt2 || '.invItemID'
456: where
457: P.query_param_id = scr.query_param_id;
458: end if;