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.FND_FLEX_SERVER dependencies on FND_DSQL

Line 1364: fnd_dsql.init;

1360:
1361: sqls := 'lock table ' || combtbl.application_table_name;
1362: sqls := sqls || ' in row share mode';
1363:
1364: fnd_dsql.init;
1365: fnd_dsql.add_text(sqls);
1366: if(FND_FLEX_SERVER1.x_dsql_execute < 0) THEN
1367: GOTO return_false;
1368: end if;

Line 1365: fnd_dsql.add_text(sqls);

1361: sqls := 'lock table ' || combtbl.application_table_name;
1362: sqls := sqls || ' in row share mode';
1363:
1364: fnd_dsql.init;
1365: fnd_dsql.add_text(sqls);
1366: if(FND_FLEX_SERVER1.x_dsql_execute < 0) THEN
1367: GOTO return_false;
1368: end if;
1369:

Line 1412: fnd_dsql.init;

1408: ccid := ccid_inp;
1409: else
1410: sqls := 'select to_char(' || combtbl.application_table_name;
1411: sqls := sqls || '_S.NEXTVAL) from dual';
1412: fnd_dsql.init;
1413: fnd_dsql.add_text(sqls);
1414: if(FND_FLEX_SERVER1.x_dsql_select_one(ccid_string) <> 1) THEN
1415: GOTO return_false;
1416: end if;

Line 1413: fnd_dsql.add_text(sqls);

1409: else
1410: sqls := 'select to_char(' || combtbl.application_table_name;
1411: sqls := sqls || '_S.NEXTVAL) from dual';
1412: fnd_dsql.init;
1413: fnd_dsql.add_text(sqls);
1414: if(FND_FLEX_SERVER1.x_dsql_select_one(ccid_string) <> 1) THEN
1415: GOTO return_false;
1416: end if;
1417: ccid := to_number(ccid_string);

Line 1440: fnd_dsql.init;

1436: if(NOT maintmode) then
1437:
1438: -- Build a SQL statement to do the insert.
1439: --
1440: fnd_dsql.init;
1441: sqls := 'insert into ' || combtbl.application_table_name || ' (';
1442: sqls := sqls || combtbl.unique_id_column_name;
1443: if(combtbl.set_defining_column_name is not null) then
1444: sqls := sqls || ', ' || combtbl.set_defining_column_name;

Line 1460: fnd_dsql.add_text(sqls);

1456: end loop;
1457: sqls := sqls || ') values (';
1458:
1459: -- So far the table name and the column names.
1460: fnd_dsql.add_text(sqls);
1461:
1462: fnd_dsql.add_bind(ccid);
1463:
1464: if(combtbl.set_defining_column_name is not null) THEN

Line 1462: fnd_dsql.add_bind(ccid);

1458:
1459: -- So far the table name and the column names.
1460: fnd_dsql.add_text(sqls);
1461:
1462: fnd_dsql.add_bind(ccid);
1463:
1464: if(combtbl.set_defining_column_name is not null) THEN
1465: fnd_dsql.add_text(',');
1466: fnd_dsql.add_bind(structnum);

Line 1465: fnd_dsql.add_text(',');

1461:
1462: fnd_dsql.add_bind(ccid);
1463:
1464: if(combtbl.set_defining_column_name is not null) THEN
1465: fnd_dsql.add_text(',');
1466: fnd_dsql.add_bind(structnum);
1467: end if;
1468:
1469: fnd_dsql.add_text(',');

Line 1466: fnd_dsql.add_bind(structnum);

1462: fnd_dsql.add_bind(ccid);
1463:
1464: if(combtbl.set_defining_column_name is not null) THEN
1465: fnd_dsql.add_text(',');
1466: fnd_dsql.add_bind(structnum);
1467: end if;
1468:
1469: fnd_dsql.add_text(',');
1470: fnd_dsql.add_bind(dvalues.enabled_flag);

Line 1469: fnd_dsql.add_text(',');

1465: fnd_dsql.add_text(',');
1466: fnd_dsql.add_bind(structnum);
1467: end if;
1468:
1469: fnd_dsql.add_text(',');
1470: fnd_dsql.add_bind(dvalues.enabled_flag);
1471:
1472: fnd_dsql.add_text(',');
1473: fnd_dsql.add_bind(dvalues.summary_flag);

Line 1470: fnd_dsql.add_bind(dvalues.enabled_flag);

1466: fnd_dsql.add_bind(structnum);
1467: end if;
1468:
1469: fnd_dsql.add_text(',');
1470: fnd_dsql.add_bind(dvalues.enabled_flag);
1471:
1472: fnd_dsql.add_text(',');
1473: fnd_dsql.add_bind(dvalues.summary_flag);
1474:

Line 1472: fnd_dsql.add_text(',');

1468:
1469: fnd_dsql.add_text(',');
1470: fnd_dsql.add_bind(dvalues.enabled_flag);
1471:
1472: fnd_dsql.add_text(',');
1473: fnd_dsql.add_bind(dvalues.summary_flag);
1474:
1475: fnd_dsql.add_text(',');
1476: fnd_dsql.add_bind(dvalues.start_valid);

Line 1473: fnd_dsql.add_bind(dvalues.summary_flag);

1469: fnd_dsql.add_text(',');
1470: fnd_dsql.add_bind(dvalues.enabled_flag);
1471:
1472: fnd_dsql.add_text(',');
1473: fnd_dsql.add_bind(dvalues.summary_flag);
1474:
1475: fnd_dsql.add_text(',');
1476: fnd_dsql.add_bind(dvalues.start_valid);
1477:

Line 1475: fnd_dsql.add_text(',');

1471:
1472: fnd_dsql.add_text(',');
1473: fnd_dsql.add_bind(dvalues.summary_flag);
1474:
1475: fnd_dsql.add_text(',');
1476: fnd_dsql.add_bind(dvalues.start_valid);
1477:
1478: fnd_dsql.add_text(',');
1479: fnd_dsql.add_bind(dvalues.end_valid);

Line 1476: fnd_dsql.add_bind(dvalues.start_valid);

1472: fnd_dsql.add_text(',');
1473: fnd_dsql.add_bind(dvalues.summary_flag);
1474:
1475: fnd_dsql.add_text(',');
1476: fnd_dsql.add_bind(dvalues.start_valid);
1477:
1478: fnd_dsql.add_text(',');
1479: fnd_dsql.add_bind(dvalues.end_valid);
1480:

Line 1478: fnd_dsql.add_text(',');

1474:
1475: fnd_dsql.add_text(',');
1476: fnd_dsql.add_bind(dvalues.start_valid);
1477:
1478: fnd_dsql.add_text(',');
1479: fnd_dsql.add_bind(dvalues.end_valid);
1480:
1481: fnd_dsql.add_text(',sysdate,');
1482: fnd_dsql.add_bind(user_id);

Line 1479: fnd_dsql.add_bind(dvalues.end_valid);

1475: fnd_dsql.add_text(',');
1476: fnd_dsql.add_bind(dvalues.start_valid);
1477:
1478: fnd_dsql.add_text(',');
1479: fnd_dsql.add_bind(dvalues.end_valid);
1480:
1481: fnd_dsql.add_text(',sysdate,');
1482: fnd_dsql.add_bind(user_id);
1483:

Line 1481: fnd_dsql.add_text(',sysdate,');

1477:
1478: fnd_dsql.add_text(',');
1479: fnd_dsql.add_bind(dvalues.end_valid);
1480:
1481: fnd_dsql.add_text(',sysdate,');
1482: fnd_dsql.add_bind(user_id);
1483:
1484: for i in 1..dquals.nquals LOOP
1485: fnd_dsql.add_text(',');

Line 1482: fnd_dsql.add_bind(user_id);

1478: fnd_dsql.add_text(',');
1479: fnd_dsql.add_bind(dvalues.end_valid);
1480:
1481: fnd_dsql.add_text(',sysdate,');
1482: fnd_dsql.add_bind(user_id);
1483:
1484: for i in 1..dquals.nquals LOOP
1485: fnd_dsql.add_text(',');
1486: fnd_dsql.add_bind(dquals.sq_values(i));

Line 1485: fnd_dsql.add_text(',');

1481: fnd_dsql.add_text(',sysdate,');
1482: fnd_dsql.add_bind(user_id);
1483:
1484: for i in 1..dquals.nquals LOOP
1485: fnd_dsql.add_text(',');
1486: fnd_dsql.add_bind(dquals.sq_values(i));
1487: end loop;
1488:
1489: for i in 1..nsegs loop

Line 1486: fnd_dsql.add_bind(dquals.sq_values(i));

1482: fnd_dsql.add_bind(user_id);
1483:
1484: for i in 1..dquals.nquals LOOP
1485: fnd_dsql.add_text(',');
1486: fnd_dsql.add_bind(dquals.sq_values(i));
1487: end loop;
1488:
1489: for i in 1..nsegs loop
1490: if(segids(i) is not null) THEN

Line 1491: fnd_dsql.add_text(',');

1487: end loop;
1488:
1489: for i in 1..nsegs loop
1490: if(segids(i) is not null) THEN
1491: fnd_dsql.add_text(',');
1492: --
1493: -- This will call fnd_dsql.add_bind
1494: --
1495: fnd_flex_server1.x_compare_clause

Line 1493: -- This will call fnd_dsql.add_bind

1489: for i in 1..nsegs loop
1490: if(segids(i) is not null) THEN
1491: fnd_dsql.add_text(',');
1492: --
1493: -- This will call fnd_dsql.add_bind
1494: --
1495: fnd_flex_server1.x_compare_clause
1496: (combtypes(i),
1497: combcols(i), segids(i), FND_FLEX_SERVER1.VC_ID,

Line 1501: fnd_dsql.add_text(')');

1497: combcols(i), segids(i), FND_FLEX_SERVER1.VC_ID,
1498: segfmts.vs_format(i), segfmts.vs_maxsize(i));
1499: end if;
1500: end loop;
1501: fnd_dsql.add_text(')');
1502:
1503: --
1504: -- Finally do the insert
1505: --

Line 2435: fnd_dsql.add_text(' and (');

2431: IF (l_awc IS NULL) THEN
2432: RETURN(TRUE);
2433: END IF;
2434:
2435: fnd_dsql.add_text(' and (');
2436:
2437: l_pos2 := 0;
2438: l_pos1 := Instr(l_awc, '''', l_pos2 + 1, 1);
2439: WHILE (l_pos1 > 0) LOOP

Line 2443: fnd_dsql.add_text(Substr(l_awc, l_pos2 + 1, (l_pos1 - l_pos2) - 1));

2439: WHILE (l_pos1 > 0) LOOP
2440: --
2441: -- Copy upto single quote.
2442: --
2443: fnd_dsql.add_text(Substr(l_awc, l_pos2 + 1, (l_pos1 - l_pos2) - 1));
2444:
2445: --
2446: -- Find the closing quote. Handle single quote escaping.
2447: --

Line 2462: fnd_dsql.add_bind(REPLACE(Substr(l_awc, l_pos1 + 1, (l_pos2-l_pos1)- 1),

2458: fnd_message.set_token('CLAUSE', Substr(l_awc, 1, 1000));
2459: RETURN(FALSE);
2460: END IF;
2461:
2462: fnd_dsql.add_bind(REPLACE(Substr(l_awc, l_pos1 + 1, (l_pos2-l_pos1)- 1),
2463: '''''', ''''));
2464:
2465: l_pos1 := Instr(l_awc, '''', l_pos2 + 1, 1);
2466: END LOOP;

Line 2468: fnd_dsql.add_text(Substr(l_awc, l_pos2 + 1, l_awc_len - l_pos2));

2464:
2465: l_pos1 := Instr(l_awc, '''', l_pos2 + 1, 1);
2466: END LOOP;
2467:
2468: fnd_dsql.add_text(Substr(l_awc, l_pos2 + 1, l_awc_len - l_pos2));
2469: fnd_dsql.add_text(')');
2470:
2471: RETURN(TRUE);
2472: EXCEPTION

Line 2469: fnd_dsql.add_text(')');

2465: l_pos1 := Instr(l_awc, '''', l_pos2 + 1, 1);
2466: END LOOP;
2467:
2468: fnd_dsql.add_text(Substr(l_awc, l_pos2 + 1, l_awc_len - l_pos2));
2469: fnd_dsql.add_text(')');
2470:
2471: RETURN(TRUE);
2472: EXCEPTION
2473: WHEN OTHERS THEN

Line 2521: fnd_dsql.init;

2517:
2518: -- Build SQL statement to select ccid, enabled information, segment columns,
2519: -- qualifiers, and extra cols in that order.
2520: --
2521: fnd_dsql.init;
2522:
2523: sqls := 'select to_char(' || combtbl.unique_id_column_name || '), ';
2524: sqls := sqls || 'nvl(ENABLED_FLAG, ''Y''), nvl(SUMMARY_FLAG, ''N''), ';
2525: sqls := sqls || 'to_char(START_DATE_ACTIVE, ''' ||

Line 2551: fnd_dsql.add_text(sqls);

2547: end if;
2548:
2549: sqls := sqls || ' = ';
2550:
2551: fnd_dsql.add_text(sqls);
2552: fnd_dsql.add_bind(structnum);
2553:
2554: -- If CCID input select by CCID, otherwise select by segment ids.
2555: --

Line 2552: fnd_dsql.add_bind(structnum);

2548:
2549: sqls := sqls || ' = ';
2550:
2551: fnd_dsql.add_text(sqls);
2552: fnd_dsql.add_bind(structnum);
2553:
2554: -- If CCID input select by CCID, otherwise select by segment ids.
2555: --
2556: if(ccid is not null) THEN

Line 2557: fnd_dsql.add_text(' and ' || combtbl.unique_id_column_name || ' = ');

2553:
2554: -- If CCID input select by CCID, otherwise select by segment ids.
2555: --
2556: if(ccid is not null) THEN
2557: fnd_dsql.add_text(' and ' || combtbl.unique_id_column_name || ' = ');
2558: fnd_dsql.add_bind(ccid);
2559: ELSE
2560: for i in 1..nsegs LOOP
2561: fnd_dsql.add_text(' and (' || combcols(i));

Line 2558: fnd_dsql.add_bind(ccid);

2554: -- If CCID input select by CCID, otherwise select by segment ids.
2555: --
2556: if(ccid is not null) THEN
2557: fnd_dsql.add_text(' and ' || combtbl.unique_id_column_name || ' = ');
2558: fnd_dsql.add_bind(ccid);
2559: ELSE
2560: for i in 1..nsegs LOOP
2561: fnd_dsql.add_text(' and (' || combcols(i));
2562: if(segids(i) is null) THEN

Line 2561: fnd_dsql.add_text(' and (' || combcols(i));

2557: fnd_dsql.add_text(' and ' || combtbl.unique_id_column_name || ' = ');
2558: fnd_dsql.add_bind(ccid);
2559: ELSE
2560: for i in 1..nsegs LOOP
2561: fnd_dsql.add_text(' and (' || combcols(i));
2562: if(segids(i) is null) THEN
2563: fnd_dsql.add_text(' is null)');
2564: else
2565: fnd_dsql.add_text(' = ');

Line 2563: fnd_dsql.add_text(' is null)');

2559: ELSE
2560: for i in 1..nsegs LOOP
2561: fnd_dsql.add_text(' and (' || combcols(i));
2562: if(segids(i) is null) THEN
2563: fnd_dsql.add_text(' is null)');
2564: else
2565: fnd_dsql.add_text(' = ');
2566: --
2567: -- This will call fnd_dsql.add_bind

Line 2565: fnd_dsql.add_text(' = ');

2561: fnd_dsql.add_text(' and (' || combcols(i));
2562: if(segids(i) is null) THEN
2563: fnd_dsql.add_text(' is null)');
2564: else
2565: fnd_dsql.add_text(' = ');
2566: --
2567: -- This will call fnd_dsql.add_bind
2568: --
2569: fnd_flex_server1.x_compare_clause

Line 2567: -- This will call fnd_dsql.add_bind

2563: fnd_dsql.add_text(' is null)');
2564: else
2565: fnd_dsql.add_text(' = ');
2566: --
2567: -- This will call fnd_dsql.add_bind
2568: --
2569: fnd_flex_server1.x_compare_clause
2570: (combtypes(i),
2571: combcols(i), segids(i), FND_FLEX_SERVER1.VC_ID,

Line 2574: fnd_dsql.add_text(')');

2570: (combtypes(i),
2571: combcols(i), segids(i), FND_FLEX_SERVER1.VC_ID,
2572: segfmts.vs_format(i), segfmts.vs_maxsize(i));
2573:
2574: fnd_dsql.add_text(')');
2575: end if;
2576: end loop;
2577: if(where_cl is not null) THEN
2578: --

Line 2591: -- This will use the sql string stored in fnd_dsql package.

2587: -- Do the lookup
2588: --
2589:
2590: --
2591: -- This will use the sql string stored in fnd_dsql package.
2592: --
2593: nrecords := fnd_flex_server1.x_dsql_select(nsegs + nquals + nxcols + 5,
2594: colvals);
2595:

Line 2757: fnd_dsql.init;

2753:
2754: sqls := 'lock table ' || combtbl.application_table_name;
2755: sqls := sqls || ' in row share mode';
2756:
2757: fnd_dsql.init;
2758: fnd_dsql.add_text(sqls);
2759: if(FND_FLEX_SERVER1.x_dsql_execute < 0) then
2760: return(FALSE);
2761: end if;

Line 2758: fnd_dsql.add_text(sqls);

2754: sqls := 'lock table ' || combtbl.application_table_name;
2755: sqls := sqls || ' in row share mode';
2756:
2757: fnd_dsql.init;
2758: fnd_dsql.add_text(sqls);
2759: if(FND_FLEX_SERVER1.x_dsql_execute < 0) then
2760: return(FALSE);
2761: end if;
2762:

Line 2803: fnd_dsql.init;

2799: ccid := ccid_inp;
2800: else
2801: sqls := 'select to_char(' || combtbl.application_table_name;
2802: sqls := sqls || '_S.NEXTVAL) from dual';
2803: fnd_dsql.init;
2804: fnd_dsql.add_text(sqls);
2805: if(FND_FLEX_SERVER1.x_dsql_select_one(ccid_string) <> 1) then
2806: return(FALSE);
2807: end if;

Line 2804: fnd_dsql.add_text(sqls);

2800: else
2801: sqls := 'select to_char(' || combtbl.application_table_name;
2802: sqls := sqls || '_S.NEXTVAL) from dual';
2803: fnd_dsql.init;
2804: fnd_dsql.add_text(sqls);
2805: if(FND_FLEX_SERVER1.x_dsql_select_one(ccid_string) <> 1) then
2806: return(FALSE);
2807: end if;
2808: ccid := to_number(ccid_string);

Line 2831: fnd_dsql.init;

2827: if(NOT maintmode) then
2828:
2829: -- Build a SQL statement to do the insert.
2830: --
2831: fnd_dsql.init;
2832: sqls := 'insert into ' || combtbl.application_table_name || ' (';
2833: sqls := sqls || combtbl.unique_id_column_name;
2834: if(combtbl.set_defining_column_name is not null) then
2835: sqls := sqls || ', ' || combtbl.set_defining_column_name;

Line 2851: fnd_dsql.add_text(sqls);

2847: end loop;
2848: sqls := sqls || ') values (';
2849:
2850: -- So far the table name and the column names.
2851: fnd_dsql.add_text(sqls);
2852:
2853: fnd_dsql.add_bind(ccid);
2854:
2855: if(combtbl.set_defining_column_name is not null) THEN

Line 2853: fnd_dsql.add_bind(ccid);

2849:
2850: -- So far the table name and the column names.
2851: fnd_dsql.add_text(sqls);
2852:
2853: fnd_dsql.add_bind(ccid);
2854:
2855: if(combtbl.set_defining_column_name is not null) THEN
2856: fnd_dsql.add_text(',');
2857: fnd_dsql.add_bind(structnum);

Line 2856: fnd_dsql.add_text(',');

2852:
2853: fnd_dsql.add_bind(ccid);
2854:
2855: if(combtbl.set_defining_column_name is not null) THEN
2856: fnd_dsql.add_text(',');
2857: fnd_dsql.add_bind(structnum);
2858: end if;
2859:
2860: fnd_dsql.add_text(',');

Line 2857: fnd_dsql.add_bind(structnum);

2853: fnd_dsql.add_bind(ccid);
2854:
2855: if(combtbl.set_defining_column_name is not null) THEN
2856: fnd_dsql.add_text(',');
2857: fnd_dsql.add_bind(structnum);
2858: end if;
2859:
2860: fnd_dsql.add_text(',');
2861: fnd_dsql.add_bind(dvalues.enabled_flag);

Line 2860: fnd_dsql.add_text(',');

2856: fnd_dsql.add_text(',');
2857: fnd_dsql.add_bind(structnum);
2858: end if;
2859:
2860: fnd_dsql.add_text(',');
2861: fnd_dsql.add_bind(dvalues.enabled_flag);
2862:
2863: fnd_dsql.add_text(',');
2864: fnd_dsql.add_bind(dvalues.summary_flag);

Line 2861: fnd_dsql.add_bind(dvalues.enabled_flag);

2857: fnd_dsql.add_bind(structnum);
2858: end if;
2859:
2860: fnd_dsql.add_text(',');
2861: fnd_dsql.add_bind(dvalues.enabled_flag);
2862:
2863: fnd_dsql.add_text(',');
2864: fnd_dsql.add_bind(dvalues.summary_flag);
2865:

Line 2863: fnd_dsql.add_text(',');

2859:
2860: fnd_dsql.add_text(',');
2861: fnd_dsql.add_bind(dvalues.enabled_flag);
2862:
2863: fnd_dsql.add_text(',');
2864: fnd_dsql.add_bind(dvalues.summary_flag);
2865:
2866: fnd_dsql.add_text(',');
2867: fnd_dsql.add_bind(dvalues.start_valid);

Line 2864: fnd_dsql.add_bind(dvalues.summary_flag);

2860: fnd_dsql.add_text(',');
2861: fnd_dsql.add_bind(dvalues.enabled_flag);
2862:
2863: fnd_dsql.add_text(',');
2864: fnd_dsql.add_bind(dvalues.summary_flag);
2865:
2866: fnd_dsql.add_text(',');
2867: fnd_dsql.add_bind(dvalues.start_valid);
2868:

Line 2866: fnd_dsql.add_text(',');

2862:
2863: fnd_dsql.add_text(',');
2864: fnd_dsql.add_bind(dvalues.summary_flag);
2865:
2866: fnd_dsql.add_text(',');
2867: fnd_dsql.add_bind(dvalues.start_valid);
2868:
2869: fnd_dsql.add_text(',');
2870: fnd_dsql.add_bind(dvalues.end_valid);

Line 2867: fnd_dsql.add_bind(dvalues.start_valid);

2863: fnd_dsql.add_text(',');
2864: fnd_dsql.add_bind(dvalues.summary_flag);
2865:
2866: fnd_dsql.add_text(',');
2867: fnd_dsql.add_bind(dvalues.start_valid);
2868:
2869: fnd_dsql.add_text(',');
2870: fnd_dsql.add_bind(dvalues.end_valid);
2871:

Line 2869: fnd_dsql.add_text(',');

2865:
2866: fnd_dsql.add_text(',');
2867: fnd_dsql.add_bind(dvalues.start_valid);
2868:
2869: fnd_dsql.add_text(',');
2870: fnd_dsql.add_bind(dvalues.end_valid);
2871:
2872: fnd_dsql.add_text(',sysdate,');
2873: fnd_dsql.add_bind(user_id);

Line 2870: fnd_dsql.add_bind(dvalues.end_valid);

2866: fnd_dsql.add_text(',');
2867: fnd_dsql.add_bind(dvalues.start_valid);
2868:
2869: fnd_dsql.add_text(',');
2870: fnd_dsql.add_bind(dvalues.end_valid);
2871:
2872: fnd_dsql.add_text(',sysdate,');
2873: fnd_dsql.add_bind(user_id);
2874:

Line 2872: fnd_dsql.add_text(',sysdate,');

2868:
2869: fnd_dsql.add_text(',');
2870: fnd_dsql.add_bind(dvalues.end_valid);
2871:
2872: fnd_dsql.add_text(',sysdate,');
2873: fnd_dsql.add_bind(user_id);
2874:
2875: for i in 1..dquals.nquals LOOP
2876: fnd_dsql.add_text(',');

Line 2873: fnd_dsql.add_bind(user_id);

2869: fnd_dsql.add_text(',');
2870: fnd_dsql.add_bind(dvalues.end_valid);
2871:
2872: fnd_dsql.add_text(',sysdate,');
2873: fnd_dsql.add_bind(user_id);
2874:
2875: for i in 1..dquals.nquals LOOP
2876: fnd_dsql.add_text(',');
2877: fnd_dsql.add_bind(dquals.sq_values(i));

Line 2876: fnd_dsql.add_text(',');

2872: fnd_dsql.add_text(',sysdate,');
2873: fnd_dsql.add_bind(user_id);
2874:
2875: for i in 1..dquals.nquals LOOP
2876: fnd_dsql.add_text(',');
2877: fnd_dsql.add_bind(dquals.sq_values(i));
2878: end loop;
2879:
2880: for i in 1..nsegs loop

Line 2877: fnd_dsql.add_bind(dquals.sq_values(i));

2873: fnd_dsql.add_bind(user_id);
2874:
2875: for i in 1..dquals.nquals LOOP
2876: fnd_dsql.add_text(',');
2877: fnd_dsql.add_bind(dquals.sq_values(i));
2878: end loop;
2879:
2880: for i in 1..nsegs loop
2881: if(segids(i) is not null) THEN

Line 2882: fnd_dsql.add_text(',');

2878: end loop;
2879:
2880: for i in 1..nsegs loop
2881: if(segids(i) is not null) THEN
2882: fnd_dsql.add_text(',');
2883: --
2884: -- This will call fnd_dsql.add_bind
2885: --
2886: fnd_flex_server1.x_compare_clause

Line 2884: -- This will call fnd_dsql.add_bind

2880: for i in 1..nsegs loop
2881: if(segids(i) is not null) THEN
2882: fnd_dsql.add_text(',');
2883: --
2884: -- This will call fnd_dsql.add_bind
2885: --
2886: fnd_flex_server1.x_compare_clause
2887: (combtypes(i),
2888: combcols(i), segids(i), FND_FLEX_SERVER1.VC_ID,

Line 2892: fnd_dsql.add_text(')');

2888: combcols(i), segids(i), FND_FLEX_SERVER1.VC_ID,
2889: segfmts.vs_format(i), segfmts.vs_maxsize(i));
2890: end if;
2891: end loop;
2892: fnd_dsql.add_text(')');
2893:
2894: --
2895: -- Finally do the insert
2896: --