53: IS
54:
55: l_module_name CONSTANT VARCHAR2(200) := G_PKG_NAME || '.Create_Extract';
56:
57: l_code_pkg iby_extracts_b.gen_code_package%TYPE;
58: l_code_entry iby_extracts_b.gen_code_entry_point%TYPE;
59: l_call VARCHAR2(3000);
60: l_param_1 VARCHAR2(3000);
61: l_param_2 VARCHAR2(3000);
54:
55: l_module_name CONSTANT VARCHAR2(200) := G_PKG_NAME || '.Create_Extract';
56:
57: l_code_pkg iby_extracts_b.gen_code_package%TYPE;
58: l_code_entry iby_extracts_b.gen_code_entry_point%TYPE;
59: l_call VARCHAR2(3000);
60: l_param_1 VARCHAR2(3000);
61: l_param_2 VARCHAR2(3000);
62: l_param_3 VARCHAR2(3000);
72:
73:
74: x_return_status VARCHAR2(200);
75:
76: CURSOR c_x_info(ci_extract_code IN iby_extracts_b.extract_code%TYPE,
77: ci_extract_version IN iby_extracts_b.extract_version%TYPE)
78: IS
79: SELECT gen_code_package,gen_code_entry_point
80: FROM iby_extracts_vl
73:
74: x_return_status VARCHAR2(200);
75:
76: CURSOR c_x_info(ci_extract_code IN iby_extracts_b.extract_code%TYPE,
77: ci_extract_version IN iby_extracts_b.extract_version%TYPE)
78: IS
79: SELECT gen_code_package,gen_code_entry_point
80: FROM iby_extracts_vl
81: WHERE (extract_code=ci_extract_code)