1194: is
1195:
1196: v_t_sourcing_info CTO_MSUTIL_PUB.sourcing_info;
1197: v_buy_traversed boolean := false ;
1198: v_source_type mrp_sources_v.source_type%type ;
1199: l_make_buy_code mtl_system_items.planning_make_buy_code%type ;
1200:
1201: l_curr_src_org mrp_sources_v.source_organization_id%type ;
1202: l_source_type mrp_sources_v.source_type%type ;
1197: v_buy_traversed boolean := false ;
1198: v_source_type mrp_sources_v.source_type%type ;
1199: l_make_buy_code mtl_system_items.planning_make_buy_code%type ;
1200:
1201: l_curr_src_org mrp_sources_v.source_organization_id%type ;
1202: l_source_type mrp_sources_v.source_type%type ;
1203: l_curr_assg_type mrp_sources_v.assignment_type%type ;
1204: l_curr_rank mrp_sources_v.rank%type ;
1205: v_sourcing_rule_exists varchar2(10) ;
1198: v_source_type mrp_sources_v.source_type%type ;
1199: l_make_buy_code mtl_system_items.planning_make_buy_code%type ;
1200:
1201: l_curr_src_org mrp_sources_v.source_organization_id%type ;
1202: l_source_type mrp_sources_v.source_type%type ;
1203: l_curr_assg_type mrp_sources_v.assignment_type%type ;
1204: l_curr_rank mrp_sources_v.rank%type ;
1205: v_sourcing_rule_exists varchar2(10) ;
1206:
1199: l_make_buy_code mtl_system_items.planning_make_buy_code%type ;
1200:
1201: l_curr_src_org mrp_sources_v.source_organization_id%type ;
1202: l_source_type mrp_sources_v.source_type%type ;
1203: l_curr_assg_type mrp_sources_v.assignment_type%type ;
1204: l_curr_rank mrp_sources_v.rank%type ;
1205: v_sourcing_rule_exists varchar2(10) ;
1206:
1207:
1200:
1201: l_curr_src_org mrp_sources_v.source_organization_id%type ;
1202: l_source_type mrp_sources_v.source_type%type ;
1203: l_curr_assg_type mrp_sources_v.assignment_type%type ;
1204: l_curr_rank mrp_sources_v.rank%type ;
1205: v_sourcing_rule_exists varchar2(10) ;
1206:
1207:
1208: x_exp_error_code NUMBER ;