1 PACKAGE rg_report_submission_pkg as
2 /* $Header: rgursubs.pls 120.8 2006/06/06 18:07:58 vtreiger ship $ */
3
4 --
5 -- Name
6 -- submit_report_set()
7 -- Purpose
8 -- Submit the whole report set
9 -- ARGUMENTS
10 -- 1. concurrent request ids
11 -- 2. application short name
12 -- 3. data access set id
13 -- 4. report set period
14 -- 5. accounting_date
15 -- 6. default ledger id
16 -- 7. unit of measure id
17 -- 8. report set id
18 -- 9. page length
19 -- 10. report set request id
20 -- CALLS
21 -- submit_report: submit a report in the report set
22 -- CALLED BY
23 -- form RGXGRRST
24 -- Note: the last concurrent req id is returned
25 --
26
27 FUNCTION submit_report_set(
28 conc_req_ids IN OUT NOCOPY VARCHAR2,
29 appl_short_name IN VARCHAR2,
30 data_access_set_id IN NUMBER,
31 set_period_name IN VARCHAR2,
32 accounting_date IN DATE,
33 default_ledger_short_name IN VARCHAR2,
34 unit_of_m_id IN VARCHAR2,
35 report_set_id IN NUMBER,
36 page_len IN NUMBER,
37 report_set_request_id IN NUMBER DEFAULT NULL
38 )
39 RETURN BOOLEAN;
40
41
42 -- Name
43 -- submit_report
44 -- Purpose
45 -- Submit a report in the report set
46 -- Arguments
47 -- 1. concurrent request id
48 -- 2. report set period name
49 -- 3. accounting date
50 -- 4. default ledger short name
51 -- 5. unit of measure id
52 -- 6. data access set id
53 -- 7. appl_short_name
54 -- 8. report id
55 -- 9. page length
56 -- 10. report request id
57 -- 11. report set request id
58 -- Calls
59 -- FND_REQUEST.SUBMIT_REQUEST
60 -- Call By
61 -- submit_report_set
62 --
63
64 FUNCTION submit_report(conc_req_id IN OUT NOCOPY NUMBER,
65 set_period_name IN VARCHAR2,
66 accounting_date IN DATE,
67 default_ledger_short_name IN VARCHAR2,
68 unit_of_m_id IN VARCHAR2,
69 data_access_set_id IN NUMBER,
70 appl_short_name IN VARCHAR2,
71 rep_id IN NUMBER,
72 page_len IN NUMBER,
73 rep_request_id IN NUMBER,
74 report_set_request_id IN NUMBER DEFAULT NULL
75 )
76 RETURN BOOLEAN;
77
78 FUNCTION submit_request
79 (X_APPL_SHORT_NAME IN VARCHAR2,
80 X_DATA_ACCESS_SET_ID IN NUMBER,
81 X_CONCURRENT_REQUEST_ID OUT NOCOPY NUMBER,
82 X_PROGRAM OUT NOCOPY VARCHAR2,
83 X_COA_ID IN NUMBER,
84 X_ADHOC_PREFIX IN VARCHAR2,
85 X_INDUSTRY IN VARCHAR2,
86 X_FLEX_CODE IN VARCHAR2,
87 X_DEFAULT_LEDGER_SHORT_NAME IN VARCHAR2,
88 X_REPORT_ID IN NUMBER,
89 X_ROW_SET_ID IN NUMBER,
90 X_COLUMN_SET_ID IN NUMBER,
91 X_PERIOD_NAME IN VARCHAR2,
92 X_UNIT_OF_MEASURE_ID IN VARCHAR2,
93 X_ROUNDING_OPTION IN VARCHAR2,
94 X_SEGMENT_OVERRIDE IN VARCHAR2,
95 X_CONTENT_SET_ID IN NUMBER,
96 X_ROW_ORDER_ID IN NUMBER,
97 X_REPORT_DISPLAY_SET_ID IN NUMBER,
98 X_OUTPUT_OPTION IN VARCHAR2,
99 X_EXCEPTIONS_FLAG IN VARCHAR2,
100 X_MINIMUM_DISPLAY_LEVEL IN NUMBER,
101 X_ACCOUNTING_DATE IN DATE,
102 X_PARAMETER_SET_ID IN NUMBER,
103 X_PAGE_LENGTH IN NUMBER,
104 X_SUBREQUEST_ID IN NUMBER,
105 X_APPL_DEFLT_NAME IN VARCHAR2)
106 RETURN BOOLEAN;
107
108 FUNCTION submit_request_addparam
109 (X_APPL_SHORT_NAME IN VARCHAR2,
110 X_DATA_ACCESS_SET_ID IN NUMBER,
111 X_CONCURRENT_REQUEST_ID OUT NOCOPY NUMBER,
112 X_PROGRAM OUT NOCOPY VARCHAR2,
113 X_COA_ID IN NUMBER,
114 X_ADHOC_PREFIX IN VARCHAR2,
115 X_INDUSTRY IN VARCHAR2,
116 X_FLEX_CODE IN VARCHAR2,
117 X_DEFAULT_LEDGER_SHORT_NAME IN VARCHAR2,
118 X_REPORT_ID IN NUMBER,
119 X_ROW_SET_ID IN NUMBER,
120 X_COLUMN_SET_ID IN NUMBER,
121 X_PERIOD_NAME IN VARCHAR2,
122 X_UNIT_OF_MEASURE_ID IN VARCHAR2,
123 X_ROUNDING_OPTION IN VARCHAR2,
124 X_SEGMENT_OVERRIDE IN VARCHAR2,
125 X_CONTENT_SET_ID IN NUMBER,
126 X_ROW_ORDER_ID IN NUMBER,
127 X_REPORT_DISPLAY_SET_ID IN NUMBER,
128 X_OUTPUT_OPTION IN VARCHAR2,
129 X_EXCEPTIONS_FLAG IN VARCHAR2,
130 X_MINIMUM_DISPLAY_LEVEL IN NUMBER,
131 X_ACCOUNTING_DATE IN DATE,
132 X_PARAMETER_SET_ID IN NUMBER,
133 X_PAGE_LENGTH IN NUMBER,
134 X_SUBREQUEST_ID IN NUMBER,
135 X_APPL_DEFLT_NAME IN VARCHAR2,
136 X_GBL_PARAM01 IN VARCHAR2,
137 X_GBL_PARAM02 IN VARCHAR2,
138 X_GBL_PARAM03 IN VARCHAR2,
139 X_GBL_PARAM04 IN VARCHAR2,
140 X_GBL_PARAM05 IN VARCHAR2,
141 X_GBL_PARAM06 IN VARCHAR2,
142 X_GBL_PARAM07 IN VARCHAR2,
143 X_GBL_PARAM08 IN VARCHAR2,
144 X_GBL_PARAM09 IN VARCHAR2,
145 X_GBL_PARAM10 IN VARCHAR2,
146 X_CST_PARAM01 IN VARCHAR2,
147 X_CST_PARAM02 IN VARCHAR2,
148 X_CST_PARAM03 IN VARCHAR2,
149 X_CST_PARAM04 IN VARCHAR2,
150 X_CST_PARAM05 IN VARCHAR2,
151 X_CST_PARAM06 IN VARCHAR2,
152 X_CST_PARAM07 IN VARCHAR2,
153 X_CST_PARAM08 IN VARCHAR2,
154 X_CST_PARAM09 IN VARCHAR2,
155 X_CST_PARAM10 IN VARCHAR2)
156 RETURN BOOLEAN;
157
158 FUNCTION submit_xml_request
159 (X_APPL_SHORT_NAME IN VARCHAR2,
160 X_IN_CONC_REQ_ID IN NUMBER,
161 X_CONCURRENT_REQUEST_ID OUT NOCOPY NUMBER,
162 X_PROGRAM OUT NOCOPY VARCHAR2,
163 X_TEMPLATE_CODE IN VARCHAR2,
164 X_APPLICATION_ID IN NUMBER)
165 RETURN BOOLEAN;
166
167 END rg_report_submission_pkg;