DBA Data[Home] [Help]

APPS.IBY_EXTRACTGEN_PVT dependencies on IBY_EXTRACTS_B

Line 65: l_code_pkg iby_extracts_b.gen_code_package%TYPE;

61: IS
62:
63: l_module_name CONSTANT VARCHAR2(200) := G_PKG_NAME || '.Create_Extract';
64:
65: l_code_pkg iby_extracts_b.gen_code_package%TYPE;
66: l_code_entry iby_extracts_b.gen_code_entry_point%TYPE;
67: l_call VARCHAR2(3000);
68: l_param_1 VARCHAR2(3000);
69: l_param_2 VARCHAR2(3000);

Line 66: l_code_entry iby_extracts_b.gen_code_entry_point%TYPE;

62:
63: l_module_name CONSTANT VARCHAR2(200) := G_PKG_NAME || '.Create_Extract';
64:
65: l_code_pkg iby_extracts_b.gen_code_package%TYPE;
66: l_code_entry iby_extracts_b.gen_code_entry_point%TYPE;
67: l_call VARCHAR2(3000);
68: l_param_1 VARCHAR2(3000);
69: l_param_2 VARCHAR2(3000);
70: l_param_3 VARCHAR2(3000);

Line 84: CURSOR c_x_info(ci_extract_code IN iby_extracts_b.extract_code%TYPE,

80:
81:
82: x_return_status VARCHAR2(200);
83:
84: CURSOR c_x_info(ci_extract_code IN iby_extracts_b.extract_code%TYPE,
85: ci_extract_version IN iby_extracts_b.extract_version%TYPE)
86: IS
87: SELECT gen_code_package,gen_code_entry_point
88: FROM iby_extracts_vl

Line 85: ci_extract_version IN iby_extracts_b.extract_version%TYPE)

81:
82: x_return_status VARCHAR2(200);
83:
84: CURSOR c_x_info(ci_extract_code IN iby_extracts_b.extract_code%TYPE,
85: ci_extract_version IN iby_extracts_b.extract_version%TYPE)
86: IS
87: SELECT gen_code_package,gen_code_entry_point
88: FROM iby_extracts_vl
89: WHERE (extract_code=ci_extract_code)