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
54:
683: PROCEDURE get_template_parameters
684: (
685: p_template_code IN iby_formats_b.format_template_code%TYPE,
686: p_pay_instruction IN VARCHAR2,
687: p_parameters_code OUT NOCOPY JTF_VARCHAR2_TABLE_200,
688: p_parameters_value OUT NOCOPY JTF_VARCHAR2_TABLE_200
689: ) IS
690:
691: l_module_name CONSTANT VARCHAR2(200) := G_PKG_NAME || '.get_template_parameters';
684: (
685: p_template_code IN iby_formats_b.format_template_code%TYPE,
686: p_pay_instruction IN VARCHAR2,
687: p_parameters_code OUT NOCOPY JTF_VARCHAR2_TABLE_200,
688: p_parameters_value OUT NOCOPY JTF_VARCHAR2_TABLE_200
689: ) IS
690:
691: l_module_name CONSTANT VARCHAR2(200) := G_PKG_NAME || '.get_template_parameters';
692: l_filename fnd_concurrent_requests.outfile_name%TYPE;
693:
694: BEGIN
695:
696: -- initialize output parameters
697: p_parameters_code := JTF_VARCHAR2_TABLE_200();
698: p_parameters_value := JTF_VARCHAR2_TABLE_200();
699:
700: IF (p_template_code = 'IBYAL_PT') THEN
701: -- get the filename and return in to be set as a template parameter
694: BEGIN
695:
696: -- initialize output parameters
697: p_parameters_code := JTF_VARCHAR2_TABLE_200();
698: p_parameters_value := JTF_VARCHAR2_TABLE_200();
699:
700: IF (p_template_code = 'IBYAL_PT') THEN
701: -- get the filename and return in to be set as a template parameter
702: