APPS.HR_WPM_MASS_SCORE_CARD_TRNSF dependencies on FND_DOCUMENTS_SHORT_TEXT

Line 47: short_text Fnd_Documents_Short_Text.short_text%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,
48: app_source_version Fnd_Documents_Short_Text.app_source_version%TYPE);
49: TYPE t_shorttext IS TABLE of l_shorttext INDEX BY BINARY_INTEGER;
50: gt_lob t_lob;
51: gt_doc t_doc;

Line 48: app_source_version Fnd_Documents_Short_Text.app_source_version%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,
48: app_source_version Fnd_Documents_Short_Text.app_source_version%TYPE);
49: TYPE t_shorttext IS TABLE of l_shorttext INDEX BY BINARY_INTEGER;
50: gt_lob t_lob;
51: gt_doc t_doc;
52: gt_attachdoc t_attachdoc;

Line 131: INSERT INTO FND_DOCUMENTS_SHORT_TEXT

127: LOOP
128: HR_UTILITY.TRACE('mEDIA ID FROM SHORT TEXT: '||gt_shorttext(j).media_id ||'-'||gt_doc(i).media_id);
129: IF gt_doc(i).media_id = gt_shorttext(j).media_id THEN -- insert only if the media id matches
130: HR_UTILITY.TRACE('INSERTING MEDIA ID: '||GT_SHORTTEXT(J).MEDIA_ID);
131: INSERT INTO FND_DOCUMENTS_SHORT_TEXT
132: (
133: media_id
134: ,short_text
135: ,app_source_version