[Home] [Help]
PACKAGE: APPS.WSH_ECE_VIEWS_DEF
Source
1 PACKAGE WSH_ECE_VIEWS_DEF AUTHID CURRENT_USER AS
2 /* $Header: WSHECVWS.pls 115.12 2003/04/17 04:06:09 rvishnuv ship $ */
3 function get_cont_area_code(contact_id_in NUMBER) RETURN VARCHAR2;
4 function get_cont_phone_number RETURN VARCHAR2;
5
6 function get_cust_area_code(customer_id_in NUMBER) return VARCHAR2;
7 function get_cust_phone_number RETURN VARCHAR2;
8
9 procedure get_invoice_number(p_delivery_id IN NUMBER,
10 x_invoice_number OUT NOCOPY NUMBER) ;
11
12 procedure get_vehicle_type_code(p_vehicle_org_id IN NUMBER,
13 p_vehicle_item_id IN NUMBER,
14 x_vehicle_type_code OUT NOCOPY VARCHAR2 ) ;
15
16 function get_cust_payment_term(p_payment_term_id NUMBER ) return VARCHAR2;
17
18 procedure get_cross_reference(X_INVENTORY_ITEM_ID IN NUMBER,
19 X_ORGANIZATION_ID IN NUMBER,
20 X_CROSS_REFERENCE OUT NOCOPY VARCHAR2);
21
22 procedure update_del_asn_info(X_DELIVERY_ID IN NUMBER,
23 X_TIME_STAMP_SEQUENCE_NUMBER IN OUT NOCOPY NUMBER,
24 X_TIME_STAMP_DATE IN OUT NOCOPY DATE,
25 X_G_TIME_STAMP_SEQUENCE_NUMBER IN OUT NOCOPY NUMBER,
26 X_G_TIME_STAMP_DATE IN OUT NOCOPY DATE);
27
28 procedure get_location_code(p_location_id IN NUMBER,
29 x_location_code OUT NOCOPY VARCHAR2 );
30
31 cont_phone_number_x VARCHAR2(25);
32 cust_phone_number_x VARCHAR2(25);
33
34 procedure get_location_info (
35 p_location_id IN NUMBER,
36 x_location OUT NOCOPY VARCHAR2,
37 x_edi_loc_code OUT NOCOPY VARCHAR2,
38 x_tp_ref_ext1 OUT NOCOPY VARCHAR2,
39 x_tp_ref_ext2 OUT NOCOPY VARCHAR2,
40 x_customer_name OUT NOCOPY VARCHAR2,
41 x_address1 OUT NOCOPY VARCHAR2,
42 x_address2 OUT NOCOPY VARCHAR2,
43 x_address3 OUT NOCOPY VARCHAR2,
44 x_address4 OUT NOCOPY VARCHAR2,
45 x_city OUT NOCOPY VARCHAR2,
46 x_state OUT NOCOPY VARCHAR2,
47 x_postal_code OUT NOCOPY VARCHAR2,
48 x_country OUT NOCOPY VARCHAR2,
49 x_province OUT NOCOPY VARCHAR2,
50 x_county OUT NOCOPY VARCHAR2,
51 x_address_id OUT NOCOPY NUMBER,
52 x_area_code OUT NOCOPY VARCHAR2,
53 x_phone_number OUT NOCOPY VARCHAR2);
54
55 procedure get_dlvy_location_info (
56 p_intmed_ship_to_location_id IN NUMBER,
57 p_pooled_ship_to_location_id IN NUMBER,
58 x_ist_location OUT NOCOPY VARCHAR2,
59 x_ist_edi_loc_code OUT NOCOPY VARCHAR2,
60 x_ist_tp_ref_ext1 OUT NOCOPY VARCHAR2,
61 x_ist_tp_ref_ext2 OUT NOCOPY VARCHAR2,
62 x_ist_customer_name OUT NOCOPY VARCHAR2,
63 x_ist_address1 OUT NOCOPY VARCHAR2,
64 x_ist_address2 OUT NOCOPY VARCHAR2,
65 x_ist_address3 OUT NOCOPY VARCHAR2,
66 x_ist_address4 OUT NOCOPY VARCHAR2,
67 x_ist_city OUT NOCOPY VARCHAR2,
68 x_ist_state OUT NOCOPY VARCHAR2,
69 x_ist_postal_code OUT NOCOPY VARCHAR2,
70 x_ist_country OUT NOCOPY VARCHAR2,
71 x_ist_province OUT NOCOPY VARCHAR2,
72 x_ist_county OUT NOCOPY VARCHAR2,
73 x_ist_address_id OUT NOCOPY NUMBER,
74 x_ist_area_code OUT NOCOPY VARCHAR2,
75 x_ist_phone_number OUT NOCOPY VARCHAR2,
76 x_pst_location OUT NOCOPY VARCHAR2,
77 x_pst_edi_loc_code OUT NOCOPY VARCHAR2,
78 x_pst_tp_ref_ext1 OUT NOCOPY VARCHAR2,
79 x_pst_tp_ref_ext2 OUT NOCOPY VARCHAR2,
80 x_pst_customer_name OUT NOCOPY VARCHAR2,
81 x_pst_address1 OUT NOCOPY VARCHAR2,
82 x_pst_address2 OUT NOCOPY VARCHAR2,
83 x_pst_address3 OUT NOCOPY VARCHAR2,
84 x_pst_address4 OUT NOCOPY VARCHAR2,
85 x_pst_city OUT NOCOPY VARCHAR2,
86 x_pst_state OUT NOCOPY VARCHAR2,
87 x_pst_postal_code OUT NOCOPY VARCHAR2,
88 x_pst_country OUT NOCOPY VARCHAR2,
89 x_pst_province OUT NOCOPY VARCHAR2,
90 x_pst_county OUT NOCOPY VARCHAR2,
91 x_pst_address_id OUT NOCOPY NUMBER,
92 x_pst_area_code OUT NOCOPY VARCHAR2,
93 x_pst_phone_number OUT NOCOPY VARCHAR2 );
94
95 procedure get_dlvy_dest_cont_info (
96 p_contact_id IN NUMBER,
97 x_dest_cont_last_name OUT NOCOPY VARCHAR2,
98 x_dest_cont_first_name OUT NOCOPY VARCHAR2,
99 x_cont_job_title OUT NOCOPY VARCHAR2 );
100
101 END WSH_ECE_VIEWS_DEF;