1 PACKAGE QP_SOURCING_API_PUB AS
2 /* $Header: QPXPSAPS.pls 120.0 2005/06/02 00:47:05 appldev noship $ */
3
4 TYPE Customer_Info_Rec_Type IS RECORD
5 ( customer_id NUMBER
6 , customer_class_code VARCHAR2(240)
7 , sales_channel_code VARCHAR2(240)
8 , gsa_indicator VARCHAR2(1)
9 , account_types QP_Attr_Mapping_PUB.t_MultiRecord
10 , customer_relationships QP_Attr_Mapping_PUB.t_MultiRecord
11 );
12
13 TYPE Order_Info_Rec_Type IS RECORD
14 ( header_id NUMBER,
15 order_amount VARCHAR2(240),
16 order_quantity VARCHAR2(240),
17 order_total varchar2(240),
18 period1_total_amount varchar2(240),
19 period2_total_amount varchar2(240),
20 period3_total_amount varchar2(240),
21 shippable_flag varchar2(1)
22 );
23
24 TYPE Site_Use_Rec_Type IS RECORD
25 ( contact_id VARCHAR2(240)
26 , site_use_id VARCHAR2(240)
27 );
28
29 TYPE Agreement_Info_Rec_Type IS RECORD
30 ( agreement_id VARCHAR2(240)
31 , agreement_type_code VARCHAR2(240)
32 );
33
34 TYPE Item_Segments_Rec_Type IS RECORD
35 ( inventory_item_id NUMBER
36 , segment1 VARCHAR2(240)
37 , segment2 VARCHAR2(240)
38 , segment3 VARCHAR2(240)
39 , segment4 VARCHAR2(240)
40 , segment5 VARCHAR2(240)
41 , segment6 VARCHAR2(240)
42 , segment7 VARCHAR2(240)
43 , segment8 VARCHAR2(240)
44 , segment9 VARCHAR2(240)
45 , segment10 VARCHAR2(240)
46 , segment11 VARCHAR2(240)
47 , segment12 VARCHAR2(240)
48 , segment13 VARCHAR2(240)
49 , segment14 VARCHAR2(240)
50 , segment15 VARCHAR2(240)
51 , segment16 VARCHAR2(240)
52 , segment17 VARCHAR2(240)
53 , segment18 VARCHAR2(240)
54 , segment19 VARCHAR2(240)
55 , segment20 VARCHAR2(240)
56 );
57
58 PROCEDURE Get_Customer_Info (p_cust_id NUMBER);
59
60 FUNCTION Get_Customer_Item_Id (p_item_type VARCHAR2, p_ordered_item_id NUMBER) RETURN NUMBER;
61
62 FUNCTION Get_Sales_Channel (p_cust_id IN NUMBER) RETURN VARCHAR2;
63
64 FUNCTION Get_Site_Use (p_invoice_to_org_id IN NUMBER, p_ship_to_org_id IN NUMBER) RETURN QP_Attr_Mapping_PUB.t_MultiRecord;
65
66 FUNCTION Get_Item_Category (p_inventory_item_id IN NUMBER)
67 RETURN QP_Attr_Mapping_PUB.t_MultiRecord;
68
69 FUNCTION Get_Item_Segment(p_inventory_item_id IN NUMBER, p_seg_num NUMBER) RETURN VARCHAR2;
70
71 FUNCTION Get_Customer_Class(p_cust_id IN NUMBER) RETURN VARCHAR2;
72
73 PROCEDURE Get_Order_AMT_and_QTY (p_header_id IN NUMBER);
74
75 FUNCTION Get_Order_Amount(p_header_id IN NUMBER) RETURN VARCHAR2;
76
77 FUNCTION Get_Order_Qty (p_header_id IN NUMBER) RETURN VARCHAR2;
78
79 FUNCTION Get_Account_Type (p_cust_id IN NUMBER) RETURN QP_Attr_Mapping_PUB.t_MultiRecord;
80
81 FUNCTION Get_Agreement_Type (p_agreement_id IN VARCHAR2) RETURN VARCHAR2;
82
83 FUNCTION Get_Customer_Relationship (p_cust_id IN NUMBER) RETURN QP_Attr_Mapping_PUB.t_MultiRecord;
84
85 FUNCTION Get_Period1_Item_Quantity(p_cust_id IN NUMBER, p_inventory_item_id IN NUMBER, p_ordered_uom IN VARCHAR2)RETURN VARCHAR2;
86
87 FUNCTION Get_Period1_Item_Quantity(p_cust_id IN NUMBER, p_inventory_item_id IN NUMBER)RETURN VARCHAR2;
88
89 FUNCTION Get_Period2_Item_Quantity(p_cust_id IN NUMBER, p_inventory_item_id IN NUMBER, p_ordered_uom IN VARCHAR2) RETURN VARCHAR2;
90
91 FUNCTION Get_Period2_Item_Quantity(p_cust_id IN NUMBER, p_inventory_item_id IN NUMBER)RETURN VARCHAR2;
92
93 FUNCTION Get_Period3_Item_Quantity(p_cust_id IN NUMBER, p_inventory_item_id IN NUMBER, p_ordered_uom IN VARCHAR2) RETURN VARCHAR2;
94
95 FUNCTION Get_Period3_Item_Quantity(p_cust_id IN NUMBER, p_inventory_item_id IN NUMBER)RETURN VARCHAR2;
96
97 FUNCTION Get_Period1_Item_Amount(p_cust_id IN NUMBER, p_inventory_item_id IN NUMBER, p_currency_code IN VARCHAR2, p_conversion_rate_date IN DATE, p_pricing_date IN DATE, p_conversion_rate IN NUMBER, p_conversion_type_code IN VARCHAR2) RETURN VARCHAR2;
98
99 FUNCTION Get_Period1_Item_Amount(p_cust_id IN NUMBER, p_inventory_item_id IN NUMBER) RETURN VARCHAR2;
100
101 FUNCTION Get_Period2_Item_Amount(p_cust_id IN NUMBER, p_inventory_item_id IN NUMBER, p_currency_code IN VARCHAR2, p_conversion_rate_date IN DATE, p_pricing_date IN DATE, p_conversion_rate IN NUMBER, p_conversion_type_code IN VARCHAR2) RETURN VARCHAR2;
102
103 FUNCTION Get_Period2_Item_Amount(p_cust_id IN NUMBER, p_inventory_item_id IN NUMBER) RETURN VARCHAR2;
104
105 FUNCTION Get_Period3_Item_Amount(p_cust_id IN NUMBER, p_inventory_item_id IN NUMBER, p_currency_code IN VARCHAR2, p_conversion_rate_date IN DATE, p_pricing_date IN DATE, p_conversion_rate IN NUMBER, p_conversion_type_code IN VARCHAR2) RETURN VARCHAR2;
106
107 FUNCTION Get_Period3_Item_Amount(p_cust_id IN NUMBER, p_inventory_item_id IN NUMBER) RETURN VARCHAR2;
108
109 FUNCTION Get_Period1_Order_Amount(p_cust_id IN NUMBER, p_currency_code IN VARCHAR2, p_conversion_rate_date IN DATE, p_pricing_date IN DATE, p_conversion_rate IN NUMBER, p_conversion_type_code IN VARCHAR2) RETURN VARCHAR2;
110
111 FUNCTION Get_Period1_Order_Amount(p_cust_id IN NUMBER) RETURN VARCHAR2;
112
113 FUNCTION Get_Period2_Order_Amount(p_cust_id IN NUMBER, p_currency_code IN VARCHAR2, p_conversion_rate_date IN DATE, p_pricing_date IN DATE, p_conversion_rate IN NUMBER, p_conversion_type_code IN VARCHAR2) RETURN VARCHAR2;
114
115 FUNCTION Get_Period2_Order_Amount(p_cust_id IN NUMBER) RETURN VARCHAR2;
116
117 FUNCTION Get_Period3_Order_Amount(p_cust_id IN NUMBER, p_currency_code IN VARCHAR2,p_conversion_rate_date IN DATE, p_pricing_date IN DATE, p_conversion_rate IN NUMBER, p_conversion_type_code IN VARCHAR2) RETURN VARCHAR2;
118
119 FUNCTION Get_Period3_Order_Amount(p_cust_id IN NUMBER) RETURN VARCHAR2;
120
121 FUNCTION Get_GSA (p_cust_id NUMBER) RETURN VARCHAR2;
122
123 FUNCTION GET_PARTY_ID (p_sold_to_org_id IN NUMBER) RETURN NUMBER;
124
125 FUNCTION GET_SHIP_TO_PARTY_SITE_ID(p_ship_to_org_id IN NUMBER) RETURN NUMBER;
126
127 FUNCTION GET_INVOICE_TO_PARTY_SITE_ID(p_invoice_to_org_id IN NUMBER) RETURN NUMBER;
128
129 FUNCTION GET_MODEL_ID(p_top_model_line_id IN NUMBER) RETURN NUMBER;
130
131 FUNCTION GET_SHIPPABLE_FLAG(p_header_id IN NUMBER) RETURN VARCHAR2;
132
133 FUNCTION Get_Line_Weight_Or_Volume
134 ( p_uom_class IN VARCHAR2,
135 p_inventory_item_id IN NUMBER,
136 p_ordered_quantity IN NUMBER,
137 p_order_quantity_uom IN VARCHAR2
138 )
139 RETURN VARCHAR2;
140
141 FUNCTION Get_Order_Weight_Or_Volume
142 ( p_uom_class IN VARCHAR2,
143 p_header_id IN NUMBER
144 )
145 RETURN VARCHAR2;
146
147 FUNCTION Get_Item_Quantity
148 ( p_ordered_qty IN NUMBER,
149 p_pricing_qty IN NUMBER
150 )
151 RETURN VARCHAR2;
152
153 FUNCTION Get_Item_Amount
154 ( p_ordered_qty IN NUMBER,
155 p_pricing_qty IN NUMBER
156 )
157 RETURN VARCHAR2;
158
159 /* Added for 2293711 */
160 FUNCTION Get_Agreement_Revisions (p_agreement_id IN Number)
161 RETURN QP_Attr_Mapping_PUB.t_MultiRecord;
162
163 G_Customer_Info Customer_Info_Rec_Type;
164 G_Order_Info Order_Info_Rec_Type;
165 G_Site_Use Site_Use_Rec_Type;
166 G_Agreement_Info Agreement_Info_Rec_Type;
167 G_Item_Segments Item_Segments_Rec_Type;
168 G_TOP_MODEL_LINE_ID NUMBER;
169 G_MODEL_ID NUMBER;
170
171 FUNCTION Get_Item_Amount
172 ( p_ordered_qty IN NUMBER,
173 p_pricing_qty IN NUMBER,
174 p_UNIT_LIST_PRICE_PER_PQTY IN NUMBER,
175 p_unit_list_price IN NUMBER
176 )
177 RETURN VARCHAR2;
178
179 Procedure Get_Customer_Info(p_cust_id NUMBER, invoice_to_org_id NUMBER);
180
181
182 END QP_SOURCING_API_PUB;