APPS.FND_CONC_PRIVATE_UTILS dependencies on FND_TEMP_FILES

Line 521: update fnd_temp_files

517: PRAGMA AUTONOMOUS_TRANSACTION;
518:
519: begin
520:
521: update fnd_temp_files
522: set REQUEST_ID = decode (req_id, 0, null, req_id),
523: SESSION_ID = sess_id
524: where filename = record_temp_file_use_pvt.filename
525: and node = record_temp_file_use_pvt.node

Line 531: 'insert into fnd_temp_files');

527:
528: if not SQL%FOUND then
529: if (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
530: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'fnd.plsql.fnd_conc_private_utils.record_temp_file_use_pvt',
531: 'insert into fnd_temp_files');
532: end if;
533: insert into fnd_temp_files
534: (FILENAME, TYPE, REQUEST_ID, SESSION_ID, NODE)
535: values (record_temp_file_use_pvt.filename, record_temp_file_use_pvt.type, req_id, sess_id, record_temp_file_use_pvt.node);

Line 533: insert into fnd_temp_files

529: if (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
530: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'fnd.plsql.fnd_conc_private_utils.record_temp_file_use_pvt',
531: 'insert into fnd_temp_files');
532: end if;
533: insert into fnd_temp_files
534: (FILENAME, TYPE, REQUEST_ID, SESSION_ID, NODE)
535: values (record_temp_file_use_pvt.filename, record_temp_file_use_pvt.type, req_id, sess_id, record_temp_file_use_pvt.node);
536: else
537: if (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

Line 539: 'fnd_temp_files updated');

535: values (record_temp_file_use_pvt.filename, record_temp_file_use_pvt.type, req_id, sess_id, record_temp_file_use_pvt.node);
536: else
537: if (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
538: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'fnd.plsql.fnd_conc_private_utils.record_temp_file_use_pvt',
539: 'fnd_temp_files updated');
540: end if;
541: end if;
542:
543: commit;

Line 557: /* Overloaded: records use of a temp file in fnd_temp_files */

553: end if;
554:
555: end record_temp_file_use_pvt;
556:
557: /* Overloaded: records use of a temp file in fnd_temp_files */
558:
559: procedure record_temp_file_use(filename in varchar, node in varchar) is
560:
561: req_id number := null;

Line 574: /* Overloaded: records use of a temp file in fnd_temp_files

570: record_temp_file_use(filename, node, type_code, req_id);
571:
572: end record_temp_file_use;
573:
574: /* Overloaded: records use of a temp file in fnd_temp_files
575: * type_codes: F=Fnd_file context; R=Request context; O=Other context
576: */
577: procedure record_temp_file_use( filename in varchar, node in varchar,
578: type_code in varchar, req_id in number) is

Line 604: delete from fnd_temp_files

600: PRAGMA AUTONOMOUS_TRANSACTION;
601:
602: begin
603:
604: delete from fnd_temp_files
605: where filename = erase_temp_file_use_pvt.filename
606: and upper(node) = upper(erase_temp_file_use_pvt.node)
607: and upper(type) = upper(erase_temp_file_use_pvt.type);
608:

Line 637: /* deletes record of a temp file from fnd_temp_files */

633: end if;
634:
635: end erase_temp_file_use_pvt;
636:
637: /* deletes record of a temp file from fnd_temp_files */
638:
639: procedure erase_temp_file_use(filename in varchar, node in varchar, type in varchar) is
640:
641: mynode varchar2(255);

Line 672: from fnd_temp_files

668:
669: begin
670: select 1
671: into file_recorded
672: from fnd_temp_files
673: where filename = check_temp_file_use.filename
674: and (node is null or upper(node) = upper(mynode))
675: and upper(type) = upper(check_temp_file_use.type);
676: exception