[Home] [Help]
PACKAGE: APPS.WSH_DOCUMENT_PUB
Source
1 PACKAGE WSH_Document_PUB AUTHID CURRENT_USER AS
2 -- $Header: WSHPPACS.pls 115.6 2002/11/18 20:29:21 nparikh ship $
3
4 --------------------
5 -- TYPE DECLARATIONS
6 --------------------
7
8 TYPE document_rectype IS RECORD
9 ( document_instance_id wsh_document_instances.document_instance_id%type
10 , document_type wsh_document_instances.document_type%type
11 , entity_name wsh_document_instances.entity_name%type
12 , entity_id wsh_document_instances.entity_id%type
13 , doc_sequence_category_id
14 wsh_document_instances.doc_sequence_category_id%type
15 , sequence_number wsh_document_instances.sequence_number%type
16 , status wsh_document_instances.status%type
17 , final_print_date wsh_document_instances.final_print_date%type
18 /* Commented for Shipping Data Model Changes Bug#1918342
19 , pod_flag wsh_document_instances.pod_flag%type
20 , pod_by wsh_document_instances.pod_by%type
21 , pod_date wsh_document_instances.pod_date%type
22 , reason_of_transport wsh_document_instances.reason_of_transport%type
23 , description wsh_document_instances.description%type
24 , cod_amount wsh_document_instances.cod_amount%type
25 , cod_currency_code wsh_document_instances.cod_currency_code%type
26 , cod_remit_to wsh_document_instances.cod_remit_to%type
27 , cod_charge_paid_by wsh_document_instances.cod_charge_paid_by%type
28 , problem_contact_reference
29 wsh_document_instances.problem_contact_reference%type
30 , bill_freight_to wsh_document_instances.bill_freight_to%type
31 , carried_by wsh_document_instances.carried_by%type
32 , port_of_loading wsh_document_instances.port_of_loading%type
33 , port_of_discharge wsh_document_instances.port_of_discharge%type
34 , booking_office wsh_document_instances.booking_office%type
35 , booking_number wsh_document_instances.booking_number%type
36 , service_contract wsh_document_instances.service_contract%type
37 , shipper_export_ref wsh_document_instances.shipper_export_ref%type
38 , carrier_export_ref wsh_document_instances.carrier_export_ref%type
39 , bol_notify_party wsh_document_instances.bol_notify_party%type
40 , supplier_code wsh_document_instances.supplier_code%type
41 , aetc_number wsh_document_instances.aetc_number%type
42 , shipper_signed_by wsh_document_instances.shipper_signed_by%type
43 , shipper_date wsh_document_instances.shipper_date%type
44 , carrier_signed_by wsh_document_instances.carrier_signed_by%type
45 , carrier_date wsh_document_instances.carrier_date%type
46 , bol_issue_office wsh_document_instances.bol_issue_office%type
47 , bol_issued_by wsh_document_instances.bol_issued_by%type
48 , bol_date_issued wsh_document_instances.bol_date_issued%type
49 , shipper_hm_by wsh_document_instances.shipper_hm_by%type
50 , shipper_hm_date wsh_document_instances.shipper_hm_date%type
51 , carrier_hm_by wsh_document_instances.carrier_hm_by%type
52 , carrier_hm_date wsh_document_instances.carrier_hm_date%type*/
53 , created_by wsh_document_instances.created_by%type
54 , creation_date wsh_document_instances.creation_date%type
55 , last_updated_by wsh_document_instances.last_updated_by%type
56 , last_update_date wsh_document_instances.last_update_date%type
57 , last_update_login wsh_document_instances.last_update_login%type
58 , program_application_id wsh_document_instances.program_application_id%type
59 , program_id wsh_document_instances.program_id%type
60 , program_update_date wsh_document_instances.program_update_date%type
61 , request_id wsh_document_instances.request_id%type
62 , attribute_category wsh_document_instances.attribute_category%type
63 , attribute1 wsh_document_instances.attribute1%type
64 , attribute2 wsh_document_instances.attribute2%type
65 , attribute3 wsh_document_instances.attribute3%type
66 , attribute4 wsh_document_instances.attribute4%type
67 , attribute5 wsh_document_instances.attribute5%type
68 , attribute6 wsh_document_instances.attribute6%type
69 , attribute7 wsh_document_instances.attribute7%type
70 , attribute8 wsh_document_instances.attribute8%type
71 , attribute9 wsh_document_instances.attribute9%type
72 , attribute10 wsh_document_instances.attribute10%type
73 , attribute11 wsh_document_instances.attribute11%type
74 , attribute12 wsh_document_instances.attribute12%type
75 , attribute13 wsh_document_instances.attribute13%type
76 , attribute14 wsh_document_instances.attribute14%type
77 , attribute15 wsh_document_instances.attribute15%type
78 );
79
80 TYPE document_tabtype IS TABLE of document_rectype;
81
82 ------------
83 -- CONSTANTS
84 ------------
85
86 -------------------
87 -- PUBLIC VARIABLES
88 -------------------
89
90 ---------------------------
91 -- PROCEDURES AND FUNCTIONS
92 ---------------------------
93
94 ------------------------------------------------------------------------------
95 -- PROCEDURE : Get_Document PUBLIC
96 -- VERSION : 1.0
97 -- COMMENT : Returns as an out-param a record containing all attributes
98 -- of the the currently open document of the specified type
99 -- ( packing slip, bill of lading, etc.) for a OE order line.
100 --
101 -- PARAMETER LIST :
102 --
103 -- IN
104 --
105 -- p_api_version known API version
106 -- p_init_msg_list should API reset message stack (default: false)
107 -- p_commit should API do a commit (default: false)
108 -- p_validation_level extent of validation done in the API (not used)
109 -- p_order_line_id OE order line id for which doc info is needed
110 -- p_document_type type codes (PACK_TYPE, BOL, ASN, etc.)
111
112 -- OUT
113 --
114 -- x_msg_count number of messages in stack
115 -- x_msg_data message if there is only one message in stack
116 -- x_return_status API return status ('S', 'E', 'U')
117 -- x_document_rec record that contains all attributes of the doc
118 --
119 -- PRE-CONDITIONS : There should be only one open document of a specific
120 -- type for a delivery. If more than one open doc is
121 -- available the API returns the first available one.
122 -- POST-CONDITIONS : None
123 -- EXCEPTIONS : None
124 ------------------------------------------------------------------------------
125
126 PROCEDURE Get_Document
127 ( p_api_version IN NUMBER
128 , p_init_msg_list IN VARCHAR2 DEFAULT FND_API.g_false
129 , p_commit IN VARCHAR2 DEFAULT FND_API.g_false
130 , p_validation_level IN NUMBER DEFAULT FND_API.g_valid_level_full
131 , x_return_status OUT NOCOPY VARCHAR2
132 , x_msg_count OUT NOCOPY NUMBER
133 , x_msg_data OUT NOCOPY VARCHAR2
134 , p_order_line_id IN NUMBER
135 , p_document_type IN VARCHAR2
136 , x_document_rec OUT NOCOPY document_rectype
137 );
138
139 END WSH_Document_PUB;