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.FND_IMP_PKG dependencies on FND_IMP_PKG

Line 1: PACKAGE BODY FND_IMP_PKG AS

1: PACKAGE BODY FND_IMP_PKG AS
2: /* $Header: afimpb.pls 120.14.12010000.1 2008/07/25 14:32:06 appldev ship $ */
3:
4: FUNCTION lastupdate(snapshot_id__ INTEGER, patch_id__ INTEGER)
5: RETURN DATE IS

Line 824: fnd_file.put_line(fnd_file.log, 'FND_IMP_PKG.refreshCP: running');

820: ) IS
821: request_id INTEGER;
822: no_request_id_found EXCEPTION;
823: BEGIN
824: fnd_file.put_line(fnd_file.log, 'FND_IMP_PKG.refreshCP: running');
825: select fcr.request_id into request_id
826: from fnd_application fa, fnd_concurrent_requests fcr, fnd_concurrent_programs fcp
827: where fcr.priority_request_id = fnd_global.conc_priority_request
828: and fcr.program_application_id = fcp.application_id

Line 833: fnd_file.put_line(fnd_file.log, 'FND_IMP_PKG.refreshCP: request id = '||request_id);

829: and fcp.application_id = fa.application_id
830: and fcr.concurrent_program_id = fcp.concurrent_program_id
831: and fa.application_short_name = 'AD'
832: and fcp.concurrent_program_name IN ('PATCHANALYSIS', 'PAANALYSIS', 'PADOWNLOADPATCHES', 'PAANALYZEPATCHES', 'PARECOMMENDPATCHES');
833: fnd_file.put_line(fnd_file.log, 'FND_IMP_PKG.refreshCP: request id = '||request_id);
834: refresh(request_id, '1');
835:
836: EXCEPTION
837: WHEN OTHERS

Line 841: fnd_file.put_line(fnd_file.log, 'FND_IMP_PKG.refreshCP failed ' || sqlcode||':'||sqlerrm);

837: WHEN OTHERS
838: THEN
839: RETCODE := 2;
840: ERRBUF := sqlcode||':'||sqlerrm;
841: fnd_file.put_line(fnd_file.log, 'FND_IMP_PKG.refreshCP failed ' || sqlcode||':'||sqlerrm);
842: END refreshCP;
843:
844: PROCEDURE refreshCP2(
845: ERRBUF OUT NOCOPY VARCHAR2,

Line 851: fnd_file.put_line(fnd_file.log, 'FND_IMP_PKG.refreshCP2: running');

847: ) IS
848: request_id INTEGER;
849: no_request_id_found EXCEPTION;
850: BEGIN
851: fnd_file.put_line(fnd_file.log, 'FND_IMP_PKG.refreshCP2: running');
852: select fcr.request_id into request_id
853: from fnd_application fa, fnd_concurrent_requests fcr, fnd_concurrent_programs fcp
854: where fcr.priority_request_id = fnd_global.conc_priority_request
855: and fcr.program_application_id = fcp.application_id

Line 860: fnd_file.put_line(fnd_file.log, 'FND_IMP_PKG.refreshCP2: request id = '||request_id);

856: and fcp.application_id = fa.application_id
857: and fcr.concurrent_program_id = fcp.concurrent_program_id
858: and fa.application_short_name = 'AD'
859: and fcp.concurrent_program_name IN ('PATCHANALYSIS', 'PAANALYSIS', 'PADOWNLOADPATCHES', 'PAANALYZEPATCHES', 'PARECOMMENDPATCHES');
860: fnd_file.put_line(fnd_file.log, 'FND_IMP_PKG.refreshCP2: request id = '||request_id);
861: refresh(request_id, '2');
862: compute_language_impact(request_id);
863: EXCEPTION
864: WHEN OTHERS

Line 868: fnd_file.put_line(fnd_file.log, 'FND_IMP_PKG.refreshCP2 failed ' || sqlcode||':'||sqlerrm);

864: WHEN OTHERS
865: THEN
866: RETCODE := 2;
867: ERRBUF := sqlcode||':'||sqlerrm;
868: fnd_file.put_line(fnd_file.log, 'FND_IMP_PKG.refreshCP2 failed ' || sqlcode||':'||sqlerrm);
869: END refreshCP2;
870:
871: PROCEDURE refreshCPAgg(
872: ERRBUF OUT NOCOPY VARCHAR2,

Line 879: fnd_file.put_line(fnd_file.log, 'FND_IMP_PKG.refreshCPAgg: running');

875: ) IS
876: request_id INTEGER;
877: no_request_id_found EXCEPTION;
878: BEGIN
879: fnd_file.put_line(fnd_file.log, 'FND_IMP_PKG.refreshCPAgg: running');
880: if (request_id__ is null) then
881: select fcr.request_id into request_id
882: from fnd_application fa, fnd_concurrent_requests fcr, fnd_concurrent_programs fcp
883: where fcr.priority_request_id = fnd_global.conc_priority_request

Line 889: fnd_file.put_line(fnd_file.log, 'FND_IMP_PKG.refreshCPAgg: request id = '||request_id);

885: and fcp.application_id = fa.application_id
886: and fcr.concurrent_program_id = fcp.concurrent_program_id
887: and fa.application_short_name = 'AD'
888: and fcp.concurrent_program_name IN ('PATCHANALYSIS', 'PAANALYSIS', 'PADOWNLOADPATCHES', 'PAANALYZEPATCHES', 'PARECOMMENDPATCHES');
889: fnd_file.put_line(fnd_file.log, 'FND_IMP_PKG.refreshCPAgg: request id = '||request_id);
890: refresh(request_id, '3');
891: compute_language_impact(request_id);
892: else
893: if (request_id__ >= 0) then

Line 904: fnd_file.put_line(fnd_file.log, 'FND_IMP_PKG.refreshCPAgg failed ' || sqlcode||':'||sqlerrm);

900: WHEN OTHERS
901: THEN
902: RETCODE := 2;
903: ERRBUF := sqlcode||':'||sqlerrm;
904: fnd_file.put_line(fnd_file.log, 'FND_IMP_PKG.refreshCPAgg failed ' || sqlcode||':'||sqlerrm);
905: END refreshCPAgg;
906:
907: PROCEDURE sync(table_name VARCHAR2) IS
908: BEGIN

Line 959: fnd_file.put_line(fnd_file.log, to_char(sysdate,'HH24:MI:SS')||'> FND_IMP_PKG.isFileTypeAffected IN');

955: where set_type in ('s','S')
956: and request_id = v_req_id
957: and snapshot_id = v_snapshot_id;
958: BEGIN
959: fnd_file.put_line(fnd_file.log, to_char(sysdate,'HH24:MI:SS')||'> FND_IMP_PKG.isFileTypeAffected IN');
960:
961: fnd_file.put_line(fnd_file.log, to_char(sysdate,'HH24:MI:SS')||'> computing file type affected for file type ' || filetype__ || '['||request_id__||']...');
962:
963: fnd_file.put_line(fnd_file.log, to_char(sysdate,'HH24:MI:SS')||'> snapshot_id['||snapshot_id__||']...');

Line 987: fnd_file.put_line(fnd_file.log, to_char(sysdate,'HH24:MI:SS')||'> FND_IMP_PKG.isFileTypeAffected OUT');

983: end loop;
984:
985: fnd_file.put_line(fnd_file.log, to_char(sysdate,'HH24:MI:SS')||'> v_return:'||v_return);
986:
987: fnd_file.put_line(fnd_file.log, to_char(sysdate,'HH24:MI:SS')||'> FND_IMP_PKG.isFileTypeAffected OUT');
988: return v_return;
989: END isFileTypeAffected;
990:
991: END FND_IMP_PKG;

Line 991: END FND_IMP_PKG;

987: fnd_file.put_line(fnd_file.log, to_char(sysdate,'HH24:MI:SS')||'> FND_IMP_PKG.isFileTypeAffected OUT');
988: return v_return;
989: END isFileTypeAffected;
990:
991: END FND_IMP_PKG;