1 PACKAGE WSH_BOLS_PVT AS
2 -- $Header: WSHBLTHS.pls 120.0 2005/05/26 18:48:58 appldev noship $
3
4 PROCEDURE update_Row
5 ( p_api_version IN NUMBER
6 , p_init_msg_list IN VARCHAR2
7 , p_commit IN VARCHAR2
8 , p_validation_level IN NUMBER
9 , x_return_status OUT NOCOPY VARCHAR2
10 , x_msg_count OUT NOCOPY NUMBER
11 , x_msg_data OUT NOCOPY VARCHAR2
12 , p_entity_name IN VARCHAR2
13 , x_entity_id IN OUT NOCOPY NUMBER
14 , p_document_type IN VARCHAR2
15 /* Commented for shipping datamodel changes bug#1918342
16 , p_pod_flag IN VARCHAR2
17 , p_pod_by IN VARCHAR2
18 , p_pod_date IN DATE
19 , p_reason_of_transport IN VARCHAR2
20 , p_description IN VARCHAR2
21 , p_cod_amount IN NUMBER
22 , p_cod_currency_code IN VARCHAR2
23 , p_cod_remit_to IN VARCHAR2
24 , p_cod_charge_paid_by IN VARCHAR2
25 , p_problem_contact_reference IN VARCHAR2
26 , p_bill_freight_to IN VARCHAR2
27 , p_carried_by IN VARCHAR2
28 , p_port_of_loading IN VARCHAR2
29 , p_port_of_discharge IN VARCHAR2
30 , p_booking_office IN VARCHAR2
31 , p_booking_number IN VARCHAR2
32 , p_service_contract IN VARCHAR2
33 , p_shipper_export_ref IN VARCHAR2
34 , p_carrier_export_ref IN VARCHAR2
35 , p_bol_notify_party IN VARCHAR2
36 , p_supplier_code IN VARCHAR2
37 , p_aetc_number IN VARCHAR2
38 , p_shipper_signed_by IN VARCHAR2
39 , p_shipper_date IN DATE
40 , p_carrier_signed_by IN VARCHAR2
41 , p_carrier_date IN DATE
42 , p_bol_issue_office IN VARCHAR2
43 , p_bol_issued_by IN VARCHAR2
44 , p_bol_date_issued IN DATE
45 , p_shipper_hm_by IN VARCHAR2
46 , p_shipper_hm_date IN DATE
47 , p_carrier_hm_by IN VARCHAR2
48 , p_carrier_hm_date IN DATE
49 , p_ledger_id IN NUMBER */ -- LE Uptake
50 , p_consolidate_option IN VARCHAR2
51 , x_trip_id IN OUT NOCOPY NUMBER
52 , x_trip_name IN OUT NOCOPY VARCHAR2
53 , p_pick_up_location_id IN NUMBER
54 , p_drop_off_location_id IN NUMBER
55 , p_carrier_id IN NUMBER
56 , p_ship_method IN VARCHAR2
57 , p_delivery_id IN NUMBER
58 , x_document_number IN OUT NOCOPY VARCHAR2
59 );
60
61
62
63 PROCEDURE insert_row
64 (x_return_status IN OUT NOCOPY VARCHAR2,
65 x_msg_count IN OUT NOCOPY VARCHAR2,
66 x_msg_data IN OUT NOCOPY VARCHAR2,
67 p_entity_name IN VARCHAR2,
68 x_entity_id IN OUT NOCOPY NUMBER,
69 p_application_id IN NUMBER,
70 p_location_id IN NUMBER,
71 p_document_type IN VARCHAR2,
72 p_document_sub_type IN VARCHAR2,
73 /* Commented for shipping Data model changes bug#1918342
74 p_pod_flag IN VARCHAR2,
75 p_pod_by IN VARCHAR2,
76 p_pod_date IN DATE,
77 p_reason_of_transport IN VARCHAR2,
78 p_description IN VARCHAR2,
79 p_cod_amount IN NUMBER,
80 p_cod_currency_code IN VARCHAR2,
81 p_cod_remit_to IN VARCHAR2,
82 p_cod_charge_paid_by IN VARCHAR2,
83 p_problem_contact_reference IN VARCHAR2,
84 p_bill_freight_to IN VARCHAR2,
85 p_carried_by IN VARCHAR2,
86 p_port_of_loading IN VARCHAR2,
87 p_port_of_discharge IN VARCHAR2,
88 p_booking_office IN VARCHAR2,
89 p_booking_number IN VARCHAR2,
90 p_service_contract IN VARCHAR2,
91 p_shipper_export_ref IN VARCHAR2,
92 p_carrier_export_ref IN VARCHAR2,
93 p_bol_notify_party IN VARCHAR2,
94 p_supplier_code IN VARCHAR2,
95 p_aetc_number IN VARCHAR2,
96 p_shipper_signed_by IN VARCHAR2,
97 p_shipper_date IN DATE,
98 p_carrier_signed_by IN VARCHAR2,
99 p_carrier_date IN DATE,
100 p_bol_issue_office IN VARCHAR2,
101 p_bol_issued_by IN VARCHAR2,
102 p_bol_date_issued IN DATE,
103 p_shipper_hm_by IN VARCHAR2,
104 p_shipper_hm_date IN DATE,
105 p_carrier_hm_by IN VARCHAR2,
106 p_carrier_hm_date IN DATE,
107 p_ledger_id IN NUMBER, */ -- LE Uptake
108 x_document_number IN OUT NOCOPY VARCHAR2,
109 x_trip_id IN OUT NOCOPY NUMBER,
110 x_trip_name IN OUT NOCOPY VARCHAR2,
111 x_delivery_id IN OUT NOCOPY NUMBER,
112 p_pick_up_location_id IN NUMBER,
113 p_drop_off_location_id IN NUMBER,
114 p_carrier_id IN NUMBER);
115
116
117 PROCEDURE delete_row
118 ( p_api_version IN NUMBER
119 , p_init_msg_list IN VARCHAR2
120 , p_commit IN VARCHAR2
121 , p_validation_level IN NUMBER
122 , x_return_status OUT NOCOPY VARCHAR2
123 , x_msg_count OUT NOCOPY NUMBER
124 , x_msg_data OUT NOCOPY VARCHAR2
125 , p_entity_id IN NUMBER
126 , p_document_type IN VARCHAR2
127 , p_document_number IN VARCHAR2
128 );
129 PROCEDURE cancel_bol
130 ( p_trip_id IN NUMBER
131 ,p_old_ship_method_code IN VARCHAR2
132 ,p_new_ship_method_code IN VARCHAR2
133 , x_return_status OUT NOCOPY VARCHAR2
134 );
135
136
137 END WSH_BOLS_PVT;