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 10257: l_cursor_id := DBMS_SQL.open_cursor;

10253:
10254: l_statement := l_statement ||
10255: ' WHERE BUDGET_VERSION_ID = '||TO_CHAR(l_budget_version_id);
10256:
10257: l_cursor_id := DBMS_SQL.open_cursor;
10258: DBMS_SQL.parse(l_cursor_id, l_statement, DBMS_SQL.native);
10259:
10260: IF (p_description <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR OR p_description IS NULL)
10261: AND nvl(p_description,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) <>

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

10254: l_statement := l_statement ||
10255: ' WHERE BUDGET_VERSION_ID = '||TO_CHAR(l_budget_version_id);
10256:
10257: l_cursor_id := DBMS_SQL.open_cursor;
10258: DBMS_SQL.parse(l_cursor_id, l_statement, DBMS_SQL.native);
10259:
10260: IF (p_description <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR OR p_description IS NULL)
10261: AND nvl(p_description,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) <>
10262: nvl(l_description,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)

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

10260: IF (p_description <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR OR p_description IS NULL)
10261: AND nvl(p_description,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) <>
10262: nvl(l_description,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
10263: THEN
10264: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':xDescription', p_description);
10265:
10266: END IF;
10267:
10268: IF (p_change_reason_code <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR OR p_change_reason_code IS NULL)

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

10268: IF (p_change_reason_code <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR OR p_change_reason_code IS NULL)
10269: AND nvl(p_change_reason_code,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) <>
10270: nvl(l_change_reason_code,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
10271: THEN
10272: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':xChangeReasonCode', p_change_reason_code);
10273:
10274: END IF;
10275:
10276:

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

10362: IF (p_budget_version_name <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR OR p_budget_version_name IS NULL)
10363: AND nvl(p_budget_version_name,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) <>
10364: nvl(l_budget_version_name,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
10365: THEN
10366: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':xBudgetVersionName', lx_budget_version_name);
10367:
10368: END IF;
10369: /*Addition for the bug 3453650 ends */
10370:

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

10367:
10368: END IF;
10369: /*Addition for the bug 3453650 ends */
10370:
10371: l_rows := DBMS_SQL.execute(l_cursor_id);
10372:
10373: IF DBMS_SQL.is_open (l_cursor_id)
10374: THEN
10375: DBMS_SQL.close_cursor (l_cursor_id);

Line 10373: IF DBMS_SQL.is_open (l_cursor_id)

10369: /*Addition for the bug 3453650 ends */
10370:
10371: l_rows := DBMS_SQL.execute(l_cursor_id);
10372:
10373: IF DBMS_SQL.is_open (l_cursor_id)
10374: THEN
10375: DBMS_SQL.close_cursor (l_cursor_id);
10376: END IF;
10377:

Line 10375: DBMS_SQL.close_cursor (l_cursor_id);

10371: l_rows := DBMS_SQL.execute(l_cursor_id);
10372:
10373: IF DBMS_SQL.is_open (l_cursor_id)
10374: THEN
10375: DBMS_SQL.close_cursor (l_cursor_id);
10376: END IF;
10377:
10378: END IF;
10379: