APPS.QP_SOURCING_API_PUB dependencies on QP_ATTR_MAPPING_PUB

Line 60: and hsu.org_id = QP_ATTR_MAPPING_PUB.G_ORG_ID;

56: INTO G_Customer_Info.gsa_indicator
57: FROM hz_cust_site_uses hsu
58: WHERE site_use_id = OE_ORDER_PUB.G_HDR.invoice_to_org_id
59: --added for moac
60: and hsu.org_id = QP_ATTR_MAPPING_PUB.G_ORG_ID;
61: /*
62: AND NVL(hsu.org_id,
63: NVL(TO_NUMBER(DECODE(SUBSTRB(USERENV('CLIENT_INFO'),1 ,1), ' ',NULL,
64: SUBSTRB(USERENV('CLIENT_INFO'), 1,10))),-99)) =

Line 210: 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

206: */
207:
208: END Get_Sales_Channel;
209:
210: 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
211: IS
212:
213: x_site_use_info QP_Attr_Mapping_PUB.t_MultiRecord;
214:

Line 213: x_site_use_info QP_Attr_Mapping_PUB.t_MultiRecord;

209:
210: 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
211: IS
212:
213: x_site_use_info QP_Attr_Mapping_PUB.t_MultiRecord;
214:
215: BEGIN
216:
217: IF p_ship_to_org_id is not null THEN

Line 237: FUNCTION Get_Item_Category (p_inventory_item_id IN NUMBER) RETURN QP_Attr_Mapping_PUB.t_MultiRecord

233: RETURN x_site_use_info;
234:
235: END Get_Site_Use;
236:
237: FUNCTION Get_Item_Category (p_inventory_item_id IN NUMBER) RETURN QP_Attr_Mapping_PUB.t_MultiRecord
238: IS
239: x_category_ids QP_Attr_Mapping_PUB.t_MultiRecord;
240: BEGIN
241: -- Exploded Category Ids to be picked in case on PLM and Sales n marketing.

Line 239: x_category_ids QP_Attr_Mapping_PUB.t_MultiRecord;

235: END Get_Site_Use;
236:
237: FUNCTION Get_Item_Category (p_inventory_item_id IN NUMBER) RETURN QP_Attr_Mapping_PUB.t_MultiRecord
238: IS
239: x_category_ids QP_Attr_Mapping_PUB.t_MultiRecord;
240: BEGIN
241: -- Exploded Category Ids to be picked in case on PLM and Sales n marketing.
242: x_category_ids := QP_CATEGORY_MAPPING_RULE.Get_Item_category(p_inventory_item_id);
243: RETURN(x_category_ids);

Line 250: QP_Attr_Mapping_PUB.t_MultiRecord

246:
247: /* Added Sourcing API Get_Agreement_Revisions for Bug 2293711*/
248: FUNCTION Get_Agreement_Revisions (p_agreement_id IN NUMBER) RETURN
249:
250: QP_Attr_Mapping_PUB.t_MultiRecord
251: IS
252:
253: --TYPE t_cursor IS REF CURSOR;
254:

Line 255: x_agreement_ids QP_Attr_Mapping_PUB.t_MultiRecord;

251: IS
252:
253: --TYPE t_cursor IS REF CURSOR;
254:
255: x_agreement_ids QP_Attr_Mapping_PUB.t_MultiRecord;
256: l_agreement_id VARCHAR2(30);
257: v_count NUMBER := 1;
258: --l_agreement_cursor t_cursor;
259: l_name varchar2(240);

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

533:
534: END Get_Order_Amount;
535:
536:
537: FUNCTION Get_Account_Type (p_cust_id IN NUMBER) RETURN QP_Attr_Mapping_PUB.t_MultiRecord
538: IS
539:
540: BEGIN
541:

Line 616: FUNCTION Get_Customer_Relationship (p_cust_id IN NUMBER) RETURN QP_Attr_Mapping_PUB.t_MultiRecord

612: END IF;
613:
614: END Get_Model_Id;
615:
616: FUNCTION Get_Customer_Relationship (p_cust_id IN NUMBER) RETURN QP_Attr_Mapping_PUB.t_MultiRecord
617: IS
618:
619: BEGIN
620:

Line 1663: and hsu.org_id = QP_ATTR_MAPPING_PUB.G_ORG_ID;

1659: INTO G_Customer_Info.gsa_indicator
1660: FROM hz_cust_site_uses hsu
1661: WHERE site_use_id = invoice_to_org_id
1662: --added for moac
1663: and hsu.org_id = QP_ATTR_MAPPING_PUB.G_ORG_ID;
1664: /*
1665: AND NVL(hsu.org_id,
1666: NVL(TO_NUMBER(DECODE(SUBSTRB(USERENV('CLIENT_INFO'),1 ,1), ' ',NULL,
1667: SUBSTRB(USERENV('CLIENT_INFO'), 1,10))),-99)) =