APPS.BSC_AW_UTILITY dependencies on DBMS_SQL

Line 5: p_array dbms_sql.varchar2_table,

1: package body BSC_AW_UTILITY AS
2: /*$Header: BSCAWUTB.pls 120.34 2006/06/16 21:32:45 vsurendr ship $*/
3:
4: function in_array(
5: p_array dbms_sql.varchar2_table,
6: p_value varchar2
7: ) return boolean is
8: Begin
9: for i in 1..p_array.count loop

Line 21: p_array dbms_sql.number_table,

17: raise;
18: End;
19:
20: function in_array(
21: p_array dbms_sql.number_table,
22: p_value number
23: ) return boolean is
24: Begin
25: for i in 1..p_array.count loop

Line 49: p_array dbms_sql.varchar2_table,

45: return false;
46: End;
47:
48: function get_array_index(
49: p_array dbms_sql.varchar2_table,
50: p_value varchar2
51: ) return number is
52: Begin
53: for i in 1..p_array.count loop

Line 65: p_array dbms_sql.number_table,

61: raise;
62: End;
63:
64: function get_array_index(
65: p_array dbms_sql.number_table,
66: p_value number
67: ) return number is
68: Begin
69: for i in 1..p_array.count loop

Line 132: l_parse_strings dbms_sql.varchar2_table;

128: p_separator varchar2,
129: p_values out nocopy value_tb
130: ) is
131: --
132: l_parse_strings dbms_sql.varchar2_table;
133: Begin
134: parse_parameter_values(p_string,p_separator,l_parse_strings);
135: for i in 1..l_parse_strings.count loop
136: resolve_into_value_r(l_parse_strings(i),p_values(p_values.count+1));

Line 183: p_values out nocopy dbms_sql.varchar2_table

179: */
180: procedure parse_parameter_values(
181: p_string varchar2,
182: p_separator varchar2,
183: p_values out nocopy dbms_sql.varchar2_table
184: ) is
185: --
186: l_start number;
187: l_end number;

Line 377: procedure add_g_commands(p_commands in out nocopy dbms_sql.varchar2_table,p_command varchar2) is

373: log('Exception in make_stmt_for_aw '||sqlerrm);
374: raise;
375: End;
376:
377: procedure add_g_commands(p_commands in out nocopy dbms_sql.varchar2_table,p_command varchar2) is
378: Begin
379: p_commands(p_commands.count+1):=p_command;
380: Exception when others then
381: log('Exception in add_g_commands '||sqlerrm);

Line 385: function get_g_commands(p_commands dbms_sql.varchar2_table,p_index number) return varchar2 is

381: log('Exception in add_g_commands '||sqlerrm);
382: raise;
383: End;
384:
385: function get_g_commands(p_commands dbms_sql.varchar2_table,p_index number) return varchar2 is
386: Begin
387: if p_commands.count>0 then
388: if p_index is null then --latest
389: return p_commands(p_commands.count);

Line 401: procedure trim_g_commands(p_commands in out nocopy dbms_sql.varchar2_table,p_trim number,p_add varchar2) is

397: log('Exception in get_g_commands '||sqlerrm);
398: raise;
399: End;
400:
401: procedure trim_g_commands(p_commands in out nocopy dbms_sql.varchar2_table,p_trim number,p_add varchar2) is
402: Begin
403: p_commands(p_commands.count):=substr(p_commands(p_commands.count),1,length(p_commands(p_commands.count))-p_trim)||p_add;
404: Exception when others then
405: log('Exception in trim_g_commands '||sqlerrm);

Line 409: procedure exec_program_commands(p_program varchar2,p_commands dbms_sql.varchar2_table) is

405: log('Exception in trim_g_commands '||sqlerrm);
406: raise;
407: End;
408:
409: procedure exec_program_commands(p_program varchar2,p_commands dbms_sql.varchar2_table) is
410: Begin
411: --the first stmt is 'dfn abc program' this does not have "joinlines"
412: --first try and drop the programs if it exists.
413: bsc_aw_dbms_aw.execute_ne('delete '||p_program);

Line 421: procedure exec_aggmap_commands(p_aggmap varchar2,p_commands dbms_sql.varchar2_table) is

417: log('Exception in exec_program_commands '||sqlerrm);
418: raise;
419: End;
420:
421: procedure exec_aggmap_commands(p_aggmap varchar2,p_commands dbms_sql.varchar2_table) is
422: Begin
423: --the first stmt is 'dfn abc program' this does not have "joinlines"
424: bsc_aw_dbms_aw.execute_ne('delete '||p_aggmap);
425: exec_aw_program_aggmap(p_aggmap,p_commands,'aggmap');

Line 433: procedure exec_aw_program_aggmap(p_name varchar2,p_commands dbms_sql.varchar2_table,p_type varchar2) is

429: raise;
430: End;
431:
432: --p_type is 'program' or 'aggmap'
433: procedure exec_aw_program_aggmap(p_name varchar2,p_commands dbms_sql.varchar2_table,p_type varchar2) is
434: l_commands varchar2(8000);
435: Begin
436: bsc_aw_dbms_aw.execute(p_commands(1));
437: for i in 2..p_commands.count loop

Line 500: function get_max(p_array dbms_sql.number_table) return number is

496:
497: /*
498: given a number array, get the max
499: */
500: function get_max(p_array dbms_sql.number_table) return number is
501: l_max number;
502: Begin
503: if p_array.count<=0 then
504: return null;

Line 626: p_location out nocopy dbms_sql.number_table

622: */
623: function is_string_present(
624: p_string varchar2,
625: p_text varchar2,
626: p_location out nocopy dbms_sql.number_table
627: ) return boolean is
628: --
629: l_start number;
630: l_end number;

Line 747: p_start_array dbms_sql.number_table

743: procedure replace_string(
744: p_string in out nocopy varchar2,
745: p_old_text varchar2,
746: p_new_text varchar2,
747: p_start_array dbms_sql.number_table
748: ) is
749: --
750: l_string_parts dbms_sql.varchar2_table;
751: l_start number;

Line 750: l_string_parts dbms_sql.varchar2_table;

746: p_new_text varchar2,
747: p_start_array dbms_sql.number_table
748: ) is
749: --
750: l_string_parts dbms_sql.varchar2_table;
751: l_start number;
752: l_len number;
753: l_length number;
754: Begin

Line 972: l_table dbms_sql.varchar2_table;

968: null;
969: End;
970:
971: procedure log_fnd(p_message varchar2,p_severity number) is
972: l_table dbms_sql.varchar2_table;
973: Begin
974: if p_severity>=FND_LOG.G_CURRENT_RUNTIME_LEVEL then
975: convert_varchar2_to_table(p_message,3990,l_table);
976: for i in 1..l_table.count loop

Line 1130: p_table out nocopy dbms_sql.varchar2_table

1126: */
1127: procedure convert_varchar2_to_table(
1128: p_string varchar2,
1129: p_limit number,
1130: p_table out nocopy dbms_sql.varchar2_table
1131: ) is
1132: --
1133: l_length number;
1134: l_start number;

Line 1222: procedure remove_array_element(p_array in out nocopy dbms_sql.varchar2_table,p_object varchar2) is

1218: log_n('Exception in get_random_number '||sqlerrm);
1219: raise;
1220: End;
1221:
1222: procedure remove_array_element(p_array in out nocopy dbms_sql.varchar2_table,p_object varchar2) is
1223: Begin
1224: for i in 1..p_array.count loop
1225: if p_array(i)=p_object then
1226: for j in i..p_array.count-1 loop

Line 1621: function make_string_from_list(p_list dbms_sql.varchar2_table) return varchar2 is

1617: log_n('Exception in get_dbms_time '||sqlerrm);
1618: raise;
1619: End;
1620:
1621: function make_string_from_list(p_list dbms_sql.varchar2_table) return varchar2 is
1622: Begin
1623: return make_string_from_list(p_list,',');
1624: Exception when others then
1625: log_n('Exception in make_string_from_list '||sqlerrm);

Line 1629: function make_string_from_list(p_list dbms_sql.varchar2_table,p_separator varchar2) return varchar2 is

1625: log_n('Exception in make_string_from_list '||sqlerrm);
1626: raise;
1627: End;
1628:
1629: function make_string_from_list(p_list dbms_sql.varchar2_table,p_separator varchar2) return varchar2 is
1630: --
1631: l_string varchar2(20000);
1632: Begin
1633: l_string:=null;

Line 1701: procedure merge_array(p_array in out nocopy dbms_sql.varchar2_table,p_values dbms_sql.varchar2_table) is

1697: log_n('Exception in get_hash_value '||sqlerrm);
1698: raise;
1699: End;
1700:
1701: procedure merge_array(p_array in out nocopy dbms_sql.varchar2_table,p_values dbms_sql.varchar2_table) is
1702: Begin
1703: for i in 1..p_values.count loop
1704: if in_array(p_array,p_values(i))=false then
1705: p_array(p_array.count+1):=p_values(i);

Line 1713: procedure merge_value(p_array in out nocopy dbms_sql.varchar2_table,p_value varchar2) is

1709: log_n('Exception in merge_array '||sqlerrm);
1710: raise;
1711: End;
1712:
1713: procedure merge_value(p_array in out nocopy dbms_sql.varchar2_table,p_value varchar2) is
1714: Begin
1715: if p_value is not null then
1716: if in_array(p_array,p_value)=false then
1717: p_array(p_array.count+1):=p_value;

Line 1725: procedure subtract_array(p_array in out nocopy dbms_sql.varchar2_table,p_values dbms_sql.varchar2_table) is

1721: log_n('Exception in merge_value '||sqlerrm);
1722: raise;
1723: End;
1724:
1725: procedure subtract_array(p_array in out nocopy dbms_sql.varchar2_table,p_values dbms_sql.varchar2_table) is
1726: l_array dbms_sql.varchar2_table;
1727: Begin
1728: if p_values.count>0 and p_array.count>0 then
1729: for i in 1..p_array.count loop

Line 1726: l_array dbms_sql.varchar2_table;

1722: raise;
1723: End;
1724:
1725: procedure subtract_array(p_array in out nocopy dbms_sql.varchar2_table,p_values dbms_sql.varchar2_table) is
1726: l_array dbms_sql.varchar2_table;
1727: Begin
1728: if p_values.count>0 and p_array.count>0 then
1729: for i in 1..p_array.count loop
1730: l_array(i):=p_array(i);

Line 1744: procedure merge_array(p_array in out nocopy dbms_sql.number_table,p_values dbms_sql.number_table) is

1740: log_n('Exception in subtract_array '||sqlerrm);
1741: raise;
1742: End;
1743:
1744: procedure merge_array(p_array in out nocopy dbms_sql.number_table,p_values dbms_sql.number_table) is
1745: Begin
1746: for i in 1..p_values.count loop
1747: if in_array(p_array,p_values(i))=false then
1748: p_array(p_array.count+1):=p_values(i);

Line 1756: procedure merge_value(p_array in out nocopy dbms_sql.number_table,p_value number) is

1752: log_n('Exception in merge_array '||sqlerrm);
1753: raise;
1754: End;
1755:
1756: procedure merge_value(p_array in out nocopy dbms_sql.number_table,p_value number) is
1757: Begin
1758: if p_value is not null then
1759: if in_array(p_array,p_value)=false then
1760: p_array(p_array.count+1):=p_value;

Line 1782: procedure dmp_values(p_table dbms_sql.varchar2_table,p_text varchar2) is

1778: log_n('Exception in set_aw_trace '||sqlerrm);
1779: raise;
1780: End;
1781:
1782: procedure dmp_values(p_table dbms_sql.varchar2_table,p_text varchar2) is
1783: Begin
1784: log('------');
1785: log(p_text);
1786: for i in 1..p_table.count loop

Line 1972: function order_array(p_array dbms_sql.varchar2_table) return dbms_sql.varchar2_table is

1968: log_n('Exception in is_new_value '||sqlerrm);
1969: raise;
1970: End;
1971:
1972: function order_array(p_array dbms_sql.varchar2_table) return dbms_sql.varchar2_table is
1973: l_array dbms_sql.varchar2_table;
1974: TYPE CurTyp IS REF CURSOR;
1975: cv CurTyp;
1976: Begin

Line 1973: l_array dbms_sql.varchar2_table;

1969: raise;
1970: End;
1971:
1972: function order_array(p_array dbms_sql.varchar2_table) return dbms_sql.varchar2_table is
1973: l_array dbms_sql.varchar2_table;
1974: TYPE CurTyp IS REF CURSOR;
1975: cv CurTyp;
1976: Begin
1977: if p_array.count>0 then

Line 1993: function make_upper(p_array dbms_sql.varchar2_table) return dbms_sql.varchar2_table is

1989: log_n('Exception in order_array '||sqlerrm);
1990: raise;
1991: End;
1992:
1993: function make_upper(p_array dbms_sql.varchar2_table) return dbms_sql.varchar2_table is
1994: l_array dbms_sql.varchar2_table;
1995: Begin
1996: for i in 1..p_array.count loop
1997: l_array(i):=upper(p_array(i));

Line 1994: l_array dbms_sql.varchar2_table;

1990: raise;
1991: End;
1992:
1993: function make_upper(p_array dbms_sql.varchar2_table) return dbms_sql.varchar2_table is
1994: l_array dbms_sql.varchar2_table;
1995: Begin
1996: for i in 1..p_array.count loop
1997: l_array(i):=upper(p_array(i));
1998: end loop;

Line 2204: procedure get_all_parents(p_parent_child parent_child_tb,p_child varchar2,p_parents in out nocopy dbms_sql.varchar2_table) is

2200: log_n('Exception in get_child_values '||sqlerrm);
2201: raise;
2202: End;
2203:
2204: procedure get_all_parents(p_parent_child parent_child_tb,p_child varchar2,p_parents in out nocopy dbms_sql.varchar2_table) is
2205: l_parents parent_child_tb;
2206: Begin
2207: get_parent_values(p_parent_child,p_child,l_parents);
2208: for i in 1..l_parents.count loop

Line 2223: procedure get_all_children(p_parent_child parent_child_tb,p_parent varchar2,p_children in out nocopy dbms_sql.varchar2_table) is

2219: log_n('Exception in get_all_parents '||sqlerrm);
2220: raise;
2221: End;
2222:
2223: procedure get_all_children(p_parent_child parent_child_tb,p_parent varchar2,p_children in out nocopy dbms_sql.varchar2_table) is
2224: l_children parent_child_tb;
2225: Begin
2226: get_child_values(p_parent_child,p_parent,l_children);
2227: for i in 1..l_children.count loop

Line 2246: l_values dbms_sql.varchar2_table;

2242: /*we have a string like property1=value1,property2,property3=value3
2243: we pass new property and or new value like property2 value value2 or property 3 value 33 or property4 with value 4
2244: we update p_string with the values*/
2245: procedure update_property(p_string in out nocopy varchar2,p_parameter varchar2,p_value varchar2,p_separator varchar2) is
2246: l_values dbms_sql.varchar2_table;
2247: l_index number;
2248: Begin
2249: parse_parameter_values(p_string,p_separator,l_values);
2250: for i in 1..l_values.count loop