eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.EGO_EXT_FWK_PUB dependencies on DBMS_SQL

Line 15843: v_cursor := DBMS_SQL.OPEN_CURSOR;

15839:
15840: -----------------------------------------
15841: -- Parse constructed SQL
15842: -----------------------------------------
15843: v_cursor := DBMS_SQL.OPEN_CURSOR;
15844: DBMS_SQL.PARSE(v_cursor, l_sql, DBMS_SQL.NATIVE);
15845:
15846:
15847: -----------------------------------------

Line 15844: DBMS_SQL.PARSE(v_cursor, l_sql, DBMS_SQL.NATIVE);

15840: -----------------------------------------
15841: -- Parse constructed SQL
15842: -----------------------------------------
15843: v_cursor := DBMS_SQL.OPEN_CURSOR;
15844: DBMS_SQL.PARSE(v_cursor, l_sql, DBMS_SQL.NATIVE);
15845:
15846:
15847: -----------------------------------------
15848: -- Bind Variable for the constructed SQL

Line 15880: DBMS_SQL.BIND_VARIABLE(v_cursor, ''||l_func_param_name, x_attributes_data_table(j).ATTR_VALUE_STR,32767);

15876: IF x_attributes_data_table(j).ATTR_NAME = l_attr_name THEN
15877: IF l_function_param_rec.PARAM_TYPE_CODE IN ('I', 'O', 'B') THEN
15878: --Check the data type for current attr/param
15879: IF l_function_param_rec.DATA_TYPE_CODE = 'V' THEN
15880: DBMS_SQL.BIND_VARIABLE(v_cursor, ''||l_func_param_name, x_attributes_data_table(j).ATTR_VALUE_STR,32767);
15881: code_debug ('EGO_EXT_FWK_PUB.Execute_Function - BIND--PARAM(varchar2): '||l_func_param_name||', VALUE: '||x_attributes_data_table(j).ATTR_VALUE_STR);
15882: ELSIF l_function_param_rec.DATA_TYPE_CODE = 'N' THEN
15883: DBMS_SQL.BIND_VARIABLE(v_cursor, ''||l_func_param_name, x_attributes_data_table(j).ATTR_VALUE_NUM);
15884: code_debug ('EGO_EXT_FWK_PUB.Execute_Function - BIND--PARAM(number): '||l_func_param_name||', VALUE: '||x_attributes_data_table(j).ATTR_VALUE_NUM);

Line 15883: DBMS_SQL.BIND_VARIABLE(v_cursor, ''||l_func_param_name, x_attributes_data_table(j).ATTR_VALUE_NUM);

15879: IF l_function_param_rec.DATA_TYPE_CODE = 'V' THEN
15880: DBMS_SQL.BIND_VARIABLE(v_cursor, ''||l_func_param_name, x_attributes_data_table(j).ATTR_VALUE_STR,32767);
15881: code_debug ('EGO_EXT_FWK_PUB.Execute_Function - BIND--PARAM(varchar2): '||l_func_param_name||', VALUE: '||x_attributes_data_table(j).ATTR_VALUE_STR);
15882: ELSIF l_function_param_rec.DATA_TYPE_CODE = 'N' THEN
15883: DBMS_SQL.BIND_VARIABLE(v_cursor, ''||l_func_param_name, x_attributes_data_table(j).ATTR_VALUE_NUM);
15884: code_debug ('EGO_EXT_FWK_PUB.Execute_Function - BIND--PARAM(number): '||l_func_param_name||', VALUE: '||x_attributes_data_table(j).ATTR_VALUE_NUM);
15885: ELSIF l_function_param_rec.DATA_TYPE_CODE = 'D' THEN
15886: DBMS_SQL.BIND_VARIABLE(v_cursor, ''||l_func_param_name, x_attributes_data_table(j).ATTR_VALUE_DATE);
15887: code_debug ('EGO_EXT_FWK_PUB.Execute_Function - BIND--PARAM(date): '||l_func_param_name||', VALUE: '||x_attributes_data_table(j).ATTR_VALUE_DATE);

Line 15886: DBMS_SQL.BIND_VARIABLE(v_cursor, ''||l_func_param_name, x_attributes_data_table(j).ATTR_VALUE_DATE);

15882: ELSIF l_function_param_rec.DATA_TYPE_CODE = 'N' THEN
15883: DBMS_SQL.BIND_VARIABLE(v_cursor, ''||l_func_param_name, x_attributes_data_table(j).ATTR_VALUE_NUM);
15884: code_debug ('EGO_EXT_FWK_PUB.Execute_Function - BIND--PARAM(number): '||l_func_param_name||', VALUE: '||x_attributes_data_table(j).ATTR_VALUE_NUM);
15885: ELSIF l_function_param_rec.DATA_TYPE_CODE = 'D' THEN
15886: DBMS_SQL.BIND_VARIABLE(v_cursor, ''||l_func_param_name, x_attributes_data_table(j).ATTR_VALUE_DATE);
15887: code_debug ('EGO_EXT_FWK_PUB.Execute_Function - BIND--PARAM(date): '||l_func_param_name||', VALUE: '||x_attributes_data_table(j).ATTR_VALUE_DATE);
15888: END IF;
15889:
15890: ELSIF l_function_param_rec.PARAM_TYPE_CODE = 'R' THEN

Line 15892: DBMS_SQL.BIND_VARIABLE(v_cursor, 'ret', x_attributes_data_table(j).ATTR_VALUE_STR, 32767);

15888: END IF;
15889:
15890: ELSIF l_function_param_rec.PARAM_TYPE_CODE = 'R' THEN
15891: IF l_function_param_rec.DATA_TYPE_CODE = 'V' THEN
15892: DBMS_SQL.BIND_VARIABLE(v_cursor, 'ret', x_attributes_data_table(j).ATTR_VALUE_STR, 32767);
15893: code_debug ('EGO_EXT_FWK_PUB.Execute_Function - BIND--return--PARAM(varchar2): '||l_func_param_name||', VALUE: '|| x_attributes_data_table(j).ATTR_VALUE_STR);
15894: ELSIF l_function_param_rec.DATA_TYPE_CODE = 'N' THEN
15895: DBMS_SQL.BIND_VARIABLE(v_cursor, 'ret', x_attributes_data_table(j).ATTR_VALUE_NUM);
15896: code_debug ('EGO_EXT_FWK_PUB.Execute_Function - BIND--return--PARAM(number): '||l_func_param_name||', VALUE: '||x_attributes_data_table(j).ATTR_VALUE_NUM);

Line 15895: DBMS_SQL.BIND_VARIABLE(v_cursor, 'ret', x_attributes_data_table(j).ATTR_VALUE_NUM);

15891: IF l_function_param_rec.DATA_TYPE_CODE = 'V' THEN
15892: DBMS_SQL.BIND_VARIABLE(v_cursor, 'ret', x_attributes_data_table(j).ATTR_VALUE_STR, 32767);
15893: code_debug ('EGO_EXT_FWK_PUB.Execute_Function - BIND--return--PARAM(varchar2): '||l_func_param_name||', VALUE: '|| x_attributes_data_table(j).ATTR_VALUE_STR);
15894: ELSIF l_function_param_rec.DATA_TYPE_CODE = 'N' THEN
15895: DBMS_SQL.BIND_VARIABLE(v_cursor, 'ret', x_attributes_data_table(j).ATTR_VALUE_NUM);
15896: code_debug ('EGO_EXT_FWK_PUB.Execute_Function - BIND--return--PARAM(number): '||l_func_param_name||', VALUE: '||x_attributes_data_table(j).ATTR_VALUE_NUM);
15897: ELSIF l_function_param_rec.DATA_TYPE_CODE = 'D' THEN
15898: DBMS_SQL.BIND_VARIABLE(v_cursor, 'ret', x_attributes_data_table(j).ATTR_VALUE_DATE);
15899: code_debug ('EGO_EXT_FWK_PUB.Execute_Function - BIND--return--PARAM(date): '||l_func_param_name||', VALUE: '||x_attributes_data_table(j).ATTR_VALUE_DATE);

Line 15898: DBMS_SQL.BIND_VARIABLE(v_cursor, 'ret', x_attributes_data_table(j).ATTR_VALUE_DATE);

15894: ELSIF l_function_param_rec.DATA_TYPE_CODE = 'N' THEN
15895: DBMS_SQL.BIND_VARIABLE(v_cursor, 'ret', x_attributes_data_table(j).ATTR_VALUE_NUM);
15896: code_debug ('EGO_EXT_FWK_PUB.Execute_Function - BIND--return--PARAM(number): '||l_func_param_name||', VALUE: '||x_attributes_data_table(j).ATTR_VALUE_NUM);
15897: ELSIF l_function_param_rec.DATA_TYPE_CODE = 'D' THEN
15898: DBMS_SQL.BIND_VARIABLE(v_cursor, 'ret', x_attributes_data_table(j).ATTR_VALUE_DATE);
15899: code_debug ('EGO_EXT_FWK_PUB.Execute_Function - BIND--return--PARAM(date): '||l_func_param_name||', VALUE: '||x_attributes_data_table(j).ATTR_VALUE_DATE);
15900: END IF;
15901: END IF;
15902: --Found value for current paramenter, so exit loop

Line 15918: DBMS_SQL.BIND_VARIABLE(v_cursor, ''||l_func_param_name, x_external_attrs_value_pairs(j).VALUE,32767);

15914: IF x_external_attrs_value_pairs(j).NAME = l_attr_name THEN
15915: IF l_function_param_rec.PARAM_TYPE_CODE IN ('I', 'O', 'B') THEN
15916: --Check the data type for current attr/param
15917: IF l_function_param_rec.DATA_TYPE_CODE = 'V' THEN
15918: DBMS_SQL.BIND_VARIABLE(v_cursor, ''||l_func_param_name, x_external_attrs_value_pairs(j).VALUE,32767);
15919: code_debug ('EGO_EXT_FWK_PUB.Execute_Function - BIND--PARAM(varchar2): '||l_func_param_name||', VALUE: '||x_external_attrs_value_pairs(j).VALUE);
15920: ELSIF l_function_param_rec.DATA_TYPE_CODE = 'N' THEN
15921: DBMS_SQL.BIND_VARIABLE(v_cursor, ''||l_func_param_name, x_external_attrs_value_pairs(j).VALUE);
15922: code_debug ('EGO_EXT_FWK_PUB.Execute_Function - BIND--PARAM(number): '||l_func_param_name||', VALUE: '||x_external_attrs_value_pairs(j).VALUE);

Line 15921: DBMS_SQL.BIND_VARIABLE(v_cursor, ''||l_func_param_name, x_external_attrs_value_pairs(j).VALUE);

15917: IF l_function_param_rec.DATA_TYPE_CODE = 'V' THEN
15918: DBMS_SQL.BIND_VARIABLE(v_cursor, ''||l_func_param_name, x_external_attrs_value_pairs(j).VALUE,32767);
15919: code_debug ('EGO_EXT_FWK_PUB.Execute_Function - BIND--PARAM(varchar2): '||l_func_param_name||', VALUE: '||x_external_attrs_value_pairs(j).VALUE);
15920: ELSIF l_function_param_rec.DATA_TYPE_CODE = 'N' THEN
15921: DBMS_SQL.BIND_VARIABLE(v_cursor, ''||l_func_param_name, x_external_attrs_value_pairs(j).VALUE);
15922: code_debug ('EGO_EXT_FWK_PUB.Execute_Function - BIND--PARAM(number): '||l_func_param_name||', VALUE: '||x_external_attrs_value_pairs(j).VALUE);
15923: ELSIF l_function_param_rec.DATA_TYPE_CODE = 'D' THEN
15924: DBMS_SQL.BIND_VARIABLE(v_cursor, ''||l_func_param_name, x_external_attrs_value_pairs(j).VALUE);
15925: code_debug ('EGO_EXT_FWK_PUB.Execute_Function - BIND--PARAM(date): '||l_func_param_name||', VALUE: '||x_external_attrs_value_pairs(j).VALUE);

Line 15924: DBMS_SQL.BIND_VARIABLE(v_cursor, ''||l_func_param_name, x_external_attrs_value_pairs(j).VALUE);

15920: ELSIF l_function_param_rec.DATA_TYPE_CODE = 'N' THEN
15921: DBMS_SQL.BIND_VARIABLE(v_cursor, ''||l_func_param_name, x_external_attrs_value_pairs(j).VALUE);
15922: code_debug ('EGO_EXT_FWK_PUB.Execute_Function - BIND--PARAM(number): '||l_func_param_name||', VALUE: '||x_external_attrs_value_pairs(j).VALUE);
15923: ELSIF l_function_param_rec.DATA_TYPE_CODE = 'D' THEN
15924: DBMS_SQL.BIND_VARIABLE(v_cursor, ''||l_func_param_name, x_external_attrs_value_pairs(j).VALUE);
15925: code_debug ('EGO_EXT_FWK_PUB.Execute_Function - BIND--PARAM(date): '||l_func_param_name||', VALUE: '||x_external_attrs_value_pairs(j).VALUE);
15926: END IF;
15927:
15928: ELSIF l_function_param_rec.PARAM_TYPE_CODE = 'R' THEN

Line 15930: DBMS_SQL.BIND_VARIABLE(v_cursor, 'ret', x_external_attrs_value_pairs(j).VALUE, 32767);

15926: END IF;
15927:
15928: ELSIF l_function_param_rec.PARAM_TYPE_CODE = 'R' THEN
15929: IF l_function_param_rec.DATA_TYPE_CODE = 'V' THEN
15930: DBMS_SQL.BIND_VARIABLE(v_cursor, 'ret', x_external_attrs_value_pairs(j).VALUE, 32767);
15931: code_debug ('EGO_EXT_FWK_PUB.Execute_Function - BIND--return--PARAM(varchar2): '||l_func_param_name||', VALUE: '|| x_external_attrs_value_pairs(j).VALUE);
15932: ELSIF l_function_param_rec.DATA_TYPE_CODE = 'N' THEN
15933: DBMS_SQL.BIND_VARIABLE(v_cursor, 'ret', x_external_attrs_value_pairs(j).VALUE);
15934: code_debug ('EGO_EXT_FWK_PUB.Execute_Function - BIND--return--PARAM(number): '||l_func_param_name||', VALUE: '||x_external_attrs_value_pairs(j).VALUE);

Line 15933: DBMS_SQL.BIND_VARIABLE(v_cursor, 'ret', x_external_attrs_value_pairs(j).VALUE);

15929: IF l_function_param_rec.DATA_TYPE_CODE = 'V' THEN
15930: DBMS_SQL.BIND_VARIABLE(v_cursor, 'ret', x_external_attrs_value_pairs(j).VALUE, 32767);
15931: code_debug ('EGO_EXT_FWK_PUB.Execute_Function - BIND--return--PARAM(varchar2): '||l_func_param_name||', VALUE: '|| x_external_attrs_value_pairs(j).VALUE);
15932: ELSIF l_function_param_rec.DATA_TYPE_CODE = 'N' THEN
15933: DBMS_SQL.BIND_VARIABLE(v_cursor, 'ret', x_external_attrs_value_pairs(j).VALUE);
15934: code_debug ('EGO_EXT_FWK_PUB.Execute_Function - BIND--return--PARAM(number): '||l_func_param_name||', VALUE: '||x_external_attrs_value_pairs(j).VALUE);
15935: ELSIF l_function_param_rec.DATA_TYPE_CODE = 'D' THEN
15936: DBMS_SQL.BIND_VARIABLE(v_cursor, 'ret', x_external_attrs_value_pairs(j).VALUE);
15937: code_debug ('EGO_EXT_FWK_PUB.Execute_Function - BIND--return--PARAM(date): '||l_func_param_name||', VALUE: '||x_external_attrs_value_pairs(j).VALUE);

Line 15936: DBMS_SQL.BIND_VARIABLE(v_cursor, 'ret', x_external_attrs_value_pairs(j).VALUE);

15932: ELSIF l_function_param_rec.DATA_TYPE_CODE = 'N' THEN
15933: DBMS_SQL.BIND_VARIABLE(v_cursor, 'ret', x_external_attrs_value_pairs(j).VALUE);
15934: code_debug ('EGO_EXT_FWK_PUB.Execute_Function - BIND--return--PARAM(number): '||l_func_param_name||', VALUE: '||x_external_attrs_value_pairs(j).VALUE);
15935: ELSIF l_function_param_rec.DATA_TYPE_CODE = 'D' THEN
15936: DBMS_SQL.BIND_VARIABLE(v_cursor, 'ret', x_external_attrs_value_pairs(j).VALUE);
15937: code_debug ('EGO_EXT_FWK_PUB.Execute_Function - BIND--return--PARAM(date): '||l_func_param_name||', VALUE: '||x_external_attrs_value_pairs(j).VALUE);
15938: END IF;
15939: END IF;
15940: --Found value for current paramenter, so exit loop

Line 15955: DBMS_SQL.BIND_VARIABLE(v_cursor, ''||l_func_param_name, p_pk_col_value_pairs(j).VALUE,32767);

15951: IF p_pk_col_value_pairs(j).NAME = l_attr_name THEN
15952: IF l_function_param_rec.PARAM_TYPE_CODE IN ('I', 'O', 'B') THEN
15953: --Check the data type for current attr/param
15954: IF l_function_param_rec.DATA_TYPE_CODE = 'V' THEN
15955: DBMS_SQL.BIND_VARIABLE(v_cursor, ''||l_func_param_name, p_pk_col_value_pairs(j).VALUE,32767);
15956: code_debug ('EGO_EXT_FWK_PUB.Execute_Function - BIND--PARAM(varchar2): '||l_func_param_name||', VALUE: '||p_pk_col_value_pairs(j).VALUE);
15957: ELSIF l_function_param_rec.DATA_TYPE_CODE = 'N' THEN
15958: DBMS_SQL.BIND_VARIABLE(v_cursor, ''||l_func_param_name, p_pk_col_value_pairs(j).VALUE);
15959: code_debug ('EGO_EXT_FWK_PUB.Execute_Function - BIND--PARAM(number): '||l_func_param_name||', VALUE: '||p_pk_col_value_pairs(j).VALUE);

Line 15958: DBMS_SQL.BIND_VARIABLE(v_cursor, ''||l_func_param_name, p_pk_col_value_pairs(j).VALUE);

15954: IF l_function_param_rec.DATA_TYPE_CODE = 'V' THEN
15955: DBMS_SQL.BIND_VARIABLE(v_cursor, ''||l_func_param_name, p_pk_col_value_pairs(j).VALUE,32767);
15956: code_debug ('EGO_EXT_FWK_PUB.Execute_Function - BIND--PARAM(varchar2): '||l_func_param_name||', VALUE: '||p_pk_col_value_pairs(j).VALUE);
15957: ELSIF l_function_param_rec.DATA_TYPE_CODE = 'N' THEN
15958: DBMS_SQL.BIND_VARIABLE(v_cursor, ''||l_func_param_name, p_pk_col_value_pairs(j).VALUE);
15959: code_debug ('EGO_EXT_FWK_PUB.Execute_Function - BIND--PARAM(number): '||l_func_param_name||', VALUE: '||p_pk_col_value_pairs(j).VALUE);
15960: ELSIF l_function_param_rec.DATA_TYPE_CODE = 'D' THEN
15961: DBMS_SQL.BIND_VARIABLE(v_cursor, ''||l_func_param_name, p_pk_col_value_pairs(j).VALUE);
15962: code_debug ('EGO_EXT_FWK_PUB.Execute_Function - BIND--PARAM(date): '||l_func_param_name||', VALUE: '||p_pk_col_value_pairs(j).VALUE);

Line 15961: DBMS_SQL.BIND_VARIABLE(v_cursor, ''||l_func_param_name, p_pk_col_value_pairs(j).VALUE);

15957: ELSIF l_function_param_rec.DATA_TYPE_CODE = 'N' THEN
15958: DBMS_SQL.BIND_VARIABLE(v_cursor, ''||l_func_param_name, p_pk_col_value_pairs(j).VALUE);
15959: code_debug ('EGO_EXT_FWK_PUB.Execute_Function - BIND--PARAM(number): '||l_func_param_name||', VALUE: '||p_pk_col_value_pairs(j).VALUE);
15960: ELSIF l_function_param_rec.DATA_TYPE_CODE = 'D' THEN
15961: DBMS_SQL.BIND_VARIABLE(v_cursor, ''||l_func_param_name, p_pk_col_value_pairs(j).VALUE);
15962: code_debug ('EGO_EXT_FWK_PUB.Execute_Function - BIND--PARAM(date): '||l_func_param_name||', VALUE: '||p_pk_col_value_pairs(j).VALUE);
15963: END IF;
15964:
15965: ELSIF l_function_param_rec.PARAM_TYPE_CODE = 'R' THEN

Line 15967: DBMS_SQL.BIND_VARIABLE(v_cursor, 'ret', p_pk_col_value_pairs(j).VALUE, 32767);

15963: END IF;
15964:
15965: ELSIF l_function_param_rec.PARAM_TYPE_CODE = 'R' THEN
15966: IF l_function_param_rec.DATA_TYPE_CODE = 'V' THEN
15967: DBMS_SQL.BIND_VARIABLE(v_cursor, 'ret', p_pk_col_value_pairs(j).VALUE, 32767);
15968: code_debug ('EGO_EXT_FWK_PUB.Execute_Function - BIND--return--PARAM(varchar2): '||l_func_param_name||', VALUE: '|| p_pk_col_value_pairs(j).VALUE);
15969: ELSIF l_function_param_rec.DATA_TYPE_CODE = 'N' THEN
15970: DBMS_SQL.BIND_VARIABLE(v_cursor, 'ret', p_pk_col_value_pairs(j).VALUE);
15971: code_debug ('EGO_EXT_FWK_PUB.Execute_Function - BIND--return--PARAM(number): '||l_func_param_name||', VALUE: '||p_pk_col_value_pairs(j).VALUE);

Line 15970: DBMS_SQL.BIND_VARIABLE(v_cursor, 'ret', p_pk_col_value_pairs(j).VALUE);

15966: IF l_function_param_rec.DATA_TYPE_CODE = 'V' THEN
15967: DBMS_SQL.BIND_VARIABLE(v_cursor, 'ret', p_pk_col_value_pairs(j).VALUE, 32767);
15968: code_debug ('EGO_EXT_FWK_PUB.Execute_Function - BIND--return--PARAM(varchar2): '||l_func_param_name||', VALUE: '|| p_pk_col_value_pairs(j).VALUE);
15969: ELSIF l_function_param_rec.DATA_TYPE_CODE = 'N' THEN
15970: DBMS_SQL.BIND_VARIABLE(v_cursor, 'ret', p_pk_col_value_pairs(j).VALUE);
15971: code_debug ('EGO_EXT_FWK_PUB.Execute_Function - BIND--return--PARAM(number): '||l_func_param_name||', VALUE: '||p_pk_col_value_pairs(j).VALUE);
15972: ELSIF l_function_param_rec.DATA_TYPE_CODE = 'D' THEN
15973: DBMS_SQL.BIND_VARIABLE(v_cursor, 'ret', p_pk_col_value_pairs(j).VALUE);
15974: code_debug ('EGO_EXT_FWK_PUB.Execute_Function - BIND--return--PARAM(date): '||l_func_param_name||', VALUE: '||p_pk_col_value_pairs(j).VALUE);

Line 15973: DBMS_SQL.BIND_VARIABLE(v_cursor, 'ret', p_pk_col_value_pairs(j).VALUE);

15969: ELSIF l_function_param_rec.DATA_TYPE_CODE = 'N' THEN
15970: DBMS_SQL.BIND_VARIABLE(v_cursor, 'ret', p_pk_col_value_pairs(j).VALUE);
15971: code_debug ('EGO_EXT_FWK_PUB.Execute_Function - BIND--return--PARAM(number): '||l_func_param_name||', VALUE: '||p_pk_col_value_pairs(j).VALUE);
15972: ELSIF l_function_param_rec.DATA_TYPE_CODE = 'D' THEN
15973: DBMS_SQL.BIND_VARIABLE(v_cursor, 'ret', p_pk_col_value_pairs(j).VALUE);
15974: code_debug ('EGO_EXT_FWK_PUB.Execute_Function - BIND--return--PARAM(date): '||l_func_param_name||', VALUE: '||p_pk_col_value_pairs(j).VALUE);
15975: END IF;
15976: END IF;
15977: --Found value for current paramenter, so exit loop

Line 15991: DBMS_SQL.BIND_VARIABLE(v_cursor, ''||l_func_param_name, p_dtlevel_col_value_pairs(j).VALUE,32767);

15987: IF p_dtlevel_col_value_pairs(j).NAME = l_attr_name THEN
15988: IF l_function_param_rec.PARAM_TYPE_CODE IN ('I', 'O', 'B') THEN
15989: --Check the data type for current attr/param
15990: IF l_function_param_rec.DATA_TYPE_CODE = 'V' THEN
15991: DBMS_SQL.BIND_VARIABLE(v_cursor, ''||l_func_param_name, p_dtlevel_col_value_pairs(j).VALUE,32767);
15992: code_debug ('EGO_EXT_FWK_PUB.Execute_Function - BIND--PARAM(varchar2): '||l_func_param_name||', VALUE: '||p_dtlevel_col_value_pairs(j).VALUE);
15993: ELSIF l_function_param_rec.DATA_TYPE_CODE = 'N' THEN
15994: DBMS_SQL.BIND_VARIABLE(v_cursor, ''||l_func_param_name, p_dtlevel_col_value_pairs(j).VALUE);
15995: code_debug ('EGO_EXT_FWK_PUB.Execute_Function - BIND--PARAM(number): '||l_func_param_name||', VALUE: '||p_dtlevel_col_value_pairs(j).VALUE);

Line 15994: DBMS_SQL.BIND_VARIABLE(v_cursor, ''||l_func_param_name, p_dtlevel_col_value_pairs(j).VALUE);

15990: IF l_function_param_rec.DATA_TYPE_CODE = 'V' THEN
15991: DBMS_SQL.BIND_VARIABLE(v_cursor, ''||l_func_param_name, p_dtlevel_col_value_pairs(j).VALUE,32767);
15992: code_debug ('EGO_EXT_FWK_PUB.Execute_Function - BIND--PARAM(varchar2): '||l_func_param_name||', VALUE: '||p_dtlevel_col_value_pairs(j).VALUE);
15993: ELSIF l_function_param_rec.DATA_TYPE_CODE = 'N' THEN
15994: DBMS_SQL.BIND_VARIABLE(v_cursor, ''||l_func_param_name, p_dtlevel_col_value_pairs(j).VALUE);
15995: code_debug ('EGO_EXT_FWK_PUB.Execute_Function - BIND--PARAM(number): '||l_func_param_name||', VALUE: '||p_dtlevel_col_value_pairs(j).VALUE);
15996: ELSIF l_function_param_rec.DATA_TYPE_CODE = 'D' THEN
15997: DBMS_SQL.BIND_VARIABLE(v_cursor, ''||l_func_param_name, p_dtlevel_col_value_pairs(j).VALUE);
15998: code_debug ('EGO_EXT_FWK_PUB.Execute_Function - BIND--PARAM(date): '||l_func_param_name||', VALUE: '||p_dtlevel_col_value_pairs(j).VALUE);

Line 15997: DBMS_SQL.BIND_VARIABLE(v_cursor, ''||l_func_param_name, p_dtlevel_col_value_pairs(j).VALUE);

15993: ELSIF l_function_param_rec.DATA_TYPE_CODE = 'N' THEN
15994: DBMS_SQL.BIND_VARIABLE(v_cursor, ''||l_func_param_name, p_dtlevel_col_value_pairs(j).VALUE);
15995: code_debug ('EGO_EXT_FWK_PUB.Execute_Function - BIND--PARAM(number): '||l_func_param_name||', VALUE: '||p_dtlevel_col_value_pairs(j).VALUE);
15996: ELSIF l_function_param_rec.DATA_TYPE_CODE = 'D' THEN
15997: DBMS_SQL.BIND_VARIABLE(v_cursor, ''||l_func_param_name, p_dtlevel_col_value_pairs(j).VALUE);
15998: code_debug ('EGO_EXT_FWK_PUB.Execute_Function - BIND--PARAM(date): '||l_func_param_name||', VALUE: '||p_dtlevel_col_value_pairs(j).VALUE);
15999: END IF;
16000:
16001: ELSIF l_function_param_rec.PARAM_TYPE_CODE = 'R' THEN

Line 16003: DBMS_SQL.BIND_VARIABLE(v_cursor, 'ret', p_dtlevel_col_value_pairs(j).VALUE, 32767);

15999: END IF;
16000:
16001: ELSIF l_function_param_rec.PARAM_TYPE_CODE = 'R' THEN
16002: IF l_function_param_rec.DATA_TYPE_CODE = 'V' THEN
16003: DBMS_SQL.BIND_VARIABLE(v_cursor, 'ret', p_dtlevel_col_value_pairs(j).VALUE, 32767);
16004: code_debug ('BIND--return--PARAM(varchar2): '||l_func_param_name||', VALUE: '|| p_dtlevel_col_value_pairs(j).VALUE);
16005: ELSIF l_function_param_rec.DATA_TYPE_CODE = 'N' THEN
16006: DBMS_SQL.BIND_VARIABLE(v_cursor, 'ret', p_dtlevel_col_value_pairs(j).VALUE);
16007: code_debug ('BIND--return--PARAM(number): '||l_func_param_name||', VALUE: '||p_dtlevel_col_value_pairs(j).VALUE);

Line 16006: DBMS_SQL.BIND_VARIABLE(v_cursor, 'ret', p_dtlevel_col_value_pairs(j).VALUE);

16002: IF l_function_param_rec.DATA_TYPE_CODE = 'V' THEN
16003: DBMS_SQL.BIND_VARIABLE(v_cursor, 'ret', p_dtlevel_col_value_pairs(j).VALUE, 32767);
16004: code_debug ('BIND--return--PARAM(varchar2): '||l_func_param_name||', VALUE: '|| p_dtlevel_col_value_pairs(j).VALUE);
16005: ELSIF l_function_param_rec.DATA_TYPE_CODE = 'N' THEN
16006: DBMS_SQL.BIND_VARIABLE(v_cursor, 'ret', p_dtlevel_col_value_pairs(j).VALUE);
16007: code_debug ('BIND--return--PARAM(number): '||l_func_param_name||', VALUE: '||p_dtlevel_col_value_pairs(j).VALUE);
16008: ELSIF l_function_param_rec.DATA_TYPE_CODE = 'D' THEN
16009: DBMS_SQL.BIND_VARIABLE(v_cursor, 'ret', p_dtlevel_col_value_pairs(j).VALUE);
16010: code_debug ('BIND--return--PARAM(date): '||l_func_param_name||', VALUE: '||p_dtlevel_col_value_pairs(j).VALUE);

Line 16009: DBMS_SQL.BIND_VARIABLE(v_cursor, 'ret', p_dtlevel_col_value_pairs(j).VALUE);

16005: ELSIF l_function_param_rec.DATA_TYPE_CODE = 'N' THEN
16006: DBMS_SQL.BIND_VARIABLE(v_cursor, 'ret', p_dtlevel_col_value_pairs(j).VALUE);
16007: code_debug ('BIND--return--PARAM(number): '||l_func_param_name||', VALUE: '||p_dtlevel_col_value_pairs(j).VALUE);
16008: ELSIF l_function_param_rec.DATA_TYPE_CODE = 'D' THEN
16009: DBMS_SQL.BIND_VARIABLE(v_cursor, 'ret', p_dtlevel_col_value_pairs(j).VALUE);
16010: code_debug ('BIND--return--PARAM(date): '||l_func_param_name||', VALUE: '||p_dtlevel_col_value_pairs(j).VALUE);
16011: END IF;
16012: END IF;
16013: --Found value for current paramenter, so exit loop

Line 16025: DBMS_SQL.BIND_VARIABLE(v_cursor, ':'||l_func_param_name, l_null_c);

16021: IF NOT l_boolean THEN
16022: --ONLY bind null value for type "A"&"INPUT" params.
16023: IF l_function_param_rec.PARAM_TYPE_CODE = 'I' AND l_function_param_rec.MAPPED_TO_GROUP_TYPE = 'A' THEN
16024: IF l_function_param_rec.DATA_TYPE_CODE = 'V' THEN
16025: DBMS_SQL.BIND_VARIABLE(v_cursor, ':'||l_func_param_name, l_null_c);
16026: ELSIF l_function_param_rec.DATA_TYPE_CODE = 'N' THEN
16027: DBMS_SQL.BIND_VARIABLE(v_cursor, ':'||l_func_param_name, l_null_n);
16028: ELSIF l_function_param_rec.DATA_TYPE_CODE = 'D' THEN
16029: DBMS_SQL.BIND_VARIABLE(v_cursor, ':'||l_func_param_name, l_null_d);

Line 16027: DBMS_SQL.BIND_VARIABLE(v_cursor, ':'||l_func_param_name, l_null_n);

16023: IF l_function_param_rec.PARAM_TYPE_CODE = 'I' AND l_function_param_rec.MAPPED_TO_GROUP_TYPE = 'A' THEN
16024: IF l_function_param_rec.DATA_TYPE_CODE = 'V' THEN
16025: DBMS_SQL.BIND_VARIABLE(v_cursor, ':'||l_func_param_name, l_null_c);
16026: ELSIF l_function_param_rec.DATA_TYPE_CODE = 'N' THEN
16027: DBMS_SQL.BIND_VARIABLE(v_cursor, ':'||l_func_param_name, l_null_n);
16028: ELSIF l_function_param_rec.DATA_TYPE_CODE = 'D' THEN
16029: DBMS_SQL.BIND_VARIABLE(v_cursor, ':'||l_func_param_name, l_null_d);
16030: END IF;
16031: code_debug ('EGO_EXT_FWK_PUB.Execute_Function - BIND NULL VALUE FOR PARAM: ' || l_func_param_name);

Line 16029: DBMS_SQL.BIND_VARIABLE(v_cursor, ':'||l_func_param_name, l_null_d);

16025: DBMS_SQL.BIND_VARIABLE(v_cursor, ':'||l_func_param_name, l_null_c);
16026: ELSIF l_function_param_rec.DATA_TYPE_CODE = 'N' THEN
16027: DBMS_SQL.BIND_VARIABLE(v_cursor, ':'||l_func_param_name, l_null_n);
16028: ELSIF l_function_param_rec.DATA_TYPE_CODE = 'D' THEN
16029: DBMS_SQL.BIND_VARIABLE(v_cursor, ':'||l_func_param_name, l_null_d);
16030: END IF;
16031: code_debug ('EGO_EXT_FWK_PUB.Execute_Function - BIND NULL VALUE FOR PARAM: ' || l_func_param_name);
16032: ELSE
16033: RAISE no_data_found_for_param_bind;

Line 16041: -- Execute the Dynamic SQL using DBMS_SQL

16037:
16038: --code_debug ('EGO_EXT_FWK_PUB.Execute_Function - CHECK POINT 1');
16039:
16040: -----------------------------------------
16041: -- Execute the Dynamic SQL using DBMS_SQL
16042: -----------------------------------------
16043: l_dummy := DBMS_SQL.EXECUTE(v_cursor);
16044: --code_debug ('EGO_EXT_FWK_PUB.Execute_Function - CHECK POINT 2, l_dummy:' || l_dummy);
16045:

Line 16043: l_dummy := DBMS_SQL.EXECUTE(v_cursor);

16039:
16040: -----------------------------------------
16041: -- Execute the Dynamic SQL using DBMS_SQL
16042: -----------------------------------------
16043: l_dummy := DBMS_SQL.EXECUTE(v_cursor);
16044: --code_debug ('EGO_EXT_FWK_PUB.Execute_Function - CHECK POINT 2, l_dummy:' || l_dummy);
16045:
16046: -----------------------------------------
16047: -- Retrieve the value of OUTPUT parameter

Line 16069: DBMS_SQL.VARIABLE_VALUE(v_cursor, ''||l_func_param_name, x_attributes_data_table(j).ATTR_VALUE_STR);

16065: --For OUTPUT, INPUT/OUTPUT, RETURN parameters
16066: IF l_function_param_table(i).PARAM_TYPE_CODE IN ('O', 'B') THEN
16067: --code_debug ('EGO_EXT_FWK_PUB.Execute_Function - CHECK POINT 3');
16068: IF l_function_param_rec.DATA_TYPE_CODE = 'V' THEN
16069: DBMS_SQL.VARIABLE_VALUE(v_cursor, ''||l_func_param_name, x_attributes_data_table(j).ATTR_VALUE_STR);
16070: ELSIF l_function_param_rec.DATA_TYPE_CODE = 'N' THEN
16071: DBMS_SQL.VARIABLE_VALUE(v_cursor, ''||l_func_param_name, x_attributes_data_table(j).ATTR_VALUE_NUM);
16072: ELSIF l_function_param_rec.DATA_TYPE_CODE = 'D' THEN
16073: DBMS_SQL.VARIABLE_VALUE(v_cursor, ''||l_func_param_name, x_attributes_data_table(j).ATTR_VALUE_DATE);

Line 16071: DBMS_SQL.VARIABLE_VALUE(v_cursor, ''||l_func_param_name, x_attributes_data_table(j).ATTR_VALUE_NUM);

16067: --code_debug ('EGO_EXT_FWK_PUB.Execute_Function - CHECK POINT 3');
16068: IF l_function_param_rec.DATA_TYPE_CODE = 'V' THEN
16069: DBMS_SQL.VARIABLE_VALUE(v_cursor, ''||l_func_param_name, x_attributes_data_table(j).ATTR_VALUE_STR);
16070: ELSIF l_function_param_rec.DATA_TYPE_CODE = 'N' THEN
16071: DBMS_SQL.VARIABLE_VALUE(v_cursor, ''||l_func_param_name, x_attributes_data_table(j).ATTR_VALUE_NUM);
16072: ELSIF l_function_param_rec.DATA_TYPE_CODE = 'D' THEN
16073: DBMS_SQL.VARIABLE_VALUE(v_cursor, ''||l_func_param_name, x_attributes_data_table(j).ATTR_VALUE_DATE);
16074: END IF;
16075: ELSIF l_function_param_table(i).PARAM_TYPE_CODE = 'R' THEN

Line 16073: DBMS_SQL.VARIABLE_VALUE(v_cursor, ''||l_func_param_name, x_attributes_data_table(j).ATTR_VALUE_DATE);

16069: DBMS_SQL.VARIABLE_VALUE(v_cursor, ''||l_func_param_name, x_attributes_data_table(j).ATTR_VALUE_STR);
16070: ELSIF l_function_param_rec.DATA_TYPE_CODE = 'N' THEN
16071: DBMS_SQL.VARIABLE_VALUE(v_cursor, ''||l_func_param_name, x_attributes_data_table(j).ATTR_VALUE_NUM);
16072: ELSIF l_function_param_rec.DATA_TYPE_CODE = 'D' THEN
16073: DBMS_SQL.VARIABLE_VALUE(v_cursor, ''||l_func_param_name, x_attributes_data_table(j).ATTR_VALUE_DATE);
16074: END IF;
16075: ELSIF l_function_param_table(i).PARAM_TYPE_CODE = 'R' THEN
16076: IF l_function_param_rec.DATA_TYPE_CODE = 'V' THEN
16077: DBMS_SQL.VARIABLE_VALUE(v_cursor, 'ret', x_attributes_data_table(j).ATTR_VALUE_STR);

Line 16077: DBMS_SQL.VARIABLE_VALUE(v_cursor, 'ret', x_attributes_data_table(j).ATTR_VALUE_STR);

16073: DBMS_SQL.VARIABLE_VALUE(v_cursor, ''||l_func_param_name, x_attributes_data_table(j).ATTR_VALUE_DATE);
16074: END IF;
16075: ELSIF l_function_param_table(i).PARAM_TYPE_CODE = 'R' THEN
16076: IF l_function_param_rec.DATA_TYPE_CODE = 'V' THEN
16077: DBMS_SQL.VARIABLE_VALUE(v_cursor, 'ret', x_attributes_data_table(j).ATTR_VALUE_STR);
16078: ELSIF l_function_param_rec.DATA_TYPE_CODE = 'N' THEN
16079: DBMS_SQL.VARIABLE_VALUE(v_cursor, 'ret', x_attributes_data_table(j).ATTR_VALUE_NUM);
16080: ELSIF l_function_param_rec.DATA_TYPE_CODE = 'D' THEN
16081: DBMS_SQL.VARIABLE_VALUE(v_cursor, 'ret', x_attributes_data_table(j).ATTR_VALUE_DATE);

Line 16079: DBMS_SQL.VARIABLE_VALUE(v_cursor, 'ret', x_attributes_data_table(j).ATTR_VALUE_NUM);

16075: ELSIF l_function_param_table(i).PARAM_TYPE_CODE = 'R' THEN
16076: IF l_function_param_rec.DATA_TYPE_CODE = 'V' THEN
16077: DBMS_SQL.VARIABLE_VALUE(v_cursor, 'ret', x_attributes_data_table(j).ATTR_VALUE_STR);
16078: ELSIF l_function_param_rec.DATA_TYPE_CODE = 'N' THEN
16079: DBMS_SQL.VARIABLE_VALUE(v_cursor, 'ret', x_attributes_data_table(j).ATTR_VALUE_NUM);
16080: ELSIF l_function_param_rec.DATA_TYPE_CODE = 'D' THEN
16081: DBMS_SQL.VARIABLE_VALUE(v_cursor, 'ret', x_attributes_data_table(j).ATTR_VALUE_DATE);
16082: END IF;
16083: END IF;

Line 16081: DBMS_SQL.VARIABLE_VALUE(v_cursor, 'ret', x_attributes_data_table(j).ATTR_VALUE_DATE);

16077: DBMS_SQL.VARIABLE_VALUE(v_cursor, 'ret', x_attributes_data_table(j).ATTR_VALUE_STR);
16078: ELSIF l_function_param_rec.DATA_TYPE_CODE = 'N' THEN
16079: DBMS_SQL.VARIABLE_VALUE(v_cursor, 'ret', x_attributes_data_table(j).ATTR_VALUE_NUM);
16080: ELSIF l_function_param_rec.DATA_TYPE_CODE = 'D' THEN
16081: DBMS_SQL.VARIABLE_VALUE(v_cursor, 'ret', x_attributes_data_table(j).ATTR_VALUE_DATE);
16082: END IF;
16083: END IF;
16084: EXIT;
16085:

Line 16095: DBMS_SQL.VARIABLE_VALUE(v_cursor, ''||l_func_param_name, x_external_attrs_value_pairs(j).VALUE);

16091: LOOP
16092: IF x_external_attrs_value_pairs(j).NAME = l_attr_name THEN
16093: --For OUTPUT, INPUT/OUTPUT, RETURN parameters
16094: IF l_function_param_table(i).PARAM_TYPE_CODE IN ('O', 'B') THEN
16095: DBMS_SQL.VARIABLE_VALUE(v_cursor, ''||l_func_param_name, x_external_attrs_value_pairs(j).VALUE);
16096: ELSIF l_function_param_table(i).PARAM_TYPE_CODE = 'R' THEN
16097: DBMS_SQL.VARIABLE_VALUE(v_cursor, 'ret', x_external_attrs_value_pairs(j).VALUE);
16098: END IF;
16099: EXIT;

Line 16097: DBMS_SQL.VARIABLE_VALUE(v_cursor, 'ret', x_external_attrs_value_pairs(j).VALUE);

16093: --For OUTPUT, INPUT/OUTPUT, RETURN parameters
16094: IF l_function_param_table(i).PARAM_TYPE_CODE IN ('O', 'B') THEN
16095: DBMS_SQL.VARIABLE_VALUE(v_cursor, ''||l_func_param_name, x_external_attrs_value_pairs(j).VALUE);
16096: ELSIF l_function_param_table(i).PARAM_TYPE_CODE = 'R' THEN
16097: DBMS_SQL.VARIABLE_VALUE(v_cursor, 'ret', x_external_attrs_value_pairs(j).VALUE);
16098: END IF;
16099: EXIT;
16100: END IF;
16101: END LOOP;--x_external_attrs_value_pairs

Line 16107: DBMS_SQL.CLOSE_CURSOR(v_cursor);

16103: --ONLY MAPPED_TO_AG_TYPE A and E can be used as OUTPUT/RESULT Param.
16104: END IF;
16105:
16106: END LOOP;--l_function_param_table
16107: DBMS_SQL.CLOSE_CURSOR(v_cursor);
16108:
16109: EXCEPTION
16110:
16111: WHEN no_action_founded_exception THEN