DBA Data[Home] [Help]

APPS.AMS_MANUAL_LIST_GEN dependencies on JTF_NUMBER_TABLE

Line 240: ,p_primary_key_tbl IN JTF_NUMBER_TABLE--primary_key_Tbl_Type ,

236: --- manual entries changes start: musman
237: PROCEDURE do_bulk_insert
238: ( p_sql_string IN VARCHAR2
239: ,p_list_header_id in NUMBER
240: ,p_primary_key_tbl IN JTF_NUMBER_TABLE--primary_key_Tbl_Type ,
241: ,x_added_entry_count OUT NOCOPY NUMBER
242: ,x_return_status OUT NOCOPY VARCHAR2
243: ,x_msg_count OUT NOCOPY NUMBER
244: ,x_msg_data OUT NOCOPY VARCHAR2

Line 339: p_primary_key_tbl IN JTF_NUMBER_TABLE,--primary_key_Tbl_Type ,

335: x_return_status OUT NOCOPY VARCHAR2,
336: x_msg_count OUT NOCOPY NUMBER,
337: x_msg_data OUT NOCOPY VARCHAR2,
338: p_list_header_id in NUMBER,
339: p_primary_key_tbl IN JTF_NUMBER_TABLE,--primary_key_Tbl_Type ,
340: p_master_type in VARCHAR2
341: , x_added_entry_count OUT NOCOPY NUMBER --- manual entries changes added: musman
342: ) IS
343: l_api_name constant varchar2(30) := 'process_manual_list';

Line 402: l_primary_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();

398: l_no_of_rows_random number;
399:
400: l_allowed_spaces NUMBER ;
401: p_added_entry_count NUMBER;
402: l_primary_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
403:
404: l_added_entry_count NUMBER;
405: l_rows_to_add NUMBER;
406: l_remaining_Spaces NUMBER;

Line 603: l_primary_tbl := JTF_NUMBER_TABLE();

599: END IF;
600: --l_end_counter := l_start_counter + (l_remaining_spaces-1);
601: l_end_counter := l_end_counter +l_remaining_Spaces ;
602: l_primary_tbl.delete;
603: l_primary_tbl := JTF_NUMBER_TABLE();
604:
605: IF l_end_counter > l_rows_to_add THEN
606: l_end_counter := l_rows_to_add;
607: END IF;

Line 772: p_primary_key_tbl IN JTF_NUMBER_TABLE,--primary_key_Tbl_Type ,

768: x_return_status OUT NOCOPY VARCHAR2,
769: x_msg_count OUT NOCOPY NUMBER,
770: x_msg_data OUT NOCOPY VARCHAR2,
771: p_list_header_id in NUMBER,
772: p_primary_key_tbl IN JTF_NUMBER_TABLE,--primary_key_Tbl_Type ,
773: p_master_type in VARCHAR2
774: -- , x_added_entry_count OUT NOCOPY NUMBER --- manual entries changes added:musman
775: ) IS
776: