DBA Data[Home] [Help]

PACKAGE: APPS.FND_DELIVERY

Source


1 package FND_DELIVERY AUTHID CURRENT_USER as
2 /* $Header: AFCPDELS.pls 120.4.12020000.2 2013/02/22 21:31:36 ckclark ship $ */
3 
4   --
5   -- PUBLIC VARIABLES
6   --
7 
8 
9    --
10    -- Delivery Types
11    --
12    TYPE_EMAIL        CONSTANT varchar2(1) := 'E';
13    TYPE_IPP_PRINTER  CONSTANT varchar2(1) := 'P';
14    TYPE_IPP_FAX      CONSTANT varchar2(1) := 'F';
15    TYPE_FTP          CONSTANT varchar2(1) := 'T';
16    TYPE_SFTP         CONSTANT varchar2(1) := 'S';
17    TYPE_HTTP         CONSTANT varchar2(1) := 'H';
18    TYPE_WEBDAV       CONSTANT varchar2(1) := 'W';
19    TYPE_CUSTOM       CONSTANT varchar2(1) := 'C';
20    TYPE_BURST        CONSTANT varchar2(1) := 'B';
21 
22 
23    --
24    -- Printer orientations
25    --
26    ORIENTATION_PORTRAIT   CONSTANT varchar2(1) := '3';
27    ORIENTATION_LANDSCAPE  CONSTANT varchar2(1) := '4';
28 
29 
30    --
31    -- Variable names for FND_VAULT
32    --
33    DELIVERY_SERVICE CONSTANT varchar2(8):=  'FND_TMP_';
34    SMTP_SERVICE     CONSTANT varchar2(8) := 'FND_SMTP';
35 
36 
37 
38 
39   --
40   -- PUBLIC FUNCTIONS
41   --
42 
43 
44    function add_email (subject         in varchar2,
45 		       from_address    in varchar2,
46 		       to_address      in varchar2,
47 		       cc              in varchar2 default null,
48 		       lang            in varchar2 default null) return boolean;
49 
50    function add_ipp_printer (printer_name in varchar2,
51 			     copies       in number default null,
52 			     orientation  in varchar2 default null,
53 			     username     in varchar2 default null,
54 			     password     in varchar2 default null,
55 			     lang         in varchar2 default null) return boolean;
56 
57 
58 
59    function add_ipp_printer (printer_id   in number,
60 			     copies       in number default null,
61 			     orientation  in varchar2 default null,
62 			     username     in varchar2 default null,
63 			     password     in varchar2 default null,
64 			     lang         in varchar2 default null) return boolean;
65 
66 
67    function add_fax ( server_name   in varchar2,
68 		      fax_number    in varchar2,
69 		      username      in varchar2 default null,
70 	              password      in varchar2 default null,
71 		      lang          in varchar2 default null) return boolean;
72 
73 
74    function add_fax ( server_id     in number,
75 		      fax_number    in varchar2,
76 		      username      in varchar2 default null,
77 	              password      in varchar2 default null,
78 		      lang          in varchar2 default null) return boolean;
79 
80 
81    function add_ftp ( server     in varchar2,
82 		      username   in varchar2,
83 		      password   in varchar2,
84 		      remote_dir in varchar2,
85 		      port       in varchar2 default null,
86 		      secure     in boolean default FALSE,
87 		      lang       in varchar2 default null) return boolean;
88 
89    function add_webdav ( server     in varchar2,
90                          remote_dir in varchar2,
91                          port       in varchar2 default null,
92 		         username   in varchar2 default null,
93 		         password   in varchar2 default null,
94 		         authtype   in varchar2 default null,
95                          enctype    in varchar2 default null,
96 		         lang       in varchar2 default null) return boolean;
97 
98    function add_http (   server     in varchar2,
99                          remote_dir in varchar2,
100                          port       in varchar2 default null,
101 		         username   in varchar2 default null,
102 		         password   in varchar2 default null,
103 		         authtype   in varchar2 default null,
104                          enctype    in varchar2 default null,
105                          method     in varchar2 default null,
106 		         lang       in varchar2 default null) return boolean;
107 
108    function add_custom ( custom_id   in number,
109 		         lang        in varchar2 default null) return boolean;
110 
111    function add_custom ( custom_name   in varchar2,
112 		         lang          in varchar2 default null) return boolean;
113 
114    function add_burst return boolean;
115 
116    function has_lob_of_type (  prog_app_name  IN varchar2,
117                                conc_prog_name IN varchar2,
118                                lob_of_type    IN varchar2,
119                                nls_lang       IN varchar2 default null,
120                                nls_terry      IN varchar2 default null)  return boolean;
121 
122    function has_lob_of_type (  reqid          IN number,
123                                lob_of_type    IN varchar2)  return boolean;
124 
125    function has_delivery_of_type ( reqid          IN number,
126                                    delivery_type  IN varchar2)  return boolean;
127 
128    function  post_processing_results ( reqid          IN number
129                                                        )  return varchar2;
130 
131    procedure set_smtp_credentials( username  in varchar2,
132 				   smtp_user in varchar2,
133 				   smtp_pass in varchar2);
134 
135    procedure get_smtp_credentials( username  in varchar2,
136 				   smtp_user out nocopy varchar2,
137 				   smtp_pass out nocopy varchar2);
138 
139    function set_temp_credentials  (username in varchar2,
140                                    password in varchar2) return varchar2;
141 
142    function get_temp_credentials  (svc_key  in varchar2,
143                                    username in varchar2,
144                                    delflag  in varchar2 default 'Y') return varchar2;
145 
146    procedure del_temp_credentials (svc_key  in varchar2,
147                                    username in varchar2);
148 
149 end FND_DELIVERY;