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 1738: l_cursor := dbms_sql.open_cursor;

1734: l_sql := l_sql || ' ) qrslt ';
1735: l_sql := l_sql || ' where ';
1736: l_sql := l_sql || x_where_clause;
1737:
1738: l_cursor := dbms_sql.open_cursor;
1739: dbms_sql.parse(l_cursor, l_sql, dbms_sql.native);
1740: dbms_sql.define_column(l_cursor, 1, l_num);
1741:
1742: l_pos := 1;

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

1735: l_sql := l_sql || ' where ';
1736: l_sql := l_sql || x_where_clause;
1737:
1738: l_cursor := dbms_sql.open_cursor;
1739: dbms_sql.parse(l_cursor, l_sql, dbms_sql.native);
1740: dbms_sql.define_column(l_cursor, 1, l_num);
1741:
1742: l_pos := 1;
1743: loop

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

1736: l_sql := l_sql || x_where_clause;
1737:
1738: l_cursor := dbms_sql.open_cursor;
1739: dbms_sql.parse(l_cursor, l_sql, dbms_sql.native);
1740: dbms_sql.define_column(l_cursor, 1, l_num);
1741:
1742: l_pos := 1;
1743: loop
1744: l_index := instr(x_bind_variables, ',', l_pos, 1);

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

1749: l_var := substr(x_bind_variables, l_pos, l_index - l_pos);
1750: end if;
1751:
1752: if( l_var = 'from_date' ) then
1753: dbms_sql.bind_variable(l_cursor, '' || l_bind_num, p_from_date);
1754: elsif (l_var = 'to_date' ) then
1755: dbms_sql.bind_variable(l_cursor, '' || l_bind_num, p_to_date);
1756: elsif ( l_var = 'organization_id' ) then
1757: dbms_sql.bind_variable(l_cursor, '' || l_bind_num, p_org_id );

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

1751:
1752: if( l_var = 'from_date' ) then
1753: dbms_sql.bind_variable(l_cursor, '' || l_bind_num, p_from_date);
1754: elsif (l_var = 'to_date' ) then
1755: dbms_sql.bind_variable(l_cursor, '' || l_bind_num, p_to_date);
1756: elsif ( l_var = 'organization_id' ) then
1757: dbms_sql.bind_variable(l_cursor, '' || l_bind_num, p_org_id );
1758: elsif ( l_var = 'department_id' ) then
1759: dbms_sql.bind_variable(l_cursor, '' || l_bind_num, p_department_id);

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

1753: dbms_sql.bind_variable(l_cursor, '' || l_bind_num, p_from_date);
1754: elsif (l_var = 'to_date' ) then
1755: dbms_sql.bind_variable(l_cursor, '' || l_bind_num, p_to_date);
1756: elsif ( l_var = 'organization_id' ) then
1757: dbms_sql.bind_variable(l_cursor, '' || l_bind_num, p_org_id );
1758: elsif ( l_var = 'department_id' ) then
1759: dbms_sql.bind_variable(l_cursor, '' || l_bind_num, p_department_id);
1760: elsif ( l_var = 'resource_id') then
1761: dbms_sql.bind_variable(l_cursor, '' || l_bind_num, p_resource_id);

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

1755: dbms_sql.bind_variable(l_cursor, '' || l_bind_num, p_to_date);
1756: elsif ( l_var = 'organization_id' ) then
1757: dbms_sql.bind_variable(l_cursor, '' || l_bind_num, p_org_id );
1758: elsif ( l_var = 'department_id' ) then
1759: dbms_sql.bind_variable(l_cursor, '' || l_bind_num, p_department_id);
1760: elsif ( l_var = 'resource_id') then
1761: dbms_sql.bind_variable(l_cursor, '' || l_bind_num, p_resource_id);
1762: end if;
1763: -- bind the var

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

1757: dbms_sql.bind_variable(l_cursor, '' || l_bind_num, p_org_id );
1758: elsif ( l_var = 'department_id' ) then
1759: dbms_sql.bind_variable(l_cursor, '' || l_bind_num, p_department_id);
1760: elsif ( l_var = 'resource_id') then
1761: dbms_sql.bind_variable(l_cursor, '' || l_bind_num, p_resource_id);
1762: end if;
1763: -- bind the var
1764:
1765: exit when l_index = 0;

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

1767: l_pos := l_index + 1;
1768: l_bind_num := l_bind_num + 1;
1769: end loop;
1770:
1771: l_dummy := dbms_sql.execute(l_cursor);
1772:
1773: if( dbms_sql.fetch_rows(l_cursor) > 0 ) then
1774: dbms_sql.column_value(l_cursor, 1, l_num);
1775: else

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

1769: end loop;
1770:
1771: l_dummy := dbms_sql.execute(l_cursor);
1772:
1773: if( dbms_sql.fetch_rows(l_cursor) > 0 ) then
1774: dbms_sql.column_value(l_cursor, 1, l_num);
1775: else
1776: l_num := 0;
1777: end if;

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

1770:
1771: l_dummy := dbms_sql.execute(l_cursor);
1772:
1773: if( dbms_sql.fetch_rows(l_cursor) > 0 ) then
1774: dbms_sql.column_value(l_cursor, 1, l_num);
1775: else
1776: l_num := 0;
1777: end if;
1778:

Line 1779: dbms_sql.close_cursor(l_cursor);

1775: else
1776: l_num := 0;
1777: end if;
1778:
1779: dbms_sql.close_cursor(l_cursor);
1780:
1781: return l_num;
1782: End get_cap_num_ns_jobs;
1783:

Line 1885: l_cursor := dbms_sql.open_cursor;

1881: l_sql := l_sql || ' ) qrslt ';
1882: l_sql := l_sql || ' where ';
1883: l_sql := l_sql || x_where_clause;
1884:
1885: l_cursor := dbms_sql.open_cursor;
1886: dbms_sql.parse(l_cursor, l_sql, dbms_sql.native);
1887: dbms_sql.define_column(l_cursor, 1, l_req);
1888:
1889: dbms_sql.bind_variable(l_cursor, '1', p_department_id);

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

1882: l_sql := l_sql || ' where ';
1883: l_sql := l_sql || x_where_clause;
1884:
1885: l_cursor := dbms_sql.open_cursor;
1886: dbms_sql.parse(l_cursor, l_sql, dbms_sql.native);
1887: dbms_sql.define_column(l_cursor, 1, l_req);
1888:
1889: dbms_sql.bind_variable(l_cursor, '1', p_department_id);
1890: dbms_sql.bind_variable(l_cursor, '2', p_resource_id);

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

1883: l_sql := l_sql || x_where_clause;
1884:
1885: l_cursor := dbms_sql.open_cursor;
1886: dbms_sql.parse(l_cursor, l_sql, dbms_sql.native);
1887: dbms_sql.define_column(l_cursor, 1, l_req);
1888:
1889: dbms_sql.bind_variable(l_cursor, '1', p_department_id);
1890: dbms_sql.bind_variable(l_cursor, '2', p_resource_id);
1891:

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

1885: l_cursor := dbms_sql.open_cursor;
1886: dbms_sql.parse(l_cursor, l_sql, dbms_sql.native);
1887: dbms_sql.define_column(l_cursor, 1, l_req);
1888:
1889: dbms_sql.bind_variable(l_cursor, '1', p_department_id);
1890: dbms_sql.bind_variable(l_cursor, '2', p_resource_id);
1891:
1892: l_pos := 1;
1893: loop

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

1886: dbms_sql.parse(l_cursor, l_sql, dbms_sql.native);
1887: dbms_sql.define_column(l_cursor, 1, l_req);
1888:
1889: dbms_sql.bind_variable(l_cursor, '1', p_department_id);
1890: dbms_sql.bind_variable(l_cursor, '2', p_resource_id);
1891:
1892: l_pos := 1;
1893: loop
1894: l_index := instr(x_bind_variables, ',', l_pos, 1);

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

1899: l_var := substr(x_bind_variables, l_pos, l_index - l_pos);
1900: end if;
1901:
1902: if( l_var = 'from_date' ) then
1903: dbms_sql.bind_variable(l_cursor, '' || l_bind_num, p_from_date);
1904: elsif (l_var = 'to_date' ) then
1905: dbms_sql.bind_variable(l_cursor, '' || l_bind_num, p_to_date);
1906: elsif ( l_var = 'organization_id' ) then
1907: dbms_sql.bind_variable(l_cursor, '' || l_bind_num, p_org_id );

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

1901:
1902: if( l_var = 'from_date' ) then
1903: dbms_sql.bind_variable(l_cursor, '' || l_bind_num, p_from_date);
1904: elsif (l_var = 'to_date' ) then
1905: dbms_sql.bind_variable(l_cursor, '' || l_bind_num, p_to_date);
1906: elsif ( l_var = 'organization_id' ) then
1907: dbms_sql.bind_variable(l_cursor, '' || l_bind_num, p_org_id );
1908: elsif ( l_var = 'department_id' ) then
1909: dbms_sql.bind_variable(l_cursor, '' || l_bind_num, p_department_id);

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

1903: dbms_sql.bind_variable(l_cursor, '' || l_bind_num, p_from_date);
1904: elsif (l_var = 'to_date' ) then
1905: dbms_sql.bind_variable(l_cursor, '' || l_bind_num, p_to_date);
1906: elsif ( l_var = 'organization_id' ) then
1907: dbms_sql.bind_variable(l_cursor, '' || l_bind_num, p_org_id );
1908: elsif ( l_var = 'department_id' ) then
1909: dbms_sql.bind_variable(l_cursor, '' || l_bind_num, p_department_id);
1910: elsif ( l_var = 'resource_id') then
1911: dbms_sql.bind_variable(l_cursor, '' || l_bind_num, p_resource_id);

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

1905: dbms_sql.bind_variable(l_cursor, '' || l_bind_num, p_to_date);
1906: elsif ( l_var = 'organization_id' ) then
1907: dbms_sql.bind_variable(l_cursor, '' || l_bind_num, p_org_id );
1908: elsif ( l_var = 'department_id' ) then
1909: dbms_sql.bind_variable(l_cursor, '' || l_bind_num, p_department_id);
1910: elsif ( l_var = 'resource_id') then
1911: dbms_sql.bind_variable(l_cursor, '' || l_bind_num, p_resource_id);
1912: end if;
1913: -- bind the var

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

1907: dbms_sql.bind_variable(l_cursor, '' || l_bind_num, p_org_id );
1908: elsif ( l_var = 'department_id' ) then
1909: dbms_sql.bind_variable(l_cursor, '' || l_bind_num, p_department_id);
1910: elsif ( l_var = 'resource_id') then
1911: dbms_sql.bind_variable(l_cursor, '' || l_bind_num, p_resource_id);
1912: end if;
1913: -- bind the var
1914:
1915: exit when l_index = 0;

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

1917: l_pos := l_index + 1;
1918: l_bind_num := l_bind_num + 1;
1919: end loop;
1920:
1921: l_dummy := dbms_sql.execute(l_cursor);
1922:
1923: if( dbms_sql.fetch_rows(l_cursor) > 0 ) then
1924: dbms_sql.column_value(l_cursor, 1, l_req);
1925: else

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

1919: end loop;
1920:
1921: l_dummy := dbms_sql.execute(l_cursor);
1922:
1923: if( dbms_sql.fetch_rows(l_cursor) > 0 ) then
1924: dbms_sql.column_value(l_cursor, 1, l_req);
1925: else
1926: l_req := 0;
1927: end if;

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

1920:
1921: l_dummy := dbms_sql.execute(l_cursor);
1922:
1923: if( dbms_sql.fetch_rows(l_cursor) > 0 ) then
1924: dbms_sql.column_value(l_cursor, 1, l_req);
1925: else
1926: l_req := 0;
1927: end if;
1928:

Line 1932: dbms_sql.close_cursor(l_cursor);

1928:
1929: if l_req is null then --Bug -7364131
1930: l_req := 0; --Bug -7364131
1931: end if; --Bug -7364131
1932: dbms_sql.close_cursor(l_cursor);
1933:
1934: return l_req;
1935: End get_cap_resource_required;
1936: