DBA Data[Home] [Help]

APPS.CSF_TASKS_PUB dependencies on JTF_NUMBER_TABLE

Line 2584: p_res_id jtf_number_table ;

2580: l_api_version CONSTANT NUMBER := 1.0;
2581:
2582:
2583:
2584: p_res_id jtf_number_table ;
2585: p_res_type jtf_varchar2_table_2000 ;
2586: p_res_name jtf_varchar2_table_2000 ;
2587: p_res_typ_name jtf_varchar2_table_2000 ;
2588: p_res_key jtf_varchar2_table_2000 ;

Line 2655: l_task_id_tbl jtf_number_table;

2651: l_cnt NUMBER :=1;
2652:
2653: l_where_clause csf_dc_queries_b.where_clause%TYPE;
2654: l_query VARCHAR2(2000);
2655: l_task_id_tbl jtf_number_table;
2656: l_task_split_flag_tbl task_split_tbl_type;
2657: l_task_num_tbl jtf_number_table := jtf_number_table();
2658: l_child_task_id_tbl jtf_number_table;
2659: l_trip_status_tbl jtf_number_table;

Line 2657: l_task_num_tbl jtf_number_table := jtf_number_table();

2653: l_where_clause csf_dc_queries_b.where_clause%TYPE;
2654: l_query VARCHAR2(2000);
2655: l_task_id_tbl jtf_number_table;
2656: l_task_split_flag_tbl task_split_tbl_type;
2657: l_task_num_tbl jtf_number_table := jtf_number_table();
2658: l_child_task_id_tbl jtf_number_table;
2659: l_trip_status_tbl jtf_number_table;
2660: l_processed_count PLS_INTEGER;
2661: l_blocked_trip_found BOOLEAN;

Line 2658: l_child_task_id_tbl jtf_number_table;

2654: l_query VARCHAR2(2000);
2655: l_task_id_tbl jtf_number_table;
2656: l_task_split_flag_tbl task_split_tbl_type;
2657: l_task_num_tbl jtf_number_table := jtf_number_table();
2658: l_child_task_id_tbl jtf_number_table;
2659: l_trip_status_tbl jtf_number_table;
2660: l_processed_count PLS_INTEGER;
2661: l_blocked_trip_found BOOLEAN;
2662: l_all_passed BOOLEAN;

Line 2659: l_trip_status_tbl jtf_number_table;

2655: l_task_id_tbl jtf_number_table;
2656: l_task_split_flag_tbl task_split_tbl_type;
2657: l_task_num_tbl jtf_number_table := jtf_number_table();
2658: l_child_task_id_tbl jtf_number_table;
2659: l_trip_status_tbl jtf_number_table;
2660: l_processed_count PLS_INTEGER;
2661: l_blocked_trip_found BOOLEAN;
2662: l_all_passed BOOLEAN;
2663:

Line 4481: l_cust_task_tbl jtf_number_table := jtf_number_table();

4477: , t.object_version_number
4478: FROM jtf_tasks_b t
4479: WHERE task_id = p_task_id;
4480:
4481: l_cust_task_tbl jtf_number_table := jtf_number_table();
4482: l_cust_objver_tbl jtf_number_table := jtf_number_table();
4483: l_task_info c_task_info%ROWTYPE;
4484: BEGIN
4485: SAVEPOINT csf_update_cust_confirmation;

Line 4482: l_cust_objver_tbl jtf_number_table := jtf_number_table();

4478: FROM jtf_tasks_b t
4479: WHERE task_id = p_task_id;
4480:
4481: l_cust_task_tbl jtf_number_table := jtf_number_table();
4482: l_cust_objver_tbl jtf_number_table := jtf_number_table();
4483: l_task_info c_task_info%ROWTYPE;
4484: BEGIN
4485: SAVEPOINT csf_update_cust_confirmation;
4486: