DBA Data[Home] [Help]

APPS.OZF_WEBADI_INTERFACE_PVT dependencies on JTF_NUMBER_TABLE

Line 45: l_code_conversion_id_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();

41: IS
42:
43: l_api_name CONSTANT VARCHAR2(30) := 'code_conversion_webadi';
44: l_api_version_number CONSTANT NUMBER := 1.0;
45: l_code_conversion_id_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
46: l_code_conversion_rec OZF_CODE_CONVERSION_PVT.CODE_CONVERSION_REC_TYPE := ozf_code_conversion_pvt.g_miss_code_conversion_rec;
47: l_code_conversion_tbl OZF_CODE_CONVERSION_PVT.CODE_CONVERSION_TBL_TYPE := ozf_code_conversion_pvt.g_miss_code_conversion_tbl;
48: l_error VARCHAR2(30) := 'OZF_WEBADI_ERROR';
49: l_object_version_no_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();

Line 49: l_object_version_no_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();

45: l_code_conversion_id_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
46: l_code_conversion_rec OZF_CODE_CONVERSION_PVT.CODE_CONVERSION_REC_TYPE := ozf_code_conversion_pvt.g_miss_code_conversion_rec;
47: l_code_conversion_tbl OZF_CODE_CONVERSION_PVT.CODE_CONVERSION_TBL_TYPE := ozf_code_conversion_pvt.g_miss_code_conversion_tbl;
48: l_error VARCHAR2(30) := 'OZF_WEBADI_ERROR';
49: l_object_version_no_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
50: l_internal_code VARCHAR2(4000);
51: x_msg_count NUMBER;
52: x_msg_data VARCHAR2(2000);
53: x_return_status VARCHAR(3);

Line 935: l_resale_line_int_id_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();

931: l_location_count NUMBER := 0;
932:
933: l_resale_batch_rec ozf_resale_batches_all%rowtype;
934: l_int_line_tbl ozf_pre_process_pvt.resale_line_int_tbl_type := ozf_pre_process_pvt.resale_line_int_tbl_type();
935: l_resale_line_int_id_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
936: l_object_version_no_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
937: l_total_claimed_amount NUMBER := 0;
938: j NUMBER;
939: l_file utl_file.file_type;

Line 936: l_object_version_no_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();

932:
933: l_resale_batch_rec ozf_resale_batches_all%rowtype;
934: l_int_line_tbl ozf_pre_process_pvt.resale_line_int_tbl_type := ozf_pre_process_pvt.resale_line_int_tbl_type();
935: l_resale_line_int_id_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
936: l_object_version_no_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
937: l_total_claimed_amount NUMBER := 0;
938: j NUMBER;
939: l_file utl_file.file_type;
940: l_file_dir VARCHAR2(500);