DBA Data[Home] [Help]

APPS.INV_VALIDATE_TROLIN dependencies on PJM_UNIT_EFF

Line 474: if( nvl(PJM_UNIT_EFF.ENABLED, 'N') = 'Y' ) then

470: --
471: -- inv_debug.message('TRO: dependency conditions');
472: -- validate unit number is the unit number is not null
473: IF (p_trolin_Rec.unit_number is NOT NULL) then
474: if( nvl(PJM_UNIT_EFF.ENABLED, 'N') = 'Y' ) then
475: if( PJM_UNIT_EFF.UNIT_EFFECTIVE_ITEM(p_trolin_rec.inventory_item_id,
476: p_trolin_rec.organization_id) = 'Y') then
477: begin
478: select 1

Line 475: if( PJM_UNIT_EFF.UNIT_EFFECTIVE_ITEM(p_trolin_rec.inventory_item_id,

471: -- inv_debug.message('TRO: dependency conditions');
472: -- validate unit number is the unit number is not null
473: IF (p_trolin_Rec.unit_number is NOT NULL) then
474: if( nvl(PJM_UNIT_EFF.ENABLED, 'N') = 'Y' ) then
475: if( PJM_UNIT_EFF.UNIT_EFFECTIVE_ITEM(p_trolin_rec.inventory_item_id,
476: p_trolin_rec.organization_id) = 'Y') then
477: begin
478: select 1
479: into l_dummy