DBA Data[Home] [Help]

APPS.FND_CONTEXT_UTIL dependencies on DBMS_LOB

Line 48: start_pos := DBMS_LOB.instr(lobd, '<' || tag_name, 1,1);

44: and name not in ('METADATA', 'TEMPLATE')
45: and ctx_type = 'A'
46: and rownum=1;
47:
48: start_pos := DBMS_LOB.instr(lobd, '<' || tag_name, 1,1);
49: end_pos := DBMS_LOB.instr(lobd, ' 50:
51: ret_string := dbms_lob.substr(lobd, end_pos - start_pos, start_pos);
52:

Line 49: end_pos := DBMS_LOB.instr(lobd, '

45: and ctx_type = 'A'
46: and rownum=1;
47:
48: start_pos := DBMS_LOB.instr(lobd, '<' || tag_name, 1,1);
49: end_pos := DBMS_LOB.instr(lobd, ' 50:
51: ret_string := dbms_lob.substr(lobd, end_pos - start_pos, start_pos);
52:
53: ret_string := substr(ret_string,instr(ret_string,'>',1,1)+1);

Line 51: ret_string := dbms_lob.substr(lobd, end_pos - start_pos, start_pos);

47:
48: start_pos := DBMS_LOB.instr(lobd, '<' || tag_name, 1,1);
49: end_pos := DBMS_LOB.instr(lobd, ' 50:
51: ret_string := dbms_lob.substr(lobd, end_pos - start_pos, start_pos);
52:
53: ret_string := substr(ret_string,instr(ret_string,'>',1,1)+1);
54:
55: return ret_string;