DBA Data[Home] [Help]

APPS.OZF_WEBADI_INTERFACE_PVT dependencies on JTF_NUMBER_TABLE

Line 31: l_code_conversion_id_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();

27: IS
28:
29: l_api_name CONSTANT VARCHAR2(30) := 'code_conversion_webadi';
30: l_api_version_number CONSTANT NUMBER := 1.0;
31: l_code_conversion_id_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
32: l_code_conversion_rec OZF_CODE_CONVERSION_PVT.CODE_CONVERSION_REC_TYPE := ozf_code_conversion_pvt.g_miss_code_conversion_rec;
33: l_code_conversion_tbl OZF_CODE_CONVERSION_PVT.CODE_CONVERSION_TBL_TYPE := ozf_code_conversion_pvt.g_miss_code_conversion_tbl;
34: l_error VARCHAR2(30) := 'OZF_WEBADI_ERROR';
35: l_object_version_no_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();

Line 35: l_object_version_no_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();

31: l_code_conversion_id_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
32: l_code_conversion_rec OZF_CODE_CONVERSION_PVT.CODE_CONVERSION_REC_TYPE := ozf_code_conversion_pvt.g_miss_code_conversion_rec;
33: l_code_conversion_tbl OZF_CODE_CONVERSION_PVT.CODE_CONVERSION_TBL_TYPE := ozf_code_conversion_pvt.g_miss_code_conversion_tbl;
34: l_error VARCHAR2(30) := 'OZF_WEBADI_ERROR';
35: l_object_version_no_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
36: x_msg_count NUMBER;
37: x_msg_data VARCHAR2(2000);
38: x_return_status VARCHAR(3);
39: l_message VARCHAR2(32000);

Line 691: l_resale_line_int_id_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();

687: l_batch_status VARCHAR2(30);
688:
689: l_resale_batch_rec ozf_resale_batches_all%rowtype;
690: l_int_line_tbl ozf_pre_process_pvt.resale_line_int_tbl_type := ozf_pre_process_pvt.resale_line_int_tbl_type();
691: l_resale_line_int_id_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
692: l_object_version_no_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
693: l_total_claimed_amount NUMBER := 0;
694: j NUMBER;
695: l_file utl_file.file_type;

Line 692: l_object_version_no_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();

688:
689: l_resale_batch_rec ozf_resale_batches_all%rowtype;
690: l_int_line_tbl ozf_pre_process_pvt.resale_line_int_tbl_type := ozf_pre_process_pvt.resale_line_int_tbl_type();
691: l_resale_line_int_id_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
692: l_object_version_no_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
693: l_total_claimed_amount NUMBER := 0;
694: j NUMBER;
695: l_file utl_file.file_type;
696: l_file_dir VARCHAR2(500);