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

Line 1673: l_cursor := dbms_sql.open_cursor;

1669: WHERE default_code_combination_id = code_combination_id
1670: AND employee_id = :l_employee_id';
1671:
1672: /* open cursor */
1673: l_cursor := dbms_sql.open_cursor;
1674:
1675: /* parse */
1676: dbms_sql.parse(l_cursor, sql_statement, dbms_sql.native);
1677:

Line 1676: dbms_sql.parse(l_cursor, sql_statement, dbms_sql.native);

1672: /* open cursor */
1673: l_cursor := dbms_sql.open_cursor;
1674:
1675: /* parse */
1676: dbms_sql.parse(l_cursor, sql_statement, dbms_sql.native);
1677:
1678: /* bind variables */
1679: dbms_sql.bind_variable(l_cursor,'l_employee_id',l_employee_id);
1680:

Line 1679: dbms_sql.bind_variable(l_cursor,'l_employee_id',l_employee_id);

1675: /* parse */
1676: dbms_sql.parse(l_cursor, sql_statement, dbms_sql.native);
1677:
1678: /* bind variables */
1679: dbms_sql.bind_variable(l_cursor,'l_employee_id',l_employee_id);
1680:
1681: /* define column */
1682: dbms_sql.define_column (l_cursor,1,p_cost_center,30);
1683:

Line 1682: dbms_sql.define_column (l_cursor,1,p_cost_center,30);

1678: /* bind variables */
1679: dbms_sql.bind_variable(l_cursor,'l_employee_id',l_employee_id);
1680:
1681: /* define column */
1682: dbms_sql.define_column (l_cursor,1,p_cost_center,30);
1683:
1684: /* execute query and fetch */
1685: l_rows := dbms_sql.execute(l_cursor);
1686: l_count := dbms_sql.fetch_rows(l_cursor);

Line 1685: l_rows := dbms_sql.execute(l_cursor);

1681: /* define column */
1682: dbms_sql.define_column (l_cursor,1,p_cost_center,30);
1683:
1684: /* execute query and fetch */
1685: l_rows := dbms_sql.execute(l_cursor);
1686: l_count := dbms_sql.fetch_rows(l_cursor);
1687:
1688: /* get the value */
1689: dbms_sql.column_value(l_cursor,1,p_cost_center);

Line 1686: l_count := dbms_sql.fetch_rows(l_cursor);

1682: dbms_sql.define_column (l_cursor,1,p_cost_center,30);
1683:
1684: /* execute query and fetch */
1685: l_rows := dbms_sql.execute(l_cursor);
1686: l_count := dbms_sql.fetch_rows(l_cursor);
1687:
1688: /* get the value */
1689: dbms_sql.column_value(l_cursor,1,p_cost_center);
1690:

Line 1689: dbms_sql.column_value(l_cursor,1,p_cost_center);

1685: l_rows := dbms_sql.execute(l_cursor);
1686: l_count := dbms_sql.fetch_rows(l_cursor);
1687:
1688: /* get the value */
1689: dbms_sql.column_value(l_cursor,1,p_cost_center);
1690:
1691: /* if cursor open, close */
1692: IF dbms_sql.is_open (l_cursor) THEN
1693: dbms_sql.close_cursor (l_cursor);

Line 1692: IF dbms_sql.is_open (l_cursor) THEN

1688: /* get the value */
1689: dbms_sql.column_value(l_cursor,1,p_cost_center);
1690:
1691: /* if cursor open, close */
1692: IF dbms_sql.is_open (l_cursor) THEN
1693: dbms_sql.close_cursor (l_cursor);
1694: END IF;
1695:
1696:

Line 1693: dbms_sql.close_cursor (l_cursor);

1689: dbms_sql.column_value(l_cursor,1,p_cost_center);
1690:
1691: /* if cursor open, close */
1692: IF dbms_sql.is_open (l_cursor) THEN
1693: dbms_sql.close_cursor (l_cursor);
1694: END IF;
1695:
1696:
1697:

Line 1911: l_cursor := dbms_sql.open_cursor;

1907: --Bug#6366630: Added the IF condition to control Cost Center Validation using Profile Option --
1908: IF nvl(pn_mo_cache_utils.get_profile_value('PN_VALIDATE_ASSIGN_CC', p_org_id),'Y') = 'Y' THEN
1909: l_column_name := ltrim(rtrim(get_segment_column_name(p_org_id)));
1910: l_cost_center := p_cost_center;
1911: l_cursor := dbms_sql.open_cursor;
1912:
1913:
1914: sql_statement :=
1915: 'select account_type

Line 1918: dbms_sql.parse(l_cursor, sql_statement, dbms_sql.native);

1914: sql_statement :=
1915: 'select account_type
1916: from gl_code_combinations where '||l_column_name||' = :l_cost_center';
1917:
1918: dbms_sql.parse(l_cursor, sql_statement, dbms_sql.native);
1919: dbms_sql.bind_variable(l_cursor,'l_cost_center',l_cost_center);
1920: dbms_sql.define_column (l_cursor,1,l_dummy,1);
1921: l_rows := dbms_sql.execute(l_cursor);
1922: l_count := dbms_sql.fetch_rows(l_cursor);

Line 1919: dbms_sql.bind_variable(l_cursor,'l_cost_center',l_cost_center);

1915: 'select account_type
1916: from gl_code_combinations where '||l_column_name||' = :l_cost_center';
1917:
1918: dbms_sql.parse(l_cursor, sql_statement, dbms_sql.native);
1919: dbms_sql.bind_variable(l_cursor,'l_cost_center',l_cost_center);
1920: dbms_sql.define_column (l_cursor,1,l_dummy,1);
1921: l_rows := dbms_sql.execute(l_cursor);
1922: l_count := dbms_sql.fetch_rows(l_cursor);
1923: dbms_sql.column_value (l_cursor,1,l_dummy);

Line 1920: dbms_sql.define_column (l_cursor,1,l_dummy,1);

1916: from gl_code_combinations where '||l_column_name||' = :l_cost_center';
1917:
1918: dbms_sql.parse(l_cursor, sql_statement, dbms_sql.native);
1919: dbms_sql.bind_variable(l_cursor,'l_cost_center',l_cost_center);
1920: dbms_sql.define_column (l_cursor,1,l_dummy,1);
1921: l_rows := dbms_sql.execute(l_cursor);
1922: l_count := dbms_sql.fetch_rows(l_cursor);
1923: dbms_sql.column_value (l_cursor,1,l_dummy);
1924: IF dbms_sql.is_open (l_cursor) THEN

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

1917:
1918: dbms_sql.parse(l_cursor, sql_statement, dbms_sql.native);
1919: dbms_sql.bind_variable(l_cursor,'l_cost_center',l_cost_center);
1920: dbms_sql.define_column (l_cursor,1,l_dummy,1);
1921: l_rows := dbms_sql.execute(l_cursor);
1922: l_count := dbms_sql.fetch_rows(l_cursor);
1923: dbms_sql.column_value (l_cursor,1,l_dummy);
1924: IF dbms_sql.is_open (l_cursor) THEN
1925: dbms_sql.close_cursor (l_cursor);

Line 1922: l_count := dbms_sql.fetch_rows(l_cursor);

1918: dbms_sql.parse(l_cursor, sql_statement, dbms_sql.native);
1919: dbms_sql.bind_variable(l_cursor,'l_cost_center',l_cost_center);
1920: dbms_sql.define_column (l_cursor,1,l_dummy,1);
1921: l_rows := dbms_sql.execute(l_cursor);
1922: l_count := dbms_sql.fetch_rows(l_cursor);
1923: dbms_sql.column_value (l_cursor,1,l_dummy);
1924: IF dbms_sql.is_open (l_cursor) THEN
1925: dbms_sql.close_cursor (l_cursor);
1926: END IF;

Line 1923: dbms_sql.column_value (l_cursor,1,l_dummy);

1919: dbms_sql.bind_variable(l_cursor,'l_cost_center',l_cost_center);
1920: dbms_sql.define_column (l_cursor,1,l_dummy,1);
1921: l_rows := dbms_sql.execute(l_cursor);
1922: l_count := dbms_sql.fetch_rows(l_cursor);
1923: dbms_sql.column_value (l_cursor,1,l_dummy);
1924: IF dbms_sql.is_open (l_cursor) THEN
1925: dbms_sql.close_cursor (l_cursor);
1926: END IF;
1927: IF l_count <> 1 THEN

Line 1924: IF dbms_sql.is_open (l_cursor) THEN

1920: dbms_sql.define_column (l_cursor,1,l_dummy,1);
1921: l_rows := dbms_sql.execute(l_cursor);
1922: l_count := dbms_sql.fetch_rows(l_cursor);
1923: dbms_sql.column_value (l_cursor,1,l_dummy);
1924: IF dbms_sql.is_open (l_cursor) THEN
1925: dbms_sql.close_cursor (l_cursor);
1926: END IF;
1927: IF l_count <> 1 THEN
1928: RETURN false;

Line 1925: dbms_sql.close_cursor (l_cursor);

1921: l_rows := dbms_sql.execute(l_cursor);
1922: l_count := dbms_sql.fetch_rows(l_cursor);
1923: dbms_sql.column_value (l_cursor,1,l_dummy);
1924: IF dbms_sql.is_open (l_cursor) THEN
1925: dbms_sql.close_cursor (l_cursor);
1926: END IF;
1927: IF l_count <> 1 THEN
1928: RETURN false;
1929: END IF;