DBA Data[Home] [Help]

APPS.QP_SOURCING_API_PUB dependencies on QP_ATTR_MAPPING_PUB

Line 9: , account_types QP_Attr_Mapping_PUB.t_MultiRecord

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

Line 10: , customer_relationships QP_Attr_Mapping_PUB.t_MultiRecord

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,

Line 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;

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:

Line 67: RETURN QP_Attr_Mapping_PUB.t_MultiRecord;

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;

Line 79: FUNCTION Get_Account_Type (p_cust_id IN NUMBER) RETURN QP_Attr_Mapping_PUB.t_MultiRecord;

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;

Line 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;

Line 161: RETURN QP_Attr_Mapping_PUB.t_MultiRecord;

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;