DBA Data[Home] [Help]

APPS.ARP_AUTO_ACCOUNTING dependencies on OE_PROFILE

Line 792: debug( ' org_id='||oe_profile.value('SO_ORGANIZATION_ID',arp_global.sysparam.org_id),

788: MSG_LEVEL_DEBUG );
789:
790: /*Bug 8640674*/
791: IF(arp_global.sysparam.org_id IS NOT NULL) THEN
792: debug( ' org_id='||oe_profile.value('SO_ORGANIZATION_ID',arp_global.sysparam.org_id),
793: MSG_LEVEL_DEBUG );
794: END IF;
795:
796: -- flex info

Line 1463: to_number(oe_profile.value('SO_ORGANIZATION_ID',arp_global.sysparam.org_id)));

1459:
1460: p_ccid_rev := -1;
1461: p_inv_item_type := NULL;
1462: t_warehouse_id := nvl(p_warehouse_id,
1463: to_number(oe_profile.value('SO_ORGANIZATION_ID',arp_global.sysparam.org_id)));
1464: BEGIN
1465: --
1466: -- see if available in cache
1467: --

Line 1663: to_number(oe_profile.value('SO_ORGANIZATION_ID',arp_global.sysparam.org_id))) --Bug#1639334

1659: AND t.agreement_id = a.agreement_id(+)
1660: AND l.inventory_item_id = i.inventory_item_id(+)
1661: AND i.organization_id(+)
1662: = nvl(p_warehouse_id,
1663: to_number(oe_profile.value('SO_ORGANIZATION_ID',arp_global.sysparam.org_id))) --Bug#1639334
1664: AND i.category_set_id(+) = 1
1665: AND to_char(nvl(i.category_id, -1)) = c.value1
1666: AND nvl(a.agreement_type_code, -1) = nvl(c.value2 , -1);
1667:

Line 7327: debug( 'ORG_ID='||oe_profile.value('SO_ORGANIZATION_ID',arp_global.sysparam.org_id)||

7323: get_inv_item_ccids(profile_info,
7324: p_inv_item_id,
7325: '',
7326: l_ccid_rev, l_inv_item_type );
7327: debug( 'ORG_ID='||oe_profile.value('SO_ORGANIZATION_ID',arp_global.sysparam.org_id)||
7328: ' INV_ITEM_ID='||to_char(p_inv_item_id)||
7329: ' rev:'||to_char(l_ccid_rev) );
7330: end if;
7331: