APPS.FUN_RULE_PUB dependencies on FUN_RULE_BULK_RESULT_GT

Line 2755: * and insert the record into FUN_RULE_BULK_RESULT_GT table.

2751:
2752: while(dbms_sql.fetch_rows(destination_cursor) > 0 ) loop
2753: l_count := 1;
2754: /* Initialize the var l_paramPresent for each rule. If any param matches then make it true
2755: * and insert the record into FUN_RULE_BULK_RESULT_GT table.
2756: */
2757: l_paramPresent := FALSE;
2758:
2759:

Line 2762: l_insert_statement := 'insert into FUN_RULE_BULK_RESULT_GT(ID, RESULT_VALUE , RULE_NAME ,RESULT_APPLICATION_ID, RULE_DETAIL_ID ) ';

2758:
2759:
2760: l_select_query := 'SELECT '||p_primary_key_column_name||' , ';
2761: l_where_clause := '';
2762: l_insert_statement := 'insert into FUN_RULE_BULK_RESULT_GT(ID, RESULT_VALUE , RULE_NAME ,RESULT_APPLICATION_ID, RULE_DETAIL_ID ) ';
2763:
2764: dbms_sql.column_value(destination_cursor, 1, l_result_type);
2765: dbms_sql.column_value(destination_cursor, 2, l_rule_detail_id );
2766: dbms_sql.column_value(destination_cursor, 3, l_operator);

Line 3033: ' AND NOT EXISTS(SELECT 1 FROM FUN_RULE_BULK_RESULT_GT WHERE ID='|| p_param_view_name||'.'||p_primary_key_column_name||')';

3029: DBMS_SQL.CLOSE_CURSOR(params_cursor);
3030:
3031: if(l_isRuleValid) then
3032: l_insert_statement := l_insert_statement || ' ' || l_select_query ||
3033: ' AND NOT EXISTS(SELECT 1 FROM FUN_RULE_BULK_RESULT_GT WHERE ID='|| p_param_view_name||'.'||p_primary_key_column_name||')';
3034: IF (populateGTBulkTable(l_insert_statement)) THEN
3035: NULL;
3036: END IF;
3037: end if;

Line 3048: l_where_clause := ' AND NOT EXISTS(SELECT 1 FROM FUN_RULE_BULK_RESULT_GT WHERE ID='|| p_param_view_name||'.'||p_primary_key_column_name||')';

3044: -- if (NOT l_isAnyRuleOk) then
3045: -- refreshGTBulkTable;
3046:
3047: l_select_query := 'SELECT '||p_primary_key_column_name||' , ';
3048: l_where_clause := ' AND NOT EXISTS(SELECT 1 FROM FUN_RULE_BULK_RESULT_GT WHERE ID='|| p_param_view_name||'.'||p_primary_key_column_name||')';
3049: l_insert_statement := 'insert into FUN_RULE_BULK_RESULT_GT(ID, RESULT_VALUE , RULE_NAME ,RESULT_APPLICATION_ID, RULE_DETAIL_ID ) ';
3050:
3051: if(l_noRuleActive) then
3052:

Line 3049: l_insert_statement := 'insert into FUN_RULE_BULK_RESULT_GT(ID, RESULT_VALUE , RULE_NAME ,RESULT_APPLICATION_ID, RULE_DETAIL_ID ) ';

3045: -- refreshGTBulkTable;
3046:
3047: l_select_query := 'SELECT '||p_primary_key_column_name||' , ';
3048: l_where_clause := ' AND NOT EXISTS(SELECT 1 FROM FUN_RULE_BULK_RESULT_GT WHERE ID='|| p_param_view_name||'.'||p_primary_key_column_name||')';
3049: l_insert_statement := 'insert into FUN_RULE_BULK_RESULT_GT(ID, RESULT_VALUE , RULE_NAME ,RESULT_APPLICATION_ID, RULE_DETAIL_ID ) ';
3050:
3051: if(l_noRuleActive) then
3052:
3053: setResultValues(l_isRuleValid,

Line 3164: DBMS_SQL.PARSE(source_cursor, 'delete from FUN_RULE_BULK_RESULT_GT', DBMS_SQL.native);

3160:
3161: -- Prepare a cursor to select from the source table:
3162: source_cursor := DBMS_SQL.OPEN_CURSOR;
3163:
3164: DBMS_SQL.PARSE(source_cursor, 'delete from FUN_RULE_BULK_RESULT_GT', DBMS_SQL.native);
3165:
3166: ignore := DBMS_SQL.EXECUTE(source_cursor);
3167:
3168: DBMS_SQL.CLOSE_CURSOR(source_cursor);

Line 3237: CURSOR C1 IS SELECT * FROM FUN_RULE_BULK_RESULT_GT;

3233: END populateGTBulkTable;
3234:
3235: PROCEDURE TEST
3236: IS
3237: CURSOR C1 IS SELECT * FROM FUN_RULE_BULK_RESULT_GT;
3238: BEGIN
3239: for c_rec in c1 loop
3240: --dbms_output.put_line('rule_name='||c_rec.rule_name||'***result_value='||c_rec.result_value);
3241: NULL;