DBA Data[Home] [Help]

APPS.PO_COMMUNICATION_PVT dependencies on FINANCIALS_SYSTEM_PARAMETERS

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

7042:
7043: --
7044: --Bug 4673653 START
7045: /*********************************************************************************
7046: Returns the Inventory Org Id stored in FINANCIALS_SYSTEM_PARAMETERS.
7047:
7048: We do not store this value in a global variable, as it would not change even when the
7049: inventory org is changed. See bug 4431545 for more info.
7050: **********************************************************************************/

Line 7053: l_inventory_org_id FINANCIALS_SYSTEM_PARAMETERS.INVENTORY_ORGANIZATION_ID%type;

7049: inventory org is changed. See bug 4431545 for more info.
7050: **********************************************************************************/
7051: FUNCTION getInventoryOrgId return NUMBER
7052: IS
7053: l_inventory_org_id FINANCIALS_SYSTEM_PARAMETERS.INVENTORY_ORGANIZATION_ID%type;
7054: BEGIN
7055: BEGIN
7056: SELECT INVENTORY_ORGANIZATION_ID
7057: INTO l_inventory_org_id

Line 7058: FROM FINANCIALS_SYSTEM_PARAMETERS;

7054: BEGIN
7055: BEGIN
7056: SELECT INVENTORY_ORGANIZATION_ID
7057: INTO l_inventory_org_id
7058: FROM FINANCIALS_SYSTEM_PARAMETERS;
7059: EXCEPTION
7060: WHEN OTHERS THEN
7061: IF (PO_LOG.d_exc) THEN
7062: PO_LOG.exc('PO_COMMUNICATION_PVT.getInventoryOrgId', 0, SQLCODE || SQLERRM);