[Home] [Help]
PACKAGE: APPS.ASO_SHIPMENT_PVT
Source
1 PACKAGE ASO_SHIPMENT_PVT AUTHID CURRENT_USER as
2 /* $Header: asovshps.pls 120.1 2005/06/29 12:45:09 appldev ship $ */
3 -- Start of Comments
4 --
5 -- NAME
6 -- ASO_SHIPMENT_PVT
7 --
8 -- PURPOSE
9
10
11 -- *******************************************************
12 -- Start of Comments
13 -- *******************************************************
14 -- API Name: Delete_Shipment
15 -- Type : Private
16 -- Pre-Req :
17 -- Parameters:
18 -- IN
19 -- p_api_version_number IN NUMBER Required
20 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
21 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
22 --
23 -- OUT:
24 -- x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
25 -- x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
26 -- x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
27 -- Version : Current version 1.0
28
29 -- End of Comments
30 --
31
32 PROCEDURE Delete_shipment(
33 P_Api_Version_Number IN NUMBER,
34 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
35 P_Commit IN VARCHAR2 := FND_API.G_FALSE,
36 p_qte_line_rec IN aso_quote_pub.qte_line_rec_type
37 := ASO_QUOTE_PUB.G_MISS_QTE_LINE_REC,
38 p_shipment_rec IN aso_quote_pub.shipment_rec_type,
39 X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
40 X_Msg_Count OUT NOCOPY /* file.sql.39 change */ NUMBER,
41 X_Msg_Data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
42 );
43
44 FUNCTION Get_Ship_To_site_Id (
45 p_qte_header_id NUMBER,
46 p_qte_line_id NUMBER,
47 p_shipment_id NUMBER) RETURN NUMBER;
48 FUNCTION Get_Ship_To_party_site_Id (
49 p_qte_header_id NUMBER,
50 p_qte_line_id NUMBER,
51 p_shipment_id NUMBER) RETURN NUMBER;
52
53 FUNCTION Get_invoice_to_party_site_id ( p_qte_header_id NUMBER,
54 p_qte_line_id NUMBER
55 ) RETURN NUMBER;
56
57 FUNCTION Get_cust_to_party_site_id (
58 p_qte_header_id NUMBER,
59 p_qte_line_id NUMBER
60 ) RETURN NUMBER;
61
62 /*FUNCTION Get_cust_acct_id (
63 p_qte_header_id NUMBER,
64 p_qte_line_id NUMBER,
65 p_shipment_id NUMBER) RETURN NUMBER;
66 */
67
68
69 FUNCTION Get_party_name (
70 p_party_id NUMBER,
71 p_party_type VARCHAR2
72 ) RETURN VARCHAR2;
73 FUNCTION Get_party_first_name (
74 p_party_id NUMBER,
75 p_party_type VARCHAR2
76 ) RETURN VARCHAR2;
77 FUNCTION Get_party_mid_name (
78 p_party_id NUMBER,
79 p_party_type VARCHAR2
80 ) RETURN VARCHAR2;
81 FUNCTION Get_party_last_name (
82 p_party_id NUMBER,
83 p_party_type VARCHAR2
84 ) RETURN VARCHAR2;
85
86 FUNCTION Get_ship_from_org_id (
87 p_qte_header_id NUMBER,
88 p_qte_line_id NUMBER
89 ) RETURN NUMBER;
90
91 FUNCTION Get_ship_method_code(p_qte_header_id NUMBER, p_qte_line_id NUMBER) RETURN VARCHAR2;
92
93 FUNCTION Get_demand_class_code(p_qte_header_id NUMBER, p_qte_line_id NUMBER) RETURN VARCHAR2;
94
95 FUNCTION Get_ship_to_party_site_id(p_qte_header_id NUMBER, p_qte_line_id NUMBER) RETURN NUMBER;
96
97 FUNCTION Get_ship_to_cust_account_id(p_qte_header_id NUMBER, p_qte_line_id NUMBER) RETURN NUMBER;
98
99
100 END ASO_SHIPMENT_PVT;
101
102
103