APPS.FUN_RULE_PUB dependencies on FUN_RULE_BULK_RESULT_GT

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

2741:
2742: while(dbms_sql.fetch_rows(destination_cursor) > 0 ) loop
2743: l_count := 1;
2744: /* Initialize the var l_paramPresent for each rule. If any param matches then make it true
2745: * and insert the record into FUN_RULE_BULK_RESULT_GT table.
2746: */
2747: l_paramPresent := FALSE;
2748:
2749:

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

2748:
2749:
2750: l_select_query := 'SELECT '||p_primary_key_column_name||' , ';
2751: l_where_clause := '';
2752: l_insert_statement := 'insert into FUN_RULE_BULK_RESULT_GT(ID, RESULT_VALUE , RULE_NAME ,RESULT_APPLICATION_ID, RULE_DETAIL_ID ) ';
2753:
2754: dbms_sql.column_value(destination_cursor, 1, l_result_type);
2755: dbms_sql.column_value(destination_cursor, 2, l_rule_detail_id );
2756: dbms_sql.column_value(destination_cursor, 3, l_operator);

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

2998: DBMS_SQL.CLOSE_CURSOR(params_cursor);
2999:
3000: if(l_isRuleValid) then
3001: l_insert_statement := l_insert_statement || ' ' || l_select_query ||
3002: ' AND NOT EXISTS(SELECT 1 FROM FUN_RULE_BULK_RESULT_GT WHERE ID='|| p_param_view_name||'.'||p_primary_key_column_name||')';
3003: IF (populateGTBulkTable(l_insert_statement)) THEN
3004: NULL;
3005: END IF;
3006: end if;

Line 3017: 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||')';

3013: -- if (NOT l_isAnyRuleOk) then
3014: -- refreshGTBulkTable;
3015:
3016: l_select_query := 'SELECT '||p_primary_key_column_name||' , ';
3017: 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||')';
3018: l_insert_statement := 'insert into FUN_RULE_BULK_RESULT_GT(ID, RESULT_VALUE , RULE_NAME ,RESULT_APPLICATION_ID, RULE_DETAIL_ID ) ';
3019:
3020: if(l_noRuleActive) then
3021:

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

3014: -- refreshGTBulkTable;
3015:
3016: l_select_query := 'SELECT '||p_primary_key_column_name||' , ';
3017: 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||')';
3018: l_insert_statement := 'insert into FUN_RULE_BULK_RESULT_GT(ID, RESULT_VALUE , RULE_NAME ,RESULT_APPLICATION_ID, RULE_DETAIL_ID ) ';
3019:
3020: if(l_noRuleActive) then
3021:
3022: setResultValues(l_isRuleValid,

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

3119:
3120: -- Prepare a cursor to select from the source table:
3121: source_cursor := DBMS_SQL.OPEN_CURSOR;
3122:
3123: DBMS_SQL.PARSE(source_cursor, 'delete from FUN_RULE_BULK_RESULT_GT', DBMS_SQL.native);
3124:
3125: ignore := DBMS_SQL.EXECUTE(source_cursor);
3126:
3127: DBMS_SQL.CLOSE_CURSOR(source_cursor);

Line 3196: CURSOR C1 IS SELECT * FROM FUN_RULE_BULK_RESULT_GT;

3192: END populateGTBulkTable;
3193:
3194: PROCEDURE TEST
3195: IS
3196: CURSOR C1 IS SELECT * FROM FUN_RULE_BULK_RESULT_GT;
3197: BEGIN
3198: for c_rec in c1 loop
3199: --dbms_output.put_line('rule_name='||c_rec.rule_name||'***result_value='||c_rec.result_value);
3200: NULL;