DBA Data[Home] [Help]

APPS.XDP_PROC_BODY_PKG dependencies on DBMS_LOB

Line 50: dbms_lob.write(lv_lob_i, length(X_PROC_BODY), 1, X_PROC_BODY);

46: X_LAST_UPDATED_BY,
47: 0)
48: returning proc_body into lv_lob_i;
49:
50: dbms_lob.write(lv_lob_i, length(X_PROC_BODY), 1, X_PROC_BODY);
51:
52: insert into XDP_PROC_BODY_TL (
53: proc_name,
54: display_name,

Line 127: if ( (DBMS_LOB.COMPARE (recinfo.PROC_BODY, X_PROC_BODY, DBMS_LOB.GETLENGTH(X_PROC_BODY), 1, 1) = 0)

123: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
124: app_exception.raise_exception;
125: end if;
126: close c;
127: if ( (DBMS_LOB.COMPARE (recinfo.PROC_BODY, X_PROC_BODY, DBMS_LOB.GETLENGTH(X_PROC_BODY), 1, 1) = 0)
128: AND (recinfo.PROC_TYPE = X_PROC_TYPE)
129: AND (recinfo.PROC_SPEC = X_PROC_SPEC)
130: AND (recinfo.PROTECTED_FLAG = X_PROTECTED_FLAG)
131: ) then

Line 189: DBMS_LOB.WRITE(lv_lob_u,length(X_PROC_BODY),1,X_PROC_BODY);

185: if sql%notfound then
186: raise NO_DATA_FOUND;
187: end if;
188:
189: DBMS_LOB.WRITE(lv_lob_u,length(X_PROC_BODY),1,X_PROC_BODY);
190:
191:
192: update XDP_PROC_BODY_TL
193: set