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