2012:
2013: FUNCTION GetVariableValue(p_cat_id number,p_variable_code varchar2,p_variable_value_id varchar2,p_attribute_value_set_id number)
2014: return VARCHAR2 is
2015: p_api_version NUMBER;
2016: p_init_msg_list VARCHAR2(4000) := FND_API.G_FALSE;
2017: p_doc_type VARCHAR2(50):=DOCUMENTTYPE;
2018: p_doc_id NUMBER :=DOCUMENTID;
2019: x_return_status VARCHAR2(10);
2020: x_msg_data VARCHAR2(4000);
2049:
2050:
2051: PROCEDURE Get_System_Variables (
2052: p_api_version IN NUMBER,
2053: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
2054:
2055: x_return_status OUT NOCOPY VARCHAR2,
2056: x_msg_data OUT NOCOPY VARCHAR2,
2057: x_msg_count OUT NOCOPY NUMBER,
2057: x_msg_count OUT NOCOPY NUMBER,
2058:
2059: p_doc_type IN VARCHAR2,
2060: p_doc_id IN NUMBER,
2061: p_only_doc_variables IN VARCHAR2 := FND_API.G_TRUE,
2062:
2063: x_sys_var_value_tbl OUT NOCOPY OKC_TERMS_UTIL_GRP.sys_var_value_tbl_type
2064: ) IS
2065: l_api_version CONSTANT NUMBER := 1;
2084: BEGIN
2085:
2086: x_return_status := 'S';
2087:
2088: IF p_only_doc_variables = FND_API.G_TRUE THEN
2089: FOR cr IN var_doc_lst_crs LOOP
2090: x_sys_var_value_tbl(i).Variable_code := cr.variable_code;
2091: i := i+1;
2092: END LOOP;