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

Line 1266: V_cursor_id := DBMS_SQL.OPEN_CURSOR;

1262: END IF;
1263: END IF;
1264: BEGIN
1265: -- Open the cursor for processing
1266: V_cursor_id := DBMS_SQL.OPEN_CURSOR;
1267:
1268: -- Parse the Query
1269:
1270: DBMS_SQL.PARSE(v_cursor_id,l_sql_stmt,DBMS_SQL.V7);

Line 1270: DBMS_SQL.PARSE(v_cursor_id,l_sql_stmt,DBMS_SQL.V7);

1266: V_cursor_id := DBMS_SQL.OPEN_CURSOR;
1267:
1268: -- Parse the Query
1269:
1270: DBMS_SQL.PARSE(v_cursor_id,l_sql_stmt,DBMS_SQL.V7);
1271:
1272: IF P_ACTIVITY_NAME IS NOT NULL THEN
1273: OPEN Cur_Actcol_wf;
1274: LOOP

Line 1281: DBMS_SQL.DEFINE_COLUMN_CHAR(v_cursor_id,l_column_count,l_column_value1,240);

1277: l_column_count := l_column_count + 1;
1278: IF l_column_count = 1 THEN
1279: l_column_name1 := l_temp_col_name;
1280: l_column_prompt1 := l_temp_prompt;
1281: DBMS_SQL.DEFINE_COLUMN_CHAR(v_cursor_id,l_column_count,l_column_value1,240);
1282: ELSIF l_column_count = 2 THEN
1283: l_column_name2:=l_temp_col_name;
1284: l_column_prompt2 := l_temp_prompt;
1285: DBMS_SQL.DEFINE_COLUMN_CHAR(v_cursor_id,l_column_count,l_column_value2,240);

Line 1285: DBMS_SQL.DEFINE_COLUMN_CHAR(v_cursor_id,l_column_count,l_column_value2,240);

1281: DBMS_SQL.DEFINE_COLUMN_CHAR(v_cursor_id,l_column_count,l_column_value1,240);
1282: ELSIF l_column_count = 2 THEN
1283: l_column_name2:=l_temp_col_name;
1284: l_column_prompt2 := l_temp_prompt;
1285: DBMS_SQL.DEFINE_COLUMN_CHAR(v_cursor_id,l_column_count,l_column_value2,240);
1286: ELSIF l_column_count = 3 THEN
1287: l_column_name3:=l_temp_col_name;
1288: l_column_prompt3 := l_temp_prompt;
1289: DBMS_SQL.DEFINE_COLUMN_CHAR(v_cursor_id,l_column_count,l_column_value3,240);

Line 1289: DBMS_SQL.DEFINE_COLUMN_CHAR(v_cursor_id,l_column_count,l_column_value3,240);

1285: DBMS_SQL.DEFINE_COLUMN_CHAR(v_cursor_id,l_column_count,l_column_value2,240);
1286: ELSIF l_column_count = 3 THEN
1287: l_column_name3:=l_temp_col_name;
1288: l_column_prompt3 := l_temp_prompt;
1289: DBMS_SQL.DEFINE_COLUMN_CHAR(v_cursor_id,l_column_count,l_column_value3,240);
1290: ELSIF l_column_count = 4 THEN
1291: l_column_name4:=l_temp_col_name;
1292: l_column_prompt4 := l_temp_prompt;
1293: DBMS_SQL.DEFINE_COLUMN_CHAR(v_cursor_id,l_column_count,l_column_value4,240);

Line 1293: DBMS_SQL.DEFINE_COLUMN_CHAR(v_cursor_id,l_column_count,l_column_value4,240);

1289: DBMS_SQL.DEFINE_COLUMN_CHAR(v_cursor_id,l_column_count,l_column_value3,240);
1290: ELSIF l_column_count = 4 THEN
1291: l_column_name4:=l_temp_col_name;
1292: l_column_prompt4 := l_temp_prompt;
1293: DBMS_SQL.DEFINE_COLUMN_CHAR(v_cursor_id,l_column_count,l_column_value4,240);
1294: ELSIF l_column_count = 5 THEN
1295: l_column_name5:=l_temp_col_name;
1296: l_column_prompt5 := l_temp_prompt;
1297: DBMS_SQL.DEFINE_COLUMN_CHAR(v_cursor_id,l_column_count,l_column_value5,240);

Line 1297: DBMS_SQL.DEFINE_COLUMN_CHAR(v_cursor_id,l_column_count,l_column_value5,240);

1293: DBMS_SQL.DEFINE_COLUMN_CHAR(v_cursor_id,l_column_count,l_column_value4,240);
1294: ELSIF l_column_count = 5 THEN
1295: l_column_name5:=l_temp_col_name;
1296: l_column_prompt5 := l_temp_prompt;
1297: DBMS_SQL.DEFINE_COLUMN_CHAR(v_cursor_id,l_column_count,l_column_value5,240);
1298: ELSIF l_column_count = 6 THEN
1299: l_column_name6:=l_temp_col_name;
1300: l_column_prompt6 := l_temp_prompt;
1301: DBMS_SQL.DEFINE_COLUMN_CHAR(v_cursor_id,l_column_count,l_column_value6,240);

Line 1301: DBMS_SQL.DEFINE_COLUMN_CHAR(v_cursor_id,l_column_count,l_column_value6,240);

1297: DBMS_SQL.DEFINE_COLUMN_CHAR(v_cursor_id,l_column_count,l_column_value5,240);
1298: ELSIF l_column_count = 6 THEN
1299: l_column_name6:=l_temp_col_name;
1300: l_column_prompt6 := l_temp_prompt;
1301: DBMS_SQL.DEFINE_COLUMN_CHAR(v_cursor_id,l_column_count,l_column_value6,240);
1302: ELSIF l_column_count = 7 THEN
1303: l_column_name7:=l_temp_col_name;
1304: l_column_prompt7 := l_temp_prompt;
1305: DBMS_SQL.DEFINE_COLUMN_CHAR(v_cursor_id,l_column_count,l_column_value7,240);

Line 1305: DBMS_SQL.DEFINE_COLUMN_CHAR(v_cursor_id,l_column_count,l_column_value7,240);

1301: DBMS_SQL.DEFINE_COLUMN_CHAR(v_cursor_id,l_column_count,l_column_value6,240);
1302: ELSIF l_column_count = 7 THEN
1303: l_column_name7:=l_temp_col_name;
1304: l_column_prompt7 := l_temp_prompt;
1305: DBMS_SQL.DEFINE_COLUMN_CHAR(v_cursor_id,l_column_count,l_column_value7,240);
1306: ELSIF l_column_count = 8 THEN
1307: l_column_name8:=l_temp_col_name;
1308: l_column_prompt8 := l_temp_prompt;
1309: DBMS_SQL.DEFINE_COLUMN_CHAR(v_cursor_id,l_column_count,l_column_value8,240);

Line 1309: DBMS_SQL.DEFINE_COLUMN_CHAR(v_cursor_id,l_column_count,l_column_value8,240);

1305: DBMS_SQL.DEFINE_COLUMN_CHAR(v_cursor_id,l_column_count,l_column_value7,240);
1306: ELSIF l_column_count = 8 THEN
1307: l_column_name8:=l_temp_col_name;
1308: l_column_prompt8 := l_temp_prompt;
1309: DBMS_SQL.DEFINE_COLUMN_CHAR(v_cursor_id,l_column_count,l_column_value8,240);
1310: ELSIF l_column_count = 9 THEN
1311: l_column_name9:=l_temp_col_name;
1312: l_column_prompt9 := l_temp_prompt;
1313: DBMS_SQL.DEFINE_COLUMN_CHAR(v_cursor_id,l_column_count,l_column_value9,240);

Line 1313: DBMS_SQL.DEFINE_COLUMN_CHAR(v_cursor_id,l_column_count,l_column_value9,240);

1309: DBMS_SQL.DEFINE_COLUMN_CHAR(v_cursor_id,l_column_count,l_column_value8,240);
1310: ELSIF l_column_count = 9 THEN
1311: l_column_name9:=l_temp_col_name;
1312: l_column_prompt9 := l_temp_prompt;
1313: DBMS_SQL.DEFINE_COLUMN_CHAR(v_cursor_id,l_column_count,l_column_value9,240);
1314: ELSIF l_column_count = 10 THEN
1315: l_column_name10:=l_temp_col_name;
1316: l_column_prompt10 := l_temp_prompt;
1317: DBMS_SQL.DEFINE_COLUMN_CHAR(v_cursor_id,l_column_count,l_column_value10,240);

Line 1317: DBMS_SQL.DEFINE_COLUMN_CHAR(v_cursor_id,l_column_count,l_column_value10,240);

1313: DBMS_SQL.DEFINE_COLUMN_CHAR(v_cursor_id,l_column_count,l_column_value9,240);
1314: ELSIF l_column_count = 10 THEN
1315: l_column_name10:=l_temp_col_name;
1316: l_column_prompt10 := l_temp_prompt;
1317: DBMS_SQL.DEFINE_COLUMN_CHAR(v_cursor_id,l_column_count,l_column_value10,240);
1318: END IF;
1319: END LOOP;
1320: CLOSE Cur_Actcol_wf;
1321: ELSE

Line 1330: DBMS_SQL.DEFINE_COLUMN_CHAR(v_cursor_id,l_column_count,l_column_value1,240);

1326: l_column_count := l_column_count + 1;
1327: IF l_column_count = 1 THEN
1328: l_column_name1:=l_temp_col_name;
1329: l_column_prompt1 := l_temp_prompt;
1330: DBMS_SQL.DEFINE_COLUMN_CHAR(v_cursor_id,l_column_count,l_column_value1,240);
1331: ELSIF l_column_count = 2 THEN
1332: l_column_name2:=l_temp_col_name;
1333: l_column_prompt2 := l_temp_prompt;
1334: DBMS_SQL.DEFINE_COLUMN_CHAR(v_cursor_id,l_column_count,l_column_value2,240);

Line 1334: DBMS_SQL.DEFINE_COLUMN_CHAR(v_cursor_id,l_column_count,l_column_value2,240);

1330: DBMS_SQL.DEFINE_COLUMN_CHAR(v_cursor_id,l_column_count,l_column_value1,240);
1331: ELSIF l_column_count = 2 THEN
1332: l_column_name2:=l_temp_col_name;
1333: l_column_prompt2 := l_temp_prompt;
1334: DBMS_SQL.DEFINE_COLUMN_CHAR(v_cursor_id,l_column_count,l_column_value2,240);
1335: ELSIF l_column_count = 3 THEN
1336: l_column_name3:=l_temp_col_name;
1337: l_column_prompt3 := l_temp_prompt;
1338: DBMS_SQL.DEFINE_COLUMN_CHAR(v_cursor_id,l_column_count,l_column_value3,240);

Line 1338: DBMS_SQL.DEFINE_COLUMN_CHAR(v_cursor_id,l_column_count,l_column_value3,240);

1334: DBMS_SQL.DEFINE_COLUMN_CHAR(v_cursor_id,l_column_count,l_column_value2,240);
1335: ELSIF l_column_count = 3 THEN
1336: l_column_name3:=l_temp_col_name;
1337: l_column_prompt3 := l_temp_prompt;
1338: DBMS_SQL.DEFINE_COLUMN_CHAR(v_cursor_id,l_column_count,l_column_value3,240);
1339: ELSIF l_column_count = 4 THEN
1340: l_column_name4:=l_temp_col_name;
1341: l_column_prompt4 := l_temp_prompt;
1342: DBMS_SQL.DEFINE_COLUMN_CHAR(v_cursor_id,l_column_count,l_column_value4,240);

Line 1342: DBMS_SQL.DEFINE_COLUMN_CHAR(v_cursor_id,l_column_count,l_column_value4,240);

1338: DBMS_SQL.DEFINE_COLUMN_CHAR(v_cursor_id,l_column_count,l_column_value3,240);
1339: ELSIF l_column_count = 4 THEN
1340: l_column_name4:=l_temp_col_name;
1341: l_column_prompt4 := l_temp_prompt;
1342: DBMS_SQL.DEFINE_COLUMN_CHAR(v_cursor_id,l_column_count,l_column_value4,240);
1343: ELSIF l_column_count = 5 THEN
1344: l_column_name5:=l_temp_col_name;
1345: l_column_prompt5 := l_temp_prompt;
1346: DBMS_SQL.DEFINE_COLUMN_CHAR(v_cursor_id,l_column_count,l_column_value5,240);

Line 1346: DBMS_SQL.DEFINE_COLUMN_CHAR(v_cursor_id,l_column_count,l_column_value5,240);

1342: DBMS_SQL.DEFINE_COLUMN_CHAR(v_cursor_id,l_column_count,l_column_value4,240);
1343: ELSIF l_column_count = 5 THEN
1344: l_column_name5:=l_temp_col_name;
1345: l_column_prompt5 := l_temp_prompt;
1346: DBMS_SQL.DEFINE_COLUMN_CHAR(v_cursor_id,l_column_count,l_column_value5,240);
1347: ELSIF l_column_count = 6 THEN
1348: l_column_name6:=l_temp_col_name;
1349: l_column_prompt6 := l_temp_prompt;
1350: DBMS_SQL.DEFINE_COLUMN_CHAR(v_cursor_id,l_column_count,l_column_value6,240);

Line 1350: DBMS_SQL.DEFINE_COLUMN_CHAR(v_cursor_id,l_column_count,l_column_value6,240);

1346: DBMS_SQL.DEFINE_COLUMN_CHAR(v_cursor_id,l_column_count,l_column_value5,240);
1347: ELSIF l_column_count = 6 THEN
1348: l_column_name6:=l_temp_col_name;
1349: l_column_prompt6 := l_temp_prompt;
1350: DBMS_SQL.DEFINE_COLUMN_CHAR(v_cursor_id,l_column_count,l_column_value6,240);
1351: ELSIF l_column_count = 7 THEN
1352: l_column_name7:=l_temp_col_name;
1353: l_column_prompt8 := l_temp_prompt;
1354: DBMS_SQL.DEFINE_COLUMN_CHAR(v_cursor_id,l_column_count,l_column_value7,240);

Line 1354: DBMS_SQL.DEFINE_COLUMN_CHAR(v_cursor_id,l_column_count,l_column_value7,240);

1350: DBMS_SQL.DEFINE_COLUMN_CHAR(v_cursor_id,l_column_count,l_column_value6,240);
1351: ELSIF l_column_count = 7 THEN
1352: l_column_name7:=l_temp_col_name;
1353: l_column_prompt8 := l_temp_prompt;
1354: DBMS_SQL.DEFINE_COLUMN_CHAR(v_cursor_id,l_column_count,l_column_value7,240);
1355: ELSIF l_column_count = 8 THEN
1356: l_column_name8:=l_temp_col_name;
1357: l_column_prompt8 := l_temp_prompt;
1358: DBMS_SQL.DEFINE_COLUMN_CHAR(v_cursor_id,l_column_count,l_column_value8,240);

Line 1358: DBMS_SQL.DEFINE_COLUMN_CHAR(v_cursor_id,l_column_count,l_column_value8,240);

1354: DBMS_SQL.DEFINE_COLUMN_CHAR(v_cursor_id,l_column_count,l_column_value7,240);
1355: ELSIF l_column_count = 8 THEN
1356: l_column_name8:=l_temp_col_name;
1357: l_column_prompt8 := l_temp_prompt;
1358: DBMS_SQL.DEFINE_COLUMN_CHAR(v_cursor_id,l_column_count,l_column_value8,240);
1359: ELSIF l_column_count = 9 THEN
1360: l_column_name9:=l_temp_col_name;
1361: l_column_prompt9 := l_temp_prompt;
1362: DBMS_SQL.DEFINE_COLUMN_CHAR(v_cursor_id,l_column_count,l_column_value9,240);

Line 1362: DBMS_SQL.DEFINE_COLUMN_CHAR(v_cursor_id,l_column_count,l_column_value9,240);

1358: DBMS_SQL.DEFINE_COLUMN_CHAR(v_cursor_id,l_column_count,l_column_value8,240);
1359: ELSIF l_column_count = 9 THEN
1360: l_column_name9:=l_temp_col_name;
1361: l_column_prompt9 := l_temp_prompt;
1362: DBMS_SQL.DEFINE_COLUMN_CHAR(v_cursor_id,l_column_count,l_column_value9,240);
1363: ELSIF l_column_count = 10 THEN
1364: l_column_name10:=l_temp_col_name;
1365: l_column_prompt10 := l_temp_prompt;
1366: DBMS_SQL.DEFINE_COLUMN_CHAR(v_cursor_id,l_column_count,l_column_value10,240);

Line 1366: DBMS_SQL.DEFINE_COLUMN_CHAR(v_cursor_id,l_column_count,l_column_value10,240);

1362: DBMS_SQL.DEFINE_COLUMN_CHAR(v_cursor_id,l_column_count,l_column_value9,240);
1363: ELSIF l_column_count = 10 THEN
1364: l_column_name10:=l_temp_col_name;
1365: l_column_prompt10 := l_temp_prompt;
1366: DBMS_SQL.DEFINE_COLUMN_CHAR(v_cursor_id,l_column_count,l_column_value10,240);
1367: END IF;
1368: END LOOP;
1369: CLOSE Cur_proccol_wf;
1370: END IF;

Line 1372: v_dummy := DBMS_SQL.EXECUTE(v_cursor_id);

1368: END LOOP;
1369: CLOSE Cur_proccol_wf;
1370: END IF;
1371: -- Execute the statement
1372: v_dummy := DBMS_SQL.EXECUTE(v_cursor_id);
1373: LOOP
1374: IF DBMS_SQL.FETCH_ROWS(v_cursor_id) = 0 THEN
1375: DBMS_SQL.CLOSE_CURSOR(v_cursor_id);
1376: IF l_no_rows > 1 THEN

Line 1374: IF DBMS_SQL.FETCH_ROWS(v_cursor_id) = 0 THEN

1370: END IF;
1371: -- Execute the statement
1372: v_dummy := DBMS_SQL.EXECUTE(v_cursor_id);
1373: LOOP
1374: IF DBMS_SQL.FETCH_ROWS(v_cursor_id) = 0 THEN
1375: DBMS_SQL.CLOSE_CURSOR(v_cursor_id);
1376: IF l_no_rows > 1 THEN
1377: -- Close the cursor
1378: data_string := 'MULTI_ROWS_ERROR';

Line 1375: DBMS_SQL.CLOSE_CURSOR(v_cursor_id);

1371: -- Execute the statement
1372: v_dummy := DBMS_SQL.EXECUTE(v_cursor_id);
1373: LOOP
1374: IF DBMS_SQL.FETCH_ROWS(v_cursor_id) = 0 THEN
1375: DBMS_SQL.CLOSE_CURSOR(v_cursor_id);
1376: IF l_no_rows > 1 THEN
1377: -- Close the cursor
1378: data_string := 'MULTI_ROWS_ERROR';
1379: RAISE WF_ERROR;

Line 1393: DBMS_SQL.COLUMN_VALUE_CHAR(v_cursor_id,l_col_vals,l_column_value1);

1389: -- Modification is chnage if condions to use l_col_vals instead of l_column_count.
1390: --
1391:
1392: IF l_col_vals = 1 THEN
1393: DBMS_SQL.COLUMN_VALUE_CHAR(v_cursor_id,l_col_vals,l_column_value1);
1394: data_string := data_string ||l_column_name1||'='||trim(l_column_value1);
1395: wf_data_string := wf_data_string ||l_column_prompt1||'='||trim(l_column_value1);
1396: ELSIF l_col_vals = 2 THEN
1397: DBMS_SQL.COLUMN_VALUE_CHAR(v_cursor_id,l_col_vals,l_column_value2);

Line 1397: DBMS_SQL.COLUMN_VALUE_CHAR(v_cursor_id,l_col_vals,l_column_value2);

1393: DBMS_SQL.COLUMN_VALUE_CHAR(v_cursor_id,l_col_vals,l_column_value1);
1394: data_string := data_string ||l_column_name1||'='||trim(l_column_value1);
1395: wf_data_string := wf_data_string ||l_column_prompt1||'='||trim(l_column_value1);
1396: ELSIF l_col_vals = 2 THEN
1397: DBMS_SQL.COLUMN_VALUE_CHAR(v_cursor_id,l_col_vals,l_column_value2);
1398: data_string := data_string ||l_delimiter||l_column_name2||'='||trim(l_column_value2);
1399: wf_data_string := wf_data_string ||l_column_prompt2||'='||trim(l_column_value2);
1400: ELSIF l_col_vals = 3 THEN
1401: DBMS_SQL.COLUMN_VALUE_CHAR(v_cursor_id,l_col_vals,l_column_value3);

Line 1401: DBMS_SQL.COLUMN_VALUE_CHAR(v_cursor_id,l_col_vals,l_column_value3);

1397: DBMS_SQL.COLUMN_VALUE_CHAR(v_cursor_id,l_col_vals,l_column_value2);
1398: data_string := data_string ||l_delimiter||l_column_name2||'='||trim(l_column_value2);
1399: wf_data_string := wf_data_string ||l_column_prompt2||'='||trim(l_column_value2);
1400: ELSIF l_col_vals = 3 THEN
1401: DBMS_SQL.COLUMN_VALUE_CHAR(v_cursor_id,l_col_vals,l_column_value3);
1402: data_string := data_string ||l_delimiter||l_column_name3||'='||trim(l_column_value3);
1403: wf_data_string := wf_data_string ||l_column_prompt3||'='||trim(l_column_value3);
1404: ELSIF l_col_vals = 4 THEN
1405: DBMS_SQL.COLUMN_VALUE_CHAR(v_cursor_id,l_col_vals,l_column_value4);

Line 1405: DBMS_SQL.COLUMN_VALUE_CHAR(v_cursor_id,l_col_vals,l_column_value4);

1401: DBMS_SQL.COLUMN_VALUE_CHAR(v_cursor_id,l_col_vals,l_column_value3);
1402: data_string := data_string ||l_delimiter||l_column_name3||'='||trim(l_column_value3);
1403: wf_data_string := wf_data_string ||l_column_prompt3||'='||trim(l_column_value3);
1404: ELSIF l_col_vals = 4 THEN
1405: DBMS_SQL.COLUMN_VALUE_CHAR(v_cursor_id,l_col_vals,l_column_value4);
1406: data_string := data_string ||l_delimiter||l_column_name4||'='||trim(l_column_value4);
1407: wf_data_string := wf_data_string ||l_column_prompt4||'='||trim(l_column_value4);
1408: ELSIF l_col_vals = 5 THEN
1409: DBMS_SQL.COLUMN_VALUE_CHAR(v_cursor_id,l_col_vals,l_column_value5);

Line 1409: DBMS_SQL.COLUMN_VALUE_CHAR(v_cursor_id,l_col_vals,l_column_value5);

1405: DBMS_SQL.COLUMN_VALUE_CHAR(v_cursor_id,l_col_vals,l_column_value4);
1406: data_string := data_string ||l_delimiter||l_column_name4||'='||trim(l_column_value4);
1407: wf_data_string := wf_data_string ||l_column_prompt4||'='||trim(l_column_value4);
1408: ELSIF l_col_vals = 5 THEN
1409: DBMS_SQL.COLUMN_VALUE_CHAR(v_cursor_id,l_col_vals,l_column_value5);
1410: data_string := data_string ||l_delimiter||l_column_name5||'='||trim(l_column_value5);
1411: wf_data_string := wf_data_string ||l_column_prompt5||'='||trim(l_column_value5);
1412: ELSIF l_col_vals = 6 THEN
1413: DBMS_SQL.COLUMN_VALUE_CHAR(v_cursor_id,l_col_vals,l_column_value6);

Line 1413: DBMS_SQL.COLUMN_VALUE_CHAR(v_cursor_id,l_col_vals,l_column_value6);

1409: DBMS_SQL.COLUMN_VALUE_CHAR(v_cursor_id,l_col_vals,l_column_value5);
1410: data_string := data_string ||l_delimiter||l_column_name5||'='||trim(l_column_value5);
1411: wf_data_string := wf_data_string ||l_column_prompt5||'='||trim(l_column_value5);
1412: ELSIF l_col_vals = 6 THEN
1413: DBMS_SQL.COLUMN_VALUE_CHAR(v_cursor_id,l_col_vals,l_column_value6);
1414: data_string := data_string ||l_delimiter||l_column_name6||'='||trim(l_column_value6);
1415: wf_data_string := wf_data_string ||l_column_prompt6||'='||trim(l_column_value6);
1416: ELSIF l_col_vals = 7 THEN
1417: DBMS_SQL.COLUMN_VALUE_CHAR(v_cursor_id,l_col_vals,l_column_value7);

Line 1417: DBMS_SQL.COLUMN_VALUE_CHAR(v_cursor_id,l_col_vals,l_column_value7);

1413: DBMS_SQL.COLUMN_VALUE_CHAR(v_cursor_id,l_col_vals,l_column_value6);
1414: data_string := data_string ||l_delimiter||l_column_name6||'='||trim(l_column_value6);
1415: wf_data_string := wf_data_string ||l_column_prompt6||'='||trim(l_column_value6);
1416: ELSIF l_col_vals = 7 THEN
1417: DBMS_SQL.COLUMN_VALUE_CHAR(v_cursor_id,l_col_vals,l_column_value7);
1418: data_string := data_string ||l_delimiter||l_column_name7||'='||trim(l_column_value7);
1419: wf_data_string := wf_data_string ||l_column_prompt7||'='||trim(l_column_value7);
1420: ELSIF l_col_vals = 8 THEN
1421: DBMS_SQL.COLUMN_VALUE_CHAR(v_cursor_id,l_col_vals,l_column_value8);

Line 1421: DBMS_SQL.COLUMN_VALUE_CHAR(v_cursor_id,l_col_vals,l_column_value8);

1417: DBMS_SQL.COLUMN_VALUE_CHAR(v_cursor_id,l_col_vals,l_column_value7);
1418: data_string := data_string ||l_delimiter||l_column_name7||'='||trim(l_column_value7);
1419: wf_data_string := wf_data_string ||l_column_prompt7||'='||trim(l_column_value7);
1420: ELSIF l_col_vals = 8 THEN
1421: DBMS_SQL.COLUMN_VALUE_CHAR(v_cursor_id,l_col_vals,l_column_value8);
1422: wf_data_string := wf_data_string ||l_column_prompt8||'='||trim(l_column_value8);
1423: data_string := data_string ||l_delimiter||l_column_name8||'='||trim(l_column_value8);
1424: ELSIF l_col_vals = 9 THEN
1425: wf_data_string := wf_data_string ||l_column_prompt9||'='||trim(l_column_value9);

Line 1426: DBMS_SQL.COLUMN_VALUE_CHAR(v_cursor_id,l_col_vals,l_column_value9);

1422: wf_data_string := wf_data_string ||l_column_prompt8||'='||trim(l_column_value8);
1423: data_string := data_string ||l_delimiter||l_column_name8||'='||trim(l_column_value8);
1424: ELSIF l_col_vals = 9 THEN
1425: wf_data_string := wf_data_string ||l_column_prompt9||'='||trim(l_column_value9);
1426: DBMS_SQL.COLUMN_VALUE_CHAR(v_cursor_id,l_col_vals,l_column_value9);
1427: data_string := data_string ||l_delimiter||l_column_name9||'='||trim(l_column_value9);
1428: ELSIF l_col_vals = 10 THEN
1429: DBMS_SQL.COLUMN_VALUE_CHAR(v_cursor_id,l_col_vals,l_column_value10);
1430: wf_data_string := wf_data_string ||l_column_prompt10||'='||trim(l_column_value10);

Line 1429: DBMS_SQL.COLUMN_VALUE_CHAR(v_cursor_id,l_col_vals,l_column_value10);

1425: wf_data_string := wf_data_string ||l_column_prompt9||'='||trim(l_column_value9);
1426: DBMS_SQL.COLUMN_VALUE_CHAR(v_cursor_id,l_col_vals,l_column_value9);
1427: data_string := data_string ||l_delimiter||l_column_name9||'='||trim(l_column_value9);
1428: ELSIF l_col_vals = 10 THEN
1429: DBMS_SQL.COLUMN_VALUE_CHAR(v_cursor_id,l_col_vals,l_column_value10);
1430: wf_data_string := wf_data_string ||l_column_prompt10||'='||trim(l_column_value10);
1431: data_string := data_string ||l_delimiter||l_column_name10||'='||trim(l_column_value10);
1432: END IF;
1433: END LOOP;