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.EAM_WORKORDERREP_PVT dependencies on EAM_WOREP_LONG_ATTACH_TEMP

Line 1319: insert into EAM_WOREP_LONG_ATTACH_TEMP

1315: BEGIN
1316: -- bug 13552899 (changed for fnd change in long_text column)
1317: -- API body
1318: if p_select=1 then
1319: insert into EAM_WOREP_LONG_ATTACH_TEMP
1320: (select
1321: fdlt.long_text
1322: from
1323: FND_DOCUMENTS_LONG_TEXT fdlt,

Line 1334: select long_text into l_lobVal from EAM_WOREP_LONG_ATTACH_TEMP ;

1330: fad.pk2_value =to_char(p_wip_id) and
1331: fdlt.media_id =to_char(p_media_id) and
1332: fad.pk1_value = to_char(p_org_id));
1333:
1334: select long_text into l_lobVal from EAM_WOREP_LONG_ATTACH_TEMP ;
1335: delete from EAM_WOREP_LONG_ATTACH_TEMP;
1336:
1337: else
1338: -- bug 13552899 (changed for fnd change in long_text column)

Line 1335: delete from EAM_WOREP_LONG_ATTACH_TEMP;

1331: fdlt.media_id =to_char(p_media_id) and
1332: fad.pk1_value = to_char(p_org_id));
1333:
1334: select long_text into l_lobVal from EAM_WOREP_LONG_ATTACH_TEMP ;
1335: delete from EAM_WOREP_LONG_ATTACH_TEMP;
1336:
1337: else
1338: -- bug 13552899 (changed for fnd change in long_text column)
1339: insert into EAM_WOREP_LONG_ATTACH_TEMP (select

Line 1339: insert into EAM_WOREP_LONG_ATTACH_TEMP (select

1335: delete from EAM_WOREP_LONG_ATTACH_TEMP;
1336:
1337: else
1338: -- bug 13552899 (changed for fnd change in long_text column)
1339: insert into EAM_WOREP_LONG_ATTACH_TEMP (select
1340: fdlt.long_text
1341: from
1342: FND_DOCUMENTS_LONG_TEXT fdlt,
1343: fnd_documents_vl fdv,

Line 1353: select long_text into l_lobVal from EAM_WOREP_LONG_ATTACH_TEMP;

1349: fad.pk1_value = to_char(p_wip_id) and
1350: fdlt.media_id =to_char(p_media_id) and
1351: fad.pk3_value =to_char(p_org_id));
1352:
1353: select long_text into l_lobVal from EAM_WOREP_LONG_ATTACH_TEMP;
1354: delete from EAM_WOREP_LONG_ATTACH_TEMP;
1355:
1356: end if;
1357: return l_lobVal;

Line 1354: delete from EAM_WOREP_LONG_ATTACH_TEMP;

1350: fdlt.media_id =to_char(p_media_id) and
1351: fad.pk3_value =to_char(p_org_id));
1352:
1353: select long_text into l_lobVal from EAM_WOREP_LONG_ATTACH_TEMP;
1354: delete from EAM_WOREP_LONG_ATTACH_TEMP;
1355:
1356: end if;
1357: return l_lobVal;
1358: -- End of API body.