DBA Data[Home] [Help]

APPS.OE_HOLDS_PUB dependencies on OE_SYS_PARAMETERS

Line 1747: --7832836 l_cascade_hold_non_smc VARCHAR2(1) := NVL(OE_SYS_PARAMETERS.VALUE('ONT_CASCADE_HOLD_NONSMC_PTO'),'N'); --ER#7479609

1743: where top_model_line_id = l_top_model_line_id;
1744: --
1745: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1746: --
1747: --7832836 l_cascade_hold_non_smc VARCHAR2(1) := NVL(OE_SYS_PARAMETERS.VALUE('ONT_CASCADE_HOLD_NONSMC_PTO'),'N'); --ER#7479609
1748: l_cascade_hold_non_smc VARCHAR2(1); -- 7832836
1749: l_org_id NUMBER; -- 7832836
1750: BEGIN
1751: IF l_debug_level > 0 THEN

Line 1813: l_cascade_hold_non_smc := NVL(OE_SYS_PARAMETERS.VALUE('ONT_CASCADE_HOLD_NONSMC_PTO',l_org_id),'N');

1809: x_result_out := FND_API.G_FALSE;
1810: END;
1811: END IF;
1812:
1813: l_cascade_hold_non_smc := NVL(OE_SYS_PARAMETERS.VALUE('ONT_CASCADE_HOLD_NONSMC_PTO',l_org_id),'N');
1814: --7832836 end
1815:
1816: /*
1817: ** Checking for HEADER level generic holds and activity specific holds