344:
345: stmt_num :=4;
346: -- Convert the Derived columns to User friendly columns
347:
348: l_return_status := Bom_Open_Interface_Utl.Process_Header_Info
349: (org_id,all_org,user_id,login_id,
350: prog_appid,prog_id,req_id,err_text,p_batch_id);
351: IF (l_return_status <> 0) THEN
352: RETURN(l_return_status);
350: prog_appid,prog_id,req_id,err_text,p_batch_id);
351: IF (l_return_status <> 0) THEN
352: RETURN(l_return_status);
353: END IF;
354: l_return_status := Bom_Open_Interface_Utl.Process_Comps_Info
355: (org_id,all_org,user_id,login_id,
356: prog_appid,prog_id,req_id,err_text,p_batch_id);
357: IF (l_return_status <> 0) THEN
358: RETURN(l_return_status);
356: prog_appid,prog_id,req_id,err_text,p_batch_id);
357: IF (l_return_status <> 0) THEN
358: RETURN(l_return_status);
359: END IF;
360: l_return_status := Bom_Open_Interface_Utl.Process_Ref_Degs_Info
361: (org_id,all_org,user_id,login_id,
362: prog_appid,prog_id,req_id,err_text,p_batch_id);
363: IF (l_return_status <> 0) THEN
364: RETURN(l_return_status);
362: prog_appid,prog_id,req_id,err_text,p_batch_id);
363: IF (l_return_status <> 0) THEN
364: RETURN(l_return_status);
365: END IF;
366: l_return_status := Bom_Open_Interface_Utl.Process_Sub_Comps_Info
367: (org_id,all_org,user_id,login_id,
368: prog_appid,prog_id,req_id,err_text,p_batch_id);
369: IF (l_return_status <> 0) THEN
370: RETURN(l_return_status);
368: prog_appid,prog_id,req_id,err_text,p_batch_id);
369: IF (l_return_status <> 0) THEN
370: RETURN(l_return_status);
371: END IF;
372: l_return_status := Bom_Open_Interface_Utl.Process_Comp_Ops_Info
373: (org_id,all_org,user_id,login_id,
374: prog_appid,prog_id,req_id,err_text,p_batch_id);
375: IF (l_return_status <> 0) THEN
376: RETURN(l_return_status);
374: prog_appid,prog_id,req_id,err_text,p_batch_id);
375: IF (l_return_status <> 0) THEN
376: RETURN(l_return_status);
377: END IF;
378: l_return_status := Bom_Open_Interface_Utl.Process_Revision_Info
379: (org_id,all_org,user_id,login_id,
380: prog_appid,prog_id,req_id,err_text,p_batch_id);
381: IF (l_return_status <> 0) THEN
382: RETURN(l_return_status);