[Home] [Help]
133: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS,'GET_DEPOT_ORG_STR value of v_instance_id: '||to_char(p_instance_id));
134: lv_in_org_str := GET_ORG_STR (p_instance_id,2);
135:
136: lv_sql_stmt := ' Select organization_id, nvl(organization_type,1) '
137: ||' From msc_instance_orgs mio '
138: ||' Where sr_instance_id = '||p_instance_id|| ' and organization_id '||lv_in_org_str
139: ;
140:
141: lv_count:= 0;
999: lv_sql_str VARCHAR2(1000);
1000:
1001: cursor org IS
1002: select mio.organization_id org_id
1003: from msc_instance_orgs mio,
1004: msc_coll_parameters mcp
1005: where mio.sr_instance_id= p_instance_id
1006: and mcp.instance_id = p_instance_id
1007: and mio.enabled_flag= 1
1009: (mio.org_group=mcp.org_group));
1010:
1011: cursor all_org IS
1012: select organization_id org_id
1013: from msc_instance_orgs
1014: where sr_instance_id= p_instance_id
1015: and enabled_flag= 1;
1016:
1017: BEGIN
1049:
1050: BEGIN
1051: lv_sql_str:=' SELECT mp.organization_id org_id'
1052: ||' from mtl_parameters'||lv_dblink||' mp,'
1053: ||' msc_instance_orgs mio'
1054: ||' where mio.sr_instance_id= :p_instance_id'
1055: ||' and mio.enabled_flag= 1'
1056: ||' and mio.organization_id=mp.organization_id'
1057: ||' and mp.process_enabled_flag='||'''Y''';
3991: lv_unit_no_lrn,
3992: lv_uom_lrn,
3993: lv_calendar_lrn,
3994: lv_trip_lrn
3995: from msc_instance_orgs
3996: WHERE ((p_org_group =MSC_UTIL.G_ALL_ORGANIZATIONS) or (org_group=p_org_group))
3997: AND sr_instance_id = p_instance_id;
3998: /* Earlier sales order is alwasy collected in netchange even if sales order is not selected for continuous collection
3999: in srs */
4002: nvl(min(LAST_SUCC_IRO_REF_TIME), SYSDATE-365000)
4003: into
4004: lv_iro_lrn,
4005: g_last_succ_iro_ref_time
4006: from msc_instance_orgs
4007: WHERE organization_type = 3
4008: AND sr_instance_id = p_instance_id;
4009:
4010:
4010:
4011: select min(nvl(ERO_LRN,lv_apps_lrn))
4012: into
4013: lv_ero_lrn
4014: from msc_instance_orgs
4015: WHERE organization_type <> 3
4016: AND sr_instance_id = p_instance_id;
4017:
4018: IF (prec.sales_order_flag = MSC_UTIL.SYS_YES ) AND
4471: WHERE INSTANCE_ID= pINSTANCE_ID;
4472:
4473: --- PREPLACE CHANGE END ---
4474:
4475: UPDATE MSC_INSTANCE_ORGS
4476: SET ITEM_LRN = decode(prec.item_flag,1,pLRN,ITEM_LRN),
4477: SAF_STOCK_LRN = decode(prec.saf_stock_flag, 1, pLRN, SAF_STOCK_LRN),
4478: UNIT_NO_LRN = decode(prec.unit_number_flag,1,pLRN,UNIT_NO_LRN),
4479: UOM_LRN = decode(prec.uom_flag,1,pLRN,UOM_LRN),
4494: WHERE SR_INSTANCE_ID= pINSTANCE_ID
4495: AND (pORG_GROUP= MSC_UTIL.G_ALL_ORGANIZATIONS OR ORG_GROUP=pORG_GROUP);
4496:
4497: IF (prec.external_repair_flag = MSC_UTIL.SYS_YES AND MSC_UTIL.G_COLLECT_SRP_DATA = 'Y') THEN
4498: UPDATE MSC_INSTANCE_ORGS
4499: SET ERO_LRN = decode(prec.external_repair_flag ,1,pLRN,ERO_LRN )
4500: WHERE SR_INSTANCE_ID= pINSTANCE_ID
4501: AND organization_type <> 3;
4502: END IF;
4501: AND organization_type <> 3;
4502: END IF;
4503:
4504: IF (prec.internal_repair_flag = MSC_UTIL.SYS_YES AND MSC_UTIL.G_COLLECT_SRP_DATA = 'Y' ) THEN
4505: UPDATE MSC_INSTANCE_ORGS
4506: SET
4507: IRO_LRN = decode(prec.internal_repair_flag ,1,pLRN,IRO_LRN ),
4508: LAST_SUCC_IRO_REF_TIME = sysdate
4509: WHERE SR_INSTANCE_ID= pINSTANCE_ID
4510: AND organization_type = 3;
4511: END IF;
4512:
4513: IF ((prec.calendar_flag = MSC_UTIL.SYS_YES) OR (prec.resource_nra_flag in (1,3))) THEN
4514: UPDATE MSC_INSTANCE_ORGS
4515: SET CALENDAR_LRN= pLRN
4516: WHERE SR_INSTANCE_ID= pINSTANCE_ID
4517: AND (pORG_GROUP= MSC_UTIL.G_ALL_ORGANIZATIONS OR ORG_GROUP=pORG_GROUP);
4518: END IF;
4520: /* Sales orders are not collected during Targeted and Continious Refresh if Sales Orders = No, so we will not update SO_LRN in this case */
4521: IF ( (pRTYPE = MSC_UTIL.G_PARTIAL OR pRTYPE = MSC_UTIL.G_CONT) AND prec.sales_order_flag = MSC_UTIL.SYS_NO ) THEN
4522: NULL;
4523: ELSE
4524: UPDATE MSC_INSTANCE_ORGS
4525: SET SO_LRN= pLRN
4526: WHERE SR_INSTANCE_ID= pINSTANCE_ID
4527: AND (pORG_GROUP= MSC_UTIL.G_ALL_ORGANIZATIONS OR ORG_GROUP=pORG_GROUP);
4528: END IF;