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: --begin add for bug 9127677
712: IF DBMS_SQL.IS_OPEN(l_cursor_id) then
713: DBMS_SQL.Close_Cursor(l_cursor_id);
714: END IF;

Line 712: IF DBMS_SQL.IS_OPEN(l_cursor_id) then

708: END IF;
709:
710: l_number_of_rows := DBMS_SQL.Execute(l_cursor_id);
711: --begin add for bug 9127677
712: IF DBMS_SQL.IS_OPEN(l_cursor_id) then
713: DBMS_SQL.Close_Cursor(l_cursor_id);
714: END IF;
715: --end add for bug 9127677
716:

Line 713: DBMS_SQL.Close_Cursor(l_cursor_id);

709:
710: l_number_of_rows := DBMS_SQL.Execute(l_cursor_id);
711: --begin add for bug 9127677
712: IF DBMS_SQL.IS_OPEN(l_cursor_id) then
713: DBMS_SQL.Close_Cursor(l_cursor_id);
714: END IF;
715: --end add for bug 9127677
716:
717: END IF;

Line 780: l_desc_table DBMS_SQL.Desc_Tab;

776: l_dynamic_sql VARCHAR2(20000);
777: l_column_count NUMBER;
778: l_uk_where_clause VARCHAR2(4000):= null;
779: l_cursor_id NUMBER;
780: l_desc_table DBMS_SQL.Desc_Tab;
781: l_dummy NUMBER;
782: L_CACHED_SQL_FOUND VARCHAR2(1) := 'N';
783: p_prod_vl_name VARCHAR2(40);
784: l_DataLevelColumnExists VARCHAR2(5);

Line 1118: l_cursor_id := DBMS_SQL.Open_Cursor;

1114: END LOOP;
1115: END IF;
1116:
1117:
1118: l_cursor_id := DBMS_SQL.Open_Cursor;
1119: -- prg_debug(l_dynamic_sql);
1120: -- prg_debug(l_bind_index);
1121: DBMS_SQL.Parse(l_cursor_id, l_dynamic_sql, DBMS_SQL.Native);
1122: DBMS_SQL.Describe_Columns(l_cursor_id, l_column_count, l_desc_table);

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

1117:
1118: l_cursor_id := DBMS_SQL.Open_Cursor;
1119: -- prg_debug(l_dynamic_sql);
1120: -- prg_debug(l_bind_index);
1121: DBMS_SQL.Parse(l_cursor_id, l_dynamic_sql, DBMS_SQL.Native);
1122: DBMS_SQL.Describe_Columns(l_cursor_id, l_column_count, l_desc_table);
1123: FOR i IN 1 .. l_column_count
1124: LOOP
1125:

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

1118: l_cursor_id := DBMS_SQL.Open_Cursor;
1119: -- prg_debug(l_dynamic_sql);
1120: -- prg_debug(l_bind_index);
1121: DBMS_SQL.Parse(l_cursor_id, l_dynamic_sql, DBMS_SQL.Native);
1122: DBMS_SQL.Describe_Columns(l_cursor_id, l_column_count, l_desc_table);
1123: FOR i IN 1 .. l_column_count
1124: LOOP
1125:
1126: DBMS_SQL.Define_Column(l_cursor_id, i, l_retrieved_value_char, 1000);

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

1122: DBMS_SQL.Describe_Columns(l_cursor_id, l_column_count, l_desc_table);
1123: FOR i IN 1 .. l_column_count
1124: LOOP
1125:
1126: DBMS_SQL.Define_Column(l_cursor_id, i, l_retrieved_value_char, 1000);
1127:
1128: END LOOP;
1129:
1130: FOR l_bind_index IN l_bind_values.FIRST .. l_bind_values.LAST

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

1131: LOOP
1132: IF ( l_bind_values(l_bind_index).ATTR_VALUE_STR is not NULL)
1133: THEN
1134: -- prg_debug(l_bind_values(l_bind_index).ATTR_VALUE_STR);
1135: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':'||l_bind_index,l_bind_values(l_bind_index).ATTR_VALUE_STR);
1136: ELSIF (l_bind_values(l_bind_index).ATTR_VALUE_NUM is not NULL)
1137: THEN
1138: -- prg_debug(l_bind_values(l_bind_index).ATTR_VALUE_NUM);
1139: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':'||l_bind_index,l_bind_values(l_bind_index).ATTR_VALUE_NUM);

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

1135: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':'||l_bind_index,l_bind_values(l_bind_index).ATTR_VALUE_STR);
1136: ELSIF (l_bind_values(l_bind_index).ATTR_VALUE_NUM is not NULL)
1137: THEN
1138: -- prg_debug(l_bind_values(l_bind_index).ATTR_VALUE_NUM);
1139: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':'||l_bind_index,l_bind_values(l_bind_index).ATTR_VALUE_NUM);
1140: ELSIF (l_bind_values(l_bind_index).ATTR_VALUE_DATE is not NULL)
1141: THEN
1142: --prg_debug(l_bind_values(l_bind_index).ATTR_VALUE_DATE);
1143: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':'||l_bind_index,l_bind_values(l_bind_index).ATTR_VALUE_DATE);

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

1139: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':'||l_bind_index,l_bind_values(l_bind_index).ATTR_VALUE_NUM);
1140: ELSIF (l_bind_values(l_bind_index).ATTR_VALUE_DATE is not NULL)
1141: THEN
1142: --prg_debug(l_bind_values(l_bind_index).ATTR_VALUE_DATE);
1143: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':'||l_bind_index,l_bind_values(l_bind_index).ATTR_VALUE_DATE);
1144: ELSE
1145: -- prg_debug(l_bind_values(l_bind_index).ATTR_VALUE_STR);
1146: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':'||l_bind_index,l_bind_values(l_bind_index).ATTR_VALUE_STR);
1147: END IF;

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

1142: --prg_debug(l_bind_values(l_bind_index).ATTR_VALUE_DATE);
1143: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':'||l_bind_index,l_bind_values(l_bind_index).ATTR_VALUE_DATE);
1144: ELSE
1145: -- prg_debug(l_bind_values(l_bind_index).ATTR_VALUE_STR);
1146: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':'||l_bind_index,l_bind_values(l_bind_index).ATTR_VALUE_STR);
1147: END IF;
1148:
1149: END LOOP;
1150:

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

1149: END LOOP;
1150:
1151:
1152:
1153: l_dummy := DBMS_SQL.Execute(l_cursor_id);
1154:
1155: if ( DBMS_SQL.Fetch_Rows(l_cursor_id) > 0)
1156: THEN
1157: x_return_status := FND_API.G_RET_STS_ERROR;

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

1151:
1152:
1153: l_dummy := DBMS_SQL.Execute(l_cursor_id);
1154:
1155: if ( DBMS_SQL.Fetch_Rows(l_cursor_id) > 0)
1156: THEN
1157: x_return_status := FND_API.G_RET_STS_ERROR;
1158: ERROR_HANDLER.Initialize();
1159: ERROR_HANDLER.Set_Bo_Identifier(EGO_USER_ATTRS_DATA_PVT.G_BO_IDENTIFIER);

Line 1181: IF DBMS_SQL.IS_OPEN(l_cursor_id) then

1177: END IF;
1178:
1179: END IF;
1180: --begin add for bug 9127677
1181: IF DBMS_SQL.IS_OPEN(l_cursor_id) then
1182: DBMS_SQL.Close_Cursor(l_cursor_id);
1183: END IF;
1184: --end add for bug 9127677
1185: END IF ; -- attribute group is MULTI ROW.

Line 1182: DBMS_SQL.Close_Cursor(l_cursor_id);

1178:
1179: END IF;
1180: --begin add for bug 9127677
1181: IF DBMS_SQL.IS_OPEN(l_cursor_id) then
1182: DBMS_SQL.Close_Cursor(l_cursor_id);
1183: END IF;
1184: --end add for bug 9127677
1185: END IF ; -- attribute group is MULTI ROW.
1186:

Line 1369: l_cursor_id INTEGER := DBMS_SQL.OPEN_CURSOR;

1365:
1366: l_pending_base_tbl VARCHAR2(100);
1367: l_pending_tl_tbl VARCHAR2(100);
1368: l_pending_vl VARCHAR2(100);
1369: l_cursor_id INTEGER := DBMS_SQL.OPEN_CURSOR;
1370: l_number_of_rows NUMBER :=0;
1371: l_attr_group_request_table EGO_ATTR_GROUP_REQUEST_TABLE;
1372: L_ATTRIBUTES_DATA_TABLE EGO_USER_ATTR_DATA_TABLE;
1373: l_attributes_row_table EGO_USER_ATTR_ROW_TABLE;

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

1658: l_b_bind_attr_table(l_bind_index).ATTR_VALUE_NUM := l_extension_id;
1659: END IF;
1660: IF l_b_dml_for_ag IS NOT NULL
1661: THEN
1662: DBMS_SQL.Parse(l_cursor_id, l_b_dml_for_ag, DBMS_SQL.Native);
1663:
1664: if l_b_bind_attr_table is NOT NULL AND p_mode <>'DELETE'
1665: THEN
1666:

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

1680: END IF;
1681: END LOOP;
1682: IF ( l_b_bind_attr_table(l_bind_index).ATTR_VALUE_STR is not NULL)
1683: THEN
1684: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':FND_BIND'||l_bind_index,l_b_bind_attr_table(l_bind_index).ATTR_VALUE_STR);
1685: ELSIF (l_b_bind_attr_table(l_bind_index).ATTR_VALUE_NUM is not NULL)
1686: THEN
1687: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':FND_BIND'||l_bind_index,l_b_bind_attr_table(l_bind_index).ATTR_VALUE_NUM);
1688: ELSIF (l_b_bind_attr_table(l_bind_index).ATTR_VALUE_DATE is not NULL)

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

1683: THEN
1684: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':FND_BIND'||l_bind_index,l_b_bind_attr_table(l_bind_index).ATTR_VALUE_STR);
1685: ELSIF (l_b_bind_attr_table(l_bind_index).ATTR_VALUE_NUM is not NULL)
1686: THEN
1687: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':FND_BIND'||l_bind_index,l_b_bind_attr_table(l_bind_index).ATTR_VALUE_NUM);
1688: ELSIF (l_b_bind_attr_table(l_bind_index).ATTR_VALUE_DATE is not NULL)
1689: THEN
1690: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':FND_BIND'||l_bind_index,l_b_bind_attr_table(l_bind_index).ATTR_VALUE_DATE);
1691: ELSE

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

1686: THEN
1687: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':FND_BIND'||l_bind_index,l_b_bind_attr_table(l_bind_index).ATTR_VALUE_NUM);
1688: ELSIF (l_b_bind_attr_table(l_bind_index).ATTR_VALUE_DATE is not NULL)
1689: THEN
1690: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':FND_BIND'||l_bind_index,l_b_bind_attr_table(l_bind_index).ATTR_VALUE_DATE);
1691: ELSE
1692: IF l_bind_index = l_b_bind_attr_table.LAST AND (p_mode ='UPDATE' OR p_mode ='DELETE')
1693: THEN
1694: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':FND_BIND'||l_bind_index,l_extension_id);

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

1690: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':FND_BIND'||l_bind_index,l_b_bind_attr_table(l_bind_index).ATTR_VALUE_DATE);
1691: ELSE
1692: IF l_bind_index = l_b_bind_attr_table.LAST AND (p_mode ='UPDATE' OR p_mode ='DELETE')
1693: THEN
1694: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':FND_BIND'||l_bind_index,l_extension_id);
1695: ELSE
1696: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':FND_BIND'||l_bind_index,l_b_bind_attr_table(l_bind_index).ATTR_VALUE_STR);
1697: END IF;
1698: END IF;

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

1692: IF l_bind_index = l_b_bind_attr_table.LAST AND (p_mode ='UPDATE' OR p_mode ='DELETE')
1693: THEN
1694: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':FND_BIND'||l_bind_index,l_extension_id);
1695: ELSE
1696: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':FND_BIND'||l_bind_index,l_b_bind_attr_table(l_bind_index).ATTR_VALUE_STR);
1697: END IF;
1698: END IF;
1699:
1700: END LOOP;

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

1699:
1700: END LOOP;
1701: END IF;
1702:
1703: l_number_of_rows := DBMS_SQL.Execute(l_cursor_id);
1704: DBMS_SQL.Close_Cursor(l_cursor_id);
1705: END IF;
1706:
1707: if p_mode = 'CREATE' and (p_acd_type ='CHANGE' OR p_acd_type ='DELETE') AND l_tl_bind_attr_table is NOT NULL

Line 1704: DBMS_SQL.Close_Cursor(l_cursor_id);

1700: END LOOP;
1701: END IF;
1702:
1703: l_number_of_rows := DBMS_SQL.Execute(l_cursor_id);
1704: DBMS_SQL.Close_Cursor(l_cursor_id);
1705: END IF;
1706:
1707: if p_mode = 'CREATE' and (p_acd_type ='CHANGE' OR p_acd_type ='DELETE') AND l_tl_bind_attr_table is NOT NULL
1708: THEN

Line 1716: l_cursor_id := DBMS_SQL.OPEN_CURSOR;

1712:
1713:
1714: IF l_tl_dml_for_ag is NOT NULL
1715: THEN
1716: l_cursor_id := DBMS_SQL.OPEN_CURSOR;
1717:
1718: DBMS_SQL.Parse(l_cursor_id, l_tl_dml_for_ag, DBMS_SQL.Native);
1719:
1720: IF l_tl_bind_attr_table is NOT NULL AND p_mode <>'DELETE'

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

1714: IF l_tl_dml_for_ag is NOT NULL
1715: THEN
1716: l_cursor_id := DBMS_SQL.OPEN_CURSOR;
1717:
1718: DBMS_SQL.Parse(l_cursor_id, l_tl_dml_for_ag, DBMS_SQL.Native);
1719:
1720: IF l_tl_bind_attr_table is NOT NULL AND p_mode <>'DELETE'
1721: THEN
1722: FOR l_bind_index IN l_tl_bind_attr_table.FIRST .. l_tl_bind_attr_table.LAST

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

1734: END LOOP;
1735: IF ( l_tl_bind_attr_table(l_bind_index).ATTR_VALUE_STR is not NULL)
1736: THEN
1737:
1738: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':FND_BIND'||l_bind_index,l_tl_bind_attr_table(l_bind_index).ATTR_VALUE_STR);
1739: ELSIF (l_tl_bind_attr_table(l_bind_index).ATTR_VALUE_NUM is not NULL)
1740: THEN
1741:
1742: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':FND_BIND'||l_bind_index,l_tl_bind_attr_table(l_bind_index).ATTR_VALUE_NUM);

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

1738: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':FND_BIND'||l_bind_index,l_tl_bind_attr_table(l_bind_index).ATTR_VALUE_STR);
1739: ELSIF (l_tl_bind_attr_table(l_bind_index).ATTR_VALUE_NUM is not NULL)
1740: THEN
1741:
1742: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':FND_BIND'||l_bind_index,l_tl_bind_attr_table(l_bind_index).ATTR_VALUE_NUM);
1743: ELSIF (l_tl_bind_attr_table(l_bind_index).ATTR_VALUE_DATE is not NULL)
1744: THEN
1745:
1746: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':FND_BIND'||l_bind_index,l_tl_bind_attr_table(l_bind_index).ATTR_VALUE_DATE);

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

1742: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':FND_BIND'||l_bind_index,l_tl_bind_attr_table(l_bind_index).ATTR_VALUE_NUM);
1743: ELSIF (l_tl_bind_attr_table(l_bind_index).ATTR_VALUE_DATE is not NULL)
1744: THEN
1745:
1746: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':FND_BIND'||l_bind_index,l_tl_bind_attr_table(l_bind_index).ATTR_VALUE_DATE);
1747: ELSE
1748: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':FND_BIND'||l_bind_index,l_tl_bind_attr_table(l_bind_index).ATTR_VALUE_STR);
1749: END IF;
1750:

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

1744: THEN
1745:
1746: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':FND_BIND'||l_bind_index,l_tl_bind_attr_table(l_bind_index).ATTR_VALUE_DATE);
1747: ELSE
1748: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':FND_BIND'||l_bind_index,l_tl_bind_attr_table(l_bind_index).ATTR_VALUE_STR);
1749: END IF;
1750:
1751:
1752: END LOOP;

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

1750:
1751:
1752: END LOOP;
1753: END IF;
1754: l_number_of_rows := DBMS_SQL.Execute(l_cursor_id);
1755:
1756: DBMS_SQL.Close_Cursor(l_cursor_id);
1757: END IF;
1758:

Line 1756: DBMS_SQL.Close_Cursor(l_cursor_id);

1752: END LOOP;
1753: END IF;
1754: l_number_of_rows := DBMS_SQL.Execute(l_cursor_id);
1755:
1756: DBMS_SQL.Close_Cursor(l_cursor_id);
1757: END IF;
1758:
1759: END IF;
1760: END IF;

Line 2211: l_desc_table DBMS_SQL.Desc_Tab;

2207: L_TL_CURSOR_ID NUMBER;
2208: l_retrieved_value_char VARCHAR(1000);
2209: l_column_count NUMBER;
2210: l_dummy NUMBER;
2211: l_desc_table DBMS_SQL.Desc_Tab;
2212: l_b_update_dml VARCHAR2(10000);
2213: l_tl_update_dml VARCHAR2(10000);
2214: L_UPDATE_WHERE_CLAUSE VARCHAR2(4000) := NULL;
2215: L_UPDATE_BIND_INDEX NUMBER :=0;

Line 2323: L_ATTR_CURSOR_ID := DBMS_SQL.Open_Cursor;

2319: END LOOP;
2320: L_DYN_ATTR_GRP_SQL := L_DYN_ATTR_GRP_SQL ||')';
2321: END IF;
2322:
2323: L_ATTR_CURSOR_ID := DBMS_SQL.Open_Cursor;
2324: DBMS_SQL.Parse(L_ATTR_CURSOR_ID, L_DYN_ATTR_GRP_SQL, DBMS_SQL.Native);
2325: DBMS_SQL.Describe_Columns(L_ATTR_CURSOR_ID, l_column_count, l_desc_table);
2326: FOR i IN 1 .. l_column_count
2327: LOOP

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

2320: L_DYN_ATTR_GRP_SQL := L_DYN_ATTR_GRP_SQL ||')';
2321: END IF;
2322:
2323: L_ATTR_CURSOR_ID := DBMS_SQL.Open_Cursor;
2324: DBMS_SQL.Parse(L_ATTR_CURSOR_ID, L_DYN_ATTR_GRP_SQL, DBMS_SQL.Native);
2325: DBMS_SQL.Describe_Columns(L_ATTR_CURSOR_ID, l_column_count, l_desc_table);
2326: FOR i IN 1 .. l_column_count
2327: LOOP
2328: DBMS_SQL.Define_Column(L_ATTR_CURSOR_ID, i, l_retrieved_value_char, 1000);

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

2321: END IF;
2322:
2323: L_ATTR_CURSOR_ID := DBMS_SQL.Open_Cursor;
2324: DBMS_SQL.Parse(L_ATTR_CURSOR_ID, L_DYN_ATTR_GRP_SQL, DBMS_SQL.Native);
2325: DBMS_SQL.Describe_Columns(L_ATTR_CURSOR_ID, l_column_count, l_desc_table);
2326: FOR i IN 1 .. l_column_count
2327: LOOP
2328: DBMS_SQL.Define_Column(L_ATTR_CURSOR_ID, i, l_retrieved_value_char, 1000);
2329:

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

2324: DBMS_SQL.Parse(L_ATTR_CURSOR_ID, L_DYN_ATTR_GRP_SQL, DBMS_SQL.Native);
2325: DBMS_SQL.Describe_Columns(L_ATTR_CURSOR_ID, l_column_count, l_desc_table);
2326: FOR i IN 1 .. l_column_count
2327: LOOP
2328: DBMS_SQL.Define_Column(L_ATTR_CURSOR_ID, i, l_retrieved_value_char, 1000);
2329:
2330: END LOOP;
2331: FOR l_bind_index IN L_PEND_BIND_VALUES.FIRST .. L_PEND_BIND_VALUES.LAST
2332: LOOP

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

2329:
2330: END LOOP;
2331: FOR l_bind_index IN L_PEND_BIND_VALUES.FIRST .. L_PEND_BIND_VALUES.LAST
2332: LOOP
2333: DBMS_SQL.BIND_VARIABLE(L_ATTR_CURSOR_ID, ':'||l_bind_index,L_PEND_BIND_VALUES(l_bind_index).VALUE);
2334:
2335: END LOOP;
2336:
2337: l_dummy := DBMS_SQL.Execute(L_ATTR_CURSOR_ID);

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

2333: DBMS_SQL.BIND_VARIABLE(L_ATTR_CURSOR_ID, ':'||l_bind_index,L_PEND_BIND_VALUES(l_bind_index).VALUE);
2334:
2335: END LOOP;
2336:
2337: l_dummy := DBMS_SQL.Execute(L_ATTR_CURSOR_ID);
2338:
2339:
2340: L_ADDED_WHERE_CLAUSE := L_ADDED_WHERE_CLAUSE
2341: ||' AND ACD_TYPE = ''ADD'' AND ATTR_GROUP_ID IN (-1';

Line 2413: l_B_cursor_id:= DBMS_SQL.OPEN_CURSOR;

2409: L_TL_UPDATE_DML := L_TL_UPDATE_DML || L_UPDATE_WHERE_CLAUSE;
2410:
2411: l_B_data_level_dml := l_B_data_level_dml || ', B.EXTENSION_ID ';
2412:
2413: l_B_cursor_id:= DBMS_SQL.OPEN_CURSOR;
2414: DBMS_SQL.Parse(l_B_cursor_id, L_B_UPDATE_DML, DBMS_SQL.Native);
2415:
2416: l_TL_cursor_id:= DBMS_SQL.OPEN_CURSOR;
2417: DBMS_SQL.Parse(l_TL_cursor_id, L_TL_UPDATE_DML, DBMS_SQL.Native);

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

2410:
2411: l_B_data_level_dml := l_B_data_level_dml || ', B.EXTENSION_ID ';
2412:
2413: l_B_cursor_id:= DBMS_SQL.OPEN_CURSOR;
2414: DBMS_SQL.Parse(l_B_cursor_id, L_B_UPDATE_DML, DBMS_SQL.Native);
2415:
2416: l_TL_cursor_id:= DBMS_SQL.OPEN_CURSOR;
2417: DBMS_SQL.Parse(l_TL_cursor_id, L_TL_UPDATE_DML, DBMS_SQL.Native);
2418:

Line 2416: l_TL_cursor_id:= DBMS_SQL.OPEN_CURSOR;

2412:
2413: l_B_cursor_id:= DBMS_SQL.OPEN_CURSOR;
2414: DBMS_SQL.Parse(l_B_cursor_id, L_B_UPDATE_DML, DBMS_SQL.Native);
2415:
2416: l_TL_cursor_id:= DBMS_SQL.OPEN_CURSOR;
2417: DBMS_SQL.Parse(l_TL_cursor_id, L_TL_UPDATE_DML, DBMS_SQL.Native);
2418:
2419:
2420: L_BIND_INDEX := L_BIND_INDEX +1;

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

2413: l_B_cursor_id:= DBMS_SQL.OPEN_CURSOR;
2414: DBMS_SQL.Parse(l_B_cursor_id, L_B_UPDATE_DML, DBMS_SQL.Native);
2415:
2416: l_TL_cursor_id:= DBMS_SQL.OPEN_CURSOR;
2417: DBMS_SQL.Parse(l_TL_cursor_id, L_TL_UPDATE_DML, DBMS_SQL.Native);
2418:
2419:
2420: L_BIND_INDEX := L_BIND_INDEX +1;
2421: L_B_WHERE_CLAUSE := L_B_WHERE_CLAUSE ||

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

2426:
2427: L_B_TEMP_WHERE_CLAUSE := L_B_WHERE_CLAUSE;
2428: L_B_TEMP_DATA_LEVEL_DML := l_B_data_level_dml;
2429:
2430: WHILE (DBMS_SQL.Fetch_Rows(L_ATTR_CURSOR_ID) > 0)
2431: LOOP
2432: DBMS_SQL.Column_Value(L_ATTR_CURSOR_ID, 1, l_retrieved_value_char);
2433: l_curr_ag_metadata_obj :=
2434: EGO_USER_ATTRS_COMMON_PVT.Get_Attr_Group_Metadata(P_ATTR_GROUP_ID => to_number(l_retrieved_value_char)

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

2428: L_B_TEMP_DATA_LEVEL_DML := l_B_data_level_dml;
2429:
2430: WHILE (DBMS_SQL.Fetch_Rows(L_ATTR_CURSOR_ID) > 0)
2431: LOOP
2432: DBMS_SQL.Column_Value(L_ATTR_CURSOR_ID, 1, l_retrieved_value_char);
2433: l_curr_ag_metadata_obj :=
2434: EGO_USER_ATTRS_COMMON_PVT.Get_Attr_Group_Metadata(P_ATTR_GROUP_ID => to_number(l_retrieved_value_char)
2435: ,P_APPLICATION_ID => p_application_id
2436: ,P_ATTR_GROUP_TYPE => 'EGO_ITEMMGMT_GROUP'

Line 2465: l_prod_cursor_id := DBMS_SQL.Open_Cursor;

2461: END LOOP;
2462:
2463: l_B_data_level_dml := l_B_data_level_dml || L_B_WHERE_CLAUSE;
2464:
2465: l_prod_cursor_id := DBMS_SQL.Open_Cursor;
2466: DBMS_SQL.Parse(l_prod_cursor_id, l_B_data_level_dml, DBMS_SQL.Native);
2467: DBMS_SQL.Describe_Columns(l_prod_cursor_id, l_column_count, l_desc_table);
2468:
2469: FOR i IN 1 .. l_column_count

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

2462:
2463: l_B_data_level_dml := l_B_data_level_dml || L_B_WHERE_CLAUSE;
2464:
2465: l_prod_cursor_id := DBMS_SQL.Open_Cursor;
2466: DBMS_SQL.Parse(l_prod_cursor_id, l_B_data_level_dml, DBMS_SQL.Native);
2467: DBMS_SQL.Describe_Columns(l_prod_cursor_id, l_column_count, l_desc_table);
2468:
2469: FOR i IN 1 .. l_column_count
2470: LOOP

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

2463: l_B_data_level_dml := l_B_data_level_dml || L_B_WHERE_CLAUSE;
2464:
2465: l_prod_cursor_id := DBMS_SQL.Open_Cursor;
2466: DBMS_SQL.Parse(l_prod_cursor_id, l_B_data_level_dml, DBMS_SQL.Native);
2467: DBMS_SQL.Describe_Columns(l_prod_cursor_id, l_column_count, l_desc_table);
2468:
2469: FOR i IN 1 .. l_column_count
2470: LOOP
2471: DBMS_SQL.Define_Column(l_prod_cursor_id, i, l_retrieved_value_char, 1000);

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

2467: DBMS_SQL.Describe_Columns(l_prod_cursor_id, l_column_count, l_desc_table);
2468:
2469: FOR i IN 1 .. l_column_count
2470: LOOP
2471: DBMS_SQL.Define_Column(l_prod_cursor_id, i, l_retrieved_value_char, 1000);
2472:
2473: END LOOP;
2474: FOR l_bind_index IN L_BIND_VALUES.FIRST .. L_BIND_VALUES.LAST
2475: LOOP

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

2472:
2473: END LOOP;
2474: FOR l_bind_index IN L_BIND_VALUES.FIRST .. L_BIND_VALUES.LAST
2475: LOOP
2476: DBMS_SQL.BIND_VARIABLE(l_prod_cursor_id, ':'||l_bind_index,L_BIND_VALUES(l_bind_index).VALUE);
2477:
2478: END LOOP;
2479: l_dummy := DBMS_SQL.Execute(l_prod_cursor_id);
2480:

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

2475: LOOP
2476: DBMS_SQL.BIND_VARIABLE(l_prod_cursor_id, ':'||l_bind_index,L_BIND_VALUES(l_bind_index).VALUE);
2477:
2478: END LOOP;
2479: l_dummy := DBMS_SQL.Execute(l_prod_cursor_id);
2480:
2481:
2482: WHILE (DBMS_SQL.Fetch_Rows(l_prod_cursor_id) > 0)
2483: LOOP

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

2478: END LOOP;
2479: l_dummy := DBMS_SQL.Execute(l_prod_cursor_id);
2480:
2481:
2482: WHILE (DBMS_SQL.Fetch_Rows(l_prod_cursor_id) > 0)
2483: LOOP
2484: FOR i IN 1 .. l_column_count
2485: LOOP
2486: DBMS_SQL.Column_Value(l_prod_cursor_id, i, l_retrieved_value_char);

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

2482: WHILE (DBMS_SQL.Fetch_Rows(l_prod_cursor_id) > 0)
2483: LOOP
2484: FOR i IN 1 .. l_column_count
2485: LOOP
2486: DBMS_SQL.Column_Value(l_prod_cursor_id, i, l_retrieved_value_char);
2487: DBMS_SQL.BIND_VARIABLE(l_B_cursor_id, ':'||i,TO_NUMBER(l_retrieved_value_char));
2488: DBMS_SQL.BIND_VARIABLE(l_TL_cursor_id, ':'||i,TO_NUMBER(l_retrieved_value_char));
2489:
2490: END LOOP;

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

2483: LOOP
2484: FOR i IN 1 .. l_column_count
2485: LOOP
2486: DBMS_SQL.Column_Value(l_prod_cursor_id, i, l_retrieved_value_char);
2487: DBMS_SQL.BIND_VARIABLE(l_B_cursor_id, ':'||i,TO_NUMBER(l_retrieved_value_char));
2488: DBMS_SQL.BIND_VARIABLE(l_TL_cursor_id, ':'||i,TO_NUMBER(l_retrieved_value_char));
2489:
2490: END LOOP;
2491: l_dummy := DBMS_SQL.Execute(l_B_cursor_id);

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

2484: FOR i IN 1 .. l_column_count
2485: LOOP
2486: DBMS_SQL.Column_Value(l_prod_cursor_id, i, l_retrieved_value_char);
2487: DBMS_SQL.BIND_VARIABLE(l_B_cursor_id, ':'||i,TO_NUMBER(l_retrieved_value_char));
2488: DBMS_SQL.BIND_VARIABLE(l_TL_cursor_id, ':'||i,TO_NUMBER(l_retrieved_value_char));
2489:
2490: END LOOP;
2491: l_dummy := DBMS_SQL.Execute(l_B_cursor_id);
2492: L_dummy := DBMS_SQL.Execute(l_TL_cursor_id);

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

2487: DBMS_SQL.BIND_VARIABLE(l_B_cursor_id, ':'||i,TO_NUMBER(l_retrieved_value_char));
2488: DBMS_SQL.BIND_VARIABLE(l_TL_cursor_id, ':'||i,TO_NUMBER(l_retrieved_value_char));
2489:
2490: END LOOP;
2491: l_dummy := DBMS_SQL.Execute(l_B_cursor_id);
2492: L_dummy := DBMS_SQL.Execute(l_TL_cursor_id);
2493: END LOOP;
2494:
2495: END LOOP;-- WHILE ATTR GROUP CURSOR

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

2488: DBMS_SQL.BIND_VARIABLE(l_TL_cursor_id, ':'||i,TO_NUMBER(l_retrieved_value_char));
2489:
2490: END LOOP;
2491: l_dummy := DBMS_SQL.Execute(l_B_cursor_id);
2492: L_dummy := DBMS_SQL.Execute(l_TL_cursor_id);
2493: END LOOP;
2494:
2495: END LOOP;-- WHILE ATTR GROUP CURSOR
2496: L_ADDED_WHERE_CLAUSE := L_ADDED_WHERE_CLAUSE || ')';