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

Line 10440: l_cursor_id := DBMS_SQL.open_cursor;

10436:
10437: l_statement := l_statement ||
10438: ' WHERE BUDGET_VERSION_ID = '||TO_CHAR(l_budget_version_id);
10439:
10440: l_cursor_id := DBMS_SQL.open_cursor;
10441: DBMS_SQL.parse(l_cursor_id, l_statement, DBMS_SQL.native);
10442:
10443: IF (p_description <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR OR p_description IS NULL)
10444: AND nvl(p_description,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) <>

Line 10441: DBMS_SQL.parse(l_cursor_id, l_statement, DBMS_SQL.native);

10437: l_statement := l_statement ||
10438: ' WHERE BUDGET_VERSION_ID = '||TO_CHAR(l_budget_version_id);
10439:
10440: l_cursor_id := DBMS_SQL.open_cursor;
10441: DBMS_SQL.parse(l_cursor_id, l_statement, DBMS_SQL.native);
10442:
10443: IF (p_description <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR OR p_description IS NULL)
10444: AND nvl(p_description,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) <>
10445: nvl(l_description,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)

Line 10447: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':xDescription', p_description);

10443: IF (p_description <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR OR p_description IS NULL)
10444: AND nvl(p_description,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) <>
10445: nvl(l_description,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
10446: THEN
10447: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':xDescription', p_description);
10448:
10449: END IF;
10450:
10451: IF (p_change_reason_code <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR OR p_change_reason_code IS NULL)

Line 10455: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':xChangeReasonCode', p_change_reason_code);

10451: IF (p_change_reason_code <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR OR p_change_reason_code IS NULL)
10452: AND nvl(p_change_reason_code,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) <>
10453: nvl(l_change_reason_code,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
10454: THEN
10455: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':xChangeReasonCode', p_change_reason_code);
10456:
10457: END IF;
10458:
10459:

Line 10549: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':xBudgetVersionName', lx_budget_version_name);

10545: IF (p_budget_version_name <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR OR p_budget_version_name IS NULL)
10546: AND nvl(p_budget_version_name,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) <>
10547: nvl(l_budget_version_name,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
10548: THEN
10549: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':xBudgetVersionName', lx_budget_version_name);
10550:
10551: END IF;
10552: /*Addition for the bug 3453650 ends */
10553:

Line 10554: l_rows := DBMS_SQL.execute(l_cursor_id);

10550:
10551: END IF;
10552: /*Addition for the bug 3453650 ends */
10553:
10554: l_rows := DBMS_SQL.execute(l_cursor_id);
10555:
10556: IF DBMS_SQL.is_open (l_cursor_id)
10557: THEN
10558: DBMS_SQL.close_cursor (l_cursor_id);

Line 10556: IF DBMS_SQL.is_open (l_cursor_id)

10552: /*Addition for the bug 3453650 ends */
10553:
10554: l_rows := DBMS_SQL.execute(l_cursor_id);
10555:
10556: IF DBMS_SQL.is_open (l_cursor_id)
10557: THEN
10558: DBMS_SQL.close_cursor (l_cursor_id);
10559: END IF;
10560:

Line 10558: DBMS_SQL.close_cursor (l_cursor_id);

10554: l_rows := DBMS_SQL.execute(l_cursor_id);
10555:
10556: IF DBMS_SQL.is_open (l_cursor_id)
10557: THEN
10558: DBMS_SQL.close_cursor (l_cursor_id);
10559: END IF;
10560:
10561: END IF;
10562: