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.WIP_WS_DL_UTIL dependencies on DBMS_SQL

Line 1757: l_cursor := dbms_sql.open_cursor;

1753: l_sql := l_sql || ' ) qrslt ';
1754: l_sql := l_sql || ' where ';
1755: l_sql := l_sql || x_where_clause;
1756:
1757: l_cursor := dbms_sql.open_cursor;
1758: dbms_sql.parse(l_cursor, l_sql, dbms_sql.native);
1759: dbms_sql.define_column(l_cursor, 1, l_num);
1760:
1761: l_pos := 1;

Line 1758: dbms_sql.parse(l_cursor, l_sql, dbms_sql.native);

1754: l_sql := l_sql || ' where ';
1755: l_sql := l_sql || x_where_clause;
1756:
1757: l_cursor := dbms_sql.open_cursor;
1758: dbms_sql.parse(l_cursor, l_sql, dbms_sql.native);
1759: dbms_sql.define_column(l_cursor, 1, l_num);
1760:
1761: l_pos := 1;
1762: loop

Line 1759: dbms_sql.define_column(l_cursor, 1, l_num);

1755: l_sql := l_sql || x_where_clause;
1756:
1757: l_cursor := dbms_sql.open_cursor;
1758: dbms_sql.parse(l_cursor, l_sql, dbms_sql.native);
1759: dbms_sql.define_column(l_cursor, 1, l_num);
1760:
1761: l_pos := 1;
1762: loop
1763: l_index := instr(x_bind_variables, ',', l_pos, 1);

Line 1772: dbms_sql.bind_variable(l_cursor, '' || l_bind_num, p_from_date);

1768: l_var := substr(x_bind_variables, l_pos, l_index - l_pos);
1769: end if;
1770:
1771: if( l_var = 'from_date' ) then
1772: dbms_sql.bind_variable(l_cursor, '' || l_bind_num, p_from_date);
1773: elsif (l_var = 'to_date' ) then
1774: dbms_sql.bind_variable(l_cursor, '' || l_bind_num, p_to_date);
1775: elsif ( l_var = 'organization_id' ) then
1776: dbms_sql.bind_variable(l_cursor, '' || l_bind_num, p_org_id );

Line 1774: dbms_sql.bind_variable(l_cursor, '' || l_bind_num, p_to_date);

1770:
1771: if( l_var = 'from_date' ) then
1772: dbms_sql.bind_variable(l_cursor, '' || l_bind_num, p_from_date);
1773: elsif (l_var = 'to_date' ) then
1774: dbms_sql.bind_variable(l_cursor, '' || l_bind_num, p_to_date);
1775: elsif ( l_var = 'organization_id' ) then
1776: dbms_sql.bind_variable(l_cursor, '' || l_bind_num, p_org_id );
1777: elsif ( l_var = 'department_id' ) then
1778: dbms_sql.bind_variable(l_cursor, '' || l_bind_num, p_department_id);

Line 1776: dbms_sql.bind_variable(l_cursor, '' || l_bind_num, p_org_id );

1772: dbms_sql.bind_variable(l_cursor, '' || l_bind_num, p_from_date);
1773: elsif (l_var = 'to_date' ) then
1774: dbms_sql.bind_variable(l_cursor, '' || l_bind_num, p_to_date);
1775: elsif ( l_var = 'organization_id' ) then
1776: dbms_sql.bind_variable(l_cursor, '' || l_bind_num, p_org_id );
1777: elsif ( l_var = 'department_id' ) then
1778: dbms_sql.bind_variable(l_cursor, '' || l_bind_num, p_department_id);
1779: elsif ( l_var = 'resource_id') then
1780: dbms_sql.bind_variable(l_cursor, '' || l_bind_num, p_resource_id);

Line 1778: dbms_sql.bind_variable(l_cursor, '' || l_bind_num, p_department_id);

1774: dbms_sql.bind_variable(l_cursor, '' || l_bind_num, p_to_date);
1775: elsif ( l_var = 'organization_id' ) then
1776: dbms_sql.bind_variable(l_cursor, '' || l_bind_num, p_org_id );
1777: elsif ( l_var = 'department_id' ) then
1778: dbms_sql.bind_variable(l_cursor, '' || l_bind_num, p_department_id);
1779: elsif ( l_var = 'resource_id') then
1780: dbms_sql.bind_variable(l_cursor, '' || l_bind_num, p_resource_id);
1781: end if;
1782: -- bind the var

Line 1780: dbms_sql.bind_variable(l_cursor, '' || l_bind_num, p_resource_id);

1776: dbms_sql.bind_variable(l_cursor, '' || l_bind_num, p_org_id );
1777: elsif ( l_var = 'department_id' ) then
1778: dbms_sql.bind_variable(l_cursor, '' || l_bind_num, p_department_id);
1779: elsif ( l_var = 'resource_id') then
1780: dbms_sql.bind_variable(l_cursor, '' || l_bind_num, p_resource_id);
1781: end if;
1782: -- bind the var
1783:
1784: exit when l_index = 0;

Line 1790: l_dummy := dbms_sql.execute(l_cursor);

1786: l_pos := l_index + 1;
1787: l_bind_num := l_bind_num + 1;
1788: end loop;
1789:
1790: l_dummy := dbms_sql.execute(l_cursor);
1791:
1792: if( dbms_sql.fetch_rows(l_cursor) > 0 ) then
1793: dbms_sql.column_value(l_cursor, 1, l_num);
1794: else

Line 1792: if( dbms_sql.fetch_rows(l_cursor) > 0 ) then

1788: end loop;
1789:
1790: l_dummy := dbms_sql.execute(l_cursor);
1791:
1792: if( dbms_sql.fetch_rows(l_cursor) > 0 ) then
1793: dbms_sql.column_value(l_cursor, 1, l_num);
1794: else
1795: l_num := 0;
1796: end if;

Line 1793: dbms_sql.column_value(l_cursor, 1, l_num);

1789:
1790: l_dummy := dbms_sql.execute(l_cursor);
1791:
1792: if( dbms_sql.fetch_rows(l_cursor) > 0 ) then
1793: dbms_sql.column_value(l_cursor, 1, l_num);
1794: else
1795: l_num := 0;
1796: end if;
1797:

Line 1798: dbms_sql.close_cursor(l_cursor);

1794: else
1795: l_num := 0;
1796: end if;
1797:
1798: dbms_sql.close_cursor(l_cursor);
1799:
1800: return l_num;
1801: End get_cap_num_ns_jobs;
1802:

Line 1907: l_cursor := dbms_sql.open_cursor;

1903: l_sql := l_sql || ' ) qrslt ';
1904: l_sql := l_sql || ' where ';
1905: l_sql := l_sql || x_where_clause;
1906:
1907: l_cursor := dbms_sql.open_cursor;
1908: dbms_sql.parse(l_cursor, l_sql, dbms_sql.native);
1909: dbms_sql.define_column(l_cursor, 1, l_req);
1910:
1911: dbms_sql.bind_variable(l_cursor, '1', p_department_id);

Line 1908: dbms_sql.parse(l_cursor, l_sql, dbms_sql.native);

1904: l_sql := l_sql || ' where ';
1905: l_sql := l_sql || x_where_clause;
1906:
1907: l_cursor := dbms_sql.open_cursor;
1908: dbms_sql.parse(l_cursor, l_sql, dbms_sql.native);
1909: dbms_sql.define_column(l_cursor, 1, l_req);
1910:
1911: dbms_sql.bind_variable(l_cursor, '1', p_department_id);
1912: dbms_sql.bind_variable(l_cursor, '2', p_resource_id);

Line 1909: dbms_sql.define_column(l_cursor, 1, l_req);

1905: l_sql := l_sql || x_where_clause;
1906:
1907: l_cursor := dbms_sql.open_cursor;
1908: dbms_sql.parse(l_cursor, l_sql, dbms_sql.native);
1909: dbms_sql.define_column(l_cursor, 1, l_req);
1910:
1911: dbms_sql.bind_variable(l_cursor, '1', p_department_id);
1912: dbms_sql.bind_variable(l_cursor, '2', p_resource_id);
1913:

Line 1911: dbms_sql.bind_variable(l_cursor, '1', p_department_id);

1907: l_cursor := dbms_sql.open_cursor;
1908: dbms_sql.parse(l_cursor, l_sql, dbms_sql.native);
1909: dbms_sql.define_column(l_cursor, 1, l_req);
1910:
1911: dbms_sql.bind_variable(l_cursor, '1', p_department_id);
1912: dbms_sql.bind_variable(l_cursor, '2', p_resource_id);
1913:
1914: l_pos := 1;
1915: loop

Line 1912: dbms_sql.bind_variable(l_cursor, '2', p_resource_id);

1908: dbms_sql.parse(l_cursor, l_sql, dbms_sql.native);
1909: dbms_sql.define_column(l_cursor, 1, l_req);
1910:
1911: dbms_sql.bind_variable(l_cursor, '1', p_department_id);
1912: dbms_sql.bind_variable(l_cursor, '2', p_resource_id);
1913:
1914: l_pos := 1;
1915: loop
1916: l_index := instr(x_bind_variables, ',', l_pos, 1);

Line 1925: dbms_sql.bind_variable(l_cursor, '' || l_bind_num, p_from_date);

1921: l_var := substr(x_bind_variables, l_pos, l_index - l_pos);
1922: end if;
1923:
1924: if( l_var = 'from_date' ) then
1925: dbms_sql.bind_variable(l_cursor, '' || l_bind_num, p_from_date);
1926: elsif (l_var = 'to_date' ) then
1927: dbms_sql.bind_variable(l_cursor, '' || l_bind_num, p_to_date);
1928: elsif ( l_var = 'organization_id' ) then
1929: dbms_sql.bind_variable(l_cursor, '' || l_bind_num, p_org_id );

Line 1927: dbms_sql.bind_variable(l_cursor, '' || l_bind_num, p_to_date);

1923:
1924: if( l_var = 'from_date' ) then
1925: dbms_sql.bind_variable(l_cursor, '' || l_bind_num, p_from_date);
1926: elsif (l_var = 'to_date' ) then
1927: dbms_sql.bind_variable(l_cursor, '' || l_bind_num, p_to_date);
1928: elsif ( l_var = 'organization_id' ) then
1929: dbms_sql.bind_variable(l_cursor, '' || l_bind_num, p_org_id );
1930: elsif ( l_var = 'department_id' ) then
1931: dbms_sql.bind_variable(l_cursor, '' || l_bind_num, p_department_id);

Line 1929: dbms_sql.bind_variable(l_cursor, '' || l_bind_num, p_org_id );

1925: dbms_sql.bind_variable(l_cursor, '' || l_bind_num, p_from_date);
1926: elsif (l_var = 'to_date' ) then
1927: dbms_sql.bind_variable(l_cursor, '' || l_bind_num, p_to_date);
1928: elsif ( l_var = 'organization_id' ) then
1929: dbms_sql.bind_variable(l_cursor, '' || l_bind_num, p_org_id );
1930: elsif ( l_var = 'department_id' ) then
1931: dbms_sql.bind_variable(l_cursor, '' || l_bind_num, p_department_id);
1932: elsif ( l_var = 'resource_id') then
1933: dbms_sql.bind_variable(l_cursor, '' || l_bind_num, p_resource_id);

Line 1931: dbms_sql.bind_variable(l_cursor, '' || l_bind_num, p_department_id);

1927: dbms_sql.bind_variable(l_cursor, '' || l_bind_num, p_to_date);
1928: elsif ( l_var = 'organization_id' ) then
1929: dbms_sql.bind_variable(l_cursor, '' || l_bind_num, p_org_id );
1930: elsif ( l_var = 'department_id' ) then
1931: dbms_sql.bind_variable(l_cursor, '' || l_bind_num, p_department_id);
1932: elsif ( l_var = 'resource_id') then
1933: dbms_sql.bind_variable(l_cursor, '' || l_bind_num, p_resource_id);
1934: end if;
1935: -- bind the var

Line 1933: dbms_sql.bind_variable(l_cursor, '' || l_bind_num, p_resource_id);

1929: dbms_sql.bind_variable(l_cursor, '' || l_bind_num, p_org_id );
1930: elsif ( l_var = 'department_id' ) then
1931: dbms_sql.bind_variable(l_cursor, '' || l_bind_num, p_department_id);
1932: elsif ( l_var = 'resource_id') then
1933: dbms_sql.bind_variable(l_cursor, '' || l_bind_num, p_resource_id);
1934: end if;
1935: -- bind the var
1936:
1937: exit when l_index = 0;

Line 1943: l_dummy := dbms_sql.execute(l_cursor);

1939: l_pos := l_index + 1;
1940: l_bind_num := l_bind_num + 1;
1941: end loop;
1942:
1943: l_dummy := dbms_sql.execute(l_cursor);
1944:
1945: if( dbms_sql.fetch_rows(l_cursor) > 0 ) then
1946: dbms_sql.column_value(l_cursor, 1, l_req);
1947: else

Line 1945: if( dbms_sql.fetch_rows(l_cursor) > 0 ) then

1941: end loop;
1942:
1943: l_dummy := dbms_sql.execute(l_cursor);
1944:
1945: if( dbms_sql.fetch_rows(l_cursor) > 0 ) then
1946: dbms_sql.column_value(l_cursor, 1, l_req);
1947: else
1948: l_req := 0;
1949: end if;

Line 1946: dbms_sql.column_value(l_cursor, 1, l_req);

1942:
1943: l_dummy := dbms_sql.execute(l_cursor);
1944:
1945: if( dbms_sql.fetch_rows(l_cursor) > 0 ) then
1946: dbms_sql.column_value(l_cursor, 1, l_req);
1947: else
1948: l_req := 0;
1949: end if;
1950:

Line 1954: dbms_sql.close_cursor(l_cursor);

1950:
1951: if l_req is null then --Bug -7364131
1952: l_req := 0; --Bug -7364131
1953: end if; --Bug -7364131
1954: dbms_sql.close_cursor(l_cursor);
1955:
1956: return l_req;
1957: End get_cap_resource_required;
1958: