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.EGO_USER_ATTRS_BULK_PVT dependencies on DBMS_LOB

Line 1177: l_clob_length_1 := dbms_lob.getlength(l_dynamic_sql_1_clob_part1);

1173: code_debug(' Preparing l_dynamic_sql_1_v_type ' ,3);
1174: l_dynamic_sql_1_v_type(1) := 'UPDATE '||p_interface_table_name||' UAI1 SET PROCESS_STATUS = PROCESS_STATUS + DECODE((';
1175:
1176: l_dynamic_sql_1_clob_part1 := p_tvs_val_check_sel_clob;
1177: l_clob_length_1 := dbms_lob.getlength(l_dynamic_sql_1_clob_part1);
1178:
1179: code_debug(' Length of l_dynamic_sql_1_clob_part1 :'||l_clob_length_1, 3);
1180:
1181: /* Read 8191 characters from clob sequentially and append them to the VARCHAR2 table

Line 1182: using DBMS_LOB.READ function */

1178:
1179: code_debug(' Length of l_dynamic_sql_1_clob_part1 :'||l_clob_length_1, 3);
1180:
1181: /* Read 8191 characters from clob sequentially and append them to the VARCHAR2 table
1182: using DBMS_LOB.READ function */
1183: l_offset := 1;
1184: l_count := 0;
1185: l_index_1 := 2;
1186: l_amount := 8191;

Line 1194: dbms_lob.read(l_dynamic_sql_1_clob_part1, l_amount, l_offset, l_buffer);

1190: while l_offset <= l_clob_length_1 LOOP
1191: l_buffer := '';
1192: l_count := l_count + 1;
1193:
1194: dbms_lob.read(l_dynamic_sql_1_clob_part1, l_amount, l_offset, l_buffer);
1195:
1196: IF (l_count = 4) THEN
1197: l_count := 0;
1198: l_index_1 := l_index_1 + 1 ;

Line 1227: l_clob_length := dbms_lob.getlength(l_dynamic_sql_clob_part1);

1223: code_debug(' Preparing l_dynamic_sql_v_type :' ,3);
1224: l_dynamic_sql_v_type(1) := 'UPDATE '||p_interface_table_name||' UAI1 SET '||l_data_type_clause||' = NVL(';
1225:
1226: l_dynamic_sql_clob_part1 := p_tvs_select_clob;
1227: l_clob_length := dbms_lob.getlength(l_dynamic_sql_clob_part1);
1228:
1229: code_debug(' Length of l_dynamic_sql_clob_part1 :'||l_clob_length, 3);
1230:
1231: /* Read 8191 characters from clob sequentially and append them to the VARCHAR2 variable

Line 1232: using DBMS_LOB.READ function */

1228:
1229: code_debug(' Length of l_dynamic_sql_clob_part1 :'||l_clob_length, 3);
1230:
1231: /* Read 8191 characters from clob sequentially and append them to the VARCHAR2 variable
1232: using DBMS_LOB.READ function */
1233: l_offset := 1;
1234: l_count := 0;
1235: l_index := 2;
1236: l_amount := 8191;

Line 1244: dbms_lob.read(l_dynamic_sql_clob_part1, l_amount, l_offset, l_buffer);

1240: while l_offset <= l_clob_length LOOP
1241: l_buffer := '';
1242: l_count := l_count + 1;
1243:
1244: dbms_lob.read(l_dynamic_sql_clob_part1, l_amount, l_offset, l_buffer);
1245:
1246: IF (l_count = 4) THEN
1247: l_count := 0;
1248: l_index := l_index + 1 ;

Line 1260: l_clob_length := dbms_lob.getlength(l_dynamic_sql_clob_part2);

1256: l_index := l_index + 1;
1257: l_dynamic_sql_v_type(l_index) := ' ,NULL), PROCESS_STATUS = PROCESS_STATUS + DECODE((';
1258:
1259: l_dynamic_sql_clob_part2 := p_tvs_select_clob;
1260: l_clob_length := dbms_lob.getlength(l_dynamic_sql_clob_part2);
1261:
1262: code_debug(' Length of l_dynamic_sql_clob_part2 :'||l_clob_length, 3);
1263:
1264: /* Read 8191 characters from clob sequentially and append them to the VARCHAR2 variable

Line 1265: using DBMS_LOB.READ function */

1261:
1262: code_debug(' Length of l_dynamic_sql_clob_part2 :'||l_clob_length, 3);
1263:
1264: /* Read 8191 characters from clob sequentially and append them to the VARCHAR2 variable
1265: using DBMS_LOB.READ function */
1266: l_offset := 1;
1267: l_count := 0;
1268: l_index := l_index + 1;
1269: l_amount := 8191;

Line 1277: dbms_lob.read(l_dynamic_sql_clob_part2, l_amount, l_offset, l_buffer);

1273: while l_offset <= l_clob_length LOOP
1274: l_buffer := '';
1275: l_count := l_count + 1;
1276:
1277: dbms_lob.read(l_dynamic_sql_clob_part2, l_amount, l_offset, l_buffer);
1278:
1279: IF (l_count = 4) THEN
1280: l_count := 0;
1281: l_index := l_index + 1 ;

Line 4425: WHILE (DBMS_LOB.INSTR(l_tvs_where_clause_clob, ':$ATTRIBUTEGROUP$') > 0)

4421: l_tvs_where_clause_clob := l_tvs_where_clause;
4422:
4423:
4424: --WHILE (INSTR(l_tvs_where_clause, ':$ATTRIBUTEGROUP$') > 0)
4425: WHILE (DBMS_LOB.INSTR(l_tvs_where_clause_clob, ':$ATTRIBUTEGROUP$') > 0)
4426: LOOP
4427:
4428: --l_attrname_start_index := INSTR(l_tvs_where_clause,':$ATTRIBUTEGROUP$') +18;
4429: l_attrname_start_index := DBMS_LOB.INSTR(l_tvs_where_clause_clob,':$ATTRIBUTEGROUP$') +18;

Line 4429: l_attrname_start_index := DBMS_LOB.INSTR(l_tvs_where_clause_clob,':$ATTRIBUTEGROUP$') +18;

4425: WHILE (DBMS_LOB.INSTR(l_tvs_where_clause_clob, ':$ATTRIBUTEGROUP$') > 0)
4426: LOOP
4427:
4428: --l_attrname_start_index := INSTR(l_tvs_where_clause,':$ATTRIBUTEGROUP$') +18;
4429: l_attrname_start_index := DBMS_LOB.INSTR(l_tvs_where_clause_clob,':$ATTRIBUTEGROUP$') +18;
4430: -- NOTE: WE ASSUME THAT WE WILL HAVE A SPACE AFTER THE ATTR NAME (will look into this later)
4431: --l_attrname_end_index := INSTR(l_tvs_where_clause,' ',l_attrname_start_index,1);
4432: l_attrname_end_index := DBMS_LOB.INSTR(l_tvs_where_clause_clob,' ',l_attrname_start_index,1);
4433:

Line 4432: l_attrname_end_index := DBMS_LOB.INSTR(l_tvs_where_clause_clob,' ',l_attrname_start_index,1);

4428: --l_attrname_start_index := INSTR(l_tvs_where_clause,':$ATTRIBUTEGROUP$') +18;
4429: l_attrname_start_index := DBMS_LOB.INSTR(l_tvs_where_clause_clob,':$ATTRIBUTEGROUP$') +18;
4430: -- NOTE: WE ASSUME THAT WE WILL HAVE A SPACE AFTER THE ATTR NAME (will look into this later)
4431: --l_attrname_end_index := INSTR(l_tvs_where_clause,' ',l_attrname_start_index,1);
4432: l_attrname_end_index := DBMS_LOB.INSTR(l_tvs_where_clause_clob,' ',l_attrname_start_index,1);
4433:
4434: --l_bind_attr_name := SUBSTR(l_tvs_where_clause,l_attrname_start_index,l_attrname_end_index-l_attrname_start_index);
4435: l_bind_attr_name := DBMS_LOB.SUBSTR(l_tvs_where_clause_clob,l_attrname_end_index-l_attrname_start_index,l_attrname_start_index);
4436:

Line 4435: l_bind_attr_name := DBMS_LOB.SUBSTR(l_tvs_where_clause_clob,l_attrname_end_index-l_attrname_start_index,l_attrname_start_index);

4431: --l_attrname_end_index := INSTR(l_tvs_where_clause,' ',l_attrname_start_index,1);
4432: l_attrname_end_index := DBMS_LOB.INSTR(l_tvs_where_clause_clob,' ',l_attrname_start_index,1);
4433:
4434: --l_bind_attr_name := SUBSTR(l_tvs_where_clause,l_attrname_start_index,l_attrname_end_index-l_attrname_start_index);
4435: l_bind_attr_name := DBMS_LOB.SUBSTR(l_tvs_where_clause_clob,l_attrname_end_index-l_attrname_start_index,l_attrname_start_index);
4436:
4437: -- HERE WE GET THE COLNAME AND DATATYPE OF THE ATTRIBUTE USED AS BIND VARIABLE
4438:
4439: FOR k IN l_attr_metadata_table.FIRST .. l_attr_metadata_table.LAST

Line 4480: l_tvs_string_length := DBMS_LOB.INSTR(l_tvs_where_clause_clob, ':$ATTRIBUTEGROUP$')-1;

4476: END IF;
4477: -- now we replace the :$ATTRIBUTEGROUP$.attrname with the query to find the value.
4478:
4479: -- Bug 10151142 : Start
4480: l_tvs_string_length := DBMS_LOB.INSTR(l_tvs_where_clause_clob, ':$ATTRIBUTEGROUP$')-1;
4481:
4482: l_offset := 1;
4483: l_tvs_where_clause_clob1 := '';
4484: l_amount := 8191;

Line 4493: dbms_lob.read(l_tvs_where_clause_clob, l_amount, l_offset, l_buffer);

4489: IF ( l_tvs_string_length > l_amount) THEN
4490: l_tvs_colb_length_diff := l_tvs_string_length - l_offset +1;
4491:
4492: IF (l_tvs_colb_length_diff >= l_amount) THEN
4493: dbms_lob.read(l_tvs_where_clause_clob, l_amount, l_offset, l_buffer);
4494: l_offset := l_offset + l_amount;
4495: ELSE
4496: dbms_lob.read(l_tvs_where_clause_clob, l_tvs_colb_length_diff, l_offset, l_buffer);
4497: l_offset := l_offset + l_tvs_colb_length_diff;

Line 4496: dbms_lob.read(l_tvs_where_clause_clob, l_tvs_colb_length_diff, l_offset, l_buffer);

4492: IF (l_tvs_colb_length_diff >= l_amount) THEN
4493: dbms_lob.read(l_tvs_where_clause_clob, l_amount, l_offset, l_buffer);
4494: l_offset := l_offset + l_amount;
4495: ELSE
4496: dbms_lob.read(l_tvs_where_clause_clob, l_tvs_colb_length_diff, l_offset, l_buffer);
4497: l_offset := l_offset + l_tvs_colb_length_diff;
4498: END IF;
4499: ELSE
4500: dbms_lob.read(l_tvs_where_clause_clob, l_tvs_string_length, l_offset, l_buffer);

Line 4500: dbms_lob.read(l_tvs_where_clause_clob, l_tvs_string_length, l_offset, l_buffer);

4496: dbms_lob.read(l_tvs_where_clause_clob, l_tvs_colb_length_diff, l_offset, l_buffer);
4497: l_offset := l_offset + l_tvs_colb_length_diff;
4498: END IF;
4499: ELSE
4500: dbms_lob.read(l_tvs_where_clause_clob, l_tvs_string_length, l_offset, l_buffer);
4501: l_offset := l_offset + l_tvs_string_length;
4502: END IF;
4503:
4504: l_tvs_where_clause_clob1 := l_tvs_where_clause_clob1||l_buffer;

Line 4508: l_clob_length := DBMS_LOB.GETLENGTH(l_tvs_where_clause_clob) - l_attrname_end_index;

4504: l_tvs_where_clause_clob1 := l_tvs_where_clause_clob1||l_buffer;
4505: END LOOP;
4506:
4507: l_offset := 1;
4508: l_clob_length := DBMS_LOB.GETLENGTH(l_tvs_where_clause_clob) - l_attrname_end_index;
4509: l_amount := 32767;
4510: l_tvs_where_clause_clob2 := '';
4511:
4512: WHILE l_offset <= l_clob_length LOOP

Line 4514: dbms_lob.read(l_tvs_where_clause_clob, l_amount, (l_attrname_end_index + (l_offset - 1)), l_tvs_where_clause_buffer);

4510: l_tvs_where_clause_clob2 := '';
4511:
4512: WHILE l_offset <= l_clob_length LOOP
4513: l_tvs_where_clause_buffer := '';
4514: dbms_lob.read(l_tvs_where_clause_clob, l_amount, (l_attrname_end_index + (l_offset - 1)), l_tvs_where_clause_buffer);
4515: l_tvs_where_clause_clob2 := l_tvs_where_clause_clob2 || l_tvs_where_clause_buffer;
4516: l_offset := l_offset + l_amount;
4517: END loop;
4518:

Line 4528: /*l_tvs_where_clause_clob := DBMS_LOB.SUBSTR(l_tvs_where_clause_clob,DBMS_LOB.INSTR(l_tvs_where_clause_clob, ':$ATTRIBUTEGROUP$')-1,1) ||

4524: )
4525: )'||
4526: l_tvs_where_clause_clob2;
4527:
4528: /*l_tvs_where_clause_clob := DBMS_LOB.SUBSTR(l_tvs_where_clause_clob,DBMS_LOB.INSTR(l_tvs_where_clause_clob, ':$ATTRIBUTEGROUP$')-1,1) ||
4529: '(NVL('||l_value_from_intftbl||',
4530: DECODE(UAI1.TRANSACTION_TYPE, ''UPDATE'','||l_value_from_ext_table||'
4531: ,''CREATE'',NULL
4532: , ''SYNC'','||l_value_from_ext_table||'

Line 4536: DBMS_LOB.SUBSTR(l_tvs_where_clause_clob,DBMS_LOB.GETLENGTH(l_tvs_where_clause_clob), l_attrname_end_index);

4532: , ''SYNC'','||l_value_from_ext_table||'
4533: ,NULL)
4534: )
4535: )'||
4536: DBMS_LOB.SUBSTR(l_tvs_where_clause_clob,DBMS_LOB.GETLENGTH(l_tvs_where_clause_clob), l_attrname_end_index);
4537: */
4538: -- Bug 10151142 : End
4539: END LOOP;
4540:

Line 4541: WHILE (DBMS_LOB.INSTR(l_tvs_where_clause_clob, ':$OBJECT$') > 0)

4537: */
4538: -- Bug 10151142 : End
4539: END LOOP;
4540:
4541: WHILE (DBMS_LOB.INSTR(l_tvs_where_clause_clob, ':$OBJECT$') > 0)
4542: LOOP
4543: SELECT REPLACE(l_tvs_where_clause_clob,':$OBJECT$','UAI1') INTO l_tvs_where_clause_clob FROM DUAL;
4544: END LOOP;
4545:

Line 4588: code_debug(' The Length of TVS query constructed is :'||dbms_lob.getlength(l_tvs_select_clob), 3);

4584: AND ROWNUM = 1
4585: AND '||l_tvs_col||' = UAI1.ATTR_VALUE_STR )';
4586:
4587: -- code_debug(' The TVS query constructed is :'||l_tvs_select ,3);
4588: code_debug(' The Length of TVS query constructed is :'||dbms_lob.getlength(l_tvs_select_clob), 3);
4589: code_debug(' The TVS query constructed is :');
4590:
4591: /* Print TVS Query - Start
4592: Below Code is for printing the TVS query in the debug log */

Line 4593: l_clob_length := dbms_lob.getlength(l_tvs_select_clob);

4589: code_debug(' The TVS query constructed is :');
4590:
4591: /* Print TVS Query - Start
4592: Below Code is for printing the TVS query in the debug log */
4593: l_clob_length := dbms_lob.getlength(l_tvs_select_clob);
4594: l_offset := 1;
4595: l_amount := 8191;
4596:
4597: /* Read 8191 characters from clob sequentially and append them to the VARCHAR2 variable

Line 4598: using DBMS_LOB.READ function */

4594: l_offset := 1;
4595: l_amount := 8191;
4596:
4597: /* Read 8191 characters from clob sequentially and append them to the VARCHAR2 variable
4598: using DBMS_LOB.READ function */
4599: while l_offset <= l_clob_length loop
4600: l_buffer := '';
4601: dbms_lob.read(l_tvs_select_clob, l_amount, l_offset, l_buffer);
4602: l_offset := l_offset + l_amount;

Line 4601: dbms_lob.read(l_tvs_select_clob, l_amount, l_offset, l_buffer);

4597: /* Read 8191 characters from clob sequentially and append them to the VARCHAR2 variable
4598: using DBMS_LOB.READ function */
4599: while l_offset <= l_clob_length loop
4600: l_buffer := '';
4601: dbms_lob.read(l_tvs_select_clob, l_amount, l_offset, l_buffer);
4602: l_offset := l_offset + l_amount;
4603: code_debug(l_buffer, 3);
4604: end loop;
4605: /* Print TVS Query - End */

Line 7936: code_debug('Before updating B table Length of l_dynamic_sql_clob :'||dbms_lob.getlength(l_dynamic_sql_clob),3);

7932: 'WHERE INTF_TL.SET_PROCESS_ID = :data_set_id '||
7933: ' AND UPPER(INTF_TL.TABLE_NAME) = '''||UPPER(p_interface_table_name)||''' '||
7934: ' AND INTF_TL.UNIQUE_ID = INTFRTCQ.ROW_IDENTIFIER ) ;';
7935:
7936: code_debug('Before updating B table Length of l_dynamic_sql_clob :'||dbms_lob.getlength(l_dynamic_sql_clob),3);
7937: ------------------------------------------------
7938: -- If we need to update the B table, we do so --
7939: ------------------------------------------------
7940: IF (LENGTH(l_db_col_tbl_set_b_attrs) > 1) THEN

Line 7953: code_debug('Before updating TL table Length of l_dynamic_sql_clob: '||dbms_lob.getlength(l_dynamic_sql_clob),3);

7949: REQUEST_ID = :request_id
7950: WHERE '||l_db_col_tbl_where_ext_id||';
7951: END IF;';
7952: END IF;
7953: code_debug('Before updating TL table Length of l_dynamic_sql_clob: '||dbms_lob.getlength(l_dynamic_sql_clob),3);
7954: -------------------------------------------------
7955: -- If we need to update the TL table, we do so --
7956: -------------------------------------------------
7957: IF (l_ext_tl_table_name IS NOT NULL AND

Line 7999: code_debug(' :--: final length : '||dbms_lob.getlength(l_dynamic_sql_clob) ,3);

7995: -- dynamic PL/SQL blocks bind by name --
7996: -----------------------------------------------
7997:
7998: code_debug(' Update DML for AG '||l_attr_group_metadata_obj.ATTR_GROUP_NAME ,3);
7999: code_debug(' :--: final length : '||dbms_lob.getlength(l_dynamic_sql_clob) ,3);
8000:
8001: DBMS_SQL.PARSE(cur_l_dynamic_sql_clob, l_dynamic_sql_clob,
8002: DBMS_SQL.NATIVE);
8003: