DBA Data[Home] [Help]

PACKAGE: APPS.PA_ONESTEP_STREAMLINE_PKG

Source


1 PACKAGE PA_ONESTEP_STREAMLINE_PKG AS
2 /* $Header: PAOSTRMS.pls 120.3 2007/12/07 08:48:34 rdegala ship $ */
3 
4   TYPE strm_request_id_type IS RECORD
5      ( request_id NUMBER,
6        lookup_code VARCHAR2(30),
7        u_phase VARCHAR2(80),
8        u_status VARCHAR2(80),
9        phase VARCHAR2(80),
10        status VARCHAR2(80),
11        fired VARCHAR2(2),
12        sob_type VARCHAR2(2),
13        sob_id NUMBER
14      );
15   TYPE strm_request_id_table IS TABLE OF strm_request_id_type
16     INDEX BY binary_integer;
17   -- For phase column:                        For status column:
18   -- COMPLETE                                 NORMAL
19   --                                          ERROR
20   --                                          WARNING
21   --                                          CANCELLED
22   --                                          TERMINATED
23   TYPE sob_err_id_type IS RECORD
24     ( sob_name varchar2(30) );
25   TYPE sob_err_table IS TABLE OF sob_err_id_type
26     INDEX BY binary_integer;
27 
28   /* added global variables for print options cascading bug 2816916 */
29 
30   l_request_id          fnd_concurrent_requests.request_id%TYPE;
31   l_number_of_copies    fnd_concurrent_requests.number_of_copies%TYPE;
32   l_print_style         fnd_concurrent_requests.print_style%TYPE;
33   l_printer             fnd_concurrent_requests.printer%TYPE;
34   l_save_output_flag    fnd_concurrent_requests.save_output_flag%TYPE;
35 
36   l_result_print        boolean;
37   l_save_op_flag_bool   boolean;
38 
39   l_print_no            NUMBER;
40 /*end adding variables for bug 2816916*/
41 
42   PROCEDURE PAOSTRM( errbuf OUT NOCOPY VARCHAR2,
43 		             retcode OUT NOCOPY VARCHAR2,
44 		             debug_mode IN VARCHAR2,
45 		             strm_opt IN VARCHAR2,
46 			     acct_date IN VARCHAR2);
47   /* Added acct_date for bug 6655250*/
48   g_debug_mode VARCHAR2(2);
49 
50 END PA_ONESTEP_STREAMLINE_PKG;