APPS.XDO_DGF_RULE_PKG dependencies on DBMS_SQL

Line 94: l_cur_handler := dbms_sql.open_cursor;

90: 'before open cursor: l_statement = '
91: || l_statement);
92: END IF;
93:
94: l_cur_handler := dbms_sql.open_cursor;
95: dbms_sql.parse(l_cur_handler,l_statement,2);
96: FOR j IN 2..(p_rule_table(i).arg_number + 1)
97: LOOP
98: dbms_sql.bind_variable(l_cur_handler,j ||'',l_arg_table(j-1));

Line 95: dbms_sql.parse(l_cur_handler,l_statement,2);

91: || l_statement);
92: END IF;
93:
94: l_cur_handler := dbms_sql.open_cursor;
95: dbms_sql.parse(l_cur_handler,l_statement,2);
96: FOR j IN 2..(p_rule_table(i).arg_number + 1)
97: LOOP
98: dbms_sql.bind_variable(l_cur_handler,j ||'',l_arg_table(j-1));
99: END LOOP;

Line 98: dbms_sql.bind_variable(l_cur_handler,j ||'',l_arg_table(j-1));

94: l_cur_handler := dbms_sql.open_cursor;
95: dbms_sql.parse(l_cur_handler,l_statement,2);
96: FOR j IN 2..(p_rule_table(i).arg_number + 1)
97: LOOP
98: dbms_sql.bind_variable(l_cur_handler,j ||'',l_arg_table(j-1));
99: END LOOP;
100: dbms_sql.bind_variable(l_cur_handler,'1', l_return_char, 2000);
101: l_ret := dbms_sql.execute(l_cur_handler);
102: dbms_sql.variable_value(l_cur_handler,'1', l_return_char);

Line 100: dbms_sql.bind_variable(l_cur_handler,'1', l_return_char, 2000);

96: FOR j IN 2..(p_rule_table(i).arg_number + 1)
97: LOOP
98: dbms_sql.bind_variable(l_cur_handler,j ||'',l_arg_table(j-1));
99: END LOOP;
100: dbms_sql.bind_variable(l_cur_handler,'1', l_return_char, 2000);
101: l_ret := dbms_sql.execute(l_cur_handler);
102: dbms_sql.variable_value(l_cur_handler,'1', l_return_char);
103: dbms_sql.close_cursor(l_cur_handler);
104:

Line 101: l_ret := dbms_sql.execute(l_cur_handler);

97: LOOP
98: dbms_sql.bind_variable(l_cur_handler,j ||'',l_arg_table(j-1));
99: END LOOP;
100: dbms_sql.bind_variable(l_cur_handler,'1', l_return_char, 2000);
101: l_ret := dbms_sql.execute(l_cur_handler);
102: dbms_sql.variable_value(l_cur_handler,'1', l_return_char);
103: dbms_sql.close_cursor(l_cur_handler);
104:
105: IF (g_level_statement >= g_current_runtime_level ) THEN

Line 102: dbms_sql.variable_value(l_cur_handler,'1', l_return_char);

98: dbms_sql.bind_variable(l_cur_handler,j ||'',l_arg_table(j-1));
99: END LOOP;
100: dbms_sql.bind_variable(l_cur_handler,'1', l_return_char, 2000);
101: l_ret := dbms_sql.execute(l_cur_handler);
102: dbms_sql.variable_value(l_cur_handler,'1', l_return_char);
103: dbms_sql.close_cursor(l_cur_handler);
104:
105: IF (g_level_statement >= g_current_runtime_level ) THEN
106: FND_LOG.STRING(g_level_statement,

Line 103: dbms_sql.close_cursor(l_cur_handler);

99: END LOOP;
100: dbms_sql.bind_variable(l_cur_handler,'1', l_return_char, 2000);
101: l_ret := dbms_sql.execute(l_cur_handler);
102: dbms_sql.variable_value(l_cur_handler,'1', l_return_char);
103: dbms_sql.close_cursor(l_cur_handler);
104:
105: IF (g_level_statement >= g_current_runtime_level ) THEN
106: FND_LOG.STRING(g_level_statement,
107: 'xdo_dgf_rule_pkg.evaluate_rules',