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 841: t_bb_id dbms_sql.Number_Table;

837: PROCEDURE validate_time_category_sql ( p_sql_string IN CLOB ) IS -- Bug 15977687
838:
839: l_sql CLOB := 'select distinct ta.bb_id from hxc_tmp_atts ta where '; -- Bug 15977687
840:
841: t_bb_id dbms_sql.Number_Table;
842:
843: l_csr INTEGER;
844: l_rows_fetched INTEGER;
845: l_dummy INTEGER;

Line 947: l_csr := dbms_sql.open_cursor;

943:
944: BEGIN
945: l_rows_fetched := 100;
946:
947: l_csr := dbms_sql.open_cursor;
948:
949: dbms_sql.parse ( l_csr, l_sql, dbms_sql.native );
950:
951: -- replace the parse_time_sql bind

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

945: l_rows_fetched := 100;
946:
947: l_csr := dbms_sql.open_cursor;
948:
949: dbms_sql.parse ( l_csr, l_sql, dbms_sql.native );
950:
951: -- replace the parse_time_sql bind
952: WHILE l_between_or is not null
953: LOOP

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

961: -- now I can replace the value with the bind
962: l_before_equal1 := replace(get_token (l_before_and,2,'='),')','');
963: l_before_equal1 := trim(replace(l_before_equal1,'''',''));
964: -- Bug 8589919
965: --dbms_sql.bind_variable( l_csr, ':'||l_index*1000, l_before_equal1 );
966: dbms_sql.bind_variable( l_csr, ':'||l_index, l_before_equal1 );
967:
968: IF (instr(l_after_and,'IS NOT NULL') = 0 AND instr(l_after_and,'IS NULL') = 0
969: AND instr(l_after_and,'<>') = 0 AND instr(l_after_and,'IN') = 0)

Line 966: dbms_sql.bind_variable( l_csr, ':'||l_index, l_before_equal1 );

962: l_before_equal1 := replace(get_token (l_before_and,2,'='),')','');
963: l_before_equal1 := trim(replace(l_before_equal1,'''',''));
964: -- Bug 8589919
965: --dbms_sql.bind_variable( l_csr, ':'||l_index*1000, l_before_equal1 );
966: dbms_sql.bind_variable( l_csr, ':'||l_index, l_before_equal1 );
967:
968: IF (instr(l_after_and,'IS NOT NULL') = 0 AND instr(l_after_and,'IS NULL') = 0
969: AND instr(l_after_and,'<>') = 0 AND instr(l_after_and,'IN') = 0)
970: THEN

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

973: l_before_equal2 := replace(get_token (l_after_and,2,'='),')','');
974: l_before_equal2 := trim(replace(l_before_equal2,'''',''));
975:
976: -- Bug 8589919
977: dbms_sql.bind_variable( l_csr, ':'||((l_index)+1),l_before_equal2);
978:
979: END IF;
980:
981: END IF;

Line 987: dbms_sql.define_array (

983: l_index := l_index + 5;
984:
985: END LOOP;
986:
987: dbms_sql.define_array (
988: c => l_csr
989: , position => 1
990: , n_tab => t_bb_id
991: , cnt => l_rows_fetched

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

990: , n_tab => t_bb_id
991: , cnt => l_rows_fetched
992: , lower_bound => 1 );
993:
994: l_dummy := dbms_sql.execute ( l_csr );
995:
996: -- loop to ensure we fetch all the rows
997:
998: WHILE ( l_rows_fetched = 100 )

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

997:
998: WHILE ( l_rows_fetched = 100 )
999: LOOP
1000:
1001: l_rows_fetched := dbms_sql.fetch_rows ( l_csr );
1002:
1003: IF ( l_rows_fetched > 0 )
1004: THEN
1005:

Line 1006: dbms_sql.column_value (

1002:
1003: IF ( l_rows_fetched > 0 )
1004: THEN
1005:
1006: dbms_sql.column_value (
1007: c => l_csr
1008: , position => 1
1009: , n_tab => t_bb_id );
1010:

Line 1017: dbms_sql.close_cursor ( l_csr );

1013: END IF;
1014:
1015: END LOOP;
1016:
1017: dbms_sql.close_cursor ( l_csr );
1018:
1019: -- execute immediate l_sql INTO l_dummy;
1020:
1021: EXCEPTION WHEN NO_DATA_FOUND THEN

Line 2402: t_bb_id dbms_sql.Number_Table;

2398: AND ';
2399:
2400: l_sql CLOB; -- Bug 15977687
2401:
2402: t_bb_id dbms_sql.Number_Table;
2403:
2404: l_csr INTEGER;
2405: l_rows_fetched INTEGER;
2406: l_dummy INTEGER;

Line 2581: l_csr := dbms_sql.open_cursor;

2577: -- now fetch rows
2578:
2579: l_rows_fetched := 100;
2580:
2581: l_csr := dbms_sql.open_cursor;
2582:
2583: dbms_sql.parse ( l_csr, l_sql, dbms_sql.native );
2584:
2585: IF ( NOT g_params.p_use_temp_table )

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

2579: l_rows_fetched := 100;
2580:
2581: l_csr := dbms_sql.open_cursor;
2582:
2583: dbms_sql.parse ( l_csr, l_sql, dbms_sql.native );
2584:
2585: IF ( NOT g_params.p_use_temp_table )
2586: THEN
2587:

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

2584:
2585: IF ( NOT g_params.p_use_temp_table )
2586: THEN
2587:
2588: dbms_sql.bind_variable ( l_csr, ':p_tbb_id' , g_params.p_tbb_id );
2589: dbms_sql.bind_variable ( l_csr, ':p_tbb_ovn', g_params.p_tbb_ovn );
2590:
2591:
2592: IF ( ( p_operator = 'AND' ) AND ( p_tc_bb_ok_string IS NOT NULL ) )

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

2585: IF ( NOT g_params.p_use_temp_table )
2586: THEN
2587:
2588: dbms_sql.bind_variable ( l_csr, ':p_tbb_id' , g_params.p_tbb_id );
2589: dbms_sql.bind_variable ( l_csr, ':p_tbb_ovn', g_params.p_tbb_ovn );
2590:
2591:
2592: IF ( ( p_operator = 'AND' ) AND ( p_tc_bb_ok_string IS NOT NULL ) )
2593: THEN

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

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

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

2599: ELSIF ( p_operator = 'OR' )
2600: THEN
2601:
2602: FOR i IN 1..get_token_count(p_tc_bb_not_ok_string,',') LOOP
2603: dbms_sql.bind_variable_char ( l_csr, ':'||i , get_token(p_tc_bb_not_ok_string,i,',' ));
2604: END LOOP;
2605:
2606: END IF;
2607:

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

2610: IF ( ( p_operator = 'AND' ) AND ( p_tc_bb_ok_string IS NOT NULL ) ) THEN
2611:
2612: FOR i IN 1..get_token_count(p_tc_bb_ok_string,',') LOOP
2613:
2614: dbms_sql.bind_variable_char ( l_csr, ':'||i , get_token(p_tc_bb_ok_string,i,',' ));
2615:
2616: END LOOP;
2617:
2618: ELSIF ( p_operator = 'OR' ) AND ( p_tc_bb_not_ok_string IS NOT NULL ) THEN

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

2617:
2618: ELSIF ( p_operator = 'OR' ) AND ( p_tc_bb_not_ok_string IS NOT NULL ) THEN
2619:
2620: FOR i IN 1..get_token_count(p_tc_bb_not_ok_string,',') LOOP
2621: dbms_sql.bind_variable_char ( l_csr, ':'||i , get_token(p_tc_bb_not_ok_string,i,',' ));
2622: END LOOP;
2623:
2624:
2625: END IF;

Line 2645: dbms_sql.bind_variable( l_csr, ':'||l_index, l_before_equal1 );

2641: -- now I can replace the value with the bind
2642: l_before_equal1 := replace(get_token (l_before_and,2,'='),')','');
2643: l_before_equal1 := trim(replace(l_before_equal1,'''',''));
2644: -- Bug 8589919
2645: dbms_sql.bind_variable( l_csr, ':'||l_index, l_before_equal1 );
2646:
2647: IF (instr(l_after_and,'IS NOT NULL') = 0 AND instr(l_after_and,'IS NULL') = 0
2648: AND instr(l_after_and,'<>') = 0 AND instr(l_after_and,'IN') = 0) THEN
2649:

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

2651: l_before_equal2 := replace(get_token (l_after_and,2,'='),')','');
2652: l_before_equal2 := trim(replace(l_before_equal2,'''',''));
2653:
2654: -- Bug 8589919
2655: dbms_sql.bind_variable( l_csr, ':'||((l_index)+1),l_before_equal2);
2656:
2657: END IF;
2658:
2659: END IF;

Line 2667: dbms_sql.define_array (

2663: END LOOP;
2664:
2665:
2666:
2667: dbms_sql.define_array (
2668: c => l_csr
2669: , position => 1
2670: , n_tab => t_bb_id
2671: , cnt => l_rows_fetched

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

2670: , n_tab => t_bb_id
2671: , cnt => l_rows_fetched
2672: , lower_bound => 1 );
2673:
2674: l_dummy := dbms_sql.execute ( l_csr );
2675:
2676: -- loop to ensure we fetch all the rows
2677:
2678: WHILE ( l_rows_fetched = 100 )

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

2677:
2678: WHILE ( l_rows_fetched = 100 )
2679: LOOP
2680:
2681: l_rows_fetched := dbms_sql.fetch_rows ( l_csr );
2682:
2683: IF ( g_debug ) THEN
2684: hr_utility.trace('l rows fetched is '||to_char(l_rows_fetched));
2685: END IF;

Line 2690: dbms_sql.column_value (

2686:
2687: IF ( l_rows_fetched > 0 )
2688: THEN
2689:
2690: dbms_sql.column_value (
2691: c => l_csr
2692: , position => 1
2693: , n_tab => t_bb_id );
2694:

Line 2757: dbms_sql.close_cursor ( l_csr );

2753: END IF; -- l_rows_fetched > 0
2754:
2755: END LOOP;
2756:
2757: dbms_sql.close_cursor ( l_csr );
2758:
2759: IF ( g_debug ) THEN
2760: hr_utility.trace('GAZ - BB OK string is '||l_bb_ok_string);
2761: hr_utility.trace('GAZ - BB NOT OK string is '||l_bb_not_ok_string);

Line 3106: l_csr := dbms_sql.open_cursor;

3102: hr_utility.trace( substr(l_sql,1501,250) );
3103: hr_utility.trace( substr(l_sql,1751,250) );
3104: END IF;
3105:
3106: l_csr := dbms_sql.open_cursor;
3107:
3108: dbms_sql.parse ( l_csr, l_sql, dbms_sql.native );
3109:
3110: FOR i IN 1..get_token_count(p_tc_bb_ok_string,',') LOOP

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

3104: END IF;
3105:
3106: l_csr := dbms_sql.open_cursor;
3107:
3108: dbms_sql.parse ( l_csr, l_sql, dbms_sql.native );
3109:
3110: FOR i IN 1..get_token_count(p_tc_bb_ok_string,',') LOOP
3111:
3112: dbms_sql.bind_variable_char ( l_csr, ':'||i , get_token(p_tc_bb_ok_string,i,',' ));

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

3108: dbms_sql.parse ( l_csr, l_sql, dbms_sql.native );
3109:
3110: FOR i IN 1..get_token_count(p_tc_bb_ok_string,',') LOOP
3111:
3112: dbms_sql.bind_variable_char ( l_csr, ':'||i , get_token(p_tc_bb_ok_string,i,',' ));
3113:
3114: END LOOP;
3115:
3116: dbms_sql.bind_variable ( l_csr, ':p_period_end' , p_period_end );

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

3112: dbms_sql.bind_variable_char ( l_csr, ':'||i , get_token(p_tc_bb_ok_string,i,',' ));
3113:
3114: END LOOP;
3115:
3116: dbms_sql.bind_variable ( l_csr, ':p_period_end' , p_period_end );
3117: dbms_sql.bind_variable ( l_csr, ':p_period_start', p_period_start);
3118:
3119: DBMS_SQL.DEFINE_COLUMN (l_csr, 1, l_hrs);
3120: --execute immediate l_sql INTO l_hrs USING p_period_end, p_period_start;

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

3113:
3114: END LOOP;
3115:
3116: dbms_sql.bind_variable ( l_csr, ':p_period_end' , p_period_end );
3117: dbms_sql.bind_variable ( l_csr, ':p_period_start', p_period_start);
3118:
3119: DBMS_SQL.DEFINE_COLUMN (l_csr, 1, l_hrs);
3120: --execute immediate l_sql INTO l_hrs USING p_period_end, p_period_start;
3121: l_rows_processed := dbms_sql.execute ( l_csr );

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

3115:
3116: dbms_sql.bind_variable ( l_csr, ':p_period_end' , p_period_end );
3117: dbms_sql.bind_variable ( l_csr, ':p_period_start', p_period_start);
3118:
3119: DBMS_SQL.DEFINE_COLUMN (l_csr, 1, l_hrs);
3120: --execute immediate l_sql INTO l_hrs USING p_period_end, p_period_start;
3121: l_rows_processed := dbms_sql.execute ( l_csr );
3122:
3123: IF DBMS_SQL.FETCH_ROWS (l_csr) > 0 THEN

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

3117: dbms_sql.bind_variable ( l_csr, ':p_period_start', p_period_start);
3118:
3119: DBMS_SQL.DEFINE_COLUMN (l_csr, 1, l_hrs);
3120: --execute immediate l_sql INTO l_hrs USING p_period_end, p_period_start;
3121: l_rows_processed := dbms_sql.execute ( l_csr );
3122:
3123: IF DBMS_SQL.FETCH_ROWS (l_csr) > 0 THEN
3124: DBMS_SQL.COLUMN_VALUE (l_csr, 1, l_hrs);
3125: END IF;

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

3119: DBMS_SQL.DEFINE_COLUMN (l_csr, 1, l_hrs);
3120: --execute immediate l_sql INTO l_hrs USING p_period_end, p_period_start;
3121: l_rows_processed := dbms_sql.execute ( l_csr );
3122:
3123: IF DBMS_SQL.FETCH_ROWS (l_csr) > 0 THEN
3124: DBMS_SQL.COLUMN_VALUE (l_csr, 1, l_hrs);
3125: END IF;
3126:
3127: dbms_sql.close_cursor ( l_csr );

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

3120: --execute immediate l_sql INTO l_hrs USING p_period_end, p_period_start;
3121: l_rows_processed := dbms_sql.execute ( l_csr );
3122:
3123: IF DBMS_SQL.FETCH_ROWS (l_csr) > 0 THEN
3124: DBMS_SQL.COLUMN_VALUE (l_csr, 1, l_hrs);
3125: END IF;
3126:
3127: dbms_sql.close_cursor ( l_csr );
3128:

Line 3127: dbms_sql.close_cursor ( l_csr );

3123: IF DBMS_SQL.FETCH_ROWS (l_csr) > 0 THEN
3124: DBMS_SQL.COLUMN_VALUE (l_csr, 1, l_hrs);
3125: END IF;
3126:
3127: dbms_sql.close_cursor ( l_csr );
3128:
3129: ELSIF ( hxc_time_category_utils_pkg.g_time_category_id IS NULL )
3130: THEN
3131: IF ( g_debug ) THEN

Line 3210: l_csr := dbms_sql.open_cursor;

3206: hr_utility.trace( substr(l_sql,1501,250) );
3207: hr_utility.trace( substr(l_sql,1751,250) );
3208: END IF;
3209:
3210: l_csr := dbms_sql.open_cursor;
3211:
3212: dbms_sql.parse ( l_csr, l_sql, dbms_sql.native );
3213:
3214: FOR i IN 1..get_token_count(p_tc_bb_ok_string,',') LOOP

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

3208: END IF;
3209:
3210: l_csr := dbms_sql.open_cursor;
3211:
3212: dbms_sql.parse ( l_csr, l_sql, dbms_sql.native );
3213:
3214: FOR i IN 1..get_token_count(p_tc_bb_ok_string,',') LOOP
3215:
3216: dbms_sql.bind_variable_char ( l_csr, ':'||i , get_token(p_tc_bb_ok_string,i,',' ));

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

3212: dbms_sql.parse ( l_csr, l_sql, dbms_sql.native );
3213:
3214: FOR i IN 1..get_token_count(p_tc_bb_ok_string,',') LOOP
3215:
3216: dbms_sql.bind_variable_char ( l_csr, ':'||i , get_token(p_tc_bb_ok_string,i,',' ));
3217:
3218: END LOOP;
3219:
3220: DBMS_SQL.DEFINE_COLUMN (l_csr, 1, l_hrs);

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

3216: dbms_sql.bind_variable_char ( l_csr, ':'||i , get_token(p_tc_bb_ok_string,i,',' ));
3217:
3218: END LOOP;
3219:
3220: DBMS_SQL.DEFINE_COLUMN (l_csr, 1, l_hrs);
3221: --execute immediate l_sql INTO l_hrs;
3222: l_rows_processed := dbms_sql.execute ( l_csr );
3223:
3224: IF DBMS_SQL.FETCH_ROWS (l_csr) > 0 THEN

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

3218: END LOOP;
3219:
3220: DBMS_SQL.DEFINE_COLUMN (l_csr, 1, l_hrs);
3221: --execute immediate l_sql INTO l_hrs;
3222: l_rows_processed := dbms_sql.execute ( l_csr );
3223:
3224: IF DBMS_SQL.FETCH_ROWS (l_csr) > 0 THEN
3225: DBMS_SQL.COLUMN_VALUE (l_csr, 1, l_hrs);
3226: END IF;

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

3220: DBMS_SQL.DEFINE_COLUMN (l_csr, 1, l_hrs);
3221: --execute immediate l_sql INTO l_hrs;
3222: l_rows_processed := dbms_sql.execute ( l_csr );
3223:
3224: IF DBMS_SQL.FETCH_ROWS (l_csr) > 0 THEN
3225: DBMS_SQL.COLUMN_VALUE (l_csr, 1, l_hrs);
3226: END IF;
3227:
3228: dbms_sql.close_cursor ( l_csr );

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

3221: --execute immediate l_sql INTO l_hrs;
3222: l_rows_processed := dbms_sql.execute ( l_csr );
3223:
3224: IF DBMS_SQL.FETCH_ROWS (l_csr) > 0 THEN
3225: DBMS_SQL.COLUMN_VALUE (l_csr, 1, l_hrs);
3226: END IF;
3227:
3228: dbms_sql.close_cursor ( l_csr );
3229:

Line 3228: dbms_sql.close_cursor ( l_csr );

3224: IF DBMS_SQL.FETCH_ROWS (l_csr) > 0 THEN
3225: DBMS_SQL.COLUMN_VALUE (l_csr, 1, l_hrs);
3226: END IF;
3227:
3228: dbms_sql.close_cursor ( l_csr );
3229:
3230:
3231: ELSE
3232: