232:
233: orp_ref_rec get_orphan_ref_desg%ROWTYPE;
234:
235: cursor get_sub_comps (cp_ass_item_name varchar2, cp_org_code varchar2, cp_alt_des varchar2) is
236: select * from bom_sub_comps_interface
237: where process_flag = 1
238: and (all_org = 1 or (all_org = 2 and organization_id = org_id))
239: and assembly_item_number = cp_ass_item_name
240: and organization_code = cp_org_code
251:
252: sub_rec get_sub_comps%ROWTYPE;
253:
254: cursor get_orphan_sub_comps is
255: SELECT * FROM BOM_SUB_COMPS_INTERFACE
256: where process_flag = 1
257: and (all_org = 1 or (all_org = 2 and organization_id = org_id))
258: and transaction_id is not null
259: and change_notice is null --added for bug 9447664
968: l_process_flag := 3;
969: l_ret_status := 1;
970: end if;
971:
972: Update BOM_SUB_COMPS_INTERFACE
973: set process_flag = l_process_flag,
974: REQUEST_ID = Fnd_Global.Conc_Request_Id,
975: PROGRAM_ID = Fnd_Global.Conc_program_Id,
976: PROGRAM_APPLICATION_ID = Fnd_Global.prog_appl_id,
1077: end loop;
1078:
1079: stmt_num := 5;
1080: loop
1081: DELETE FROM BOM_SUB_COMPS_INTERFACE
1082: WHERE PROCESS_FLAG = 7
1083: AND
1084: (
1085: ( (p_batch_id IS NULL) AND (BATCH_ID IS NULL) )