eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.QP_SOURCING_API_PUB dependencies on QP_ATTR_MAPPING_PUB

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

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

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

198: */
199:
200: END Get_Sales_Channel;
201:
202: 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
203: IS
204:
205: x_site_use_info QP_Attr_Mapping_PUB.t_MultiRecord;
206:

Line 205: x_site_use_info QP_Attr_Mapping_PUB.t_MultiRecord;

201:
202: 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
203: IS
204:
205: x_site_use_info QP_Attr_Mapping_PUB.t_MultiRecord;
206:
207: BEGIN
208:
209: IF p_ship_to_org_id is not null THEN

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

225: RETURN x_site_use_info;
226:
227: END Get_Site_Use;
228:
229: FUNCTION Get_Item_Category (p_inventory_item_id IN NUMBER) RETURN QP_Attr_Mapping_PUB.t_MultiRecord
230: IS
231: x_category_ids QP_Attr_Mapping_PUB.t_MultiRecord;
232: BEGIN
233: -- Exploded Category Ids to be picked in case on PLM and Sales n marketing.

Line 231: x_category_ids QP_Attr_Mapping_PUB.t_MultiRecord;

227: END Get_Site_Use;
228:
229: FUNCTION Get_Item_Category (p_inventory_item_id IN NUMBER) RETURN QP_Attr_Mapping_PUB.t_MultiRecord
230: IS
231: x_category_ids QP_Attr_Mapping_PUB.t_MultiRecord;
232: BEGIN
233: -- Exploded Category Ids to be picked in case on PLM and Sales n marketing.
234: x_category_ids := QP_CATEGORY_MAPPING_RULE.Get_Item_category(p_inventory_item_id);
235: RETURN(x_category_ids);

Line 242: QP_Attr_Mapping_PUB.t_MultiRecord

238:
239: /* Added Sourcing API Get_Agreement_Revisions for Bug 2293711*/
240: FUNCTION Get_Agreement_Revisions (p_agreement_id IN NUMBER) RETURN
241:
242: QP_Attr_Mapping_PUB.t_MultiRecord
243: IS
244:
245: --TYPE t_cursor IS REF CURSOR;
246:

Line 247: x_agreement_ids QP_Attr_Mapping_PUB.t_MultiRecord;

243: IS
244:
245: --TYPE t_cursor IS REF CURSOR;
246:
247: x_agreement_ids QP_Attr_Mapping_PUB.t_MultiRecord;
248: l_agreement_id VARCHAR2(30);
249: v_count NUMBER := 1;
250: --l_agreement_cursor t_cursor;
251: l_name varchar2(240);

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

525:
526: END Get_Order_Amount;
527:
528:
529: FUNCTION Get_Account_Type (p_cust_id IN NUMBER) RETURN QP_Attr_Mapping_PUB.t_MultiRecord
530: IS
531:
532: BEGIN
533:

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

604: END IF;
605:
606: END Get_Model_Id;
607:
608: FUNCTION Get_Customer_Relationship (p_cust_id IN NUMBER) RETURN QP_Attr_Mapping_PUB.t_MultiRecord
609: IS
610:
611: BEGIN
612:

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

1651: INTO G_Customer_Info.gsa_indicator
1652: FROM hz_cust_site_uses hsu
1653: WHERE site_use_id = invoice_to_org_id
1654: --added for moac
1655: and hsu.org_id = QP_ATTR_MAPPING_PUB.G_ORG_ID;
1656: /*
1657: AND NVL(hsu.org_id,
1658: NVL(TO_NUMBER(DECODE(SUBSTRB(USERENV('CLIENT_INFO'),1 ,1), ' ',NULL,
1659: SUBSTRB(USERENV('CLIENT_INFO'), 1,10))),-99)) =