[Home] [Help]
571: v_wljdi_cum_yield t_wljdi_cum_yield := t_wljdi_cum_yield();
572: v_wljdi_rev_cum_yield t_wljdi_rev_cum_yield := t_wljdi_rev_cum_yield();
573:
574: type t_res_recom is table of varchar2(5) index by binary_integer;
575: type t_res_code is table of bom_resources.resource_code%type index by binary_integer;
576:
577: /* end */
578: /* ST : Detailed scheduling : end */
579:
1799: begin
1800: l_stmt_num := 40.2;
1801: select unique(resource_id)
1802: into v_wljdi_resource_id_new(l_d)
1803: from bom_resources
1804: where resource_code = v_wljdi_resource_code_new(l_d)
1805: and organization_id = p_org_id
1806: and cost_code_type in (3,4);
1807: exception
1816: elsif v_wljdi_resource_code_new(l_d) IS NULL then
1817: begin /* unique why...? ..... */
1818: select unique(resource_code)
1819: into v_wljdi_resource_code_new(l_d)
1820: from bom_resources
1821: where resource_id = v_wljdi_resource_id_new(l_d)
1822: and organization_id = p_org_id
1823: and cost_code_type in (3,4);
1824:
2419: begin
2420: l_stmt_num := 70.2;
2421: select unique(resource_id)
2422: into l_resource_id
2423: from bom_resources
2424: where resource_code = v_wljdi_resource_code_new(l_d)
2425: and organization_id = p_org_id;
2426: exception
2427: when others then
3424: l_xst := 0;
3425:
3426: select br.batchable
3427: into l_xst
3428: from bom_resources br
3429: where resource_id = l_resource_id;
3430:
3431: if l_xst <> 1 then
3432: /* error out... */
3625: l_stmt_num := 140;
3626:
3627: select br.batchable
3628: into l_xst
3629: from bom_resources br
3630: where resource_id = l_resource_id;
3631:
3632: if l_xst <> 1 then
3633: /* error out... */
3849: l_res_autocharge_type,
3850: l_res_standard_rate_flag,
3851: l_res_batchable,
3852: l_res_code
3853: from bom_resources
3854: where resource_id=l_resource_id
3855: and organization_id=p_org_id
3856: and nvl(disable_date,sysdate+1) > sysdate;
3857: exception
13542: p_new_res_tbl(l_index).basis_type,
13543: l_uom_class,
13544: l_batchable,
13545: p_new_res_tbl(l_index).standard_rate_flag
13546: from bom_resources BR,
13547: mtl_units_of_measure_vl uom
13548: where br.resource_id = p_new_res_tbl(l_index).resource_id
13549: and autocharge_type = nvl(p_new_res_tbl(l_index).autocharge_type,autocharge_type)
13550: and nvl(p_new_res_tbl(l_index).uom_code,br.unit_of_measure) = br.unit_of_measure -- uom.uom_code
13670: begin
13671:
13672: select nvl(p_new_res_tbl(l_index).dept_id,wo.department_id)
13673: into p_new_res_tbl(l_index).dept_id
13674: from bom_resources br,bom_department_resources bdr, wip_operations wo
13675: where br.resource_id = p_new_res_tbl(l_index).resource_id
13676: and br.resource_code = p_new_res_tbl(l_index).resource_code
13677: and (br.disable_date > sysdate or br.disable_date is null)
13678: and br.organization_id = p_org_id
13737: begin
13738:
13739: select nvl(p_new_res_tbl(l_index).dept_id,wco.department_id)
13740: into p_new_res_tbl(l_index).dept_id
13741: from bom_resources br,bom_department_resources bdr, wsm_copy_operations wco
13742: where br.resource_id = p_new_res_tbl(l_index).resource_id
13743: and br.resource_code = p_new_res_tbl(l_index).resource_code
13744: and (br.disable_date > sysdate or br.disable_date is null)
13745: and br.organization_id = p_org_id
16058: bsor.attribute14,
16059: bsor.attribute15,
16060: null
16061: from wsm_copy_operations wco,
16062: bom_resources br,
16063: bom_std_op_resources bsor
16064: where bsor.standard_operation_id = v_wljdi_std_op_id(l_d)
16065: and br.resource_id = bsor.resource_id
16066: and nvl(br.disable_date, SYSDATE + 1) > SYSDATE
16189: bsor.attribute14,
16190: bsor.attribute15,
16191: null
16192: from wsm_copy_operations wco,
16193: bom_resources br,
16194: bom_std_sub_op_resources bsor,
16195: wsm_copy_op_resources wcor
16196: where bsor.standard_operation_id = v_wljdi_std_op_id(l_d)
16197: and br.resource_id = bsor.resource_id