1 PACKAGE EDR_PRINT_PROCESS_PVT AS
2 /* $Header: EDRVPRTS.pls 120.0.12000000.1 2007/01/18 05:56:38 appldev ship $ */
3
4 /* Global Constants */
5 G_PKG_NAME CONSTANT varchar2(30) := 'EDR_PRINT_PROCESS_PVT';
6
7 /* Program to submit print job */
8 /* This Procedure will submit a print job for a given Query id and also will increment the print count */
9 -- Start of comments
10 -- API name : SUBMIT_PRINT_JOB
11 -- Type : Private Utility.
12 -- Function : Submits the print job and increments the counted
13 -- Pre-reqs : None.
14 -- Parameters :
15 -- IN : p_api_version API version '1.0'
16 -- p_init_msg_list Flag to indicate if the message stack has to be initialised or not
17 -- P_QUERY_ID Query id to associated to the erecords which needs to be printed
18 -- P_WAIT_FOR_JOB This falg will indicate to
19 -- API if it has to wait till the concurrent request is complete or not
20
21 -- OUT : X_return Status API status
22 -- X_Msg_count Message Count
23 -- X_MSG_DATA Message DAta which will populate the message stack
24 -- X_REQUEST_ID Request Id of the concurrent request submitted
25 -- X_REQUEST_STATUS Request Status of the concurrent Request
26
27 PROCEDURE SUBMIT_PRINT_JOB (
28 p_api_version IN NUMBER,
29 p_init_msg_list IN VARCHAR2,
30 x_return_status OUT NOCOPY VARCHAR2,
31 x_msg_count OUT NOCOPY NUMBER,
32 x_msg_data OUT NOCOPY VARCHAR2,
33 p_Query_id IN NUMBER,
34 P_WAIT_FOR_JOB IN BOOLEAN,
35 x_request_id OUT NOCOPY NUMBER,
36 x_request_status OUT NOCOPY VARCHAR2);
37
38 -- Start of comments
39 -- API name : PROCESS_PRINTRECORDS
40 -- Type : Private Utility.
41 -- Function : Processes the records passed as table and prepares for print/Query
42 -- Pre-reqs : None.
43 -- Parameters :
44 -- IN : p_api_version API version '1.0'
45 -- p_init_msg_list Flag to indicate if the message stack has to be initialised or not
46 -- p_erecord_id_TBL Table of eRecords
47 -- P_INCLUDE_RELATED_RECORDS This falg will indicate to
48 -- API if child erecords needs to be included
49
50 -- OUT : X_return Status API status
51 -- X_Msg_count Message Count
52 -- X_MSG_DATA Message DAta which will populate the message stack
53 -- X_QUERY_ID Query id to associated to the erecords which have been
54
55
56 PROCEDURE PROCESS_PRINTRECORDS (
57 p_api_version IN NUMBER,
58 p_init_msg_list IN VARCHAR2,
59 x_return_status OUT NOCOPY VARCHAR2,
60 x_msg_count OUT NOCOPY NUMBER,
61 x_msg_data OUT NOCOPY VARCHAR2,
62 p_erecord_id_TBL IN FND_TABLE_OF_VARCHAR2_255,
63 P_INCLUDE_RELATED_RECORDS IN BOOLEAN,
64 x_Query_id OUT NOCOPY NUMBER);
65
66 -- Start of comments
67 -- API name : ACKNOWLEDGE_PRINT
68 -- Type : Private Utility.
69 -- Function : Acknowledges print event if it has been raised for the event
70 -- Pre-reqs : None.
71 -- Parameters :
72 -- IN : p_api_version API version '1.0'
73 -- p_init_msg_list Flag to indicate if the message stack has to be initialised or not
74 -- p_QUERY_ID Query Id to be acknoweldged
75
76 -- OUT : X_return Status API status
77 -- X_Msg_count Message Count
78 -- X_MSG_DATA Message DAta which will populate the message stack
79
80
81 PROCEDURE ACKNOWLEDGE_PRINT (
82 p_api_version IN NUMBER,
83 p_init_msg_list IN VARCHAR2,
84 x_return_status OUT NOCOPY VARCHAR2,
85 x_msg_count OUT NOCOPY NUMBER,
86 x_msg_data OUT NOCOPY VARCHAR2,
87 p_Query_id IN NUMBER
88 );
89
90
91 /* Utility procedures for Pritn option */
92
93 -- Start of comments
94 -- API name : GET_PARENT_ERECORD_ID
95 -- Type : Private Utility.
96 -- Function : fetches Parent eRecord ID for a given erecord. P_PARENT_ERECORD_ID will be NULL if not found
97 -- Pre-reqs : None.
98 -- Parameters :
99 -- IN : P_ERECORD_ID eRecord id for which parent erecord id need to be retrieved
100
101 -- OUT : P_PARENT_ERECORD_ID Parent eRecord id of a given eRecord
102
103
104 PROCEDURE GET_PARENT_ERECORD_ID(P_ERECORD_ID IN NUMBER,
105 P_PARENT_ERECORD_ID OUT NOCOPY NUMBER);
106
107 -- Start of comments
108 -- API name : GET_EVENT_DESCRIPTION
109 -- Type : Private Utility.
110 -- Function : Fectches the event display name from wf_events table.
111 -- Pre-reqs : None.
112 -- Parameters :
113 -- IN : P_EVENT Name of the event
114 -- OUT : P_DESCRIPTION Display name of the Event
115
116 PROCEDURE GET_EVENT_DESCRIPTION(P_EVENT IN VARCHAR2,
117 P_DESCRIPTION OUT NOCOPY VARCHAR2);
118
119 end EDR_PRINT_PROCESS_PVT;