265: OPEN c_retreive_org_name( p_csp_inv_loc_assignment_id );
266: FETCH c_retreive_org_name INTO r_retreive_org_name;
267: IF NOT c_retreive_org_name%NOTFOUND THEN
268:
269: IF CSL_CSP_SEC_INV_ACC_PKG.Insert_CSP_Sec_Inventory(
270: p_resource_id
271: ,r_retreive_org_name.subinventory_code
272: ,r_retreive_org_name.organization_id) THEN
273:
338: OPEN c_retreive_org_name( p_csp_inv_loc_assignment_id);
339: FETCH c_retreive_org_name INTO r_retreive_org_name;
340: IF c_retreive_org_name%FOUND THEN
341:
342: l_return_value := CSL_CSP_SEC_INV_ACC_PKG.Delete_CSP_Sec_Inventory(
343: p_resource_id
344: ,r_retreive_org_name.subinventory_code
345: ,r_retreive_org_name.organization_id);
346:
601: /*** Update ! ***/
602: OPEN c_retreive_org_name( l_csp_inv_loc_assignment );
603: FETCH c_retreive_org_name INTO r_retreive_org_name;
604: IF NOT c_retreive_org_name%NOTFOUND THEN
605: CSL_CSP_SEC_INV_ACC_PKG.Update_CSP_Sec_Inventory(
606: l_resource_id ,
607: r_retreive_org_name.subinventory_code ,
608: r_retreive_org_name.organization_id);
609: