PACKAGE: APPS.ASO_SOURCING_PVT

Source

1 PACKAGE ASO_SOURCING_PVT AUTHID CURRENT_USER as
2 /* $Header: asovsrcs.pls 115.8 2003/05/09 22:10:26 smadapus ship $ */
3 -- Start of Comments
4 -- Package name     : ASO_SOURCING_PVT
5 -- Purpose          :
6 -- History          :
7 -- NOTE             :
8 -- End of Comments
9 
10 FUNCTION Get_Customer_Class
11 (p_cust_account_id IN NUMBER)
12 RETURN VARCHAR2;
13 
14 FUNCTION Get_Account_Type
15 (p_cust_account_id IN NUMBER)
16 RETURN QP_Attr_Mapping_PUB.t_MultiRecord;
17 
18 FUNCTION Get_Sales_Channel
19 (p_cust_account_id IN NUMBER)
20 RETURN VARCHAR2;
21 
22 FUNCTION Get_GSA
23 (p_cust_account_id NUMBER)
24 RETURN VARCHAR2;
25 
26 FUNCTION Get_quote_Qty
27 (p_qte_header_id IN NUMBER)
28 RETURN VARCHAR2;
29 
30 FUNCTION Get_quote_Amount(p_qte_header_id IN NUMBER)
31 RETURN VARCHAR2;
32 
33 FUNCTION Get_shippable_flag(p_qte_line_id NUMBER)
34 RETURN VARCHAR2;
35 
36 FUNCTION Get_Cust_Acct (p_quote_header_id NUMBER)
37 RETURN NUMBER;
38 
39 FUNCTION Get_Ship_to_Site_Use (p_quote_header_id NUMBER)
40 RETURN NUMBER;
41 
42 FUNCTION Get_Line_Ship_to_Site_Use (p_quote_line_id NUMBER)
43 RETURN NUMBER;
44 
45 FUNCTION Get_Invoice_to_Site_Use (p_quote_header_id NUMBER)
46 RETURN NUMBER;
47 
48 FUNCTION Get_Line_Invoice_Site_Use (p_quote_line_id NUMBER)
49 RETURN NUMBER;
50 
51 FUNCTION Get_Ship_to_Party_Site (p_quote_header_id NUMBER)
52 RETURN NUMBER;
53 
54 FUNCTION Get_Line_Ship_Party_Site (p_quote_line_id NUMBER)
55 RETURN NUMBER;
56 
57 FUNCTION Get_Invoice_to_Party_Site (p_quote_header_id NUMBER)
58 RETURN NUMBER;
59 
60 FUNCTION Get_Line_Invoice_Party_Site (p_quote_line_id NUMBER)
61 RETURN NUMBER;
62 
63 --FUNCTION Get_Party_Id (p_quote_header_id NUMBER)
64 --RETURN NUMBER;
65 
66 
67 
68 FUNCTION Get_Cust_Po(
69 p_qte_header_id 	number
70 ) RETURN  VARCHAR2;
71 
72 FUNCTION Get_line_Cust_Po(
73 p_qte_line_id       number
74 ) RETURN  VARCHAR2;
75 
76 FUNCTION Get_Request_date(
77 p_qte_header_id 	number
78 ) RETURN  DATE;
79 
80 FUNCTION Get_line_Request_date(
81 p_qte_line_id 	number
82 ) RETURN  DATE;
83 
84 FUNCTION Get_Freight_term(
85 p_qte_header_id 	number
86 	) RETURN  DATE;
87 
88 FUNCTION Get_line_Freight_term(
89 p_qte_line_id    number
90 ) RETURN  VARCHAR2;
91 
92 FUNCTION Get_Payment_term(
93 p_qte_header_id 	number
94 ) RETURN  NUMBER;
95 
96 FUNCTION Get_line_Payment_term(
97 p_qte_line_id    number,p_qte_header_id number
98 ) RETURN  NUMBER;
99 
100 
101 FUNCTION Get_top_model_item_id(
102 p_qte_line_id    number
103 ) RETURN  NUMBER;
104 
105 
106 FUNCTION Get_freight_terms_code(
107 p_qte_line_id    number
108 ) RETURN  VARCHAR2;
109 
110 
111 FUNCTION Get_shipping_method_code(
112 p_qte_line_id    number
113 ) RETURN  VARCHAR2;
114 
115 FUNCTION Get_header_ship_flag(p_qte_header_id NUMBER)
116 RETURN VARCHAR2;
117 
118 FUNCTION Get_Parent_List_price (p_quote_line_id NUMBER)
119 RETURN NUMBER;
120 
121 FUNCTION Get_Minisite_Id RETURN NUMBER;
122 
123 End ASO_SOURCING_PVT;