DBA Data[Home] [Help]

APPS.PO_COMMUNICATION_PVT dependencies on FINANCIALS_SYSTEM_PARAMETERS

Line 8241: Returns the Inventory Org Id stored in FINANCIALS_SYSTEM_PARAMETERS.

8237:
8238: --
8239: --Bug 4673653 START
8240: /*********************************************************************************
8241: Returns the Inventory Org Id stored in FINANCIALS_SYSTEM_PARAMETERS.
8242:
8243: We do not store this value in a global variable, as it would not change even when the
8244: inventory org is changed. See bug 4431545 for more info.
8245: **********************************************************************************/

Line 8248: l_inventory_org_id FINANCIALS_SYSTEM_PARAMETERS.INVENTORY_ORGANIZATION_ID%type;

8244: inventory org is changed. See bug 4431545 for more info.
8245: **********************************************************************************/
8246: FUNCTION getInventoryOrgId return NUMBER
8247: IS
8248: l_inventory_org_id FINANCIALS_SYSTEM_PARAMETERS.INVENTORY_ORGANIZATION_ID%type;
8249: BEGIN
8250: BEGIN
8251: SELECT INVENTORY_ORGANIZATION_ID
8252: INTO l_inventory_org_id

Line 8253: FROM FINANCIALS_SYSTEM_PARAMETERS;

8249: BEGIN
8250: BEGIN
8251: SELECT INVENTORY_ORGANIZATION_ID
8252: INTO l_inventory_org_id
8253: FROM FINANCIALS_SYSTEM_PARAMETERS;
8254: EXCEPTION
8255: WHEN OTHERS THEN
8256: IF (PO_LOG.d_exc) THEN
8257: PO_LOG.exc('PO_COMMUNICATION_PVT.getInventoryOrgId', 0, SQLCODE || SQLERRM);