APPS.OKS_MAIL dependencies on DBMS_LOB

Line 399: l_num := dbms_lob.getlength(l_file_loc);

395: transfer_enc => 'base64');
396: ------------ It will upload the physical file ----------------
397: l_file_loc := BFILENAME(path_name, file_name);
398:
399: l_num := dbms_lob.getlength(l_file_loc);
400:
401: dbms_lob.open(file_loc => l_file_loc,
402: open_mode => dbms_lob.file_readonly);
403:

Line 401: dbms_lob.open(file_loc => l_file_loc,

397: l_file_loc := BFILENAME(path_name, file_name);
398:
399: l_num := dbms_lob.getlength(l_file_loc);
400:
401: dbms_lob.open(file_loc => l_file_loc,
402: open_mode => dbms_lob.file_readonly);
403:
404: while l_offset < l_num Loop
405: dbms_lob.read(file_loc => l_file_loc,

Line 402: open_mode => dbms_lob.file_readonly);

398:
399: l_num := dbms_lob.getlength(l_file_loc);
400:
401: dbms_lob.open(file_loc => l_file_loc,
402: open_mode => dbms_lob.file_readonly);
403:
404: while l_offset < l_num Loop
405: dbms_lob.read(file_loc => l_file_loc,
406: amount => l_amount,

Line 405: dbms_lob.read(file_loc => l_file_loc,

401: dbms_lob.open(file_loc => l_file_loc,
402: open_mode => dbms_lob.file_readonly);
403:
404: while l_offset < l_num Loop
405: dbms_lob.read(file_loc => l_file_loc,
406: amount => l_amount,
407: offset => l_offset,
408: buffer => l_raw);
409: attach_base64(conn, l_raw, mime_type, TRUE, file_name, FALSE);

Line 416: dbms_lob.fileclose(file_loc => l_file_loc);

412: l_amount := l_num - l_offset;
413: End If;
414:
415: End Loop;
416: dbms_lob.fileclose(file_loc => l_file_loc);
417: --------------------------------------------------------------
418: end_attachment(conn);
419: end_mail(conn);
420:

Line 608: clob_length := dbms_lob.getlength(document);

604: transfer_enc => 'base64');
605:
606: ------ It will upload the physical file ----------------
607:
608: clob_length := dbms_lob.getlength(document);
609: offset := 1;
610:
611: WHILE clob_length > 0 LOOP
612:

Line 619: dbms_lob.read(document, amount, offset, l_str);

615: ELSE
616: amount := 3000;
617: END IF;
618:
619: dbms_lob.read(document, amount, offset, l_str);
620:
621: l_raw := UTL_RAW.CAST_TO_RAW (l_str);
622: attach_base64(conn, l_raw, mime_type, TRUE, file_name, FALSE);
623:

Line 667: clob_length := dbms_lob.getlength(mail_text);

663:
664: begin_attachment(conn => conn,
665: mime_type => mime_type);
666:
667: clob_length := dbms_lob.getlength(mail_text);
668: offset := 1;
669:
670: WHILE clob_length > 0 LOOP
671:

Line 678: l_str := DBMS_LOB.SUBSTR(mail_text, amount, offset);

674: ELSE
675: amount := 2000;
676: END IF;
677:
678: l_str := DBMS_LOB.SUBSTR(mail_text, amount, offset);
679: write_text(conn => conn,
680: message => l_str);
681:
682: clob_length := clob_length - 2000;

Line 693: clob_length := dbms_lob.getlength(document);

689: mime_type => mime_type,
690: inline => FALSE,
691: filename => file_name);
692:
693: clob_length := dbms_lob.getlength(document);
694: offset := 1;
695:
696: WHILE clob_length > 0 LOOP
697:

Line 704: l_str := DBMS_LOB.SUBSTR(document, amount, offset);

700: ELSE
701: amount := 2000;
702: END IF;
703:
704: l_str := DBMS_LOB.SUBSTR(document, amount, offset);
705: write_text(conn => conn,
706: message => l_str );
707:
708: clob_length := clob_length - 2000;