DBA Data[Home] [Help]

APPS.CSF_TASKS_PUB dependencies on JTF_NUMBER_TABLE

Line 2159: l_task_id_tbl jtf_number_table;

2155: l_cnt NUMBER :=1;
2156:
2157: l_where_clause csf_dc_queries_b.where_clause%TYPE;
2158: l_query VARCHAR2(2000);
2159: l_task_id_tbl jtf_number_table;
2160: l_task_split_flag_tbl task_split_tbl_type;
2161: l_task_num_tbl jtf_number_table := jtf_number_table();
2162: l_child_task_id_tbl jtf_number_table;
2163: l_trip_status_tbl jtf_number_table;

Line 2161: l_task_num_tbl jtf_number_table := jtf_number_table();

2157: l_where_clause csf_dc_queries_b.where_clause%TYPE;
2158: l_query VARCHAR2(2000);
2159: l_task_id_tbl jtf_number_table;
2160: l_task_split_flag_tbl task_split_tbl_type;
2161: l_task_num_tbl jtf_number_table := jtf_number_table();
2162: l_child_task_id_tbl jtf_number_table;
2163: l_trip_status_tbl jtf_number_table;
2164: l_processed_count PLS_INTEGER;
2165: l_blocked_trip_found BOOLEAN;

Line 2162: l_child_task_id_tbl jtf_number_table;

2158: l_query VARCHAR2(2000);
2159: l_task_id_tbl jtf_number_table;
2160: l_task_split_flag_tbl task_split_tbl_type;
2161: l_task_num_tbl jtf_number_table := jtf_number_table();
2162: l_child_task_id_tbl jtf_number_table;
2163: l_trip_status_tbl jtf_number_table;
2164: l_processed_count PLS_INTEGER;
2165: l_blocked_trip_found BOOLEAN;
2166: l_all_passed BOOLEAN;

Line 2163: l_trip_status_tbl jtf_number_table;

2159: l_task_id_tbl jtf_number_table;
2160: l_task_split_flag_tbl task_split_tbl_type;
2161: l_task_num_tbl jtf_number_table := jtf_number_table();
2162: l_child_task_id_tbl jtf_number_table;
2163: l_trip_status_tbl jtf_number_table;
2164: l_processed_count PLS_INTEGER;
2165: l_blocked_trip_found BOOLEAN;
2166: l_all_passed BOOLEAN;
2167:

Line 3833: l_cust_task_tbl jtf_number_table := jtf_number_table();

3829: , t.object_version_number
3830: FROM jtf_tasks_b t
3831: WHERE task_id = p_task_id;
3832:
3833: l_cust_task_tbl jtf_number_table := jtf_number_table();
3834: l_cust_objver_tbl jtf_number_table := jtf_number_table();
3835: l_task_info c_task_info%ROWTYPE;
3836: BEGIN
3837: SAVEPOINT csf_update_cust_confirmation;

Line 3834: l_cust_objver_tbl jtf_number_table := jtf_number_table();

3830: FROM jtf_tasks_b t
3831: WHERE task_id = p_task_id;
3832:
3833: l_cust_task_tbl jtf_number_table := jtf_number_table();
3834: l_cust_objver_tbl jtf_number_table := jtf_number_table();
3835: l_task_info c_task_info%ROWTYPE;
3836: BEGIN
3837: SAVEPOINT csf_update_cust_confirmation;
3838: