APPS.WSM_LBJ_INTERFACE_PVT dependencies on BOM_RESOURCE_SETUPS

Line 3345: Check if there exists any record in bom_resource_setups

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

Line 3407: from bom_resource_setups brs

3403: l_xst := 0;
3404:
3405: select 1
3406: into l_xst
3407: from bom_resource_setups brs
3408: where brs.resource_id = l_resource_id
3409: and brs.organization_id = p_org_id
3410: and brs.setup_id = l_setup_id;
3411:

Line 3540: Check if there exists any record in bom_resource_setups

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

Line 3607: from bom_resource_setups brs

3603: l_xst := 0;
3604:
3605: select 1
3606: into l_xst
3607: from bom_resource_setups brs
3608: where brs.resource_id = l_resource_id
3609: and brs.organization_id = p_org_id
3610: and brs.setup_id = l_setup_id;
3611:

Line 13823: from bom_resource_setups brs

13819: BEGIN
13820:
13821: select 1
13822: into l_dummy
13823: from bom_resource_setups brs
13824: where brs.resource_id = p_new_res_tbl(l_index).resource_id
13825: and brs.organization_id = p_org_id
13826: and brs.setup_id = p_new_res_tbl(l_index).setup_id;
13827: