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
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,
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:
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;
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;
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;
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;