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.HR_WPM_MASS_SCORE_CARD_TRNSF dependencies on FND_DOCUMENTS

Line 13: description fnd_documents_tl.description%TYPE,

9: last_update_date DATE,
10: last_updated_by NUMBER,
11: last_update_login NUMBER,
12: datatype_id NUMBER,
13: description fnd_documents_tl.description%TYPE,
14: file_name fnd_documents.file_name%TYPE,
15: media_id fnd_documents.media_id%TYPE,
16: category_id fnd_documents.category_id%TYPE,
17: security_type fnd_documents.security_type%TYPE,

Line 14: file_name fnd_documents.file_name%TYPE,

10: last_updated_by NUMBER,
11: last_update_login NUMBER,
12: datatype_id NUMBER,
13: description fnd_documents_tl.description%TYPE,
14: file_name fnd_documents.file_name%TYPE,
15: media_id fnd_documents.media_id%TYPE,
16: category_id fnd_documents.category_id%TYPE,
17: security_type fnd_documents.security_type%TYPE,
18: publish_flag fnd_documents.publish_flag%TYPE,

Line 15: media_id fnd_documents.media_id%TYPE,

11: last_update_login NUMBER,
12: datatype_id NUMBER,
13: description fnd_documents_tl.description%TYPE,
14: file_name fnd_documents.file_name%TYPE,
15: media_id fnd_documents.media_id%TYPE,
16: category_id fnd_documents.category_id%TYPE,
17: security_type fnd_documents.security_type%TYPE,
18: publish_flag fnd_documents.publish_flag%TYPE,
19: usage_type fnd_documents.usage_type%TYPE,

Line 16: category_id fnd_documents.category_id%TYPE,

12: datatype_id NUMBER,
13: description fnd_documents_tl.description%TYPE,
14: file_name fnd_documents.file_name%TYPE,
15: media_id fnd_documents.media_id%TYPE,
16: category_id fnd_documents.category_id%TYPE,
17: security_type fnd_documents.security_type%TYPE,
18: publish_flag fnd_documents.publish_flag%TYPE,
19: usage_type fnd_documents.usage_type%TYPE,
20: dm_node fnd_documents.dm_node%TYPE,

Line 17: security_type fnd_documents.security_type%TYPE,

13: description fnd_documents_tl.description%TYPE,
14: file_name fnd_documents.file_name%TYPE,
15: media_id fnd_documents.media_id%TYPE,
16: category_id fnd_documents.category_id%TYPE,
17: security_type fnd_documents.security_type%TYPE,
18: publish_flag fnd_documents.publish_flag%TYPE,
19: usage_type fnd_documents.usage_type%TYPE,
20: dm_node fnd_documents.dm_node%TYPE,
21: title fnd_documents_tl.title%TYPE);

Line 18: publish_flag fnd_documents.publish_flag%TYPE,

14: file_name fnd_documents.file_name%TYPE,
15: media_id fnd_documents.media_id%TYPE,
16: category_id fnd_documents.category_id%TYPE,
17: security_type fnd_documents.security_type%TYPE,
18: publish_flag fnd_documents.publish_flag%TYPE,
19: usage_type fnd_documents.usage_type%TYPE,
20: dm_node fnd_documents.dm_node%TYPE,
21: title fnd_documents_tl.title%TYPE);
22: TYPE t_doc IS TABLE OF l_docrow INDEX BY BINARY_INTEGER;

Line 19: usage_type fnd_documents.usage_type%TYPE,

15: media_id fnd_documents.media_id%TYPE,
16: category_id fnd_documents.category_id%TYPE,
17: security_type fnd_documents.security_type%TYPE,
18: publish_flag fnd_documents.publish_flag%TYPE,
19: usage_type fnd_documents.usage_type%TYPE,
20: dm_node fnd_documents.dm_node%TYPE,
21: title fnd_documents_tl.title%TYPE);
22: TYPE t_doc IS TABLE OF l_docrow INDEX BY BINARY_INTEGER;
23: TYPE l_attachdoc IS RECORD (post_state NUMBER,

Line 20: dm_node fnd_documents.dm_node%TYPE,

16: category_id fnd_documents.category_id%TYPE,
17: security_type fnd_documents.security_type%TYPE,
18: publish_flag fnd_documents.publish_flag%TYPE,
19: usage_type fnd_documents.usage_type%TYPE,
20: dm_node fnd_documents.dm_node%TYPE,
21: title fnd_documents_tl.title%TYPE);
22: TYPE t_doc IS TABLE OF l_docrow INDEX BY BINARY_INTEGER;
23: TYPE l_attachdoc IS RECORD (post_state NUMBER,
24: attached_document_id NUMBER,

Line 21: title fnd_documents_tl.title%TYPE);

17: security_type fnd_documents.security_type%TYPE,
18: publish_flag fnd_documents.publish_flag%TYPE,
19: usage_type fnd_documents.usage_type%TYPE,
20: dm_node fnd_documents.dm_node%TYPE,
21: title fnd_documents_tl.title%TYPE);
22: TYPE t_doc IS TABLE OF l_docrow INDEX BY BINARY_INTEGER;
23: TYPE l_attachdoc IS RECORD (post_state NUMBER,
24: attached_document_id NUMBER,
25: document_id NUMBER,

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 105: fnd_documents_pkg.Insert_Row(X_Rowid => l_rowid,

101: BEGIN
102: hr_utility.trace('media_id:'||gt_doc(i).media_id);
103: hr_utility.trace('file name:'||gt_doc(i).file_name);
104: l_media_id := gt_doc(i).media_id;
105: fnd_documents_pkg.Insert_Row(X_Rowid => l_rowid,
106: X_document_id => l_document_id,
107: X_creation_date => gt_doc(i).creation_date,
108: X_created_by => gt_doc(i).created_by,
109: X_last_update_date => gt_doc(i).last_update_date,

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