APPS.WSM_LBJ_INTERFACE_PVT dependencies on BOM_RESOURCE_SETUPS

Line 3350: Check if there exists any record in bom_resource_setups

3346: /* ST : Detailed Scheduling : Place the validations here.....
3347: Firm_type Default: Null
3348: Setup_id Default : Null.
3349:
3350: Check if there exists any record in bom_resource_setups
3351: for the setup_id and resource_id.If Setup Id is not null,
3352: assigned units and Max Assigned units should be 1.
3353:
3354: Batch Id Default: Null

Line 3412: from bom_resource_setups brs

3408: l_xst := 0;
3409:
3410: select 1
3411: into l_xst
3412: from bom_resource_setups brs
3413: where brs.resource_id = l_resource_id
3414: and brs.organization_id = p_org_id
3415: and brs.setup_id = l_setup_id;
3416:

Line 3545: Check if there exists any record in bom_resource_setups

3541: /* ST : Detailed Scheduling : Place the validations here.....
3542: Firm_type Default: Null
3543: Setup_id Default : Null.
3544:
3545: Check if there exists any record in bom_resource_setups
3546: for the setup_id and resource_id.If Setup Id is not null,
3547: assigned units and Max Assigned units should be 1.
3548:
3549: Batch Id Default: Null

Line 3612: from bom_resource_setups brs

3608: l_xst := 0;
3609:
3610: select 1
3611: into l_xst
3612: from bom_resource_setups brs
3613: where brs.resource_id = l_resource_id
3614: and brs.organization_id = p_org_id
3615: and brs.setup_id = l_setup_id;
3616:

Line 13927: from bom_resource_setups brs

13923: BEGIN
13924:
13925: select 1
13926: into l_dummy
13927: from bom_resource_setups brs
13928: where brs.resource_id = p_new_res_tbl(l_index).resource_id
13929: and brs.organization_id = p_org_id
13930: and brs.setup_id = p_new_res_tbl(l_index).setup_id;
13931: