APPS.HR_WPM_MASS_SCORE_CARD_TRNSF dependencies on FND_LOBS

Line 39: file_name fnd_lobs.file_name%TYPE,

35: attachment_category_id NUMBER);
36: TYPE t_attachdoc IS TABLE OF l_attachdoc INDEX BY BINARY_INTEGER;
37: TYPE l_lob IS RECORD (post_state NUMBER,
38: file_id NUMBER,
39: file_name fnd_lobs.file_name%TYPE,
40: file_content_type fnd_lobs.file_content_type%TYPE,
41: file_data BLOB,
42: oracle_charset fnd_lobs.oracle_charset%TYPE,
43: file_format fnd_lobs.file_format%TYPE);

Line 40: file_content_type fnd_lobs.file_content_type%TYPE,

36: TYPE t_attachdoc IS TABLE OF l_attachdoc INDEX BY BINARY_INTEGER;
37: TYPE l_lob IS RECORD (post_state NUMBER,
38: file_id NUMBER,
39: file_name fnd_lobs.file_name%TYPE,
40: file_content_type fnd_lobs.file_content_type%TYPE,
41: file_data BLOB,
42: oracle_charset fnd_lobs.oracle_charset%TYPE,
43: file_format fnd_lobs.file_format%TYPE);
44: TYPE t_lob IS TABLE of l_lob INDEX BY BINARY_INTEGER;

Line 42: oracle_charset fnd_lobs.oracle_charset%TYPE,

38: file_id NUMBER,
39: file_name fnd_lobs.file_name%TYPE,
40: file_content_type fnd_lobs.file_content_type%TYPE,
41: file_data BLOB,
42: oracle_charset fnd_lobs.oracle_charset%TYPE,
43: file_format fnd_lobs.file_format%TYPE);
44: TYPE t_lob IS TABLE of l_lob INDEX BY BINARY_INTEGER;
45: TYPE l_shorttext IS RECORD (post_state NUMBER,
46: media_id NUMBER,

Line 43: file_format fnd_lobs.file_format%TYPE);

39: file_name fnd_lobs.file_name%TYPE,
40: file_content_type fnd_lobs.file_content_type%TYPE,
41: file_data BLOB,
42: oracle_charset fnd_lobs.oracle_charset%TYPE,
43: file_format fnd_lobs.file_format%TYPE);
44: TYPE t_lob IS TABLE of l_lob INDEX BY BINARY_INTEGER;
45: TYPE l_shorttext IS RECORD (post_state NUMBER,
46: media_id NUMBER,
47: short_text Fnd_Documents_Short_Text.short_text%TYPE,

Line 150: INSERT INTO FND_LOBS

146: IF gt_lob.COUNT > 0 THEN -- count check
147: FOR j IN gt_lob.FIRST..gt_lob.LAST
148: LOOP
149: IF gt_doc(i).media_id = gt_lob(j).file_id THEN -- insert only if the media id matches
150: INSERT INTO FND_LOBS
151: (
152: FILE_ID
153: ,FILE_NAME
154: ,FILE_CONTENT_TYPE

Line 360: INSERT INTO FND_LOBS

356: gt_lob(j+1).file_data := lb_filedata;
357: --
358: /* IF gt_lob(j+1).post_State = 0 THEN
359: BEGIN
360: INSERT INTO FND_LOBS
361: (
362: FILE_ID
363: ,FILE_NAME
364: ,FILE_CONTENT_TYPE