DBA Data[Home] [Help]

APPS.IBY_EXTRACTGEN_PVT dependencies on IBY_EXTRACTS_VL

Line 48: p_extract_code IN iby_extracts_vl.extract_code%TYPE,

44: END stripped_string;
45:
46: PROCEDURE Create_Extract
47: (
48: p_extract_code IN iby_extracts_vl.extract_code%TYPE,
49: p_extract_version IN iby_extracts_vl.extract_version%TYPE,
50: p_params IN OUT NOCOPY JTF_VARCHAR2_TABLE_200,
51: x_extract_doc OUT NOCOPY CLOB
52: )

Line 49: p_extract_version IN iby_extracts_vl.extract_version%TYPE,

45:
46: PROCEDURE Create_Extract
47: (
48: p_extract_code IN iby_extracts_vl.extract_code%TYPE,
49: p_extract_version IN iby_extracts_vl.extract_version%TYPE,
50: p_params IN OUT NOCOPY JTF_VARCHAR2_TABLE_200,
51: x_extract_doc OUT NOCOPY CLOB
52: )
53: IS

Line 80: FROM iby_extracts_vl

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)
82: AND (extract_version=ci_extract_version)
83: AND (gen_code_language='PLSQL');
84: BEGIN

Line 108: 'IBY_20590#TABLE=IBY_EXTRACTS_VL' || '#ID=' || p_extract_code,

104: CLOSE c_x_info;
105:
106: IF (l_x_not_found) THEN
107: raise_application_error(-20000,
108: 'IBY_20590#TABLE=IBY_EXTRACTS_VL' || '#ID=' || p_extract_code,
109: FALSE);
110: END IF;
111: -- test_debug('l_code_pkg: '|| l_code_pkg);
112: