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

Line 534: l_cursor_id INTEGER := DBMS_SQL.OPEN_CURSOR;

530: l_attr_tl_update_dml VARCHAR2(3200);
531: l_attr_update_where_dml VARCHAR2(3200);
532: l_pending_base_tbl VARCHAR2(30);
533: l_pending_tl_tbl VARCHAR2(30);
534: l_cursor_id INTEGER := DBMS_SQL.OPEN_CURSOR;
535: l_number_of_rows NUMBER;
536: l_bind_count NUMBER;
537: l_inventory_item_id NUMBER;
538: l_organization_id NUMBER;

Line 631: DBMS_SQL.Parse(l_cursor_id, l_attr_b_update_dml, DBMS_SQL.Native);

627: END LOOP;
628:
629: l_attr_b_update_dml := 'UPDATE '|| l_pending_base_tbl || ' SET '|| l_attr_b_update_dml || ' WHERE '|| l_attr_update_where_dml;
630:
631: DBMS_SQL.Parse(l_cursor_id, l_attr_b_update_dml, DBMS_SQL.Native);
632:
633: l_bind_count :=0;
634: FOR i IN p_base_attr_names_values.FIRST .. p_base_attr_names_values.LAST
635: LOOP

Line 639: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':FND_BIND'||l_bind_count ,p_base_attr_names_values(i).ATTR_VALUE_STR);

635: LOOP
636: l_bind_count := l_bind_count +1;
637: if (p_base_attr_names_values(i).ATTR_VALUE_STR is not NULL)
638: THEN
639: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':FND_BIND'||l_bind_count ,p_base_attr_names_values(i).ATTR_VALUE_STR);
640: ELSIF (p_base_attr_names_values(i).ATTR_VALUE_NUM is not NULL)
641: THEN
642: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':FND_BIND'||l_bind_count ,p_base_attr_names_values(i).ATTR_VALUE_NUM);
643: if p_base_attr_names_values(i).ATTR_UNIT_OF_MEASURE IS NOT NULL

Line 642: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':FND_BIND'||l_bind_count ,p_base_attr_names_values(i).ATTR_VALUE_NUM);

638: THEN
639: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':FND_BIND'||l_bind_count ,p_base_attr_names_values(i).ATTR_VALUE_STR);
640: ELSIF (p_base_attr_names_values(i).ATTR_VALUE_NUM is not NULL)
641: THEN
642: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':FND_BIND'||l_bind_count ,p_base_attr_names_values(i).ATTR_VALUE_NUM);
643: if p_base_attr_names_values(i).ATTR_UNIT_OF_MEASURE IS NOT NULL
644: THEN
645: l_bind_count := l_bind_count +1;
646: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':FND_BIND'||l_bind_count ,p_base_attr_names_values(i).ATTR_UNIT_OF_MEASURE );

Line 646: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':FND_BIND'||l_bind_count ,p_base_attr_names_values(i).ATTR_UNIT_OF_MEASURE );

642: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':FND_BIND'||l_bind_count ,p_base_attr_names_values(i).ATTR_VALUE_NUM);
643: if p_base_attr_names_values(i).ATTR_UNIT_OF_MEASURE IS NOT NULL
644: THEN
645: l_bind_count := l_bind_count +1;
646: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':FND_BIND'||l_bind_count ,p_base_attr_names_values(i).ATTR_UNIT_OF_MEASURE );
647: END IF;
648:
649: ELSIF (p_base_attr_names_values(i).ATTR_VALUE_DATE is not NULL)
650: THEN

Line 651: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':FND_BIND'||l_bind_count ,p_base_attr_names_values(i).ATTR_VALUE_DATE);

647: END IF;
648:
649: ELSIF (p_base_attr_names_values(i).ATTR_VALUE_DATE is not NULL)
650: THEN
651: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':FND_BIND'||l_bind_count ,p_base_attr_names_values(i).ATTR_VALUE_DATE);
652: ELSE
653: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':FND_BIND'||l_bind_count ,to_char(NULL));
654: END IF;
655: END LOOP;

Line 653: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':FND_BIND'||l_bind_count ,to_char(NULL));

649: ELSIF (p_base_attr_names_values(i).ATTR_VALUE_DATE is not NULL)
650: THEN
651: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':FND_BIND'||l_bind_count ,p_base_attr_names_values(i).ATTR_VALUE_DATE);
652: ELSE
653: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':FND_BIND'||l_bind_count ,to_char(NULL));
654: END IF;
655: END LOOP;
656: IF l_attr_b_update_dml IS NOT NULL
657: THEN

Line 664: l_number_of_rows := DBMS_SQL.Execute(l_cursor_id);

660: IF g_debug_flag THEN
661: Write_Debug('UPDATE base DML : '|| l_attr_b_update_dml);
662: END IF;
663:
664: l_number_of_rows := DBMS_SQL.Execute(l_cursor_id);
665: END IF;
666: END IF;
667:
668: IF p_base_attr_names_values IS NOT NULL

Line 670: DBMS_SQL.Close_Cursor(l_cursor_id);

666: END IF;
667:
668: IF p_base_attr_names_values IS NOT NULL
669: THEN
670: DBMS_SQL.Close_Cursor(l_cursor_id);
671:
672: l_cursor_id := DBMS_SQL.OPEN_CURSOR;
673: FOR i IN p_tl_attr_names_values.FIRST .. p_tl_attr_names_values.LAST
674: LOOP

Line 672: l_cursor_id := DBMS_SQL.OPEN_CURSOR;

668: IF p_base_attr_names_values IS NOT NULL
669: THEN
670: DBMS_SQL.Close_Cursor(l_cursor_id);
671:
672: l_cursor_id := DBMS_SQL.OPEN_CURSOR;
673: FOR i IN p_tl_attr_names_values.FIRST .. p_tl_attr_names_values.LAST
674: LOOP
675: IF (l_attr_tl_update_dml IS NULL)
676: THEN

Line 688: DBMS_SQL.Parse(l_cursor_id, l_attr_tl_update_dml, DBMS_SQL.Native);

684: THEN
685: l_attr_update_where_dml := l_attr_update_where_dml ||' AND LANGUAGE = USERENV(''LANG'')' ;
686: l_attr_tl_update_dml := 'UPDATE '|| l_pending_tl_tbl || ' SET '|| l_attr_tl_update_dml || ' WHERE '|| l_attr_update_where_dml;
687:
688: DBMS_SQL.Parse(l_cursor_id, l_attr_tl_update_dml, DBMS_SQL.Native);
689: END IF;
690:
691: FOR i IN p_tl_attr_names_values.FIRST .. p_tl_attr_names_values.LAST
692: LOOP

Line 695: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':FND_BIND'||i,p_tl_attr_names_values(i).ATTR_VALUE_STR);

691: FOR i IN p_tl_attr_names_values.FIRST .. p_tl_attr_names_values.LAST
692: LOOP
693: IF (p_tl_attr_names_values(i).ATTR_VALUE_STR is not NULL)
694: THEN
695: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':FND_BIND'||i,p_tl_attr_names_values(i).ATTR_VALUE_STR);
696: ELSIF (p_tl_attr_names_values(i).ATTR_VALUE_NUM is not NULL)
697: THEN
698: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':FND_BIND'||i,p_tl_attr_names_values(i).ATTR_VALUE_NUM);
699: ELSIF (p_tl_attr_names_values(i).ATTR_VALUE_DATE is not NULL)

Line 698: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':FND_BIND'||i,p_tl_attr_names_values(i).ATTR_VALUE_NUM);

694: THEN
695: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':FND_BIND'||i,p_tl_attr_names_values(i).ATTR_VALUE_STR);
696: ELSIF (p_tl_attr_names_values(i).ATTR_VALUE_NUM is not NULL)
697: THEN
698: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':FND_BIND'||i,p_tl_attr_names_values(i).ATTR_VALUE_NUM);
699: ELSIF (p_tl_attr_names_values(i).ATTR_VALUE_DATE is not NULL)
700: THEN
701: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':FND_BIND'||i,p_tl_attr_names_values(i).ATTR_VALUE_DATE);
702: ELSE

Line 701: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':FND_BIND'||i,p_tl_attr_names_values(i).ATTR_VALUE_DATE);

697: THEN
698: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':FND_BIND'||i,p_tl_attr_names_values(i).ATTR_VALUE_NUM);
699: ELSIF (p_tl_attr_names_values(i).ATTR_VALUE_DATE is not NULL)
700: THEN
701: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':FND_BIND'||i,p_tl_attr_names_values(i).ATTR_VALUE_DATE);
702: ELSE
703: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':FND_BIND'||i,to_CHAR(NULL));
704: END IF;
705: END LOOP;

Line 703: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':FND_BIND'||i,to_CHAR(NULL));

699: ELSIF (p_tl_attr_names_values(i).ATTR_VALUE_DATE is not NULL)
700: THEN
701: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':FND_BIND'||i,p_tl_attr_names_values(i).ATTR_VALUE_DATE);
702: ELSE
703: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':FND_BIND'||i,to_CHAR(NULL));
704: END IF;
705: END LOOP;
706: IF g_debug_flag THEN
707: Write_Debug('UPDATE base DML : '|| l_attr_tl_update_dml);

Line 710: l_number_of_rows := DBMS_SQL.Execute(l_cursor_id);

706: IF g_debug_flag THEN
707: Write_Debug('UPDATE base DML : '|| l_attr_tl_update_dml);
708: END IF;
709:
710: l_number_of_rows := DBMS_SQL.Execute(l_cursor_id);
711:
712: END IF;
713: END IF;
714: IF g_debug_flag THEN

Line 775: l_desc_table DBMS_SQL.Desc_Tab;

771: l_dynamic_sql VARCHAR2(20000);
772: l_column_count NUMBER;
773: l_uk_where_clause VARCHAR2(4000):= null;
774: l_cursor_id NUMBER;
775: l_desc_table DBMS_SQL.Desc_Tab;
776: l_dummy NUMBER;
777: L_CACHED_SQL_FOUND VARCHAR2(1) := 'N';
778: p_prod_vl_name VARCHAR2(40);
779: l_DataLevelColumnExists VARCHAR2(5);

Line 1093: l_cursor_id := DBMS_SQL.Open_Cursor;

1089: END LOOP;
1090: END IF;
1091:
1092:
1093: l_cursor_id := DBMS_SQL.Open_Cursor;
1094: -- prg_debug(l_dynamic_sql);
1095: -- prg_debug(l_bind_index);
1096: DBMS_SQL.Parse(l_cursor_id, l_dynamic_sql, DBMS_SQL.Native);
1097: DBMS_SQL.Describe_Columns(l_cursor_id, l_column_count, l_desc_table);

Line 1096: DBMS_SQL.Parse(l_cursor_id, l_dynamic_sql, DBMS_SQL.Native);

1092:
1093: l_cursor_id := DBMS_SQL.Open_Cursor;
1094: -- prg_debug(l_dynamic_sql);
1095: -- prg_debug(l_bind_index);
1096: DBMS_SQL.Parse(l_cursor_id, l_dynamic_sql, DBMS_SQL.Native);
1097: DBMS_SQL.Describe_Columns(l_cursor_id, l_column_count, l_desc_table);
1098: FOR i IN 1 .. l_column_count
1099: LOOP
1100:

Line 1097: DBMS_SQL.Describe_Columns(l_cursor_id, l_column_count, l_desc_table);

1093: l_cursor_id := DBMS_SQL.Open_Cursor;
1094: -- prg_debug(l_dynamic_sql);
1095: -- prg_debug(l_bind_index);
1096: DBMS_SQL.Parse(l_cursor_id, l_dynamic_sql, DBMS_SQL.Native);
1097: DBMS_SQL.Describe_Columns(l_cursor_id, l_column_count, l_desc_table);
1098: FOR i IN 1 .. l_column_count
1099: LOOP
1100:
1101: DBMS_SQL.Define_Column(l_cursor_id, i, l_retrieved_value_char, 1000);

Line 1101: DBMS_SQL.Define_Column(l_cursor_id, i, l_retrieved_value_char, 1000);

1097: DBMS_SQL.Describe_Columns(l_cursor_id, l_column_count, l_desc_table);
1098: FOR i IN 1 .. l_column_count
1099: LOOP
1100:
1101: DBMS_SQL.Define_Column(l_cursor_id, i, l_retrieved_value_char, 1000);
1102:
1103: END LOOP;
1104:
1105: FOR l_bind_index IN l_bind_values.FIRST .. l_bind_values.LAST

Line 1110: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':'||l_bind_index,l_bind_values(l_bind_index).ATTR_VALUE_STR);

1106: LOOP
1107: IF ( l_bind_values(l_bind_index).ATTR_VALUE_STR is not NULL)
1108: THEN
1109: -- prg_debug(l_bind_values(l_bind_index).ATTR_VALUE_STR);
1110: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':'||l_bind_index,l_bind_values(l_bind_index).ATTR_VALUE_STR);
1111: ELSIF (l_bind_values(l_bind_index).ATTR_VALUE_NUM is not NULL)
1112: THEN
1113: -- prg_debug(l_bind_values(l_bind_index).ATTR_VALUE_NUM);
1114: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':'||l_bind_index,l_bind_values(l_bind_index).ATTR_VALUE_NUM);

Line 1114: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':'||l_bind_index,l_bind_values(l_bind_index).ATTR_VALUE_NUM);

1110: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':'||l_bind_index,l_bind_values(l_bind_index).ATTR_VALUE_STR);
1111: ELSIF (l_bind_values(l_bind_index).ATTR_VALUE_NUM is not NULL)
1112: THEN
1113: -- prg_debug(l_bind_values(l_bind_index).ATTR_VALUE_NUM);
1114: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':'||l_bind_index,l_bind_values(l_bind_index).ATTR_VALUE_NUM);
1115: ELSIF (l_bind_values(l_bind_index).ATTR_VALUE_DATE is not NULL)
1116: THEN
1117: --prg_debug(l_bind_values(l_bind_index).ATTR_VALUE_DATE);
1118: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':'||l_bind_index,l_bind_values(l_bind_index).ATTR_VALUE_DATE);

Line 1118: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':'||l_bind_index,l_bind_values(l_bind_index).ATTR_VALUE_DATE);

1114: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':'||l_bind_index,l_bind_values(l_bind_index).ATTR_VALUE_NUM);
1115: ELSIF (l_bind_values(l_bind_index).ATTR_VALUE_DATE is not NULL)
1116: THEN
1117: --prg_debug(l_bind_values(l_bind_index).ATTR_VALUE_DATE);
1118: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':'||l_bind_index,l_bind_values(l_bind_index).ATTR_VALUE_DATE);
1119: ELSE
1120: -- prg_debug(l_bind_values(l_bind_index).ATTR_VALUE_STR);
1121: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':'||l_bind_index,l_bind_values(l_bind_index).ATTR_VALUE_STR);
1122: END IF;

Line 1121: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':'||l_bind_index,l_bind_values(l_bind_index).ATTR_VALUE_STR);

1117: --prg_debug(l_bind_values(l_bind_index).ATTR_VALUE_DATE);
1118: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':'||l_bind_index,l_bind_values(l_bind_index).ATTR_VALUE_DATE);
1119: ELSE
1120: -- prg_debug(l_bind_values(l_bind_index).ATTR_VALUE_STR);
1121: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':'||l_bind_index,l_bind_values(l_bind_index).ATTR_VALUE_STR);
1122: END IF;
1123:
1124: END LOOP;
1125:

Line 1128: l_dummy := DBMS_SQL.Execute(l_cursor_id);

1124: END LOOP;
1125:
1126:
1127:
1128: l_dummy := DBMS_SQL.Execute(l_cursor_id);
1129:
1130: if ( DBMS_SQL.Fetch_Rows(l_cursor_id) > 0)
1131: THEN
1132: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1130: if ( DBMS_SQL.Fetch_Rows(l_cursor_id) > 0)

1126:
1127:
1128: l_dummy := DBMS_SQL.Execute(l_cursor_id);
1129:
1130: if ( DBMS_SQL.Fetch_Rows(l_cursor_id) > 0)
1131: THEN
1132: x_return_status := FND_API.G_RET_STS_ERROR;
1133: ERROR_HANDLER.Initialize();
1134: ERROR_HANDLER.Set_Bo_Identifier(EGO_USER_ATTRS_DATA_PVT.G_BO_IDENTIFIER);

Line 1339: l_cursor_id INTEGER := DBMS_SQL.OPEN_CURSOR;

1335:
1336: l_pending_base_tbl VARCHAR2(100);
1337: l_pending_tl_tbl VARCHAR2(100);
1338: l_pending_vl VARCHAR2(100);
1339: l_cursor_id INTEGER := DBMS_SQL.OPEN_CURSOR;
1340: l_number_of_rows NUMBER :=0;
1341: l_attr_group_request_table EGO_ATTR_GROUP_REQUEST_TABLE;
1342: L_ATTRIBUTES_DATA_TABLE EGO_USER_ATTR_DATA_TABLE;
1343: l_attributes_row_table EGO_USER_ATTR_ROW_TABLE;

Line 1631: DBMS_SQL.Parse(l_cursor_id, l_b_dml_for_ag, DBMS_SQL.Native);

1627: l_b_bind_attr_table(l_bind_index).ATTR_VALUE_NUM := l_extension_id;
1628: END IF;
1629: IF l_b_dml_for_ag IS NOT NULL
1630: THEN
1631: DBMS_SQL.Parse(l_cursor_id, l_b_dml_for_ag, DBMS_SQL.Native);
1632:
1633: if l_b_bind_attr_table is NOT NULL AND p_mode <>'DELETE'
1634: THEN
1635:

Line 1653: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':FND_BIND'||l_bind_index,l_b_bind_attr_table(l_bind_index).ATTR_VALUE_STR);

1649: END IF;
1650: END LOOP;
1651: IF ( l_b_bind_attr_table(l_bind_index).ATTR_VALUE_STR is not NULL)
1652: THEN
1653: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':FND_BIND'||l_bind_index,l_b_bind_attr_table(l_bind_index).ATTR_VALUE_STR);
1654: ELSIF (l_b_bind_attr_table(l_bind_index).ATTR_VALUE_NUM is not NULL)
1655: THEN
1656: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':FND_BIND'||l_bind_index,l_b_bind_attr_table(l_bind_index).ATTR_VALUE_NUM);
1657: ELSIF (l_b_bind_attr_table(l_bind_index).ATTR_VALUE_DATE is not NULL)

Line 1656: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':FND_BIND'||l_bind_index,l_b_bind_attr_table(l_bind_index).ATTR_VALUE_NUM);

1652: THEN
1653: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':FND_BIND'||l_bind_index,l_b_bind_attr_table(l_bind_index).ATTR_VALUE_STR);
1654: ELSIF (l_b_bind_attr_table(l_bind_index).ATTR_VALUE_NUM is not NULL)
1655: THEN
1656: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':FND_BIND'||l_bind_index,l_b_bind_attr_table(l_bind_index).ATTR_VALUE_NUM);
1657: ELSIF (l_b_bind_attr_table(l_bind_index).ATTR_VALUE_DATE is not NULL)
1658: THEN
1659: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':FND_BIND'||l_bind_index,l_b_bind_attr_table(l_bind_index).ATTR_VALUE_DATE);
1660: ELSE

Line 1659: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':FND_BIND'||l_bind_index,l_b_bind_attr_table(l_bind_index).ATTR_VALUE_DATE);

1655: THEN
1656: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':FND_BIND'||l_bind_index,l_b_bind_attr_table(l_bind_index).ATTR_VALUE_NUM);
1657: ELSIF (l_b_bind_attr_table(l_bind_index).ATTR_VALUE_DATE is not NULL)
1658: THEN
1659: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':FND_BIND'||l_bind_index,l_b_bind_attr_table(l_bind_index).ATTR_VALUE_DATE);
1660: ELSE
1661: IF l_bind_index = l_b_bind_attr_table.LAST AND (p_mode ='UPDATE' OR p_mode ='DELETE')
1662: THEN
1663: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':FND_BIND'||l_bind_index,l_extension_id);

Line 1663: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':FND_BIND'||l_bind_index,l_extension_id);

1659: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':FND_BIND'||l_bind_index,l_b_bind_attr_table(l_bind_index).ATTR_VALUE_DATE);
1660: ELSE
1661: IF l_bind_index = l_b_bind_attr_table.LAST AND (p_mode ='UPDATE' OR p_mode ='DELETE')
1662: THEN
1663: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':FND_BIND'||l_bind_index,l_extension_id);
1664: ELSE
1665: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':FND_BIND'||l_bind_index,l_b_bind_attr_table(l_bind_index).ATTR_VALUE_STR);
1666: END IF;
1667: END IF;

Line 1665: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':FND_BIND'||l_bind_index,l_b_bind_attr_table(l_bind_index).ATTR_VALUE_STR);

1661: IF l_bind_index = l_b_bind_attr_table.LAST AND (p_mode ='UPDATE' OR p_mode ='DELETE')
1662: THEN
1663: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':FND_BIND'||l_bind_index,l_extension_id);
1664: ELSE
1665: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':FND_BIND'||l_bind_index,l_b_bind_attr_table(l_bind_index).ATTR_VALUE_STR);
1666: END IF;
1667: END IF;
1668:
1669: END LOOP;

Line 1672: l_number_of_rows := DBMS_SQL.Execute(l_cursor_id);

1668:
1669: END LOOP;
1670: END IF;
1671:
1672: l_number_of_rows := DBMS_SQL.Execute(l_cursor_id);
1673: DBMS_SQL.Close_Cursor(l_cursor_id);
1674: END IF;
1675:
1676: if p_mode = 'CREATE' and (p_acd_type ='CHANGE' OR p_acd_type ='DELETE') AND l_tl_bind_attr_table is NOT NULL

Line 1673: DBMS_SQL.Close_Cursor(l_cursor_id);

1669: END LOOP;
1670: END IF;
1671:
1672: l_number_of_rows := DBMS_SQL.Execute(l_cursor_id);
1673: DBMS_SQL.Close_Cursor(l_cursor_id);
1674: END IF;
1675:
1676: if p_mode = 'CREATE' and (p_acd_type ='CHANGE' OR p_acd_type ='DELETE') AND l_tl_bind_attr_table is NOT NULL
1677: THEN

Line 1685: l_cursor_id := DBMS_SQL.OPEN_CURSOR;

1681:
1682:
1683: IF l_tl_dml_for_ag is NOT NULL
1684: THEN
1685: l_cursor_id := DBMS_SQL.OPEN_CURSOR;
1686:
1687: DBMS_SQL.Parse(l_cursor_id, l_tl_dml_for_ag, DBMS_SQL.Native);
1688:
1689: IF l_tl_bind_attr_table is NOT NULL AND p_mode <>'DELETE'

Line 1687: DBMS_SQL.Parse(l_cursor_id, l_tl_dml_for_ag, DBMS_SQL.Native);

1683: IF l_tl_dml_for_ag is NOT NULL
1684: THEN
1685: l_cursor_id := DBMS_SQL.OPEN_CURSOR;
1686:
1687: DBMS_SQL.Parse(l_cursor_id, l_tl_dml_for_ag, DBMS_SQL.Native);
1688:
1689: IF l_tl_bind_attr_table is NOT NULL AND p_mode <>'DELETE'
1690: THEN
1691: FOR l_bind_index IN l_tl_bind_attr_table.FIRST .. l_tl_bind_attr_table.LAST

Line 1707: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':FND_BIND'||l_bind_index,l_tl_bind_attr_table(l_bind_index).ATTR_VALUE_STR);

1703: END LOOP;
1704: IF ( l_tl_bind_attr_table(l_bind_index).ATTR_VALUE_STR is not NULL)
1705: THEN
1706:
1707: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':FND_BIND'||l_bind_index,l_tl_bind_attr_table(l_bind_index).ATTR_VALUE_STR);
1708: ELSIF (l_tl_bind_attr_table(l_bind_index).ATTR_VALUE_NUM is not NULL)
1709: THEN
1710:
1711: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':FND_BIND'||l_bind_index,l_tl_bind_attr_table(l_bind_index).ATTR_VALUE_NUM);

Line 1711: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':FND_BIND'||l_bind_index,l_tl_bind_attr_table(l_bind_index).ATTR_VALUE_NUM);

1707: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':FND_BIND'||l_bind_index,l_tl_bind_attr_table(l_bind_index).ATTR_VALUE_STR);
1708: ELSIF (l_tl_bind_attr_table(l_bind_index).ATTR_VALUE_NUM is not NULL)
1709: THEN
1710:
1711: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':FND_BIND'||l_bind_index,l_tl_bind_attr_table(l_bind_index).ATTR_VALUE_NUM);
1712: ELSIF (l_tl_bind_attr_table(l_bind_index).ATTR_VALUE_DATE is not NULL)
1713: THEN
1714:
1715: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':FND_BIND'||l_bind_index,l_tl_bind_attr_table(l_bind_index).ATTR_VALUE_DATE);

Line 1715: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':FND_BIND'||l_bind_index,l_tl_bind_attr_table(l_bind_index).ATTR_VALUE_DATE);

1711: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':FND_BIND'||l_bind_index,l_tl_bind_attr_table(l_bind_index).ATTR_VALUE_NUM);
1712: ELSIF (l_tl_bind_attr_table(l_bind_index).ATTR_VALUE_DATE is not NULL)
1713: THEN
1714:
1715: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':FND_BIND'||l_bind_index,l_tl_bind_attr_table(l_bind_index).ATTR_VALUE_DATE);
1716: ELSE
1717: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':FND_BIND'||l_bind_index,l_tl_bind_attr_table(l_bind_index).ATTR_VALUE_STR);
1718: END IF;
1719:

Line 1717: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':FND_BIND'||l_bind_index,l_tl_bind_attr_table(l_bind_index).ATTR_VALUE_STR);

1713: THEN
1714:
1715: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':FND_BIND'||l_bind_index,l_tl_bind_attr_table(l_bind_index).ATTR_VALUE_DATE);
1716: ELSE
1717: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':FND_BIND'||l_bind_index,l_tl_bind_attr_table(l_bind_index).ATTR_VALUE_STR);
1718: END IF;
1719:
1720:
1721: END LOOP;

Line 1723: l_number_of_rows := DBMS_SQL.Execute(l_cursor_id);

1719:
1720:
1721: END LOOP;
1722: END IF;
1723: l_number_of_rows := DBMS_SQL.Execute(l_cursor_id);
1724:
1725: DBMS_SQL.Close_Cursor(l_cursor_id);
1726: END IF;
1727:

Line 1725: DBMS_SQL.Close_Cursor(l_cursor_id);

1721: END LOOP;
1722: END IF;
1723: l_number_of_rows := DBMS_SQL.Execute(l_cursor_id);
1724:
1725: DBMS_SQL.Close_Cursor(l_cursor_id);
1726: END IF;
1727:
1728: END IF;
1729: END IF;

Line 2180: l_desc_table DBMS_SQL.Desc_Tab;

2176: L_TL_CURSOR_ID NUMBER;
2177: l_retrieved_value_char VARCHAR(1000);
2178: l_column_count NUMBER;
2179: l_dummy NUMBER;
2180: l_desc_table DBMS_SQL.Desc_Tab;
2181: l_b_update_dml VARCHAR2(10000);
2182: l_tl_update_dml VARCHAR2(10000);
2183: L_UPDATE_WHERE_CLAUSE VARCHAR2(4000) := NULL;
2184: L_UPDATE_BIND_INDEX NUMBER :=0;

Line 2292: L_ATTR_CURSOR_ID := DBMS_SQL.Open_Cursor;

2288: END LOOP;
2289: L_DYN_ATTR_GRP_SQL := L_DYN_ATTR_GRP_SQL ||')';
2290: END IF;
2291:
2292: L_ATTR_CURSOR_ID := DBMS_SQL.Open_Cursor;
2293: DBMS_SQL.Parse(L_ATTR_CURSOR_ID, L_DYN_ATTR_GRP_SQL, DBMS_SQL.Native);
2294: DBMS_SQL.Describe_Columns(L_ATTR_CURSOR_ID, l_column_count, l_desc_table);
2295: FOR i IN 1 .. l_column_count
2296: LOOP

Line 2293: DBMS_SQL.Parse(L_ATTR_CURSOR_ID, L_DYN_ATTR_GRP_SQL, DBMS_SQL.Native);

2289: L_DYN_ATTR_GRP_SQL := L_DYN_ATTR_GRP_SQL ||')';
2290: END IF;
2291:
2292: L_ATTR_CURSOR_ID := DBMS_SQL.Open_Cursor;
2293: DBMS_SQL.Parse(L_ATTR_CURSOR_ID, L_DYN_ATTR_GRP_SQL, DBMS_SQL.Native);
2294: DBMS_SQL.Describe_Columns(L_ATTR_CURSOR_ID, l_column_count, l_desc_table);
2295: FOR i IN 1 .. l_column_count
2296: LOOP
2297: DBMS_SQL.Define_Column(L_ATTR_CURSOR_ID, i, l_retrieved_value_char, 1000);

Line 2294: DBMS_SQL.Describe_Columns(L_ATTR_CURSOR_ID, l_column_count, l_desc_table);

2290: END IF;
2291:
2292: L_ATTR_CURSOR_ID := DBMS_SQL.Open_Cursor;
2293: DBMS_SQL.Parse(L_ATTR_CURSOR_ID, L_DYN_ATTR_GRP_SQL, DBMS_SQL.Native);
2294: DBMS_SQL.Describe_Columns(L_ATTR_CURSOR_ID, l_column_count, l_desc_table);
2295: FOR i IN 1 .. l_column_count
2296: LOOP
2297: DBMS_SQL.Define_Column(L_ATTR_CURSOR_ID, i, l_retrieved_value_char, 1000);
2298:

Line 2297: DBMS_SQL.Define_Column(L_ATTR_CURSOR_ID, i, l_retrieved_value_char, 1000);

2293: DBMS_SQL.Parse(L_ATTR_CURSOR_ID, L_DYN_ATTR_GRP_SQL, DBMS_SQL.Native);
2294: DBMS_SQL.Describe_Columns(L_ATTR_CURSOR_ID, l_column_count, l_desc_table);
2295: FOR i IN 1 .. l_column_count
2296: LOOP
2297: DBMS_SQL.Define_Column(L_ATTR_CURSOR_ID, i, l_retrieved_value_char, 1000);
2298:
2299: END LOOP;
2300: FOR l_bind_index IN L_PEND_BIND_VALUES.FIRST .. L_PEND_BIND_VALUES.LAST
2301: LOOP

Line 2302: DBMS_SQL.BIND_VARIABLE(L_ATTR_CURSOR_ID, ':'||l_bind_index,L_PEND_BIND_VALUES(l_bind_index).VALUE);

2298:
2299: END LOOP;
2300: FOR l_bind_index IN L_PEND_BIND_VALUES.FIRST .. L_PEND_BIND_VALUES.LAST
2301: LOOP
2302: DBMS_SQL.BIND_VARIABLE(L_ATTR_CURSOR_ID, ':'||l_bind_index,L_PEND_BIND_VALUES(l_bind_index).VALUE);
2303:
2304: END LOOP;
2305:
2306: l_dummy := DBMS_SQL.Execute(L_ATTR_CURSOR_ID);

Line 2306: l_dummy := DBMS_SQL.Execute(L_ATTR_CURSOR_ID);

2302: DBMS_SQL.BIND_VARIABLE(L_ATTR_CURSOR_ID, ':'||l_bind_index,L_PEND_BIND_VALUES(l_bind_index).VALUE);
2303:
2304: END LOOP;
2305:
2306: l_dummy := DBMS_SQL.Execute(L_ATTR_CURSOR_ID);
2307:
2308:
2309: L_ADDED_WHERE_CLAUSE := L_ADDED_WHERE_CLAUSE
2310: ||' AND ACD_TYPE = ''ADD'' AND ATTR_GROUP_ID IN (-1';

Line 2382: l_B_cursor_id:= DBMS_SQL.OPEN_CURSOR;

2378: L_TL_UPDATE_DML := L_TL_UPDATE_DML || L_UPDATE_WHERE_CLAUSE;
2379:
2380: l_B_data_level_dml := l_B_data_level_dml || ', B.EXTENSION_ID ';
2381:
2382: l_B_cursor_id:= DBMS_SQL.OPEN_CURSOR;
2383: DBMS_SQL.Parse(l_B_cursor_id, L_B_UPDATE_DML, DBMS_SQL.Native);
2384:
2385: l_TL_cursor_id:= DBMS_SQL.OPEN_CURSOR;
2386: DBMS_SQL.Parse(l_TL_cursor_id, L_TL_UPDATE_DML, DBMS_SQL.Native);

Line 2383: DBMS_SQL.Parse(l_B_cursor_id, L_B_UPDATE_DML, DBMS_SQL.Native);

2379:
2380: l_B_data_level_dml := l_B_data_level_dml || ', B.EXTENSION_ID ';
2381:
2382: l_B_cursor_id:= DBMS_SQL.OPEN_CURSOR;
2383: DBMS_SQL.Parse(l_B_cursor_id, L_B_UPDATE_DML, DBMS_SQL.Native);
2384:
2385: l_TL_cursor_id:= DBMS_SQL.OPEN_CURSOR;
2386: DBMS_SQL.Parse(l_TL_cursor_id, L_TL_UPDATE_DML, DBMS_SQL.Native);
2387:

Line 2385: l_TL_cursor_id:= DBMS_SQL.OPEN_CURSOR;

2381:
2382: l_B_cursor_id:= DBMS_SQL.OPEN_CURSOR;
2383: DBMS_SQL.Parse(l_B_cursor_id, L_B_UPDATE_DML, DBMS_SQL.Native);
2384:
2385: l_TL_cursor_id:= DBMS_SQL.OPEN_CURSOR;
2386: DBMS_SQL.Parse(l_TL_cursor_id, L_TL_UPDATE_DML, DBMS_SQL.Native);
2387:
2388:
2389: L_BIND_INDEX := L_BIND_INDEX +1;

Line 2386: DBMS_SQL.Parse(l_TL_cursor_id, L_TL_UPDATE_DML, DBMS_SQL.Native);

2382: l_B_cursor_id:= DBMS_SQL.OPEN_CURSOR;
2383: DBMS_SQL.Parse(l_B_cursor_id, L_B_UPDATE_DML, DBMS_SQL.Native);
2384:
2385: l_TL_cursor_id:= DBMS_SQL.OPEN_CURSOR;
2386: DBMS_SQL.Parse(l_TL_cursor_id, L_TL_UPDATE_DML, DBMS_SQL.Native);
2387:
2388:
2389: L_BIND_INDEX := L_BIND_INDEX +1;
2390: L_B_WHERE_CLAUSE := L_B_WHERE_CLAUSE ||

Line 2399: WHILE (DBMS_SQL.Fetch_Rows(L_ATTR_CURSOR_ID) > 0)

2395:
2396: L_B_TEMP_WHERE_CLAUSE := L_B_WHERE_CLAUSE;
2397: L_B_TEMP_DATA_LEVEL_DML := l_B_data_level_dml;
2398:
2399: WHILE (DBMS_SQL.Fetch_Rows(L_ATTR_CURSOR_ID) > 0)
2400: LOOP
2401: DBMS_SQL.Column_Value(L_ATTR_CURSOR_ID, 1, l_retrieved_value_char);
2402: l_curr_ag_metadata_obj :=
2403: EGO_USER_ATTRS_COMMON_PVT.Get_Attr_Group_Metadata(P_ATTR_GROUP_ID => to_number(l_retrieved_value_char)

Line 2401: DBMS_SQL.Column_Value(L_ATTR_CURSOR_ID, 1, l_retrieved_value_char);

2397: L_B_TEMP_DATA_LEVEL_DML := l_B_data_level_dml;
2398:
2399: WHILE (DBMS_SQL.Fetch_Rows(L_ATTR_CURSOR_ID) > 0)
2400: LOOP
2401: DBMS_SQL.Column_Value(L_ATTR_CURSOR_ID, 1, l_retrieved_value_char);
2402: l_curr_ag_metadata_obj :=
2403: EGO_USER_ATTRS_COMMON_PVT.Get_Attr_Group_Metadata(P_ATTR_GROUP_ID => to_number(l_retrieved_value_char)
2404: ,P_APPLICATION_ID => p_application_id
2405: ,P_ATTR_GROUP_TYPE => 'EGO_ITEMMGMT_GROUP'

Line 2434: l_prod_cursor_id := DBMS_SQL.Open_Cursor;

2430: END LOOP;
2431:
2432: l_B_data_level_dml := l_B_data_level_dml || L_B_WHERE_CLAUSE;
2433:
2434: l_prod_cursor_id := DBMS_SQL.Open_Cursor;
2435: DBMS_SQL.Parse(l_prod_cursor_id, l_B_data_level_dml, DBMS_SQL.Native);
2436: DBMS_SQL.Describe_Columns(l_prod_cursor_id, l_column_count, l_desc_table);
2437:
2438: FOR i IN 1 .. l_column_count

Line 2435: DBMS_SQL.Parse(l_prod_cursor_id, l_B_data_level_dml, DBMS_SQL.Native);

2431:
2432: l_B_data_level_dml := l_B_data_level_dml || L_B_WHERE_CLAUSE;
2433:
2434: l_prod_cursor_id := DBMS_SQL.Open_Cursor;
2435: DBMS_SQL.Parse(l_prod_cursor_id, l_B_data_level_dml, DBMS_SQL.Native);
2436: DBMS_SQL.Describe_Columns(l_prod_cursor_id, l_column_count, l_desc_table);
2437:
2438: FOR i IN 1 .. l_column_count
2439: LOOP

Line 2436: DBMS_SQL.Describe_Columns(l_prod_cursor_id, l_column_count, l_desc_table);

2432: l_B_data_level_dml := l_B_data_level_dml || L_B_WHERE_CLAUSE;
2433:
2434: l_prod_cursor_id := DBMS_SQL.Open_Cursor;
2435: DBMS_SQL.Parse(l_prod_cursor_id, l_B_data_level_dml, DBMS_SQL.Native);
2436: DBMS_SQL.Describe_Columns(l_prod_cursor_id, l_column_count, l_desc_table);
2437:
2438: FOR i IN 1 .. l_column_count
2439: LOOP
2440: DBMS_SQL.Define_Column(l_prod_cursor_id, i, l_retrieved_value_char, 1000);

Line 2440: DBMS_SQL.Define_Column(l_prod_cursor_id, i, l_retrieved_value_char, 1000);

2436: DBMS_SQL.Describe_Columns(l_prod_cursor_id, l_column_count, l_desc_table);
2437:
2438: FOR i IN 1 .. l_column_count
2439: LOOP
2440: DBMS_SQL.Define_Column(l_prod_cursor_id, i, l_retrieved_value_char, 1000);
2441:
2442: END LOOP;
2443: FOR l_bind_index IN L_BIND_VALUES.FIRST .. L_BIND_VALUES.LAST
2444: LOOP

Line 2445: DBMS_SQL.BIND_VARIABLE(l_prod_cursor_id, ':'||l_bind_index,L_BIND_VALUES(l_bind_index).VALUE);

2441:
2442: END LOOP;
2443: FOR l_bind_index IN L_BIND_VALUES.FIRST .. L_BIND_VALUES.LAST
2444: LOOP
2445: DBMS_SQL.BIND_VARIABLE(l_prod_cursor_id, ':'||l_bind_index,L_BIND_VALUES(l_bind_index).VALUE);
2446:
2447: END LOOP;
2448: l_dummy := DBMS_SQL.Execute(l_prod_cursor_id);
2449:

Line 2448: l_dummy := DBMS_SQL.Execute(l_prod_cursor_id);

2444: LOOP
2445: DBMS_SQL.BIND_VARIABLE(l_prod_cursor_id, ':'||l_bind_index,L_BIND_VALUES(l_bind_index).VALUE);
2446:
2447: END LOOP;
2448: l_dummy := DBMS_SQL.Execute(l_prod_cursor_id);
2449:
2450:
2451: WHILE (DBMS_SQL.Fetch_Rows(l_prod_cursor_id) > 0)
2452: LOOP

Line 2451: WHILE (DBMS_SQL.Fetch_Rows(l_prod_cursor_id) > 0)

2447: END LOOP;
2448: l_dummy := DBMS_SQL.Execute(l_prod_cursor_id);
2449:
2450:
2451: WHILE (DBMS_SQL.Fetch_Rows(l_prod_cursor_id) > 0)
2452: LOOP
2453: FOR i IN 1 .. l_column_count
2454: LOOP
2455: DBMS_SQL.Column_Value(l_prod_cursor_id, i, l_retrieved_value_char);

Line 2455: DBMS_SQL.Column_Value(l_prod_cursor_id, i, l_retrieved_value_char);

2451: WHILE (DBMS_SQL.Fetch_Rows(l_prod_cursor_id) > 0)
2452: LOOP
2453: FOR i IN 1 .. l_column_count
2454: LOOP
2455: DBMS_SQL.Column_Value(l_prod_cursor_id, i, l_retrieved_value_char);
2456: DBMS_SQL.BIND_VARIABLE(l_B_cursor_id, ':'||i,TO_NUMBER(l_retrieved_value_char));
2457: DBMS_SQL.BIND_VARIABLE(l_TL_cursor_id, ':'||i,TO_NUMBER(l_retrieved_value_char));
2458:
2459: END LOOP;

Line 2456: DBMS_SQL.BIND_VARIABLE(l_B_cursor_id, ':'||i,TO_NUMBER(l_retrieved_value_char));

2452: LOOP
2453: FOR i IN 1 .. l_column_count
2454: LOOP
2455: DBMS_SQL.Column_Value(l_prod_cursor_id, i, l_retrieved_value_char);
2456: DBMS_SQL.BIND_VARIABLE(l_B_cursor_id, ':'||i,TO_NUMBER(l_retrieved_value_char));
2457: DBMS_SQL.BIND_VARIABLE(l_TL_cursor_id, ':'||i,TO_NUMBER(l_retrieved_value_char));
2458:
2459: END LOOP;
2460: l_dummy := DBMS_SQL.Execute(l_B_cursor_id);

Line 2457: DBMS_SQL.BIND_VARIABLE(l_TL_cursor_id, ':'||i,TO_NUMBER(l_retrieved_value_char));

2453: FOR i IN 1 .. l_column_count
2454: LOOP
2455: DBMS_SQL.Column_Value(l_prod_cursor_id, i, l_retrieved_value_char);
2456: DBMS_SQL.BIND_VARIABLE(l_B_cursor_id, ':'||i,TO_NUMBER(l_retrieved_value_char));
2457: DBMS_SQL.BIND_VARIABLE(l_TL_cursor_id, ':'||i,TO_NUMBER(l_retrieved_value_char));
2458:
2459: END LOOP;
2460: l_dummy := DBMS_SQL.Execute(l_B_cursor_id);
2461: L_dummy := DBMS_SQL.Execute(l_TL_cursor_id);

Line 2460: l_dummy := DBMS_SQL.Execute(l_B_cursor_id);

2456: DBMS_SQL.BIND_VARIABLE(l_B_cursor_id, ':'||i,TO_NUMBER(l_retrieved_value_char));
2457: DBMS_SQL.BIND_VARIABLE(l_TL_cursor_id, ':'||i,TO_NUMBER(l_retrieved_value_char));
2458:
2459: END LOOP;
2460: l_dummy := DBMS_SQL.Execute(l_B_cursor_id);
2461: L_dummy := DBMS_SQL.Execute(l_TL_cursor_id);
2462: END LOOP;
2463:
2464: END LOOP;-- WHILE ATTR GROUP CURSOR

Line 2461: L_dummy := DBMS_SQL.Execute(l_TL_cursor_id);

2457: DBMS_SQL.BIND_VARIABLE(l_TL_cursor_id, ':'||i,TO_NUMBER(l_retrieved_value_char));
2458:
2459: END LOOP;
2460: l_dummy := DBMS_SQL.Execute(l_B_cursor_id);
2461: L_dummy := DBMS_SQL.Execute(l_TL_cursor_id);
2462: END LOOP;
2463:
2464: END LOOP;-- WHILE ATTR GROUP CURSOR
2465: L_ADDED_WHERE_CLAUSE := L_ADDED_WHERE_CLAUSE || ')';