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

Line 1257: cur_wal := dbms_sql.open_cursor;

1253: 'and service_package_id = ' || l_service_package_id || ' ' ||
1254: 'and budget_year_id = ' || p_budget_year_id || ' ' ||
1255: 'and code_combination_id = ' || l_ccid;
1256:
1257: cur_wal := dbms_sql.open_cursor;
1258: dbms_sql.parse(cur_wal, sql_wal, dbms_sql.v7);
1259:
1260: dbms_sql.define_column(cur_wal, 1, l_spal_id);
1261: dbms_sql.define_column(cur_wal, 2, l_spal_budget_group_id);

Line 1258: dbms_sql.parse(cur_wal, sql_wal, dbms_sql.v7);

1254: 'and budget_year_id = ' || p_budget_year_id || ' ' ||
1255: 'and code_combination_id = ' || l_ccid;
1256:
1257: cur_wal := dbms_sql.open_cursor;
1258: dbms_sql.parse(cur_wal, sql_wal, dbms_sql.v7);
1259:
1260: dbms_sql.define_column(cur_wal, 1, l_spal_id);
1261: dbms_sql.define_column(cur_wal, 2, l_spal_budget_group_id);
1262: dbms_sql.define_column(cur_wal, 3, l_spytd_amount);

Line 1260: dbms_sql.define_column(cur_wal, 1, l_spal_id);

1256:
1257: cur_wal := dbms_sql.open_cursor;
1258: dbms_sql.parse(cur_wal, sql_wal, dbms_sql.v7);
1259:
1260: dbms_sql.define_column(cur_wal, 1, l_spal_id);
1261: dbms_sql.define_column(cur_wal, 2, l_spal_budget_group_id);
1262: dbms_sql.define_column(cur_wal, 3, l_spytd_amount);
1263: -- Bug 3347507
1264: dbms_sql.define_column(cur_wal, 4, l_original_start_stage_seq);

Line 1261: dbms_sql.define_column(cur_wal, 2, l_spal_budget_group_id);

1257: cur_wal := dbms_sql.open_cursor;
1258: dbms_sql.parse(cur_wal, sql_wal, dbms_sql.v7);
1259:
1260: dbms_sql.define_column(cur_wal, 1, l_spal_id);
1261: dbms_sql.define_column(cur_wal, 2, l_spal_budget_group_id);
1262: dbms_sql.define_column(cur_wal, 3, l_spytd_amount);
1263: -- Bug 3347507
1264: dbms_sql.define_column(cur_wal, 4, l_original_start_stage_seq);
1265:

Line 1262: dbms_sql.define_column(cur_wal, 3, l_spytd_amount);

1258: dbms_sql.parse(cur_wal, sql_wal, dbms_sql.v7);
1259:
1260: dbms_sql.define_column(cur_wal, 1, l_spal_id);
1261: dbms_sql.define_column(cur_wal, 2, l_spal_budget_group_id);
1262: dbms_sql.define_column(cur_wal, 3, l_spytd_amount);
1263: -- Bug 3347507
1264: dbms_sql.define_column(cur_wal, 4, l_original_start_stage_seq);
1265:
1266: num_wal := dbms_sql.execute(cur_wal);

Line 1264: dbms_sql.define_column(cur_wal, 4, l_original_start_stage_seq);

1260: dbms_sql.define_column(cur_wal, 1, l_spal_id);
1261: dbms_sql.define_column(cur_wal, 2, l_spal_budget_group_id);
1262: dbms_sql.define_column(cur_wal, 3, l_spytd_amount);
1263: -- Bug 3347507
1264: dbms_sql.define_column(cur_wal, 4, l_original_start_stage_seq);
1265:
1266: num_wal := dbms_sql.execute(cur_wal);
1267:
1268: loop

Line 1266: num_wal := dbms_sql.execute(cur_wal);

1262: dbms_sql.define_column(cur_wal, 3, l_spytd_amount);
1263: -- Bug 3347507
1264: dbms_sql.define_column(cur_wal, 4, l_original_start_stage_seq);
1265:
1266: num_wal := dbms_sql.execute(cur_wal);
1267:
1268: loop
1269:
1270: if dbms_sql.fetch_rows(cur_wal) = 0 then

Line 1270: if dbms_sql.fetch_rows(cur_wal) = 0 then

1266: num_wal := dbms_sql.execute(cur_wal);
1267:
1268: loop
1269:
1270: if dbms_sql.fetch_rows(cur_wal) = 0 then
1271: exit;
1272: end if;
1273:
1274: dbms_sql.column_value(cur_wal, 1, l_spal_id);

Line 1274: dbms_sql.column_value(cur_wal, 1, l_spal_id);

1270: if dbms_sql.fetch_rows(cur_wal) = 0 then
1271: exit;
1272: end if;
1273:
1274: dbms_sql.column_value(cur_wal, 1, l_spal_id);
1275: dbms_sql.column_value(cur_wal, 2, l_spal_budget_group_id);
1276: dbms_sql.column_value(cur_wal, 3, l_spytd_amount);
1277: -- Bug 3347507
1278: dbms_sql.column_value(cur_wal, 4, l_original_start_stage_seq);

Line 1275: dbms_sql.column_value(cur_wal, 2, l_spal_budget_group_id);

1271: exit;
1272: end if;
1273:
1274: dbms_sql.column_value(cur_wal, 1, l_spal_id);
1275: dbms_sql.column_value(cur_wal, 2, l_spal_budget_group_id);
1276: dbms_sql.column_value(cur_wal, 3, l_spytd_amount);
1277: -- Bug 3347507
1278: dbms_sql.column_value(cur_wal, 4, l_original_start_stage_seq);
1279:

Line 1276: dbms_sql.column_value(cur_wal, 3, l_spytd_amount);

1272: end if;
1273:
1274: dbms_sql.column_value(cur_wal, 1, l_spal_id);
1275: dbms_sql.column_value(cur_wal, 2, l_spal_budget_group_id);
1276: dbms_sql.column_value(cur_wal, 3, l_spytd_amount);
1277: -- Bug 3347507
1278: dbms_sql.column_value(cur_wal, 4, l_original_start_stage_seq);
1279:
1280: l_spal_exists := TRUE;

Line 1278: dbms_sql.column_value(cur_wal, 4, l_original_start_stage_seq);

1274: dbms_sql.column_value(cur_wal, 1, l_spal_id);
1275: dbms_sql.column_value(cur_wal, 2, l_spal_budget_group_id);
1276: dbms_sql.column_value(cur_wal, 3, l_spytd_amount);
1277: -- Bug 3347507
1278: dbms_sql.column_value(cur_wal, 4, l_original_start_stage_seq);
1279:
1280: l_spal_exists := TRUE;
1281:
1282: end loop;

Line 1284: dbms_sql.close_cursor(cur_wal);

1280: l_spal_exists := TRUE;
1281:
1282: end loop;
1283:
1284: dbms_sql.close_cursor(cur_wal);
1285:
1286: if l_spal_budget_group_id <> p_budget_group_id then
1287: l_budget_group_changed := TRUE;
1288: end if;

Line 2804: cur_wal := dbms_sql.open_cursor;

2800: 'and budget_year_id = ' || l_budget_year_id || ' ' ||
2801: 'and budget_group_id = ' || l_budget_group_id || ' ' ||
2802: 'and code_combination_id = ' || l_ccid;
2803:
2804: cur_wal := dbms_sql.open_cursor;
2805: dbms_sql.parse(cur_wal, sql_wal, dbms_sql.v7);
2806:
2807: dbms_sql.define_column(cur_wal, 1, l_spal_id);
2808: dbms_sql.define_column(cur_wal, 2, l_spytd_amount);

Line 2805: dbms_sql.parse(cur_wal, sql_wal, dbms_sql.v7);

2801: 'and budget_group_id = ' || l_budget_group_id || ' ' ||
2802: 'and code_combination_id = ' || l_ccid;
2803:
2804: cur_wal := dbms_sql.open_cursor;
2805: dbms_sql.parse(cur_wal, sql_wal, dbms_sql.v7);
2806:
2807: dbms_sql.define_column(cur_wal, 1, l_spal_id);
2808: dbms_sql.define_column(cur_wal, 2, l_spytd_amount);
2809:

Line 2807: dbms_sql.define_column(cur_wal, 1, l_spal_id);

2803:
2804: cur_wal := dbms_sql.open_cursor;
2805: dbms_sql.parse(cur_wal, sql_wal, dbms_sql.v7);
2806:
2807: dbms_sql.define_column(cur_wal, 1, l_spal_id);
2808: dbms_sql.define_column(cur_wal, 2, l_spytd_amount);
2809:
2810: num_wal := dbms_sql.execute(cur_wal);
2811:

Line 2808: dbms_sql.define_column(cur_wal, 2, l_spytd_amount);

2804: cur_wal := dbms_sql.open_cursor;
2805: dbms_sql.parse(cur_wal, sql_wal, dbms_sql.v7);
2806:
2807: dbms_sql.define_column(cur_wal, 1, l_spal_id);
2808: dbms_sql.define_column(cur_wal, 2, l_spytd_amount);
2809:
2810: num_wal := dbms_sql.execute(cur_wal);
2811:
2812: loop

Line 2810: num_wal := dbms_sql.execute(cur_wal);

2806:
2807: dbms_sql.define_column(cur_wal, 1, l_spal_id);
2808: dbms_sql.define_column(cur_wal, 2, l_spytd_amount);
2809:
2810: num_wal := dbms_sql.execute(cur_wal);
2811:
2812: loop
2813:
2814: if dbms_sql.fetch_rows(cur_wal) = 0 then

Line 2814: if dbms_sql.fetch_rows(cur_wal) = 0 then

2810: num_wal := dbms_sql.execute(cur_wal);
2811:
2812: loop
2813:
2814: if dbms_sql.fetch_rows(cur_wal) = 0 then
2815: exit;
2816: end if;
2817:
2818: dbms_sql.column_value(cur_wal, 1, l_spal_id);

Line 2818: dbms_sql.column_value(cur_wal, 1, l_spal_id);

2814: if dbms_sql.fetch_rows(cur_wal) = 0 then
2815: exit;
2816: end if;
2817:
2818: dbms_sql.column_value(cur_wal, 1, l_spal_id);
2819: dbms_sql.column_value(cur_wal, 2, l_spytd_amount);
2820:
2821: l_spal_exists := TRUE;
2822:

Line 2819: dbms_sql.column_value(cur_wal, 2, l_spytd_amount);

2815: exit;
2816: end if;
2817:
2818: dbms_sql.column_value(cur_wal, 1, l_spal_id);
2819: dbms_sql.column_value(cur_wal, 2, l_spytd_amount);
2820:
2821: l_spal_exists := TRUE;
2822:
2823: end loop;

Line 2825: dbms_sql.close_cursor(cur_wal);

2821: l_spal_exists := TRUE;
2822:
2823: end loop;
2824:
2825: dbms_sql.close_cursor(cur_wal);
2826:
2827: end;
2828: end if;
2829:

Line 3998: if dbms_sql.is_open(cur_wsacc) then

3994:
3995: when OTHERS then
3996: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3997:
3998: if dbms_sql.is_open(cur_wsacc) then
3999: dbms_sql.close_cursor(cur_wsacc);
4000: end if;
4001:
4002: if FND_MSG_PUB.Check_Msg_Level

Line 3999: dbms_sql.close_cursor(cur_wsacc);

3995: when OTHERS then
3996: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3997:
3998: if dbms_sql.is_open(cur_wsacc) then
3999: dbms_sql.close_cursor(cur_wsacc);
4000: end if;
4001:
4002: if FND_MSG_PUB.Check_Msg_Level
4003: (p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

Line 4924: cursornum := dbms_sql.open_cursor;

4920: nprocessed INTEGER;
4921:
4922: BEGIN
4923:
4924: cursornum := dbms_sql.open_cursor;
4925: dbms_sql.parse(cursornum, sql_statement, dbms_sql.v7);
4926: nprocessed := dbms_sql.execute(cursornum);
4927: dbms_sql.close_cursor(cursornum);
4928: return(nprocessed);

Line 4925: dbms_sql.parse(cursornum, sql_statement, dbms_sql.v7);

4921:
4922: BEGIN
4923:
4924: cursornum := dbms_sql.open_cursor;
4925: dbms_sql.parse(cursornum, sql_statement, dbms_sql.v7);
4926: nprocessed := dbms_sql.execute(cursornum);
4927: dbms_sql.close_cursor(cursornum);
4928: return(nprocessed);
4929:

Line 4926: nprocessed := dbms_sql.execute(cursornum);

4922: BEGIN
4923:
4924: cursornum := dbms_sql.open_cursor;
4925: dbms_sql.parse(cursornum, sql_statement, dbms_sql.v7);
4926: nprocessed := dbms_sql.execute(cursornum);
4927: dbms_sql.close_cursor(cursornum);
4928: return(nprocessed);
4929:
4930:

Line 4927: dbms_sql.close_cursor(cursornum);

4923:
4924: cursornum := dbms_sql.open_cursor;
4925: dbms_sql.parse(cursornum, sql_statement, dbms_sql.v7);
4926: nprocessed := dbms_sql.execute(cursornum);
4927: dbms_sql.close_cursor(cursornum);
4928: return(nprocessed);
4929:
4930:
4931: EXCEPTION

Line 4935: if dbms_sql.is_open(cursornum) then

4931: EXCEPTION
4932:
4933: when OTHERS then
4934:
4935: if dbms_sql.is_open(cursornum) then
4936: dbms_sql.close_cursor(cursornum);
4937: end if;
4938:
4939: -- Dynamic SQL Exception

Line 4936: dbms_sql.close_cursor(cursornum);

4932:
4933: when OTHERS then
4934:
4935: if dbms_sql.is_open(cursornum) then
4936: dbms_sql.close_cursor(cursornum);
4937: end if;
4938:
4939: -- Dynamic SQL Exception
4940: