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_FP_GEN_AMT_WRP_PKG dependencies on DBMS_SQL

Line 107: sql_cursor := DBMS_SQL.OPEN_CURSOR;

103: l_fin_plan_type_err_token := FND_MESSAGE.GET;
104:
105: retcode := '0';
106:
107: sql_cursor := DBMS_SQL.OPEN_CURSOR;
108: l_sel_clause := ' SELECT distinct pj.project_id, opt.fin_plan_type_id,'
109: ||' opt.FIN_PLAN_PREFERENCE_CODE,pt.PLAN_CLASS_CODE'
110: ||',pj.name';
111:

Line 230: DBMS_SQL.PARSE(sql_cursor, l_stmt, dbms_sql.v7);

226: hr_utility.trace('Where Clause1 : ' || l_where_clause1);
227: hr_utility.trace('Where Clause2 : ' || l_where_clause2);
228: hr_utility.trace('Dynamic SQL ' || l_stmt); */
229:
230: DBMS_SQL.PARSE(sql_cursor, l_stmt, dbms_sql.v7);
231:
232: -- SQL Repository Bugs 4884427, 5112175;
233: -- SQL IDs 14901706, 14901662, 16507224, 16507225, 16507275
234: -- Bind values to the new bind variables.

Line 236: DBMS_SQL.BIND_VARIABLE(sql_cursor, ':organization_id', p_organization_id);

232: -- SQL Repository Bugs 4884427, 5112175;
233: -- SQL IDs 14901706, 14901662, 16507224, 16507225, 16507275
234: -- Bind values to the new bind variables.
235: IF (P_ORGANIZATION_ID) IS NOT NULL THEN
236: DBMS_SQL.BIND_VARIABLE(sql_cursor, ':organization_id', p_organization_id);
237: END IF;
238: IF (P_PROJECT_TYPE_ID IS NOT NULL) THEN
239: DBMS_SQL.BIND_VARIABLE(sql_cursor, ':project_type_id', p_project_type_id);
240: END IF;

Line 239: DBMS_SQL.BIND_VARIABLE(sql_cursor, ':project_type_id', p_project_type_id);

235: IF (P_ORGANIZATION_ID) IS NOT NULL THEN
236: DBMS_SQL.BIND_VARIABLE(sql_cursor, ':organization_id', p_organization_id);
237: END IF;
238: IF (P_PROJECT_TYPE_ID IS NOT NULL) THEN
239: DBMS_SQL.BIND_VARIABLE(sql_cursor, ':project_type_id', p_project_type_id);
240: END IF;
241: IF (p_proj_manager_id IS NOT NULL) THEN
242: DBMS_SQL.BIND_VARIABLE(sql_cursor, ':proj_manager_id', p_proj_manager_id);
243: END IF;

Line 242: DBMS_SQL.BIND_VARIABLE(sql_cursor, ':proj_manager_id', p_proj_manager_id);

238: IF (P_PROJECT_TYPE_ID IS NOT NULL) THEN
239: DBMS_SQL.BIND_VARIABLE(sql_cursor, ':project_type_id', p_project_type_id);
240: END IF;
241: IF (p_proj_manager_id IS NOT NULL) THEN
242: DBMS_SQL.BIND_VARIABLE(sql_cursor, ':proj_manager_id', p_proj_manager_id);
243: END IF;
244: IF (P_PLAN_TYPE_ID) IS NOT NULL THEN
245: DBMS_SQL.BIND_VARIABLE(sql_cursor, ':plan_type_id', p_plan_type_id);
246: END IF;

Line 245: DBMS_SQL.BIND_VARIABLE(sql_cursor, ':plan_type_id', p_plan_type_id);

241: IF (p_proj_manager_id IS NOT NULL) THEN
242: DBMS_SQL.BIND_VARIABLE(sql_cursor, ':proj_manager_id', p_proj_manager_id);
243: END IF;
244: IF (P_PLAN_TYPE_ID) IS NOT NULL THEN
245: DBMS_SQL.BIND_VARIABLE(sql_cursor, ':plan_type_id', p_plan_type_id);
246: END IF;
247: DBMS_SQL.BIND_VARIABLE(sql_cursor, ':from_proj_no', l_from_proj_no);
248: DBMS_SQL.BIND_VARIABLE(sql_cursor, ':to_proj_no', l_to_proj_no);
249:

Line 247: DBMS_SQL.BIND_VARIABLE(sql_cursor, ':from_proj_no', l_from_proj_no);

243: END IF;
244: IF (P_PLAN_TYPE_ID) IS NOT NULL THEN
245: DBMS_SQL.BIND_VARIABLE(sql_cursor, ':plan_type_id', p_plan_type_id);
246: END IF;
247: DBMS_SQL.BIND_VARIABLE(sql_cursor, ':from_proj_no', l_from_proj_no);
248: DBMS_SQL.BIND_VARIABLE(sql_cursor, ':to_proj_no', l_to_proj_no);
249:
250: l_rows := DBMS_SQL.EXECUTE (sql_cursor);
251:

Line 248: DBMS_SQL.BIND_VARIABLE(sql_cursor, ':to_proj_no', l_to_proj_no);

244: IF (P_PLAN_TYPE_ID) IS NOT NULL THEN
245: DBMS_SQL.BIND_VARIABLE(sql_cursor, ':plan_type_id', p_plan_type_id);
246: END IF;
247: DBMS_SQL.BIND_VARIABLE(sql_cursor, ':from_proj_no', l_from_proj_no);
248: DBMS_SQL.BIND_VARIABLE(sql_cursor, ':to_proj_no', l_to_proj_no);
249:
250: l_rows := DBMS_SQL.EXECUTE (sql_cursor);
251:
252: --dbms_output.put_line('After execute, l_rows is: '||l_rows);

Line 250: l_rows := DBMS_SQL.EXECUTE (sql_cursor);

246: END IF;
247: DBMS_SQL.BIND_VARIABLE(sql_cursor, ':from_proj_no', l_from_proj_no);
248: DBMS_SQL.BIND_VARIABLE(sql_cursor, ':to_proj_no', l_to_proj_no);
249:
250: l_rows := DBMS_SQL.EXECUTE (sql_cursor);
251:
252: --dbms_output.put_line('After execute, l_rows is: '||l_rows);
253: -- hr_utility.trace('After execute, l_rows is: '||l_rows);
254:

Line 267: DBMS_SQL.DEFINE_COLUMN(sql_cursor, 1, l_proj_id);

263: END IF;
264: RETURN;
265: END IF;
266:
267: DBMS_SQL.DEFINE_COLUMN(sql_cursor, 1, l_proj_id);
268: DBMS_SQL.DEFINE_COLUMN(sql_cursor, 2, l_plan_type_id);
269: DBMS_SQL.DEFINE_COLUMN(sql_cursor, 3, l_fin_plan_preference_code,30);
270: DBMS_SQL.DEFINE_COLUMN(sql_cursor, 4, l_plan_class_code,30);
271: DBMS_SQL.DEFINE_COLUMN(sql_cursor, 5, l_project_name,200);

Line 268: DBMS_SQL.DEFINE_COLUMN(sql_cursor, 2, l_plan_type_id);

264: RETURN;
265: END IF;
266:
267: DBMS_SQL.DEFINE_COLUMN(sql_cursor, 1, l_proj_id);
268: DBMS_SQL.DEFINE_COLUMN(sql_cursor, 2, l_plan_type_id);
269: DBMS_SQL.DEFINE_COLUMN(sql_cursor, 3, l_fin_plan_preference_code,30);
270: DBMS_SQL.DEFINE_COLUMN(sql_cursor, 4, l_plan_class_code,30);
271: DBMS_SQL.DEFINE_COLUMN(sql_cursor, 5, l_project_name,200);
272:

Line 269: DBMS_SQL.DEFINE_COLUMN(sql_cursor, 3, l_fin_plan_preference_code,30);

265: END IF;
266:
267: DBMS_SQL.DEFINE_COLUMN(sql_cursor, 1, l_proj_id);
268: DBMS_SQL.DEFINE_COLUMN(sql_cursor, 2, l_plan_type_id);
269: DBMS_SQL.DEFINE_COLUMN(sql_cursor, 3, l_fin_plan_preference_code,30);
270: DBMS_SQL.DEFINE_COLUMN(sql_cursor, 4, l_plan_class_code,30);
271: DBMS_SQL.DEFINE_COLUMN(sql_cursor, 5, l_project_name,200);
272:
273: LOOP

Line 270: DBMS_SQL.DEFINE_COLUMN(sql_cursor, 4, l_plan_class_code,30);

266:
267: DBMS_SQL.DEFINE_COLUMN(sql_cursor, 1, l_proj_id);
268: DBMS_SQL.DEFINE_COLUMN(sql_cursor, 2, l_plan_type_id);
269: DBMS_SQL.DEFINE_COLUMN(sql_cursor, 3, l_fin_plan_preference_code,30);
270: DBMS_SQL.DEFINE_COLUMN(sql_cursor, 4, l_plan_class_code,30);
271: DBMS_SQL.DEFINE_COLUMN(sql_cursor, 5, l_project_name,200);
272:
273: LOOP
274: l_rows1 := DBMS_SQL.FETCH_ROWS(sql_cursor);

Line 271: DBMS_SQL.DEFINE_COLUMN(sql_cursor, 5, l_project_name,200);

267: DBMS_SQL.DEFINE_COLUMN(sql_cursor, 1, l_proj_id);
268: DBMS_SQL.DEFINE_COLUMN(sql_cursor, 2, l_plan_type_id);
269: DBMS_SQL.DEFINE_COLUMN(sql_cursor, 3, l_fin_plan_preference_code,30);
270: DBMS_SQL.DEFINE_COLUMN(sql_cursor, 4, l_plan_class_code,30);
271: DBMS_SQL.DEFINE_COLUMN(sql_cursor, 5, l_project_name,200);
272:
273: LOOP
274: l_rows1 := DBMS_SQL.FETCH_ROWS(sql_cursor);
275: --dbms_output.put_line('l_rows1 value inside the loop is : ' || l_rows1);

Line 274: l_rows1 := DBMS_SQL.FETCH_ROWS(sql_cursor);

270: DBMS_SQL.DEFINE_COLUMN(sql_cursor, 4, l_plan_class_code,30);
271: DBMS_SQL.DEFINE_COLUMN(sql_cursor, 5, l_project_name,200);
272:
273: LOOP
274: l_rows1 := DBMS_SQL.FETCH_ROWS(sql_cursor);
275: --dbms_output.put_line('l_rows1 value inside the loop is : ' || l_rows1);
276: --hr_utility.trace('l_rows1 value inside the loop is : ' || l_rows1);
277: IF l_rows1 = 0 then
278: EXIT;

Line 280: DBMS_SQL.COLUMN_VALUE(sql_cursor,1,l_proj_id);

276: --hr_utility.trace('l_rows1 value inside the loop is : ' || l_rows1);
277: IF l_rows1 = 0 then
278: EXIT;
279: END IF;
280: DBMS_SQL.COLUMN_VALUE(sql_cursor,1,l_proj_id);
281: DBMS_SQL.COLUMN_VALUE(sql_cursor,2,l_plan_type_id);
282: DBMS_SQL.COLUMN_VALUE(sql_cursor,3,l_fin_plan_preference_code);
283: DBMS_SQL.COLUMN_VALUE(sql_cursor,4,l_plan_class_code);
284: DBMS_SQL.COLUMN_VALUE(sql_cursor,5,l_project_name);

Line 281: DBMS_SQL.COLUMN_VALUE(sql_cursor,2,l_plan_type_id);

277: IF l_rows1 = 0 then
278: EXIT;
279: END IF;
280: DBMS_SQL.COLUMN_VALUE(sql_cursor,1,l_proj_id);
281: DBMS_SQL.COLUMN_VALUE(sql_cursor,2,l_plan_type_id);
282: DBMS_SQL.COLUMN_VALUE(sql_cursor,3,l_fin_plan_preference_code);
283: DBMS_SQL.COLUMN_VALUE(sql_cursor,4,l_plan_class_code);
284: DBMS_SQL.COLUMN_VALUE(sql_cursor,5,l_project_name);
285:

Line 282: DBMS_SQL.COLUMN_VALUE(sql_cursor,3,l_fin_plan_preference_code);

278: EXIT;
279: END IF;
280: DBMS_SQL.COLUMN_VALUE(sql_cursor,1,l_proj_id);
281: DBMS_SQL.COLUMN_VALUE(sql_cursor,2,l_plan_type_id);
282: DBMS_SQL.COLUMN_VALUE(sql_cursor,3,l_fin_plan_preference_code);
283: DBMS_SQL.COLUMN_VALUE(sql_cursor,4,l_plan_class_code);
284: DBMS_SQL.COLUMN_VALUE(sql_cursor,5,l_project_name);
285:
286: --dbms_output.put_line('====l_proj_id is : ' || l_proj_id);

Line 283: DBMS_SQL.COLUMN_VALUE(sql_cursor,4,l_plan_class_code);

279: END IF;
280: DBMS_SQL.COLUMN_VALUE(sql_cursor,1,l_proj_id);
281: DBMS_SQL.COLUMN_VALUE(sql_cursor,2,l_plan_type_id);
282: DBMS_SQL.COLUMN_VALUE(sql_cursor,3,l_fin_plan_preference_code);
283: DBMS_SQL.COLUMN_VALUE(sql_cursor,4,l_plan_class_code);
284: DBMS_SQL.COLUMN_VALUE(sql_cursor,5,l_project_name);
285:
286: --dbms_output.put_line('====l_proj_id is : ' || l_proj_id);
287: --dbms_output.put_line('====l_plan_type_id is : ' || l_plan_type_id);

Line 284: DBMS_SQL.COLUMN_VALUE(sql_cursor,5,l_project_name);

280: DBMS_SQL.COLUMN_VALUE(sql_cursor,1,l_proj_id);
281: DBMS_SQL.COLUMN_VALUE(sql_cursor,2,l_plan_type_id);
282: DBMS_SQL.COLUMN_VALUE(sql_cursor,3,l_fin_plan_preference_code);
283: DBMS_SQL.COLUMN_VALUE(sql_cursor,4,l_plan_class_code);
284: DBMS_SQL.COLUMN_VALUE(sql_cursor,5,l_project_name);
285:
286: --dbms_output.put_line('====l_proj_id is : ' || l_proj_id);
287: --dbms_output.put_line('====l_plan_type_id is : ' || l_plan_type_id);
288: --dbms_output.put_line('====l_fin_plan_preference_code is : ' || l_fin_plan_preference_code);

Line 1189: DBMS_SQL.CLOSE_CURSOR(sql_cursor); -- Bug 5715252 Cursor is closed

1185:
1186: END LOOP;
1187: END LOOP;
1188:
1189: DBMS_SQL.CLOSE_CURSOR(sql_cursor); -- Bug 5715252 Cursor is closed
1190:
1191: IF P_PA_DEBUG_MODE = 'Y' THEN
1192: PA_DEBUG.RESET_CURR_FUNCTION;
1193: END IF;

Line 1229: IF DBMS_SQL.IS_OPEN(sql_cursor) THEN

1225: retcode := '2';
1226: errbuff := substr(sqlerrm,1,240);
1227:
1228: /* Start Bug 5715252 */
1229: IF DBMS_SQL.IS_OPEN(sql_cursor) THEN
1230: DBMS_SQL.CLOSE_CURSOR(sql_cursor);
1231: END IF;
1232: /* End Bug 5715252 */
1233:

Line 1230: DBMS_SQL.CLOSE_CURSOR(sql_cursor);

1226: errbuff := substr(sqlerrm,1,240);
1227:
1228: /* Start Bug 5715252 */
1229: IF DBMS_SQL.IS_OPEN(sql_cursor) THEN
1230: DBMS_SQL.CLOSE_CURSOR(sql_cursor);
1231: END IF;
1232: /* End Bug 5715252 */
1233:
1234: RAISE;

Line 1259: IF DBMS_SQL.IS_OPEN(sql_cursor) THEN

1255: retcode := '2';
1256: errbuff := substr(sqlerrm,1,240);
1257:
1258: /* Start Bug 5715252 */
1259: IF DBMS_SQL.IS_OPEN(sql_cursor) THEN
1260: DBMS_SQL.CLOSE_CURSOR(sql_cursor);
1261: END IF;
1262: /* End Bug 5715252 */
1263:

Line 1260: DBMS_SQL.CLOSE_CURSOR(sql_cursor);

1256: errbuff := substr(sqlerrm,1,240);
1257:
1258: /* Start Bug 5715252 */
1259: IF DBMS_SQL.IS_OPEN(sql_cursor) THEN
1260: DBMS_SQL.CLOSE_CURSOR(sql_cursor);
1261: END IF;
1262: /* End Bug 5715252 */
1263:
1264: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;