DBA Data[Home] [Help]

APPS.PV_RULE_EVALUATION_PUB dependencies on JTF_VARCHAR2_TABLE_32767

Line 23: function in_list ( p_string in varchar2 ) return jtf_varchar2_table_32767;

19: p_token3 IN VARCHAR2 := NULL,
20: p_token3_value IN VARCHAR2 := NULL
21: );
22:
23: function in_list ( p_string in varchar2 ) return jtf_varchar2_table_32767;
24:
25:
26: -- #############################################################################
27: -- Partner Evaluation Outcome

Line 625: '( SELECT * FROM THE ( SELECT CAST( :Y as JTF_VARCHAR2_TABLE_32767 ) from dual ))';

621:
622: ELSE
623:
624: l_lov_string := 'SELECT t.meaning FROM (' || l_lov_string ||' ) t WHERE t.code IN '||
625: '( SELECT * FROM THE ( SELECT CAST( :Y as JTF_VARCHAR2_TABLE_32767 ) from dual ))';
626:
627: END IF;
628:
629: l_attr_in_string := replace(l_attribute_value_tbl(i),'''','');

Line 1485: '( SELECT * FROM THE ( SELECT CAST( :Y as JTF_VARCHAR2_TABLE_32767 ) from dual ))';

1481:
1482: ELSE
1483:
1484: l_lov_string := 'SELECT t.meaning FROM (' || l_lov_string ||' ) t WHERE t.code IN '||
1485: '( SELECT * FROM THE ( SELECT CAST( :Y as JTF_VARCHAR2_TABLE_32767 ) from dual ))';
1486:
1487: END IF;
1488:
1489: l_attr_in_string := replace(l_attribute_value_tbl(i),'''','');

Line 1804: --| jtf_varchar2_table_32767 |

1800: --| |
1801: --| Parameters |
1802: --| IN p_string |
1803: --| OUT |
1804: --| jtf_varchar2_table_32767 |
1805: --| |
1806: --| NOTES: |
1807: --| converts string to pl/sql table |
1808: --| HISTORY |

Line 1813: RETURN jtf_varchar2_table_32767

1809: --| |
1810: --==============================================================================
1811: FUNCTION in_list
1812: ( p_string IN VARCHAR2 )
1813: RETURN jtf_varchar2_table_32767
1814: as
1815: l_data jtf_varchar2_table_32767 := jtf_varchar2_table_32767();
1816: l_string long default p_string || ',';
1817: l_n number;

Line 1815: l_data jtf_varchar2_table_32767 := jtf_varchar2_table_32767();

1811: FUNCTION in_list
1812: ( p_string IN VARCHAR2 )
1813: RETURN jtf_varchar2_table_32767
1814: as
1815: l_data jtf_varchar2_table_32767 := jtf_varchar2_table_32767();
1816: l_string long default p_string || ',';
1817: l_n number;
1818: BEGIN
1819: