[Home] [Help]
1: PACKAGE BODY WSH_DOCUMENT_SETS as
2: /* $Header: WSHDSPRB.pls 120.9 2008/01/23 13:18:53 jnpinto ship $ */
3:
4: -- Name
5: -- Print_Document_Sets
34: -- if the user defines their own reports they should restrict parameter names
35: -- to those used in this package. Additional they may use P_TEXT1 - P_TEXT4.
36:
37: --
38: G_PKG_NAME CONSTANT VARCHAR2(50) := 'WSH_DOCUMENT_SETS';
39: --
40: PROCEDURE Print_Document_Sets
41: (p_report_set_id IN NUMBER,
42: p_organization_id IN NUMBER,
42: p_organization_id IN NUMBER,
43: p_trip_ids IN WSH_UTIL_CORE.Id_Tab_Type,
44: p_stop_ids IN WSH_UTIL_CORE.Id_Tab_Type,
45: p_delivery_ids IN WSH_UTIL_CORE.Id_Tab_Type,
46: p_document_param_info IN WSH_DOCUMENT_SETS.DOCUMENT_SET_TAB_TYPE,
47: x_return_status IN OUT NOCOPY VARCHAR2)
48: IS
49:
50: --
235: AND a.application_id = f.application_id
236: AND f.enabled_flag = 'Y'
237: ORDER BY rs.program_sequence;
238:
239: l_doc_set_params wsh_document_sets.document_set_tab_type;
240:
241: CURSOR c_document_params(i NUMBER) IS
242: SELECT
243: decode(
420: l_delv_trip_id_tmp NUMBER :=0;
421:
422: --bug 1633386
423:
424: l_lang_doc_params_info WSH_DOCUMENT_SETS.document_set_rec_type;
425: l_nls_lang WSH_EXTREPS_MLS_LANG.lang_tab_type;
426: l_submitted BOOLEAN;
427: l_nls_count NUMBER;
428:
1763: END IF;
1764: --
1765: END print_document_sets;
1766:
1767: END WSH_DOCUMENT_SETS;
1768: