DBA Data[Home] [Help]

APPS.OKC_PRICE_PUB dependencies on QP_ATTR_MAPPING_PUB

Line 51: , account_types QP_Attr_Mapping_PUB.t_MultiRecord

47: ( customer_id NUMBER
48: , customer_class_code VARCHAR2(240)
49: , sales_channel_code VARCHAR2(240)
50: , gsa_indicator VARCHAR2(1)
51: , account_types QP_Attr_Mapping_PUB.t_MultiRecord
52: , customer_relationships QP_Attr_Mapping_PUB.t_MultiRecord
53: );
54:
55: TYPE Order_Info_Rec_Type IS RECORD

Line 52: , customer_relationships QP_Attr_Mapping_PUB.t_MultiRecord

48: , customer_class_code VARCHAR2(240)
49: , sales_channel_code VARCHAR2(240)
50: , gsa_indicator VARCHAR2(1)
51: , account_types QP_Attr_Mapping_PUB.t_MultiRecord
52: , customer_relationships QP_Attr_Mapping_PUB.t_MultiRecord
53: );
54:
55: TYPE Order_Info_Rec_Type IS RECORD
56: ( header_id NUMBER

Line 442: ) RETURN QP_Attr_Mapping_PUB.t_MultiRecord;

438: FUNCTION Get_Item_Category
439: (
440: P_inventory_item_id IN NUMBER,
441: P_org_id IN NUMBER
442: ) RETURN QP_Attr_Mapping_PUB.t_MultiRecord;
443:
444: FUNCTION Get_Customer_Class(p_cust_id IN NUMBER) RETURN VARCHAR2;
445:
446: FUNCTION Get_Account_Type (p_cust_id IN NUMBER) RETURN QP_Attr_Mapping_PUB.t_MultiRecord;

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

442: ) RETURN QP_Attr_Mapping_PUB.t_MultiRecord;
443:
444: FUNCTION Get_Customer_Class(p_cust_id IN NUMBER) RETURN VARCHAR2;
445:
446: FUNCTION Get_Account_Type (p_cust_id IN NUMBER) RETURN QP_Attr_Mapping_PUB.t_MultiRecord;
447:
448: FUNCTION Get_Sales_Channel (p_cust_id IN NUMBER) RETURN VARCHAR2;
449:
450: FUNCTION Get_GSA (p_cust_id NUMBER) RETURN VARCHAR2;

Line 461: FUNCTION Get_Site_Use (p_rul_tbl IN GLOBAL_RPRLE_TBL_TYPE) RETURN QP_Attr_Mapping_PUB.t_MultiRecord;

457: ) RETURN VARCHAR2;
458: ---> Add New parameter(P_org_id IN NUMBER)
459: --added by smhanda
460: --pass global rule tbl here
461: FUNCTION Get_Site_Use (p_rul_tbl IN GLOBAL_RPRLE_TBL_TYPE) RETURN QP_Attr_Mapping_PUB.t_MultiRecord;
462: --not used anymore take get_invoice-- out later
463: FUNCTION GET_INVOICE_TO_ORG_ID (p_rul_tbl IN GLOBAL_RPRLE_TBL_TYPE,p_rle_tbl IN GLOBAL_RPRLE_TBL_TYPE) RETURN NUMBER;
464:
465: FUNCTION GET_PARTY_ID (p_sold_to_org_id IN NUMBER) RETURN NUMBER ;