1669: '150: l_additional_where_clause '||l_additional_where_clause);
1670: END IF;
1671:
1672: -- put sql in log
1673: fnd_file.put_line(FND_FILE.LOG,' ');
1674: fnd_file.put_line(FND_FILE.LOG,'Variable : '||rec_rule_variables.variable_name);
1675: fnd_file.put_line(FND_FILE.LOG,'Dynamic SQL for Valueset: '||rec_rule_variables.value_set_name);
1676: fnd_file.put_line(FND_FILE.LOG,'SELECT '||l_name_col||' , '||l_id_col);
1677: fnd_file.put_line(FND_FILE.LOG,'FROM '||l_table_name||' ');
1670: END IF;
1671:
1672: -- put sql in log
1673: fnd_file.put_line(FND_FILE.LOG,' ');
1674: fnd_file.put_line(FND_FILE.LOG,'Variable : '||rec_rule_variables.variable_name);
1675: fnd_file.put_line(FND_FILE.LOG,'Dynamic SQL for Valueset: '||rec_rule_variables.value_set_name);
1676: fnd_file.put_line(FND_FILE.LOG,'SELECT '||l_name_col||' , '||l_id_col);
1677: fnd_file.put_line(FND_FILE.LOG,'FROM '||l_table_name||' ');
1678: fnd_file.put_line(FND_FILE.LOG,l_additional_where_clause);
1671:
1672: -- put sql in log
1673: fnd_file.put_line(FND_FILE.LOG,' ');
1674: fnd_file.put_line(FND_FILE.LOG,'Variable : '||rec_rule_variables.variable_name);
1675: fnd_file.put_line(FND_FILE.LOG,'Dynamic SQL for Valueset: '||rec_rule_variables.value_set_name);
1676: fnd_file.put_line(FND_FILE.LOG,'SELECT '||l_name_col||' , '||l_id_col);
1677: fnd_file.put_line(FND_FILE.LOG,'FROM '||l_table_name||' ');
1678: fnd_file.put_line(FND_FILE.LOG,l_additional_where_clause);
1679: fnd_file.put_line(FND_FILE.LOG,' ');
1672: -- put sql in log
1673: fnd_file.put_line(FND_FILE.LOG,' ');
1674: fnd_file.put_line(FND_FILE.LOG,'Variable : '||rec_rule_variables.variable_name);
1675: fnd_file.put_line(FND_FILE.LOG,'Dynamic SQL for Valueset: '||rec_rule_variables.value_set_name);
1676: fnd_file.put_line(FND_FILE.LOG,'SELECT '||l_name_col||' , '||l_id_col);
1677: fnd_file.put_line(FND_FILE.LOG,'FROM '||l_table_name||' ');
1678: fnd_file.put_line(FND_FILE.LOG,l_additional_where_clause);
1679: fnd_file.put_line(FND_FILE.LOG,' ');
1680:
1673: fnd_file.put_line(FND_FILE.LOG,' ');
1674: fnd_file.put_line(FND_FILE.LOG,'Variable : '||rec_rule_variables.variable_name);
1675: fnd_file.put_line(FND_FILE.LOG,'Dynamic SQL for Valueset: '||rec_rule_variables.value_set_name);
1676: fnd_file.put_line(FND_FILE.LOG,'SELECT '||l_name_col||' , '||l_id_col);
1677: fnd_file.put_line(FND_FILE.LOG,'FROM '||l_table_name||' ');
1678: fnd_file.put_line(FND_FILE.LOG,l_additional_where_clause);
1679: fnd_file.put_line(FND_FILE.LOG,' ');
1680:
1681: -- execute the dynamic sql
1674: fnd_file.put_line(FND_FILE.LOG,'Variable : '||rec_rule_variables.variable_name);
1675: fnd_file.put_line(FND_FILE.LOG,'Dynamic SQL for Valueset: '||rec_rule_variables.value_set_name);
1676: fnd_file.put_line(FND_FILE.LOG,'SELECT '||l_name_col||' , '||l_id_col);
1677: fnd_file.put_line(FND_FILE.LOG,'FROM '||l_table_name||' ');
1678: fnd_file.put_line(FND_FILE.LOG,l_additional_where_clause);
1679: fnd_file.put_line(FND_FILE.LOG,' ');
1680:
1681: -- execute the dynamic sql
1682: BEGIN
1675: fnd_file.put_line(FND_FILE.LOG,'Dynamic SQL for Valueset: '||rec_rule_variables.value_set_name);
1676: fnd_file.put_line(FND_FILE.LOG,'SELECT '||l_name_col||' , '||l_id_col);
1677: fnd_file.put_line(FND_FILE.LOG,'FROM '||l_table_name||' ');
1678: fnd_file.put_line(FND_FILE.LOG,l_additional_where_clause);
1679: fnd_file.put_line(FND_FILE.LOG,' ');
1680:
1681: -- execute the dynamic sql
1682: BEGIN
1683: -- EXECUTE IMMEDIATE l_sql_stmt