eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.HXC_TIME_CATEGORY_UTILS_PKG dependencies on DBMS_SQL

Line 825: t_bb_id dbms_sql.Number_Table;

821: PROCEDURE validate_time_category_sql ( p_sql_string IN LONG ) IS
822:
823: l_sql LONG := 'select distinct ta.bb_id from hxc_tmp_atts ta where ';
824:
825: t_bb_id dbms_sql.Number_Table;
826:
827: l_csr INTEGER;
828: l_rows_fetched INTEGER;
829: l_dummy INTEGER;

Line 930: l_csr := dbms_sql.open_cursor;

926:
927: BEGIN
928: l_rows_fetched := 100;
929:
930: l_csr := dbms_sql.open_cursor;
931:
932: dbms_sql.parse ( l_csr, l_sql, dbms_sql.native );
933:
934: -- replace the parse_time_sql bind

Line 932: dbms_sql.parse ( l_csr, l_sql, dbms_sql.native );

928: l_rows_fetched := 100;
929:
930: l_csr := dbms_sql.open_cursor;
931:
932: dbms_sql.parse ( l_csr, l_sql, dbms_sql.native );
933:
934: -- replace the parse_time_sql bind
935: WHILE l_between_or is not null
936: LOOP

Line 947: dbms_sql.bind_variable( l_csr, ':'||l_index*1000, l_before_equal1 );

943:
944: -- now I can replace the value with the bind
945: l_before_equal1 := replace(get_token (l_before_and,2,'='),')','');
946: l_before_equal1 := trim(replace(l_before_equal1,'''',''));
947: dbms_sql.bind_variable( l_csr, ':'||l_index*1000, l_before_equal1 );
948:
949: IF (instr(l_after_and,'IS NOT NULL') = 0 AND instr(l_after_and,'IS NULL') = 0
950: AND instr(l_after_and,'<>') = 0 AND instr(l_after_and,'IN') = 0)
951: THEN

Line 957: dbms_sql.bind_variable( l_csr, ':'||((l_index*1000)+1),l_before_equal2);

953: -- now I can replace the value with the bind
954: l_before_equal2 := replace(get_token (l_after_and,2,'='),')','');
955: l_before_equal2 := trim(replace(l_before_equal2,'''',''));
956:
957: dbms_sql.bind_variable( l_csr, ':'||((l_index*1000)+1),l_before_equal2);
958:
959: END IF;
960:
961: END IF;

Line 966: dbms_sql.define_array (

962: l_index := l_index + 1;
963:
964: END LOOP;
965:
966: dbms_sql.define_array (
967: c => l_csr
968: , position => 1
969: , n_tab => t_bb_id
970: , cnt => l_rows_fetched

Line 973: l_dummy := dbms_sql.execute ( l_csr );

969: , n_tab => t_bb_id
970: , cnt => l_rows_fetched
971: , lower_bound => 1 );
972:
973: l_dummy := dbms_sql.execute ( l_csr );
974:
975: -- loop to ensure we fetch all the rows
976:
977: WHILE ( l_rows_fetched = 100 )

Line 980: l_rows_fetched := dbms_sql.fetch_rows ( l_csr );

976:
977: WHILE ( l_rows_fetched = 100 )
978: LOOP
979:
980: l_rows_fetched := dbms_sql.fetch_rows ( l_csr );
981:
982: IF ( l_rows_fetched > 0 )
983: THEN
984:

Line 985: dbms_sql.column_value (

981:
982: IF ( l_rows_fetched > 0 )
983: THEN
984:
985: dbms_sql.column_value (
986: c => l_csr
987: , position => 1
988: , n_tab => t_bb_id );
989:

Line 996: dbms_sql.close_cursor ( l_csr );

992: END IF;
993:
994: END LOOP;
995:
996: dbms_sql.close_cursor ( l_csr );
997:
998: -- execute immediate l_sql INTO l_dummy;
999:
1000: EXCEPTION WHEN NO_DATA_FOUND THEN

Line 2381: t_bb_id dbms_sql.Number_Table;

2377: AND ';
2378:
2379: l_sql VARCHAR2(32000);
2380:
2381: t_bb_id dbms_sql.Number_Table;
2382:
2383: l_csr INTEGER;
2384: l_rows_fetched INTEGER;
2385: l_dummy INTEGER;

Line 2559: l_csr := dbms_sql.open_cursor;

2555: -- now fetch rows
2556:
2557: l_rows_fetched := 100;
2558:
2559: l_csr := dbms_sql.open_cursor;
2560:
2561: dbms_sql.parse ( l_csr, l_sql, dbms_sql.native );
2562:
2563: IF ( NOT g_params.p_use_temp_table )

Line 2561: dbms_sql.parse ( l_csr, l_sql, dbms_sql.native );

2557: l_rows_fetched := 100;
2558:
2559: l_csr := dbms_sql.open_cursor;
2560:
2561: dbms_sql.parse ( l_csr, l_sql, dbms_sql.native );
2562:
2563: IF ( NOT g_params.p_use_temp_table )
2564: THEN
2565:

Line 2566: dbms_sql.bind_variable ( l_csr, ':p_tbb_id' , g_params.p_tbb_id );

2562:
2563: IF ( NOT g_params.p_use_temp_table )
2564: THEN
2565:
2566: dbms_sql.bind_variable ( l_csr, ':p_tbb_id' , g_params.p_tbb_id );
2567: dbms_sql.bind_variable ( l_csr, ':p_tbb_ovn', g_params.p_tbb_ovn );
2568:
2569:
2570: IF ( ( p_operator = 'AND' ) AND ( p_tc_bb_ok_string IS NOT NULL ) )

Line 2567: dbms_sql.bind_variable ( l_csr, ':p_tbb_ovn', g_params.p_tbb_ovn );

2563: IF ( NOT g_params.p_use_temp_table )
2564: THEN
2565:
2566: dbms_sql.bind_variable ( l_csr, ':p_tbb_id' , g_params.p_tbb_id );
2567: dbms_sql.bind_variable ( l_csr, ':p_tbb_ovn', g_params.p_tbb_ovn );
2568:
2569:
2570: IF ( ( p_operator = 'AND' ) AND ( p_tc_bb_ok_string IS NOT NULL ) )
2571: THEN

Line 2574: dbms_sql.bind_variable_char ( l_csr, ':'||i , get_token(p_tc_bb_ok_string,i,',' ));

2570: IF ( ( p_operator = 'AND' ) AND ( p_tc_bb_ok_string IS NOT NULL ) )
2571: THEN
2572:
2573: FOR i IN 1..get_token_count(p_tc_bb_ok_string,',') LOOP
2574: dbms_sql.bind_variable_char ( l_csr, ':'||i , get_token(p_tc_bb_ok_string,i,',' ));
2575: END LOOP;
2576:
2577: ELSIF ( p_operator = 'OR' )
2578: THEN

Line 2581: dbms_sql.bind_variable_char ( l_csr, ':'||i , get_token(p_tc_bb_not_ok_string,i,',' ));

2577: ELSIF ( p_operator = 'OR' )
2578: THEN
2579:
2580: FOR i IN 1..get_token_count(p_tc_bb_not_ok_string,',') LOOP
2581: dbms_sql.bind_variable_char ( l_csr, ':'||i , get_token(p_tc_bb_not_ok_string,i,',' ));
2582: END LOOP;
2583:
2584: END IF;
2585:

Line 2592: dbms_sql.bind_variable_char ( l_csr, ':'||i , get_token(p_tc_bb_ok_string,i,',' ));

2588: IF ( ( p_operator = 'AND' ) AND ( p_tc_bb_ok_string IS NOT NULL ) ) THEN
2589:
2590: FOR i IN 1..get_token_count(p_tc_bb_ok_string,',') LOOP
2591:
2592: dbms_sql.bind_variable_char ( l_csr, ':'||i , get_token(p_tc_bb_ok_string,i,',' ));
2593:
2594: END LOOP;
2595:
2596: ELSIF ( p_operator = 'OR' ) AND ( p_tc_bb_not_ok_string IS NOT NULL ) THEN

Line 2599: dbms_sql.bind_variable_char ( l_csr, ':'||i , get_token(p_tc_bb_not_ok_string,i,',' ));

2595:
2596: ELSIF ( p_operator = 'OR' ) AND ( p_tc_bb_not_ok_string IS NOT NULL ) THEN
2597:
2598: FOR i IN 1..get_token_count(p_tc_bb_not_ok_string,',') LOOP
2599: dbms_sql.bind_variable_char ( l_csr, ':'||i , get_token(p_tc_bb_not_ok_string,i,',' ));
2600: END LOOP;
2601:
2602:
2603: END IF;

Line 2622: dbms_sql.bind_variable( l_csr, ':'||l_index*1000, l_before_equal1 );

2618:
2619: -- now I can replace the value with the bind
2620: l_before_equal1 := replace(get_token (l_before_and,2,'='),')','');
2621: l_before_equal1 := trim(replace(l_before_equal1,'''',''));
2622: dbms_sql.bind_variable( l_csr, ':'||l_index*1000, l_before_equal1 );
2623:
2624: IF (instr(l_after_and,'IS NOT NULL') = 0 AND instr(l_after_and,'IS NULL') = 0
2625: AND instr(l_after_and,'<>') = 0 AND instr(l_after_and,'IN') = 0) THEN
2626:

Line 2631: dbms_sql.bind_variable( l_csr, ':'||((l_index*1000)+1),l_before_equal2);

2627: -- now I can replace the value with the bind
2628: l_before_equal2 := replace(get_token (l_after_and,2,'='),')','');
2629: l_before_equal2 := trim(replace(l_before_equal2,'''',''));
2630:
2631: dbms_sql.bind_variable( l_csr, ':'||((l_index*1000)+1),l_before_equal2);
2632:
2633: END IF;
2634:
2635: END IF;

Line 2642: dbms_sql.define_array (

2638: END LOOP;
2639:
2640:
2641:
2642: dbms_sql.define_array (
2643: c => l_csr
2644: , position => 1
2645: , n_tab => t_bb_id
2646: , cnt => l_rows_fetched

Line 2649: l_dummy := dbms_sql.execute ( l_csr );

2645: , n_tab => t_bb_id
2646: , cnt => l_rows_fetched
2647: , lower_bound => 1 );
2648:
2649: l_dummy := dbms_sql.execute ( l_csr );
2650:
2651: -- loop to ensure we fetch all the rows
2652:
2653: WHILE ( l_rows_fetched = 100 )

Line 2656: l_rows_fetched := dbms_sql.fetch_rows ( l_csr );

2652:
2653: WHILE ( l_rows_fetched = 100 )
2654: LOOP
2655:
2656: l_rows_fetched := dbms_sql.fetch_rows ( l_csr );
2657:
2658: IF ( g_debug ) THEN
2659: hr_utility.trace('l rows fetched is '||to_char(l_rows_fetched));
2660: END IF;

Line 2665: dbms_sql.column_value (

2661:
2662: IF ( l_rows_fetched > 0 )
2663: THEN
2664:
2665: dbms_sql.column_value (
2666: c => l_csr
2667: , position => 1
2668: , n_tab => t_bb_id );
2669:

Line 2732: dbms_sql.close_cursor ( l_csr );

2728: END IF; -- l_rows_fetched > 0
2729:
2730: END LOOP;
2731:
2732: dbms_sql.close_cursor ( l_csr );
2733:
2734: IF ( g_debug ) THEN
2735: hr_utility.trace('GAZ - BB OK string is '||l_bb_ok_string);
2736: hr_utility.trace('GAZ - BB NOT OK string is '||l_bb_not_ok_string);

Line 2996: l_csr := dbms_sql.open_cursor;

2992: hr_utility.trace( substr(l_sql,1501,250) );
2993: hr_utility.trace( substr(l_sql,1751,250) );
2994: END IF;
2995:
2996: l_csr := dbms_sql.open_cursor;
2997:
2998: dbms_sql.parse ( l_csr, l_sql, dbms_sql.native );
2999:
3000: FOR i IN 1..get_token_count(p_tc_bb_ok_string,',') LOOP

Line 2998: dbms_sql.parse ( l_csr, l_sql, dbms_sql.native );

2994: END IF;
2995:
2996: l_csr := dbms_sql.open_cursor;
2997:
2998: dbms_sql.parse ( l_csr, l_sql, dbms_sql.native );
2999:
3000: FOR i IN 1..get_token_count(p_tc_bb_ok_string,',') LOOP
3001:
3002: dbms_sql.bind_variable_char ( l_csr, ':'||i , get_token(p_tc_bb_ok_string,i,',' ));

Line 3002: dbms_sql.bind_variable_char ( l_csr, ':'||i , get_token(p_tc_bb_ok_string,i,',' ));

2998: dbms_sql.parse ( l_csr, l_sql, dbms_sql.native );
2999:
3000: FOR i IN 1..get_token_count(p_tc_bb_ok_string,',') LOOP
3001:
3002: dbms_sql.bind_variable_char ( l_csr, ':'||i , get_token(p_tc_bb_ok_string,i,',' ));
3003:
3004: END LOOP;
3005:
3006: dbms_sql.bind_variable ( l_csr, ':p_period_end' , p_period_end );

Line 3006: dbms_sql.bind_variable ( l_csr, ':p_period_end' , p_period_end );

3002: dbms_sql.bind_variable_char ( l_csr, ':'||i , get_token(p_tc_bb_ok_string,i,',' ));
3003:
3004: END LOOP;
3005:
3006: dbms_sql.bind_variable ( l_csr, ':p_period_end' , p_period_end );
3007: dbms_sql.bind_variable ( l_csr, ':p_period_start', p_period_start);
3008:
3009: DBMS_SQL.DEFINE_COLUMN (l_csr, 1, l_hrs);
3010: --execute immediate l_sql INTO l_hrs USING p_period_end, p_period_start;

Line 3007: dbms_sql.bind_variable ( l_csr, ':p_period_start', p_period_start);

3003:
3004: END LOOP;
3005:
3006: dbms_sql.bind_variable ( l_csr, ':p_period_end' , p_period_end );
3007: dbms_sql.bind_variable ( l_csr, ':p_period_start', p_period_start);
3008:
3009: DBMS_SQL.DEFINE_COLUMN (l_csr, 1, l_hrs);
3010: --execute immediate l_sql INTO l_hrs USING p_period_end, p_period_start;
3011: l_rows_processed := dbms_sql.execute ( l_csr );

Line 3009: DBMS_SQL.DEFINE_COLUMN (l_csr, 1, l_hrs);

3005:
3006: dbms_sql.bind_variable ( l_csr, ':p_period_end' , p_period_end );
3007: dbms_sql.bind_variable ( l_csr, ':p_period_start', p_period_start);
3008:
3009: DBMS_SQL.DEFINE_COLUMN (l_csr, 1, l_hrs);
3010: --execute immediate l_sql INTO l_hrs USING p_period_end, p_period_start;
3011: l_rows_processed := dbms_sql.execute ( l_csr );
3012:
3013: IF DBMS_SQL.FETCH_ROWS (l_csr) > 0 THEN

Line 3011: l_rows_processed := dbms_sql.execute ( l_csr );

3007: dbms_sql.bind_variable ( l_csr, ':p_period_start', p_period_start);
3008:
3009: DBMS_SQL.DEFINE_COLUMN (l_csr, 1, l_hrs);
3010: --execute immediate l_sql INTO l_hrs USING p_period_end, p_period_start;
3011: l_rows_processed := dbms_sql.execute ( l_csr );
3012:
3013: IF DBMS_SQL.FETCH_ROWS (l_csr) > 0 THEN
3014: DBMS_SQL.COLUMN_VALUE (l_csr, 1, l_hrs);
3015: END IF;

Line 3013: IF DBMS_SQL.FETCH_ROWS (l_csr) > 0 THEN

3009: DBMS_SQL.DEFINE_COLUMN (l_csr, 1, l_hrs);
3010: --execute immediate l_sql INTO l_hrs USING p_period_end, p_period_start;
3011: l_rows_processed := dbms_sql.execute ( l_csr );
3012:
3013: IF DBMS_SQL.FETCH_ROWS (l_csr) > 0 THEN
3014: DBMS_SQL.COLUMN_VALUE (l_csr, 1, l_hrs);
3015: END IF;
3016:
3017: dbms_sql.close_cursor ( l_csr );

Line 3014: DBMS_SQL.COLUMN_VALUE (l_csr, 1, l_hrs);

3010: --execute immediate l_sql INTO l_hrs USING p_period_end, p_period_start;
3011: l_rows_processed := dbms_sql.execute ( l_csr );
3012:
3013: IF DBMS_SQL.FETCH_ROWS (l_csr) > 0 THEN
3014: DBMS_SQL.COLUMN_VALUE (l_csr, 1, l_hrs);
3015: END IF;
3016:
3017: dbms_sql.close_cursor ( l_csr );
3018:

Line 3017: dbms_sql.close_cursor ( l_csr );

3013: IF DBMS_SQL.FETCH_ROWS (l_csr) > 0 THEN
3014: DBMS_SQL.COLUMN_VALUE (l_csr, 1, l_hrs);
3015: END IF;
3016:
3017: dbms_sql.close_cursor ( l_csr );
3018:
3019: ELSIF ( hxc_time_category_utils_pkg.g_time_category_id IS NULL )
3020: THEN
3021:

Line 3093: l_csr := dbms_sql.open_cursor;

3089: hr_utility.trace( substr(l_sql,1501,250) );
3090: hr_utility.trace( substr(l_sql,1751,250) );
3091: END IF;
3092:
3093: l_csr := dbms_sql.open_cursor;
3094:
3095: dbms_sql.parse ( l_csr, l_sql, dbms_sql.native );
3096:
3097: FOR i IN 1..get_token_count(p_tc_bb_ok_string,',') LOOP

Line 3095: dbms_sql.parse ( l_csr, l_sql, dbms_sql.native );

3091: END IF;
3092:
3093: l_csr := dbms_sql.open_cursor;
3094:
3095: dbms_sql.parse ( l_csr, l_sql, dbms_sql.native );
3096:
3097: FOR i IN 1..get_token_count(p_tc_bb_ok_string,',') LOOP
3098:
3099: dbms_sql.bind_variable_char ( l_csr, ':'||i , get_token(p_tc_bb_ok_string,i,',' ));

Line 3099: dbms_sql.bind_variable_char ( l_csr, ':'||i , get_token(p_tc_bb_ok_string,i,',' ));

3095: dbms_sql.parse ( l_csr, l_sql, dbms_sql.native );
3096:
3097: FOR i IN 1..get_token_count(p_tc_bb_ok_string,',') LOOP
3098:
3099: dbms_sql.bind_variable_char ( l_csr, ':'||i , get_token(p_tc_bb_ok_string,i,',' ));
3100:
3101: END LOOP;
3102:
3103: DBMS_SQL.DEFINE_COLUMN (l_csr, 1, l_hrs);

Line 3103: DBMS_SQL.DEFINE_COLUMN (l_csr, 1, l_hrs);

3099: dbms_sql.bind_variable_char ( l_csr, ':'||i , get_token(p_tc_bb_ok_string,i,',' ));
3100:
3101: END LOOP;
3102:
3103: DBMS_SQL.DEFINE_COLUMN (l_csr, 1, l_hrs);
3104: --execute immediate l_sql INTO l_hrs;
3105: l_rows_processed := dbms_sql.execute ( l_csr );
3106:
3107: IF DBMS_SQL.FETCH_ROWS (l_csr) > 0 THEN

Line 3105: l_rows_processed := dbms_sql.execute ( l_csr );

3101: END LOOP;
3102:
3103: DBMS_SQL.DEFINE_COLUMN (l_csr, 1, l_hrs);
3104: --execute immediate l_sql INTO l_hrs;
3105: l_rows_processed := dbms_sql.execute ( l_csr );
3106:
3107: IF DBMS_SQL.FETCH_ROWS (l_csr) > 0 THEN
3108: DBMS_SQL.COLUMN_VALUE (l_csr, 1, l_hrs);
3109: END IF;

Line 3107: IF DBMS_SQL.FETCH_ROWS (l_csr) > 0 THEN

3103: DBMS_SQL.DEFINE_COLUMN (l_csr, 1, l_hrs);
3104: --execute immediate l_sql INTO l_hrs;
3105: l_rows_processed := dbms_sql.execute ( l_csr );
3106:
3107: IF DBMS_SQL.FETCH_ROWS (l_csr) > 0 THEN
3108: DBMS_SQL.COLUMN_VALUE (l_csr, 1, l_hrs);
3109: END IF;
3110:
3111: dbms_sql.close_cursor ( l_csr );

Line 3108: DBMS_SQL.COLUMN_VALUE (l_csr, 1, l_hrs);

3104: --execute immediate l_sql INTO l_hrs;
3105: l_rows_processed := dbms_sql.execute ( l_csr );
3106:
3107: IF DBMS_SQL.FETCH_ROWS (l_csr) > 0 THEN
3108: DBMS_SQL.COLUMN_VALUE (l_csr, 1, l_hrs);
3109: END IF;
3110:
3111: dbms_sql.close_cursor ( l_csr );
3112:

Line 3111: dbms_sql.close_cursor ( l_csr );

3107: IF DBMS_SQL.FETCH_ROWS (l_csr) > 0 THEN
3108: DBMS_SQL.COLUMN_VALUE (l_csr, 1, l_hrs);
3109: END IF;
3110:
3111: dbms_sql.close_cursor ( l_csr );
3112:
3113:
3114: ELSE
3115: